This section relates to Avalara VAT Reporting (Desktop version). If you use Avalara VAT Reporting (Cloud version), please see the Avalara VAT Reporting (Cloud version) help section.
This installation guide demonstrates an installation using Windows 7 Professional SP1 with Microsoft SQL Server 2012 Express with Tools SP3. Note that a production installation may involve additional steps – for example installing an Application Server or installing a Citrix server.
- Open SQL Server Management Studio.
- Verify your information and click Connect.
- When the Management Studio opens, right-click Databases.
- Click New Database.
- Name your new database and click OK. This name is used when you move to the Avalara VAT Reporting Module Setup Wizard.
- When you purchased Avalara VAT Reporting, you received an email with the link to our latest software download. Go to that page and click the latest Download version.
- When the file downloads, click it to start the installation.
- Follow the VAT Reporting Module Setup Wizard.
- On the Select Additional Tasks window, select the following options:
- Include ReportingCheck: If you require the Reporting Check tool.
- Create a desktop icon: If you want a desktop shortcut for VAT Reporting Module
- Create a Quick Launch icon: If you want a launch icon on the taskbar
- Continue following the installation steps in the VAT Reporting Module Setup Wizard.
- When the setup wizard ends, go to the Windows Start menu and under Program Files, click VAT Reporting Module to open it.
- When you first open Avalara VAT Reporting, an error message opens. Ignore this message and click OK, since the database is set up in the next step.
- In the Database Connections screen, click New DB to connect to a new database.
- Give the new database a name, check SQL Server, add the name of the server you created in step 5, check windows authentication and click Test Connection.
- The connection confirmation assures you that Avalara VAT Reporting is successfully working with the server you previously created. Click OK after the confirmation then click Save.
- Back in the Database Connections section, select your database, click Use this DB and click OK in the confirmation window that pops up next.
- You have successfully installed Avalara VAT Reporting and connected it to a database. You are now ready to open the application from the Start Menu on your computer.
- Congratulations! You're now ready to start using Avalara VAT Reporting
SQL Server update
We have added support for more connectivity providers to SQL Server, in order to support the latest technology and security features.
You can now use the following providers (if available on the host):
- • SQLOLEDB (current , installed by default in windows)
- • MSOLEDBSQL (latest, can be downloaded from: https://www.microsoft.com/en-us/download/details.aspx?id=56730 )
- • SQLNCL (comes with SQL Server 2005)
- • SQLNCLI10 (comes with SQL Server 2008)
- • SQLNCLI11 (comes with SQL Server 2012, [Microsoft® SQL Server® 2012 Native Client])
By adding these providers it is possible to use TLS 1.1 or TLS 1.2 for customers who need to disable TLS 1.0.
In order to enable the new provider, you will need to update the connection string within the Avalara VAT Reporting application, in the Database setup screen.
It is also necessary to update to the latest version of the Avalara VAT Reporting Inbox Monitor service available here:
https://release.vat.avalara.net/VATInboxMonitoringServiceSetup1981.exe and update the connection string used by the Inbox Monitor configuration. It is also necessary to update the connection string in your SII .bat file.