SQL SERVER 2000 Login failure in ASP.NET

[superwoman]

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:

[vrsane]

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

[superwoman]

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.

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

MY MSSQLSERVER is running tho!!!
Please help

[vrsane]

Read this one :

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

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.

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

MY MSSQLSERVER is running tho!!! Please help

[superwoman]

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

[vrsane]

this kb article applies to all...

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

[f1 fan]

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= in there too for your app

[f1 fan]

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