phoenix81
asked on
Changing allocated memory in SQL Management Studio - No Access - SBS 2011
Hi All,
I am logged into a SBS2011 Server as the domain admin and want to lower the max ram usage setting for Sql. Its using 15gb RAM and the only Sql databases running are SBSMonitoring and BackupExec. Leaving around 200mb RAM free. The server runs like absolute crap so i am hoping setting the ram to a max of 2gb will help.
Only problem is i am logging into the databases using windows authentication and when i click apply to make the change... it comes up that i do not have access. Is there anyway i can get access to make this change easily?
I didn't originally setup this server so am not aware of any special sysadmin logins for sql, i would need to reset them if i have to use the sysadmin account.
Any help would be great.
Thanks
I am logged into a SBS2011 Server as the domain admin and want to lower the max ram usage setting for Sql. Its using 15gb RAM and the only Sql databases running are SBSMonitoring and BackupExec. Leaving around 200mb RAM free. The server runs like absolute crap so i am hoping setting the ram to a max of 2gb will help.
Only problem is i am logging into the databases using windows authentication and when i click apply to make the change... it comes up that i do not have access. Is there anyway i can get access to make this change easily?
I didn't originally setup this server so am not aware of any special sysadmin logins for sql, i would need to reset them if i have to use the sysadmin account.
Any help would be great.
Thanks
In addition to the above.
You will also have a database which is used by WSUS (if you've not removed it).
You can connect to the WSUS Database by entering the following into the Server Name:
\\.\pipe\mssql$microsoft## ssee\sql\q uery
Make sure that you are opening Microsoft SQL Server Management Studio as an Administrator.
In addition, once you do limit the SQL Servers RAM you will find that Exchange will gobble the free RAM. You can also limit the Exchange RAM useage as well.
There is an article on what you're trying to do here:
http://blog.switchsystems.co.uk/2014/01/reducing-memory-usage-on-sbs-servers/
You will also have a database which is used by WSUS (if you've not removed it).
You can connect to the WSUS Database by entering the following into the Server Name:
\\.\pipe\mssql$microsoft##
Make sure that you are opening Microsoft SQL Server Management Studio as an Administrator.
In addition, once you do limit the SQL Servers RAM you will find that Exchange will gobble the free RAM. You can also limit the Exchange RAM useage as well.
There is an article on what you're trying to do here:
http://blog.switchsystems.co.uk/2014/01/reducing-memory-usage-on-sbs-servers/
ASKER
Thanks for the tips :)
ASKER
I am stuck on this part - Now you can add your domain id in sql server logins as a sysadmin and enjoy.
Where in in the management do i do this?
Thanks
Where in in the management do i do this?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
phoenix81, do you still need help with this question?
Option 2 - You can restart SQL server in single user mode. Here is the steps to restart SQL server in single user mode.
https://msdn.microsoft.com/en-us/library/ms345416(v=sql.105).aspx
After changing the startup option restart sql services and connect SQL server using your credentials, But your domain ID should be added in local Administrator windows Group.
Now you can add your domain id in sql server logins as a sysadmin and enjoy.
Change the startup options back once you are done.