<div>
You'll want to add the ASPNET user, the &quot;NT Authority\Network Service&quot;, or the IIS WP user to your DB as a user, and then give it access to your database. &nbsp;It depends on what OS, and what version of IIS you are using.
</div>


You'll want to add the ASPNET user, the "NT Authority\Network Service", or the IIS WP user to your DB as a user, and then give it access to your database.  It depends on what OS, and what version of IIS you are using.

<div>
There are two types of security &nbsp;modes on sql server. <br />
1. Windows authentication mode &nbsp;<br />
2. Mixed mode(sqlserver and windows authentication mode). <br />
<br />
You must &nbsp;set to mixed mode on the sql server to be able to login from asp.net application providing username/password combination on web.config. <br />
<br />
<br />
<br />

</div>


There are two types of security  modes on sql server.
1. Windows authentication mode  
2. Mixed mode(sqlserver and windows authentication mode).

You must  set to mixed mode on the sql server to be able to login from asp.net application providing username/password combination on web.config.





<div>
<div class="content wysiwyg-content">
Hi all. &nbsp;I've just created ASPNETDB on my SQL Server 2005 and currently it has the following users: dbo, guest, INFORMATION_SCHEMA and guest. &nbsp;I'm assuming in my web.config file that I have to provide a username and password to this database. &nbsp;However, it seems that I can't add the current username and password that I am using to connect to the database to the ASPNETDB in the usual way. &nbsp;Can someone help me with this as I'm a newbie at this and can't find this information anywhere.<br />
<br />
Thanks so much.
</div>
</div>


Hi all.  I've just created ASPNETDB on my SQL Server 2005 and currently it has the following users: dbo, guest, INFORMATION_SCHEMA and guest.  I'm assuming in my web.config file that I have to provide a username and password to this database.  However, it seems that I can't add the current username and password that I am using to connect to the database to the ASPNETDB in the usual way.  Can someone help me with this as I'm a newbie at this and can't find this information anywhere.

Thanks so much.

Permissions needed to connect to ASPNETDB on SQL Server 2005

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

Microsoft SQL Server 2005 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. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.