Self-Service
Self-Service check list
1. Registry
[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\eWare\SelfService]
"SSDbDatabaseDriver"="MSSQL"
"SSDbEntDatabaseDriver"="MSSQL"
"SSDbDatabaseServer"="servername\\crmsqlexpress"
"SSDbUserName"="sa"
"SSDbEntDatabaseServer"="servername\\crmsqlexpress"
"SSDbEntUser"="sa"
"SSDbDatabaseName"="CRMSelfService"
"SSDbEntDatabaseName"="CRM"
"SSDbPassword"="password"
"SSDbEntPassword"="password"
2. Database
3.
--SQL to create the database
USE [master] GO
CREATE DATABASE [CRMSelfService] ON PRIMARY ( NAME = N'CRMSelfService', FILENAME = N'CRMSelfService.mdf' , SIZE = 2304KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'CRMSelfService_log', FILENAME = N'CRMSelfService_log.LDF' , SIZE = 576KB , MAXSIZE = 2048GB , FILEGROWTH = 10%) GO
ALTER DATABASE [CRMSelfService] SET COMPATIBILITY_LEVEL = 100 GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')) begin EXEC [CRMSelfService].[dbo].[sp_fulltext_database] @action = 'enable' end GO
ALTER DATABASE [CRMSelfService] SET ANSI_NULL_DEFAULT OFF GO
ALTER DATABASE [CRMSelfService] SET ANSI_NULLS OFF GO
ALTER DATABASE [CRMSelfService] SET ANSI_PADDING OFF GO
ALTER DATABASE [CRMSelfService] SET ANSI_WARNINGS OFF GO
SET ANSI_NULLS ON GO
SET QUOTED_IDENTIFIER ON GO
CREATE TABLE [dbo].[Visitor]( [Visi_VisitorId] [int] IDENTITY(1,1) NOT NULL, [Visi_VisitorKey] [nvarchar](50) NULL, [Visi_LogonId] [nvarchar](30) NULL, [Visi_Password] [nvarchar](12) NULL, [Visi_PersonId] [int] NULL, [Visi_CompanyId] [int] NULL, [Visi_IpAddress] [nvarchar](15) NULL, [Visi_Salutation] [nvarchar](10) NULL, [Visi_FirstName] [nvarchar](30) NULL, [Visi_LastName] [nvarchar](40) NULL, [Visi_MiddleName] [nvarchar](30) NULL, [Visi_Suffix] [nvarchar](20) NULL, [Visi_Gender] [nvarchar](6) NULL, [Visi_Title] [nvarchar](30) NULL, [Visi_TitleCode] [nvarchar](15) NULL, [Visi_CompanyName] [nvarchar](60) NULL, [Visi_PhoneCountryCode] [nvarchar](5) NULL, [Visi_PhoneAreaCode] [nvarchar](20) NULL, [Visi_PhoneNumber] [nvarchar](20) NULL, [Visi_FaxCountryCode] [nvarchar](5) NULL, [Visi_FaxAreaCode] [nvarchar](20) NULL, [Visi_FaxNumber] [nvarchar](20) NULL, [Visi_EmailAddress] [nvarchar](50) NULL, [Visi_Address1] [nvarchar](40) NULL, [Visi_Address2] [nvarchar](40) NULL, [Visi_Address3] [nvarchar](40) NULL, [Visi_Address4] [nvarchar](40) NULL, [Visi_Address5] [nvarchar](40) NULL, [Visi_City] [nvarchar](30) NULL, [Visi_State] [nvarchar](30) NULL, [Visi_Country] [nvarchar](30) NULL, [Visi_PostCode] [nvarchar](10) NULL, [Visi_Language] [nvarchar](5) NULL, [Visi_CreatedDate] [datetime] NULL, [Visi_UpdatedDate] [datetime] NULL, [visi_userid] [int] NULL ) ON [PRIMARY] GO
CREATE TABLE [dbo].[VisitorProfile]( [Prof_ProfileId] [int] IDENTITY(1,1) NOT NULL, [Prof_VisitorID] [int] NULL, [Prof_ProfileType] [nvarchar](30) NULL, [Prof_Details] [nvarchar](120) NULL, [Prof_CreatedDate] [datetime] NULL, [Prof_UpdatedDate] [datetime] NULL ) ON [PRIMARY]
GO
