Solved

Rename sql2005 Reports Server

Posted on 2013-12-03
8
248 Views
Last Modified: 2013-12-09
I'm trying to upgrade my SQL 2005 server to service pack 2 and I am getting authentication errors for Log in. I changed my server name and it appears my old Instance name is still showing up in some places. See attached PDF.

HQVSDB02 is my old server name. My new Server name is SQLSERVER.

I notice the localSQL account users have old server name in them as well. How do i resolve this.

When i try to connect to report configuration it cant find any report server either. I restarted computer and all services are running.
Wrong-Instance-Name.pdf
0
Comment
Question by:MEATBALLHERO
  • 4
  • 2
  • 2
8 Comments
 
LVL 17

Expert Comment

by:dbaSQL
ID: 39694582
0
 

Author Comment

by:MEATBALLHERO
ID: 39695540
I did this already.

EXEC sp_dropserver '<old_name>'
GO
EXEC sp_addserver '<new_name>', 'local'
GO

The problem is with LOGIN when trying to update service packs. Windows authentication doesn't work and neither does SA password during the install.

However SA password and windows authentication works when I log into SQL Server Management Studio.

See error in new photo attached when applying update.

I also get this error Next to the component.
HResult 0x35,Level 16, State 1 Named Pipes Provider: Could not open a connection to SQL Server [53]. Sqlcmd: Error: Microsoft SQL Native Client: An error has occurred while establishing a c...

Help File says:
If authentication fails, update the information for the component, and then retry the verification test. When all components are listed in the table, and all have a "Success" status, click Next to continue.

How do I update reports server component? HQVSDB02 is my old servers name.
SQL-Login-Error.pdf
0
 
LVL 19

Expert Comment

by:compdigit44
ID: 39697135
When you renamed you SQL server did you remove your old SPN records and replace them with that of the new SQL server name?
0
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
LVL 17

Expert Comment

by:dbaSQL
ID: 39697240
Please take a look at this.  
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/3d8d57fd-e750-4646-a409-4fe4eb3db21f/cant-install-sp2?forum=sqlsetupandupgrade

Looks a lot like the errors you've noted, with that user's solution posted at this time by Mike DePouw:   Tuesday, March 20, 2007 3:36 PM
0
 

Accepted Solution

by:
MEATBALLHERO earned 0 total points
ID: 39697464
I found the answer that solved all the problems.

http://technet.microsoft.com/en-us/library/ms143697%28v=sql.90%29.aspx
0
 
LVL 19

Expert Comment

by:compdigit44
ID: 39698050
So a repair on SQL 2005 fixed the issue?
0
 

Author Comment

by:MEATBALLHERO
ID: 39698253
Went to add remove programs. Hit change. Uninstalled reports server that was my only option. It did not allow me to repair. Then I ran it again and reinstalled. All works great now.
0
 

Author Closing Comment

by:MEATBALLHERO
ID: 39705734
I found the answer myself doing google searches.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This script can help you clean up your user profile database by comparing profiles to Active Directory users in a particular OU, and removing the profiles that don't match.
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question