Results 1 to 4 of 4

Thread: problem with renaming SQL server

  1. 10-16-2006, 10:54 AM #1
    jannat
    jannat is offline Registered User
    Join Date
    Oct 2002
    Location
    queens
    Posts
    139

    problem with renaming SQL server

    I am experiencing a big problem with my prod server.I renamed my production server as my test sever (abc) and the test server to (xyz) in sql 2000.

    Now, when I connect from my test server to my prod server, it does not seem to see the new server even I put the new server name. It still sees the databases what is in the test server, not the new server databases.

    How can I resolve this?

    Please help. Thank you all.
    Reply With Quote Reply With Quote
  2. 10-16-2006, 01:59 PM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Run 'select @@servername' on both servers to see what you get.
    Reply With Quote Reply With Quote
  3. 10-16-2006, 02:25 PM #3
    jannat
    jannat is offline Registered User
    Join Date
    Oct 2002
    Location
    queens
    Posts
    139
    I get correct names in both servers..
    Reply With Quote Reply With Quote
  4. 10-16-2006, 02:32 PM #4
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Which netlib do you use to connect to sql server? Any connection string involved? Did you check DNS and/or Wins for ip address mappings?
    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