Solved

Problem Connecting to Database Engine in SQL Server 2005

Posted on 2011-09-20
5
153 Views
Last Modified: 2012-05-12
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
Comment
Question by:Tyecom
5 Comments
 
LVL 3

Expert Comment

by:chandrasekar1
Comment Utility
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
 
LVL 8

Accepted Solution

by:
venk_r earned 500 total points
Comment Utility
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
 

Author Comment

by:Tyecom
Comment Utility
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
 

Expert Comment

by:praveen42522003
Comment Utility
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
 

Author Closing Comment

by:Tyecom
Comment Utility
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

Featured Post

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now