cancel
Showing results for 
Search instead for 
Did you mean: 

Server Manager backup SQL connection error

Former Member
0 Kudos
86

Exactly same problem as discussed in [SAP BPC Server Manager Backup Problem|;. The solution provided didn't work. I followed the steps given. I restarted the app server. But the problem still persists.

I hope someone can provide further advice. (I am considering to restart the database server).

Thanks.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

From SQL Server log, I noticed few lines of "Login failed for user xxx\userid. Reason: Failed to open the explicitly specified database. [CLIENT: xxx.xxx.xxx.xxx]"

What does this mean? The Server Manager (SM) is unable to connect to the database? If so, how can I reset the userid/password? Do I use the "reset server credential" option in the SM?

Former Member
0 Kudos

Hi Zikif

It means that the user which is running the ServerManager.exe process doesn't have rights to log into SQL Server. You can simply launch Server Manager with credentials to log into SQL Server. Typically this will be the account used to run the COM+ components. (The user account which is running BPC)

Hope this helps

Kind Regards

Daniel

Former Member
0 Kudos

Hi Daniel,

I reset the passwords and it is working fine now.

Thanks

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Zikif

Have you checked your SQL Server Event log for the details about the error. The reason for the failure should correspond to an error on the SQL Server.

Which account is running Server Manager, does that have access to log into the SQL Server.

Kind Regards

Daniel