?
Solved

Rename sql2005 Reports Server

Posted on 2013-12-03
8
Medium Priority
?
257 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

Here's a look at newsworthy articles and community happenings during the last month.
In the absence of a fully-fledged GPO Management product like AGPM, the script in this article will provide you with a simple way to watch the domain (or a select OU) for GPOs changes and automatically take backups when policies are added, removed o…
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…
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 …
Suggested Courses

649 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