I connect to sql server express 2008 using MYPC\SQLEXPRESS2008 for server name and Windows Authentication.
But I can’t connect in DB Visual Architect with the following connection string : Server=MYPC\SQLEXPRESS2008;Database=test;TRUSTED_CONNECTION=yes;
I’m using jtds-1.2.jar and the error is 'Unknown server host name '.
I allowed tcp/ip connections to the server, but it didn’t solve the problem.
Thanks for your post. May I know is “MYPC” the domain? If so, you should enter “Server=SQLEXPRESS2008” and “Domain=MYPC” in the connection string.
And for .NET with Windows Authentication, please configure the connection string as following:
Server=%HOST%,%PORT%;Database=%DATABASE%;User ID=%USER_ID%;Password=%PASSWD%;Trusted_Connection=Yes;Domain=%WINDOW_DOMAIN%