Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 ASP.NET
 SQL Server does not exist or access denied.

Author  Topic 

SCameron
Starting Member

2 Posts

Posted - 2010-07-28 : 12:22:31
We have multiple applications running on a dev server, and all of them can access our database with no problems, except my newest project. I have copied the connection string from another one of our applications, so I know that isn't the problem. The app runs perfectly fine on another server, but not the one it should be on.

I have tried pinging the db server from the dev server and it fails, but our other applications are able to connect to it anyways.

Any ideas?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-07-28 : 13:23:48
http://weblogs.sqlteam.com/tarad/archive/2008/05/23/60609.aspx

If ping isn't working, then you'll need to contact your network administrator. See the above link for some other troubleshooting steps, but you've got to get the ping to work first. Telnet'ing to the port as a test is the second thing that needds to work.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

SCameron
Starting Member

2 Posts

Posted - 2010-07-28 : 15:19:10
By removing the <identity impersonate="true"/> line from the web.config file, the application was able to access the database with no problems (even though the servers still can't ping each other).

Thanks for the suggestions Tara, I have bookmarked your blog post for future reference.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-07-28 : 15:26:02
Cool, glad you got it working. The network must be preventing pings, unusual but not required for SQL access. The telnet test is the very first place to start troubleshooting.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -