https://community.hpe.com/t5/server-management-systems/connect-to-a-remote-sql-db-server-using-sql-auth-during-install/m-p/4863824#M44391 Yes, absolutely. Mon, 04 Oct 2004 10:58:40 GMT Joel Rubenstein 2004-10-04T10:58:40Z https://community.hpe.com/t5/server-management-systems/connect-to-a-remote-sql-db-server-using-sql-auth-during-install/m-p/4863819#M44386 I want HP SIM to access a remote SQL server. Durning the installation of System Insight Manager, it prompts me for credentials to the database server, but I can only enter password for the account currently logged in and I cannot change the doamin. Nevertheless, it doesn't appear that I can use SQL authentication. Is there a way a round this? Mon, 04 Oct 2004 09:45:13 GMT https://community.hpe.com/t5/server-management-systems/connect-to-a-remote-sql-db-server-using-sql-auth-during-install/m-p/4863819#M44386 Ron_159 2004-10-04T09:45:13Z https://community.hpe.com/t5/server-management-systems/connect-to-a-remote-sql-db-server-using-sql-auth-during-install/m-p/4863820#M44387 SIM requires Windows NT authentication for all database access it does not support SQL server authentication. Mon, 04 Oct 2004 09:55:17 GMT https://community.hpe.com/t5/server-management-systems/connect-to-a-remote-sql-db-server-using-sql-auth-during-install/m-p/4863820#M44387 Joel Rubenstein 2004-10-04T09:55:17Z https://community.hpe.com/t5/server-management-systems/connect-to-a-remote-sql-db-server-using-sql-auth-during-install/m-p/4863821#M44388 Thanks much. Can I setup SIM to access SQL with Windows domain account, but use a seprate account to log in to the HP SIM Web interface, view reports, scheduled jobs and so forth? Mon, 04 Oct 2004 10:25:20 GMT https://community.hpe.com/t5/server-management-systems/connect-to-a-remote-sql-db-server-using-sql-auth-during-install/m-p/4863821#M44388 Ron_159 2004-10-04T10:25:20Z https://community.hpe.com/t5/server-management-systems/connect-to-a-remote-sql-db-server-using-sql-auth-during-install/m-p/4863822#M44389 Yes you can setup SIM to use a Windows domain account to access SQL and then create any number of separate accounts used to login to SIM. These accounts must first be present in Windows since SIM authenticates all logins against the windows directory however they do not need any special windows privileges. In SIM you go to Options --> Security --> Users and Authorizations to configure the SIM users. Mon, 04 Oct 2004 10:38:06 GMT https://community.hpe.com/t5/server-management-systems/connect-to-a-remote-sql-db-server-using-sql-auth-during-install/m-p/4863822#M44389 Joel Rubenstein 2004-10-04T10:38:06Z https://community.hpe.com/t5/server-management-systems/connect-to-a-remote-sql-db-server-using-sql-auth-during-install/m-p/4863823#M44390 Excellent, It should still be possible then to login locally to the workstation where HP SIM is installed and launch SIM using a local account rather than a domain account, as long as HP SIM was given the domain cerdential to access the SQL server? Mon, 04 Oct 2004 10:56:49 GMT https://community.hpe.com/t5/server-management-systems/connect-to-a-remote-sql-db-server-using-sql-auth-during-install/m-p/4863823#M44390 Ron_159 2004-10-04T10:56:49Z https://community.hpe.com/t5/server-management-systems/connect-to-a-remote-sql-db-server-using-sql-auth-during-install/m-p/4863824#M44391 Yes, absolutely. Mon, 04 Oct 2004 10:58:40 GMT https://community.hpe.com/t5/server-management-systems/connect-to-a-remote-sql-db-server-using-sql-auth-during-install/m-p/4863824#M44391 Joel Rubenstein 2004-10-04T10:58:40Z https://community.hpe.com/t5/server-management-systems/connect-to-a-remote-sql-db-server-using-sql-auth-during-install/m-p/4863825#M44392 Thanks for responing so quickly. I am a contractor for this Co. and have little access to the network. Being able to set this up this way is going to help. Mon, 04 Oct 2004 12:17:42 GMT https://community.hpe.com/t5/server-management-systems/connect-to-a-remote-sql-db-server-using-sql-auth-during-install/m-p/4863825#M44392 Ron_159 2004-10-04T12:17:42Z