Unknown server host name for sql server express 2008

General Questions/Discussions
#1

Hi,

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

#2

Hi Stan,

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%

BTW, if this does not solve the connection problem, please refer the resources page at the following link for solutions:
http://resources.visual-paradigm.com/index.php/tips-support/53-support/95-sql-connection-problem.html

Hope this helps. If there is any further inquiry, please feel free to contact me.

Best regards,
Lilian Wong