+ Post New Thread
Page 2 of 2 FirstFirst 12
Results 16 to 29 of 29
MIS Systems Thread, SIMS Help... urgent in Technical; what was the old server Os and what is the new one? When moving to 2008 you will need to ...
  1. #16
    Mcshammer_dj's Avatar
    Join Date
    Feb 2007
    Location
    Portsmouth
    Posts
    968
    Thank Post
    38
    Thanked 173 Times in 138 Posts
    Rep Power
    96
    what was the old server Os and what is the new one?

    When moving to 2008 you will need to check the firewall as sims does not always use the standard SQl ports .

  2. Thanks to Mcshammer_dj from:

    PEO (12th April 2010)

  3. #17

    Join Date
    Apr 2010
    Location
    Cheshire
    Posts
    17
    Thank Post
    1
    Thanked 2 Times in 2 Posts
    Rep Power
    10
    I always start with connect.ini's when I get reason 0. The connect.ini on the workstation, particularly if it's been a sims workstation since the last migration, can sometimes contain too much bumph. It should ideally just have:

    [SIMSConnection]
    Redirect=s:\sims

    And then the central connect.ini in s:\sims should have the correct servername and database name in it. e.g.

    [SIMSConnection]
    ServerName=whatevercomputernameis\sims2008

    If connect.ini's are correct and they contain the server name rather than IP address, check that you can ping the server by name from a workstation.

    Shouldn't really need to reinstall any SIMS client on the workstations or adjust the network config on a new sql install.

  4. Thanks to Janit from:

    PEO (12th April 2010)

  5. #18

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    18,157
    Thank Post
    522
    Thanked 2,552 Times in 1,981 Posts
    Blog Entries
    24
    Rep Power
    877
    Quote Originally Posted by Janit View Post
    Shouldn't really need to reinstall any SIMS client on the workstations or adjust the network config on a new sql install.
    Not true. A default SQL install has remote connections disabled by default. So, as part of setup, you have to allow them access.

  6. Thanks to localzuk from:

    PEO (12th April 2010)

  7. #19

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28° 31' 48.89", +28° 25' 37.42" ... if only.
    Posts
    3,256
    Thank Post
    182
    Thanked 375 Times in 304 Posts
    Rep Power
    174
    Quote Originally Posted by Janit View Post
    I always start with connect.ini's when I get reason 0. The connect.ini on the workstation, particularly if it's been a sims workstation since the last migration, can sometimes contain too much bumph. It should ideally just have:

    [SIMSConnection]
    Redirect=s:\sims
    All our connect.inis are like this:

    [SIMSConnection]
    ServerName=PServer\SIMSSQL
    DatabaseName=simssdatabasename
    Commandtimeout=100000

    No redirects.

  8. Thanks to creese from:

    PEO (12th April 2010)

  9. #20
    BatchFile's Avatar
    Join Date
    Aug 2007
    Location
    Cumbria
    Posts
    955
    Thank Post
    548
    Thanked 128 Times in 106 Posts
    Rep Power
    60
    The only problem with that is if you have to move SIMS to another server in a hurry with a redirect on the local machine and the full [SIMSConnection] as above on a mapped drive, all you have to do is change the login script to map the drive to a different server, edit the connect.ini on the mapped drive and you're away. After you've set up another server, of course

  10. Thanks to BatchFile from:

    PEO (12th April 2010)

  11. #21

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28° 31' 48.89", +28° 25' 37.42" ... if only.
    Posts
    3,256
    Thank Post
    182
    Thanked 375 Times in 304 Posts
    Rep Power
    174
    Or copy the connect.ini from the S:\sims directory.

    Redirects have always caused us problems.

  12. #22

    Join Date
    Apr 2010
    Location
    Cheshire
    Posts
    17
    Thank Post
    1
    Thanked 2 Times in 2 Posts
    Rep Power
    10
    Quote Originally Posted by localzuk View Post
    Not true. A default SQL install has remote connections disabled by default. So, as part of setup, you have to allow them access.
    I've never had to change that setting after a new install. Have only taken advantage of disabling it myself for upgrades.

  13. Thanks to Janit from:

    PEO (12th April 2010)

  14. #23
    BatchFile's Avatar
    Join Date
    Aug 2007
    Location
    Cumbria
    Posts
    955
    Thank Post
    548
    Thanked 128 Times in 106 Posts
    Rep Power
    60
    Quote Originally Posted by creese View Post
    Or copy the connect.ini from the S:\sims directory.

    Redirects have always caused us problems.
    That would depend on how many workstations you've got and how urgent the situation is

  15. #24

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28° 31' 48.89", +28° 25' 37.42" ... if only.
    Posts
    3,256
    Thank Post
    182
    Thanked 375 Times in 304 Posts
    Rep Power
    174
    Quote Originally Posted by TonyRidal View Post
    That would depend on how many workstations you've got and how urgent the situation is
    Urgent would be about 1 or 2 workstations at most. How many people urgently need in a school.

  16. Thanks to creese from:

    PEO (12th April 2010)

  17. #25

    Join Date
    Nov 2006
    Location
    Kendal
    Posts
    1,555
    Thank Post
    112
    Thanked 177 Times in 144 Posts
    Rep Power
    72
    Quote Originally Posted by creese View Post
    Urgent would be about 1 or 2 workstations at most. How many people urgently need in a school.
    Well in our school all staff need SIMS "urgently" as it is used for registration every lesson, report cards & logging of behaviour incidents etc. I'd say if it didn't work here it would be considered urgent!

  18. Thanks to jcollings from:

    BatchFile (12th April 2010)

  19. #26

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28° 31' 48.89", +28° 25' 37.42" ... if only.
    Posts
    3,256
    Thank Post
    182
    Thanked 375 Times in 304 Posts
    Rep Power
    174
    I'm talking about Primary phase. Secondaries do their own thing.
    Last edited by creese; 12th April 2010 at 03:21 PM.

  20. Thanks to creese from:

    PEO (12th April 2010)

  21. #27

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,592
    Thank Post
    109
    Thanked 770 Times in 598 Posts
    Rep Power
    183
    The permissions can sometimes get screwed and then present you with a reason 0 message. Run the following SQL commands to fix... it can take a while! (BTW - the syntax assumes your database is called SIMS)

    Code:
    use sims
    exec sims.db_p_install
    exec sims.db_p_grant

  22. Thanks to Ric_ from:

    PEO (12th April 2010)

  23. #28
    PEO
    PEO is offline
    PEO's Avatar
    Join Date
    Oct 2007
    Posts
    2,096
    Thank Post
    457
    Thanked 152 Times in 96 Posts
    Rep Power
    72
    Hi gang thank you to everyone for the fast responce, we tried all the suggestions and narrowed it down to the flipping windows firewall. some how Kaspersky had disabled and windows server 2008 firewall had enabled it self.

    +1 rep to everyone

  24. #29
    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
    30
    Sometimes reason 0/local SIMS logon only is also caused by the SQL server browser agent not running (disabled by default on SQL2008)

SHARE:
+ Post New Thread
Page 2 of 2 FirstFirst 12

Similar Threads

  1. SIMS to Booking System - URGENT
    By 01hanstu in forum MIS Systems
    Replies: 9
    Last Post: 5th March 2010, 09:33 PM
  2. Replies: 12
    Last Post: 18th August 2009, 09:09 AM
  3. Please Help URGENT
    By gibboap in forum Hardware
    Replies: 18
    Last Post: 6th December 2007, 11:27 PM
  4. urgent: Sims.net command line reporter (CLR)
    By russdev in forum MIS Systems
    Replies: 2
    Last Post: 20th September 2007, 02:00 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
  •