May 10, 2010 at 10:36 am
Hi,
I have SQL Server 2008 running on my laptop.
I am using an application written in PowerBuilder 8.
When I run my front-end app, I believe it is using the network connection to connect to the server. Because, if my internet connection breaks, the SQL connectivity also breaks. How can I configure my SQL server to NOT use network connection at all?
Amazing thing is, sometimes it doesn't do this. I even tried switching off my wireless card and my program still worked fine. I am confused...
Could anyone please shed some light so as to what is happening?
Any help would be highly appreciated..
Shibu
May 10, 2010 at 12:27 pm
Within the sql server configuration manager try setting the IP address to 127.0.0.1
You will need to restart the sql services for it to take effect.
May 10, 2010 at 2:25 pm
Thanks for the quick response, SQL_LOCK.
The IP6 address for TCP/IP is already 127.0.0.1.
All other IP settings are disabled, except IP6.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply