+ Post New Thread
Results 1 to 5 of 5
MIS Systems Thread, Stand alone install of SIMs in Technical; Hi, Our SIMs server recently died and whilst waiting for nice new one to be delivered we are trying to ...
  1. #1

    Join Date
    Jul 2009
    Posts
    1
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Stand alone install of SIMs

    Hi,

    Our SIMs server recently died and whilst waiting for nice new one to be delivered we are trying to install SIMs on a laptop just to run off some reports.

    So far we have installed SQL Server 2008 (default instance), attached the sims.mdf database to the SQL server, and installed SIMS.net.

    As the laptop has Windows Vista we turned off User Access Control and windows firewall just in case.

    When we ran SIMs for the first time it asked for the location of SIMs on the laptop. We chose "I cannot access a SIMS connect.ini file", left the Server Name as (local) and the database name is sims.

    When I try and log in it just says invalid username and password.

    Looking at the connect.ini file that was created it says:

    [SIMSConnection]
    ServerName=(local)
    DatabaseName= sims
    ServerType=SIMSSQL

    I tried changing the ServerName to the name of the laptop instead of (local) but this still had no effect. Usually the ServerName would be the name of the Server or PC followed by the name of the SQL server instance but we installed SQL server as the default instance.

    Can anyone shed any light on what we might be doing wrong?

  2. #2

    FN-GM's Avatar
    Join Date
    Jun 2007
    Location
    UK
    Posts
    15,773
    Thank Post
    865
    Thanked 1,663 Times in 1,448 Posts
    Blog Entries
    11
    Rep Power
    442
    ah sims will do this if you dont use DB attach to backup the database it will loose the credentials.

    how to get round it i do not know. You will have to get in some how and reset every users password.

  3. #3
    Sarconia's Avatar
    Join Date
    Mar 2010
    Location
    London
    Posts
    315
    Thank Post
    15
    Thanked 34 Times in 31 Posts
    Rep Power
    15
    It might be worth trying to reset the Sysman password to password by running exec sims.db_p_reset_sysman_password in SQL Server Management Studio.

    I'd also give exec sims.db_p_install and exec sims.db_p_grant a go as well as those procedures happen every time you re-attach the database and they help to refresh/restore the logins.

    I wouldn't be too hopeful though, once it's lost them, it's usually a complete PITA to get them back. I have a vague recollection of a rather complex way to do this in SQL Management Studio... recover logins through there but it took quite a long time to do and figure out, I can't quite remember I'm afraid.

  4. #4

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,843
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    SIMS wont run as a default instance...

    I did this last summer thinking i was saving time, but it went wrong.

    Just whack the SQL disk in and add another instance, but it must be named. Then you should be fine.

    I can't remember why this happens, there is a reason, it just can't cope with a blank name for the instance. I'm not sure where it's documented either, maybe check SupportNet. I came across it, whilst setting up a test server to test SLG / sharepoint on. I was using SQL 2005 on my laptop at the time...

    Whatever the reason, i think putting a named instance should fix the issue.

  5. #5

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,843
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    So,
    I did a little search on SupportNet and the results came back inconclusive, damn!
    KB71936 - How to Install SQL 2005 - says choose a named instance.
    KB94307 - How to Install SQL 2008 - says you can choose a named or default instance.
    KB89074 - Shows a DBAttach error regarding backing up DMS when using a default instance on SQL 2005
    KB20794 - How to move document server from one machine to another - describes using default instances again!!

    I still think it's worth a go though, to rule it out if nothing else.

SHARE:
+ Post New Thread

Similar Threads

  1. sims 64bit install
    By ful56_uk in forum MIS Systems
    Replies: 4
    Last Post: 22nd September 2009, 08:12 AM
  2. New SIMS Install
    By massiv3 in forum MIS Systems
    Replies: 13
    Last Post: 3rd July 2009, 05:17 PM
  3. Permission to install SIMS please
    By andy in forum MIS Systems
    Replies: 13
    Last Post: 18th July 2008, 10:54 AM
  4. SIMS Fresh Install
    By binky in forum MIS Systems
    Replies: 10
    Last Post: 7th February 2008, 08:08 PM
  5. SIMS Install Error
    By danIT in forum MIS Systems
    Replies: 4
    Last Post: 7th December 2007, 04:23 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
  •