In order to connect the Site Store Pro online store files to your MS SQL server database, the SiteStoreProDB.asp file must be edited to include your specific SQL SERVER database login information.

The SiteStoreProDB.asp file is located in the ‘Connections’ folder in your installation directory.

Below is a screen shot from Dreamweaver that shows the location of the folder as well as the opened SiteStoreProDB.asp file.

Using Dreamweaver (Code View), a text file editor or your preferred HTML editor, you must replace the default SQL connection string values with the login information for your specific SQL server database.

The values in RED need to be replaced with your specific SQL login parameters:

server=SERVERNAME;uid=USERNAME;pwd=PASSWORD;database=DATABASE_NAME

• SERVERNAME = The servername or IP Address of your MS SQL Server
• USERNAME = The username provided by your webhost or entered when setting up the database
• PASSWORD = The password provided by your webhost or entered when setting up the database
• DATABASE_NAME= The name of the database provided by your webhost or entered when setting up the database.

If you need assistance setting the correct MS SQL connection string for your Site Store Pro installation, please email support@sitestorepro.com or call (800) 974-6493 Ext 2.