Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

WSUS Access Denied

Posted on 2011-09-29
10
369 Views
Last Modified: 2012-05-12
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
Comment
Question by:mgassett
  • 4
  • 3
  • 3
10 Comments
 
LVL 47

Expert Comment

by:Donald Stewart
ID: 36816064
First what changes to WSUS database are you trying to make?
0
 

Author Comment

by:mgassett
ID: 36816132
I'm trying to upgrade from 3.0 to 3.0SP1 and if fails becuase i don't have access.
0
 
LVL 47

Expert Comment

by:Donald Stewart
ID: 36816160
WSUS is actually on sp2. You would definitely save time and headache uninstalling/reinstalling <<<starting from scratch.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 6

Expert Comment

by:penguinjas
ID: 36816445
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
 

Author Comment

by:mgassett
ID: 36817465
Used both local and domain account and getting error message that the user does not have permission to perform this action.
0
 
LVL 6

Expert Comment

by:penguinjas
ID: 36817747
What action?  Were you able to launch SQL management studio?
0
 
LVL 47

Expert Comment

by:Donald Stewart
ID: 36817907
Again, suggest that you just reinstall.
0
 
LVL 6

Expert Comment

by:penguinjas
ID: 36897056
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
 

Accepted Solution

by:
mgassett earned 0 total points
ID: 36980465
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
 

Author Closing Comment

by:mgassett
ID: 37010531
Found the answer by other means.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the…
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question