Certifications, Supported Platforms, Database help, Back-ups, Data Migration, and more
There were 20 articles found in this category:
What are the recommended operating systems and database servers for WinSPC?
The information below represents a list of recommended operating systems and database servers for WinSPC 8.2. Other versions of WinSPC may have different recommended platforms and you will want to refer to your "Installation and Configuration Guide" for the recommended platforms for your specif ...
What are the minimum hardware requirements for WinSPC?
Minimum hardware requirements for a WinSPC Client: 1 GHz or faster 32-bit or 64-bit processor 1 GB RAM (if 32-bit) or 2 GB RAM (if 64-bit) for a typical Windows 7 station* 1 GB RAM for a typical Windows Vista Business station* 256 MB RAM for a typical Windows XP Pro station* 200MB available loc ...
How do I install WinSPC?
To install WinSPC, you should follow the instructions detailed in the "Installation and Configuration Guide" that comes with your WinSPC installation media (CD or download). This guide will take you step by step through the configuration of the WinSPC database as well as the installation of the ...
How do I upgrade WinSPC?
To upgrade your WinSPC system, you should refer to the "Upgrade Instructions" that comes with your WinSPC installation media (download or CD). These instructions will take you step by step through the upgrade process. In general, the WinSPC upgrade process consists of the following steps: Taki ...
Running the WinSPCSecurity program
This article details how to run WinSPCSecurity to grant permissions to users or user groups for the local Windows workstation. The WinSPCSecurity program will set the minimum permission required to run WinSPC. This program should be used if the WinSPC operator does not have local administrati ...
How to move a WinSPC database from one SQL Server to another (manual migration process)
WinSPC has a built-in utility to migrate a WinSPC database from one database server to another. The migration utility will copy the data to the new database, enter a notation into the old database indicating a migration has been done, and update the WinSPC.ini file in the remote directory so th ...
How do I move (or migrate) my WinSPC database to different server?
WinSPC has a built-in utility to migrate a WinSPC database from one database server to another. The migration utility will copy the data to the new database, enter a notation into the old database indicating a migration has been done, and update the WinSPC.ini file in the remote directory so t ...
How do I backup my WinSPC database if I'm running Microsoft SQL Server Express?
This procedure is not meant to supplant or supersede documentation or best practices from Microsoft. If you find a discrepancy between this procedure and documentation or best practices from Microsoft, follow the documentation or best practices from Microsoft. This procedure guides you through ...
How do I restore my backed-up WinSPC database if I'm running Microsoft SQL Server Express?
This procedure is not meant to supplant or supersede documentation or best practices from Microsoft. If you find a discrepancy between this procedure and documentation or best practices from Microsoft, follow the documentation or best practices from Microsoft. This procedure guides you through ...
How do I manage the Microsoft SQL Server transaction log?
If you are using Microsoft's SQL Server as the backend database for WinSPC, you may need to manage the database transaction log in order to keep it to a manageable size. The transaction log is used by the database server to record changes to a particular database in the event that those modific ...
Where can I download Microsoft SQL Server Express 2005 or 2008 for use with WinSPC?
You can download the latest version of Microsoft SQL Server Express from Microsoft's Express website here: http://www.microsoft.com/express/Database/ You can also download the following specific SQL Server Express versions from our website: Microsoft SQL Server Express 2005 Installer Microsoft S ...
How to configure Windows Firewall for SQL Server Express for WinSPC
To configure the Windows Firewall to allow SQL Server Express traffic: Open TCP ports 1433 and 1434. Open UDP ports 1433 and 1434. Add the 'sqlservr.exe' to the exception list (by default, located in: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn)
How to test SMTP communication through telnet
Sometimes, it is necessary to test SMTP (Simple Mail Transport Protocol) to verify that a particular client can access and send email. This can be done by using the telnet application. For more information on the full process of testing the SMTP communication, visit Microsoft's website here: h ...
Tech Note: Installing (or upgrading to) WinSPC 8.0 on a Windows 2000 client machine
If you are installing or upgrading to WinSPC 8.0 on a Windows 2000 client machine, it is recommended that you do the following: Download and install the latest Windows 2000 service pack and fixes from Windows Update. Download and install the latest version of MDAC (Microsoft Data Access Compone ...
How do I activate my WinSPC licenses?
To activate your WinSPC licenses, you will need to do the following: Run WinSPC on any computer and login as the admin user. Select "Tools" > "License Manager" from the drop down menu at the top of the screen. This will cause the "License Manager" dialog box to appear. You will need to kee ...
What is the WinSPC remote directory?
In most WinSPC installations, the WinSPC remote directory (sometimes called the network directory) is a shared folder on your network that is accessible to all your WinSPC clients. The remote directory is created during the initial installation of WinSPC and is used as the basis to install addi ...
How can I estimate the database storage requirements for WinSPC?
To estimate the database storage requirements for your WinSPC database: Multiply your average subgroup size by 37. (E.g. 5x37=185) Multiply your average percentage of subgroups in violation by 66. (E.g. 2%x66=1.32) Multiply your average number of tag values per subgroup by 17.4. (E.g. 4x17.4=6 ...
SQL Server 2005 fails to install with MSXML installation errors
SQL Server 2005 (both enterprise and express editions) may fail to install due to errors encountered during the installation of the MSXML component. For more information regarding the causes and resolutions for this error, please see the following Microsoft Knowledgebase article: http://support ...
Search the WinSPC Knowledgebase
Browse by Category
