Load Testing Reporter

[sitefinitysteve]

I'm getting a red reporter icon and when I try to run tests I get "Cannot run because the reporter cannot establish its database"

How do I give it a DB?

[Cody]

Hello Steve,

The Load Reporter service will automatically create its needed database once it successfully establishes a connection to your MS SQL Server. This connection can be specified either during the install or afterwards by configuring the services (see attached screen shot).

Which version of SQL Server are you trying to use? The Load Reporter service requires SQL Server 2008 or above (Express edition is adequate).

Regards,
Cody
the Telerik team

[sitefinitysteve]

Ok thanks!

Hey one other quick Q...our site is 100% protected (like one public page...thats login)

Are we still able to load test that with a set of users?  Knowing that in Sitefinity a user can only be logged in once (like we can't have 100 virtual users sharing the same account)

[Cody]

Hello Steve,

Trying to run a load test where the same user cannot be logged in more than once presents a real challenge with what we currently have released. If you try to setup a load test with 100 virtual users the same HTTP traffic would be used by all 100 users, including the logon credentials.

What you really need (and is currently in development) is data driven load testing, where the logon credentials come from a data source. You would have to create a data source with 100 different logon credentials for your 100 virtual users to consume.

The only alternative today is to load test with only one virtual user, or record multiple HTTP traffic streams one for each unique virtual user that has unique logon credentials in the stream. You would only be able to have one virtual user per unique traffic stream (i.e. user profile). Tedious and a lot of work, but is doable.

Kind regards,
Cody
the Telerik team

[Matt]

I am using the trial version... just installed, SQL 2008 R2 is up and running... and I still get this error. Is there a manual step that I need to take to create the database?

[Cody]

Hello Matt,

No there is no method to manually create the DB. In fact if you do you will actually cause additional problems. Please enable logging and send us the log for further diagnosis of this problem.

Regards,
Cody
the Telerik team

[Matt]

I would upload this... but it's restricted. BTW, SQL is running, I use it for other purposes all the time. I have Windows Auth set... do I need SQL auth set up?

[06/11 17:26:13,Telerik.TestStudio.Services.exe(6616:8)] First trace message from process 6616: "C:\Program Files\Telerik\Test Studio\Bin\Telerik.TestStudio.Services.exe"
[06/11 17:26:13,Telerik.TestStudio.Services.exe(6616:8)] First trace message from pool unnamed thread (managed ID = 8, native ID = 8148).
[06/11 17:26:13,Telerik.TestStudio.Services.exe(6616:8),Error] LoadReporterService.FromLoadController_TestDBConnection() : EXCEPTION! (see below)
     Situation: Exception detected while trying to connect to the DB.
     Outer Exception Type: System.Data.SqlClient.SqlException
     Message: 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)
     HRESULT: 0x80131904 (Official ID (if app.) = COR_E_SqlException, Error Bit = FAILED, Facility = FACILITY_URT, Code = 6404)
     Call Stack:
          at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
          at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
          at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity)
          at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, SqlConnection owningObject)
          at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout)
          at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, 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 System.Data.SqlClient.SqlProviderServices.UsingConnection(SqlConnection sqlConnection, Action`1 act)
          at System.Data.SqlClient.SqlProviderServices.UsingMasterConnection(SqlConnection sqlConnection, Action`1 act)
          at System.Data.SqlClient.SqlProviderServices.DbDatabaseExists(DbConnection connection, Nullable`1 commandTimeout, StoreItemCollection storeItemCollection)
          at System.Data.Objects.ObjectContext.DatabaseExists()
          at Telerik.TestStudio.Services.LoadReporter.LoadReporterEntityBridge.TestDBConnection()
          at Telerik.TestStudio.Services.LoadReporter.LoadReporterService.Telerik.TestStudio.Interfaces.Load.ILoadReporterWcfService.FromLoadController_TestDBConnection()


[06/11 17:26:18,Telerik.TestStudio.Services.exe(6616:9)] First trace message from pool unnamed thread (managed ID = 9, native ID = 8000).
[06/11 17:26:18,Telerik.TestStudio.Services.exe(6616:9),Error] LoadReporterService.FromLoadController_TestDBConnection() : EXCEPTION! (see below)
     Situation: Exception detected while trying to connect to the DB.
     Outer Exception Type: System.Data.SqlClient.SqlException
     Message: 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)
     HRESULT: 0x80131904 (Official ID (if app.) = COR_E_SqlException, Error Bit = FAILED, Facility = FACILITY_URT, Code = 6404)
     Call Stack:
          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 System.Data.SqlClient.SqlProviderServices.UsingConnection(SqlConnection sqlConnection, Action`1 act)
          at System.Data.SqlClient.SqlProviderServices.UsingMasterConnection(SqlConnection sqlConnection, Action`1 act)
          at System.Data.SqlClient.SqlProviderServices.DbDatabaseExists(DbConnection connection, Nullable`1 commandTimeout, StoreItemCollection storeItemCollection)
          at System.Data.Objects.ObjectContext.DatabaseExists()
          at Telerik.TestStudio.Services.LoadReporter.LoadReporterEntityBridge.TestDBConnection()
          at Telerik.TestStudio.Services.LoadReporter.LoadReporterService.Telerik.TestStudio.Interfaces.Load.ILoadReporterWcfService.FromLoadController_TestDBConnection()


[06/11 17:26:25,Telerik.TestStudio.Services.exe(6616:22)] First trace message from pool unnamed thread (managed ID = 22, native ID = 5368).
[06/11 17:26:25,Telerik.TestStudio.Services.exe(6616:22),Load] LoadAgentService.PingControllerAsync() : Checking to see if the controller is still active...
[06/11 17:26:25,Telerik.TestStudio.Services.exe(6616:22),Load] LoadAgentService.PingControllerAsync() : Controller is still active.
[06/11 17:27:10,Telerik.TestStudio.Services.exe(6616:8),Error] LoadReporterService.FromLoadController_TestDBConnection() : EXCEPTION! (see below)
     Situation: Exception detected while trying to connect to the DB.
     Outer Exception Type: System.Data.SqlClient.SqlException
     Message: 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)
     HRESULT: 0x80131904 (Official ID (if app.) = COR_E_SqlException, Error Bit = FAILED, Facility = FACILITY_URT, Code = 6404)
     Call Stack:
          at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
          at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
          at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity)
          at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, SqlConnection owningObject)
          at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout)
          at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, 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 System.Data.SqlClient.SqlProviderServices.UsingConnection(SqlConnection sqlConnection, Action`1 act)
          at System.Data.SqlClient.SqlProviderServices.UsingMasterConnection(SqlConnection sqlConnection, Action`1 act)
          at System.Data.SqlClient.SqlProviderServices.DbDatabaseExists(DbConnection connection, Nullable`1 commandTimeout, StoreItemCollection storeItemCollection)
          at System.Data.Objects.ObjectContext.DatabaseExists()
          at Telerik.TestStudio.Services.LoadReporter.LoadReporterEntityBridge.TestDBConnection()
          at Telerik.TestStudio.Services.LoadReporter.LoadReporterService.Telerik.TestStudio.Interfaces.Load.ILoadReporterWcfService.FromLoadController_TestDBConnection()


[06/11 17:27:10,Telerik.TestStudio.Services.exe(6616:11)] First trace message from pool unnamed thread (managed ID = 11, native ID = 7244).
[06/11 17:27:10,Telerik.TestStudio.Services.exe(6616:11),Error] LoadReporterService.FromLoadController_TestDBConnection() : EXCEPTION! (see below)
     Situation: Exception detected while trying to connect to the DB.
     Outer Exception Type: System.Data.SqlClient.SqlException
     Message: 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)
     HRESULT: 0x80131904 (Official ID (if app.) = COR_E_SqlException, Error Bit = FAILED, Facility = FACILITY_URT, Code = 6404)
     Call Stack:
          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 System.Data.SqlClient.SqlProviderServices.UsingConnection(SqlConnection sqlConnection, Action`1 act)
          at System.Data.SqlClient.SqlProviderServices.UsingMasterConnection(SqlConnection sqlConnection, Action`1 act)
          at System.Data.SqlClient.SqlProviderServices.DbDatabaseExists(DbConnection connection, Nullable`1 commandTimeout, StoreItemCollection storeItemCollection)
          at System.Data.Objects.ObjectContext.DatabaseExists()
          at Telerik.TestStudio.Services.LoadReporter.LoadReporterEntityBridge.TestDBConnection()
          at Telerik.TestStudio.Services.LoadReporter.LoadReporterService.Telerik.TestStudio.Interfaces.Load.ILoadReporterWcfService.FromLoadController_TestDBConnection()


[06/11 17:27:25,Telerik.TestStudio.Services.exe(6616:12)] First trace message from pool unnamed thread (managed ID = 12, native ID = 5692).
[06/11 17:27:25,Telerik.TestStudio.Services.exe(6616:12),Load] LoadAgentService.PingControllerAsync() : Checking to see if the controller is still active...
[06/11 17:27:25,Telerik.TestStudio.Services.exe(6616:12),Load] LoadAgentService.PingControllerAsync() : Controller is still active.
[06/11 17:27:30,Telerik.TestStudio.Services.exe(6616:11),Error] LoadReporterService.FromLoadController_TestDBConnection() : EXCEPTION! (see below)
     Situation: Exception detected while trying to connect to the DB.
     Outer Exception Type: System.Data.SqlClient.SqlException
     Message: 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)
     HRESULT: 0x80131904 (Official ID (if app.) = COR_E_SqlException, Error Bit = FAILED, Facility = FACILITY_URT, Code = 6404)
     Call Stack:
          at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
          at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
          at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity)
          at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, SqlConnection owningObject)
          at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout)
          at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, 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 System.Data.SqlClient.SqlProviderServices.UsingConnection(SqlConnection sqlConnection, Action`1 act)
          at System.Data.SqlClient.SqlProviderServices.UsingMasterConnection(SqlConnection sqlConnection, Action`1 act)
          at System.Data.SqlClient.SqlProviderServices.DbDatabaseExists(DbConnection connection, Nullable`1 commandTimeout, StoreItemCollection storeItemCollection)
          at System.Data.Objects.ObjectContext.DatabaseExists()
          at Telerik.TestStudio.Services.LoadReporter.LoadReporterEntityBridge.TestDBConnection()
          at Telerik.TestStudio.Services.LoadReporter.LoadReporterService.Telerik.TestStudio.Interfaces.Load.ILoadReporterWcfService.FromLoadController_TestDBConnection()


[06/11 17:27:49,Telerik.TestStudio.Services.exe(6616:8),Error] LoadReporterService.FromLoadController_TestDBConnection() : EXCEPTION! (see below)
     Situation: Exception detected while trying to connect to the DB.
     Outer Exception Type: System.Data.SqlClient.SqlException
     Message: 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)
     HRESULT: 0x80131904 (Official ID (if app.) = COR_E_SqlException, Error Bit = FAILED, Facility = FACILITY_URT, Code = 6404)
     Call Stack:
          at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
          at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
          at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity)
          at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, SqlConnection owningObject)
          at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout)
          at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, 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 System.Data.SqlClient.SqlProviderServices.UsingConnection(SqlConnection sqlConnection, Action`1 act)
          at System.Data.SqlClient.SqlProviderServices.UsingMasterConnection(SqlConnection sqlConnection, Action`1 act)
          at System.Data.SqlClient.SqlProviderServices.DbDatabaseExists(DbConnection connection, Nullable`1 commandTimeout, StoreItemCollection storeItemCollection)
          at System.Data.Objects.ObjectContext.DatabaseExists()
          at Telerik.TestStudio.Services.LoadReporter.LoadReporterEntityBridge.TestDBConnection()
          at Telerik.TestStudio.Services.LoadReporter.LoadReporterService.Telerik.TestStudio.Interfaces.Load.ILoadReporterWcfService.FromLoadController_TestDBConnection()


[06/11 17:28:09,Telerik.TestStudio.Services.exe(6616:8),Error] LoadReporterService.FromLoadController_TestDBConnection() : EXCEPTION! (see below)
     Situation: Exception detected while trying to connect to the DB.
     Outer Exception Type: System.Data.SqlClient.SqlException
     Message: 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)
     HRESULT: 0x80131904 (Official ID (if app.) = COR_E_SqlException, Error Bit = FAILED, Facility = FACILITY_URT, Code = 6404)
     Call Stack:
          at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
          at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
          at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity)
          at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, SqlConnection owningObject)
          at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout)
          at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, 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 System.Data.SqlClient.SqlProviderServices.UsingConnection(SqlConnection sqlConnection, Action`1 act)
          at System.Data.SqlClient.SqlProviderServices.UsingMasterConnection(SqlConnection sqlConnection, Action`1 act)
          at System.Data.SqlClient.SqlProviderServices.DbDatabaseExists(DbConnection connection, Nullable`1 commandTimeout, StoreItemCollection storeItemCollection)
          at System.Data.Objects.ObjectContext.DatabaseExists()
          at Telerik.TestStudio.Services.LoadReporter.LoadReporterEntityBridge.TestDBConnection()
          at Telerik.TestStudio.Services.LoadReporter.LoadReporterService.Telerik.TestStudio.Interfaces.Load.ILoadReporterWcfService.FromLoadController_TestDBConnection()


[06/11 17:28:14,Telerik.TestStudio.Services.exe(6616:8),Error] LoadReporterService.FromLoadController_TestDBConnection() : EXCEPTION! (see below)
     Situation: Exception detected while trying to connect to the DB.
     Outer Exception Type: System.Data.SqlClient.SqlException
     Message: 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)
     HRESULT: 0x80131904 (Official ID (if app.) = COR_E_SqlException, Error Bit = FAILED, Facility = FACILITY_URT, Code = 6404)
     Call Stack:
          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 System.Data.SqlClient.SqlProviderServices.UsingConnection(SqlConnection sqlConnection, Action`1 act)
          at System.Data.SqlClient.SqlProviderServices.UsingMasterConnection(SqlConnection sqlConnection, Action`1 act)
          at System.Data.SqlClient.SqlProviderServices.DbDatabaseExists(DbConnection connection, Nullable`1 commandTimeout, StoreItemCollection storeItemCollection)
          at System.Data.Objects.ObjectContext.DatabaseExists()
          at Telerik.TestStudio.Services.LoadReporter.LoadReporterEntityBridge.TestDBConnection()
          at Telerik.TestStudio.Services.LoadReporter.LoadReporterService.Telerik.TestStudio.Interfaces.Load.ILoadReporterWcfService.FromLoadController_TestDBConnection()


[06/11 17:28:25,Telerik.TestStudio.Services.exe(6616:227)] First trace message from pool unnamed thread (managed ID = 227, native ID = 5536).
[06/11 17:28:25,Telerik.TestStudio.Services.exe(6616:227),Load] LoadAgentService.PingControllerAsync() : Checking to see if the controller is still active...
[06/11 17:28:25,Telerik.TestStudio.Services.exe(6616:227),Load] LoadAgentService.PingControllerAsync() : Controller is still active.
[06/11 17:28:34,Telerik.TestStudio.Services.exe(6616:8),Error] LoadReporterService.FromLoadController_TestDBConnection() : EXCEPTION! (see below)
     Situation: Exception detected while trying to connect to the DB.
     Outer Exception Type: System.Data.SqlClient.SqlException
     Message: 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)
     HRESULT: 0x80131904 (Official ID (if app.) = COR_E_SqlException, Error Bit = FAILED, Facility = FACILITY_URT, Code = 6404)
     Call Stack:
          at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
          at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
          at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity)
          at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, SqlConnection owningObject)
          at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout)
          at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, 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 System.Data.SqlClient.SqlProviderServices.UsingConnection(SqlConnection sqlConnection, Action`1 act)
          at System.Data.SqlClient.SqlProviderServices.UsingMasterConnection(SqlConnection sqlConnection, Action`1 act)
          at System.Data.SqlClient.SqlProviderServices.DbDatabaseExists(DbConnection connection, Nullable`1 commandTimeout, StoreItemCollection storeItemCollection)
          at System.Data.Objects.ObjectContext.DatabaseExists()
          at Telerik.TestStudio.Services.LoadReporter.LoadReporterEntityBridge.TestDBConnection()
          at Telerik.TestStudio.Services.LoadReporter.LoadReporterService.Telerik.TestStudio.Interfaces.Load.ILoadReporterWcfService.FromLoadController_TestDBConnection()


[06/11 17:28:54,Telerik.TestStudio.Services.exe(6616:8),Error] LoadReporterService.FromLoadController_TestDBConnection() : EXCEPTION! (see below)
     Situation: Exception detected while trying to connect to the DB.
     Outer Exception Type: System.Data.SqlClient.SqlException
     Message: 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)
     HRESULT: 0x80131904 (Official ID (if app.) = COR_E_SqlException, Error Bit = FAILED, Facility = FACILITY_URT, Code = 6404)
     Call Stack:
          at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
          at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
          at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity)
          at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, SqlConnection owningObject)
          at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout)
          at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, 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 System.Data.SqlClient.SqlProviderServices.UsingConnection(SqlConnection sqlConnection, Action`1 act)
          at System.Data.SqlClient.SqlProviderServices.UsingMasterConnection(SqlConnection sqlConnection, Action`1 act)
          at System.Data.SqlClient.SqlProviderServices.DbDatabaseExists(DbConnection connection, Nullable`1 commandTimeout, StoreItemCollection storeItemCollection)
          at System.Data.Objects.ObjectContext.DatabaseExists()
          at Telerik.TestStudio.Services.LoadReporter.LoadReporterEntityBridge.TestDBConnection()
          at Telerik.TestStudio.Services.LoadReporter.LoadReporterService.Telerik.TestStudio.Interfaces.Load.ILoadReporterWcfService.FromLoadController_TestDBConnection()


[06/11 17:29:13,Telerik.TestStudio.Services.exe(6616:8),Error] LoadReporterService.FromLoadController_TestDBConnection() : EXCEPTION! (see below)
     Situation: Exception detected while trying to connect to the DB.
     Outer Exception Type: System.Data.SqlClient.SqlException
     Message: 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)
     HRESULT: 0x80131904 (Official ID (if app.) = COR_E_SqlException, Error Bit = FAILED, Facility = FACILITY_URT, Code = 6404)
     Call Stack:
          at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
          at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
          at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity)
          at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, SqlConnection owningObject)
          at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout)
          at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, 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 System.Data.SqlClient.SqlProviderServices.UsingConnection(SqlConnection sqlConnection, Action`1 act)
          at System.Data.SqlClient.SqlProviderServices.UsingMasterConnection(SqlConnection sqlConnection, Action`1 act)
          at System.Data.SqlClient.SqlProviderServices.DbDatabaseExists(DbConnection connection, Nullable`1 commandTimeout, StoreItemCollection storeItemCollection)
          at System.Data.Objects.ObjectContext.DatabaseExists()
          at Telerik.TestStudio.Services.LoadReporter.LoadReporterEntityBridge.TestDBConnection()
          at Telerik.TestStudio.Services.LoadReporter.LoadReporterService.Telerik.TestStudio.Interfaces.Load.ILoadReporterWcfService.FromLoadController_TestDBConnection()


[06/11 17:29:25,Telerik.TestStudio.Services.exe(6616:228)] First trace message from pool unnamed thread (managed ID = 228, native ID = 5708).
[06/11 17:29:25,Telerik.TestStudio.Services.exe(6616:228),Load] LoadAgentService.PingControllerAsync() : Checking to see if the controller is still active...
[06/11 17:29:25,Telerik.TestStudio.Services.exe(6616:228),Load] LoadAgentService.PingControllerAsync() : Controller is still active.
[06/11 17:29:33,Telerik.TestStudio.Services.exe(6616:8),Error] LoadReporterService.FromLoadController_TestDBConnection() : EXCEPTION! (see below)
     Situation: Exception detected while trying to connect to the DB.
     Outer Exception Type: System.Data.SqlClient.SqlException
     Message: 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)
     HRESULT: 0x80131904 (Official ID (if app.) = COR_E_SqlException, Error Bit = FAILED, Facility = FACILITY_URT, Code = 6404)
     Call Stack:
          at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
          at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
          at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity)
          at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, SqlConnection owningObject)
          at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout)
          at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, 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 System.Data.SqlClient.SqlProviderServices.UsingConnection(SqlConnection sqlConnection, Action`1 act)
          at System.Data.SqlClient.SqlProviderServices.UsingMasterConnection(SqlConnection sqlConnection, Action`1 act)
          at System.Data.SqlClient.SqlProviderServices.DbDatabaseExists(DbConnection connection, Nullable`1 commandTimeout, StoreItemCollection storeItemCollection)
          at System.Data.Objects.ObjectContext.DatabaseExists()
          at Telerik.TestStudio.Services.LoadReporter.LoadReporterEntityBridge.TestDBConnection()
          at Telerik.TestStudio.Services.LoadReporter.LoadReporterService.Telerik.TestStudio.Interfaces.Load.ILoadReporterWcfService.FromLoadController_TestDBConnection()


[06/11 17:29:53,Telerik.TestStudio.Services.exe(6616:8),Error] LoadReporterService.FromLoadController_TestDBConnection() : EXCEPTION! (see below)
     Situation: Exception detected while trying to connect to the DB.
     Outer Exception Type: System.Data.SqlClient.SqlException
     Message: 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)
     HRESULT: 0x80131904 (Official ID (if app.) = COR_E_SqlException, Error Bit = FAILED, Facility = FACILITY_URT, Code = 6404)
     Call Stack:
          at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
          at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
          at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity)
          at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, SqlConnection owningObject)
          at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout)
          at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, 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 System.Data.SqlClient.SqlProviderServices.UsingConnection(SqlConnection sqlConnection, Action`1 act)
          at System.Data.SqlClient.SqlProviderServices.UsingMasterConnection(SqlConnection sqlConnection, Action`1 act)
          at System.Data.SqlClient.SqlProviderServices.DbDatabaseExists(DbConnection connection, Nullable`1 commandTimeout, StoreItemCollection storeItemCollection)
          at System.Data.Objects.ObjectContext.DatabaseExists()
          at Telerik.TestStudio.Services.LoadReporter.LoadReporterEntityBridge.TestDBConnection()
          at Telerik.TestStudio.Services.LoadReporter.LoadReporterService.Telerik.TestStudio.Interfaces.Load.ILoadReporterWcfService.FromLoadController_TestDBConnection()


[06/11 17:30:13,Telerik.TestStudio.Services.exe(6616:16)] First trace message from pool unnamed thread (managed ID = 16, native ID = 6764).
[06/11 17:30:13,Telerik.TestStudio.Services.exe(6616:16),Error] LoadReporterService.FromLoadController_TestDBConnection() : EXCEPTION! (see below)
     Situation: Exception detected while trying to connect to the DB.
     Outer Exception Type: System.Data.SqlClient.SqlException
     Message: 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)
     HRESULT: 0x80131904 (Official ID (if app.) = COR_E_SqlException, Error Bit = FAILED, Facility = FACILITY_URT, Code = 6404)
     Call Stack:
          at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
          at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
          at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity)
          at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, SqlConnection owningObject)
          at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout)
          at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, 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 System.Data.SqlClient.SqlProviderServices.UsingConnection(SqlConnection sqlConnection, Action`1 act)
          at System.Data.SqlClient.SqlProviderServices.UsingMasterConnection(SqlConnection sqlConnection, Action`1 act)
          at System.Data.SqlClient.SqlProviderServices.DbDatabaseExists(DbConnection connection, Nullable`1 commandTimeout, StoreItemCollection storeItemCollection)
          at System.Data.Objects.ObjectContext.DatabaseExists()
          at Telerik.TestStudio.Services.LoadReporter.LoadReporterEntityBridge.TestDBConnection()
          at Telerik.TestStudio.Services.LoadReporter.LoadReporterService.Telerik.TestStudio.Interfaces.Load.ILoadReporterWcfService.FromLoadController_TestDBConnection()


[06/11 17:30:18,Telerik.TestStudio.Services.exe(6616:16),Error] LoadReporterService.FromLoadController_TestDBConnection() : EXCEPTION! (see below)
     Situation: Exception detected while trying to connect to the DB.
     Outer Exception Type: System.Data.SqlClient.SqlException
     Message: 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)
     HRESULT: 0x80131904 (Official ID (if app.) = COR_E_SqlException, Error Bit = FAILED, Facility = FACILITY_URT, Code = 6404)
     Call Stack:
          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 System.Data.SqlClient.SqlProviderServices.UsingConnection(SqlConnection sqlConnection, Action`1 act)
          at System.Data.SqlClient.SqlProviderServices.UsingMasterConnection(SqlConnection sqlConnection, Action`1 act)
          at System.Data.SqlClient.SqlProviderServices.DbDatabaseExists(DbConnection connection, Nullable`1 commandTimeout, StoreItemCollection storeItemCollection)
          at System.Data.Objects.ObjectContext.DatabaseExists()
          at Telerik.TestStudio.Services.LoadReporter.LoadReporterEntityBridge.TestDBConnection()
          at Telerik.TestStudio.Services.LoadReporter.LoadReporterService.Telerik.TestStudio.Interfaces.Load.ILoadReporterWcfService.FromLoadController_TestDBConnection()


[06/11 17:30:25,Telerik.TestStudio.Services.exe(6616:227)] First trace message from pool unnamed thread (managed ID = 227, native ID = 6876).
[06/11 17:30:25,Telerik.TestStudio.Services.exe(6616:227),Load] LoadAgentService.PingControllerAsync() : Checking to see if the controller is still active...
[06/11 17:30:25,Telerik.TestStudio.Services.exe(6616:227),Load] LoadAgentService.PingControllerAsync() : Controller is still active.
[06/11 17:30:37,Telerik.TestStudio.Services.exe(6616:8),Error] LoadReporterService.FromLoadController_TestDBConnection() : EXCEPTION! (see below)
     Situation: Exception detected while trying to connect to the DB.
     Outer Exception Type: System.Data.SqlClient.SqlException
     Message: 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)
     HRESULT: 0x80131904 (Official ID (if app.) = COR_E_SqlException, Error Bit = FAILED, Facility = FACILITY_URT, Code = 6404)
     Call Stack:
          at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
          at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
          at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity)
          at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, SqlConnection owningObject)
          at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout)
          at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, 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 System.Data.SqlClient.SqlProviderServices.UsingConnection(SqlConnection sqlConnection, Action`1 act)
          at System.Data.SqlClient.SqlProviderServices.UsingMasterConnection(SqlConnection sqlConnection, Action`1 act)
          at System.Data.SqlClient.SqlProviderServices.DbDatabaseExists(DbConnection connection, Nullable`1 commandTimeout, StoreItemCollection storeItemCollection)
          at System.Data.Objects.ObjectContext.DatabaseExists()
          at Telerik.TestStudio.Services.LoadReporter.LoadReporterEntityBridge.TestDBConnection()
          at Telerik.TestStudio.Services.LoadReporter.LoadReporterService.Telerik.TestStudio.Interfaces.Load.ILoadReporterWcfService.FromLoadController_TestDBConnection()

[Cody]

Hello,

Hmmm.... the server may be running but Test Studio is unable to connect to it for some reason:

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.

This is something I can't really help troubleshoot remotely. One suggestion however, if you changed the server name or the instance name in the Configuring Services dialog, be sure to stop all services and restart them in order to make the change active. The services won't reload any configuration changes until they are all restarted.

P.S. you can always place the log into a .zip file and attach that file.

All the best,
Cody
the Telerik team

[Matt]

It seems that restarting SQL worked but I had to restart the agent now, not sure why. Thanks!

[Cody]

Hello,

I'm just glad to hear you were able to get it going. Appreciate the update!

Kind regards,
Cody
the Telerik team

[David]

Hello,
I also have the same problem : no possible to connect to MS-SQL Server from the test studio load reporter. Telerik Test Studio 2012.2.920
What was the solution proposed ? I tried to restart the sql-server, but it is still not functioning.
Thanks in advance for any help.


I get the error in log :
[11.14 18:12:43,Telerik.TestStudio.Services.exe(2888:16),Error] LoadReporterService.FromLoadController_TestDBConnection() : EXCEPTION! (see below)
     Situation: Exception detected while trying to connect to the DB.
     Outer Exception Type: System.Data.SqlClient.SqlException
     Message: 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)
     HRESULT: 0x80131904 (Official ID (if app.) = COR_E_SqlException, Error Bit = FAILED, Facility = FACILITY_URT, Code = 6404)
     Call Stack:
          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 System.Data.SqlClient.SqlProviderServices.UsingConnection(SqlConnection sqlConnection, Action`1 act)
          at System.Data.SqlClient.SqlProviderServices.UsingMasterConnection(SqlConnection sqlConnection, Action`1 act)
          at System.Data.SqlClient.SqlProviderServices.DbDatabaseExists(DbConnection connection, Nullable`1 commandTimeout, StoreItemCollection storeItemCollection)
          at System.Data.Objects.ObjectContext.DatabaseExists()
          at Telerik.TestStudio.Services.LoadReporter.LoadReporterEntityBridge.TestDBConnection()
          at Telerik.TestStudio.Services.LoadReporter.LoadReporterService.FromLoadController_TestDBConnection()

[Ivaylo]

Hello David,

Regarding the exception you are getting:

Message: 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)

Please note that we do not support  SQL 2005, if you are using version above 2005 please perform the following steps:

1) Make sure the server is up and running. 
2) Make sure your server name is correct, e.g., no typo on the name. 
3) Make sure your instance name is correct and there is actually such an instance on your target machine. If you are running SQL server locally you can use . in your server name, for example TESTING\SQLEXPRESS, can be replaced by .\SQLEXPRESS 
4) If you are using remote SQL server  make sure the SQL Server is configured to allow remote connections
5) Make sure SQL Browser service is running on the server.
6) Ensure nothing is blocking the connection, like a firewall. Are you able to connect to it outside of Test Studio?

More about the error 26 you can find in this article.

Hope this helps.

Kind regards,
Ivaylo
the Telerik team

[David]

Hello and thanks for your answers.
I have found the problem : the version SQL-Express 2012 is not functioning with TestStudio 2012.
The steps I needed to do :
- remove the SQL-Express 2012
- installation of SQL-Express 2008
- restart the services in load testing configuration
Then it is OK, everything works well.

So only SQL-Express version  2008 is working as reporter for load testing.

thanks four your help and nice day