Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Generally you would put a password if you are connecting to say a sql server database with a sql login unless you decide to use windows authentication.</p> <pre><code> &lt;connectionStrings&gt;&lt;add name="MyDbConn1" connectionString="Server=MyServer;Database=MyDb;Trusted_Connection=Yes;"/&gt; &lt;add name="MyDbConn2" connectionString="Initial Catalog=MyDb;Data Source=MyServer;Integrated Security=SSPI;"/&gt; &lt;/connectionStrings&gt; </code></pre> <p>You should lock down the permissions/roles for what a sql server login can do.</p> <p>If you have to use a sql server style login you could encrypt the password like this..</p> <p><a href="https://stackoverflow.com/questions/1706613/encrypting-connection-string-in-web-config">Encrypting Connection String in web.config</a></p> <p>or some other links..</p> <p><a href="http://www.kodyaz.com/articles/Encrypting-in-web-configuration-file.aspx" rel="nofollow noreferrer">http://www.kodyaz.com/articles/Encrypting-in-web-configuration-file.aspx</a></p> <p><a href="http://www.codeproject.com/KB/cs/Configuration_File.aspx" rel="nofollow noreferrer">http://www.codeproject.com/KB/cs/Configuration_File.aspx</a></p> <p><a href="http://www.velocityreviews.com/forums/t84120-how-to-encrypt-database-password-in-web-config-file.html" rel="nofollow noreferrer">http://www.velocityreviews.com/forums/t84120-how-to-encrypt-database-password-in-web-config-file.html</a></p> <p>EDIT: </p> <p>To use a connection string from a connectionstring element in the web.config file then this shows you..</p> <p><a href="http://www.martinwilley.com/net/code/nhibernate/appconfig.html" rel="nofollow noreferrer">http://www.martinwilley.com/net/code/nhibernate/appconfig.html</a></p> <p>ALTERNATIVELY</p> <p>use fluentnhibernate. :)</p>
    singulars
    1. This table or related slice is empty.
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
 

Querying!

 
Guidance

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload