+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 16
Windows Thread, Sims FMS problems in Technical; Sims have been leaving messages at the school for a while now but they keep missing me and messages don't ...
  1. #1

    Join Date
    Jan 2009
    Location
    leicestershire
    Posts
    59
    Thank Post
    7
    Thanked 2 Times in 1 Post
    Rep Power
    12

    Sims FMS problems

    Sims have been leaving messages at the school for a while now but they keep missing me and messages don't get relayed properly so I've rung them up today to be told I need to put an Icon on the bursers desktop that points at the server and I need to upgrade. They wouldn't give me any more info than that as they are useless. I've tried upgrading but I just get 'connection failed reason 0' and I haven't a clue what she meant by an icon that points at the server and neither did she apparently.

    Can anyone offer any wisdom?

    Cheers

  2. #2
    Mcshammer_dj's Avatar
    Join Date
    Feb 2007
    Location
    Portsmouth
    Posts
    951
    Thank Post
    37
    Thanked 167 Times in 134 Posts
    Rep Power
    95
    Reason 0 often points to an issue with the connect.ini

    no idea about the icon

  3. #3

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,439
    Thank Post
    368
    Thanked 649 Times in 530 Posts
    Rep Power
    160
    Could be she's using the old FMS.

    Try:
    start | programs | SIMS Applications | FMSSQL | SIMS FMS Module.

    Reason 0 is a connection failure

    Check:
    c:\program files\sims\fmssql\fmsconnect.ini

  4. #4

    Join Date
    Jan 2009
    Location
    leicestershire
    Posts
    59
    Thank Post
    7
    Thanked 2 Times in 1 Post
    Rep Power
    12
    cheers I'll get those checked

  5. #5
    superfletch's Avatar
    Join Date
    Nov 2007
    Location
    South
    Posts
    440
    Thank Post
    153
    Thanked 77 Times in 61 Posts
    Rep Power
    31
    By an icon that points at the server I expect they probably mean a RDP shortcut so that person can log on to the server remotely and carry out SOLUS upgrades?

    Connection failed reason 0 -

    either incorrect connect.ini (FMSConnect.ini in this case) or perhaps the servers firewall/antivirus is blocking the incoming connection to the SQL server.

    If that doesn't resolve then next question is: Is the machine definately on the domain or is it a workaround with some drive mappings and authentication jiggery pokery?
    Last edited by superfletch; 24th February 2009 at 01:24 PM.

  6. #6

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,439
    Thank Post
    368
    Thanked 649 Times in 530 Posts
    Rep Power
    160
    Turn off UAC if it's Vista.

  7. #7

    Join Date
    Jan 2009
    Location
    leicestershire
    Posts
    59
    Thank Post
    7
    Thanked 2 Times in 1 Post
    Rep Power
    12
    Thanks for your replies I'm trying to use solus update on the simsserver for the fms module but upon login I get the reason 0 problem. I've found my fmsconnect.ini file and it reads:
    [FMSConnection]
    Server=simsserver\FMS22005
    Database=ccsfms
    Trusted_Connection=No

    Does this make sense to anyone, looks like it's missing something to me

    Also the bursar reckons the icon sims wanted me to put on the desktop was to back up the fms database to the server.

  8. #8

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,439
    Thank Post
    368
    Thanked 649 Times in 530 Posts
    Rep Power
    160
    simsserver\FMS22005
    Doesn't seem right. 2 2's? Also you have a separate SQL instance just for FMS? Shouldn't it be the same as SIMS?

  9. #9

    Join Date
    Jan 2009
    Location
    leicestershire
    Posts
    59
    Thank Post
    7
    Thanked 2 Times in 1 Post
    Rep Power
    12
    Quote Originally Posted by matt40k View Post
    Doesn't seem right. 2 2's?
    I'm not sure I might try removing one fo the 2s and retrying

    Quote Originally Posted by matt40k View Post
    Also you have a separate SQL instance just for FMS? Shouldn't it be the same as SIMS?
    I'm really not sure I'm new to this school, the servers are a mess, and I haven't really had to touch sims before, do you know how I could find out?

  10. #10

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,439
    Thank Post
    368
    Thanked 649 Times in 530 Posts
    Rep Power
    160
    Look at C:\program files\sims\sims .net\connect.ini
    See what that says if it says redirect, look in the folder for connect.ini, open that.

    What is the server name in there?


    Do you know the SA password?

  11. #11

    Join Date
    Jan 2009
    Location
    leicestershire
    Posts
    59
    Thank Post
    7
    Thanked 2 Times in 1 Post
    Rep Power
    12
    Yes I know the SA password.

    There doesn't look to be the connect.ini file in the sims program files' folder but the way we have the simsroot mapped to the machines is by having a shared filed 'simsroot' on the D:. Inside simroot\sims there is a connect.ini file which reads:
    [SIMSConnection]
    ServerName=simsserver\SIMS
    DatabaseName=SIMS

  12. #12

    Join Date
    Jan 2009
    Location
    leicestershire
    Posts
    59
    Thank Post
    7
    Thanked 2 Times in 1 Post
    Rep Power
    12
    I've also just noticed another fmsconnect.ini file is also stored in d:\simsroot\sims

  13. #13

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,439
    Thank Post
    368
    Thanked 649 Times in 530 Posts
    Rep Power
    160
    Go Start | Programs | SIMS Application | dbattach

    Servername: simsserver\SIMS
    Username: sa
    Password: whatever it is
    Click login

    If you select deattach dropdown list, is SIMS in the list? Is FMS?

    If FMS isn't

    Close dbattach and reopen this time logon with
    Servername: simsserver\FMSS2005
    Username: sa
    Password: whatever it is

    If that fails, try:
    Servername: simsserver\FMS2005
    Username: sa
    Password: whatever it is

  14. #14

    Join Date
    Jan 2009
    Location
    leicestershire
    Posts
    59
    Thank Post
    7
    Thanked 2 Times in 1 Post
    Rep Power
    12
    Thanks for that unfortunately it looks like I don't have the SA username and password
    "sql server does not exist or access denied"

  15. #15

    Join Date
    Jun 2007
    Location
    London
    Posts
    894
    Thank Post
    64
    Thanked 171 Times in 140 Posts
    Rep Power
    55
    If your FMS has also been upgraded to SQL2005 then your FMS database should be on the same server as SIMS, i.e. say your SIMS database is on a SQL server named simsserver\SIMS2005 and the database is named SIMS, then your FMS database is also on the same SQL server instance (named simsserver\SIMS2005) but the FMS database is named ccsfms.

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

Similar Threads

  1. SIMS FMS Printer problems
    By GILLSMITH23 in forum MIS Systems
    Replies: 3
    Last Post: 5th December 2008, 03:46 PM
  2. Moving SIMS\FMS to a new server
    By matt40k in forum MIS Systems
    Replies: 2
    Last Post: 22nd August 2008, 07:58 PM
  3. SIMS FMS Manager upgrade
    By cjohnsonuk in forum MIS Systems
    Replies: 11
    Last Post: 5th March 2008, 08:51 PM
  4. SIMS.NET FMS Module Prob
    By dan4132 in forum Thin Client and Virtual Machines
    Replies: 2
    Last Post: 12th September 2007, 11:09 AM
  5. Sims.Net FMS and Thin clients
    By richard in forum MIS Systems
    Replies: 9
    Last Post: 13th December 2006, 09:10 AM

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
  •