Solved

cannot login to sql management studio on 2011 sbs installation

Posted on 2013-11-07
3
1,013 Views
Last Modified: 2013-11-16
hi, I have just installed a 2011 sbs prem via a migration setup from a 2003 sbs prem. the servers are still both in migration format.

We went to move the SQL database from the 2003 to 2011, but cannot login to the sql management studio. it says the username or password is wrong.
We haven't installed SQL server from scratch, It had installed itself from the general setup.

does any one know if Microsoft had setup a default username and password.

please note, I have tried our two admin accounts already.
0
Comment
Question by:total123
3 Comments
 
LVL 15

Expert Comment

by:unknown_routine
Comment Utility
What type of security this server is using. is it windows integrated security or SQL security.

Make sure you use the right credential.
0
 

Author Comment

by:total123
Comment Utility
both option are available on login
0
 
LVL 3

Accepted Solution

by:
Sagir87 earned 300 total points
Comment Utility
hi,

You can reset "sa" password so please follow below steps to reset "sa" password:

http://v-consult.be/2011/05/26/recover-sa-password-microsoft-sql-server-2008-r2/

Also you can change mode of authentication in registry i.e. Windows Authentication OR Mixed mode authentication mode(SQL Server and Windows Authentication mode)  :

HKLM\Software\Microsoft\Microsoft SQl Server\MSSQL10.Instance_Name\MSSQLSERVER
then go to LoginMode and modify to 1 or 2:

1 for Windows Authentication mode
2 for Mixed authentication mode.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

728 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now