MEATBALLHERO
asked on
Rename sql2005 Reports Server
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
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
ASKER
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
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
When you renamed you SQL server did you remove your old SPN records and replace them with that of the new SQL server name?
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
So a repair on SQL 2005 fixed the issue?
ASKER
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.
ASKER
I found the answer myself doing google searches.
http://www.karaszi.com/sqlserver/info_change_server_name.asp