SQL Hosting Web Service

  • Article

The following methods of the SQL Hosting Namespace are exposed as Web methods in the Web Service:

Public Methods

Public Method Description

SQL Hosting::DropLogin Method

The DropLogin method removes a SQL login from the server.

SQL Hosting::RevokeLogin Method

The RevokeLogin method revokes access to a Microsoft Windows NT or Windows 2000 account from a server.

SQL Hosting::AddUserToRole Method

The AddUserToRole method adds a user account to a database role.

SQL Hosting::RemoveUserFromRole Method

The RemoveUserFromRole method removes a user from a database role.

SQL Hosting::BackupToDisk Method

The BackupToDisk method backs up a database to a disk file.

SQL Hosting::ListBackupInformation Method

The ListBackupInformation method lists the header information from a backup file.

SQL Hosting::RestoreFromDisk Method

The RestoreFromDisk method restores a database from a disk file.

SQL Hosting::GrantDBAcccess Method

The GrantDBAccess method grants an account access to a database.

SQL Hosting::RevokeDBAccess Method

The RevokeDBAccess method revokes an account's access to a database.

SQL Hosting::SetPassword Method

The SetPassword method sets the password for a SQL account.

SQL Hosting::ChangePassword Method

The ChangePassword method changes the password for a SQL user.

Note

In the method definitions that follow, the sqlUserName and sqlUserPass parameters must be specified only if you enabled SQL authentication on the SQL server. If you are using Windows authentication and you specify these optional parameters, the request will fail.

Applies To

  • Hosted Messaging and Collaboration version 4.0

  • Hosted Messaging and Collaboration version 3.5

  • Hosted Messaging and Collaboration version 3.0

  • Windows-based Hosting version 4.5

  • Windows-based Hosting version 4.0

  • Windows-based Hosting version 3.5

  • Windows-based Hosting for Applications version 1.0