HPE Community read-only access December 15, 2018
This is a maintenance upgrade. You will be able to read articles and posts, but not post or reply.
Dec 15, 4:00 am to 10:00 am UTC
Dec 14, 10:00 pm CST to Dec 15, 4:00 am CST
Dec 14, 8:00 pm PST to Dec 15, 2:00 am PST
Server Management - Systems Insight Manager
Showing results for 
Search instead for 
Did you mean: 

HPSIM DB error using sqlcmd

Occasional Contributor

HPSIM DB error using sqlcmd


I try to make an simple sql querry on the HP SIM DB, but I don't get a trusted connection to it.

Here is the command:

sqlcmd -E -d Insight_v50_0_8514220614 -Y 40 -i drives.sql -o drives.txt -s ";"

And the error message located in the "drives.txt":

Msg 4060, Level 11, State 1, Server HP-SIM, Line 1
Cannot open database "Insight_v50_0_8514220614" requested by the login. The login failed.
Msg 18456, Level 14, State 1, Server HP-SIM, Line 1
Login failed for user 'WURMLOCH\hpsim'.

The user 'WURMLOCH\hpsim' has admin credentials and it is the log on account for the SQL Server. I have a screenshot attached.

Thanks for your help!