Solved

cannot login to 2008 SQL management studio

Posted on 2011-03-07
13
614 Views
Last Modified: 2012-05-11
Hi experts I am the domain admin and I cannot login to the sqo management, it tells me
Login failed for user 'ALLIANCESTRATA\administrator'. (.Net SqlClient Data Provider)
Cannot connect to (local).
please help
BTW i am using the correct password!
0
Comment
Question by:fessiambre
[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
13 Comments
 
LVL 3

Accepted Solution

by:
dtrance earned 125 total points
ID: 35060974
Did you install it using both Windows Authentication and SQL Server authentication?  If so make sure you are using "Windows Authentication" in the initial log in window.
0
 

Author Comment

by:fessiambre
ID: 35060996
yes i am using windows authentication
0
 
LVL 18

Expert Comment

by:Jeremy Weisinger
ID: 35061067
What version of SQL are you using?
0
Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

 

Author Comment

by:fessiambre
ID: 35061073
2008 r2
0
 
LVL 2

Assisted Solution

by:grossac
grossac earned 125 total points
ID: 35061083
Try using the server name and/or the instance name:

youservername\yourinstancename
0
 
LVL 13

Assisted Solution

by:Wizilling
Wizilling earned 125 total points
ID: 35061100
Hi by default - builtin administartors dont have access to sql server like the previous versions of sql.
Were you able to log in before - and using the same username?
ALLIANCESTRATA\administrator - is this the domain account or the local account?
do you have sa password to the sql server. can you login using sa and check if the user ALLIANCESTRATA\administrator has sysadmin on the sql server.
0
 

Author Comment

by:fessiambre
ID: 35061232
trying hold on please
0
 

Author Comment

by:fessiambre
ID: 35061354
alliancestrata\administrator is the domain account
i do not know what the password is for the sql sa account
i have tried to logiin as domain admin and everything else
0
 
LVL 13

Expert Comment

by:Wizilling
ID: 35063408
were you able to log on to this server before?
are you trying to connect from the management studio from the same sql server box?
try connecting to localhost
0
 
LVL 75

Assisted Solution

by:Anthony Perkins
Anthony Perkins earned 125 total points
ID: 35063563
>>
BTW i am using the correct password!
...
yes i am using windows authentication
<<

Can we back up, please?  These two statments contradict each other.  Can you tell us whether you are using:
A. Windows Authentication and you are therefore not entering a password or
B. SQL Server Authentication and you are entering a login name and password?
0
 

Author Comment

by:fessiambre
ID: 35073384
Sorry A:) windows Authentication.
I have been able to login to the server before with the same username and password
it is not working now. the user has not been changed nor the password.
is there another account i can use. why doesnt the admin have the power to change this?
0
 

Author Comment

by:fessiambre
ID: 35073641
ok i reset the users password and i got into the sql server but i cannot backup the database as the ok button stays greyed out any thoughts
0
 

Author Comment

by:fessiambre
ID: 35076730
well i have gotten in removed the sql and reinstalled i will split points between users as all of you helped thanks alot guys
0

Featured Post

Enroll in June's Course of the Month

June’s Course of the Month is now available! Experts Exchange’s Premium Members, Team Accounts, and Qualified Experts have access to a complimentary course each month as part of their membership—an extra way to sharpen your skills and increase training.

Question has a verified solution.

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

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how the fundamental information of how to create a table.

705 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