Liferay + SQL Server / Steps for Installation of SQL Server 2005

Steps for Installation of SQL Server 2005

1)     Install SQL Server 2005 with below options
    >    Use sql authentication instead of windows authentication
    >    Give User Name & Password as "sa" and "sa"
2)    Configuration
    >    Open C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft SQL Server 2005\Configuration Tools\SQL Server Configuration Manager
    >    Navigate "SQL Server 2005 Network Configuration" > "Protocols for SQLEXPRESS"
    >     double click "TCP/IP"
    >    Go to "IP Address" tab
    >    Under "IP All" section give TCP Port "1433"
    >    "Apply" and "Ok"
    >    Navigate to "SQL Server 2005 Services"
    >    Restart Service of "SQL Server (SQLEXPRESS)" (available on right tab)
3)    Verify SQL Server's service is up and listening on port 1433   
    >    Go to command prompt
    >    type "telnet localhost 1433" and hit enter
4)    Create Database with "Microsoft SQL Server Management Studio Express"
    >    Right click on "Databases" -> "New Database"
    >    Give database name "test"
    >    Click on "Ok"
5)    Create a User and give permission to newly created DB
    >    Go to "Object Explorer"
    >    Click on "Security"
    >    Go to "Logins"
    >    Right click on it and select "New Login"
    >    Give "Login Name"
    >    select "SQL Server authentication"
    >    give "Password" & "Confirm password"
    >    Uncheck "Enforce password policy"
    >    From the "Default database" select DB (on which permission you want to grant)
    >    Click on the "Server Roles" (under "Select a page" on left column inside "Login-new" wizard)
    >    Check "sysadmin"
    >    Move to "User Mapping"
    >    Select the databases whose mapping you want to do with new user (in our case its "test")
    >    Click on "Status" section on left column
    >     Let the default settings as it is i.e.
        1)    Permission to connect to database engine : "Grant"
        2)    Login : "Enabled"
    > Click on "Ok"

So far we have done SQL Server setup, DB created and User is mapped to database with required permissions.

Cheers!
Henal Saraiya
(Senior Consultant)
CIGNEX Datamatics