ASP.NET 2.0 accessing SQL Server Express

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jim B - 05 Feb 2008 21:45 GMT

Hello,

This is a FAQ, messy one but what I actually should do that ASP.NET 2.0 Web
Application is
using SQL Server Express database?

I have struggle with Node\ASPNET user account but connection from Web App to
database
doesn not succeed.

Have anyone simple instructions what should be done when a ASP.NET
application (deployed into IIS) is using SQL Server Express database in same
PC?

Cheers,

Reply to this Message

Peter Bromberg [C# MVP] - 06 Feb 2008 01:06 GMT

Attach the database the same way you would do with SQL Server, and don't use
the UserInstance connection strings; use a regular connection string such as:
server=(local);database=mydatabase;uid=sa;pwd=password;
-- Peter
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
MetaFinder: http://www.blogmetafinder.com

> Hello,
>
[quoted text clipped - 11 lines]
>
> Cheers,

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...