WSUS Access Denied

WSUS 3.0 was installed by a former employee using his network account and apparently the only one with sysadmin rights to WSUS database. When logging into SQL Server 2008 Management Studio it's using windows authentication and even though I login with my admin account I don't have the ability to make any changes because my server role is public. We don't know what the SA password is to log in and make necessary changes. Is the best solution in this case is to reinstall WSUS 3.0? Or is there another way?
mgassettAsked:
Who is Participating?
 
mgassettAuthor Commented:
Logged into the server with the local admin account. In Configuration manager went into SQL server properties and changed the Log on properties, previously set to network service, to local admin. restarted SQL services from there was able to mange setting in SQL Management Studio.
0
 
DonNetwork AdministratorCommented:
First what changes to WSUS database are you trying to make?
0
 
mgassettAuthor Commented:
I'm trying to upgrade from 3.0 to 3.0SP1 and if fails becuase i don't have access.
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
DonNetwork AdministratorCommented:
WSUS is actually on sp2. You would definitely save time and headache uninstalling/reinstalling <<<starting from scratch.
0
 
penguinjasCommented:
Do you have local admin on the SQL box as a local account or domain account?  

If so go into SQL management studio open security then logins.  

Right-click on login and choose new login.  Select Windows Authentication and browse for your admin account.

Select Server Roles and check the sysadmin box.  Select ok and you will now have the necessary access to the database.

  I would not use your user account though for this just as your admin should not have.  Create a new domain account with access to the server and WSUS database not sysadmin for entire server.
0
 
mgassettAuthor Commented:
Used both local and domain account and getting error message that the user does not have permission to perform this action.
0
 
penguinjasCommented:
What action?  Were you able to launch SQL management studio?
0
 
DonNetwork AdministratorCommented:
Again, suggest that you just reinstall.
0
 
penguinjasCommented:
If you don't have the ability to do anything in SQL management Studio do you have other databases on the SQL server?  If you do then re-installing WSUS won't help you since you have no SQL credentials to complete the installation of the database.

If this is the only database on the SQL server then you could re-install SQL and WSUS or try and recover the SA password.  I've never had to recover from this but I did find some resources that may help you.  They reference SQL 2005, but I read in comments below the posting in the first link and people were able to do this in 2008.

http://deepakrangarajan.blogspot.com/2008/01/forgot-sa-password-in-sql-server-2005.html

http://blogs.msdn.com/b/raulga/archive/2007/07/12/disaster-recovery-what-to-do-when-the-sa-account-password-is-lost-in-sql-server-2005.aspx

0
 
mgassettAuthor Commented:
Found the answer by other means.
0
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.

All Courses

From novice to tech pro — start learning today.