Couldnt Login Remotely from Virtual Machine.

Question

VM OS - XP Mode with SP3 Running in Windows 7
Server OS - Server 2003.

Scenario - I am trying to login to Physical Server (which runs the MS SQL 2005 using the Server's IP Address\Instance Name) through the Virtual Machine (XP Mode) using the application Enterprise downloader (Where I can type the "User Name", "Password", Server Address (where I will be typing the Server IP\Instance Name), I am getting following error mentioned below -

Event Type: Error
Event Source: Enterprise 3.0 Application
Event Category: None
Event ID: 0
Date:  3/29/2011
Time:  1:37:47 PM
User:  N/A
Computer: TEST-MACHINE
Description:
System.Data.SqlClient.SqlException Error 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) Occured at OnError In System.Data.SqlClient.SqlInternalConnection--->    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.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   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 GotDotNet.ApplicationBlocks.Data.AdoHelper.ExecuteDataset(String connectionString, CommandType commandType, String commandText, IDataParameter[] commandParameters)
   at GotDotNet.ApplicationBlocks.Data.AdoHelper.ExecuteDataset(String connectionString, CommandType commandType, String commandText)
   at GESecurity.Enterprise.Downloader.Server.TransServer.GetLoginOperator(String scConnect, String sUserName, String sPassword)
   at __UIWorkFlow.__UIWorkFlow.GetLoginOperator(String sUserName, String sPassword, IOperator& op)

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

I made sure necessary ports (SQL Ports & other ports are opened). I still couldnt login.

Note - But I can login locally from the DBServer that runs MS SQL 2005. Can you guys assist me in this to login. Hoping to see your message.

---

VT

Answer 1

My,

 

Look at this line of log:

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.

 

Try this!

and another thing, try a telnet command on port 1433 of physical machine

---

------------------------------------------------------------- Oracle OCA11g

Answer 2

Yes, I can telnet into the Server from the Virtual Machine on the port 1433. I guess we narrowed down the issue.

The thing is there are 2 instances. One is for the server (for example - MYSQLINSTANCE - which is for the server) & another one is created by the Enterprise Downloader (which is for example - ENTERPRISEINSTANCE).

MYSQLINSTANCE is using the port 1433 & ENTERPRISEINSTANCE is using the port 1434. When I login using the ENTERPRISEINSTANCE it is looking if the port is opened (which I doubt), Hence I am going to speak to Firewall guys tomorrow.

In the meantime can you please let me know if 2 instances can have same port number say 1433. Will there be any issue? Hoping to see your message.

---

VT

Answer 3

The issue is fixed- its the firewall issue. Thanks guys.

---

VT