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

Posted on 2007-10-08
Last Modified: 2013-12-17

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=

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

Question by:EnolaKotrotsos
    LVL 1

    Accepted Solution

    Have you tried changing the source to localhost or the machine's name?
    LVL 22

    Expert Comment

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

    Author Comment

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

    Kind regards,
    LVL 22

    Expert Comment

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

    marco, glad you got it working
    LVL 1

    Expert Comment

    No worries p_davis, it happens. :)

    Featured Post

    Live: Real-Time Solutions, Start Here

    Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

    Join & Write a Comment

    More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
    JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
    Via a live example, show how to shrink a transaction log file down to a reasonable size.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now