Monthly Archives: December 2009

Working with .Net Services

Dear All

In this blog I will be showing the procedure to Install and uninstall services, which are created using Microsoft .Net framework

 

1)      How to uninstall the service(s)

Click on start button and select RUN option

Type services.msc


Right click on the service which u want to uninstall
And copy the path to executable of service file

Now Click on start button and select RUN option
Type CMD
And in command window
Type cd\ c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727 ( here we are working on >net Framework 2.0 )

Now type INSTALLUTIL.exe <> -U

2) How to Install Service(s)

Now Click on start button and select RUN option
Type CMD
And in command window

Type cd\ c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727 ( here we are working on >net Framework 2.0 )
Now type INSTALLUTIL.exe <>

Now open the services.msc and change type to Automatic and start the service.

Its all done

Thanks

Prashant Deshpande

Leave a comment

Filed under Uncategorized

TempDB issues

Dear All

If we recieve a error message in Event log ” The log file for database ‘tempdb’ is full. Back up the transaction log for the database to free up some log space”

First thing we should check for disk space on which tempdb database database files are present .

If the disk space is enough ( not full or less)

Right click on Tempdb Database and in properties tab set the Space allocated to higer value for LOG file and see to it that it is given option to auto grow and recovery model is set to simple.
Actually when we restart SQL server Tempdb database is created from scratch but for that much time tranasactions will be stopped ( SQL server is stoped )

If we want to check for the oldest transaction taking tempdb space then we can use a technique to know the transaction ( SPID ) and we can kill it

DO the following steps in sequence

1) Open SQL query analyzer   ( type following commands )

<strong>Use tempdb</strong>

<strong>DBCC OPENTRAN(’tempdb’)</strong>
            Check the oldest transaction (if it returns any), and see who the SPID is (there will be a line starting with ‘SPID (Server Process ID) : <number>’).
Use that <number> in the following:

<strong>DBCC INPUTBUFFER(SPID number)</strong>

             This will tell you at least a portion of the last SQL command executed by this SPID, and will help you determine
If you want to end this process with:

<strong>KILL SPID number </strong>

Thanks

Prashant Deshpande

Leave a comment

Filed under Database Server, Server Application, SQL Server

Installing SSL certificate on IIS 6.0

Dear All
Please read the documentation for installing SSL Certificate into IIS 6.0

You will receive two certificates from vendor
1) SSL certificate for web server
2) Intermediate CA certificate

Installing SSL certificate for web server

Open Notepad and paste the content of the certificate:

You should then have a text file that looks like:

—–BEGIN CERTIFICATE—–
[encoded data]
—–END CERTIFICATE—–

Make sure you have 5 dashes to either side of the BEGIN CERTIFICATE and END CERTIFICATE and that no white space, extra line breaks or additional characters have been inadvertently added.
save the files with a name and extension as .cer
1. Open the Internet Services Manager (IIS):
a) Click Start
b) Select All Programs
c) Select Administrative Tools
d) Choose Internet Information Services (IIS) Manager

2. Under Web Sites, right-click your web site and select Properties.

3. Click the Directory Security tab.

4. Under Secure Communications, click Server Certificate.

5. The Web Site Certificate Wizard will open, click Next.

6. Choose Process the Pending Request and Install the Certificate, then click Next.

Important: The pending request must match the response file. If you deleted the pending request in error you must generate a new CSR and replace this certificate.

7. Select the location of the certificate response file, and then click Next.

8. Read the summary screen to be sure that you are processing the correct certificate and then click Next.

9. You see a confirmation screen. After you read this information, click Next.

Stop and start your Web server prior to any testing.

Be sure to assign your site an SSL port (443 by default).

If you do not specify an IP address when installing your SSL Certificate, the same ID will be used for all virtual servers created on the system.

If you are hosting multiple sites on a single server, you can specify that the ID only be used for a particular server IP address

Installing Intermediate CA certificate
Default in IIS5.0 and above, Intermediate CA certificate is available but the expiry date is 2004 so we need to delete the existing one and then install new CA certificate.
Procedure
Open Notepad and paste the content of the certificate:

You should then have a text file that looks like:

—–BEGIN CERTIFICATE—–
[encoded data]
—–END CERTIFICATE—–

Make sure you have 5 dashes to either side of the BEGIN CERTIFICATE and END CERTIFICATE and that no white space, extra line breaks or additional characters have been inadvertently added.

a) Click Start
b) Select Run
c) Select MMC
d) select File menu and click on Add/Remove Snap-in..
e) Select Certificates option in it
f) From left panel select Intermediate Certification Authorities  certificates
g) From Right panel delete Class 3 Public Primary Certificate Authority ( Read in Issued by)
h) Now Right click on Certificates ( left panel ) and select All Tasks and then select Import
i) Select the file in which we have copied the Intermediate certificate text from email
j) It will install the intermediate CA certificate for Clients.

NOTE :- You need to open 443 ( SSL port) on the server

With Regards,

Prashant Deshpande

Leave a comment

Filed under IIS, Server Application, Web/Application Server

Working With Linked servers in SQL SERVER 2000

Dear All

Please download and read the document whcih i have implemented on DU-webserver SQL server to serve the requiremnet of harsh and his clients.

Download document

Thnaks

Prashant Deshpande

Leave a comment

Filed under Database Server, Server Application, SQL Server