SQL Server 2005 wont start - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

SQL Server 2005 wont start

Author

Topic

dashabl
Starting Member

2 Posts

Posted - 2011-04-07 : 10:01:26

Hello everyone,

I am completely new to this topic, and I'm not sure if I'm posting it in the right place or not.
I'm a translator and I use Across CAT tool. The mentioned CAT tool needs MS SQL Server 2005 to be installed...I never had any problems with installation of that program before, but when I tried to install it on my laptop with Windows XP OS, I keep getting errors, telling me the server wouldn't start.
I googled it and found few solutions such as one mentioned here http://support.microsoft.com/kb/920114/en-us but there is no protect folder on my computer, as mentioned in the solution. So, anyway, I could really use your help. I'll paste the error message bellow.

Thanks,
Dasha

2011-04-07 14:39:39.86 Server Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86)
Nov 24 2008 13:01:59
Copyright (c) 1988-2005 Microsoft Corporation
Express Edition on Windows NT 5.1 (Build 2600: Service Pack 3)

2011-04-07 14:39:39.86 Server (c) 2005 Microsoft Corporation.
2011-04-07 14:39:39.86 Server All rights reserved.
2011-04-07 14:39:39.86 Server Server process ID is 1480.
2011-04-07 14:39:39.86 Server Authentication mode is MIXED.
2011-04-07 14:39:39.86 Server Logging SQL Server messages in file 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2011-04-07 14:39:39.87 Server This instance of SQL Server last reported using a process ID of 2412 at 4/7/2011 2:39:25 PM (local) 4/7/2011 12:39:25 PM (UTC). This is an informational message only; no user action is required.
2011-04-07 14:39:39.87 Server Registry startup parameters:
2011-04-07 14:39:39.87 Server -d c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2011-04-07 14:39:39.87 Server -e c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2011-04-07 14:39:39.87 Server -l c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2011-04-07 14:39:39.87 Server Command Line Startup Parameters:
2011-04-07 14:39:39.87 Server -m SqlSetup
2011-04-07 14:39:39.87 Server SqlSetup
2011-04-07 14:39:39.87 Server -Q
2011-04-07 14:39:39.87 Server -q SQL_Latin1_General_CP1_CI_AS
2011-04-07 14:39:39.87 Server -T 4022
2011-04-07 14:39:39.87 Server -T 3659
2011-04-07 14:39:39.87 Server -T 3610
2011-04-07 14:39:39.87 Server -T 4010
2011-04-07 14:39:39.88 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2011-04-07 14:39:39.88 Server Detected 1 CPUs. This is an informational message; no user action is required.
2011-04-07 14:39:40.60 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.
2011-04-07 14:39:40.65 Server Database Mirroring Transport is disabled in the endpoint configuration.
2011-04-07 14:39:40.66 spid5s Warning ******************
2011-04-07 14:39:40.66 spid5s SQL Server started in single-user mode. This an informational message only. No user action is required.
2011-04-07 14:39:40.66 spid5s Starting up database 'master'.
2011-04-07 14:39:40.80 spid5s 5 transactions rolled forward in database 'master' (1). This is an informational message only. No user action is required.
2011-04-07 14:39:40.99 spid5s 1 transactions rolled back in database 'master' (1). This is an informational message only. No user action is required.
2011-04-07 14:39:40.99 spid5s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2011-04-07 14:39:41.12 spid5s SQL Trace ID 1 was started by login "sa".
2011-04-07 14:39:41.16 spid5s Starting up database 'mssqlsystemresource'.
2011-04-07 14:39:41.21 spid5s The resource database build version is 9.00.4035. This is an informational message only. No user action is required.
2011-04-07 14:39:41.38 spid5s Error: 15209, Severity: 16, State: 1.
2011-04-07 14:39:41.38 spid5s An error occurred during encryption.
2011-04-07 14:39:41.38 spid5s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2011-04-08 : 06:37:41

http://blogs.msdn.com/b/blakhani/archive/2009/11/24/sql-server-2005-express-setup-failure-with-error-an-error-occurred-during-encryption.aspx

rename C:\Windows\System32\Microsoft (Microsoft) to Microsoft_1 and rerun setup

--------------------------
http://connectsql.blogspot.com/

dashabl
Starting Member

2 Posts

Posted - 2011-04-09 : 21:10:05

Thanks, but it didn't work. I was able to install it on its own by assigning a domain user for it-however I still couldn't get it to start when I was installing the Across program. There is no option to see hidden files during the setup, and that's the only way I could get it to start...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources