need for your help

Question

need for your help

SQL Galaxy

One Orange Chip

Points: 29472
More actions
August 23, 2009 at 11:55 pm

#95763

1. we are plan change sql authentication mode(mixed) to windows authentication, if changed authentication to windows mode sql server become a trusted connection. so appllication will be affected on connection string.
2. sa password will be diabled after change windows mode, so how to enabled sa login on windows mode in sql server 2000?
3. I have domain user and login same user this server, after that I had tried one of the test server changed to windows mode, then sa login has been disabled. could not able to connect the sql server. error msg is:Login failed for user "domainname\username", here is it required for this user should be sysadmin permission?
Please can anyone suggestion me, thanks for your help.

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

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

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

You will definitely want to have at least on Windows login as part of the sysadmin role before you make any changes.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Sarab_SQLChamp Hall of Fame Points: 3882 More actions · Answer 2

This link will definately help you.

http://support.microsoft.com/kb/827422

Regards,
Sarabpreet Singh 😎
Sarabpreet.com
SQLChamp.com
Twitter: @Sarab_SQLGeek

Steve Jones - SSC Editor SSC Guru Points: 736494 More actions · Answer 3

1. yes, connection strings need to change if they are not using trusted connections.

2. you can't. the Sa account cannot be used as that is for SQL authentication only. You need to add another user/group to the sysadmin role before you make this change.

3.see #2

SQL Galaxy One Orange Chip Points: 29472 More actions · Answer 4

Thanks for yours reply...

Windows authentication worked for me.

I added my domain user in sql server login, and then given sysadmin permission, so now i can able to access all the database and my domain user become a super user like sa. Also sql services running under this domain user.

I need some more details for the below.

1. select * from syslogins in master database, here my domain user display NULL password, so how to set the password on windows user?

2. how to give access database to windows user?

Thanks

Jack Corbett SSC Guru Points: 184394 More actions · Answer 5

When using Windows Authentication SQL Server does not require a password, it uses the token from your domain login to verify who are and if you have rights. SQL Server does store your Active Directory SID.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

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

To allow a Windows user access to a database, you need to add a user, then map that user to the login you added.

You can, and should, read this section in books Online: http://msdn.microsoft.com/en-us/library/bb510418.aspx