Solved

Rename sql2005 Reports Server

Posted on 2013-12-03
8
252 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
Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

 
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

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

Active Directory security has been a hot topic of late, and for good reason. With 90% of the world’s organization using this system to manage access to all parts of their IT infrastructure, knowing how to protect against threats and keep vulnerabil…
Recently, Microsoft released a best-practice guide for securing Active Directory. It's a whopping 300+ pages long. Those of us tasked with securing our company’s databases and systems would, ideally, have time to devote to learning the ins and outs…
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 …
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.

726 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