After the server of the sqlserver database is renamed, the database login is not on the solution.
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