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.
What is the reason for this error?
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:
BTW, if this does not solve the connection problem, please refer the resources page at the following link for solutions:
Hope this helps. If there is any further inquiry, please feel free to contact me.