Login Issue
-
Thursday, January 10, 2013 12:27 PMDear Members,
I need to discuss about issues with sql server 2008 R2. I have just installed windows server 2011 SBS. Found that it have installed sql server 2008 R2 at the time of windows installation without asking any question regarding SQL 2008.
Now i am unable to login through either windows authentication mode or SQL server authentication.
I have tried login sa account with following password.
- <blank>
- Admin@123
- admin@123
- sql@123
Can any one help me out with issue mentioned above.
All Replies
-
Thursday, January 10, 2013 1:10 PM
if you are facing problem in login then
Start the SQL Server in SIngle user mode by changing the parameters of the start up parameters wiht -m, check the image attached
then try to access the sql server using sql server management studio
Ramesh Babu Vavilla MCTS,MSBI
-
Thursday, January 10, 2013 1:10 PM
if you are facing problem in login then
Start the SQL Server in SIngle user mode by changing the parameters of the start up parameters wiht -m, check the image attached
then try to access the sql server using sql server management studio
Ramesh Babu Vavilla MCTS,MSBI
-
Thursday, January 10, 2013 2:45 PM
Check Services.msc to confirm SQL Services are runing or not?
Share the error message you are facing.
Regards,
Rohit Garg
(My Blog)
This posting is provided with no warranties and confers no rights.
Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread. -
Thursday, January 10, 2013 4:14 PM
I may be confused but it looks like you are trying to guess the password of the sa account. Which might not even be enabled.
When logged into Windows as an administrator, try connecting to SQL Server using Windows Authentication.
If that doesn't work, start SQL Server Management Studio using the Run as administrator option, and then try connecting to SQL Server using Windows Authentication.
Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty
- Proposed As Answer by Fanny LiuMicrosoft Contingent Staff, Moderator Monday, January 14, 2013 6:02 AM
- Marked As Answer by Allen Li - MSFTModerator Friday, January 18, 2013 2:03 AM
-
Monday, January 14, 2013 1:00 AMHi there, open SQL server configuration manager. select sqlserver 20XX servicess. Make sure all are running. under log on as there will be accounts you can use those accounts to login. and you can create new users and use those accounts, if you are not sure about any other accounts. thanks kumar
.png)
