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
    Enable VSS writer for Exchange 2003 servers
    Viewed 2513 times since Tue, Nov 11, 2014
    Exchange Backup Frequently Asked Questions
    Viewed 2108 times since Mon, Aug 17, 2015
    How to backup a MS SQL database using the Attix5 VSS plug-in
    Viewed 6356 times since Wed, Nov 12, 2014
    How to restore an Exchange database using the Attix5 VSS plug-in
    Viewed 2757 times since Wed, Nov 5, 2014
    How to backup an Exchange server using the Attix5 VSS plugin
    Viewed 4768 times since Tue, Nov 4, 2014
    How to Backup Windows System State
    Viewed 1879 times since Sun, Aug 16, 2015
    How to restore a MS SQL database using the Attix5 VSS plug-in
    Viewed 3617 times since Wed, Nov 12, 2014
    How to backup MySQL on Attix5 Server Edition for Windows
    Viewed 3364 times since Fri, May 30, 2014
    How to restore SQL database files with a .DAT extension in Attix5
    Viewed 4743 times since Fri, May 16, 2014