Open SQL Management Studio, change to Windows Authentication and click Connect.Left list box, select "Server Roles" then in the right list boxĬheck boxes you want to have as server roles. ![]() Right click "Logins" > click New Userīutton and scroll for your Windows account.Īccount, double click, then click OK on both "Select User or Group"ĭialogs but leave the "New User" dialog window open. Delete your Windows account login from SQL Server logins.This is imperative so you do not lock yourself out of My intention is to just let my local windows user be authenticated but I am not totally sure how to do that. IMPORTANT: Login to SQL using SQL Server Authentication with username 'sa'. I've just installed SQL Server 2008 and I cannot connect to it with SQL Server Management Studio.The name of the server is SQL2008 and the instance name of the SQL Server is SQL2008DATA. Reboot if you changed either, not sure if this is needed but it will reinitialize all registry hives. I have installed SQL Server R2 on Windows Server 2008 R2 in a development environment.To change Full Name, double click the Name, and to the properties dialog then change the Full Name value.To change Name, right click then on the context menu click Rename. ![]() Make sure both your both columns (Name and Full ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |