I have a SQL 2005 and Reporting Servince installed on Win 2003. The server was named as 'WSOS' when install. I've changed it to 'SSA' after. Everything seems OK except can not connect to reporting service in SSMS. The error message is :
The remote name could not be resolved: WSOS
I try adjust reporting service configuration tools, still showing me the same error msg. How come it still looking for old name but not the new name
Any idea will be appreciate.
server name can not resolved after rename server
Ltl Hawk
1. Use sp_dropserver and sp_addserver to remove the old server name and insert the new server name into sys.sysservers.
2. Update the server name in rsreportserver.config
3. Use the Configure Report Server utility and select the Database Connection option. Notice how the Server Name is set to the old server name. Use the dropdown list to select the new server name.
4. Restart the SQL Server Reporting Services service.
4. Use the Configure Report Server utility and select the Encryption Keys option. Delete the existing key. Notice how the dialog box shows the old server name. Click the Change button to create a new key. Notice how the new server name appears in the dialog box.
ihendry01
DiasVFX
from booksonline:(sp_addserver)
SQL Server Setup sets this variable to the computer name during installation. We recommend that the name not be changed. By default, the computer name is the way users connect to an instance of SQL Server without requiring additional configuration.
anyone tell me will the server down if I update sysservers directly