Setup a database that holds the customers

This example uses an SQL Server 2008 R2 that holds one table with customers. You can adjust the solution to connect to a table or view that suits your needs.

1. Create a database named CustomMembershipProvider.

2. Execute the following script:

   TSQL

    USE [CustomMembershipProvider]
    GO
    /****** Object:  Table [dbo].[Customers]    Script Date: 15-8-2013 17:59:10 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    SET ANSI_PADDING ON
    GO
    CREATE TABLE [dbo].[Customers](
        [CustomerId] [uniqueidentifier] NOT NULL,
        [Firstname] [varchar](50) NULL,
        [Lastname] [varchar](50) NULL,
        [Email] [varchar](50) NOT NULL,
        [Username] [varchar](50) NOT NULL,
        [Password] [varchar](256) NOT NULL,
        [Salt] [varchar](50) NOT NULL,
        [IsApproved] [bit] NOT NULL,
     CONSTRAINT [PK_Customers] PRIMARY KEY CLUSTERED 
    (
        [CustomerId] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
     
    GO
    SET ANSI_PADDING OFF
    GO

   NOTE: Do not add data to the table. You will provide this through the Sitefinity CMS backend.