Configure SQL 2005 & 2008 Express for Attix5 SQL Plugin

The Attix5 Pro plugin connects to SQL using port 1433 and uses SQL authentication (usually the sa account). By default on most Windows operating systems port 1433 and SQL authentication is not enabled and needs to be configured.

Enable port 1433 (on local server):

  1. Run SQL Server Configuration Manager and click on SQL Server Network Configuration, then Protocols for SQLEXPRESS
  2. Select the IP Addresses tab
  3. Scroll down to the section IPALL and specify the TCP Port 1433
  4. Apply the changes and restart the SQL service

Configure the SQL username:

  1. Run SQL Server Management Studio Express and login using your Windows credentials
  2. Set the sa account server role to have sysadmin access
  3. Set/reset the sa password as required

You will now be able to continue configuring the Attix5 SQL plugin using the SQL Plugin knowledgebase article.

0 (0)
Article Rating (No Votes)
Rate this article
    Attached Files
    There are no attachments for this article.
    There are no comments for this article. Be the first to post a comment.
    Security Code Security Code
    Related Articles RSS Feed
    How to Backup Windows System State
    Viewed 3123 times since Sun, Aug 16, 2015
    How to Backup Capita SIMS Using the Attix5 Plugin
    Viewed 5065 times since Tue, Apr 12, 2016
    How to backup a MS SQL database using the Attix5 VSS plug-in
    Viewed 7202 times since Wed, Nov 12, 2014
    How to backup an Exchange server using the Attix5 VSS plugin
    Viewed 5553 times since Tue, Nov 4, 2014
    How to backup MySQL on Attix5 Server Edition for Windows
    Viewed 5744 times since Fri, May 30, 2014
    How to restore SQL database files with a .DAT extension in Attix5
    Viewed 7875 times since Fri, May 16, 2014
    Enable VSS writer for Exchange 2003 servers
    Viewed 4459 times since Tue, Nov 11, 2014
    How to Setup Email Notifications
    Viewed 3295 times since Sat, Aug 15, 2015
    Exchange Backup Frequently Asked Questions
    Viewed 2863 times since Mon, Aug 17, 2015