February 24, 2009 at 11:45 am
When I log on to SQL Server Configuration Manager, I am able to see only SSIS service is running status. Rest of them are not present even though SQL server is up and running.
Also, when I try to use SQL Server Surface Area Configuration, I get below error message
"To Configure the Surface Area, one or more services for the database engine or analysis services or Reporting Services must be running. SQLSAC."
Could you please advice.
M&M
February 24, 2009 at 11:50 am
Are you running the configuration manager on the server where you are running SQL Server, or are you running it from a separate workstation?
- 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
February 24, 2009 at 11:56 am
I am trying to run it from the server where the SQL server is running.
I have box level access.
M&M
February 24, 2009 at 2:00 pm
When you open the surface area configuration, what server does it say it's connected to? Local?
- 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
February 24, 2009 at 3:17 pm
SQL Server Configuration Manager is showing as LOCAL
M&M
February 26, 2009 at 1:28 pm
Not sure where to take it from there. I've never had a problem with getting it to connect to the service I needed unless there was a security issue (wrong login, etc.).
- 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
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply