SQL SERVER 2000 Login failure in ASP.NET
 

Hi

I recently installed SQL SERVER 2000 Personal edition on my Windows XP Prof PC. I installed using the windows authentication mode.
But when i try to connect the database from .NET in my ASP.NET application. I get an error saying
"Server does not exist or not access denied"

pLEASE help me

:sad:

Re: SQL SERVER 2000 Login failure in ASP.NET
 

try replacing localhost with 127.0.0.1 Ip address ... check your config file to see if there is any default option set...

did you try to connect to sql server with ent manager ..?

Re: SQL SERVER 2000 Login failure in ASP.NET
 

I can run the server on enterprise manager successfully. But when i try to run an asp.net page i get this error now

Anonymous error occured:5 - 18452 - Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

I checked the Webconfig file.

<sessionState mode="InProc" stateConnectionString="tcpip=127.0.0.1:42424" sqlConnectionString="data source=127.0.0.1;user id=sa;password="
cookieless="false" timeout="20" />

Should I make changes to the user id and password here (as i m using windows authentication)

MY MSSQLSERVER is running tho!!!
Please help

Re: SQL SERVER 2000 Login failure in ASP.NET
 

Read this one :

http://support.microsoft.com/kb/889615/en-us

Re: SQL SERVER 2000 Login failure in ASP.NET
 

Thnx for the link. But unfortunately it couldnt solve my problem. I have installed Personal edition and i think the article was only for
• Microsoft SQL Server 2000 Standard Edition
• Microsoft SQL Server 2005 Standard Edition
• Microsoft SQL Server 2005 Developer Edition
• Microsoft SQL Server 2005 Enterprise Edition
• Microsoft SQL Server 2005 Express Edition
• Microsoft SQL Server 2005 Workgroup Edition

Please help

Re: SQL SERVER 2000 Login failure in ASP.NET
 

this kb article applies to all...

Re: SQL SERVER 2000 Login failure in ASP.NET
 

the problem is you are using the sa name and password but have set it to windows authentication only not mixed mode. take out the userid and the password and replace with IntegratedSecurity=SSPI that should work, i would also have an Initial Catalog=<databasename> in there too for your app

Re: SQL SERVER 2000 Login failure in ASP.NET
 

oops there is supposed to be a space between Integrated and Security.... Integrated Security=SSPI