I've developed a few ASP.NET applications in the past, develop C# windows apps all the time, but am just now developing my first ASP.NET 2.0 app. I'm having a nightmare getting a database connected.
Everything is on my local machine, including
Visual Studio 2005 Professional
Latest .NET Framework 2.0
I've managed to create my database, tables, sprocs, etc. with VS2005.
My ASP.NET 2.0 app has a "SqlDataSource" control, with proper connection strings, etc. (The "test" button on the wizard runs the stored procedure, getting the correct results). This DataSource is bound to a dropdownlist. Everything is fine until I debug or run the app.
Then I get the standard "Error connecting to database... login failed for user XXXX\ASPNET".
Now, in any other database, I'd simply grant the appropriate rights for the stored procedures to the ASPNET user.
However, I can discover no way to do that with SqlExpress2005. Any ideas?