English 
Chinese
Japanese
Russian
News & Events
FavoritesThis configuration is only required for SQL Server installations from sources other than the ShipConstructor installation CD
With the release of ShipConstructor 2008, you can now take advantage of the increased performance and scalability of SQL Server 2005.
To configure your SQL Server 2005 installation to be compatible with ShipConstructor you need to perform the following actions:
1. Domain Password Policy Enforcement
SQL Server 2005 by default enforces your domain password policy for Database user accounts. This impacts ShipConstructor in 2 ways:
-
Generally passwords are now case-sensitive, where in SQL Server 2000 they were case-insensitive, so the default password created by ShipConstructor is now ShipCon with the capitals S, and C.
-
If the password ShipCon that is set for the ShipConstructor user by the SCServerSetup utility is not complex enough for your domain policy, you can change the default password when running SCServerSetup by choosing Custom, and changing the password in the ShipConstructor User settings.
2. Enable TCP/IP and Named Pipes Protocols
To enable these communications protocols, go to:
Start->All Programs->Microsoft SQL Server 2005->Configuration Tools->SQL Server Configuration Manager
Select the Protocols for <Instance Name> node in the tree on the left.
Right-click on Named Pipes, and TCP/IP, and Selected Enable
3. Enable Remote Connections
To enable remote connections, go to:
Start->All Programs->Microsoft SQL Server 2005->Configuration Tools->SQL Server 2005 Surface Area Configuration
Click on the Surface Area Configuration for Services and Connections link.
Under <Instance Name>\Database Engine\Remote Connections, select Local and Remote Connections, and Using both TCP/IP and named pipes, as shown below:
Apply your changes when done.
4. Turn on the SQL Server Browser Service
To enable remote connections, go to:
Start->All Programs->Microsoft SQL Server 2005->Configuration Tools->SQL Server 2005 Surface Area Configuration
Click on the Surface Area Configuration for Services and Connections link.
Under <Instance Name>\SQL Server Browser\Service, set the startup type to Automatic, and click the Start button to start the service.
Apply your changes when done.
5. Enable xp_cmdshell
Make sure the xp_cmdshell stored procedure is enabled on the server. This procedure is required for browsing server folders in administrator.
To enable xp_cmdshell, go to:
Start->All Programs->Microsoft SQL Server 2005->Configuration Tools->SQL Server 2005 Surface Area Configuration
Click on the Surface Area Configuration for Features link.
Under <Instance Name>\Database Engine\xp_cmdshell, Check the Enable xp_cmdshell checkbox, and click the Apply button to enable the feature.
6. After following these procedures, please run Server Setup in order to complete the configuration.
Troubleshooting
Q: I performed all of the steps shown above, but I do not see my server in the list of available servers.
A1: First, try restarting your server machine. Restarting the SQL server service is not always sufficient.
A2: Try installing the latest SQL Server 2005 service pack. At the time of this writing, the latest SQL Server 2005 service pack is SP2. - To obtain the latest SQL Server 2005 Service Pack 2, visit the following Microsoft Web site:
http://www.microsoft.com/downloads/details.aspx?FamilyId=d07219b2-1e23-49c8-8f0c-63fa18f26d3a
