We are migrating our EOC database from one SQL 2008 server to another in a different environment. The new SQL server will also have a newly installed EOC on the front-end. All the software is the same version.
We backed up the database, and restored it onto the SQL server. The EOC services on the new server start with no errors. But when we run EOC we get an error stating that EOC fails to log into the database. The exact error is: "Cannot open database "EOC" requested by the login. The login failed."
We are using SQL authentication to connect to the database. I have checked all the security settings in SQL, and they all appears to be correct ( the same as the old SQL server).
Any Ideas?
