Friday, February 24, 2012

Error while trying to connect to another SQL Server Express machine

The error states:

Additional Information:
An error has occured while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that unthe default settings SQL Server does not allow remote connections.

How do I correct this issue?

Thanks,

Steve C.

By default, SQL Server 2005 Express Edition disables network access / remote connections. This is for security purposes. We want this enabled explicitly should someone have a need for it. Here is a KB article that talks about ways to enable remote connections http://support.microsoft.com/default.aspx?scid=kb%3bEN-US%3b914277

Thank You

Ajay

No comments:

Post a Comment