User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the ASP.NET section within the Web Development category of DaniWeb, a massive community of 402,430 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,944 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our ASP.NET advertiser: Lunarpages ASP Web Hosting
Views: 1737 | Replies: 3
Reply
Join Date: Dec 2004
Posts: 1,590
Reputation: tgreer is an unknown quantity at this point 
Rep Power: 7
Solved Threads: 34
Colleague
tgreer tgreer is offline Offline
Made Her Cry

VS2005, SQLEXPRESS2005, ASP.NET config

  #1  
Feb 13th, 2006
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

IIS
Visual Studio 2005 Professional
Latest .NET Framework 2.0
sqlexpress 2005

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?
AddThis Social Bookmark Button
Reply With Quote  
Join Date: Jul 2005
Location: Dallas, TX
Posts: 481
Reputation: campkev is an unknown quantity at this point 
Rep Power: 4
Solved Threads: 19
campkev campkev is offline Offline
Posting Pro in Training

Re: VS2005, SQLEXPRESS2005, ASP.NET config

  #2  
Feb 14th, 2006
I seem to remember having a similar problem recently developing some personal stuff at home. i am at work now but will check when I get home and see if I can find what I did.
I'm assuming you already tried
grant exec on stored_procedure_name to aspnet
Reply With Quote  
Join Date: Dec 2004
Posts: 1,590
Reputation: tgreer is an unknown quantity at this point 
Rep Power: 7
Solved Threads: 34
Colleague
tgreer tgreer is offline Offline
Made Her Cry

Re: VS2005, SQLEXPRESS2005, ASP.NET config

  #3  
Feb 14th, 2006
Yes, I have a permissioning script I can use, or I can add the "grant" clause to each CREATE... that will solve the specific issue (and has). So let me rephrase the question:

Where, using VS2005 and SqlExpress2005, is the "widget", wizard, menu, button, etc. for assigning permissions? It seems to me that the VS2005 DB Interface is missing some crucial elements.

BTW, you do a great job answering questions here. Keep up the good work, it's appreciated.
Reply With Quote  
Join Date: Jul 2005
Location: Dallas, TX
Posts: 481
Reputation: campkev is an unknown quantity at this point 
Rep Power: 4
Solved Threads: 19
campkev campkev is offline Offline
Posting Pro in Training

Re: VS2005, SQLEXPRESS2005, ASP.NET config

  #4  
Feb 14th, 2006
ahh. In that case, i have no idea. I generally hate the VS interface with databases. I always do database maintenance, creation, etc directly through SQL.
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

DaniWeb ASP.NET Marketplace
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

Thread Tools Display Modes

Similar Threads
Other Threads in the ASP.NET Forum

All times are GMT -4. The time now is 2:27 pm.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC