SQL Server, can't connect to local server when there is no network connection present via connectionstring.
Posted on 2007-10-08
I am having a bit of a problem connecting to my local SQL Server instance when I have no network connection. The server is running on my own computer- and connecting to it is not a problemen when I have a normal network connection. But when I am on the road, or at the clients office and disconnect my network. I can't seem to connect to my (local) server anymore. But I can via enterprise manager though , but not via the connectionstring below
Provider=SQLOLEDB;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=SUNDB;Data Source=127.0.0.1
Is there something I am missing in regards to local loopbacks or something?
Hope someone can help,
Thank you very much