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 denied
I'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?
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.
I 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?
SQL Server error 71
Posted - 05/19/2007 : 12:11:38
