Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

WSUS Access Denied

Posted on 2011-09-29
10
Medium Priority
?
386 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
[X]
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
  • 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
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

 
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: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering 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

Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
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…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

618 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