Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
debradeng
Starting Member
46 Posts |
 Posted - 2006-11-11 : 19:51:01
|
| I was trying to allow remote user to access sql server 2005 database.I have done configuration and tested on my computer,it works well.But from other computer,I can not use the new user to login.Error message is :no such host is known.How can I resolve it? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-11-12 : 00:35:26
|
have you configured the Surface Area Configuration ?
KH |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-11-12 : 03:59:44
|
| Do you have some firewall installed? SQL Server uses port 1433 by default.Peter LarssonHelsingborg, Sweden |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-11-12 : 10:54:15
|
| If you are getting the error, host unkown. As Peter said, check if you have a firewall and run a netstat test to see which ports are listening |
|
|
|
|
|
|
Error 11001:No such host is known.