SqlException x80131904 (0) : unable to open the login "XXXXXXX" the requested database, login failure,
Users' WORKGROUP \ _17_0_3 $172 'login failed,]

Has been added in the iis web site on the server, but have a connection to the database, an error here,
This WORKGROUP don't understand it, because I saw others error are sa has some users or other database security, don't know what's the relationship between the team and

CodePudding user response:

Please check the way you used to login validation, is according to the sa login, or according to the Windows account login,
According to the above situation, may be is to use Windows account to log in,

CodePudding user response:

Thank you, but I set the database side used Windows login mode
Then I vs sqlconnection written inside is Data Source=the host; The Database=AnimalAdoption; UId=sa; Password=* * * *; Integrated Security=True
I don't know why here has now become a Windows login
That could you tell me how to modify the

CodePudding user response:

Vs?????? To vs
Please check the web. The configuration in the config

CodePudding user response:

reference wanghui0380 reply: 3/f

v?????? To vs
Please check the web. Config in the configuration of the

Well well thank you, it would need to look at those nodes

CodePudding user response:

If you use a SQL login account, rather than the Windows account to log in, it should not be to Integrated Security=True this paragraph,

https://blog.csdn.net/yenange/article/details/50853083
https://blog.csdn.net/yenange/article/details/77026214

Read the above two articles that set the connection string is something for you.

CodePudding user response:

refer to the second floor weixin_41329696 response:

thank you, but I set the database side used Windows login mode
Then I vs sqlconnection written inside is Data Source=the host; The Database=AnimalAdoption; UId=sa; Password=* * * *; Integrated Security=True
I don't know why here has now become a Windows login
That could you tell me how to modify the

Should be in IIS anonymous logins

CodePudding user response:

Number; The Database=AnimalAdoption; UId=sa; Password=* * * *; Integrated Security=True

This cannot coexist, to need not integrated Windows, either by user

The Database=AnimalAdoption; UId=sa; Password=* * * *;
The Database=AnimalAdoption; Integrated Security=True;

As separate it,

CodePudding user response:

reference 5 floor gypsy song reply:

if you use a SQL login account, rather than the Windows account to log in, it should not be to Integrated Security=True this paragraph,

https://blog.csdn.net/yenange/article/details/50853083
https://blog.csdn.net/yenange/article/details/77026214

Read the above two articles that set the connection string is something for you,

Thank you very much, useful!