using Integrated Security connection in IIS

change Identity with LocalSystem

 

than you can connection string as the following in web.config

:<add name="conn" connectionString="Data Source=.;Initial Catalog=dbname;Integrated Security=True" providerName="System.Data.SqlClient" />