Came in this morning and im getting the following error in our Provisioning tool. This was working as of yesterday and no changes were made to the web.config file. Ive failed over the cluster on the sql servers and also restarted the provisioning engine.
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
The SQL server is setup for mixed mode authentication and ive opened my web.config file with visual studio and can make a connection with the same sql user and pass thats in my web.config to the proper databases.
The provisioning server and sql server are individual boxes on the same domain.
Event log error when im trying to connect:
A failure occurred while connecting to the transaction log database.
Connection String = 'server='MPSSQLVS01';database='MPFTranLogData''.
SQL server reported errors:
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Resolved my issue. I went into IIS to the MPSWEB virtual directory and went into properties, directory security, and turned off anonymous access. I then turned it back on and it worked fine. Seems like it lost permissions somehow and switched to null instead of the local IUSR_servername authentication.