December 19, 2006 at 6:21 am
When I open up Enterprise Manager, Right click on my SQL Server and go to Properties, under the General Tab it doesn't display any info such as OS, Platform, Processors, etc... they are all blank. If I go to my Memory Tab, it is set to Fixed Memory and will not let me slide the bar over nor change it to dynamically, if I choose dynamically, as soon as I hit OK it sets it back to Fixed. When I go to the processor tab, it lists no processors in there. What is wrong with this? Did I forget to install something? Why don't I see anything and can't change my memory?
December 19, 2006 at 6:23 am
EM can be a bit of a pig - most likely the registration doesn't have sufficient permissions, try re-registering the server.
Also make sure you apply service packs to client tools if you don't have a actual server installed on your PC.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
December 19, 2006 at 10:13 am
Are you doing this remotely or on the server itself? Somethings you cannot do in Enterprise Manager remotely. Anything that affects the server itself, usually has to be done at the server. For example, on the General tab, there is Network Connection. You can change the port used there, but you can't do it from a remote computer.
-SQLBill
December 19, 2006 at 10:35 am
It is from the Server itself.
December 19, 2006 at 10:35 am
How do I re-register the server?
December 19, 2006 at 12:48 pm
Open enterprise manager, right click on the group (default group is SQL Server Group) and select New SQL Server Registration.
-SQLBill
December 19, 2006 at 12:50 pm
Run this from Query Analyzer:
SELECT ServerProperty('Edition'),
ServerProperty('ProductLevel'),
ServerProperty('ProductVersion')
and let us know what it returns.
-SQLBill
December 19, 2006 at 12:57 pm
I Re-Registered it and no changes.
I ran the query and it returned
Standard Edition SP4 8.00.2039
December 20, 2006 at 8:52 am
What account are you using to log into SQL Server and use Enterprise Manager? Does it have SQL Server sysadmin privilege?
-SQLBill
Viewing 9 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply