VMware Horizon Community
njd62495
Contributor
Contributor
Jump to solution

Cannot enable View Composer

I've installed View Composer on my Virtual Center server, but when I go into the Virtual Composer Settings and try to enable it I keep getting the follwoing error:

Either the View Composer Server is not responding, or the user name or password entered is incorrect. The View Composer requires that the user name must be fully qualified with the domain (domain\administrator). Please contact the administrator.

Also when I try to start the View Composer service I am getting the follwoing error codes in the Application event log:

Service cannot be started. VMware.Sim.CommonLib.Exception.SimDbConnectionException: [ODBC SQL Server Driver][SQL Server]Login failed for user 'SERVERNAME\ID'. ---> NHibernate.ADOException: cannot open connection ---> System.Data.Odbc.OdbcException: ERROR [ODBC SQL Server Driver][SQL Server]Login failed for user 'SERVERNAME\ID'.

ERROR [ODBC SQL Server Driver][SQL Server]Login failed for user 'SERVERNAME\ID'.

at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)

at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle)

at System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)

at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)

at System.Data.ProviderBase.DbConnecti...

I have a DB created on my SQL server and I've created a DSN pointing to the DB but I'm not sure if I'm using the correct logon type. I'm using With WindowsNT authentication using network login ID.

Is there some sort of ID that needs rights to the DB on the SQL server side that I have to use when creating my DSN.

Also do both of these errors have and relevance to each other?

Reply
0 Kudos
1 Solution

Accepted Solutions
dcerri
Enthusiast
Enthusiast
Jump to solution

looks like you are possibly sending the incorrect servername.

I would try to use sql authentication instead of NT, unless you really need to use NT authentication. to do that you need to enable it into mssql and choose that authentication type on the ODBC connection too. If you choose to try to follow my advice, let me know if it solves the problem.

View solution in original post

Reply
0 Kudos
2 Replies
dcerri
Enthusiast
Enthusiast
Jump to solution

looks like you are possibly sending the incorrect servername.

I would try to use sql authentication instead of NT, unless you really need to use NT authentication. to do that you need to enable it into mssql and choose that authentication type on the ODBC connection too. If you choose to try to follow my advice, let me know if it solves the problem.

Reply
0 Kudos
njd62495
Contributor
Contributor
Jump to solution

Thanks, I took your advice and I'm now able to get the service started and I'm also able to enable view composer.

Thanks!!!

Reply
0 Kudos