Log in to SQL database in ASP.NET

xiaoxiao2021-03-06  101

Author: Unknown Author speed Please contact me often found users log on using SQL SERVER WINDOWS mode, the results failed Tip: You 'KEKC / ASPNET' Login failed. Description: Execute an unprocessed exception during the current web request. Check the stack tracking information to learn more about the error and the code caused in the code. Abnormal details: system.data.sqlclient.sqlexception: User 'KEKC / ASPNET' Failed. Source error:. . . For this issue, specialty catwrites for your reference. First, assume that your SQL Server 2000 has been configured to log in, if there is no reference: mixed mode configuration method, VS. Configuration method in NET (very simple to mention, will skip), first put it into the connection you want, select "Microsoft Ole DB Provider for SQL Server", enter "connection in" Provider "page "See the picture below, after configuring, click" Test Connection "button, prompt the test connection success: At this time, the connection attribute can be detected, and you can see the figure below," ConnectString "is the string we have to get, manually fill in the effect Same, there are often user dynamically configure this string. (Write vs.net This part mainly teaches you how to get this string. If you write, you don't have to take it here) this time, generally prompts the first description, see how to configure the SQL database. Second, it is actually very simple, because she prompts: User 'KEKC / ASPNET' login failed. Then we have to build an ASPNET user, Kekc is a domain name. "Safety" - "" Login "-" New Login: This is not, you want to assign permissions to this user, what permissions are needed to see your needs, at least give only read permissions:

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

New Post(0)