错误System.Data.SqlClient.SqlException：在serverr中执行file.exe时登录失败 [英] error System.Data.SqlClient.SqlException: Login failed fou user when file.exe is executed in serverr

问题描述

我在我的控制台应用程序中使用此连接：data source = MYNAME \ SQLEXPRESS; initial catalog = prodcambio;集成安全性= True; MultipleActiveResultSets = True; App = EntityFramework，在我的PC本地工作得非常好，但当我执行文件时，.exe
在服务器中发出此错误 错误System.Data.SqlClient.SqlException：在serverr中执行file.exe时登录失败的用户

I´m using this connection in my console application : data source=MYNAME\SQLEXPRESS;initial catalog=prodcambio; integrated security=True;MultipleActiveResultSets=True;App=EntityFramework, in my PC local is working very well, but when I execute the file .exe in server is giving this error  error System.Data.SqlClient.SqlException: Login failed fou user when file.exe is executed in serverr

请帮帮我

推荐答案

连接将使用服务器上运行它的任何人的帐户。但我注意到你提到了SQLEXPRESS。 SQL Express是否安装在服务器上？那会很奇怪。在服务器上检查进程正在运行的帐户。该用户将
需要访问您指定的SQL实例。对我来说，使用SQLEXPRESS在服务器上没有意义。

The connection will use the account of whoever is running it on the server. But I notice you mentioned SQLEXPRESS. Is SQL Express installed on the server? That would be odd. Check the account the process is running under on the server. That user would need access to the SQL instance you specified. Using SQLEXPRESS, to me, doesn't make sense on the server.

这篇关于错误System.Data.SqlClient.SqlException：在serverr中执行file.exe时登录失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！