<div>
data source should be DBServerName\InstanceName<br />
InitialCatalog should be databasename<br />

<pre><code id="code-20-37857924-1">&lt;add name=&quot;testconnectionstring&quot; connectionString=&quot;Data Source=Database\Instance; Initial Catalog=testdb;Persist Security Info=True;User ID=test;Password=test; Connect Timeout=360&quot; providerName=&quot;System.Data.SqlClient&quot; /&gt;</code></pre>
</div>


data source should be DBServerName\InstanceName
InitialCatalog should be databasename


<add name="testconnectionstring" connectionString="Data Source=Database\Instance; Initial Catalog=testdb;Persist Security Info=True;User ID=test;Password=test; Connect Timeout=360" providerName="System.Data.SqlClient" />

<div>
yes i got that but it doesn't see the login info because i'm using the login info as application role info. what login info should i use
</div>


yes i got that but it doesn't see the login info because i'm using the login info as application role info. what login info should i use

<div>
you have to create a user with username test and password test.<br />
Role has nothing to do in connection string, its purely as SQL Identity....
</div>


you have to create a user with username test and password test.
Role has nothing to do in connection string, its purely as SQL Identity....

<div>
so then how do i assign this user to that application role
</div>


so then how do i assign this user to that application role

<div>
<div class="content wysiwyg-content">
ok so i logged into sql as admin and did the following<br />
CREATE APPLICATION ROLE test<br />
&nbsp; &nbsp; WITH PASSWORD = 'test' <br />
&nbsp; &nbsp; , DEFAULT_SCHEMA = test;<br />
GO<br />
<br />
<br />
exec sp_setapprole test, 'test'<br />
<br />
<br />
now in my web.config, what should my connection string look like for my asp.net web application?<br />
&lt;add name=&quot;testconnectionstring<wbr />&quot; connectionString=&quot;Data Source=testdb;Initial Catalog=testcatalog;Persis<wbr />t Security Info=True;User ID=test;Password=test; Connect Timeout=360&quot; providerName=&quot;System.Data.<wbr />SqlClient&quot;<wbr /> /&gt;
</div>
</div>


ok so i logged into sql as admin and did the following
CREATE APPLICATION ROLE test
    WITH PASSWORD = 'test' 
    , DEFAULT_SCHEMA = test;
GO


exec sp_setapprole test, 'test'


now in my web.config, what should my connection string look like for my asp.net web application?
<add name="testconnectionstring" connectionString="Data Source=testdb;Initial Catalog=testcatalog;Persist Security Info=True;User ID=test;Password=test; Connect Timeout=360" providerName="System.Data.SqlClient" />

application role sql 2008

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.