Microsoft sql server dsn configuration spn

For a default instance using a domain user account, use:. User-specified SPNs are supported in client drivers. However, if an SPN isn't provided, it will be generated automatically based on the type of a client connection. Service accounts can be used as an SPN. They're specified through the connection attribute for the Kerberos authentication and take the following formats:. The following table describes the authentication defaults that are used based on SPN registration scenarios.

As an alternative a user can specify the account name as an SPN. Skip to main content. This browser is no longer supported.

Download Microsoft Edge More info. Contents Exit focus mode. Is this page helpful? Please rate your experience Yes No. Any additional feedback? Note The information that is provided in this topic also applies to SQL Server configurations that use clustering. Note The new SPN format doesn't require a port number.

SPNs will be used on all connection attempts to the principal and partner when specified in the connection string or connection attributes. Applications should be aware that specifying SPNs in some but not all connection strings can contribute to pool fragmentation.

Applications can programmatically specify SPNs as connection attributes, instead of specifying connection string keywords. This can help manage connection pool fragmentation. Applications should be aware that SPNs in connection strings can be overridden by setting the corresponding connection attributes, but connection strings used by connection pooling will use the connection string values for pooling purposes. The new connection behavior is implemented by the client; therefore, it is not specific to a version of SQL Server.

The benefits of doing this are the same as specifying SPNs in client connection strings: It is simpler and more reliable to establish connections that use Kerberos authentication.

When choosing whether to specify SPNs in an application through connection strings or programmatically through connection properties rather than relying on the defalt provider generated SPNs , consider the following factors:. This applies to both the principal server and its failover partner if you use database mirroring. If a server change means that SPNs must be changed, how will this affect applications? Will any changes be managed? You can specify an SPN in dialog boxes and in code.

This section discusses how you can specify an SPN. Skip to main content. This browser is no longer supported. Download Microsoft Edge More info.

Access is denied. When i used : setspn. Warning: The Service Principal Name you specified could not be found on any accounts in this domain. This target configuration will not be able to deliver passwords if the Service Principal Name is not configured properly.

Office Office Exchange Server. Not an IT pro? SQL Server. Sign in. United States English. Home R2 Library Forums. Ask a question. Quick access. Search related threads. Remove From My Forums. Answered by:. Archived Forums I-L.