error in database connection

Please support our ASP.NET advertiser: Intel Parallel Studio Home
Reply

Join Date: Oct 2008
Posts: 6
Reputation: mubin_attar is an unknown quantity at this point 
Solved Threads: 0
mubin_attar's Avatar
mubin_attar mubin_attar is offline Offline
Newbie Poster

error in database connection

 
0
  #1
Oct 16th, 2008
Hi,

While trying to connect MSSql Server 2000 databse through ASP .Net application using c# I got below errror. Please help.

Sql Server does not exist or access denied.

Mubin
Reply With Quote Quick reply to this message  
Join Date: Jan 2008
Posts: 2,052
Reputation: serkan sendur is a glorious beacon of light serkan sendur is a glorious beacon of light serkan sendur is a glorious beacon of light serkan sendur is a glorious beacon of light serkan sendur is a glorious beacon of light serkan sendur is a glorious beacon of light 
Solved Threads: 118
Featured Poster
serkan sendur serkan sendur is offline Offline
Postaholic

Re: error in database connection

 
0
  #2
Oct 16th, 2008
change your sql server authentication from mixed mode to windows authentication, then you dont have to mess with passwords. this might be the cause for the error.
Due to lack of freedom of speech, i no longer post on this website.
Reply With Quote Quick reply to this message  
Join Date: Oct 2008
Posts: 6
Reputation: mubin_attar is an unknown quantity at this point 
Solved Threads: 0
mubin_attar's Avatar
mubin_attar mubin_attar is offline Offline
Newbie Poster

Re: error in database connection

 
0
  #3
Oct 16th, 2008
Originally Posted by serkansendur View Post
change your sql server authentication from mixed mode to windows authentication, then you dont have to mess with passwords. this might be the cause for the error.
Thanx for your reply.

Actually, my SQL Server have Windows Aunthentication mode.

Please help me out.

Mubin
Reply With Quote Quick reply to this message  
Join Date: Jan 2008
Posts: 2,052
Reputation: serkan sendur is a glorious beacon of light serkan sendur is a glorious beacon of light serkan sendur is a glorious beacon of light serkan sendur is a glorious beacon of light serkan sendur is a glorious beacon of light serkan sendur is a glorious beacon of light 
Solved Threads: 118
Featured Poster
serkan sendur serkan sendur is offline Offline
Postaholic

Re: error in database connection

 
0
  #4
Oct 16th, 2008
ok then right click my computer, click manage, select users and groups, add asp.net user to databaseadministrators group.
Due to lack of freedom of speech, i no longer post on this website.
Reply With Quote Quick reply to this message  
Join Date: Oct 2008
Posts: 6
Reputation: mubin_attar is an unknown quantity at this point 
Solved Threads: 0
mubin_attar's Avatar
mubin_attar mubin_attar is offline Offline
Newbie Poster

Re: error in database connection

 
0
  #5
Oct 17th, 2008
Originally Posted by serkansendur View Post
ok then right click my computer, click manage, select users and groups, add asp.net user to databaseadministrators group.
Thanx serkansendur,

I will try it, hope so it will work.

I will reply the same if it works.

Best regards,
Mubin
Reply With Quote Quick reply to this message  
Join Date: Oct 2008
Posts: 6
Reputation: mubin_attar is an unknown quantity at this point 
Solved Threads: 0
mubin_attar's Avatar
mubin_attar mubin_attar is offline Offline
Newbie Poster

Re: error in database connection

 
0
  #6
Oct 18th, 2008
Originally Posted by mubin_attar View Post
Thanx serkansendur,

I will try it, hope so it will work.

I will reply the same if it works.

Best regards,
Mubin
Hi,

Its working .......

Thanks a lot..

Mubin
Reply With Quote Quick reply to this message  
Join Date: Jan 2008
Posts: 2,052
Reputation: serkan sendur is a glorious beacon of light serkan sendur is a glorious beacon of light serkan sendur is a glorious beacon of light serkan sendur is a glorious beacon of light serkan sendur is a glorious beacon of light serkan sendur is a glorious beacon of light 
Solved Threads: 118
Featured Poster
serkan sendur serkan sendur is offline Offline
Postaholic

Re: error in database connection

 
0
  #7
Oct 18th, 2008
add to my reputation
Due to lack of freedom of speech, i no longer post on this website.
Reply With Quote Quick reply to this message  
Join Date: Oct 2008
Posts: 8
Reputation: n4naeem is an unknown quantity at this point 
Solved Threads: 1
n4naeem n4naeem is offline Offline
Newbie Poster

Re: error in database connection

 
0
  #8
Oct 21st, 2008
Check yours connection string it must have password.

from web.config.

change the connection string without password.





Originally Posted by mubin_attar View Post
Thanx for your reply.

Actually, my SQL Server have Windows Aunthentication mode.

Please help me out.

Mubin
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC