Results 1 to 4 of 4

Thread: Moving to a new server

  1. 03-25-2009, 08:31 AM #1
    Picha Pie
    Picha Pie is offline Registered User
    Join Date
    Dec 2003
    Posts
    181

    Moving to a new server

    We're moving to a new SQL Server and server name is new. Is there an automated way to push the new ODBC connection to the network as I have about 150 users?
    Reply With Quote Reply With Quote
  2. 03-25-2009, 08:53 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Try modify registry remotely with some script.
    Reply With Quote Reply With Quote
  3. 03-25-2009, 09:36 AM #3
    Picha Pie
    Picha Pie is offline Registered User
    Join Date
    Dec 2003
    Posts
    181
    Can somebody post the script or point me when to find it?
    Reply With Quote Reply With Quote
  4. 03-25-2009, 04:16 PM #4
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    This is the reason we always have a DNS alias for all databases such as

    dbpubs.abc.com

    that translates to the actual server IP at DNS. Something to keep in mind for future.
    http://databaseandstorage.blogspot.com
    http://gotodba.weebly.com
    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