Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Q: SQL Server login error, used to work fine?

Thread Tools

Q: SQL Server login error, used to work fine?

Matt C.
Posts: n/a
Just this week I have discovered that my ASP.NET apps do not connect
properly to SQL server anymore. If I try to connect to the server by name,
I get the error "SQL Server does not exist or access denied."

However, if I change the SQL server connection string to use IP address, I
can connect successfully. I am using SQL Server Security (not integrated)
to connect to the SQL server. I have tried adding "Net=dbmssocn" to the
connection string and adding the server name to my HOSTS file just in case
there was a named pipes issue or a slow lookup; neither thing helped. I can
ping the server by name with no problem, and other apps (e.g. VB 6 apps) can
connect by server name.

The failures on the client correspond to logon failures on the server for
WORKSTATION\ASPNET. (Logon Type 3, process NtLmSsp, plus another error code
3221225572.) My workstation connects to the network via a VPN, just in case
it's relevant.

The app shouldn't be trying to connect as WORKSTATION\ASPNET at all, and I
definitely don't understand why it started to do this out of the blue. My
guess is it has something to do with the security updates I installed last
week (against Sasser, I don't remember the #s), but that is only a guess.

Has anyone had any related problems, perhaps associated with the latest
security updates? Or have any insight why my app refuses to use SQL Server
authentication with the server name?

Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
using Membership on production server (Copy Web Site tool) - Used to SQL Server 2000 enterprise edition Louis R. ASP .Net 5 01-14-2009 06:21 AM
Help. Getting a An error has occurred while establishing a connectionto the server. When connecting to SQL Server 2005, this failure may be causedby the fact that under the default settings SQL Server does not allow remote ASP .Net 0 05-03-2008 12:43 PM
question about login at server level in sql server express Jean ASP .Net Security 0 08-28-2007 10:03 AM
question about login at server level in sql server express Jean ASP .Net 0 08-28-2007 10:03 AM
Re: Is SQL Server 2005 Express is the only choice to work with Login controls? Juan T. Llibre ASP .Net 2 10-17-2005 05:06 PM