Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 624
  • 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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