Using Trusted Connections

The MSSQL Schema Engine supports using 'Trusted Connections' to connect to SQL Server (See Creating Schema Profiles).  When enabled any Schema Processors will attempt to connect to the SQL Server using the MS Windows login credentials of the user running the program.  Note that this can result in issues when running the Schema Engine as a service, particularly if the SQL Server is on a different computer than the one running the service.

If you encounter connection problems, verify the following:

1) The MS Windows Account which is running the service has adequate user access to the SQL Server and Database containing the Schema Tables.  You may need to change the MS Windows Account which is used to run the service.

2) If the SQL Server is on a different computer, be aware that by default the Schema Engine service (like most windows services) will be running under the built-in LOCAL windows system user account which usually cannot access any network resources.