Integrated Security = true? What is it?

Source: Internet
Author: User
Tags connectionstrings

Learn about Quickstart of dotnet2.0 today. In the gridview controls, you need to configure the database connection in Web. config.

The sample contains the following paragraph:

< Configuration >

< Connectionstrings >

< Add name = " Pubs " Connectionstring = " Server = localhost; user id = dot-well; Password = dot-well.com; Integrated Security = true; database = pubs; "

Providername = " System. Data. sqlclient "   />

</ Connectionstrings >

This involves the security connection. I don't know about it, so the permission issue occurs during page execution.

What is the problem with this ntegrated security? I need to study ..................

If you know, give me some advice.


After getting your guidance last time, I have been vague about it. Now I have finally figured it out, because if I write the password in the connection string, it will cause security problems, therefore, Windows Integrated Identity Authentication is used, that is, indegrated security. Therefore, there is a problem with the above sentence. You should change it to the following.

Server = DW - Yidao; Integrated Security = True; Database = Pubs

 

In addition, we can only say that we have done half of the work. Because we are writing a. NET web app, we need to add the account of Asp.net to the SQL statement. Otherwise, the system will prompt that the login fails.

Well, I know so much now ........................

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.