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 |
hanshenggao
Starting Member
3 Posts |
Posted - 2007-05-19 : 12:11:38
|
Hi, I recently set up an sql server 2000 on my network. I'm using a pipe name to connect my computers. However, I can only connect 5 computers to my server. The 6th computer that tries to connect gives me the following error:Connection failed:SQLState: '01000'SQL Server Error: 71[Microsoft][ODBC SQL Server DRiver][Named Pipes]ConnectionOpen (Connect()).Connection failed:SQLState: '08001'SQLServer Error: 71[Microsoft][ODBC SQL Server Driver][Named Pipes]SQL Server does not exist or access deniedI'm using the same settings for the 6th computer as for the other 5. The computer my server is running on is Windows XP Home edition. I found a document on microsoft.com that says that XP home edition only allows 5 computers to connect to it. I'm not sure if thats the reason and I've tried looking for ways to get around that but to no avail. In addition, I could not find any information on SQL server error 71. Can anyone help me please? |
|
Kristen
Test
22859 Posts |
Posted - 2007-05-19 : 12:31:15
|
Is SQL Server configured to only allow 5 connections?Enterprise Manager > Server : Properties : [Connections]Kristen |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-19 : 20:19:57
|
What's your sql2k edition? Looks like edition's limit. |
|
|
hanshenggao
Starting Member
3 Posts |
Posted - 2007-05-20 : 12:22:58
|
My sql server is configured to allow 500 connections. I'm not sure what my Sql edition is but it came with my Office XP developer's edition. I'm assuing its the developer edition of SQL 2000. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-20 : 17:22:04
|
You can find it with 'select @@version'. |
|
|
hanshenggao
Starting Member
3 Posts |
Posted - 2007-05-20 : 18:01:12
|
it is sql 2000 developer editionI have a feeling that it is xp home edition thats limiting my number of connections. I read on microsoft.com that home edition only lets 5 computers to connect while xp pro lets 10. Is there any way to get around this? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-20 : 20:31:32
|
Then the only way is install sql on win server. |
|
|
|
|
|