Help needed: turn mode to "off" Error SQL Server

Home ›

ASP.NET Forums » Starter Kits and Source Projects » Classifieds Starter Kit » Help needed: turn mode to "off" Error SQL Server

Shortcuts

Previous Next

Help needed: turn mode to "off" Error SQL Server

Last post 09-15-2006 12:34 PM by bmains. 1 replies.

Sort Posts:

Help needed: turn mode to "off" Error SQL Server

09-15-2006, 10:53 AM

Contact

15 point Member
sunmoon
Member since 09-13-2006, 9:17 AM
Posts 3

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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Source Error:

Line 1670:            Me.Adapter.SelectCommand.Parameters(3).Value = CType(AdLevel,Integer)
Line 1671:            Dim dataTable As AdsDataComponent.AdsDataTable = New AdsDataComponent.AdsDataTable
Line 1672:            Me.Adapter.Fill(dataTable)
Line 1673:            Return dataTable
Line 1674:        End Function

Re: Help needed: turn mode to "off" Error SQL Server

09-15-2006, 12:34 PM

Contact

27,972 point All-Star
bmains
Member since 10-22-2004, 8:20 AM
Posts 5,644

Hey,

Try this:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277
http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

Brian

"Trust in the Lord and do what is good; dwell in the land and live securely. Take delight in the Lord, and He will give you your heart's desires" (Psalm 37: 3-4).

Page 1 of 1 (2 items)

RSS Available