KBA-01046: All users receive messages that login failed for user SpitfireKBA-01046: All users receive messages that login failed for user Spitfire

Problem: The dashboard loads and users enter their credentials.  No matter what user name and password are supplied, the following message is displayed: Server Error in ‘sfPMS‘ Application. Login failed

KBA-01026: Why are the alerts not generated for overdue documents?KBA-01026: Why are the alerts not generated for overdue documents?

Question: No alerts are appearing in Spitfire for overdue documents.  Why not? Answer: Things to consider: Is there an Alert Subscription set up for overdue documents? Alert Subscriptions are set

KBA-01024: How do I synchronize my Customers, Vendors, and Employees?KBA-01024: How do I synchronize my Customers, Vendors, and Employees?

Question: How can I synchronize my Microsoft Dynamics SL customers, vendors, and employees in Spitfire? Answer: Synchronization is performed by special stored procedures that can run in SQL Server Agent jobs. To ensure that your Customers,

KBA-01010: How do I move my SQL Server database files?KBA-01010: How do I move my SQL Server database files?

Question: When I set up the SQL Server database for Spitfire, I had the opportunity to specify the location for the primary MDF, the secondary file group NDF, and the

KBA-01003: Why are the Spitfire reports not showing up on the Spitfire Report Browser menu?KBA-01003: Why are the Spitfire reports not showing up on the Spitfire Report Browser menu?

Question Why aren‘t Spitfire reports showing up on the Spitfire Report Browser menu window? Answer Spitfire Reports are hosted by SQL Reporting Services.  When properly configured, reports are displayed in the

KBA-01475: SQL Report ParametersKBA-01475: SQL Report Parameters

Summary: In order to provide a consistent user experience, Spitfire recognizes certain report parameter names and uses standard user interface methodology to prompt the user. These parameter names include: pProject –

KBA-01480: SQL Server Reporting Services Remote ErrorsKBA-01480: SQL Server Reporting Services Remote Errors

Question: A report is failing.  How do I see the actual error without having to run the report on the server? Answer: In SQL 2008 or later this is fairly

KBA-01349: Custom Reports in SQL Server Reporting ServicesKBA-01349: Custom Reports in SQL Server Reporting Services

Purpose & Scope: Spitfire reports are SQL Server Reporting Services (SSRS) reports.  Spitfire uses a few conventions when organizing reports in SSRS and has recommended conventions for deploying custom reports

KBA-01376: Creating specific log reports using the generic document logKBA-01376: Creating specific log reports using the generic document log

Purpose & Scope: Spitfire provides a generic document log with many filters.  Using the report deployment features built into Microsoft SQL Server Reporting Services, you can redeploy our generic document