This would be expected. A large transaction log would cause database mirror problems. Regular backups and truncation should be performed to the Simplify database transaction log to maintain a small size.
Microsoft KB Article - How to stop the transaction log of a SQL Server database from growing unexpectedly - http://support.microsoft.com/kb/873235
The database backup should be performed daily, possibly more often depending on the rate that the transaction log grows.
This problem is related to authentication. With Windows Authentication, the users' permissions are used to gain access to the Simplify database. This works for the primary domain because when the Simplify database is generated, NT Authority\Authenticated Users are granted 'Connect' and 'Read' access to the Simplify database. NT Authority\Authenticated Users does not work for trusted domains, unless the trusted domain resides in the same forest as the primary domain. This can be resolved by switching to SQL Authentication or granted Domain Users from the trusted domain access to the Simplify database.
The Simplify database transactio log is not controlled by the Simplify Suite, rather by the SQL Server. However, these problems can be resolved by follow these steps:
SQL 2005 and 2008
Open the Microsoft SQL Server Management Studio application.
Right-click the Simplify database and select Properties
Open the Options page
In the middle you will see Recovery Model, change it to Simple and click OK.
Try Shrinking the database from the Microsoft SQL Server Management Studio. Right-click the Simplify database, select Tasks, select Shrink. Execute the Shrink function.
SQL 2000
Open the Enterprise Manager application for SQL 2000.
Right-click the Simplify database and select Properties
Open the Options page.
In the middle you will see Recovery Model, change it to Simple and click OK.
Try Shrinking the database from the Enterprise Manager. Right-click the Simplify database, select Taks, select Shrink. Execute the Shrink function.
* Simplify Suite v5 added support for Windows 2008, Vista, XP, and 2000. Simplify Suite v4 only installs on Windows 2003, 2000, NT.
** Simplify Suite installs on Windows 7, but triCerat does not actively support installations of Simplify Suite on Windows 7 at this time. Simplify Suite will be fully approved for Windows 7 with the official release.
The database is a separate entity of the Simplify Suite, therefore uninstalling Simplify Suite will not affect the Simplify database. For more information click here.
The recommended upgrade steps for Simplify Suite are:
Uninstall Simplify Suite
Restart Server
Install new Simplify Suite
In the event you cannot restart the server follow these steps:
Uninstall Simplify Suite
For 32-bit, in C:\Windows\System32\Spool\Drivers\w32x86\3 delete sd4ui.dll and sd4drv.dll. For 64-bit, in C:\Windows\System32\Spool\Drivers\x64\3 delete sd4ui.dll and sd4drv.dll. If these files cannot be deleted then rename them (for example rename sd4ui.dll to sd4ui.old).
Install Simplify Suite
These steps are instrumental for Simplify Printing. Without following the correct directions, the ScrewDrivers driver may not patch. Printers will not create if the driver does not upgrade. Always test after upgrading Simplify Suite.
The Simplify Suite must be installed at the console of the terminal
server (i.e. session 0), not through a remote session. There
are a number of ways to access the console:
- If it is Windows Server
2003, use the remote console switch. If
you are unfamiliar with this option, please
refer to the following Knowledge Base (KB) article from Microsoft (278845).
- Use a third-party utility
such as VNC or Dameware
The database is a separate install from the Simplify Suite, so uninstalling or upgrading the Suite will not affect the install of the database. This is true even with the MSDE bundle provided by triCerat, which first installs the MSDE and then installs the Simplify Suite. In this scenario, the MSDE and it’s databases remain on the system even if the Simplify Suite is removed.
The Simplify Suite install is in windows installer format, allowing
for silent installations and deployment through Active Directory. Silent
install is initialized using the /q switch with msiexec.exe, and then
passing in values for properties. The command line syntax to set a property
is PROPERTY=VALUE. Valid properties include:
SQLUSERNAME and SQLPASSWORD are only necessary when SQLTRUSTED=no. If
SQLTRUSTED=yes, then the install ignores the SQL username and password.
A silent installation cannot be performed using the install bundled
with the MSDE (SimplifyMSDE.exe). Instead, the (Simplify.msi) will is
required. Additionally, a silent install cannot perform database operations
such as creating a new database. A simplify database must already exist
for the silent install to work.
Yes, during the install an option is presented to choose which features
to install. At this selection dialog, choose to install the management
console, and disable other options by selecting 'Entire feature will
be unavailable' for 'Products'.
Different ScrewDrivers Client packages install different files, so follow the appropriate directions. If you are receiving an error in Add/Remove Programs that prevents the ScrewDrivers Client uninstall then you must use Microsoft's Windows Installer Clean Up Utility to remove MSI instance of ScrewDrivers.
ScrewDrivers RDP Only
Delete Program Files\triCerat\
Delete sdrdp5.dll from Windows\System32\
Delete sd4client.cpl, sdcpl.exe, or sdclient.cpl from Windows\System32. Note that the the client Control Panel applet filename has changed with various revisions of ScrewDrivers v4.
ScrewDrivers Client v4 (with RDP and ICA)
Delete Program Files\triCerat\
Delete sdrdp5.dll from Windows\System32\
Delete sd4client.cpl, sdcpl.exe, or sdclient.cpl from Windows\System32. Note that the the client Control Panel applet filename has changed with various revisions of ScrewDrivers v4.
Delete sdica6.dll from the Citrix ICA Client directory, usually Program Files\Citrix\ICA Client
ScrewDrivers ICA Only
Delete Program Files\triCerat\
Delete sd4client.cpl, sdcpl.exe, or sdclient.cpl from Windows\System32. Note that the the client Control Panel applet filename has changed with various revisions of ScrewDrivers v4.
Delete sdica6.dll from the Citrix ICA Client directory, usually Program Files\Citrix\ICA Client
There are different ways to deploy ScrewDrivers using the Citrix Web Interface, but the simplest way is embedding the ScrewDrivers CAB install into the Citrix Web Interface.
On the Citrix Web Interface server(s), edit the layout.inc file in C:\inetpub\wwwroot\Citrix\XenApp\app_data\include.
Place the ActiveX code below the <html> and <head> portion. Here is sample ActiveX code:
You must modify the web interface to allow ScrewDrivers to work with Remote Desktop via the web interface. Without these modifications ScrewDrivers is unable to create a virtual channel within the Remote Desktop Protocol. Please follow the appropriate directions:
Windows Server 2003
Edit the web portal's html file, typically default.htm in C:\inetpub\wwwroot\tsweb\default.htm. Check Internet Information Service (IIS) if you do not know where the Remote Desktop html file resides.
In the html file find "Device redirection options". It should read as:
These steps are recommended when ScrewDrivers Server cannot be removed with Add or Remove Programs. Do not remove ScrewDrivers while in production. Only remove ScrewDrivers after the users Log Off the server. A restart is generally recommended after completing these steps.
Windows XP, 2000, 2003 x86
Delete the following files and directories, and rename any files that cannot be deleted:
Program Files\triCerat
system32\spool\drivers\w32x86\sd4drv.dll
system32\spool\drivers\w32x86\sd4ui.dll
system32\spool\drivers\w32x86\3\sd4drv.dll
system32\spool\drivers\w32x86\3\sd4ui.dll
system32\sd4notify.dll
system32\sd4ICA6.dll
system32\sd4pRDP5.dll
system32\sd4pTCP.dll
system32\sd4server.cpl and/or sd4servercpl.exe
Remove the following regsitry entries
HKLM\SOFTWARE\triCerat
HKLM\SYSTEM\CurrentControlSet\Control\Printers\Environments\Windows NT x86\Drivers\Version-3\ScrewDrivers4
ScrewDrivers is a print driver utility, and must be removed when clients are not connected to the Server. You do not need to use Install Mode because ScrewDrivers is an MSI, and does not cache data during install or uninstalls. Follow these directions to ensure ScrewDrivers is upgraded properly:
Connect to the Server at the console. If you are remote use mstsc.exe /console.
Verify all remote sessions are closed. Connections can be managed in the Users tab of tsadmin.exe and taskmgr.exe.
Verify there are no ScrewDrivers printers on the server. In Printers and Faxes audit the printer 'Model', and delete any printer using ScrewDriver4. If you cannot delete a specific printer then stop the Print Spool service, delete all files from the Print Spool directory, and start the Print Spool service.. The default directory for the Spooling is Windows\System32\Spool\Printers. If you cannot delete all ScrewDrivers printers then you MUST restart the server after uninstalling ScrewDrivers.
Access Add or Remove Programs, and remove ScrewDrivers Server v4.
Install the new version of ScrewDrivers Server.
Test and verify the new version of ScrewDrivers works.
Simplify Profiles is a hybrid profile management utility for Windows designed to provide the same benefits as roaming profiles
without the management problems. click here.
Install the ScrewDrivers v4 Print Server Agent on each node of the print cluster
On one node go to Start > Programs > Tricerat > ScrewDrivers v4 Print Server Agent and open the ScrewDrivers Console.
Select Tools > Cluster Configuration
Note that this step will restart the clustered Print Spool service. If the nodes are part of a pre-existing Windows print cluster, all the necessary cluster information should be automatically filled in, and the setup is complete.
If a Windows print cluster is not currently setup, a new cluster will be setup...
- In the Cluster Name tab, the physical Cluster Name should already appear; below it, enter a network name for the ScrewDrivers cluster.
- In the Network Settings tab, select a network connection for the cluster, and enter an unused static IP and subnet mask for the print cluster
- In the Cluster Resources tab, select a shared disk to be used for the cluster's spool directory; you can optionally enter a name for the cluster that will appear under when viewed through Microsoft's cluster administration tool.
When connecting to the cluster in the Simplify Console, be sure to use the ScrewDrivers Print Cluster name and not the physical cluster or node name(s).
This error occurs if the Simplify Console cannot handle the printer data from the Print Server. To save time and resources, the printer data is cached on the Print Server. In v5.3.00 a new printer data standard was introduced. After upgrading, the cached printer data on the Print Server are no longer valid, and must be manaully cleared.
On the Print Server, delete HKLM\Software\triCerat\Simplify Printing\Printers, then retry the Import New Printers or Refresh All Printers function in the Simplify Console.
If this does not fix the problem, then very the sdservice.exe on the Print Server and Simplify Console are identical. sdservice.exe is found in C:\Program Files\triCerat\Simplify Printing\ScrewDrivers Print Server v4.
If this problem persists after synchronizing the sdservice.exe versions, then contact support@tricerat.com.
Yes, Simplify Printing works with Windows Print Clusters, but there are additional configuration steps. Follow these directions:
Install the ScrewDrivers v4 Print SErver Agent on each node of the print cluster.
On one node go to Start > All Programs > triCerat > ScrewDrivers v4 Print Server Agent, and open the ScrewDrivers Console
Select Tools > Cluster Configuration
Check the option "Enable ScrewDrivers Print Server Clustering" and give a name to the ScrewDrivers print Cluster. All other fields should be auto filled with the appropriate information.
Create a Print Server object in the Simplify Console and Import the printers. Use the ScrewDrivers Print Cluster name and not the Print Cluster name from Active Directory.
This generic Windows error appears when print driver DLLs are the incorrect version or missing.
It is recommended to perform a clean installation of Simplify Printing when encountering this error. The steps to be taken are:
1. Uninstall Simplify Printing
2. Reboot
3. Re-install Simplify Printing
Specifically, these files must be removed and replaced:
- Windows\System32\Spool\Drivers\w32x86\3\sd4drv.dll*
- Windows\System32\Spool\Drivers\w32x86\3\sd4ui.dll*
- Windows\System32\SQLAPI_Mtu.dll
* For Windows x64 systems, use Windows\System32\Spool\Drivers\x64\3\