How to Access SQL Server from browser (it can be done through "Configure XML Support for SQL Server")

How to Access SQL Server from browser (it can be done through "Configure XML Support for SQL Server")

T Access SQL Server from browser (it can be done through "Configure XML Support for SQL Server")

Step 1

To start XML Support for MSSQL Server, first you need to go to Program Files after that, click on the MS SQL Server. Next, you need to choose Configure XML Support for SQL Server.

Step 2

After that, you need to enter the Northwind as the virtual directory name. It can be any other name and provide the path where the virtual directory will be placed.

Step 3

Please note that the name Northwind must be the same as the one that you will be using to pass the query to. Next, you need to click on Security Tab.

Step 4

We will use SQL server SA to login to SQL Server. After that, you need to click on Data Source tab.

Step 5

Under the Database section, you need to choose Northwind as the database. Next, you ought to click on Setting tab and check Allow URL queries. Then, Allow template queries, Allow Xpath, Allow Post.

Step 6

Under define virtual name, you have to click the New option.

Step 7

Then setup the 2 objects here, which is the schema and dboject. First select Schema and then provide the path to it. We will use a schema folder under Nwind folder.

Step 8

Now, you need to click Save and we will setup DBOBJECT.

Step 9

You need to click Save and Apply when you have done. The newly created virtual directory will look something like this.

Step 10

To test it, open your IE browser and then pass the following string over to it.

http://compact/northwind?sql=SELECT+*+FROM+Employees+FOR+XML+AUTO&root=root

Edited By: Norasyikin Mahmud

© 2001 ISC/Inner Esteem

All rights reserved. All other product names and trademarks are registered properties of their respective owners.

301001

How to use compression in IIS 5.0

How to use compression in IIS 5.0

To use compression in IIS 5.0

Step 1

To use compression for IIS 5.0, first you need to go to Start and click Programs and after that select Administrative Tools and IIS. Later, you need to click on Edit.

Step 2

Now, you ought to choose Service tab and click on compress static file.

Step 3

Now, you have to click on Apply and then OK.

How to set CGI time out period

How to set CGI time out period

To set CGI time out period

Step 1

To increase or reduce a CGI timeout script all you need to do is to go to Start and choose Programs. After that, you need to click on the Administrative Tools and IIS. Under the IIS manager, right click on your computer and choose Properties.

Step 2

Another screen will appear as shown in the diagram below.

Step 3

Now, you need to click on the Configuration.

Step 4

Later, under the CGI configuration, change CGI timeout settings.

How to set Expiration Policy for newsgroup

How to set Expiration Policy for newsgroup

To set Expiration Policy for newsgroup

Step 1

User can set an expiration data for newsgroup. To do this, first you need to go to Start and click Programs. After that, click Administrative Tools and choose IIS. Later, you need to go to Default NNTP server and right click on it. Next, go to New and choose Expiration Policy.

Step 2

Next, another window similar to the one shown below will appear.

Step 3

Then choose Only selected newsgroup on this virtual server and click Next to continue.

Step 4

Next, you need to enter POLEC that we have created earlier.

Step 5

Next, enter the value 720 and click Finish when you have done.

What does a metabase do?

Metabase to IIS 5.0 is what registry is to MS Windows. It is located at %SystemRoot%\system32\inetsrv.

How to enable SSL on your virtual directory

How to enable SSL on your virtual directory

To enable SSL on your virtual directory

Step 1

Once we have setup the certificate, we can enable SSL on a virtual directory by

Invoking IIS and then choose a directory for our purpose here. The site that we have chosen is called "Snail".

Step 2

Then, under Directory Security click on Edit and click on Require secure channel (SSL) and OK.

Step 3

To test it out, open your browser and then type

http://yourcomputername/snail

You will get an error message, which is similar to the one shown below.

If you type https://computername/snail/index.asp then you will be able to view it.

How to Enable SSL in your server

How to Enable SSL in your server

To Enable SSL in your server

Step 1

Once the certificate is installed on your computer, the next step is to enable the certificate in IIS.

Step 2

You ought to click on Process the pending request and install the certificate.

Step 3

You have to accept the default parameter by clicking Next and click Finish when you have done.

How to install the request to your server

How to install the request to your server

To install the request to your server

Step 1

You need to go back to your browser and then type in the following to access issue your.

http://computername/certsrv

This time choose Retrieve the CA certificate or certificate revocation list and click Next to continue.

Step 2

Now, you need to click on Download CA Certificate and then windows save dialog box will appear. You need to choose Open this file from its current location.

Step 3

Another window will now appear.

Step 4

Next, you need to click on Install Certificate to install it.

Step 5

Certificate import wizard will now appear and you need to click Next to continue.

Step 6

After that, click Next to continue.

Step 7

Now, click on Finish when you have done and then click Ok again to exit the dialog box.

How to issue certificate

How to issue certificate

To issue certificate

Step 1

Once you have setup your certificate, the next step is to approve it. You need to go to Start option and choose Program. Next, choose Administrative Tools and click Certificate Authority. After that, you need to go to Pending Request to expand it.

Step 2

To issue request, right click on request located on your right hand side and click Issue to issue it.

Step 3

Next, you need to close the certificate authority. Now, we are done with request issuing.

How to issue certificate request to server

How to issue certificate request to server

To issue certificate request to server

Step 1

To issue a certificate request, open your Browser and then type in the following to access issues your certificate to your server.

http://computername/certsrv

Step 2

Next, you need to select Request a certificate and click Next to continue.

Step 3

After that, you must click on Advance request and click Next to continue.

Step 4

Later, you ought to choose Submit a certificate request using a base64 encoded PKCS #10 file or a renewal request using a base64 encoded PKCS #7 file and click Next to proceed.

Step 5

Then user will need to provide the code to server. If you are not able to browse, use notepad to open your certificate. For our purpose we will use the certificate that we have created earlier, certreq.txt. After that, you need to click Submit to continue.

Step 6

That抯 all to request approval from server.

How to create certificates

How to create certificates

To create certificates

Step 1

Once your have setup your certificate services, the next step is to setup your certificate in IIS.

Step 2

What you need to do now is to click on Properties. Under Documents Security, you need to choose Server Certificate. Web server certificate wizard will appear as shown below.

Step 3

Now, click Next to continue.

Step 4

Now, you need to click on Assign new certificate and click Next to continue.

Step 5

Now, you need to click on Prepare the request now, but send it later. After that, you have to click Next to continue.

Step 6

Then, click Next to continue.

Step 7

After that, click Next to continue.

Step 8

Now, click Next to continue.

Step 9

After that, you need to click the Next to continue.

Step 10

Now, you must click Next to continue and click on Finish to exit certificate wizard.

How to Implement SSL on your IIS

How to Implement SSL on your IIS

T Implement SSL on your IIS

Step 1

It is to enable the Certificate Services in your computer. To enable SSL you need to install this component into your computer.

Step 2

If IIS 5.0 in not available in your system and user would wanted to install IIS 5.0, then all you need to do is to go to Start first and choose Setting. After that, you need to click on Control Panel and choose Add/Remove Program. Next, you need to click on Add/Remove Window Component and then check on Certificate Services and click Next to continue.

Step 3

Now, the certificate component will be installed. Then under Certification Authority Types, you need to choose Stand-Alone root CA. After that, click Next to continue.

Step 4

Then we will provide identification information into the system.

Step 5

Now, you need to key in your information and click Next to continue. Then data storage location for your certificates will appear. Accept the default and click Next to continue.

Step 6

If IIS is running, your IIS services will be stopped. So please make sure nobody is accessing it during this time.

Step 7

Now Certificate wizard will configure all the necessary changes to make it works.

Step 8

Next, click on Finish when you have done. Your certification authority should look something like this.