SQL Server Authentication mode

Question

Post reply

SQL Server Authentication mode

vijaymohanp

Grasshopper

Points: 10
More actions
September 4, 2008 at 11:20 am

#123303

i wanna use sql Authentication mode, by default it is Window Authentication mode, i dont knw the username and password , i tried with sa and
please help me
Thank u in advance
Vijay Mohan

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

DNA_DBA SSCrazy Eights Points: 9132 More actions · Answer 1

... and what? Can you still get in via windows authentication? Are you a sysadmin user? You can change the sa password.

vijaymohanp Grasshopper Points: 10 More actions · Answer 2

Am Not System admin.

Previously i worked with J2ee Mysql

Now am Workin In VS2008 and SQL Server 2005

I want to login to the DB in SQL Authentication Mode with Default Username and password

For that i Login Using Window Authentication Mode and Change the Mode to SQL AUthentication Mode

i Followed the Steps:

1. Right Clicked Object Explorer

2. Selected Properties

3. Selected Securities In Left pane

4. Changed Window Authentication Mode to SQL Authentication mode

5. Restarted The Server

I tried with above Mentioned Username And passwords

but i cant login

help me Please

Regards,

Vijay Mohan

Thank u

Perry Whittle SSC Guru Points: 234013 More actions · Answer 3

sql authentication modes are either

windows

mixed

in mixed mode windows accounts can still authenticate. Logon as the server administrator and you will gain access to the sql server via the builtin\administrator group. Once you have logged in it would pay to reset the sa account to a known\secure password

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

Sakthivel Chidambaram SSCertifiable Points: 5531 More actions · Answer 4

I guess you have already changed the authentication mode to SQL Server Authentication... So now you will not be able to login through Windows Authentication... So unless you get correct password for sa or anyother SQL Server login then server will not permit you to login...

Now to go back to Mixed mode authentication there are two options...

1. Get help of anyother DBA who has valid SQL Server login and get into the box and reset SA password/Create new SQL Server login.

2. Change the authentication mode back to mixed mode in the Registry and restart SQL Server and create/reset SQL login password...

Hope it helps!

Regards,
Sakthi
My Blog -> http://www.sqlserverdba.co.cc

MANU-J. SSC-Dedicated Points: 31126 More actions · Answer 5

Have you gone thru this link:-

http://blogs.msdn.com/raulga/archive/2007/07/12/disaster-recovery-what-to-do-when-the-sa-account-password-is-lost-in-sql-server-2005.aspx

Do let us know in case it works or not.

HTH

MJ

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 6

There is no SQL Server mode. There is mixed mode, both Windows and SQL authentication, and Windows only mode, for only Windows authentication.

There is no default user and password. The only user that exists is "sa", but you must set a password for that account when you install SQL Server.