Ej inloggad - Inloggning

Restore backup taken from another server to existing SoftOne Lön SQL server

Restore SoftOne Lön SQL-database-backup taken from another server to existing SoftOne Lön SQL-server. Please note that it is important that the backup comes from a similar sql version or lower than the recipient server. To see existing sql server versions click here

  1. Restore the backup, click here
  2. Run this script in the database: 
    3. sp_changedbowner 'dba'
DROP SCHEMA cpsuser
DROP USER [cpsuser]
Create USER [cpsuser] FOR LOGIN [cpsuser]
GO
EXEC sp_addrolemember N'db_datareader', N'cpsuser'
GO
EXEC sp_addrolemember N'db_denydatawriter', N'cpsuser'
GO
DENY SELECT ON [dbo].[auser] ([au_pword]) TO [cpsuser]
GO