Installing SQL SERVER 2005 and SQL REPORTING SERVICES

Installing SQL SERVER 2005 and Installing SQL REPORTING SERVICES:

1.       First we need to create service account for Sql Server and Reporting Services. Lets create a service account named SqlReportServer.

A.      Start  –> Settings –> Control Panel –> Administrative Tools

B.      Click Computer Management

C.      Expand the Local Users And Groups

D.      Right-click the Users folder and select New User.

E.       Enter a User name – SqlReportServer

F.       Enter description – Account for SQL Server and Reporting Services.

G.     Enter Password.

H.      Enter Confirm password.

I.        Uncheck “User must change password at next logon” check box.

J.        Select “User cannot change password” check box.

K.      Select “Password never expires” check box.

L.       Click “Create” button.

2.       Now we will install SQL SERVER 2005 and SQL REPORTING SERVICES. For this first insert SQL SERVER CD wait for auto run to open.

3.       Under install click “Server components, tools, Books Online, and samples”.

4.       You will then asked to accept “End User License Agreement”, Click check box “I accept the licensing terms and conditions.” and then click “Next”.

5.       It will then ask you to install prerequisites and then click “Install”.

6.       It will install prerequisites and then click next.

7.       Screen will show that system is inspecting configuration. Click  “Next”

8.       It will show SQL SERVER INSTALIZARD click “Next”.

9.       Another in-depth configuration screen will appear and if there is any error you need to repair otherwise click “Next”.

10.   Next on the Registration Information page, type a Name and, optionally, a Company name, and then click next.

11.   Now on this screen we will need to select components we want to install.

12.   Click the check box next to SQL Server Database Services†, Analysis Services†, Reporting Services† and then click the check box next to Workstation Components, Books Online And Development Tools. († in future tutorials we will learn SQL DBA Tips and Reporting Services and Analysis services so we install it together)

13.   Click Advanced

14.   Click next to Documentation, Samples, And Sample Databases, click the arrow next to Sample Databases, and select Entire Feature Will Be Installed on Local Hard Drive. Click the arrow next to Sample Code and Applications, and select Entire Feature Will Be Installed on Local Hard Drive. Now click “Next”.

15.   On the Instance Name screen select “Default Instance” and click “Next”.

16.   On the Service Account screen, click “Use a domain user account” and enter account information we have created in step 1(account name SqlReportServer ) when finished click “Next”.

17.   On the Authentication Mode screen select “Mixed Mode” enter a password for sa account and then click “Next”.

18.   On next screen select “Latin1_General” collation designator and sort order.

19.   On the Report Server Installation Options screen select “Install but do not configure the server” click “Next”.

20.   On the Error and Usage Report Settings page, you can choose to send reports to Microsoft. Click “Next”,

21.    Now it will show you the list of components will be installed then click “Install”.

22.   Now Setup progress screen appears during install.  Once setup finished for all components click “Next”.

23.   You can review Summary log for any setup issue on completing sql server setup screen.  Click “Finish” to complete installation.

      24.   Reboot your system if required.
            Once you finish installation install “SQL Server 2005 Service Pack 2”.
                http://technet.microsoft.com/en-us/sqlserver/bb426877.aspx
             For more reading please check:
             http://support.microsoft.com/kb/934164(How to install SQL Server 2005 Reporting Services on a Windows Vista)

-          Harpreet Virk

(Pilibangan)

Turning Off Client-Side Validation

Each of the validation server controls has a property called EnableClientScript. This property is set to True by default, but setting it to False prevents the control from sending out a JavaScript function for validation on the client.

1.       Disabling client-side validations in a validation control

<form id=”form1″ runat=”server”>
<div>
<asp:TextBox ID=”txtName” runat=”server”></asp:TextBox>
<asp:RequiredFieldValidator ID=”RequiredFieldValidator1″ Runat=”server” ErrorMessage=”Required!!!” ControlToValidate=”txtName” EnableClientScript=”false”></asp:RequiredFieldValidator>
</div>   
</form>

2.       Reamove client-side capability programmatically

protected void Page_Load(object sender, EventArgs e)
{
 RequiredFieldValidator1.EnableClientScript = false;
}

3.    Disable client-side script capabilities for all the validation controls on a page from within the Page_Load event.
 

protected void Page_Load(Object sender, EventArgs e)
{
foreach (BaseValidator bv in Page.Validators)
{
 bv.EnableClientScript = false;
}
}

-          Harpreet Virk 
        Pilibangan