memory usage sqlservr.exe in SBS2008

Hello,
I have installed a new SBS2008 standard server, no clients connected
yet.
I did MS updates on the server and all went fine.
now i check the server and found out that sqlservr.exe is ussing
5.154.776kB
This is very large and I want to adjust the max of usage.
is this possible and how to?
in command line or in studio manager?
i tried this
http://www.smallbizserver.net/Articl...-SBS-2008.aspx
but i get: user does not have permission...
regards Marc

Hi Marc:

In the enhanced security model of 2008 and Windows 7, you should try right
click and "run as administrator" if you have such a message.


-Please post the resolution to your issue so others may benefit.

-Get Your SBS Health Check at www.sbsbpa.co

Could you describe how? I enabled the administrator in Acive dir users
and computers, but i get the same error.

Marc

> "Marc" <> wrote in message
> news:...
>> Hello,
>> I have installed a new SBS2008 standard server, no clients connected yet.
>> I did MS updates on the server and all went fine.
>> now i check the server and found out that sqlservr.exe is ussing
>> 5.154.776kB
>> This is very large and I want to adjust the max of usage.
>> is this possible and how to?
>> in command line or in studio manager?
>> i tried this
>> http://www.smallbizserver.net/Articl...-SBS-2008.aspx
>> but i get: user does not have permission...
>> regards Marc
>
> Try it using the built in Administrator account.

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@localhost> wrote in message
news:...
> "Marc" <> wrote in message
> news:...
>> 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

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.co

I am having the same issue and I had to switch to the built in admin account
even though the one I created had admin rights. Thanks for posted about that.
I was able to change the max RAM usage to 512MB and it's current lt using
around 330MB but my CPU is till screaming at 100% utilization and it's mostly
from this sqlservr,exe instance. I have the same issue on 2 differentnt
clients SBS2008 boxes (both VMs).

"Brian Cryer" wrote:

>
> "Larry Struckmeyer[SBS-MVP]" <> wrote in message
> news: om...
> > 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
>
> .
>