Can't use 'local' to find sql server instances on local machine

Discussion in 'ASP .Net' started by karim, Jun 26, 2003.

  1. karim

    karim Guest

    My computer (connected to a domain) is having trouble connecting to the
    local MSDE when using 'local' or '(local)' as server name. The only way I
    can connect to server through Visual Studio or DTS in Enterprise manager is
    when using domainname\localcomputername format. Also when I try to install
    the starter kits from asp.net, the installer in each kit fails to find sql
    server instances. I am pretty sure it's related to fact the installer is
    probably using 'local' or a derivative for the local server name which does
    not work.

    Any ideas?

    Karim
     
    karim, Jun 26, 2003
    #1
    1. Advertising

  2. There is always option to run SQL scripts manually.
    It's documented in the readme file. I recal i did not have any problem.

    George.

    "Greg Burns" <> wrote in message
    news:...
    > If you installed the MSDE version for Visual Studios is doesn't create a
    > "default instance" of MSDE. The instance name is something like,
    > computername\VSdotNET. (SQL server 2000 allows multiple instances to be
    > installed and running on one computer).
    >
    > I remember I had the same problem trying to install the starter kits on my
    > computer prior to installing a default instance. Maybe somebody could chip
    > in, as to how to install the starter kits to a named instance.
    >
    > BTW, if you install MSDE from the SQL SP3 desktop patch it installs as the
    > default instance.
    >
    > HTH,
    > Greg
    >
    >
    >
    > "karim" <> wrote in message
    > news:...
    > >
    > > My computer (connected to a domain) is having trouble connecting to the
    > > local MSDE when using 'local' or '(local)' as server name. The only way

    I
    > > can connect to server through Visual Studio or DTS in Enterprise manager

    > is
    > > when using domainname\localcomputername format. Also when I try to

    install
    > > the starter kits from asp.net, the installer in each kit fails to find

    sql
    > > server instances. I am pretty sure it's related to fact the installer is
    > > probably using 'local' or a derivative for the local server name which

    > does
    > > not work.
    > >
    > > Any ideas?
    > >
    > > Karim

    >
    >
     
    George Ter-Saakov, Jun 26, 2003
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. =?Utf-8?B?UmV6YQ==?=
    Replies:
    3
    Views:
    18,023
    Carlos Barini
    Jun 7, 2004
  2. Otis Mukinfus
    Replies:
    3
    Views:
    949
    Juan T. Llibre
    Jul 8, 2005
  3. Rehman
    Replies:
    1
    Views:
    841
    Thomas Weidenfeller
    Mar 8, 2006
  4. John Wohlbier
    Replies:
    2
    Views:
    391
    Josiah Carlson
    Feb 22, 2004
  5. Replies:
    8
    Views:
    482
    James Stroud
    Jan 29, 2009
Loading...

Share This Page