Setting Basic Security

Using the registration tool, select the virtual root, select the Security tab, and enter a valid SQL Server login ID. For ease of testing, use sa as the login with no password. This setting is dependent on the SQL Server configuration and you should not consider doing this on a production SQL Server; use this setting only a test bed server because this procedure makes the server a security risk.

Select a data source, enter the name of a valid SQL Server, and choose the database you created earlier. Incidentally, this is the only time you will see the database name when using XML; the virtual directory name is the one you should take note of.

Under the security settings, you can specify the actions allowed at the virtual ...

Get Writing Stored Procedures for Microsoft SQL Server now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.