Basic MSI -> SQL Server -> Authentication Mode

[UNeverNo]

Is it possible - without using DMO/SMO (they are not installed everywhere) - to figure out in which mode a sql server runs?

I mean, IS needs to communicate with that sql server over a certain protocol when running sql scripts, so it should be possible to interact in the same way, right?

I either need to execute

select serverproperty('IsIntegratedSecurity')

and check the return value or just try to connect to my server by using name and password (if this fails it does not run in mixed mode). Unfortunately I only found IS oder MSI IS-functions to achieve that.

[timstspry]

Why not use the SQL Login Dialog which supports both SQL Server Security and Windows Authentication?

Hope this helps.

Tim