June 5, 2008 at 12:40 pm
I'm connecting remotely to a SQL Server 2005 SP1 instance using my SSMS client (version 9.0.3042, SP2).
I do not see the SQL Server Agent node!
If I RDP to the server, I can see the node and the service is up and running!
What could be causing this??
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
June 5, 2008 at 1:29 pm
I haven't run into that one. My first guess would be a rights issue.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
June 5, 2008 at 1:42 pm
GSquared (6/5/2008)
I haven't run into that one. My first guess would be a rights issue.
Thank you, it was a "rights" issue! My NT login - the one I was using to connect to the instance - was not sysadmin on the instance.
It's now fixed.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply