Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Data Server connection status is error after restoring database

Here is the situation


Issue: Data Server connection in error status after restoring the database.

SAP MII Version : 12.2.6

SQL Server 2008 R2

Data Services - > Data Server -> Server URL used : jdbc:jtds:sqlserver://localhost:1433/DBNAME


Here are the series of steps


1. MII Data Server Connection Status= running for Database= DBNAME

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.


Error

I checked the log files and could see below error

Unable to get a connection from the pool
[EXCEPTION]
java.sql.SQLException: Cannot open database "DBNAME" requested by the login. The login failed.



Please help to resolve the issue.

Former Member
Not what you were looking for? View more on this topic or Ask a question