SQL Server2005 connection
-
i have created a data base connection but when the connection.Open() statement is executed i get the following exception " 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." what should i do ............... thanks
-
i have created a data base connection but when the connection.Open() statement is executed i get the following exception " 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." what should i do ............... thanks
Hi there, Just did a quick search from google...here is the one you might take a look http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=747709&SiteID=1[^] << >>
-
i have created a data base connection but when the connection.Open() statement is executed i get the following exception " 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." what should i do ............... thanks
waheed awan wrote:
what should i do
Set it up so you can allow remote connections. You do this by going into the Surface Area Configuration manager...
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon