Solved

Problem Connecting to Database Engine in SQL Server 2005

Posted on 2011-09-20
5
160 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 3

Expert Comment

by:chandrasekar1
ID: 36568851
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
ID: 36568873
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
ID: 36569212
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
ID: 36576756
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
ID: 36817371
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

696 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