We are running SQL express 2008 for EPO 5.0. All is fine. However, during the installation we entered domain\administrator to run the SQL database. Now we are disabling the use of the domain admin "administrator" account. How can I start the database as a different user? The administrator account is already disabled.
this the error I get:
Login failed for user 'servername\Administrator'. Reason: Failed to open the explicitly specified database. [CLIENT: 10.44.47.197]
Accoring to the SQL tools the logon is being done by the Network Service.
solved, change the SQL logon settings in menu registred servers.
THen also grant the new users the same rights in SQL mangement studio as the first user under security.