Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
troubleshooting_c3s_errors [2019/01/23 12:58]
kcifreo
troubleshooting_c3s_errors [2019/01/30 09:50] (current)
Line 1: Line 1:
-====== ​  ​======+====== ​ ====== 
 + 
  
 ===== The '​Microsoft.Jet.OLEDB.4.0'​ provider is not registered on the local machine. ===== ===== The '​Microsoft.Jet.OLEDB.4.0'​ provider is not registered on the local machine. =====
  
 **Cause:** **Cause:**
 +
 +
  
 The C3S Host application is running in 64-bit mode and all of the components it uses must also be 64-bit. There is no 64-bit Jet OLE DB Provider, so you get the message described. The C3S Host application is running in 64-bit mode and all of the components it uses must also be 64-bit. There is no 64-bit Jet OLE DB Provider, so you get the message described.
  
 **Solution:​** **Solution:​**
 +
 +
  
 Contact Technical Support to receive the 32-bit only mode of C3S Host. Contact Technical Support to receive the 32-bit only mode of C3S Host.
 +
 +
  
 ===== Failed to connect to database: Login failed for user ''​. The user is not associated with a trusted SQL Server connection. ===== ===== Failed to connect to database: Login failed for user ''​. The user is not associated with a trusted SQL Server connection. =====
  
 **Cause:** **Cause:**
 +
 +
  
 The C3S Host application to connects to databases using the connections strings stored in the C3SHost.exe.config file. By default the connection string uses a trusted connection with the logged in user's information. If the logged in user does not have the privileges to connect to the supplied database, the connection will be denied with the message above returned. The C3S Host application to connects to databases using the connections strings stored in the C3SHost.exe.config file. By default the connection string uses a trusted connection with the logged in user's information. If the logged in user does not have the privileges to connect to the supplied database, the connection will be denied with the message above returned.
  
 **Solution:​** **Solution:​**
 +
 +
  
 Run the C3SHost from a login that has privieleges to connect to the database. Run the C3SHost from a login that has privieleges to connect to the database.
  
 **OR** **OR**
 +
 +
  
 1. Modify the connection string in the C3SHost.exe.config file and add the User ID and Password attributes with a valid user id and password that will connect to the database. 1. Modify the connection string in the C3SHost.exe.config file and add the User ID and Password attributes with a valid user id and password that will connect to the database.
  
-Ex. Replace <font inherit/​inherit;;#​1abc9c;;​inherit>​connectionString="​Data Source=myServerAddress;​Initial Catalog=myDataBase;​Integrated Security=True;"</​font>​ 
  
-with <font inherit/​inherit;;#​1abc9c;;​inherit>​connectionString="​Data Source=myServerAddress;​Initial Catalog=myDataBase;​</​font><​font inherit/​inherit;;#3498db;;inherit>User Id=myUsername;​Password=myPassword;"​</​font>​+ 
 +Ex. Replace ​connectionString="​Data Source=myServerAddress;​Initial Catalog=myDataBase;​Integrated Security=True;
 + 
 + 
 + 
 +with connectionString="​Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;​Password=myPassword;"​ 
 + 
  
 2. Modify the SSLIP_Options.txt to prevent the change from being overwritten. Add this option: 2. Modify the SSLIP_Options.txt to prevent the change from being overwritten. Add this option:
  
-<font inherit/​inherit;;#​1abc9c;;​inherit>​UpdateC3SHostConfig=0</​font>​+ 
 + 
 +UpdateC3SHostConfig=0 
 + 
  
 ===== Keyword not supported: '​userid'​. ===== ===== Keyword not supported: '​userid'​. =====
  
 **Cause:** **Cause:**
 +
 +
  
 The user id attribute in the connection string in the C3SHost.exe.config file is incorrect. The user id attribute in the connection string in the C3SHost.exe.config file is incorrect.
  
 **Solution:​** **Solution:​**
 +
 +
  
 Change the UserID attribute to User ID (two words). Change the UserID attribute to User ID (two words).
 +
 +
  
 ===== A connection with the server could not be established - URL: http://... . ===== ===== A connection with the server could not be established - URL: http://... . =====
  
 **Cause:** **Cause:**
 +
 +
  
 The SSLIP could not establish a connection with the specified endpoint to the C3S Host. The SSLIP could not establish a connection with the specified endpoint to the C3S Host.
  
 **Possible Solutions:​** **Possible Solutions:​**
 +
 +
  
 1. Verify the C3SHost applicatoin is running. If it is not running, start it and try connecting again. 1. Verify the C3SHost applicatoin is running. If it is not running, start it and try connecting again.
 +
 +
  
 2. View the C3SHost.exe.config file and verify the endpoint address exists in the service node. If it does not, correct the config file. 2. View the C3SHost.exe.config file and verify the endpoint address exists in the service node. If it does not, correct the config file.
 +
 +
  
 ===== Cannot start your application. The workgroup information file is missing or opened exclusively by another user. ===== ===== Cannot start your application. The workgroup information file is missing or opened exclusively by another user. =====
  
 **Cause:** **Cause:**
 +
 +
  
 Another program is accessing the SMSStore.mdb file and has locked it. Another program is accessing the SMSStore.mdb file and has locked it.
  
 **Solution:​** **Solution:​**
 +
 +
  
 Close the other program and try again Close the other program and try again
 +
 +