We help IT Professionals succeed at work.

SQL Server, can't connect to local server when there is no network connection present via connectionstring.

649 Views
Last Modified: 2013-12-17
goodevening.

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
Kindest regards,
Marco Kotrotsos

Comment
Watch Question

Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
CERTIFIED EXPERT

Commented:
can you use localhost instead of the home ip address? don't know if will make a difference but it's worth a try

Author

Commented:
that was fast, thanks! Both of you!
Changing it to localhost didnt' work, but changing it to the computers name did....

Kind regards,
Marco
CERTIFIED EXPERT

Commented:
4cl1t3--sorry about stepping on your answer i didn't see it before i posted.

marco, glad you got it working

Commented:
No worries p_davis, it happens. :)
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.