Issue with creating SUSDB database on remote SQL 2005 server during WSUS installation
hi,
i'm experiencing issue when installing new instance of wsus 3.0 sp1, onto w2003 sp2 server, connecting , creating new susdb database on remote w2003/sql2005 sp2 server.
it fails @ installation @ step 'configuring database'.
looking @ error log: wsusca <time>.log:
changed database context 'susdb'.
msg 15063, level 16, state 1, server sccp101c, line 1
the login has account under different user name.msg 15410, level 11, state 1, server sccp101c, procedure sp_addrolemember, line 75
user or role 'via1\sccp101w$' not exist in database.
running sql trace reveals can create database, tables, stored procedures etc. may failing @ following step:
use susdb
exec sp_grantlogin n'via1\sccp101w$' exec sp_grantdbaccess n'via1\sccp101w$' exec sp_addrolemember webservice,n'via1\sccp101w$'
it appears it's trying create sql login local computer account , failing @ 1 of these steps.
we've followed resolution steps at:
http://support.microsoft.com/?scid=kb%3ben-us%3b920660&x=9&y=17
but has failed fix issue wsus installation seems create basic login wsus computer account 'public' rights
we add explicit 'sysadmin' rights to this existing sql login computer account, re-run installatino process still fails same error message.
the wsus computer account member of sql server's local administrator account. if wasn't, wsus installation not create susdb database or connect remote sql server. supposedly wsus installation uses context of user account 'kicking' off installation, log files reveals it's using local computer account , not user account when running database create procedures.
if has hit error before, if can me work out issue may lie, that'd great.
regards
michael
mpearn@gmail.com
i'm experiencing issue when installing new instance of wsus 3.0 sp1, onto w2003 sp2 server, connecting , creating new susdb database on remote w2003/sql2005 sp2 server.
it fails @ installation @ step 'configuring database'.
looking @ error log: wsusca <time>.log:
changed database context 'susdb'.
msg 15063, level 16, state 1, server sccp101c, line 1
the login has account under different user name.msg 15410, level 11, state 1, server sccp101c, procedure sp_addrolemember, line 75
user or role 'via1\sccp101w$' not exist in database.
running sql trace reveals can create database, tables, stored procedures etc. may failing @ following step:
use susdb
exec sp_grantlogin n'via1\sccp101w$' exec sp_grantdbaccess n'via1\sccp101w$' exec sp_addrolemember webservice,n'via1\sccp101w$'
it appears it's trying create sql login local computer account , failing @ 1 of these steps.
we've followed resolution steps at:
http://support.microsoft.com/?scid=kb%3ben-us%3b920660&x=9&y=17
but has failed fix issue wsus installation seems create basic login wsus computer account 'public' rights
we add explicit 'sysadmin' rights to this existing sql login computer account, re-run installatino process still fails same error message.
the wsus computer account member of sql server's local administrator account. if wasn't, wsus installation not create susdb database or connect remote sql server. supposedly wsus installation uses context of user account 'kicking' off installation, log files reveals it's using local computer account , not user account when running database create procedures.
if has hit error before, if can me work out issue may lie, that'd great.
regards
michael
mpearn@gmail.com
hi mike,
did install terminal service on wsus server?
please ensure frontend machine(wsus server) account login permissions have been removed
the remote sql server
also, please uninstall terminal service frontend machine (you can still have remote desktop).
this article maybe helpful reference:
appendix b: configure remote sql
http://technet2.microsoft.com/windowsserver/en/library/d7183651-b9fb-4288-a15f-33032c40ce2d1033.mspx?mfr=true
--------------------
regards,
eric zhang
did install terminal service on wsus server?
please ensure frontend machine(wsus server) account login permissions have been removed
the remote sql server
also, please uninstall terminal service frontend machine (you can still have remote desktop).
this article maybe helpful reference:
appendix b: configure remote sql
http://technet2.microsoft.com/windowsserver/en/library/d7183651-b9fb-4288-a15f-33032c40ce2d1033.mspx?mfr=true
--------------------
regards,
eric zhang
Windows Server > WSUS
Comments
Post a Comment