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

cannot login to 2008 SQL management studio

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
fessiambre
Asked:
fessiambre
4 Solutions
 
dtranceCommented:
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
 
fessiambreAuthor Commented:
yes i am using windows authentication
0
 
Jeremy WeisingerSenior Network Consultant / EngineerCommented:
What version of SQL are you using?
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
fessiambreAuthor Commented:
2008 r2
0
 
grossacCommented:
Try using the server name and/or the instance name:

youservername\yourinstancename
0
 
WizillingCommented:
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
 
fessiambreAuthor Commented:
trying hold on please
0
 
fessiambreAuthor Commented:
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
 
WizillingCommented:
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
 
Anthony PerkinsCommented:
>>
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
 
fessiambreAuthor Commented:
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
 
fessiambreAuthor Commented:
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
 
fessiambreAuthor Commented:
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
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

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

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