Shulou(Shulou.com)06/03 Report--

After the computer name is modified, sqlserver original windows authentication cannot log in

Tag: database

2016-09-26 15:04 1491 people Read comments (1) Favorite Report

Category: DB Road--sqlserver (3)

After the computer renamed, SQL database can not log on to the problem solution.

1. Log in with sa

database is master.

select from sys.sysservers

A query reveals that the database still retains the previous computer name

2. Enter the information below to delete the login with the original computer name

EXEC sp_dropserver "Original computer name"

Select from sys.sysservers

After verification, it can be found that the information has not been found.

3. Input: EXEC SP_ADDSERVER "name of computer after change","LOCAL"

After clicking Run, you can find that the computer has changed after querying.

Restart and the problem will be solved.

From blog.csdn.net/love_zt_love/article/details/7175829

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.