MS SQL domain login

[xian_]

SQL server does not allow login from non-domain machine including vRO (embedded vRA instance). Tried to add kerberos config (needed for PowerShell host integration) but did not help. Is this possible at all?

item: 'Add a database/item2', state: 'failed', business state: 'null', exception: 'com.vmware.o11n.plugin.database.DatabaseException: java.sql.SQLException: Login failed for user '_srv_db@domain.corp'. (Dynamic Script Module name : addDatabase#8)'

[Jeff_CH · Accepted solution]

Hi Xian

I am using the following connection URL for MS SQL (without using a Kerberos Config):

jdbc:jtds:sqlserver://<sql-server-dns-name>:<portnumber>/<database-name>;instance=<instance-number>;domain=<pre-windows-2000-domain-name>;useNTLMv2=true

Regards,

Jeff

[xian_]

Thanks, Jeff

this helped a little bit but the server is picky:

com.vmware.o11n.plugin.database.DatabaseException: java.sql.SQLException: Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication. (Dynamic Script Module name : addDatabase#8)

[Jeff_CH]

Did you try using the username '_srv_db',  so without using '@domain.corp'?

[xian_]

Worked, thank you!