SQL Server Mgmt Studio Change Back to Windows Auth -
1st time user sql server , after logged in 2012 management studio using windows authentication worked expected. while open, attempted change sql sever auth within properties. want go windows auth, cannot connect server management studio.
i don't want have go through painful process of uninstalling , reinstalling, option?
not understood question, believe first logged in ssms using windows authentication , when open changed sql server authentication , want connect again windows, if case click on highlighted area , in authentication click windows authentication provided in screenshot below. please correct me if understanding wrong!!
if connecting not problem go through following links , may useful
https://msdn.microsoft.com/en-in/library/ms188670.aspx
http://blogs.adobe.com/livecyclehelp/2013/08/sql-server-in-windows-authentication-mode.html
Comments
Post a Comment