ASP.NET RSS ASP.NET RSS

SQL SERVER 2000 Login failure in ASP.NET

Please support our ASP.NET advertiser: $4.95 a Month - ASP.NET Web Hosting – Click Here!
Reply

•
•
Join Date: Jan 2006
Posts: 5
Reputation: superwoman is an unknown quantity at this point 
Solved Threads: 0
superwoman superwoman is offline Offline
Newbie Poster

SQL SERVER 2000 Login failure in ASP.NET

 
0
  #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

Reply With Quote Quick reply to this message  
•
•
Join Date: Dec 2005
Posts: 6
Reputation: vrsane is an unknown quantity at this point 
Solved Threads: 0
vrsane vrsane is offline Offline
Newbie Poster

Re: SQL SERVER 2000 Login failure in ASP.NET

 
0
  #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 Quick reply to this message  
•
•
Join Date: Jan 2006
Posts: 5
Reputation: superwoman is an unknown quantity at this point 
Solved Threads: 0
superwoman superwoman is offline Offline
Newbie Poster

Re: SQL SERVER 2000 Login failure in ASP.NET

 
0
  #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 Quick reply to this message  
•
•
Join Date: Dec 2005
Posts: 6
Reputation: vrsane is an unknown quantity at this point 
Solved Threads: 0
vrsane vrsane is offline Offline
Newbie Poster

Re: SQL SERVER 2000 Login failure in ASP.NET

 
0
  #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 Quick reply to this message  
•
•
Join Date: Jan 2006
Posts: 5
Reputation: superwoman is an unknown quantity at this point 
Solved Threads: 0
superwoman superwoman is offline Offline
Newbie Poster

Re: SQL SERVER 2000 Login failure in ASP.NET

 
0
  #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 Quick reply to this message  
•
•
Join Date: Dec 2005
Posts: 6
Reputation: vrsane is an unknown quantity at this point 
Solved Threads: 0
vrsane vrsane is offline Offline
Newbie Poster

Re: SQL SERVER 2000 Login failure in ASP.NET

 
0
  #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 Quick reply to this message  
•
•
Join Date: Jan 2006
Posts: 275
Reputation: f1 fan is an unknown quantity at this point 
Solved Threads: 11
f1 fan f1 fan is offline Offline
Posting Whiz in Training

Re: SQL SERVER 2000 Login failure in ASP.NET

 
0
  #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 Quick reply to this message  
•
•
Join Date: Jan 2006
Posts: 275
Reputation: f1 fan is an unknown quantity at this point 
Solved Threads: 11
f1 fan f1 fan is offline Offline
Posting Whiz in Training

Re: SQL SERVER 2000 Login failure in ASP.NET

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

Quick Reply to Thread
This thread is more than three months old.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Similar Threads
Other Threads in the ASP.NET Forum
Thread Tools Search this Thread



.net 2.0 3.5 activexcontrol advice ajax alltypeofvideos appliances asp asp.net bc30451 beginner bottomasp.net browser businesslogiclayer c# c#gridviewcolumn cac checkbox commonfunctions compatible confirmationcodegeneration content contenttype courier css dataaccesslayer database datagrid datagridview datagridviewcheckbox datalist development dgv dropdownlist dropdownmenu dynamically edit fileuploader fill flash flv formatdecimal forms formview gridview gudi homeedition iframe iis javascript jquery listbox menu microsoft mono mouse mssql multistepregistration nameisnotdeclared news objects opera panelmasterpagebuttoncontrols redirect registration relationaldatabases reportemail rotatepage schoolproject security serializesmo.table sessionvariables silverlight smartcard smoobjects software sql-server sqlserver2005 suse textbox tracking treeview unauthorized validatedate validation vb.net video videos virtualdirectory vista visual-studio visualstudio web webapplications webarchitecture webdevelopemnt webprogramming webservice youareanotmemberofthedebuggerusers
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC