How I can create login from windows authentication to SQL Server Authentication

Question

How I can create login from windows authentication to SQL Server Authentication

dharmendra.rajput06

Valued Member

Points: 74
More actions
December 10, 2009 at 4:25 am

#214526

Hi All,
I am new user of a SQL SERVER 2008, I was lost my default user 'sa' Password. Is it possible to create a new user name with a password with SQL Server Authentication using windows authentication login.
Thanks in advance...

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

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

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 1

dharmendra.rajput06 (12/10/2009)
Hi All,
I am new user of a SQL SERVER 2008, I was lost my default user 'sa' Password. Is it possible to create a new user name with a password with SQL Server Authentication using windows authentication login.
Thanks in advance...

S possible,

To connect using local windows admin user & create sql login.

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 2

I was lost my default user 'sa' Password.

Hi,

If u don't have permission to the server ask ur Admin team and reset the sa password.

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

shahid_jambagi SSC Enthusiast Points: 164 More actions · Answer 3

goto start --> click select SQL server management studio

log windows is pop up

Server type is by default

server name is by default (provide appropriate server name)

Authentication select WINDOWS Authentication.

click connect button

TO reset sa password:

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

After successful login click on Security from left pane and expand it

and expand Login then you are able to view sa user

Double click sa, provide password and reconfirm password and click OK button

Logoff and login with new changed sa password

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 4

shahid_jambagi (2/8/2012)
goto start --> click select SQL server management studio
log windows is pop up
Server type is by default
server name is by default (provide appropriate server name)
Authentication select WINDOWS Authentication.
click connect button
TO reset sa password:
------------------------
After successful login click on Security from left pane and expand it
and expand Login then you are able to view sa user
Double click sa, provide password and reconfirm password and click OK button
Logoff and login with new changed sa password

I sure hope he could reset his sa password 3 years ago...

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

shahid_jambagi SSC Enthusiast Points: 164 More actions · Answer 5

thanks a lot for informing me ....:)

intention was to benifit others searching such type of questions. hope you got it.

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 6

shahid_jambagi (2/9/2012)
thanks a lot for informing me ....:)
intention was to benifit others searching such type of questions. hope you got it.

I already got it from the first two replies, which already provided a complete solution.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

shahid_jambagi SSC Enthusiast Points: 164 More actions · Answer 7

shahid_jambagi

SSC Enthusiast

Points: 164

February 9, 2012 at 12:23 am

#1444895

anyway thanks for informing me. buy for now.