When установкt SQL Server I get a message "could Not start the SQL Server service. For more information, see the documentation for SQL Server "How to: view the 2005 installation files of SQL Server magazine" and "running SQL Server manually." ("The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually")
Error code: 29503
Here are the four possible reasons and solutions:
Reason 1. Microsoft SQL Server 2005 is installed on a computer with a multi-core processor, and one of the following conditions:
* The relationship between logical processors and physical sockets is not a power of 2. For example, your computer has one connector together with трехъядерных processors.
* The number of physical cores is not a power of 2.
* The total number of processors is an odd number. For Example, there Are seven or nine processors.
Solution:
To change the number of logical processors for Windows Server 2003, perform the following steps:
1. Click Start, click Run, type MSCONFIG and click OK.
2. In the utility, go to the BOOT.INI tab.
3. On the BOOT.INI tab, click Advanced.
4. IN the BOOT.INI dialog box, Advanced options, check / NUMPROC.
5. In the list, which is located next to a flag / NUMPROC, select "1", and then press the OK button.
6. Press the OK button.
7. Restart the server.
Install SQL Server 2005.
Install the latest service pack for SQL Server 2005.
Now you can clear the NUMPROC (in the MSCONFIG)
Reason 2. The network service account does not have permission on the directory (or one of its sub-folders).
C:\Documents and Settings\NetworkService\Application Data\Microsoft
Solution:
Give the NETWORK SERVICE account full access (Full Access) to this folder (and all subfolders)
or in the installation options SQL change the Network Service account on the Local System.
Cause 3. Installation of SQL Server 2005 is running on a disk with the file structure of the FAT.
Solution:
Convert the file system of the disk to NTFS, or do an installation on another disk with NTFS file system
Reason 4. The computer is not in a domain and the "Domain "is not in the Windows registry on the way HKEY_LOOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters.
Solution:
Create an empty string parameter "Domain "in the key of HKEY_LOOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip
Error code: 29503
Here are the four possible reasons and solutions:
Reason 1. Microsoft SQL Server 2005 is installed on a computer with a multi-core processor, and one of the following conditions:
* The relationship between logical processors and physical sockets is not a power of 2. For example, your computer has one connector together with трехъядерных processors.
* The number of physical cores is not a power of 2.
* The total number of processors is an odd number. For Example, there Are seven or nine processors.
Solution:
To change the number of logical processors for Windows Server 2003, perform the following steps:
1. Click Start, click Run, type MSCONFIG and click OK.
2. In the utility, go to the BOOT.INI tab.
3. On the BOOT.INI tab, click Advanced.
4. IN the BOOT.INI dialog box, Advanced options, check / NUMPROC.
5. In the list, which is located next to a flag / NUMPROC, select "1", and then press the OK button.
6. Press the OK button.
7. Restart the server.
Install SQL Server 2005.
Install the latest service pack for SQL Server 2005.
Now you can clear the NUMPROC (in the MSCONFIG)
Reason 2. The network service account does not have permission on the directory (or one of its sub-folders).
C:\Documents and Settings\NetworkService\Application Data\Microsoft
Solution:
Give the NETWORK SERVICE account full access (Full Access) to this folder (and all subfolders)
or in the installation options SQL change the Network Service account on the Local System.
Cause 3. Installation of SQL Server 2005 is running on a disk with the file structure of the FAT.
Solution:
Convert the file system of the disk to NTFS, or do an installation on another disk with NTFS file system
Reason 4. The computer is not in a domain and the "Domain "is not in the Windows registry on the way HKEY_LOOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters.
Solution:
Create an empty string parameter "Domain "in the key of HKEY_LOOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip
No comments:
Post a Comment