对SSPI的调用失败，请参阅内部异常。 [英] A call to SSPI failed, see inner exception.

问题描述

我在将记录插入数据库时​​从服务器收到此错误。



我尝试了什么：



我不知道这个错误来自哪里

I am getting this error from server when inserting record to database.

What I have tried:

I dont know from where this error come

推荐答案

问题是你的连接字符串& /或服务器配置。

您的连接字符串不包含SQL用户名&密码，但在字符串中使用Integrated Security或Trusted_Connection，其值设置为SSPI。

错误是建议SQL Server无法验证发出请求的用户。

这可能是由几个原因导致的;

a） SQL在本地帐户下运行，无法查询域控制器以确定用户是否使请求具有所需的权限

b）发出请求的帐户（我建议这是一个网站，因为 ScriptManager 参考）没有访问数据库的权限，可能是因为网站在您的网络服务器上的本地帐户下运行



查看您如何连接到SQL&创建一个合适的连接字符串 - 以下链接将有所帮助。

SqlConnection.ConnectionString属性（System.Data.SqlClient） [ ^ ]

ConnectionStrings.com - 忘记连接字符串？在这里获取！ [ ^ ]



亲切的问候

The problem is your connection string & /or server configuration.
Your connection string does not include a SQL Username & Password but instead are using Integrated Security or Trusted_Connection in your string with the value set to SSPI.
The error is advising that the SQL Server is unable to authenticate the User that is making the request.
This can be caused by several reasons for example;
a) SQL is running under a local account that cannot query the domain controller to determine if the user making the request has the required permissions
b) The account that is making the request (I would suggest this is a website due to the ScriptManager reference) does not have permission to access the DB, probably because the website is running under a local account on your web server

Review how you are connecting to SQL & create an appropriate connection string - the below links will assist.
SqlConnection.ConnectionString Property (System.Data.SqlClient)[^]
ConnectionStrings.com - Forgot that connection string? Get it here![^]

Kind Regards

这篇关于对SSPI的调用失败，请参阅内部异常。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！