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