• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 172
  • Last Modified:

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?
0
Tyecom
Asked:
Tyecom
1 Solution
 
chandrasekar1Commented:
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.  Mssql Connection Error
0
 
venk_rCommented:
May be the windows user doesnt have a local admin rights.if your'e in a domain then check the domain user permissions.
if neither doesnt work  reinstall with mixed mode authentication and will be able to connect with a valid login.
0
 
TyecomAuthor Commented:
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.
0
 
praveen42522003Commented:
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
0
 
TyecomAuthor Commented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now