MSDE access denied error

I set up MSDE that came with VS.NET and, using the Server Explorer, created a database called 'pubs' on my server. The MSSQLServer icon is lit up in the System Tray and has been started. When I created 'pubs', I was prompted whether I wanted to use NT Integrated Security or SQL Server Authentication. I was forced to choose the NT option because any login name that I used, including my administrator account, the 'aspnet_wp account', 'SQLDebugger' and 'sa'. Every time I tried to use the SQL Server Auth. option, I would get the following error prompt:

ADO Error: '
Login failed for user 'whateverItried'. Reason: Not associated with a trusted SQL Server connection.

When running the following:

Dim myConnection As SqlConnection = New SqlConnection("server=(local);database=pubs;uid=sa;pwd=")

it would result in this error message:

Index #0
Error: System.Data.SqlClient.SqlError: SQL Server does not exist or access denied.

I also tried using 'localhost' and <my-computername>\<my-servername> for the server. For my database name, I tried both pubs and dbo.pubs. I also tried every username I could think of.

No luck.

Here's the funny thing: I was able to create a View on the database that did exactly what I was trying to do in code, so the DB is working.

If anyone has sucessfully ran the first example program in Chapter 16 of Beginning VB.NET 2nd edition, please respond. That's where I got this example.

Thanks for any help!

JasonWhat is the authentication mode used to connect?

Refer to books online for Troubleshooting the Transact-SQL Debugger topic.|||Originally posted by Satya
What is the authentication mode used to connect?

Refer to books online for Troubleshooting the Transact-SQL Debugger topic.

I'm not sure what you are asking. Remember that I'm using MSDE and I don't go through a lot of the setup that MS SQL uses.

I was forced to use the NT Integrated Security, since no usernames or password combinations that I knew would work for the SQL option, if that's what you mean.|||True, update the SQL Server Authentication mode back to SQL Server Authentification as referred in this KBA (http://support.microsoft.com/default.aspx?scid=kb;EN-US;285097).|||I have only one icon running in my system tray and it is set to SQL Server, not SQL Server Agent.

Do I need both running? If so, how can I get an instance of Agent to run as well as the server, as suggested in the KBA?

By the way, thanks for your response!

Jason|||Also, what username do I use? 'SA'?

Jason

Originally posted by jtimms
I have only one icon running in my system tray and it is set to SQL Server, not SQL Server Agent.

Do I need both running? If so, how can I get an instance of Agent to run as well as the server, as suggested in the KBA?

By the way, thanks for your response!

Jason|||We have the same issue. If you also have Enterprise Manager installed on the same machine, use it to be sure TCP/IP is an enabled protocol. We did that and were able to connect.

The 64 dollar question is how you do this if you DON'T have Enterprise manager. Anyone know how to do it programatically?

Jim M.
Orrtax Software|||Of course you can!

Search for this file:

svrnetcn.exe

usually in:

"C:\Program Files\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe"

which is the Server Network Configuration|||Manowar...thank you! I had the same problem as above, and it turned out that my server had not had TCP/IP enabled! Thank you so much!|||hi manomar - thanks a lot for your entry to this forum. i have had exactly the same problem and thru your entries - now it works!

regards,

Originally posted by manowar
Of course you can!

Search for this file:

svrnetcn.exe

usually in:

"C:\Program Files\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe"

which is the Server Network Configuration|||MSDE usually installs as a named instance, rather than the default instance (this way no two MSDE installs can interfere with each other...theoretically). Check in Administrative tools->services, and check the name of the MSSQL service. If it is MSSQLService, then it is amazingly the default instance. If it is MSSQL$blah, then you have a named instance. In order to address a named instance, you need to specify the name of the server, and the name of the instance as

server=servername\blah

You can also use IP addresses:

10.10.10.10\blah

Not sure if this works:

(local)\blah

Note that while the service is named with a '$', and all folders related to the instance are named with a '$', the service is addressed with '\'. Intuitive, right?|||I have another strange problem:

When I use SVRNETCN or click on the properties in enterprise manager, I see that TCP/IP is enabled for my msde Instance.
But when I look in the error.log of my instance, I see only the entry:
SQL server listening on Named Pipes

There is no entry that the server is listening on TCP/IP and I still get the error message "SQL Server does not exist or access denied" when I try to connect to my database over the network.
So I think my server is still not listening on TCP/IP.

Has anyone a workaround for this problem?

Thanks in advance

MSDE 2000a Tray Icon - Disabling Right-Click Options

Is it possible to either 1) Manually gray out specific options for when you
right-click the MSDE tray icon, or 2) Disable right-clicking on the MSDE tray
icon all together?
If so, please provide the procedure or a link to the appropriate information.
Thank you in advance!!
Robert
rboyer@.cityofsanmateo.org
Hi
None thta I know of. Sorry.
Regards
Mike
"roboyer" wrote:

> Is it possible to either 1) Manually gray out specific options for when you
> right-click the MSDE tray icon, or 2) Disable right-clicking on the MSDE tray
> icon all together?
> If so, please provide the procedure or a link to the appropriate information.
> Thank you in advance!!
> Robert
> rboyer@.cityofsanmateo.org
|||Then how about a way to hide the tray icon?
Thank you for your time.
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> None thta I know of. Sorry.
> Regards
> Mike
> "roboyer" wrote:

MSDE 2000a Tray Icon - Disabling Right-Click Options

Is it possible to either 1) Manually gray out specific options for when you
right-click the MSDE tray icon, or 2) Disable right-clicking on the MSDE tray
icon all together'
If so, please provide the procedure or a link to the appropriate information.
Thank you in advance!!
Robert
rboyer@.cityofsanmateo.orgHi
None thta I know of. Sorry.
Regards
Mike
"roboyer" wrote:
> Is it possible to either 1) Manually gray out specific options for when you
> right-click the MSDE tray icon, or 2) Disable right-clicking on the MSDE tray
> icon all together'
> If so, please provide the procedure or a link to the appropriate information.
> Thank you in advance!!
> Robert
> rboyer@.cityofsanmateo.org|||Then how about a way to hide the tray icon?
Thank you for your time.
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> None thta I know of. Sorry.
> Regards
> Mike
> "roboyer" wrote:
> > Is it possible to either 1) Manually gray out specific options for when you
> > right-click the MSDE tray icon, or 2) Disable right-clicking on the MSDE tray
> > icon all together'
> >
> > If so, please provide the procedure or a link to the appropriate information.
> >
> > Thank you in advance!!
> >
> > Robert
> > rboyer@.cityofsanmateo.org

MSDE 2000 Release A

I just installed MSDE 2000 Release A. I expected to see an icon in the
system try which lets you start and stop msde. I've seen this before,
but it didn't appear on my machine. Can I get this icon to appear
somehow ? Thanks...
hi,
mberger@.skypoint.com wrote:
> I just installed MSDE 2000 Release A. I expected to see an icon in the
> system try which lets you start and stop msde. I've seen this before,
> but it didn't appear on my machine. Can I get this icon to appear
> somehow ? Thanks...
the icon in the systray area should be there, if you correctly installed
MSDE... it can be empty becouse of network protocols status, as reported in
http://support.microsoft.com/default...b;EN-US;814132 ..
if you can't find the Service Manager icon in the tray area, please verify
the service has been correctly installed checking the Services applet in the
OS management tools..
if it's there, up and running (:D) verify in your the "Startup" folder the
presence of the Service Manager entry, usually pointing to
"C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlmangr.exe" /n
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks Andrea, the Service Manager was in my Startup, and clicking on
that caused the icon to show in the system tray. Then, I re-booted, and
the icon showed up. (I had not re-booted after installation)
Mike

Msde 2000

This is my first time using SQL. I installed MSDE 2000 on my desktop and after restarting my PC I see an icon in the startup area MSSQLServer with the server being my T-Tag #.

I am trying to upsize my Access DB to Sqlserver. I am still confused as to where does this server reside? How does this whole thing work?

Also, when I tried to upsize my db I got an overflow error.

Could someone please explain how does this work?

Thanks,

DHYou really should have your instance name be one word with no special characters, so you might want to reinstall MSDE to start with.

The MSDE SQL Server can reside anywhere. A server is always preferrable. You just point to it in Access with ODBC or an Access Data Project.

Can you post the exact message you got on the upsize? This is probably an arithmetic overflow error, but who knows without seeing the error.|||Doesn't MSDE create a named instance by default?

Also, the poster is probably referring to the Tag # of the PC or a laptop, like Dell usually assignes to it's products, something like YG2PBF, so I don't see any problem with it.|||Doesn't MSDE create a named instance by default?

Also, the poster is probably referring to the Tag # of the PC or a laptop, like Dell usually assignes to it's products, something like YG2PBF, so I don't see any problem with it.

Yes, you are right. It uses the TTAG number of the desktop. The MSSQL icon in the start up area also had other names unser the serverl ist. Anyway, attached is the screen shot of the verflow error I encountered.|||Yes, you are right. It uses the TTAG number of the desktop. The MSSQL icon in the start up area also had other names unser the serverl ist. Anyway, attached is the screen shot of the verflow error I encountered.


OOps ..I forgot the attachment..

MSDE

I installed MSDE 2000 in my system. There is no icon & gui screen. How can i create/alter database using MSDE without using any programming language? from where can i get stored data in msde? How can i take backup for this data?See this thread for some ideas on how to manage MSDE:http://forums.asp.net/658936/showpost.aspx
|||

tmorton wrote:

See this thread for some ideas on how to manage MSDE:http://forums.asp.net/658936/showpost.aspx

Thank you very much