I am struggling a little bit with SQL 2008 install on a new server, wonder if anyone can prod me int he right direction.
I have a new server, I have updated SQL to 2008 on the old server so its running the desktop engine for today so I really would like to get it moved across tonight.
The Sims stuff I found wasn't very thorough. I installed as below but the instance name wasn't allowing me to select it so I tried to install a new instance with the SIMS2008 name but it failed.
I am currently uninstalling SQL2008 and trying again. I know I have to change the pipes too... shoudl I be changing the default instance name to start with to SIMS2008? Then I presume I can just copy the sims folder over, detach the DB and reattach it to the new server?
Was tempted to install the Desktop engine on the new server then just upgrade it.
Insert the disk.
Select Installation from the left hand side.
Click on 'New SQL Server stand-alone installation or add features to an existing installation'
Click Ok after the Support Rules has completed.
Enter your Product Key.
Tick the 'I accept the license terms' and click Next
Select the relevant features you want to install. You must select at least Database Engine Services.
You can either use the Default Instance Name or specify your own instance name by selecting the Named Instance radio button.
You can also change the Instance ID as well. This will change the name of the SQL Server Directory. For example if it was named MSSQLSERVER the SQL Server Directory would be
C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER.
You can also choose the route to where you want SQL 2008 to be installed to.
Click Next once this has been completed.
On the Service Accounts Tab please click on the dropdown and select NT AUTHORITY\SYSTEM for SQL Server Agent and NT AUTHORITY\SYSTEM for the SQL Server Database Engine.
On the Account Provisioning tab choose Mixed Mode and enter in your SA Password for this SQL Instance.
You will then need to click on the Add button to add an Administrator Account as a SQL Server Administrator.
After the installation has completed please run Windows Updates and apply all SQL Server Updates if available.