Register new Server Name in Sql Managment Studio

2019-07-31 17:03发布

问题:

i want to know is there anyway to register new server in SqlServer Managment Studio??Except the General way in Managment Studio

my Master said there is a Way but i forgot to ask him??(i know we can register new server name in Sql Managment studio by Right click on Current ServerName and click Register but some body say its not a good way to register)

Now i have a server name with windows authentication Security,is there anyway to create a Server Name with user pass(without uninstalling Sql Server)

回答1:

Press CTRL + ALT + G, this will show the registered servers window, now add a new server group, then add it there or just add the server under the main folder. You do this by right clicking on the group and selecting New Server Registration



回答2:

in the link below i uploaded the pics for changing from windows authentication to sql server authentication:

change windows authentication to sql authentication