Skip to Content
avatar image
Former Member

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jan 10, 2014 at 10:22 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Jan 10, 2014 at 04:54 PM

    Try providing new user ID and password which would work.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 11, 2014 at 08:10 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded