İyi gunler, ASP.net MVC Core 6'da bir proje geliştiriyorum, projeyi ISS uzerinde denemek istedim ancak aşağıda detaylarını paylaşacağım hatayı aldım, Sıfırdan proje oluşturdum ancak yine aynı hata'yı aldım, Sorun ya Connection String'te yada SQL server yapılandırmasında. Hatayı cozmede yardımcı olabilir, Şoyle birşey denedim, SQL Server 'da IP adresi ve Windows Authentication ile giriş yaptığımda aynı hatayı alıyorum, ancak "sa" kullanıcı ile girdiğimde bağlanıyorum. Şimdiden teşekkurler.


Surprizbozan: MVC Core Detaylı Hata Mesajı C#:Panoya kopyala
Microsoft.Data.SqlClient.SqlException HResult=0x80131904 Message=Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication. Source=Core Microsoft SqlClient Data Provider StackTrace: at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionA ndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehav ior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at Microsoft.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at Microsoft.Data.SqlClient.SqlInternalConnectionTds. CompleteLogin(Boolean enlistOK) at Microsoft.Data.SqlClient.SqlInternalConnectionTds. AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover) at Microsoft.Data.SqlClient.SqlInternalConnectionTds. LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout) at Microsoft.Data.SqlClient.SqlInternalConnectionTds. OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance) at Microsoft.Data.SqlClient.SqlInternalConnectionTds. .ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, Boolean applyTransientFaultHandling, String accessToken, DbConnectionPool pool) at Microsoft.Data.SqlClient.SqlConnectionFactory.Crea teConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) at Microsoft.Data.ProviderBase.DbConnectionFactory.Cr eatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions) at Microsoft.Data.ProviderBase.DbConnectionPool.Creat eObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at Microsoft.Data.ProviderBase.DbConnectionPool.UserC reateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at Microsoft.Data.ProviderBase.DbConnectionPool.TryGe tConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at Microsoft.Data.ProviderBase.DbConnectionPool.TryGe tConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at Microsoft.Data.ProviderBase.DbConnectionFactory.Tr yGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at Microsoft.Data.ProviderBase.DbConnectionInternal.T ryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at Microsoft.Data.SqlClient.SqlConnection.TryOpen(Tas kCompletionSource`1 retry, SqlConnectionOverrides overrides) at Microsoft.Data.SqlClient.SqlConnection.Open(SqlCon nectionOverrides overrides) at WebApplication1.Controllers.HomeController.Index() in D:ProjelerWebApplication1WebApplication1Controller sHomeController.cs:line 22 at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMeth odExecutor.SyncActionResultExecutor.Execute(IActio nResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.Controller ActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.Controller ActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.Controller ActionInvoker.InvokeNextActionFilterAsync()






Hata Aldığım Connection String:
ASP.net:Panoya kopyala
SqlConnection SqlBaglanti = new SqlConnection("Server=192.168.1.40;Database=CoreDa shboard;Trusted_Connection=True;TrustServerCertifi cate=True;MultipleActiveResultSets=True");


Calışan Connection String:
ASP.net:Panoya kopyala
SqlConnection SqlBaglanti = new SqlConnection("Server=SINANUGURLU\SQLEXPRESS;Datab ase=CoreDashboard;Trusted_Connection=True;TrustSer verCertificate=True;MultipleActiveResultSets=True" );