Install Microsoft SQL Server Express 2012

Download and Install SQL Server Express 2012

Download Contact Management Software     Reached the Final for a CRM Award in the Software Satisfaction Awards 2011 Reached the Final for a CRM Award in the Software Satisfaction Awards 2012

Microsoft SQL Server Express 2012

Microsoft SQL Server Express 2012 is a Free Database Management System (DBMS) that provides superior performance and scalability compared to using a Microsoft Access Database.

Microsoft SQL Server Express 2012 is designed to support multiple users in true client server fashion and can support many more users than a Microsoft Access database.

Download Microsoft SQL Server Express 2012

Microsoft SQL Server Express 2012 can be downloaded from here. Download SQL Server Express.

It's best to download and install the Database Server and also SQL Server Management Studio Express.

To install SQL Server Express and SQL Server Management Studio Express on a 64-bit PC, choose ENU\x64\SQLEXPRWT_x64_ENU.exe.

To install SQL Server Express and SQL Server Management Studio Express on a 32-bit PC, choose ENU\x86\SQLEXPRWT_x86_ENU.exe.

If you are not sure whether your PC is a 32-bit PC or a 64-bit PC, click the Windows Start menu and right-click on Computer. Select Properties. That may show if your PC is a 32-bit or a 64-bit PC like this.

64 Bit PC

If in doubt, contact your System Administrator or your IT Department.

Click the appropriate Download button and download the file. Save the file somewhere where you can easily find it such as your desktop.

Install Microsoft SQL Server Express 2012

Run the SQLEXPRWT_x64_ENU.exe or SQLEXPRWT_x86_ENU.exe file that you downloaded to install SQL Server Express 2012.

You need to install Microsoft SQL Server Express and Microsoft SQL Server Management Express on a server that your clients can connect to.

You may need to install these as an Administrator or else you will get an error. We run the Command Prompt as Administrator and then run the .exe file from there.

Configure Microsoft SQL Server Express 2012

For information on configuring SQL Server Authentication so your users can access the database, see SQL Server Authentication

For more information on SQL Logins and SQL Users, see SQL Logins and SQL Users.

You will need to configure SQL Server to allow remote connections. For more information see - SQL Server Remote Connections

Enable TCP-IP Protocol on the Server

You will need to go into the SQL Server Configuration Manager and enable the TCP-IP protocol on the server.

SQL Server Remote Connections Enable TCP-IP

SQL Server Backups

You'll need to set up regular backups of the database - see SQL Server Backups

IT Support Needed

Please note that setting up and maintaining Microsoft SQL Server is an advanced topic and we would suggest consulting an IT Professional to help you with this. The IT Professional needs to have a full understanding of Microsoft SQL Server including SQL Logins, SQL Users, networking and security, and SQL Server backups.

Amphis Software Support are happy to provide help with setting up Amphis Customer to use SQL Server but setting up Microsoft software such as Microsoft Windows, Microsoft Exchange, Microsoft Outlook or Microsoft SQL Server is beyond the Free support that Amphis Software Support can provide. We support software we have developed but we don't support software developed by Microsoft.

Date Formats

If you live in a country that uses British date formats eg United Kingdom or Australia, you will need to change the Default Language for the Logins to British English.

SQL Server British English Dates

Microsoft SQL Server Express 2012 Limitations

Also note that there are limitations with SQL Server Express 2012, namely, there is a size restriction on the database which is limited to 10GB. You will need to monitor the size of your customer database to check that it does not reach this limit. If it does, you would need to purchase a license from Microsoft for the full version of SQL Server.

There are other limitations eg SQL Server Express will only use 1GB of memory and will only use one CPU.

More Information

We have some short CRM Videos about Amphis Customer CRM Software and also a CRM Quick Guide with more details and screenshots. We have Prices, Customer testimonials and CRM Software Case Studies or why not Download our CRM Software Free 60 Day Trial and try it for yourself ?

Bookmark and Share