SQL error, cannot connect to database after restore
Posted on 2014-04-15
I have a database called TVArchive in machine A and there's an service application connects to the database on the same machine.
Machine A crashed, and I built a new one and installed MSDE 2000 and the service application. The database connection from the application was OK.
Then I restored the database backup to machine A's SQL (MSDE 2000). Now when I tried to launch the service application, it says 'cannot connect to database'. I checked SQL logins and database mapping for users, all the same. Is there any database or user identity(such as GUID) that I have change for the restored database in SQL system tables?