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 2000 installation problem

" Starting custom action ConfigServer
Executing "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe
-V 1 -M 1 -U sa -I "MSSQLSERVER" -Q "Latin1_General""
Setup failed to configure the server. Refer to the server error logs and
setup error logs for more information. "
that is the last action before the install fail in the log
does anyone know what's wrong?
thanx
Lok
hi Lok,
"Lok" <Lok@.discussions.microsoft.com> ha scritto nel messaggio
news:7B1D91E0-00CA-4C32-AC67-267BCFF7958A@.microsoft.com
> " Starting custom action ConfigServer
> Executing "C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "MSSQLSERVER" -Q
> "Latin1_General""
> Setup failed to configure the server. Refer to the server error logs
> and setup error logs for more information. "
> that is the last action before the install fail in the log
> does anyone know what's wrong?
> thanx
> Lok
please have a look at
http://support.microsoft.com/default...99&Product=sql
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I have tried every resolutions found on the website and it was still not
installing.
I've always set the lanaguage for non Unicode programs to chinese( Hong
Kong) to be able to display chinese character in the system natively. I have
specified the collation to Latin1_General in order for the setup to start but
the installation was never successful.
After switching the language back to English(United States), MSDE installed
fine.
Now my question is if I switch the language back to Chinese(Hong Kong),
would that mess up the MSDE install.
thanx
Lok
"Andrea Montanari" wrote:

> hi Lok,
> "Lok" <Lok@.discussions.microsoft.com> ha scritto nel messaggio
> news:7B1D91E0-00CA-4C32-AC67-267BCFF7958A@.microsoft.com
> please have a look at
> http://support.microsoft.com/default...99&Product=sql
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>

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..