Solved

cannot login to sql management studio on 2011 sbs installation

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

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

Question has a verified solution.

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

Because virtualization becomes more and more common, and, with Microsoft Hyper-V included in Windows Server at no additional costs, and, most server hardware nowadays is more than capable of running a physical Small Business Server (SBS) 2008 or 201…
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…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

737 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