| | |
VS2005, SQLEXPRESS2005, ASP.NET config
Please support our ASP.NET advertiser: Intel Parallel Studio Home
![]() |
•
•
Join Date: Dec 2004
Posts: 1,655
Reputation:
Solved Threads: 35
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?
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?
•
•
Join Date: Jul 2005
Posts: 483
Reputation:
Solved Threads: 19
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
I'm assuming you already tried
ASP.NET Syntax (Toggle Plain Text)
grant exec on stored_procedure_name to aspnet
•
•
Join Date: Dec 2004
Posts: 1,655
Reputation:
Solved Threads: 35
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.
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.
![]() |
Similar Threads
- Forms Authorization/ Authentication using asp .net and vb .net (ASP.NET)
- Impersonation in ASP.NET (ASP.NET)
- Simple ASP.Net Login Page (Using VB.Net) (ASP.NET)
- Populating & Retrieving Data in a listbox : ASP.NET (w/ VB.NET) (ASP.NET)
Other Threads in the ASP.NET Forum
- Previous Thread: asp.net deployment problem
- Next Thread: Data Item
| Thread Tools | Search this Thread |
.net 3.5 ajax alltypeofvideos appliances asp asp.net bc30451 beginner box browser businesslogiclayer button c# cac checkbox class commonfunctions control countryselector dataaccesslayer database datagrid datagridview datagridviewcheckbox datalist deployment development dgv dialog dropdownlist dropdownmenu dynamic dynamically edit embeddingactivexcontrol expose fileuploader fill findcontrol flash formatdecimal formview gridview gudi iis javascript list listbox login microsoft mouse mssql nameisnotdeclared news novell numerical opera panelmasterpagebuttoncontrols problem radio redirect registration relationaldatabases reportemail save schoolproject search security sessionvariables silverlight smartcard smoobjects software sql sql-server sqlserver2005 ssl suse textbox tracking treeview unauthorized validatedate validation vb.net video videos vista visualstudio vs2008 web webapplications webdevelopemnt webdevelopment webprogramming webservice wizard xsl youareanotmemberofthedebuggerusers






