+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 22
MIS Systems Thread, Error 0 in Technical; ...
  1. #1

    Join Date
    Jul 2010
    Posts
    565
    Thank Post
    67
    Thanked 24 Times in 20 Posts
    Rep Power
    14

    Error 0

    Had a quick google about and found that its either a password error or a connect.ini error.

    Our set up is Sims installed on one computer PC. Then we have 4 other computers connecting to it.
    Since yesterday dinnertime noone can connect to SIMS, as far as i can tell nothing has been done to either the installed computer or the others that connect to it.

    As I'm not responsible for SIMS I dont want to do anything that may make it worse.
    Just wondered what your trouble shooting would be on this?

    Solution: Browse to C:\Program Files\SIMS\SIMS .Net and ope the file connect.ini under the field “ServerName=” enter the servername of your sims server, backslash, sims sql instance for example “ServerName=SIMSSERVER\SIMS2008″
    would that need doing on all computers?
    #

  2. #2
    nikaso's Avatar
    Join Date
    May 2010
    Location
    The Death Star
    Posts
    311
    Thank Post
    20
    Thanked 50 Times in 27 Posts
    Rep Power
    17
    Ahh, the old Error 0. Connect.ini is a problem but you will also see the issue if there is a loss of network connectivity. We have a member of staff who forgets to turn their wireless on sometimes and gets the error 0 code.

    I'm assuming the PC you have it installed on is the SIMS server? We have our system set up to look at a single shared connect.ini file on the server but in your case it sounds as though you might need to change it on each PC.

  3. #3

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,680
    Thank Post
    516
    Thanked 2,451 Times in 1,897 Posts
    Blog Entries
    24
    Rep Power
    832
    It all depends on what your connect.ini file has in it at the moment. Can you post it here?

  4. #4

    Jawloms's Avatar
    Join Date
    Aug 2007
    Posts
    817
    Thank Post
    175
    Thanked 104 Times in 72 Posts
    Rep Power
    185
    Might a Windows Update have turned the firewall on?

  5. #5

    Join Date
    Mar 2009
    Location
    uk
    Posts
    15
    Thank Post
    3
    Thanked 2 Times in 2 Posts
    Rep Power
    11
    Quote Originally Posted by Jawloms View Post
    Might a Windows Update have turned the firewall on?
    Also see if you had a antivirus update, can block SIMS if not on the trusted programs list

  6. #6

    Join Date
    Jul 2010
    Posts
    565
    Thank Post
    67
    Thanked 24 Times in 20 Posts
    Rep Power
    14
    right on the server pc in
    C:\Program Files\SIMS\SIMS .Net \conect
    [SIMSConnection]
    ServerName=of2-sims\sims2008
    DatabaseName=SIMS
    ServerType=SIMSSQL

    However in C:SIMS\conect i have
    [SIMSConnection]
    ServerName=OF2-SIMS\SIMS2008
    DatabaseName=sims

    on the client pc's
    C:\Programfiles\Sims\Sims .net
    [Simsconection]
    Redirect=L:\SIMS

    L is the shared drive on the server pc which is this file
    However in C:SIMS\conect i have
    [SIMSConnection]
    ServerName=OF2-SIMS\SIMS2008
    DatabaseName=sims

    Thanks for your help.

    SIMS support says its our problem not theirs

  7. #7

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,680
    Thank Post
    516
    Thanked 2,451 Times in 1,897 Posts
    Blog Entries
    24
    Rep Power
    832
    That looks fine to me.

    I would say the issue will be something like a firewall issue then.

  8. #8
    MrMat's Avatar
    Join Date
    Jul 2013
    Location
    Solihull
    Posts
    155
    Thank Post
    17
    Thanked 33 Times in 25 Posts
    Rep Power
    27
    Agree with the above.

    Potential for the SQL service to have been stopped? This would also cause the same error. Have a look at the Local Services on the machine running the SIMS database, check that the service called SQL Server (OF2-SIMS) is running.

  9. #9

    Join Date
    Mar 2009
    Location
    uk
    Posts
    15
    Thank Post
    3
    Thanked 2 Times in 2 Posts
    Rep Power
    11
    Localzuk i think is right, other thing you can do is copy the connect ini from C drive and paste it over the Clients PC one. We had problems with the connect ini with the redirect and firewalls.

    Copy the clients connect ini and put it some where safe just in case you need to put it back.

  10. #10

    Join Date
    Jul 2010
    Posts
    565
    Thank Post
    67
    Thanked 24 Times in 20 Posts
    Rep Power
    14
    Right to add more to this I have turned of AV temporarily and we have no firewall on and still nothing.

    Been to local services and SQL Server (OF2-SIM) is set to automatic but looking at it its not running and when I click start I get
    Attachment 23417

    Any ideas how to get this restarted?
    Last edited by MattDLEA; 18th March 2014 at 10:50 AM.

  11. #11
    MrMat's Avatar
    Join Date
    Jul 2013
    Location
    Solihull
    Posts
    155
    Thank Post
    17
    Thanked 33 Times in 25 Posts
    Rep Power
    27
    Cannot open the attachment unfortunately, it says 'Invalid Attachment Specified'.

    I presume it's an error message, what does it say?

  12. #12

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,406
    Thank Post
    368
    Thanked 639 Times in 521 Posts
    Rep Power
    158
    Check Event Viewer for more info, failing that the errorlog in the SQL logs folder. Also worth checking Event viewer to see if Windows has recorded any bad blocks - ie duff hdd. Check the mdf\ldf are still present as well. I know I'd had it before when someone CUT the databases rather than COPY when they did a backup.

  13. #13

    Join Date
    Jul 2010
    Posts
    565
    Thank Post
    67
    Thanked 24 Times in 20 Posts
    Rep Power
    14
    windows could not start the SQL Server ..... error code 3417

  14. #14

    sparkeh's Avatar
    Join Date
    May 2007
    Posts
    6,744
    Thank Post
    1,275
    Thanked 1,648 Times in 1,104 Posts
    Blog Entries
    22
    Rep Power
    505
    Quote Originally Posted by MattDLEA View Post
    windows could not start the SQL Server ..... error code 3417
    Check that the account that is running the SQL service has permission to access the folder containing the db.

    Or could be a problem with the db? :S
    Last edited by sparkeh; 18th March 2014 at 11:54 AM.

  15. #15
    MrMat's Avatar
    Join Date
    Jul 2013
    Location
    Solihull
    Posts
    155
    Thank Post
    17
    Thanked 33 Times in 25 Posts
    Rep Power
    27
    A very quick Google points to a permissions issue between the account running the SQL Server (Network Service etc) and the Data Folder where the actual database is held.

    Suggested resolution:

    Check what account is running the SQL service (In local services it will say in the right hand column next to the SQL service)

    Browse to the location of your SQL server installation. Will be in Program Files or Program Files (x86), Microsoft SQL Server, MSSQL.10.OF2-SIM, MSSQL then right click the Data folder, Properties, Security then make sure the account running SQL (i.e. local Service etc) has Full Control of this folder.

    SQL Server 2005 Expess – How to fix error 3417 | Decoding the Web

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

Similar Threads

  1. Administrators Nasty File Search errors.
    By Kyle in forum How do you do....it?
    Replies: 5
    Last Post: 24th January 2006, 09:53 PM
  2. Google Spyware error
    By ChrisH in forum Windows
    Replies: 10
    Last Post: 14th December 2005, 08:35 PM
  3. liberum and asp error message
    By russdev in forum Windows
    Replies: 2
    Last Post: 25th November 2005, 01:46 PM
  4. Adduser.conf parse errors
    By ChrisH in forum *nix
    Replies: 4
    Last Post: 18th November 2005, 11:10 AM
  5. Kerberos error - All policies disappeared
    By ajbritton in forum Windows
    Replies: 13
    Last Post: 2nd November 2005, 02:13 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
  •