|
To be able to use SQL Server 2008 as a database backend for ChannelCRM you will have to configure it for this purpose. This is so because by default a SQL Server will be very closed (closed = secure). In other words: You will have to enable the features of SQL Server that you plan to use.
| 1. | SQL Server 2008 has to be running.
On the PC/server on which SQL is to be executes you will start Start | Program Files | Microsoft SQL Server | Configuration Tools | SQL Server Configuration Manager. In the navigator you select SQL Server 2008 Services. In the right part of the dialog you can observe whether the SQL Service is running and possibly also SQL Server Browser. Normally you will select to let at least SQL Server to run automatically. |
| 2. | Check enabling of remote connections (SQL Server 2005)
After installing SQL Server 2005 it will not have remote connections enabled. Choose Start | Program Files | Microsoft SQL Server | Configuration Tools | SQL Server 2005 Surface Area Configuration. Choose Surface Area Configuration for Services and Connections. In this dialog choose Database Engine | Remote Connections. In the right part of the dialog select Local and remote connections og either Using TCP/IP only or Using both… |
| 3. | If you plan to user SQL Server Security this should be enabled
The recommended Security Model is Windows Authentication. If you for any reason want to use SQL Server Security (UserId and password) this has to be changed on the server. Open SQL Server Management Studio and select properties for the SQL Server. Selecting the page Security choose SQL Server and Windows authentication mode. |
| 4. | If you plan to use Windows Authentication ...
Windows Authentication is about letting the Domain Security services govern SQL Server as well. In other words: A user that is already trusted by his/her logon will be allowed access to SQL Server with no further credentials.
Many different settings are possible in this area and this is out of scope for this guide.
If you are having problems gaining access to the SQL Server by Windows Authentication it will be helpful to open the SQL Server Log. In this you will be able so see what logins are rejected and why. |
Page url:
http://www.channelcrm.net/us/index.html?net_checklist_for_sql_server.htm
| 
