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.

All Forums  SQL Server 2005 Forums  Express Edition and Compact Edition (2005)  Cannot configure SQLEXPRESS for remote connection

Author  Topic  matman13 Starting Member 1 Post Posted - 2006-08-14 : 22:17:13 Hello. I have SQLEXPRESS 2005 installed on my laptop running Windows XP Home Edition with SP2. I have an application that can connect to the local instance with no problem. The other day, I tried to configure SQLEXPRESS 2005 for a remote connection from my desktop. To date, I have been unable to figure out how to do this. I have followed the instructions posted at various locations on the internet, but to no avail. While I can configure SQLEXPRESS 2005 to allow TCP/IP connections, I have been unable to restart the server. Here is the pertinent snippet from the error log: <time> Server A self-generated certificate was successfully loaded for encryption. <time> Server Error: 26024, Severity: 16, State: 1. 2006-08-14 21:02:27.18 Server Server failed to listen on 'any' <ipv4> 0. Error: 0x277a. To proceed, notify your system administrator. <time> Server Error: 17182, Severity: 16, State: 1. <time> Server TDSSNIClient initialization failed with error 0x277a, status code 0xa. <time> Server Error: 17182, Severity: 16, State: 1. <time> Server TDSSNIClient initialization failed with error 0x277a, status code 0x1. <time> Server Error: 17826, Severity: 18, State: 3. <time> Server Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log. <time> Server Error: 17120, Severity: 16, State: 1. <time> Server SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems. I have a feeling this problem is due to the way my system is configured, not necessarily how my SQLEXPRESS 2005 is configured. My laptop and desktop are connected via a wireless router, and both machines are running Norton Anti-Virus 2006. I've added sqlserver.exe and sqlbrowser.exe to the exceptions list for the Worm protection on the laptop, i.e., the server machine. There's not a setting at the router that would prevent the server from re-starting, is there? Any help is GREATLY appreciated! Matt