MIS Systems Thread, Error 0 in Technical; Had a quick google about and found that its either a password error or a connect.ini error.
Our set up ...
18th March 2014, 09:10 AM #1
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?
would that need doing on all computers?
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″
18th March 2014, 09:22 AM #2
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.
18th March 2014, 09:23 AM #3
It all depends on what your connect.ini file has in it at the moment. Can you post it here?
18th March 2014, 09:24 AM #4
Might a Windows Update have turned the firewall on?
18th March 2014, 09:43 AM #5
- Rep Power
Also see if you had a antivirus update, can block SIMS if not on the trusted programs list
Originally Posted by Jawloms
18th March 2014, 09:55 AM #6
right on the server pc in
C:\Program Files\SIMS\SIMS .Net \conect
However in C:SIMS\conect i have
on the client pc's
L is the shared drive on the server pc which is this file
However in C:SIMS\conect i have
Thanks for your help.
SIMS support says its our problem not theirs
18th March 2014, 09:57 AM #7
That looks fine to me.
I would say the issue will be something like a firewall issue then.
18th March 2014, 10:04 AM #8
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.
18th March 2014, 10:05 AM #9
- Rep Power
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.
18th March 2014, 10:23 AM #10
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
Any ideas how to get this restarted?
Last edited by MattDLEA; 18th March 2014 at 10:50 AM.
18th March 2014, 11:34 AM #11
Cannot open the attachment unfortunately, it says 'Invalid Attachment Specified'.
I presume it's an error message, what does it say?
18th March 2014, 11:40 AM #12
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.
18th March 2014, 11:44 AM #13
windows could not start the SQL Server ..... error code 3417
18th March 2014, 11:52 AM #14
Check that the account that is running the SQL service has permission to access the folder containing the db.
Originally Posted by MattDLEA
Or could be a problem with the db? :S
Last edited by sparkeh; 18th March 2014 at 11:54 AM.
18th March 2014, 11:54 AM #15
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.
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
By Kyle in forum How do you do....it?
Last Post: 24th January 2006, 09:53 PM
By ChrisH in forum Windows
Last Post: 14th December 2005, 08:35 PM
By russdev in forum Windows
Last Post: 25th November 2005, 01:46 PM
Last Post: 18th November 2005, 11:10 AM
By ajbritton in forum Windows
Last Post: 2nd November 2005, 02:13 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)