Solved

Rename sql2005 Reports Server

Posted on 2013-12-03
8
243 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
 
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
Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

 

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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Introduction You may have a need to setup a group of users to allow local administrative access on workstations.  In a domain environment this can easily be achieved with Restricted Groups and Group Policies. This article will demonstrate how to…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles from a Windows Server 2008 domain controller to a Windows Server 2012 domain controlle…
This tutorial will walk an individual through the process of configuring their Windows Server 2012 domain controller to synchronize its time with a trusted, external resource. Use Google, Bing, or other preferred search engine to locate trusted NTP …

708 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now