Hello,
I've been trying to install SQL Server express edition all day and it errors out every time. I've tried it on two different servers and I get the same errors. Here's what the error log says:
2007-04-20 16:37:52.77 Server Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)
Feb 9 2007 22:47:07
Copyright (c) 1988-2005 Microsoft Corporation
Express Edition on Windows NT 5.2 (Build 3790: Service Pack 2, v.2825)
2007-04-20 16:37:52.77 Server (c) 2005 Microsoft Corporation.
2007-04-20 16:37:52.77 Server All rights reserved.
2007-04-20 16:37:52.77 Server Server process ID is 1356.
2007-04-20 16:37:52.77 Server Authentication mode is MIXED.
2007-04-20 16:37:52.77 Server Logging SQL Server messages in file 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2007-04-20 16:37:52.77 Server This instance of SQL Server last reported using a process ID of 1964 at 4/20/2007 4:37:47 PM (local) 4/20/2007 8:37:47 PM (UTC). This is an informational message only; no user action is required.
2007-04-20 16:37:52.77 Server Registry startup parameters:
2007-04-20 16:37:52.77 Server -d c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2007-04-20 16:37:52.77 Server -e c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2007-04-20 16:37:52.77 Server -l c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2007-04-20 16:37:52.77 Server Command Line Startup Parameters:
2007-04-20 16:37:52.77 Server -d c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Template Data\master.mdf
2007-04-20 16:37:52.77 Server -l c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Template Data\mastlog.ldf
2007-04-20 16:37:52.77 Server -m SqlSetup
2007-04-20 16:37:52.77 Server SqlSetup
2007-04-20 16:37:52.77 Server -Q
2007-04-20 16:37:52.77 Server -q SQL_Latin1_General_CP1_CI_AS
2007-04-20 16:37:52.77 Server -T 4022
2007-04-20 16:37:52.77 Server -T 3659
2007-04-20 16:37:52.77 Server -T 3610
2007-04-20 16:37:52.77 Server -T 4010
2007-04-20 16:37:52.79 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2007-04-20 16:37:52.79 Server Detected 1 CPUs. This is an informational message; no user action is required.
2007-04-20 16:37:52.88 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.
2007-04-20 16:37:52.92 Server Database Mirroring Transport is disabled in the endpoint configuration.
2007-04-20 16:37:52.93 spid5s Warning ******************
2007-04-20 16:37:52.93 spid5s SQL Server started in single-user mode. This an informational message only. No user action is required.
2007-04-20 16:37:52.93 spid5s Starting up database 'master'.
2007-04-20 16:37:52.93 spid5s Error: 17207, Severity: 16, State: 1.
2007-04-20 16:37:52.93 spid5s FCB:pen: Operating system error 5(Access is denied.) occurred while creating or opening file 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Template Data\master.mdf'. Diagnose and correct the operating system error, and retry the operation.
2007-04-20 16:37:52.97 spid5s Error: 17204, Severity: 16, State: 1.
2007-04-20 16:37:52.97 spid5s FCB:pen failed: Could not open file c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Template Data\master.mdf for file number 1. OS error: 5(Access is denied.).
2007-04-20 16:37:52.98 spid5s Error: 5120, Severity: 16, State: 101.
2007-04-20 16:37:52.98 spid5s Unable to open the physical file "c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Template Data\master.mdf". Operating system error 5: "5(Access is denied.)".
2007-04-20 16:37:53.05 spid5s Error: 17207, Severity: 16, State: 1.
2007-04-20 16:37:53.05 spid5s FCB:pen: Operating system error 5(Access is denied.) occurred while creating or opening file 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Template Data\mastlog.ldf'. Diagnose and correct the operating system error, and retry the operation.
2007-04-20 16:37:53.05 spid5s Error: 17204, Severity: 16, State: 1.
2007-04-20 16:37:53.05 spid5s FCB:pen failed: Could not open file c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Template Data\mastlog.ldf for file number 2. OS error: 5(Access is denied.).
2007-04-20 16:37:53.05 spid5s Error: 5120, Severity: 16, State: 101.
2007-04-20 16:37:53.05 spid5s Unable to open the physical file "c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Template Data\mastlog.ldf". Operating system error 5: "5(Access is denied.)".
What exact steps are you trying to perform here and what log file is this comming from?
Basically this is saying that you don't have permissions to a bunch of files that SQL Express is trying to access, the fact that it's happening on two different computers would suggest that they both share some kind of security policy that is limiting your user account in some way. If this is a corporate computer, check with your IT staff to see what kind of security policies they have running, you need to be a computer administrator to install SQL Express.
Mike
|||I'm logged in as administrator however I had to check the option to add my user to the SQL Server Administrator role in order for the install to work.Now that I got it installed I can't connect, the service is running but the osql command fails every time I try it and Plesk cannot connect to the server to add a database.
No comments:
Post a Comment