Activation center (ACEN)
How to: Set connection string for SQL server access.
There are a number of ways to set SQL Server access for ACEN. The strategy you choose depends on how your computers are configured and whether you are on an intranet.
1. Windows integrated security.
Because of delegation issues, this frequently only works by default if SQL Server is on the same computer as IIS.
2. Access the SQL Server as the local identity of ASP.NET application.
Example: local ASPNET account on a Windows 2000 server or the local NETWORK SERVICE account on a Windows Server 2003. This option works well for anonymous access.
3. Explicit user name and password are passed in connection string.
This option can be less secure than other options so you should always use protected configuration to secure the connection strings.
Please refer to Activation center documentation for more connection strings examples.
1. Windows integrated security.
Because of delegation issues, this frequently only works by default if SQL Server is on the same computer as IIS.
2. Access the SQL Server as the local identity of ASP.NET application.
Example: local ASPNET account on a Windows 2000 server or the local NETWORK SERVICE account on a Windows Server 2003. This option works well for anonymous access.
3. Explicit user name and password are passed in connection string.
This option can be less secure than other options so you should always use protected configuration to secure the connection strings.
Please refer to Activation center documentation for more connection strings examples.