Anyone know a stored procedure or TSQL statement that would retrieve the authentication mode for a SQL Server?
Thanks.
Printable View
Anyone know a stored procedure or TSQL statement that would retrieve the authentication mode for a SQL Server?
Thanks.
Isn't this something that should already be known? I mean, if there is an SP or T-SQL that coule return it, you'ld have to already connect, which means you'd need to already know the authentication mode...
TG
You're right, duh. But just to explain what I am doing: I am writing a technical note to potential users of our product explaining configuration scenarios and how to test them. I wanted to provide a script they could run from some diag program that retrieves that info before they install our product.
But as you pointed out, duh, can't do that. So I'm just going to tell them to ask their SQL admin. Thanks for waking me up today.