+ Post New Thread
Results 1 to 14 of 14
MIS Systems Thread, New SIMS Install in Technical; Hi Everyone. I have recently installed a brand fresh version SIMS onto a server. the March 2009. i have successfully ...
  1. #1

    Join Date
    Jun 2009
    Posts
    7
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    New SIMS Install

    Hi Everyone.
    I have recently installed a brand fresh version SIMS onto a server. the March 2009. i have successfully set up everything but when i try to login to SIMS it doesnt let me with the following info

    username : sysman
    password : password

    Any Suggestions?

    Many Thanks

  2. #2

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,442
    Thank Post
    369
    Thanked 650 Times in 531 Posts
    Rep Power
    160
    What database did you attach?

  3. #3

    Join Date
    Jun 2009
    Posts
    7
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    newsimsdatabase.mdf

  4. #4

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,442
    Thank Post
    369
    Thanked 650 Times in 531 Posts
    Rep Power
    160
    Do you get any error messages? First thing would be to check you connect.ini (c:\program files\sims\sims .net) Next would be try de-attaching, re-attach the database (look on support for details)

    After that there is a long list, but it starts with, what version is, how did you install it etc etc etc

  5. #5

    Join Date
    Jun 2009
    Posts
    7
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    when i first attached the database a message came up saying that the SIMS Database was successfully attached.
    then when i tried to login using the username and password sysman : password it wouldnt let me in. the login errror comes up saying username/password incorrect
    Last edited by massiv3; 1st July 2009 at 04:49 PM.

  6. #6

    dhicks's Avatar
    Join Date
    Aug 2005
    Location
    Knightsbridge
    Posts
    5,683
    Thank Post
    1,268
    Thanked 788 Times in 685 Posts
    Rep Power
    237
    Quote Originally Posted by massiv3 View Post
    Any Suggestions?
    Try with a password of "abcd" instead. Otherwise, you can reset the sysman password via a database tool. I can't remember how (search Capita SupportNet, you might find the answer there), but I seem to remember simply calling a stored procedure in the database. It was called something obvious along the lines of "reset sysman password" or similar.

    --
    David Hicks

  7. #7

    Join Date
    Jun 2009
    Posts
    7
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    do you know any good database tools by any chance?

    Thanks for the help

  8. #8

    dhicks's Avatar
    Join Date
    Aug 2005
    Location
    Knightsbridge
    Posts
    5,683
    Thank Post
    1,268
    Thanked 788 Times in 685 Posts
    Rep Power
    237
    Quote Originally Posted by massiv3 View Post
    do you know any good database tools by any chance?
    Sorry, I thought there was some handy command-line tool, but I think I may have simply been thinking of running the stored procedure via the command line. You want (possibly) to run the stored procedure "sims.db_p_reset_sysman_password" on your database, which you should be able to do from your server's MSSQL management console (the "Microsoft SQL Server Management Studio" or whatever it's called).

    --
    David Hicks

  9. #9

    Join Date
    Jun 2009
    Posts
    7
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    update
    i have done the reset sysman password query on the server. once i ran the query a popup came up to say 1 line(s) affected
    checked the main conect.ini file in S:\SIMS to check its all ok. thats fine.
    tried logging into SIMS with sysman : password
    still no luck

  10. #10

    dhicks's Avatar
    Join Date
    Aug 2005
    Location
    Knightsbridge
    Posts
    5,683
    Thank Post
    1,268
    Thanked 788 Times in 685 Posts
    Rep Power
    237
    Quote Originally Posted by massiv3 View Post
    still no luck
    What version of Windows Server is your SIMS server runnning, and what SQL server? I got similar error messages to you when running SIMS on Windows Server 2008 with SQL Server 2005 - when installing SQL Server 2005 I'd missed out the required Windows Server 2008 Internet Services components.

    --
    David Hicks

  11. #11
    Diello's Avatar
    Join Date
    Jun 2005
    Location
    Kent, England
    Posts
    1,063
    Thank Post
    112
    Thanked 228 Times in 128 Posts
    Rep Power
    74
    Tried User: Manager Pass: abcd ?

  12. #12

    Join Date
    Jun 2009
    Posts
    7
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by dhicks View Post
    What version of Windows Server is your SIMS server runnning, and what SQL server? I got similar error messages to you when running SIMS on Windows Server 2008 with SQL Server 2005 - when installing SQL Server 2005 I'd missed out the required Windows Server 2008 Internet Services components.

    --
    David Hicks

    Windows Server 2003 Standard Edition
    Microsoft SQL Server 2005 Express Edition

  13. #13

    dhicks's Avatar
    Join Date
    Aug 2005
    Location
    Knightsbridge
    Posts
    5,683
    Thank Post
    1,268
    Thanked 788 Times in 685 Posts
    Rep Power
    237
    Quote Originally Posted by Diello View Post
    Tried User: Manager Pass: abcd ?
    I think the "incorrect username/password" error is misleading - there's something more fundamentally wrong. I first installed SQL Server 2005 onto our Server 2008 VM from two CDs, stopping the procedure halfway through to mount the next CD, and I forgot to set up all the components that SQL Server 2005 needs to run properly. I then got "incorrect username/password" errors, no matter what I did to try and reset the sysman (or any other) password. Something is hosed, good and proper.

    A thought... are you running the SIMS client on the server or from a workstation? If from a workstation, remember you have to create a firewall exception on your server to allow SIMS to use the SQL database (yes, each SIMS client uses its own SQL connection to your SQL server, hence you need an appropriate number of SQL Server CALs if using SQL Server (the Express edition should be fine)).

    --
    David Hicks

  14. #14

    Join Date
    Jun 2009
    Posts
    7
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    ive ran sims workstation from both the server and a client.

    both the server and client have got the firewalls switched off.

    also tried the manager : abcd and manager : password

    both show incorrect username/password

SHARE:
+ Post New Thread

Similar Threads

  1. SIMS Client Install
    By cookie_monster in forum MIS Systems
    Replies: 4
    Last Post: 15th April 2009, 11:31 PM
  2. Permission to install SIMS please
    By andy in forum MIS Systems
    Replies: 13
    Last Post: 18th July 2008, 10:54 AM
  3. Fresh Install of SIMS (new DB)
    By binky in forum MIS Systems
    Replies: 10
    Last Post: 19th February 2008, 11:09 AM
  4. SIMS Install Error
    By danIT in forum MIS Systems
    Replies: 4
    Last Post: 7th December 2007, 04:23 PM
  5. Re-install SIMS Server?
    By kingswood in forum MIS Systems
    Replies: 16
    Last Post: 18th June 2007, 03:03 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
  •