default settings SQL Server does not allow remote connections
-
hello all, I'm getting this error when connecting to my sql server 2005 with asp.net 2.0 An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Shared Memory Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider) Regards
Amit Agarwal
-
hello all, I'm getting this error when connecting to my sql server 2005 with asp.net 2.0 An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Shared Memory Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider) Regards
Amit Agarwal
Enable the remote connections in SQL server surface area management. Make sure you don't have any firewalls running which blocks SQL server port.
All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia How to use google | Ask smart questions
-
Enable the remote connections in SQL server surface area management. Make sure you don't have any firewalls running which blocks SQL server port.
All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia How to use google | Ask smart questions
Thnaks for the reply, yeah, I did the certain changes from server surface area Management.i'm trying to connect sql server 2005 express edition with asp.net 2.0 on a single my PC. but still getting the same error.
Amit Agarwal