Professional Web Applications Themes

Can't use 'local' to find sql server instances on local machine - ASP.NET General

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...

  1. #1

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


    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 Guest

  2. #2

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

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

    George.

    "Greg Burns" <greg_burnshotmail.com> wrote in message
    news:eEIQtbCPDHA.3836tk2msftngp13.phx.gbl...
    > 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" <karim341111yahoo11.com> wrote in message
    > news:51d7328dd12955b6cb66750b28df488bfree.teranew s.com...
    > >
    > > 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 Guest

Similar Threads

  1. filecopy from remote machine to local machine
    By anu in forum PERL Modules
    Replies: 5
    Last Post: February 8th, 03:49 PM
  2. .htc file on a not local machine ??
    By mrVithan in forum ASP.NET Web Services
    Replies: 0
    Last Post: March 16th, 05:55 AM
  3. Replies: 2
    Last Post: June 17th, 12:08 AM
  4. SSL on local machine...
    By Paul M in forum ASP.NET Security
    Replies: 1
    Last Post: December 5th, 11:05 AM
  5. Replies: 0
    Last Post: July 28th, 09:23 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139