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>Search


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


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

Publication Date:  2012-09-24 Views:  114 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


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.