Re: Patching up the NBNUser login
In case it is of help to anyone, here is a script which sets up the NBNUser login and user on the database from scratch. It may be handy, e.g. if you are trying to fix problems during the install procedure or after moving database files around:
IF NOT EXISTS(SELECT * FROM Master.dbo.SysLogins WHERE Name='NBNUser')
CREATE LOGIN NBNUser WITH PASSWORD='NBNPassword', CHECK_POLICY=OFF
EXEC sp_addsrvrolemember 'NBNUser', 'dbCreator'
EXEC sp_addsrvrolemember 'NBNUser', 'diskAdmin'
USE NBNData
IF NOT EXISTS(SELECT * FROM SysUsers WHERE Name='NBNUser')
CREATE USER [NBNUser] FOR LOGIN [NBNUser] WITH DEFAULT_SCHEMA=[NBNUser]
GO
EXEC sp_addrolemember 'db_backupoperator', 'NBNUser'
EXEC sp_addrolemember 'db_datareader', 'NBNUser'
EXEC sp_addrolemember 'db_datawriter', 'NBNUser'
EXEC sp_addrolemember 'db_ddladmin', 'NBNUser'
EXEC sp_addrolemember 'db_owner', 'NBNUser'
EXEC sp_change_users_login 'Update_One', 'NBNUser', 'NBNUser'John van Breda
Biodiverse IT
Biodiverse IT