Question

FredricJLowe on Sat, 07 Jan 2017 18:35:01


I installed ACT! Pro Version 16 on this laptop running Windows 7 64 bit Home Premium.

The database will not open and I receive error messages indicated SQL Server has started and stopped when I access SQL Server Configuration manager.  Here is the error log:

2017-01-07 12:20:45.82 Server      Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (Intel X86) 
Jun 17 2011 00:57:23 
Copyright (c) Microsoft Corporation
Express Edition on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (WOW64)

2017-01-07 12:20:45.82 Server      (c) Microsoft Corporation.
2017-01-07 12:20:45.82 Server      All rights reserved.
2017-01-07 12:20:45.82 Server      Server process ID is 6016.
2017-01-07 12:20:45.82 Server      System Manufacturer: 'Hewlett-Packard', System Model: 'HP Pavilion dv7 Notebook PC'.
2017-01-07 12:20:45.82 Server      Authentication mode is MIXED.
2017-01-07 12:20:45.82 Server      Logging SQL Server messages in file 'C:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.ACT7\MSSQL\Log\ERRORLOG'.
2017-01-07 12:20:45.82 Server      This instance of SQL Server last reported using a process ID of 5344 at 1/7/2017 12:16:29 PM (local) 1/7/2017 6:16:29 PM (UTC). This is an informational message only; no user action is required.
2017-01-07 12:20:45.82 Server      Registry startup parameters: 
-d C:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.ACT7\MSSQL\DATA\master.mdf
-e C:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.ACT7\MSSQL\Log\ERRORLOG
-l C:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.ACT7\MSSQL\DATA\mastlog.ldf
2017-01-07 12:20:45.86 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2017-01-07 12:20:45.86 Server      Detected 8 CPUs. This is an informational message; no user action is required.
2017-01-07 12:20:45.93 Server      Using dynamic lock allocation.  Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node.  This is an informational message only.  No user action is required.
2017-01-07 12:20:46.06 Server      Node configuration: node 0: CPU mask: 0x000000ff:0 Active CPU mask: 0x000000ff:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2017-01-07 12:20:46.14 spid6s      Starting up database 'master'.
2017-01-07 12:20:46.33 spid6s      SQL Trace ID 1 was started by login "sa".
2017-01-07 12:20:46.33 spid6s      Starting up database 'mssqlsystemresource'.
2017-01-07 12:20:46.39 spid6s      The resource database build version is 10.50.2500. This is an informational message only. No user action is required.
2017-01-07 12:20:46.57 spid6s      Error: 15209, Severity: 16, State: 1.
2017-01-07 12:20:46.57 spid6s      An error occurred during encryption.
2017-01-07 12:20:46.57 spid6s      SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.

ACT technical support had me uninstall SQL Server 2008 and then uninstalled ACT.  We reinstalled ACT and it rebuilt the SQL Server.  That didn't solve the issue.  He then had me download and attempt to install SQL Server 2014 but it asked me to name it as ACT7 but it said another instance of ACT7 was already on the computer and asked me to rename it as another file.  The ACT technician suggested I contract Microsoft.

What can I do to resolve this to enable SQL Server?  I attempted numerous times initially to start SQL but it failed every time.

Thank you for any asssitance you can offer on fixing this issue.


Fred


Sponsored



Replies

Vishe on Sat, 07 Jan 2017 19:20:12


Hi ,

Give full permission on folder.

refer following link

http://www.sqldbadiaries.com/2011/02/10/sql-server-service-does-not-start-an-error-occurred-during-encryption/

José Diz on Sat, 07 Jan 2017 19:31:45


... SQL Server 2008 R2 (SP1), build 10.50.2500.0, Express Edition, 32 bits
... Windows 7 SP1, 64 bits: Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

Error: 15209, Severity: 16, State: 1.
An error occurred during encryption.

Verify that the following document assists in solving the problem: Error message when you try to install SQL Server 2008 or SQL Server 2008 R2: "The SQL Server service failed to start".

After everything is correct, I suggest that you upgrade SQL Server 2008 R2 with the latest service pack: SQL Server 2008 R2 SP3.


    José Diz     Belo Horizonte, MG - Brasil


FredricJLowe on Sun, 08 Jan 2017 00:22:24


I cannot find the Protect folder in the path 

%Systemroot%\ServiceProfiles\NetworkService\AppData\Roaming\Microsoft\Protect





as suggested in the article

Error message when you try to install SQL Server 2008 or SQL Server 2008 R2: "The SQL Server service failed to start"

In the preceding suggestion it was already assigned full control


Above with SQL Server Agent the same issue persists with the same error when trying to START.


Olaf Helper on Sun, 08 Jan 2017 13:34:35


Hello Fred,

I guess ACT uses the free SQL Server Express Edition and the SQL Server-Agent comes along with that Edition, but it's not a supported feature of the edition, therefore you can not start it; you would need a paid Standard or Enterprise Edition.

FredricJLowe on Sun, 08 Jan 2017 18:25:54


So I uninstalled ACT and switched User Accounts to rule that it could have been a corrupt user profile.

Reinstalled and tried to start ACT but the issue persists with this error message

When trying to open the ACT Demo database this is the error message that appears.

Teige Gao on Tue, 10 Jan 2017 09:38:19


Hi FredricJLowe,

According to your description 'Above with SQL Server Agent the same issue persists with the same error when trying to START', the root cause of this problem is that the SQL Server Service cannot start. We need to solve this problem first. After switching User Accounts to rule, can you start the SQL Server Service? You can refer to this case.

Besides, could you please connect with the software provider and get the login of this database, after that, you can use SQL Server Management Studio(SSMS) to connect to this database, this will help to troubleshoot this problem.

If you have any other questions, please let me know.

Best Regards,
Teige