?
Solved

cannot login to sql management studio on 2011 sbs installation

Posted on 2013-11-07
3
Medium Priority
?
1,172 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
[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
3 Comments
 
LVL 15

Expert Comment

by:unknown_routine
ID: 39631544
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
ID: 39631604
both option are available on login
0
 
LVL 3

Accepted Solution

by:
Sagir87 earned 1200 total points
ID: 39639192
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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
A quick step-by-step overview of installing and configuring Carbonite Server Backup.
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

762 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