memory usage sqlservr.exe in SBS2008
|
From: Russ SBITS.Biz [SBS-MVP] on 23 Jun 2010 06:12 What Brian is saying is Login as Domain Administrator on the SBS2008 Server Start the SQL tool by doing a "RUN AS Administrator" Then you will have the permissions and can change things Russ -- Russell Grover - SBITS.Biz [SBS-MVP] MCP, MCPS, MCNPS, SBSC Small Business Server/Computer Support - www.SBITS.Biz BPOS - Microsoft Online Services - www.BPOSMadeEasy.com Microsoft's New SBS Public Support Forum - www.SBSRepair.com "Brian Cryer" <not.here(a)localhost> wrote in message news:uLtkFNrELHA.4504(a)TK2MSFTNGP02.phx.gbl... > "Marc" <marcharms(a)invalid.com> wrote in message > news:OJNkwihELHA.5500(a)TK2MSFTNGP05.phx.gbl... >> Could you describe how? I enabled the administrator in Acive dir users >> and computers, but i get the same error. > > Have you logged in using the administrator account and then tried? > This isn't the same as running-as-administrator. > -- > Brian Cryer > http://www.cryer.co.uk/brian
From: Larry Struckmeyer[SBS-MVP] on 23 Jun 2010 08:22 Can anyone explain how the Marc could have logged on to the server as anything *other* than an administrator, given that there is no indication that he created users that could have logged on the the server that are not administrators? Marc: The account we used to know and love, the built in Administrator account is inactive in Server 2008, and therefore SBS 2008. The account you created when you installed your SBS assumes that role. True, other accounts given Admin rights *may* not have all the authority of the account created on install, but we have yet to see that issue in SBS 2008. Therefore, unless you did something really out of bounds, the account you created when you installed SBS is "the administrator" The built in account is not needed. While logged on at the console as that id, right click and "run as administrator", and if that does not work, let us know. -Please post the resolution to your issue so others may benefit. -Get Your SBS Health Check at www.sbsbpa.com
From: Brian Cryer on 24 Jun 2010 04:39
"Larry Struckmeyer[SBS-MVP]" <lstruckmeyer(a)mis-wizards.com> wrote in message news:4e68351518e748cce0c44a5d6511(a)news.microsoft.com... > Can anyone explain how the Marc could have logged on to the server as > anything *other* than an administrator, given that there is no indication > that he created users that could have logged on the the server that are > not administrators? The key thing here is not as "an administrator" but as "the administrator" .... but having looked into it (see below), I agree with you. > Marc: The account we used to know and love, the built in Administrator > account is inactive in Server 2008, and therefore SBS 2008. The account > you created when you installed your SBS assumes that role. True, other > accounts given Admin rights *may* not have all the authority of the > account created on install, but we have yet to see that issue in SBS 2008. > Therefore, unless you did something really out of bounds, the account you > created when you installed SBS is "the administrator" The built in > account is not needed. While logged on at the console as that id, right > click and "run as administrator", and if that does not work, let us know. The SBS server I'm using is 2008 but it was an upgrade from 2003, so I may have some old hang-overs. That said, on my system I can connect using Microsoft SQL Server Management Studio Express to SBSMONITORING or \\.\pipe\mssql$microsoft##ssee\sql\query. Looking at the set-up, for SBSMONITORING it looks like anyone who is a member of the Builtin/USERS group can connect. For \\.\pipe\mssql$microsoft##ssee\sql\query (which is what I think the OP is interested in), its BUILTIN\Administrators which includes domain admins and the good old Administrator account (I knew I got it from somewhere). On a clean build (not upgrade) that might be the account you initially set up - don't know. So yes, on the face of it anyone who is a member of domain admins should be able to connect - but if the OP still can't then I'd try reenabling the administator account and using that. > -Please post the resolution to your issue so others may benefit. -- Brian Cryer http://www.cryer.co.uk/brian |