Data Server connection status is error after restoring database

[Former Member]

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]

Hi Rajesh,

Couple of things you can check from the Database server end..

1. Assuming its a SQL server, check if the authentication is windows auth or SQL Server login.

2. Check if the user you are trying to connect with has login access to server and to the database. It is possible that when you have restored the backup, the user is still associated with the database but has lost the login rights....In a reverse context, it is possible that the users for the DB have not been backed up, the user has login rights but no access to database.

3. Try to login into the databse (SQL Server interface/client may be) with the credentials you have provided in MII Data server.

Regards

Tufale Ashai.

[former_member204240]

Try providing new user ID and password which would work.

[Former Member]

Hi Rajesh,

The error is indicating authentication problem.

Check for the user(given in the data server in MII) in the database.

Also try to recreate the dataserver.

Regards,

Rohit Negi.

[Former Member]

Hi Rohit,

I tried deleting the data server and created a new one. Same issue persistis.

Can you share what steps to be followed in database.

thanks

Rajesh