No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>

Reminder

To have a better experience, please upgrade your IE browser.

upgrade

The problem that displaying failure of connecting isql database when install network management as host name modified

Publication Date:  2012-09-24 Views:  39 Downloads:  0
Issue Description
Install Windows network management, display that use isql to connect database in failure, lead to network installation cannot continue.
Alarm Information
none
Handling Process
Delete the old host name of master.. Sysservers, and add new host name.
The implement script is as follows:

Sp_dropserver @ server = 'old host name'

Sp_addserver @ server = 'new host name'
Root Cause
After SQLServer installation, modify the machine host name, but the SQLServer master.. Sysservers table still keeps the old host name, fail to connect the master.. sysservers name used by installation disk.
Suggestions
none

END