Solved

Rename sql2005 Reports Server

Posted on 2013-12-03
8
251 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 20

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
Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

 
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 20

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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

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 describes my battle tested process for setting up delegation. I use this process anywhere that I need to setup delegation. In the article I will show how it applies to Active Directory
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

749 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