StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>You current connection string is this:</p> <pre><code><connectionStrings> <remove name="LocalSqlServer" /> <add name="LocalSqlServer" connectionString="Initial Catalog=MYS;Data Source=WIN2K8;Integrated Security=SSPI;" providerName="System.Data.SqlClient" /> </connectionStrings> </code></pre> <p>The error here is that you're saying: <em>Connect to my sql server database and use the App Pool identity as the 'account' to authenticate my sql server db against.</em></p> <p>All Websits on IIS run under an 'account'. In this case, it looks like this account is called <code>MyApp</code>.</p> <p>So the fix you need to have a connection string that says: Don't use whatever 'identity' is setup on this IIS machine, etc. BUT! Use this hardcoded username/password instead.</p> <p>Check this out, now:</p> <pre><code><connectionStrings> <remove name="LocalSqlServer" /> <add name="LocalSqlServer" connectionString="Initial Catalog=MYS;Data Source=WIN2K8;uid=username;password=pass;" providerName="System.Data.SqlClient" /> </connectionStrings> </code></pre> <p>Take note:</p> <ol> <li>I've removed the argument: <code>Integrated Security=SSPI;</code></li> <li>I've added the argument: <code>uid=username;</code></li> <li>I've added the argument: <code>password=pass;</code></li> </ol> <p>Just replace the values <code>username</code> and <code>pass</code> with the username/password you use to log into your sql server database.</p> <p>Need help learning about what options/keywords u can define in a single connection string? <a href="http://www.connectionstrings.com/" rel="nofollow">Check this ConnectionStrings site as a reference</a>.</p> <p>Pro Tip: Instead of <code><remove name="whatever/></code> .. try using <code><clear/></code></p> <p>eg.</p> <pre><code><connectionStrings> <clear/> <add name="LocalSqlServer" connectionString="Initial Catalog=MYS;Data Source=WIN2K8;uid=username;password=pass;" providerName="System.Data.SqlClient" /> </connectionStrings> </code></pre> <p>GL!</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

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