Server Management - Systems Insight Manager
1753486 Members
4420 Online
108794 Solutions
New Discussion

HPSIM DB error using sqlcmd

 
chotto83
Occasional Contributor

HPSIM DB error using sqlcmd

Hi,

 

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!