Log as follows, this log is reported to the user cannot login here
The SQL Server Network Interface library could not register The Service Principal Name (SPN) [MSSQLSvc/iZ23xvjchsrZ: 1433] for The SQL Server Service. Windows return code: 0 XFFFFFFFF, state: 63. Failure to register a SPN took cause integrated authentication to use NTLM home Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by The authentication policies and if The SPN from then manually registered.
SQL Server is attempting to register a Service Principal Name (SPN) for the SQL Server Service. The Kerberos authentication will not be possible until a SPN is registered for the SQL Server Service. This is an informational message. No user action is required.
Server local connection provider is ready to accept the connection on [\ \. \ pipe \ \ SQL query].
CodePudding user response:
Why are you Kerberos authentication?
CodePudding user response:
The
refer to the original poster lizh0103 response: log as follows, in this log here so the user cannot login CodePudding user response:
The sa account, I look online to say whether mandatory password policy issue now is checked, but I had to restart the server CodePudding user response:
reference lizh0103 reply: 3/f sa account, I look online to say whether mandatory password policy problem now is checked, but I had to restart the server CodePudding user response:
Yes the front-end is sa login,, CodePudding user response:
reference 5 floor lizh0103 reply: yes front are sa login,, CodePudding user response:
Provider based on the Open, failure - & gt; System. The Data. SqlClient. SqlException: in establishing connection with SQL Server and network or specific instances of the error, or unable to access the Server was not found, please verify the instance name is correct and that SQL Server is configured to allow remote connections, (the provider: Named Pipes provider, error: 40 - unable to open the connection to SQL Server) - & gt; System.Com ponentModel. Win32Exception: can't find the network path, CodePudding user response:
refer to 7th floor lizh0103 response: based provider failure on the Open, - & gt; System. The Data. SqlClient. SqlException: in establishing connection with SQL Server and network or specific instances of the error, or unable to access the Server was not found, please verify the instance name is correct and that SQL Server is configured to allow remote connections, (the provider: Named Pipes provider, error: 40 - unable to open the connection to SQL Server) - & gt; System.Com ponentModel. Win32Exception: can't find the network path, CodePudding user response:
CodePudding user response: Login failed for user 'sa'. Reason: unable to open the specified database "* * * * *," [client: * * * * * * *] CodePudding user response:
refer to 7th floor lizh0103 response: based provider failure on the Open, - & gt; System. The Data. SqlClient. SqlException: in establishing connection with SQL Server and network or specific instances of the error, or unable to access the Server was not found, please verify the instance name is correct and that SQL Server is configured to allow remote connections, (the provider: Named Pipes provider, error: 40 - unable to open the connection to SQL Server) - & gt; System.Com ponentModel. Win32Exception: can't find the network path, references to the tenth floor lizh0103 response: Login failed for user 'sa'. Reason: unable to open the specified database "* * * * *", [client: * * * * * * *] CodePudding user response:
references 9 f lizh0103 response: & lt; Add name="DBSTR" providerName="System. The Data. SqlClient" connectionString="Data source=111; Initial catalog=222; Persist security info=True; User id=sa; Password=23333; Pooling=False; MultipleActiveResultSets=true "/& gt; 