SQL Instance doesn't work with alias

[euromedic]

Hi All!

I moved the LanSweeper database to a new server and now it doesn't work.
The only difference is, we use 3 instances on the new server and we use aliases for each.
The problem is, if I define the server alias in the config files and when I open the LS web page the following error displayed:

System.Data.SqlClient.SqlException: Login failed for user 'domain\lansweeperuser'.
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 DreamweaverCtrls.DataSet.DoInit()

The lansweeperuser has the necessary permissions (owner), and I double checked the password.

Could Anybody help me please?

[euromedic]

Dear Support!

Thank You for help, but we resolved the problem and the problem was the instance name, because I tried with instance;port and instance:port but the right format is instance,port.

Once more thanks for help, You can close the ticket.

[Hemoco]

Could you contact us at support@lansweeper.com and provide us with the following:
- Program Files\Lansweeper\Website\web.config file
- Program Files\Lansweeper\Service\Lansweeperservice.exe.config
- Screenshot of your instance name in SQL Server Management Studio.
- Screenshot of the complete error message you are currently seeing.

[euromedic]

That's fine, if I use only lansweeperuser the error is the same:

System.Data.SqlClient.SqlException: Login failed for user 'lansweeperuser'.
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 DreamweaverCtrls.DataSet.DoInit()



if I define the server name as servername/instance the error is the following:

System.InvalidOperationException: Instance failure.
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 DreamweaverCtrls.DataSet.DoInit()

I tried to define port number too, like instance:port or instance;port but the result is same

Thank You!

[Hemoco]

Your configuration files should specify an SQL user and we generally do not recommend changing the default "lansweeperuser". Most likely the issue is that you changed "lansweeperuser" to "domain\lansweeperuser".