User Name Password Register
DaniWeb IT Discussion Community
Home
Forums
Tutorials
Code Snippets
Blogs
Link Directory
All
•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the ASP.NET section within the Web Development category of DaniWeb, a massive community of 374,443 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,922 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Join our community!
Please support our ASP.NET advertiser: Lunarpages ASP Web Hosting
Views: 7904 | Replies: 7
Reply
•
•
Join Date: Jan 2006
Posts: 5
Reputation: superwoman is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
superwoman superwoman is offline Offline
Newbie Poster

SQL SERVER 2000 Login failure in ASP.NET

  #1  
Jan 23rd, 2006
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

AddThis Social Bookmark Button
Reply With Quote  
•
•
Join Date: Dec 2005
Location: New York
Posts: 6
Reputation: vrsane is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
vrsane vrsane is offline Offline
Newbie Poster

Re: SQL SERVER 2000 Login failure in ASP.NET

  #2  
Jan 23rd, 2006
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 ..?
•
•
•
•
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

Regards,
VRSane

Free Training : http://www.exforsys.com
Interview Questions : http://www.geekinterview.com
Articles Directory : http://www.geekarticles.com
Reply With Quote  
•
•
Join Date: Jan 2006
Posts: 5
Reputation: superwoman is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
superwoman superwoman is offline Offline
Newbie Poster

Re: SQL SERVER 2000 Login failure in ASP.NET

  #3  
Jan 23rd, 2006
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
Reply With Quote  
•
•
Join Date: Dec 2005
Location: New York
Posts: 6
Reputation: vrsane is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
vrsane vrsane is offline Offline
Newbie Poster

Re: SQL SERVER 2000 Login failure in ASP.NET

  #4  
Jan 23rd, 2006
Read this one :

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


•
•
•
•
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
Regards,
VRSane

Free Training : http://www.exforsys.com
Interview Questions : http://www.geekinterview.com
Articles Directory : http://www.geekarticles.com
Reply With Quote  
•
•
Join Date: Jan 2006
Posts: 5
Reputation: superwoman is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
superwoman superwoman is offline Offline
Newbie Poster

Re: SQL SERVER 2000 Login failure in ASP.NET

  #5  
Jan 23rd, 2006
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
Reply With Quote  
•
•
Join Date: Dec 2005
Location: New York
Posts: 6
Reputation: vrsane is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
vrsane vrsane is offline Offline
Newbie Poster

Re: SQL SERVER 2000 Login failure in ASP.NET

  #6  
Jan 23rd, 2006
this kb article applies to all...

•
•
•
•
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
Regards,
VRSane

Free Training : http://www.exforsys.com
Interview Questions : http://www.geekinterview.com
Articles Directory : http://www.geekarticles.com
Reply With Quote  
•
•
Join Date: Jan 2006
Location: Its the internet... i am everywhere lol
Posts: 274
Reputation: f1 fan is an unknown quantity at this point 
Rep Power: 3
Solved Threads: 10
f1 fan f1 fan is offline Offline
Posting Whiz in Training

Re: SQL SERVER 2000 Login failure in ASP.NET

  #7  
Jan 23rd, 2006
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
Reply With Quote  
•
•
Join Date: Jan 2006
Location: Its the internet... i am everywhere lol
Posts: 274
Reputation: f1 fan is an unknown quantity at this point 
Rep Power: 3
Solved Threads: 10
f1 fan f1 fan is offline Offline
Posting Whiz in Training

Re: SQL SERVER 2000 Login failure in ASP.NET

  #8  
Jan 23rd, 2006
oops there is supposed to be a space between Integrated and Security.... Integrated Security=SSPI
Reply With Quote  
Reply

•
•
•
•

Only community members can participate in forum threads. You must register or log in to contribute.

Register
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

•
•
•
•
•
•
•
•
DaniWeb ASP.NET Marketplace
•
•
•
•
Thread Tools Display Modes
Linear Mode Linear Mode

•
•
•
•
.net access ad advertising ajax asp backup beta business centro code combo custom daniweb data database developer development dom doubleclick dropdownlist feed google hacker linux longhorn microsoft module msdn net news novell office reader reuse security server skin smtp software sql survey suse theme weather web windows windows server xml xoap
Similar Threads
Other Threads in the ASP.NET Forum

Advertising Opportunities on DaniWeb
Contact Us - Newsletter Archive - Sitemap - Privacy Statement
All times are GMT -4. The time now is 12:21 pm.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC