Get the App
SLTechnology News&Howtos  ›  Internet Technology  › 

After the server of the sqlserver database is renamed, the database login is not on the solution.

Shulou Source: shulou.com Published: 2022-06-03 06:55:52 11月23日 Update

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

Tags: Computer data database login name query input information question authentication name method label transfer Zhongxin path classification comment run scheme Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno MariaDB Apple vpn Linux Huawei