I want to host a SQL server database, but whenever I try to connect to it I get this error:
The login is from an untrusted domain and cannot be used with Windows authentication
I am connecting through Matlab using the following command:
conn = database('Clinical_Data','DoyleLab07\Acc','','com.microsoft.sqlserver.jdbc.SQLServerDriver','jdbc:sqlserver://DOYLELAB07\SQLEXPRESS:54287;database=Clinical_Data;integratedSecurity=true;').
As long as I was using Matlab on the PC I was using to host the server, connecting to the database through Matlab worked without a problem. The issue I previously described occurs when I use the identical Matlab command on a different computer.
When I look under "System" in the control panel. Despite being in the same workgroup, neither my host computer nor the computer I am connecting with have any domains listed. Would setting up a domain and including the foreign PC and the host in it allow me to solve my issue? If so, how can this be accomplished?
Any suggestions will be very much appreciated. Thank you for reading my post.