Results 1 to 4 of 4

Thread: unable to connect to sql server

  1. 11-20-2003, 01:08 AM #1
    bhavna
    bhavna is offline Registered User
    Join Date
    Jul 2003
    Posts
    23

    unable to connect to sql server

    recently i made my PC dual boot by installing windows 2000 advanced server. It already had win2000 profesional installed on it. since then i have been unable to connect to sql server running on some other server(called CONTROLS) on the LAN. I am able to access the CONTROLS server thru 'my networkplaces' and able to see all its hsared directories and access htem. but when i open Enterprise manager i cannot connect to CONTROLS.
    Please help me . i have already wasted 2 days over it.
    Reply With Quote Reply With Quote
  2. 11-20-2003, 07:04 AM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Try odbcping to check if you can see the database.

    Also check protocols enabled on your pc using sql client network utility. make sure you have at least named pipe or tcp/ip enabled.
    Reply With Quote Reply With Quote
  3. 11-20-2003, 10:57 PM #3
    bhavna
    bhavna is offline Registered User
    Join Date
    Jul 2003
    Posts
    23
    thank you skhanal
    but later what i found was when i created a new user account in NT domain of 'CONTROLS' server i was able to connect thru that login.
    Reply With Quote Reply With Quote
  4. 11-21-2003, 08:57 AM #4
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Should be able to connect with sql authentication.
    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