Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2004
    Posts
    9

    Unanswered: registering MSDE 2000 FROM SQL 2000

    Hi There,

    I have install msde in one computer and try to register from my sql server, the following error message is coming.

    A connection could not be established to Cal-itimilsina (computer in which MSDE IS INSTALLED)

    RESON: SQL SERVER DOES NOT EXIST OR ACCESS DENIED

    CONNECTIONOPEN(CONNECT())

    ====

    BUT THE MSDE IS RUNNING IN THE CLIENT MACHINE. Could any one please help me

    Thanks.

    Indra.

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Check this site, but in short, - Named Pipes is not supported on MSDE. You need to create an alias on your server for MSDE instance using TCP/IP protocol, and specify the alias during server registration in EM. You can also use the IP address for registration.

  3. #3
    Join Date
    Jan 2004
    Posts
    9
    Thanks, i will have a check now.

  4. #4
    Join Date
    Jan 2004
    Posts
    9
    Hi,

    I setup alias with TCP/IP and try to connect with alias name as well with tcp/ip, but same error message is comming. by the way what cold be my instance, i just install msde with setup.exe from command prompt.

    thanks for help

  5. #5
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Type "OSQL -L" in command window.

  6. #6
    Join Date
    Jan 2004
    Posts
    9
    Originally posted by rdjabarov
    Type "OSQL -L" in command window.
    it display the name of the sql server available inthe network.

Posting Permissions

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