Tyecom
asked on
Problem Connecting to Database Engine in SQL Server 2005
Just installed MS SQL Server 2005. During setup, I selected use Windows Authenication mode to connect to the database engine. After launching SQL, I can't connect because it says I'm not authorized to connect. Do I have to do a re-install?
Go to MS SQL configuration manager and check the SQL Server engine it running or not, if it’s running then try login using “.\(instance name)” which is given in the screen shot.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you responding. Using the *.\(instance) did not work. Said something about problem connecting to a remote server. I will do a re-install and make sure I select the mixed mode authentication option. Will let you know how it turned out. Thanks again.
Make sure that SQL Server engine is up and running. if its not running make it to run by changing the properties. once it is started use . as username and try to run. it will work
ASKER
Had to do a re-install and set the proper properties during setup. After installing, used SA account to make myself a SA under server role and everything worked fine. Thanks