Right now I am in a bind. I have to support a VS 2003 web application that was originally created using SQL Server 2000 and works just fine in that configuration.
However a version was also deployed on a 2003 server that had SQL Server 2005 on it. I need to debug a problem with the 2005 database so I installed SQL Server 2005 alongside the VS web 2003 application in the XP Pro development workstation.
Now I get a "SQL Server does not exist or access denied" error in the browser whenever I try to run the VS web application.
I can log into SQL Server 2005 directly with the sa user id and password so that is working.
Can anyone help me with this problem because I have tried searching the internet and nothing relates directly to configuring SQL Server 2005 for a VS 2003 web application that I have been able to find.
After searching MSDN and finding an article on changing the firewall and discovering that didn't work either I decided to attempt the first principles approach instead.
I deleted the <sessionState.../> from my web.config entirely and decided to see what kind of error that would generate so that I would only add back whatever it needed.
Surprise, surprise there was no longer any "SQL Server does not exist or access denied" error and the Login page appeared instead.
I have no idea if any of the solutions recommended by Jeff and Kamii have had any impact on resolving this problem but I do appreciate their help.
I am not sure how I would chaeck that. That setting is a legacy from the original SQL Server 2000 in the web.config.
I would remove the port, and set the IP to the IP of the server itself. 127.0.0.0 isn't an IP, it's a routing address, and probably a typo. But port 42424 is non-standard and you probably don't need it if you didn't set SQL to a specific port.
rgould
0 Points
9 Posts
VS 2003/SQL Server 2005 Access Denied
May 13, 2008 02:05 PM|LINK
Right now I am in a bind. I have to support a VS 2003 web application that was originally created using SQL Server 2000 and works just fine in that configuration.
However a version was also deployed on a 2003 server that had SQL Server 2005 on it. I need to debug a problem with the 2005 database so I installed SQL Server 2005 alongside the VS web 2003 application in the XP Pro development workstation.
Now I get a "SQL Server does not exist or access denied" error in the browser whenever I try to run the VS web application.
The web.config has the following settings;
<sessionState
mode="SQLServer"
cookieless="false"
timeout="2000"
sqlConnectionString="data source=DEV03/DEV03;user id=sa;password=xxx"
stateConnectionString="tcpip=127.0.0.1:42424"/>
I can log into SQL Server 2005 directly with the sa user id and password so that is working.
Can anyone help me with this problem because I have tried searching the internet and nothing relates directly to configuring SQL Server 2005 for a VS 2003 web application that I have been able to find.
Thank you
kamii47
Star
9500 Points
2383 Posts
Re: VS 2003/SQL Server 2005 Access Denied
May 13, 2008 03:04 PM|LINK
Follow the steps I have mentioned in http://forums.asp.net/t/1254303.aspx
IT will also work for VS2003
(MCP,MCAD.net,MCSD.net,MCTS,MCPD.net[web])
rgould
0 Points
9 Posts
Re: VS 2003/SQL Server 2005 Access Denied
May 13, 2008 03:53 PM|LINK
Thanks for the response. I followed the steps and made the configuration changes that you recommended and rebooted.
Unfortunately I am still seeing the exact same error.
Is there anything else that I could try?
kamii47
Star
9500 Points
2383 Posts
Re: VS 2003/SQL Server 2005 Access Denied
May 13, 2008 04:03 PM|LINK
Try to turn off your firewall
(MCP,MCAD.net,MCSD.net,MCTS,MCPD.net[web])
jeff@zina.co...
All-Star
87677 Points
11637 Posts
Moderator
Re: VS 2003/SQL Server 2005 Access Denied
May 13, 2008 04:46 PM|LINK
Is this just for session state or is there another connection to the SQL server? Is the SQL server answering on 127.0.0.0:42424?
Jeff
rgould
0 Points
9 Posts
Re: VS 2003/SQL Server 2005 Access Denied
May 13, 2008 04:59 PM|LINK
What firewall?
I have SQL Server 2005 installed on the same PC as the VS 2003.
rgould
0 Points
9 Posts
Re: VS 2003/SQL Server 2005 Access Denied
May 13, 2008 05:01 PM|LINK
Jeff,
I am using both ASPState and the database for the application.
Rich
rgould
0 Points
9 Posts
Re: VS 2003/SQL Server 2005 Access Denied
May 13, 2008 05:19 PM|LINK
Jeff,
Sorry, I missed the second part of your question.
<Is the SQL server answering on 127.0.0.0:42424?>
I am not sure how I would chaeck that. That setting is a legacy from the original SQL Server 2000 in the web.config.
Rich
rgould
0 Points
9 Posts
Re: VS 2003/SQL Server 2005 Access Denied
May 13, 2008 06:45 PM|LINK
After searching MSDN and finding an article on changing the firewall and discovering that didn't work either I decided to attempt the first principles approach instead.
I deleted the <sessionState.../> from my web.config entirely and decided to see what kind of error that would generate so that I would only add back whatever it needed.
Surprise, surprise there was no longer any "SQL Server does not exist or access denied" error and the Login page appeared instead.
I have no idea if any of the solutions recommended by Jeff and Kamii have had any impact on resolving this problem but I do appreciate their help.
Thank you.
Rich
jeff@zina.co...
All-Star
87677 Points
11637 Posts
Moderator
Re: VS 2003/SQL Server 2005 Access Denied
May 13, 2008 07:05 PM|LINK
I would remove the port, and set the IP to the IP of the server itself. 127.0.0.0 isn't an IP, it's a routing address, and probably a typo. But port 42424 is non-standard and you probably don't need it if you didn't set SQL to a specific port.
Jeff