Results 1 to 4 of 4

Thread: Multiple instances

  1. 03-06-2003, 02:27 PM #1
    knicholson
    knicholson is offline Registered User
    Join Date
    Sep 2002
    Posts
    51

    Multiple instances

    I created a second SQL2000 instance on a Windows 2000 server. The strange thing is that I can create an ODBC connection to the default instance but cannot for the new named instance. If I try from a client that has SQL installed on it, I can see both instances. Any idea why this is happening?

    Thanks,
    Ken Nicholson
    Reply With Quote Reply With Quote
  2. 03-06-2003, 03:31 PM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Did you input host\instance as server name in dsn?
    Reply With Quote Reply With Quote
  3. 03-06-2003, 03:53 PM #3
    knicholson
    knicholson is offline Registered User
    Join Date
    Sep 2002
    Posts
    51
    Yes.
    Reply With Quote Reply With Quote
  4. 03-06-2003, 04:23 PM #4
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    If use tcp/ip netlib, should check 'dynamically determine port'.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules