MS SQL Express 2005 + cant connect remotely
Posted on 2010-11-27
i am trying to connect to my sql server which is sql express 2005, i am using sql 2008, i have changed the setting to allow remote settings, but get the following error, do i need to set my router to port forwarding or is there something else i am missing.
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)