944,122 Members | Top Members by Rank

Web Development > ASP.NET > SQL SERVER 2000 Login failure in ASP.NET
Ad:
  • ASP.NET Discussion Thread
  • Unsolved
  • Views: 11085
  • ASP.NET RSS
Permalink
Jan 23rd, 2006
0

SQL SERVER 2000 Login failure in ASP.NET

Expand Post »
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

Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
superwoman is offline Offline
5 posts
since Jan 2006
Permalink
Jan 23rd, 2006
0

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 ..?
Quote originally posted by 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

Reputation Points: 10
Solved Threads: 0
Newbie Poster
vrsane is offline Offline
6 posts
since Dec 2005
Permalink
Jan 23rd, 2006
0

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
Reputation Points: 10
Solved Threads: 0
Newbie Poster
superwoman is offline Offline
5 posts
since Jan 2006
Permalink
Jan 23rd, 2006
0

Re: SQL SERVER 2000 Login failure in ASP.NET

Read this one :

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


Quote originally posted by 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.

<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
Reputation Points: 10
Solved Threads: 0
Newbie Poster
vrsane is offline Offline
6 posts
since Dec 2005
Permalink
Jan 23rd, 2006
0

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
Reputation Points: 10
Solved Threads: 0
Newbie Poster
superwoman is offline Offline
5 posts
since Jan 2006
Permalink
Jan 23rd, 2006
0

Re: SQL SERVER 2000 Login failure in ASP.NET

this kb article applies to all...

Quote originally posted by 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
Reputation Points: 10
Solved Threads: 0
Newbie Poster
vrsane is offline Offline
6 posts
since Dec 2005
Permalink
Jan 23rd, 2006
0

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
Reputation Points: 26
Solved Threads: 11
Posting Whiz in Training
f1 fan is offline Offline
275 posts
since Jan 2006
Permalink
Jan 23rd, 2006
0

Re: SQL SERVER 2000 Login failure in ASP.NET

oops there is supposed to be a space between Integrated and Security.... Integrated Security=SSPI
Reputation Points: 26
Solved Threads: 11
Posting Whiz in Training
f1 fan is offline Offline
275 posts
since Jan 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in ASP.NET Forum Timeline: How can I fill the webpage
Next Thread in ASP.NET Forum Timeline: check for images duplication





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC