Link to home
Start Free TrialLog in
Avatar of aspnetdev
aspnetdev

asked on

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
Avatar of mrichmon
mrichmon

Are you connecting onthe correct port?
ASKER CERTIFIED SOLUTION
Avatar of mrichmon
mrichmon

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Typo... I put "SWL Server" above and obviously meant "SQL Server"...

John
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
no reply from you aspnetdev

Is my solution solved your problem?
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.
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.  :)
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.
<applause>
You're a good sport mrichmon.  Happy to see you have a sense of humor.
</applause>
no reply from you aspnetdev

is our solution helped you???