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.
    Comments
    There are no comments for this article. Be the first to post a comment.
    Name
    Email
    Security Code Security Code
    Related Articles RSS Feed
    How to Backup Windows System State
    Viewed 2423 times since Sun, Aug 16, 2015
    How to Backup Capita SIMS Using the Attix5 Plugin
    Viewed 3502 times since Tue, Apr 12, 2016
    How to backup MySQL on Attix5 Server Edition for Windows
    Viewed 5354 times since Fri, May 30, 2014
    Enable VSS writer for Exchange 2003 servers
    Viewed 4351 times since Tue, Nov 11, 2014
    How to Restore Windows System State
    Viewed 2901 times since Sun, Aug 16, 2015
    Exchange Backup Frequently Asked Questions
    Viewed 2542 times since Mon, Aug 17, 2015
    How to configure the MS SQL Attix5 Pro Plugin
    Viewed 6039 times since Fri, May 16, 2014
    How to restore SQL database files with a .DAT extension in Attix5
    Viewed 7487 times since Fri, May 16, 2014
    How to restore an Exchange database using the Attix5 VSS plug-in
    Viewed 4750 times since Wed, Nov 5, 2014
    How to backup an Exchange server using the Attix5 VSS plugin
    Viewed 5367 times since Tue, Nov 4, 2014