SQL script upgrade to version 8 from 6.1

Is the management console launched on any of the server(s) you have ?

Hi, Yes. 

Management console on different VM running as separate.

You'll need to log out of the management console on each server to make sure the script has exclusive access the database. 

Hi,

How to logout from management console ? I already check inside management console, I don't see any logout or disconnect.

Hello,

I performed following steps from SGN 6.0 to 7.0:

1. Stop all SGN Services on SafeGuard Server(s) (SGN sync Service, etc..)

2. Stop IIS on SafeGuard Server(s)

3. Add to SQL update script follwing line at the beginning of it (First line):

ALTER DATABASE [<ENTER SAFEGUARD DB NAME>] SET SINGLE_USER WITH ROLLBACK IMMEDIATE; -- attension, all active transactions/connections will be killed, exclusive access to SQL with this
GO

4.

Add to SQL update script follwing line at the beginning of it (last line):

ALTER DATABASE [<ENTER SAFEGUARD DB NAME>] SET MULTI_USER; -- With this access to BD is possible again with multiple connections.
GO

5. Open Microsoft SQL Server Management Studio

6. open modified SQL Update script and execute it

Don't forget to perform backup steps, recommended update steps by Sophos and so on.

Try it and let us know if this was helpful.

Kind regards

Tralveller