SQL Server does not exist or access denied.

Hi,
When ever im trying to run my application im getting this error
SQL Server does not exist or access denied.
i use xml configuration file in my web.config file to connect to my DB.Even though the db name is right  and it exists i keep getting this error...can anyone help me on this,
Thanks
aspnetdevAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
mrichmonConnect With a Mentor Commented:
It would help if you showed your connection code (minus password of course)
0
 
mrichmonCommented:
Are you connecting onthe correct port?
0
 
Vivek ThangaswamyCommented:
Are you using sa account in your code? if yes then check the sa account is enable in your SQL manager.

in Some case this "access denied" problem will come for ASPNET account. Check that account as full rights
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Steve SiricaConnect With a Mentor Senior Web Application EngineerCommented:
Yeah, if you're using a trusted connection without an impersonate it's probably trying to connect as aspnet.  Either specify the User ID & Password in your connection string, give the proper rights to aspnet or add an impersonate to your web.config.  Oh I just remembered, there's always UseDefaultCredentials.  

Any combination of those should work.
0
 
jnhorstConnect With a Mentor Commented:
Trying to give ASPNET (for Win2K -- it will be NETWORK SERVICE for Win2003) access to the SQL Server will be a headache because the ASPNET or NETWORK SERVICE accounts are local to the IIS server and the SQL Server (I am assuming they are on different boxes here) will not know anything about these accounts.  The comment above about using SQL Server Auth and specifying the username and password in the connection string is the easiest path to solving this.

Alternately, if you are allowing anonymous requests to the web site, create a domain/AD account strictly for the web site's database access.  Then change IIS to use this account to authenticate anonymous requests.  Then add this account to the SWL Server Logins section (under the Security node).  Then add the account to the database's Users.

John
0
 
jnhorstCommented:
Typo... I put "SWL Server" above and obviously meant "SQL Server"...

John
0
 
Vivek ThangaswamyConnect With a Mentor Commented:
Hi  aspnetdev

Is my solution solved your problem?
0
 
Vivek ThangaswamyCommented:
no reply from you aspnetdev

Is my solution solved your problem?
0
 
mrichmonCommented:
Any reason all solutions that suggested credentials were marked for a split, but mine- which is also a plausible cause of the wrong port being used - was not included in the split?

I think all are equally viable possibilities and all should be included in a split or a delete no refund should be done.
0
 
Steve SiricaSenior Web Application EngineerCommented:
If it would make them feel better, go ahead and give my share of the split to the squeeky wheel as charity points.  Afterall, I'm not here for the points...I'm here to help my fellow programmers.

Can anyone else hear the sounds of the waaaaaabulance?  Too bad this wasn't the Lounge.  :)
0
 
mrichmonCommented:
I am concerned with what is being documented as possible solutions not with points.  Go ahead and assign 0 points, I would have the same point to make - even if there were no points on the site at all.

But others coming later to look should see what are actual possible solutions if this is being marked as solved - or it should be deleted if it is unclear that any were solutions.
0
 
Steve SiricaSenior Web Application EngineerCommented:
<applause>
You're a good sport mrichmon.  Happy to see you have a sense of humor.
</applause>
0
 
Vivek ThangaswamyCommented:
no reply from you aspnetdev

is our solution helped you???
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.