Re: Trouble granting access to user in MSDE-2000
From: Narayana Vyas Kondreddi (answer_me_at_hotmail.com)
Date: 01/17/04
- Next message: Dandy Weyn: "Re: SQL server registration failed"
- Previous message: jecko: "enterprise manager"
- In reply to: Anu: "Trouble granting access to user in MSDE-2000"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Sat, 17 Jan 2004 22:31:11 -0000
Have you tried adding ASPNET login as a user in master database? Try that,
and then run this command in Query Analyzer (in master database).
GRANT EXEC ON sp_sdidebug TO ASPNET
GO
Now try your application, it should work.
-- HTH, Vyas, MVP (SQL Server) http://vyaskn.tripod.com/ Is .NET important for a database professional? http://vyaskn.tripod.com/poll.htm "Anu" <anonymous@discussions.microsoft.com> wrote in message news:016b01c3dcea$eb88b990$a001280a@phx.gbl... Hi, I am trying to read data off a MSDE (downloaded from MS website 2 weeks back)database and display it on a web- form, using .NET. As any ASP.NET application requires access permission for user "ASPNET" on the database, after 3 days of constant searching I hit upon the sp_addlogin, sp_adduser stored procedures and was able to add "ASPNET" as a valid user. Now, the application is able to open the connection to the database,but dies when it tries to read data and the error I get is: "System.Data.SqlClient.SqlException: EXECUTE permission denied on object 'sp_sdidebug', database 'master', owner 'dbo'." After more searching, I tried opening ControlPanel -> Administrative... -> Services -> SQL Server -> Properties -> LogOn , modified the user login to ASPNET, and tried to restart the service, but the service would not restart due to a failure to login. By the way, the OS I have is Windows-XP Pro. I am learning to use .NET and I have already spent 4 days on this issue due to lack of support. I would very much appreciate help so that I can go forward with learning the .NET environment further. Thanks a bunch, -Anu
- Next message: Dandy Weyn: "Re: SQL server registration failed"
- Previous message: jecko: "enterprise manager"
- In reply to: Anu: "Trouble granting access to user in MSDE-2000"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
