MS SQL Server login problem

xiaoxiao2021-03-06  102

1: Server = (local); Database = Friends; trusted_connection = true;

User 'NT Authority / Network Service' failed.

2: Server = (local); database = friends; trusted_connection = false; user '(null)' login failed. Cause: Not associated with trusted SQL Server connections.

3: Server = (local); database = friends; UID = sa; user 'sa' failed. Other databases can be fully logged in through the SA account login and integrated security verification. Why do this database happen? Bao Yu's statement: This error will be made when connecting SQL Server using trust. In Windows XP, the run account of ASP.NET is ASPNET, and in Windows Server 2003, run the account to NetWork Service, directly put this The user is getting better in the login account of SQL Server, so many examples don't have to change the connection string!

The system account in 2003 did have ASPNET, and Network Service is a built-in security principal account, so it already exists, it can't be established, the group NThority is not. Establish such a role in SQL, or not pass, depressed ... What is the 'NT authority / network service'? What is the purpose? Please also give a point.

转载请注明原文地址:https://www.9cbs.com/read-124875.html

New Post(0)