I have a production environment which consists of an application/admin server and a SQL 2005 hosting the database on the backend.
I also have a test environment with the same setup.
4 servers total, 2 for production, 2 for testing.
The file locations for the database and datastore are in different locations on each server.
I've backed up the production SQL 2005 database using the built-in SQL tools, and have also restored to the test SQL server, choosing to "overwrite the existing database" successfully.
I am supposed to login to the application/admin test server and attach to this test database that I've just restored, however it doesn't seem to be taking my credentials. What I'm asked for is:
Database Server Name: <testserverdb>
Database Name: <does THIS need to be exactly the same name as the prod. db??>
SQL username: <production DB uses windows auth., so I'm putting in my domain admin username>
SQL password: <putting in password for domain admin above>
I'm thinking either I have something wrong with the name of the database (if that matters), or it looking for a specific account.
When I connect to the SQL Production server using SQL Manager, I am using the same credentials I'm putting in for the restored test DB and can connect fine....
I know this is basic, and I'm missing something very basic, but can't figure it out....Suggestions?? Thanks in advance.