Server Management - Systems Insight Manager
1753677 Members
5475 Online
108799 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!