• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 389
  • Last Modified:

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?
0
mgassett
Asked:
mgassett
  • 4
  • 3
  • 3
1 Solution
 
Donald StewartNetwork 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
 
Donald StewartNetwork AdministratorCommented:
WSUS is actually on sp2. You would definitely save time and headache uninstalling/reinstalling <<<starting from scratch.
0
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

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

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

  • 4
  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now