Database issues

[Dov]

Greetings,
Had to move the Lansweeper to a new server. New server has the same name as the old one. Did a fresh install of Lansweeper, verified functionality, shut down the lansweeper service, detached the database, attached the original database (same install version and build number as the old server), started the lansweeper service and getting the following error when launching the web interface:
System.Data.SqlClient.SqlException: Cannot open database "lansweeperdb" requested by the login. The login failed.
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()
--------------------------------------------------------------------------------
System.Data.SqlClient.SqlException: Cannot open database "lansweeperdb" requested by the login. The login failed.
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()
--------------------------------------------------------------------------------
System.Data.SqlClient.SqlException: Cannot open database "lansweeperdb" requested by the login. The login failed.
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()
--------------------------------------------------------------------------------
Device overview
Add new device
System.Data.SqlClient.SqlException: Cannot open database "lansweeperdb" requested by the login. The login failed.
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()
--------------------------------------------------------------------------------
System.Exception: The DefaultView was requested but no tables yet exist.
at DreamweaverCtrls.DataSet.get_DefaultView()
--------------------------------------------------------------------------------
System.Data.SqlClient.SqlException: Cannot open database "lansweeperdb" requested by the login. The login failed.
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()
--------------------------------------------------------------------------------
System.Exception: The DefaultView was requested but no tables yet exist.
at DreamweaverCtrls.DataSet.get_DefaultView()
--------------------------------------------------------------------------------

[Hemoco]

Resolved through email. For any errors we recommend contacting us at support@lansweeper.com

[gmitrana]

Lansweeper functional now with the following changes in web.config:

<system.web>
<compilation debug="true" defaultLanguage="VB"/>
<trust level="Full" originUrl="" />
<customErrors mode="Off"/>
<pages enableSessionState="true" />
<sessionState cookieless="false" timeout="20" />
<httpModules>
<add name="Session" type="System.Web.SessionState.SessionStateModule"/>
</httpModules>
</system.web>

[gmitrana]

Partially solved

After 2-3 reinstalls from scratch, let's resume the issues.
First: the installer does not configure properly the permissions for the webapp.

Resolution: set the trust to Full in your web.config...

<trust level="Full" originUrl="" />



Second: After restoring (or attaching) the original DB, it seems that the password for the lansweeperuser created by Lansweeper 4.2 is different than the password we used to have.

Tip: if you don't know the password of your original lansweeperuser, check your web.config to find the new password assigned by the installer. Change the SQL login accordingly. Hovever, there is a schema "lansweeperuser" that will give you some trouble.
Issues: the main page and existing reports work but no other links on the page.

For instance:

default.aspx?item=cust&det=web40repNotLatestSPwinXP&title=OS%3a+Not+latest+Service+Pack+XP

triggers a server error on:

Line 169: <%=datetime.parse(myrow(mycolumn.Caption)).tostring(session("dateformat"))%><%else%>&nbsp;<%end if%>

Source File: C:\Program Files (x86)\Lansweeper\Website\it-cust.aspx Line: 169

Stack Trace:


[HttpException (0x80004005): Session state can only be used when enableSessionState is set to true, either in a configuration file or in the Page directive. Please also make sure that System.Web.SessionStateModule or a custom session state module is included in the <configuration>\<system.web>\<httpModules> section in the application configuration.]
System.Web.UI.Page.get_Session() +4065282
ASP.it_cust_aspx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) in C:\Program Files (x86)\Lansweeper\Website\it-cust.aspx:169
System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +115
System.Web.UI.Page.Render(HtmlTextWriter writer) +38
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4240



No other clues....lost.....

[gmitrana]

Similar issue here...
(Added) Except that the clean install gave the same DB connect errors

Emailed support