I like to test the connection to SQL Server. My Web Site is running under AD account Domain\userA.
my connection string is connectionString="Data Source=server\instance;Initial Catalog=Database;Integrated Security=SSPI" providerName="System.Data.SqlClient"
I am not able to log in using UserA account as interactive login is disabled. Does anyone know any way to test. I have tired UDL file and ODBC but they are taking current credentials logged in to Server.
I couldn't find a way to test the connection using domain\usera account under web site is running.