How To - Using SmarterTicket with a SQL Server in Windows Authentication mode

SmarterTools Portal

Language

Home

Knowledge Base

SmarterTicket

How To - Using SmarterTicket with a SQL Server in Windows Authentication mode

Information

Article ID	184
Created On	2/16/2005
Modified	9/11/2008

Actions

Print this Page

Add to Favorites

Share With Others

	Digg
	Reddit

How To - Using SmarterTicket with a SQL Server in Windows Authentication mode

Applies to: SmarterTicket 2.x

When connecting to a SQL server database, you may see an error like the one below:

System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. at
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) at
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open() at
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(StringconnectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at
SmarterTools.SmarterTicket.Data.DatabaseManager.CreateOrUpgradeDatabase(Boolean includeSampleData) at
SmarterTools.SmarterTicket.Data.DatabaseManager.CreateOrUpgradeDatabase() at
SmarterTools.SmarterTicket.SystemAdmin.frmMrsSettings.NextInitButton_Click(Object sender, EventArgs e)

This error indicates that the SQL server is in strict windows authentication mode. To connect to a database, use "domain\username" for the database user field when setting up the connection.