October 16, 2006 at 9:15 am
I have upgraded a default SQL2000 instance (SP4, HF2187) to SQL2005 (SP1 HF2153) on W2003 SP1. When I try to start SAC to configure Features, I get the message 'one or more services for the Database Engine ... must be running'.
Has anyone else seen this behaviour after doing an in-place upgrade, and if so do you have a fix? If there is no fix, then I can always use sp_configure instead of SAC.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
October 16, 2006 at 3:15 pm
TITLE: Surface Area Configuration
------------------------------
To configure the surface area, one or more services for the Database Engine or Analysis Services or Reporting Services must be running. (SQLSAC)
------------------------------
BUTTONS:
OK
------------------------------
Is this the error message you are talking about?
This screen shows the instances which are running. If there is no SQL Service running on this box, it doesnot make sense to show next screen. I am not sure what is the problem you are facing.
October 17, 2006 at 2:29 am
Balmukund,
I am getting the message you describe, but SQL 2005 is very definitely running on the box. I can see the service in the Windows Services applet, and can connect to it using SQLMS. The problem is that SAC does not recognise it.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
March 29, 2007 at 1:44 pm
Hi
Did you ever resolve this. I have just done exactly the same upgrade and SAC does not see the database but it is definitly running as users are connected to it!
Thanks
March 30, 2007 at 2:37 am
No, the problem remains. Feel free to raise it with Microsoft if you want. IMHO SAC is one of the least reliable of the SQL 2005 tools, and I try to avoid it whenever possible.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
April 3, 2007 at 3:07 am
Hi, is there any way of enabling email notifications without using the SAC?
April 4, 2007 at 2:59 am
You can do everything tha SAC does for SQL Server database services using sp_configure. Check with BOL for the required syntax.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply