Advertisement

04.14.2008 at 06:50AM PDT, ID: 23320287 | Points: 500
[x]
Attachment Details

Problem Backing up SQL 2005 SP2 Databases when machine name has been changed after SQL Install

Tags: Microsoft, SQL Server, 2005 SP2
Recently we implemented a new terminal server that runs Great Plains 10.0 and running SQL 2005 w/ SP2 on there as well.  I want to backup our SQL Server using EMC Retrospect and I already have the agent installed on there.  Originally we had an old terminal server running older versions of Great Plains and SQL 2000 so we since then upgraded and migrated on a new piece of hardware.  Anyways originally during the migration, we had the old terminal server and new terminal server online at the same time:

Old Terminal Server Name = TS2003
New Terminal Server Name = TS2003-NEW

So when the guy was doing our migration, he installed SQL and Great Plains with the TS2003-NEW machine name although our plan was to change it to TS2003 after the migration was complete and the old TS2003 was decommissioned.   Once the old one was put out of production, we changed the machine name of the new terminal server to TS2003.  The problem occurs when I try to backup the SQL Server, I can license it through Retrospect and it sees there is a DB there although I cannot authenticate with Retrospect either by Windows Authentication or SQL Authentication.  We diagnosed the problem referencing the old machine name by clearing the report log, then trying to re-authenticate to the TS2003 and within the error I saw it was trying to reference the machine name TS2003-NEW.

T-2: TWDBSqlServer::Init: Connect() failed [0x80040000]:[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
T-2: TWDBSqlServer::InitDMO: connection failed to instance: 'TS2003NEW', username: 'administrator'
                vlocQuitHook: DK_DRMODE is false.
                Exit at 4/10/2008 3:06 PM

Then I figured there's gotta be a reference to TS2003-NEW in the registry so I go into regedt32 and go to find and select everything and searched for TS2003-NEW
The following keys referenced TS2003-NEW
-      HKLM/Software/Microsoft/Microsoft SQL Server/90/Machines
                 o      Original Machine Name = TS2003-NEW
-      HKLM/Software/Microsoft/Services/Report Server
                o      Group Prefix = SQLServer2005ReportUser$TS2003-NEW$
-      HKLM/Software/Microsoft/Services/SSIS
                 o      Group Prefix = SQLServer2005DTSUser$TS2003-NEW
-      HKLM/Software/Microsoft/MSSQL Server/Client/SNI9.0/Last Connect
                o      TS2003-NEW = -1040187384:LPC:TS2003-NEW

Any of these keys need to be changed in the registry to fix this issue so the software see's the database under TS2003 name instead of TS2003-NEW?
Start your free trial to view this solution
Question Stats
Zone: Storage
Question Asked By: skidogg24
Question Asked On: 04.14.2008
Participating Experts: 2
Points: 500
Views: 0
Translate:
Loading Advertisement...
04.14.2008 at 07:36AM PDT, ID: 21350363

Rank: Sage

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
04.14.2008 at 08:41AM PDT, ID: 21350974

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
04.17.2008 at 07:26AM PDT, ID: 21377421

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
04.17.2008 at 07:54PM PDT, ID: 21382995

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
04.18.2008 at 12:05AM PDT, ID: 21383763

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
04.20.2008 at 07:31PM PDT, ID: 21398423

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
Loading Advertisement...
Microsoft
  • Internet Protocols
  • Applications
  • Development
  • OS
  • Hardware
  • Windows Security
Apple
  • Operating Systems
  • Hardware
  • Programming
  • Networking
  • Software
Internet
  • Search Engines
  • File Sharing
  • WebTrends / Stats
  • Spy / Ad Blockers
  • Web Browsers
  • New Net Users
  • Web Development
  • Chat / IM
  • Anti Spam
  • Web Servers
  • Anti-Virus
  • Email Clients
Gamers
  • Tips
  • Online / MMORPG
  • Puzzle
  • Emulators
  • Action / Adventure
  • Role Playing
  • Consoles
  • Game Programming
  • Strategy
  • Sports
  • Misc
  • Computer Games
Digital Living
  • Hardware
  • New Net Users
  • New Users
  • Software
  • Digital Music
  • Gaming World
  • Home Security
  • Apple
  • Networking Hardware
Virus & Spyware
  • Vulnerabilities
  • IDS
  • Encryption
  • Anti-Virus
  • Operating Systems Security
  • Software Firewalls
  • WebApplications
  • Cell Phones
  • Operating Systems
  • Internet
  • Hardware Firewalls
Hardware
  • Handhelds / PDAs
  • Displays / Monitors
  • Components
  • Networking Hardware
  • Peripherals
  • Laptops/Notebooks
  • Storage
  • Servers
  • Desktops
  • New Users
  • Misc
  • Apple
Software
  • System Utilities
  • Industry Specific
  • Network Management
  • Photos / Graphics
  • Page Layout
  • VMWare
  • Misc
  • Web Development
  • OS
  • CYGWIN
  • Voice Recognition
  • Message Queue
  • Quality Assurance
  • Security
  • Firewalls
  • MultiMedia Applications
  • Development
  • Database
  • Office / Productivity
  • Business Management
  • OS/2 Apps
  • Server Software
  • Internet / Email
ITPro
  • OS
  • Storage
  • Encryption
  • Operating Systems Security
  • Apple Hardware
  • Laptops & Notebooks
  • Servers
  • Networking Hardware
  • Peripherals
  • Devices
  • Displays / Monitors
  • WebTrends / Stats
  • Search Engines
  • Firewalls
  • WebApplications
  • IDS
  • Vulnerabilities
  • Email Clients
  • File Sharing
  • Spy / Ad Blockers
  • Web Browsers
  • Web Servers
  • Networking
  • Anti-Virus
  • Chat / IM
  • Anti Spam
Developer
  • Web Servers
  • Web Browsers
  • Game Programming
  • Dev Tools
  • Industry Specific
  • Office / Productivity
  • Database
  • CYGWIN
  • Web Development
  • Search Engines
  • File Sharing
  • WebTrends / Stats
  • Programming
  • Content Management
  • Application Servers
  • Protocols
Storage
  • Removable Backup Media
  • Storage Technology
  • Servers
  • Grid
  • Remote Access
  • Backup / Restore
  • Misc
  • Hard Drives
OS
  • Miscellaneous
  • Security
  • Development
  • Linux
  • VMWare
  • MainFrame OS
  • Unix
  • Apple
  • OS / 2
  • AS / 400
  • BeOS
  • Microsoft
  • VMS / OpenVMS
Database
  • Oracle
  • Miscellaneous
  • MySQL
  • Software
  • Sybase
  • Contact Management
  • PostgreSQL
  • Data Manipulation
  • Clarion
  • InterSystems Cache
  • Siebel
  • MUMPS
  • OLAP
  • SQLBase
  • SAS
  • GIS & GPS
  • 4GL
  • Berkeley DB
  • DB2
  • Informix
  • Interbase / Firebird
  • FoxPro
  • Reporting
  • LDAP
  • Filemaker Pro
  • MS SQL Server
  • dBase
  • MS Access
Security
  • Misc
  • Web Browsers
  • Software Firewalls
  • Operating Systems Security
  • File Sharing
  • Spy / Ad Blockers
  • Vulnerabilities
  • WebApplications
  • IDS
  • Anti-Virus
  • Encryption
  • Anti Spam
  • Email Clients
  • VPN
  • Chat / IM
Programming
  • Editors IDEs
  • Installation
  • Handhelds / PDAs
  • Multimedia Programming
  • System / Kernel
  • Algorithms
  • Game
  • Signal Processing
  • Project Management
  • Open Source
  • Database
  • Misc
  • Languages
  • Processor Platforms
  • Theory
Web Development
  • Scripting
  • Blogs
  • Web Servers
  • Software
  • Search Engines
  • Web Graphics
  • Images
  • Internet Marketing
  • Images and Photos
  • Components
  • Document Imaging
  • Web Languages/Standards
  • Illustration
  • WebApplications
  • Fonts
  • WebTrends / Stats
  • Authoring
  • Digital Camera Software
  • Miscellaneous
Networking
  • Protocols
  • Apple Networking
  • Network Management
  • Message Queue
  • Application Servers
  • Content Management
  • File Servers
  • Email Servers
  • Misc
  • Java Editors & IDEs
  • Wireless
  • Networking Hardware
  • Backup / Restore
  • System Utilities
  • ISPs & Hosting
  • Web Servers
  • Storage Technology
  • Removable Backup Media
  • Servers
  • Broadband
  • Grid
  • OS / 2
  • Novell Netware
  • Unix Networking
  • Windows Networking
  • Security
  • Telecommunications
  • Operating Systems
  • Linux Networking
Other
  • Community Advisor
  • Lounge
  • Community Support
  • New Net Users
  • Philosophy / Religion
  • Math / Science
  • Miscellaneous
  • URLs
  • Expert Lounge
  • Politics
  • Puzzles / Riddles
Community Support
  • Suggestions
  • New to EE
  • New Topics
  • Community Advisor
  • CleanUp
  • Announcements
  • General
  • Feedback
  • Input
  • EE Bugs
 
04.14.2008 at 07:36AM PDT, ID: 21350363

Rank: Sage

After changing a machine name if you run the setup again it should detect the change and correct the entries.
You may also have to change the entry in sysservers.
 
04.14.2008 at 08:41AM PDT, ID: 21350974
well what if i can't really re-run setup again?  

How do i change that in sysservers?
 
04.17.2008 at 07:26AM PDT, ID: 21377421
If you do a Select @@servername do you get the new servername or old servername.

If it is the oldname you need to register the servername again.

Use Master
go
Sp_DropServer 'OldName'
GO
Use Master
go
Sp_Addserver 'NewName', 'local'
GO
 
04.17.2008 at 07:54PM PDT, ID: 21382995
how do i do that?  where do i do that at, in the query analyzer?
 
04.18.2008 at 12:05AM PDT, ID: 21383763
Yes, Open up query analyzer. Select your master database.
add this
select @@servername

If it displays the old name of your server run the following to register the new server name on SQL

Use Master
go
Sp_DropServer 'OldName'
GO
Use Master
go
Sp_Addserver 'NewName', 'local'
GO
 
04.20.2008 at 07:31PM PDT, ID: 21398423
it shows the new server name under that.  It must be something else
 
 
20080236-EE-VQP-29 / EE_QW_2_20070628