3.5 Upgrade issues

[Jrobinson]

Upgraded to 3.5 yesterday. The sql script seemed to lock up and I ran it manually in the SQL management studio. After that the Ls web console including tools seemed to work. I noticed later in the day that no machines were updating even after a trigger scan and the queue was not running.

In the application event log I noticed error event ID's Event Type: Failure Audit
Event Source: MSSQL$SQLEXPRESS
Event Category: (4)
Event ID: 18456
Date: 3/12/2009
Time: 9:12:35 AM
User: NT AUTHORITY\NETWORK SERVICE
Computer: HM-2K3-INVENTOR
Description:
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. [CLIENT: <local machine>]

And

Event Type: Error
Event Source: Report Server Windows Service (SQLEXPRESS)
Event Category: Management
Event ID: 107
Date: 3/12/2009
Time: 9:12:35 AM
User: N/A
Computer: HM-2K3-INVENTOR
Description:
Report Server Windows Service (SQLEXPRESS) cannot connect to the report server database.

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

I made no changes to the logins prior to the upgrade, so there shouldn't be any permission issues.

Getting this error when loading the website:

System.Data.SqlClient.SqlException: A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
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: A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
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()

[Hemoco]

Could you post the errorlog.txt from your service please.

[Jrobinson]

Lansweeper wrote:
Could you post the errorlog.txt from your service please.

Unfortunately I didn't save it. I have lansweeper running on a VM and decided to revert the machine to a snapshot and retry the install. It worked the second time.