asked on

SQL 2008 R2 Mixed Mode Auth Login Username

Heyas,

I just installed SQL server and I chose mixed auth during the install. I only specified the password during the install where would I find the username I supposed to use. Refer to screenshot below

Thank you.
Capture3.PNG

John Jennings

Using mixed mode authentication, you have two options:

1. You can sign in using your windows username and password.

example: domain\username

2. You can use the "SQL Admin" account and SQL authentication.

example: default sql admin account is called "sa" - but that in user field.

So, either login with your Windows credentials, or login with user "sa" and the password you specified.

Anuj

The password you specified at the time of installation is for 'SA' Account, the is a default system admin account comes with SQL Server and has all permissions. So choose "sa" in the username, and the password is the one you provided during setup.

Vijaya Reddy Pinnapa Reddy

Usename is sa

Zack

ASKER

HI guys tried not working any other ideas.

Thank you.

ASKER CERTIFIED SOLUTION

TI2Heaven

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

John Jennings

You really should just sign in with Windows authentication. Use the account that you were signed in as when you installed SQL.

Using SQL authentication is best reserved for applications themselves.

Zack

ASKER

Cheers man that fixed it.

Additionally here is a great post that explains the issue in detail.

http://www.dekho.com.au/enabling-mixed-mode-authentication-on-sql-server-after-installed-with-windows-authenication-mode/

John Jennings

If that blog post explains your problem, then your original question wasn't accurate. Had you actually installed SQL in mixed mode, the 'sa' account would've been enabled automatically.