Solved

WSUS Access Denied

Posted on 2011-09-29
10
360 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:dstewartjr
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:dstewartjr
ID: 36816160
WSUS is actually on sp2. You would definitely save time and headache uninstalling/reinstalling <<<starting from scratch.
0
 
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
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

 
LVL 6

Expert Comment

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

Expert Comment

by:dstewartjr
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Many companies are making the switch from Microsoft to Google Apps (https://www.google.com/work/apps/business/). Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

708 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now