login types windows autentication or SQL server a

Question

login types windows autentication or SQL server a

misuk11

Valued Member

Points: 74
More actions
March 25, 2003 at 10:38 am

#80496

Does anyone know of a way to automatically select which type of user authentication SQL server 2000 will use. Ideally id like to put this into the GUI front end of an application, is there a system stored procedure that can do this ?
TIA Mark Wheeler.
markwheeler1963@hotmail.com

Viewing 5 posts - 1 through 4 (of 4 total)

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

Rodrigo Acosta SSC-Insane Points: 21261 More actions · Answer 1

If you change the authenticacion mode of SQL, you must restart SQL Server to take effect. You can do it with the xp xp_instance_regwrite. But it changes the registry so I wouldn't use it.

But if you want to put in your app. the posibility to login with a Windows Login account or with a SQL Server user, then you must change the connection string in your application.

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 2

Technically, though, even when going through EM it changes the registry key.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

K. Brian Kelley
@kbriankelley

Rodrigo Acosta SSC-Insane Points: 21261 More actions · Answer 3

Agree but for example when you change the login account of the SQL Server or Agent service with EM is not the same than doing it from the Control Panel.

EM also changes some security things in the registry.

dj_meier SSCrazy Points: 2732 More actions · Answer 4

I may be misunderstanding what you need, but you can select the type of connection for the user/client based on the connection string. If you pass a uid and password, then SQL Server authentication will be used, but if you only pass "trusted_connection=yes", then the client application will use NT authentication.

-Dan