+ Post New Thread
Results 1 to 12 of 12
MIS Systems Thread, Sims SQL 2008 install in Technical; I am struggling a little bit with SQL 2008 install on a new server, wonder if anyone can prod me ...
  1. #1

    Join Date
    Nov 2005
    Location
    North
    Posts
    1,731
    Thank Post
    23
    Thanked 78 Times in 63 Posts
    Rep Power
    35

    Sims SQL 2008 install

    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.
    Click Install.
    Click Next.
    Enter your Product Key.
    Click Next.
    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.
    Click Next.
    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.
    Click Next
    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.
    Click Next
    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.
    Click Next
    Click Next
    Click Next
    Click Install
    After the installation has completed please run Windows Updates and apply all SQL Server Updates if available.

  2. #2

    Join Date
    Nov 2005
    Location
    North
    Posts
    1,731
    Thank Post
    23
    Thanked 78 Times in 63 Posts
    Rep Power
    35
    Never mind found it, reinstalled it with a instan name of SIMS2008 and enabled the pipes... knew it was something simple.

    Was up till nearly 2 last night getting stuff sorted for it

    Will fizz it over tonight and do some testing.

  3. #3

    Join Date
    Nov 2005
    Location
    North
    Posts
    1,731
    Thank Post
    23
    Thanked 78 Times in 63 Posts
    Rep Power
    35
    well this is 3 hours of my life i can't get back.

    Can't dettach the old sql as I am getting a FMS error saying that there are users still using it.. i don't use FMS... oh and I can't install the management studio cos I don't have enough space.

  4. #4

    Join Date
    Jan 2006
    Location
    Surburbia
    Posts
    2,178
    Thank Post
    74
    Thanked 307 Times in 243 Posts
    Rep Power
    114
    I can't install the management studio cos I don't have enough space.
    That works across the network, if you need it can you install it somewhere else?

  5. #5

    FN-GM's Avatar
    Join Date
    Jun 2007
    Location
    UK
    Posts
    15,393
    Thank Post
    797
    Thanked 1,588 Times in 1,391 Posts
    Blog Entries
    10
    Rep Power
    427
    I wouldn't put your SQL database on your C Drive from the steps above it looks like you have done. I have recently been on a 7 day SQL course. Microsoft Don't really recomend it, although they locate it on the C drive by default.

  6. #6

    Join Date
    Nov 2005
    Location
    North
    Posts
    1,731
    Thank Post
    23
    Thanked 78 Times in 63 Posts
    Rep Power
    35
    Sorted it, after many head scratching I found a laptop had been left on... sent a very nice email to the person asking them why they left it logged into Sims when i asked them not to.

    All done now. Phew.

  7. #7

    FN-GM's Avatar
    Join Date
    Jun 2007
    Location
    UK
    Posts
    15,393
    Thank Post
    797
    Thanked 1,588 Times in 1,391 Posts
    Blog Entries
    10
    Rep Power
    427
    You could have stoped the SQL service. Renamed to connect.ini then started it again then it would have dropped the connection.

  8. #8

    Join Date
    Nov 2005
    Location
    North
    Posts
    1,731
    Thank Post
    23
    Thanked 78 Times in 63 Posts
    Rep Power
    35
    I didn't know that was the reason, the error message mentioned an FMS installation which threw me.

  9. #9

    FN-GM's Avatar
    Join Date
    Jun 2007
    Location
    UK
    Posts
    15,393
    Thank Post
    797
    Thanked 1,588 Times in 1,391 Posts
    Blog Entries
    10
    Rep Power
    427
    Another pointer if you need everyone out of sims view what files are open in computer management that will show you if anyone is on.

  10. #10

    Join Date
    Nov 2005
    Location
    North
    Posts
    1,731
    Thank Post
    23
    Thanked 78 Times in 63 Posts
    Rep Power
    35
    it didn't show it up, its the first thing I looked at.

  11. #11

    FN-GM's Avatar
    Join Date
    Jun 2007
    Location
    UK
    Posts
    15,393
    Thank Post
    797
    Thanked 1,588 Times in 1,391 Posts
    Blog Entries
    10
    Rep Power
    427
    odd it always works for me

  12. #12

    Join Date
    Nov 2005
    Location
    North
    Posts
    1,731
    Thank Post
    23
    Thanked 78 Times in 63 Posts
    Rep Power
    35
    There were no files open, the only way I found the client was by looking in the activity monitor in SQL Management and the connection was there.

SHARE:
+ Post New Thread

Similar Threads

  1. SIMS SQL 2008 migration utility
    By Oops_my_bad in forum MIS Systems
    Replies: 28
    Last Post: 11th February 2010, 02:29 PM
  2. Migrate SIMS database to SQL 2008
    By speckytecky in forum MIS Systems
    Replies: 8
    Last Post: 10th October 2009, 09:43 AM
  3. SIMS SQL 2008 migration
    By matt40k in forum MIS Systems
    Replies: 0
    Last Post: 8th August 2009, 12:08 AM
  4. CMIS and SQL 2008 install
    By sgavan in forum MIS Systems
    Replies: 2
    Last Post: 9th July 2009, 02:31 PM
  5. SIMS SQL Server 2005 re-install
    By philserre in forum MIS Systems
    Replies: 6
    Last Post: 14th October 2008, 08:44 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •