Load the SQL disc and run the installation.
1. Click Installation
2. Click New SQL Server stand-alone installation or add features to an existing installation
3. Usually the product key is already entered for you. If not, please enter it now to prevent license issues down the road.
4. Check the box next to I accept the license terms
5. Select SQL Server Feature Installation
6. Check the box next to all the features shown below. These are the minimum required. Don't worry about the installation directories at the bottom. We'll tell you why later.
7. You can use a Named Instance if you would like but if Windchill is the only or first software being used with this SQL installation, the default instance is recommended.
8. Change all the accounts to use NT AUTHORITY\SYSTEM. If this isn't listed by default in the drop down box, click << Browse... >>
9. Enter "system" and click Check Names
10. "SYSTEM" should now show up as below confirming it is a valid object.
11. Repeat for all other services that you can. Change the Startup Type to Automatic. Click Collation.
12. The default collation will not allow you to install Windchill. You need to change the collation manually. Click Customize...
13. Check the box next to Windows collation designator and sort order and set the collation as below to Latin1_General_100_CS_AS_SC.
14. Click Add Current User to add the Windows user you are logged in as an administrator. Feel free to add other users as well with the Add... button. Like in an earlier step, don't worry about the Data Directories in this section. The Windchill install will allow you to specify where the active database files will go regardless of the settings here.
15. Select Mixed Mode (SQL Server authentication and Windows Authentication). This will allow both the previously added windows users as well as a SQL account named "sa" to log in. Depending on the password policy, it may take a few times to create a password that is accepted. Be sure to make it a strong password as this account is used on almost all SQL installations. You will be using the password in the Windchill install steps.
16. Click Install
17. Make sure everything shows a status of Succeeded and close the window.
18. Open up SQL Server Configuration Manager. Expand SQL Server Network Configuration. Select Protocols for MSSQLSERVER. Right click on Named Pipes and click Enable.
19. Select SQL Server Services. Right click and Restart all listed Services.
thanks..workspace in bangalore
ReplyDeleteThank you Erick for providing the step by step installation guide. really helpful.
ReplyDeleteüsküdar bosch klima servisi
ReplyDeletependik mitsubishi klima servisi
tuzla vestel klima servisi
tuzla bosch klima servisi
çekmeköy samsung klima servisi
ataşehir samsung klima servisi
çekmeköy mitsubishi klima servisi
ataşehir mitsubishi klima servisi
beykoz arçelik klima servisi