Re: Can't Access Named Instanced With Network Protocol Disabled

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi

(local) and localhost rely on the network stack to resolve. If you network
is disabled, there is nothing there to resolve the name. localhost resolves
to 127.0.0.1 by TCP/IP.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@xxxxxxxxxxxx

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Marauderz" <marauderz@xxxxxxxxxx> wrote in message
news:u1dlfrAqFHA.3720@xxxxxxxxxxxxxxxxxxxxxxx
> Hi there,
>
> I have a little question here.
>
> I've installed a named instance of MSDE SP4 called mydb, with network
> protocols disabled.
>
> Then I noticed that I can't connect to it using OSQL
>
> I tried
> 'osl -S (local)\mydb -E'
> 'osl -S localhost\mydb -E'
> and both of them can't connect to the database, however.
> 'osql -S mypcname\mydb -E'
> works perfectly... I don't want to manually fill in the machine name for
> each connection string can someone tell me why (local) doesn't seem to
> connect to the local machine? Does it have anything to do with network
> protocols disabled?
>
> Thanks.
>


.

Relevant Pages

  • RE: Error binding to local domain
    ... away because I was away for a couple weeks and I do not force permissions on ... The permissions dialog just times out trying to resolve the ... >> following event "Windows cannot query for the list of Group Policy objects. ... >> An Active Directory, network connectivity, or network configuration problem ...
    (microsoft.public.windows.server.sbs)
  • Re: download cvsup?
    ... Also the rest of the network is currently working. ... Eliminate all things superfluous to troubleshooting the DNS problem. ... whatever I try I can't seem to resolve external hosts, ... or whether the lookup is returning from your DNS server. ...
    (freebsd-questions)
  • Re: Cant establish a network.
    ... "John John" wrote in message ... That is not to say that you should keep on beating a dead horse, if the thread is going nowhere or if it has been hijacked by posters who have nothing of value to add to the problem at hand then you definitely should start a new thread. ... If you feel that you are getting further ahead in your troubleshooting efforts and that you prefer to start new threads with new topics to resolve the problem then you should do as you see fit. ... It is not for me to tell anyone how to post, I only suggested that it was difficult to follow your efforts and the suggestions made by the poster to help you resolve the errors and come to a successful conclusion with the network problem. ...
    (microsoft.public.windowsxp.general)
  • Re: Cant establish a network.
    ... That is not to say that you should keep on beating a dead horse, if the thread is going nowhere or if it has been hijacked by posters who have nothing of value to add to the problem at hand then you definitely should start a new thread. ... Maybe I'm dense but isn't this a system of daily forced abandonment? ... If you feel that you are getting further ahead in your troubleshooting efforts and that you prefer to start new threads with new topics to resolve the problem then you should do as you see fit. ... It is not for me to tell anyone how to post, I only suggested that it was difficult to follow your efforts and the suggestions made by the poster to help you resolve the errors and come to a successful conclusion with the network problem. ...
    (microsoft.public.windowsxp.general)
  • Re: Cant establish a network.
    ... The current newsgroup seems to do it about a day after each ... still see the replies coming from other posters in other groups. ... resolve the problem then you should do as you see fit. ... As for the network problem, ...
    (microsoft.public.windowsxp.general)