Why remotely connecting to SQL 2005 express failed?

  • Up

  • halifaxdal (2/10/2012)


    Up

    IS it working now?

    What was the fix?

    Regards,

    Skybvi

    Regards
    Sushant Kumar
    MCTS,MCP

  • unfortunately it is still not working.

  • going back to the questions on the first page...we never got a definitive answer.

    did you disable windows firewall and attempt to connect?

    what was the results or specific error when you tried?

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • Lowell (2/10/2012)


    going back to the questions on the first page...we never got a definitive answer.

    did you disable windows firewall and attempt to connect?

    what was the results or specific error when you tried?

    thanks.

    firewall is off but subject to group policy

    error when reconnect:

    ===================================

    Cannot connect to TISMJPVV62\SQLEXPRESS.

    ===================================

    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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)

    ------------------------------

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476

    ------------------------------

    Error Number: -1

    Severity: 20

    State: 0

    ------------------------------

    Program Location:

    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

    at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)

    at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)

    at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)

    at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)

    at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)

    at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)

    at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)

    at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)

    at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

    at System.Data.SqlClient.SqlConnection.Open()

    at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)

    at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

  • I used this command to dump the current firewall settings:

    netsh firewall show config

    Domain profile configuration (current):

    -------------------------------------------------------------------

    Operational mode = Disable

    Exception mode = Enable

    Multicast/broadcast response mode = Enable

    Notification mode = Enable

    Service configuration for Domain profile:

    Mode Customized Name

    -------------------------------------------------------------------

    Enable No File and Printer Sharing

    Enable No Remote Desktop

    Allowed programs configuration for Domain profile:

    Mode Name / Program

    -------------------------------------------------------------------

    Enable Network Diagnostics for Windows XP / C:\WINDOWS\Network Diagnostic\xpnetdiag.exe

    Enable Remote Assistance / C:\WINDOWS\system32\sessmgr.exe

    Enable McAfee Framework Service / C:\Program Files\McAfee\Common Framework\FrameworkService.exe

    Enable sqlservr.exe / C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe

    Port configuration for Domain profile:

    Port Protocol Mode Name

    -------------------------------------------------------------------

    1434 UDP Enable SQL Server Browser

    1433 TCP Enable SQLExpress

    139 TCP Enable NetBIOS Session Service

    445 TCP Enable SMB over TCP

    137 UDP Enable NetBIOS Name Service

    138 UDP Enable NetBIOS Datagram Service

    3389 TCP Enable Remote Desktop

    Standard profile configuration:

    -------------------------------------------------------------------

    Operational mode = Disable

    Exception mode = Enable

    Multicast/broadcast response mode = Enable

    Notification mode = Enable

    Service configuration for Standard profile:

    Mode Customized Name

    -------------------------------------------------------------------

    Enable No File and Printer Sharing

    Enable No Remote Desktop

    Allowed programs configuration for Standard profile:

    Mode Name / Program

    -------------------------------------------------------------------

    Enable Network Diagnostics for Windows XP / C:\WINDOWS\Network Diagnostic\xpnetdiag.exe

    Enable Remote Assistance / C:\WINDOWS\system32\sessmgr.exe

    Enable McAfee Framework Service / C:\Program Files\McAfee\Common Framework\FrameworkService.exe

    Port configuration for Standard profile:

    Port Protocol Mode Name

    -------------------------------------------------------------------

    139 TCP Enable NetBIOS Session Service

    445 TCP Enable SMB over TCP

    137 UDP Enable NetBIOS Name Service

    138 UDP Enable NetBIOS Datagram Service

    3389 TCP Enable Remote Desktop

    Log configuration:

    -------------------------------------------------------------------

    File location = C:\WINDOWS\pfirewall.log

    Max file size = 4096 KB

    Dropped packets = Disable

    Connections = Disable

    Local Area Connection firewall configuration:

    -------------------------------------------------------------------

    Operational mode = Enable

    Local Area Connection 2 firewall configuration:

    -------------------------------------------------------------------

    Operational mode = Enable

    1394 Connection firewall configuration:

    -------------------------------------------------------------------

    Operational mode = Enable

Viewing 6 posts - 31 through 35 (of 35 total)

You must be logged in to reply to this topic. Login to reply