When creating or opening an authorization store, type a URL beginning with the protocol prefix MSSQL://.

The syntax for the URL is:

mssql://<connection string>/<database name>/<policy store name>

where:

• <connection string> is any valid SQL Server connection string,
  
  
• <database name> is the name of the database where the store will be saved, and
  
  
• <policy store name> is the name of the particular store.
  
  

Examples

mssql://dsn=MyTestDataSource;/AzManDB/MyTestStore

mssql://Driver={SQL Server};Server={server1-test};/AzManDB/MyTestStore

	Note
	Connections to a SQL store are not encrypted unless you explicitly set up SQL encryption for the connection or set up encryption of the network traffic that uses Internet Protocol security (IPsec). For information about configuring SQL encryption or configuring IPsec, see SQL Server product documentation (http://go.microsoft.com/fwlink/?LinkId=131607).

Additional considerations

• If the instance of SQL Server doesn't have the named Authorization Manager database, Authorization Manager will create a new database of this name. Otherwise, the new store will be created within the same named database.
  
  
• The database administrator responsible for the computer running SQL Server must configure security on the computer to allow the Authorization Manager database to be created and maintained.
  
  
• If you are not familiar with connection string syntax, see the documentation provided with Microsoft SQL Server 2008 or Microsoft SQL Server 2005, or visit the Microsoft Web site and see Connection String Syntax (http://go.microsoft.com/fwlink/?LinkId=69663).
  
  

Additional references

• Understanding Authorization Manager Stores
  
  
• What's New in Authorization Manager