+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 18
MIS Systems Thread, SIMS Migration help in Technical; I have previously installed SQL Express and converted all instances other than SIMS over to this (ie. Backup Exec, Sophos, ...
  1. #1
    randle's Avatar
    Join Date
    Dec 2006
    Location
    Chelmsford, Essex
    Posts
    604
    Thank Post
    68
    Thanked 17 Times in 16 Posts
    Rep Power
    20

    SIMS Migration help

    I have previously installed SQL Express and converted all instances other than SIMS over to this (ie. Backup Exec, Sophos, WSUS 3).

    When running the migration tool i get to the "Select and connect to your SQL2005/SQL Express Database Server" screen but from the drop down box this only gives me the option to choose one of the Three instances that already exist ie. SERVER01\MICROSOFT##SSEE, SERVER01\BKUPEXEC and SERVER01\SOPHOS

    Surely i don't select one of these as they are already being used!! A little help would be magic 8O

  2. #2
    Jake's Avatar
    Join Date
    Jan 2006
    Location
    Sunny South Coast
    Posts
    954
    Thank Post
    11
    Thanked 12 Times in 10 Posts
    Rep Power
    22

    Re: SIMS Migration help

    Daft though it may sound, try logging into SIMS on the server, then log out of sims and then run the migration tool again.

  3. #3
    randle's Avatar
    Join Date
    Dec 2006
    Location
    Chelmsford, Essex
    Posts
    604
    Thank Post
    68
    Thanked 17 Times in 16 Posts
    Rep Power
    20

    Re: SIMS Migration help

    It's not the SQL 2000 instance i'm trying to find (SIMS shows up fine here) it's the next screen where it's asking to select a SQL Express database server to connect to which surely would just be "SERVER01"!!?

    Anyway i tried you suggestion but this has changed nothing. Am i missing the picture here?

  4. #4
    Jake's Avatar
    Join Date
    Jan 2006
    Location
    Sunny South Coast
    Posts
    954
    Thank Post
    11
    Thanked 12 Times in 10 Posts
    Rep Power
    22

    Re: SIMS Migration help

    Ah...my bad, I misread the post

    yeah, when I did ours on Tuesday, it just showed "SIMSserver\SIMS2005" , so I imagine you are right, yours should show SERVER01\whatever

  5. #5
    randle's Avatar
    Join Date
    Dec 2006
    Location
    Chelmsford, Essex
    Posts
    604
    Thank Post
    68
    Thanked 17 Times in 16 Posts
    Rep Power
    20

    Re: SIMS Migration help

    I forgot to add that i unticked the "Install a new SQL Express Instance to host SIMS" box as the istructions state that this should be delselected if you already have an installation of SQL Server 2005 present. Should i really tick this?

  6. #6
    Jake's Avatar
    Join Date
    Jan 2006
    Location
    Sunny South Coast
    Posts
    954
    Thank Post
    11
    Thanked 12 Times in 10 Posts
    Rep Power
    22

    Re: SIMS Migration help

    Not sure on that one, as we didnt already have an SQL Server 2005 installation present, so we left it ticked of course

  7. #7

    Join Date
    Feb 2006
    Location
    South Cumbria
    Posts
    199
    Thank Post
    26
    Thanked 29 Times in 24 Posts
    Rep Power
    23

    Re: SIMS Migration help

    I think you are confusing instances and databases. Each instance can contain more than one database so you can add the SIMS database to an existing instance or create a new one depending on your set up. On ours which is full SQLServer 2005 we have the library database and SIMS on the same instance.

  8. #8
    randle's Avatar
    Join Date
    Dec 2006
    Location
    Chelmsford, Essex
    Posts
    604
    Thank Post
    68
    Thanked 17 Times in 16 Posts
    Rep Power
    20

    Re: SIMS Migration help

    Hecate: I thought this first tick box meant the initial install of SQL Express on the server which i had already done. I thought a new SQL Express Instance meant a complete seperate SQL install (I'm new to getting my hands dirtier with SQL so don't laugh)

    I just bit the bullet and ticked the Install a new instance. This has gone through and migrated as expected so i'm one step closer.

    When logging in i now get an error saying "Invalid User Name/Password". I'm definately using the correct username/password so what's going wrong here?

  9. #9
    randle's Avatar
    Join Date
    Dec 2006
    Location
    Chelmsford, Essex
    Posts
    604
    Thank Post
    68
    Thanked 17 Times in 16 Posts
    Rep Power
    20

    Re: SIMS Migration help

    Anyone? I'm getting a little desperate here as No-one can use SIMS currently. Aren't i going to be popular

  10. #10

    Join Date
    Nov 2006
    Location
    Kendal
    Posts
    1,556
    Thank Post
    112
    Thanked 178 Times in 145 Posts
    Rep Power
    72

    Re: SIMS Migration help

    Quote Originally Posted by randle
    Anyone? I'm getting a little desperate here as No-one can use SIMS currently. Aren't i going to be popular
    Have you checked what your s:\sims\connect.ini says and what your connect.ini on your workstations say? I had this problem.

    Should say something like

    \\Servername\instance
    DATABASE=SIMS

  11. #11
    Oops_my_bad's Avatar
    Join Date
    Jan 2007
    Location
    Man chest hair
    Posts
    1,738
    Thank Post
    438
    Thanked 53 Times in 50 Posts
    Rep Power
    31

    Re: SIMS Migration help

    Have you made sure you aren't using trusted logins but instead just using SQL authentication only?

    Failing that do you have a trusty backdoor account into SIMS that you can reset your SIMS password via system manager with?

  12. #12
    randle's Avatar
    Join Date
    Dec 2006
    Location
    Chelmsford, Essex
    Posts
    604
    Thank Post
    68
    Thanked 17 Times in 16 Posts
    Rep Power
    20

    Re: SIMS Migration help

    @jcollings: My SIMS\SIMS\connect.ini file has
    [SIMSConnection]
    ServerName=SERVER01\SIMS
    DatabaseName=SIMS
    and my Program files connect.ini has
    [SIMSConnection]
    Redirect=S:\SIMS
    @TeddyKGB: How do i make sure i'm not using trusted logins?

    No users i try can gain access

  13. #13

    Join Date
    Nov 2006
    Location
    Kendal
    Posts
    1,556
    Thank Post
    112
    Thanked 178 Times in 145 Posts
    Rep Power
    72

    Re: SIMS Migration help

    Quote Originally Posted by randle
    @jcollings: My SIMS\SIMS\connect.ini file has
    [SIMSConnection]
    ServerName=SERVER01\SIMS
    DatabaseName=SIMS
    and my Program files connect.ini has
    [SIMSConnection]
    Redirect=S:\SIMS
    The workstation on is fine. Your server one looks wrong to me.

    Ours before conversion was

    [SIMSConnection]
    ServerName=SERVERNAME\SIMS
    DatabaseName=SIMS

    When I upgraded I changed it to
    [SIMSConnection]
    ServerName=SERVERNAME\SIMS205 (new instance name)
    DatabaseName=SIMS

    That sorted that issue for me. Out of interest it you logon to the SIMS server itself and try to run SIMS do you get the same result?

  14. #14
    randle's Avatar
    Join Date
    Dec 2006
    Location
    Chelmsford, Essex
    Posts
    604
    Thank Post
    68
    Thanked 17 Times in 16 Posts
    Rep Power
    20

    Re: SIMS Migration help

    I've changed the servername to the new instance which i'm sure was going to work but this made no difference unfortunately.

    It's the server i'm trying to run this on

  15. #15
    randle's Avatar
    Join Date
    Dec 2006
    Location
    Chelmsford, Essex
    Posts
    604
    Thank Post
    68
    Thanked 17 Times in 16 Posts
    Rep Power
    20

    Re: SIMS Migration help

    Just been speaking to Capita and none of the data has been migrated over even though the migration tool said it had completed successfully!! I'm wondering whether this is because originally i had the full version of SQL 2000 and am trying to migrate to the free version!!?

    I have also checked the instances i'd installed for Backup Exec & Sophos and it looks like these haven't migrated accross either. Is there a special migration proccess needed for these aswell?

    Anyway we're back up and running on SQL 2000 (Lucky i didn't uninstall) and have been told to try the migration again but i don't hold much hope for this.



SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. Ease of SIMS migration to SQL 2005
    By Ric_ in forum MIS Systems
    Replies: 12
    Last Post: 29th February 2008, 03:06 PM
  2. Replies: 1
    Last Post: 21st December 2007, 04:21 PM
  3. Downloading SIMS Migration toll via SOLUS
    By randle in forum MIS Systems
    Replies: 5
    Last Post: 26th October 2007, 10:17 AM
  4. SIMS migration - help needed!
    By ndavies in forum MIS Systems
    Replies: 15
    Last Post: 9th October 2007, 03:21 PM
  5. SIMS - Migration to new Domain
    By Gatt in forum Windows
    Replies: 2
    Last Post: 20th December 2006, 02:06 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
  •