Solved

cannot login to sql management studio on 2011 sbs installation

Posted on 2013-11-07
3
1,070 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
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 300 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
sql help 8 55
Alter a column in sql 34 30
SQl Server 2012 r2 - Why temp table shrinks from large query 4 37
SBS 2008 RDP Gateway works on from Windows 10 5 29
If you are a user of the discontinued Microsoft Office Accounting 2008 (MSOA) and have to move to a new computer running Windows 8, you will be unhappy to discover that it won't install.  In particular, Microsoft SQL Server 2005 Express Edition (SSE…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

777 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