+ Post New Thread
Results 1 to 9 of 9
MIS Systems Thread, SIMS MSDE in Technical; This appears to even myself as a stupid question but I just need confirmation..after migration, I need to stop the ...
  1. #1

    Join Date
    May 2007
    Location
    Hale Barns
    Posts
    211
    Thank Post
    39
    Thanked 8 Times in 2 Posts
    Rep Power
    16

    SIMS MSDE

    This appears to even myself as a stupid question but I just need confirmation..after migration, I need to stop the old instance of the SIMS db running on MSDE, right?

    I'm scared to do this because of the two errors in this...

    SIMS System Information Report
    ==============================

    Server Name: EDMUND\SIMS2005

    Database Name: SIMS

    Database Version: <ERROR: Cannot find file 'C:\Program Files\SIMS\SIMS .net\MSSQLDBV.INI'>

    Platform Version: <ERROR: Cannot find file 'C:\Program Files\SIMS\SIMS .net\LOCAL.MEM'>

    Workstation Version: <NONE>

    MDAC Version: 2.81.1117.0

    Windows Version: Windows XP - Version 5.1 (Build 2600: Service Pack 2)

    Processor: x86 Family 15 Model 6 Stepping 4 - GenuineIntel

    Physical Memory: 495MB

    Total Memory: 1.13GB

    (Generated by SIMS System Manager Module on 16/10/2007)

  2. #2

    Join Date
    Sep 2007
    Location
    Somerset
    Posts
    62
    Thank Post
    5
    Thanked 15 Times in 12 Posts
    Rep Power
    17

    Re: SIMS MSDE

    The migration process should automatically detach the SIMS database from the MSDE instance and attach it to the SQL Express instance.

  3. #3

    Join Date
    May 2007
    Location
    Hale Barns
    Posts
    211
    Thank Post
    39
    Thanked 8 Times in 2 Posts
    Rep Power
    16

    Re: SIMS MSDE

    You'd think so, but I'm fairly surely the MSDE instance is still running?!

  4. #4

    Join Date
    Oct 2006
    Location
    uk
    Posts
    494
    Thank Post
    19
    Thanked 3 Times in 2 Posts
    Rep Power
    17

    Re: SIMS MSDE

    msde will still be running sims took the decision to do a side by side install of sql 2005 not an inplace upgrade just in case you have other stuff other than sims that requires the msde still.

  5. #5

    Join Date
    May 2007
    Location
    Hale Barns
    Posts
    211
    Thank Post
    39
    Thanked 8 Times in 2 Posts
    Rep Power
    16

    Re: SIMS MSDE

    yes we do. we have backup exec, rm portal and WASP inventory instances still running but what i'm saying is that the sims instance is still running is msde. how do i know that sims isn't still using that one. stop it?!!!!!

  6. #6

    Join Date
    Sep 2007
    Location
    Somerset
    Posts
    62
    Thank Post
    5
    Thanked 15 Times in 12 Posts
    Rep Power
    17

    Re: SIMS MSDE

    The SIMS instance will still be running, but there should be no SIMS database attached to that instance after migration. This can be tested by either running dbAttach and seeing what databases are available on the MSDE instance to detach, or trying to copy the SIMS.MDF & LDF. (You won't be able to copy them if they are still attached)

  7. #7

    Join Date
    Sep 2007
    Posts
    8
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: SIMS MSDE

    The migration process should redirect the old instance to the new 2005/express, sort of similar to a redirection that the royal mail do when you move house.

  8. #8

    Join Date
    Sep 2007
    Posts
    8
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: SIMS MSDE

    The migration process should redirect the old instance to the new 2005/express, sort of similar to a redirection that the royal mail do when you move house.

  9. #9

    Join Date
    May 2007
    Location
    Hale Barns
    Posts
    211
    Thank Post
    39
    Thanked 8 Times in 2 Posts
    Rep Power
    16

    Re: SIMS MSDE

    In the end I checked the connect ini files to ensure they were looking at the right instance...then i stopped the old one and waited for the calls to coming flooding in..nearly two days later..nada!!

SHARE:
+ Post New Thread

Similar Threads

  1. MSDE the instance name specified is invalid
    By timbo343 in forum Windows
    Replies: 8
    Last Post: 30th September 2010, 05:10 AM
  2. SIMS .net MSDE connection limit
    By localzuk in forum MIS Systems
    Replies: 3
    Last Post: 20th December 2006, 03:23 PM
  3. Backing up MSDE (WMSDE for WSS) database with BackupExec
    By meastaugh1 in forum How do you do....it?
    Replies: 13
    Last Post: 23rd July 2006, 01:56 PM
  4. MSDE SQL
    By thom in forum Windows
    Replies: 4
    Last Post: 10th March 2006, 02:12 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
  •