Data Server connection status is error after restoring database
Here is the situation
Issue: Data Server connection in error status after restoring the database.
SQL Server 2008 R2
Data Services - > Data Server -> Server URL used : jdbc:jtds:sqlserver://localhost:1433/DBNAME
Here are the series of steps
2. Dropped DBNAME database in SQL management Studio and restored the DBNAME with a bkp file
3. No changes were done to Data Services - > Data Server
4. After restoring the DBNAME database Data server connections dependent on DBNAME are showing in "Error" status.
I checked the log files and could see below error
Unable to get a connection from the pool
java.sql.SQLException: Cannot open database "DBNAME" requested by the login. The login failed.
Please help to resolve the issue.