By default, MSDE is configured to use Windows authentication.
I want to use SQL-DMO to change this to SQL-Server/Windows authentication,
but havent found any better way to do it.
* My code...
clear
oSQLApp = CreateObject('SQLDMO.Application')
oServer = osqlapp.ServerGroups(1)
nRegServ = oserver.RegisteredServers.Count
FOR i = 1 TO nRegServ
oChange = oserver.RegisteredServers.item(i)
? oChange.UseTrustedConnection = 0
ENDFOR
From SQL-DMO Reference Help
When 0, a connection initiated by a Microsoft client application for SQL Server using an instance of SQL Server in the registry listing will use SQL Server Authentication. Configure authentication using the Login and Password properties.
When 1, a connection initiated by a Microsoft client application for SQL Server using an instance of SQL Server in the registry listing will use Windows® Authentication.
In this PC SQL-Server is configured to use SQL-Server authentication, so it's value is 0 but the code above returns .F.
Why ?
Thanks in Advance
Peter