943,700 Members | Top Members by Rank

Web Development > ASP.NET > error in database connection
Ad:
  • ASP.NET Discussion Thread
  • Unsolved
  • Views: 922
  • ASP.NET RSS
Permalink
Oct 16th, 2008
0

error in database connection

Expand Post »
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
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
mubin_attar is offline Offline
9 posts
since Oct 2008
Permalink
Oct 16th, 2008
0

Re: error in database connection

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.
Featured Poster
Reputation Points: 854
Solved Threads: 127
Banned
serkan sendur is offline Offline
2,057 posts
since Jan 2008
Permalink
Oct 16th, 2008
0

Re: error in database connection

Click to Expand / Collapse  Quote originally posted by serkansendur ...
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
Reputation Points: 10
Solved Threads: 0
Newbie Poster
mubin_attar is offline Offline
9 posts
since Oct 2008
Permalink
Oct 16th, 2008
0

Re: error in database connection

ok then right click my computer, click manage, select users and groups, add asp.net user to databaseadministrators group.
Featured Poster
Reputation Points: 854
Solved Threads: 127
Banned
serkan sendur is offline Offline
2,057 posts
since Jan 2008
Permalink
Oct 17th, 2008
0

Re: error in database connection

Click to Expand / Collapse  Quote originally posted by serkansendur ...
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
Reputation Points: 10
Solved Threads: 0
Newbie Poster
mubin_attar is offline Offline
9 posts
since Oct 2008
Permalink
Oct 18th, 2008
0

Re: error in database connection

Click to Expand / Collapse  Quote originally posted by mubin_attar ...
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
Reputation Points: 10
Solved Threads: 0
Newbie Poster
mubin_attar is offline Offline
9 posts
since Oct 2008
Permalink
Oct 18th, 2008
0

Re: error in database connection

add to my reputation
Featured Poster
Reputation Points: 854
Solved Threads: 127
Banned
serkan sendur is offline Offline
2,057 posts
since Jan 2008
Permalink
Oct 21st, 2008
0

Re: error in database connection

Check yours connection string it must have password.

from web.config.

change the connection string without password.





Click to Expand / Collapse  Quote originally posted by mubin_attar ...
Thanx for your reply.

Actually, my SQL Server have Windows Aunthentication mode.

Please help me out.

Mubin
Reputation Points: 10
Solved Threads: 1
Newbie Poster
n4naeem is offline Offline
8 posts
since Oct 2008

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: Asp.net Page access Control
Next Thread in ASP.NET Forum Timeline: Transferring Variables





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


Follow us on Twitter


© 2011 DaniWeb® LLC