Sunday, March 25, 2012

Cant find SQL Server

I have the following in my web.config

<appSettings>
<add key="strConn" value="server=10.100.1.2;uid=sa;pwd=;database=MyDB/>
</appSettings
and I am getting the following error message --

"SQL Server cannot be found or access denied"

if I replace the server IP address with server name, it works fine.

Am I missing something here? Help!

Thanks

Bugme

See the linkhttp://blogs.msdn.com/sql_protocols/archive/2005/10/29/486861.aspx has some information. Hope that helps you!

My guess is name resolution faild!

No comments:

Post a Comment