HELP with SQL2005 install - 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

Express Edition and Compact Edition (2005)

HELP with SQL2005 install

Author

Topic

angie93550
Starting Member

3 Posts

Posted - 2008-01-25 : 13:29:40

working with Altiris Software deployment - when installing SQL 2005 i receive the follwing error "failed to set registry settings for server network libraries. the action is SetDefaults. The error is 111 (The file name is too long.)

I have the Install log (error log) and I'm looking at all these errors and pulling my hair out - any help would be appreciated!! Help GURUS!!
2008-01-25 09:35:30.25 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.1 (Build 2600: Service Pack 2)

2008-01-25 09:35:30.57 Server (c) 2005 Microsoft Corporation.
2008-01-25 09:35:30.57 Server All rights reserved.
2008-01-25 09:35:30.59 Server Server process ID is 812.
2008-01-25 09:35:30.59 Server Authentication mode is MIXED.
2008-01-25 09:35:30.64 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2008-01-25 09:35:30.70 Server Registry startup parameters:
2008-01-25 09:35:30.75 Server -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2008-01-25 09:35:30.75 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2008-01-25 09:35:30.75 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2008-01-25 09:35:30.92 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2008-01-25 09:35:30.92 Server Detected 2 CPUs. This is an informational message; no user action is required.
2008-01-25 09:35:32.12 Server Error: 8316, Severity: 16, State: 1.
2008-01-25 09:35:32.12 Server Cannot open registry key 'HKLM\SYSTEM\CurrentControlSet\Services\MSSQL$XACTWARE\Performance'. SQL Server performance counters are disabled.
2008-01-25 09:35:35.48 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.
2008-01-25 09:35:38.79 Server Database mirroring has been enabled on this instance of SQL Server.
2008-01-25 09:35:39.23 spid5s Starting up database 'master'.
2008-01-25 09:35:40.06 spid5s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2008-01-25 09:35:40.76 spid5s SQL Trace ID 1 was started by login "sa".
2008-01-25 09:35:40.98 spid5s Starting up database 'mssqlsystemresource'.
2008-01-25 09:35:41.15 spid5s Error: 17207, Severity: 16, State: 1.
2008-01-25 09:35:41.15 spid5s FCB::Open: Operating system error 21(The device is not ready.) occurred while creating or opening file 'D:\WINDOWS\TEMP\mkmastr_result\mssqlsystemresource.mdf'. Diagnose and correct the operating system error, and retry the operation.
2008-01-25 09:35:41.18 spid5s Error: 17204, Severity: 16, State: 1.
2008-01-25 09:35:41.18 spid5s FCB::Open failed: Could not open file D:\WINDOWS\TEMP\mkmastr_result\mssqlsystemresource.mdf for file number 1. OS error: 21(The device is not ready.).
2008-01-25 09:35:41.28 spid5s Error: 5120, Severity: 16, State: 101.
2008-01-25 09:35:41.28 spid5s Unable to open the physical file "D:\WINDOWS\TEMP\mkmastr_result\mssqlsystemresource.mdf". Operating system error 21: "21(The device is not ready.)".
2008-01-25 09:35:41.70 spid5s Error: 17207, Severity: 16, State: 1.
2008-01-25 09:35:41.70 spid5s FileMgr::StartLogFiles: Operating system error 2(The system cannot find the file specified.) occurred while creating or opening file 'D:\WINDOWS\TEMP\mkmastr_result\mssqlsystemresource.ldf'. Diagnose and correct the operating system error, and retry the operation.
2008-01-25 09:35:41.70 spid5s File activation failure. The physical file name "D:\WINDOWS\TEMP\mkmastr_result\mssqlsystemresource.ldf" may be incorrect.
2008-01-25 09:35:41.74 spid5s Error: 945, Severity: 14, State: 2.
2008-01-25 09:35:41.74 spid5s Database 'mssqlsystemresource' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
2008-01-25 09:35:41.87 spid5s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.

angela

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-01-26 : 00:45:07

Don't put db files in temp directory.