WSUS Database User Permsissions

Hey,

I want to upgrade to a windows server 2012 running wsus role using a remote Database Instance SQL 2012, What user role and permissions should I grant on the SUSDB Database ?

Thanks
Hani_SAAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

MaheshArchitectCommented:
The account should have Sysadmin and public roles to suffice the requirements
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
btanExec ConsultantCommented:
You should make sure that the person who is going to install WSUS 3.0 on the front-end computer has administrative permissions on SQL Server. Specifically in the remote SQL, those accounts need to have database access as per
Set up this account for the roles needed to set up the WSUS 3.0 database. The roles are either dbcreator plus diskadmin, or sysadmin. Accounts belonging to the local Administrators group have the sysadmin role by default.
0
Hani_SAAuthor Commented:
Thank you guys for your replies.

Just to clarify one thing; I'm going to install WSUS role on windows server 2012 using a remote SQL server 2012.
So if I install the role using a local admin account, the SUSDB database will be created on the remote SQL server using this user right?
Or do I need to setup the Database prior to installing the role "update service" ? and what about the Database collation type, should it be: SQL_Latin_General_CP1_CI_AS ? DB size ~ 10 GB ? Standard or Enterprise version, does it matter ?
If that is the case so I need to create a user on the database, what about its membership and role for 2012 SQL?

Thank you
0
MaheshArchitectCommented:
The SQL Collation is OK

The account should be domain account and part of local admin group on SUS server to install SUS role

Same time account should be granted Sysadmin and public role on remote SQL server
OR
you can add it to local administrators group on SQL server if wanted to.

Also ensure that SQL browser service is running on remote SQL server

SUSDB should get created on remote SQL server
0
btanExec ConsultantCommented:
agree with Mahesh. thanks all!
You can check out further in https://technet.microsoft.com/es-es/library/dd939912(v=ws.10).aspx
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2012

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.