.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SQL SERVER 2008 Create Maintenance Plans encounter General Access Denied error

Posted By:      Posted Date: September 28, 2010    Points: 0   Category :Sql Server

After I clicked New Maintenance Plans and filled in <Maintenance Plans Name>, an error appeared like below: General access denied error, my account is already sysadmin and public, and agent service has started.


TITLE: Microsoft SQL Server Management Studio


General access denied error


General access denied error



View Complete Post

More Related Resource Links

[SSRS 2008 R2]Report Builder Access error-The remote server returned an error: (401) Unauthorized.

Hello,        I am able to login Web Service URL and report manager using computer name and report builder is also working fine.  http://RPTSRV/reportserver   (RPTSRV is report server name. web service url working fine. all accessible) http://RPTSRV/reports  (report manager working fine and all accessible ,report builder too) It means I am able to access everything locally right? http://rs.test.abc.com/reportserver  (web service url working fine. all accessible)  http://rs.test.abc.com/reports    (Report manager working fine and all accessible accept report builder)(I carefully checked the link and its taking rs.test.abc.com/reportserver.....)     when I click on reportbuilder button in report manager it shows me error dialog box with following error log!! I tried from local and remote computer too but gives the same error both side. I am not sure but I am just thinking is this double hop kerberos security issue? Please help me to solve this problem. I am finding solution from last 4 days. Reporting Service configuratin tool settings Web Serivice URL -  all set to default Report Manager URL - all set to default Environment - Distributed deployment Server1(report_srv) --Windows server 2003, Installed sql server 2008R2 reporting service,

Remote access to SQL-Server 2008 R2 on Windows Server 2008 denied

Hello, after successful installation of SQLServer 2008 R2 and providing my account as a 'sysadmin' I failed to access the server from a management studio of a SQL-Server 2005 release installation. The TCP/IP access is enabled and the server is configured to allow access from remote connections.  The error message reads a follows: ' A network-related or instance-specific error occured while establishing a connection to SQL Server. The server was not found or was not accessible. Verify ... (Provider: Named Pipes Provider, error 40 - Could not open a connection to SQL Server)(Microsoft SQL Server, Error:2)' Accessing the SQL-Server by the management studio from the local host works fine but trying to acces by command line using the '-E' parameter fails. Is there any additional configuration on the operation system level needed to open a SQL-Server 2008 instance to be selected by other members of  domain groups from the non-local host? Thank you for the answer  

Windows 7 CREATE DATABASE permission denied in database 'master'. (Microsoft SQL Server, Error: 26

Hi I have migrated to a new computer using Windows 7, 6 gig memory, I7 chip (old machine had xp) and have installed Visual Studio 2008 and  SQL Server 2008 R2.  I get CREATE DATABASE permission denied in database 'master'. (Microsoft SQL Server, Error: 262) when I try to create a new database.  Other posts (example:http://social.msdn.microsoft.com/forums/en-US/sqltools/thread/28fee0ed-c7e2-40df-8f79-f513c9848f09/) work for Vista but I cannot find how to grant permissions.  Run as administrator (vista fix) does not work. I have admin privaleges on my machine.  There are no other accounts.    What do I need to do to update privaleges? Thanks and have a nice day.    

"[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied error for a sched

Hi Guys, The subject of this question is the error which I am receiving when running a scheduled job also this is an error which we get at a random intervals and the frequency would be once or twice in a month. I have been through several posts and didn't concluded anything out of it. At the time when we receive this error the memory usage of the database was normal with free resources available and also the network was stable without issues. Our Sql database is in cluster mode with named instance. Can anyone share some information on this, I know this is not the right forum with the error message I have posted but am sure some one might have face the same problem when running some ETL jobs. Source and target both are sql server and the error message is generated in the validation phase of the connection manager connecting to target database. SSIS 2005 SP2 64 bit environmentRaju

sql server 2008 version upgrade failed access to path is denied

upgrading from 2008 r2 eval to 2008 r2 enterprise. Use the maintenance option from setup. Get pretty far along in the process.  But then the following error. ( an additional note. setup warns that I am running sql server on a domain controller server. ) The link the error message points to has nothing to say. Why would my sql server upgrade fail? If I have to reinstall, will I lose my database data? thanks,   TITLE: Microsoft SQL Server 2008 R2 Setup ------------------------------ The following error has occurred: Access to the path 'C:\Program Files\Microsoft SQL Server\100\License Terms\SQLServer2008R2_License_ENT_1033.rtf' is denied. Click 'Retry' to retry the failed action, or click 'Cancel' to cancel this action and continue setup. For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.50.1600.1&EvtType=0x60797DC7%25400xBB814387  

CommitChanges - General access denied error

Hi, We are developing a intranet web application through which our users can modify their profile information(in Active Directory). I am getting an error which says like this System.UnauthorizedAccessException: General access denied error at System.DirectoryServices.Interop.IAds.SetInfo() at System.DirectoryServices.DirectoryEntry.CommitChanges() Here is my vb code block --------------------------------------------------------------- Public sPath As String = "LDAP://domainname/OU=OITS,OU=ODI,DC=aa,DC=bb,DC=cc,DC=dd" Dim dsUser As DirectoryEntry = New DirectoryEntry(sPath, "domain/AdminID", "AdminPassword", AuthenticationTypes.Secure) dsUser = dsUser.Children.Find("CN=John") With dsUser.Properties .Item("displayname").Value = "John Doe" End With dsUser.CommitChanges() -------------------------------------------------------------- I am getting the above error while calling CommitChanges. Am I missing anything on ASPNET user account? Any thoughts?

Linked Server Mapping Error "Access to the remote server is denied because no login-mapping exists"


SQL Server 2005 SP3 32bit server
Connecting to an Oracle 10g server
Loaded OracleClient 10g

I'm able to ping the Oracle Server, and ODBC connect and able to run an open query with a single remote user id.

Issue: When I use the security context "Be made using this security context" it connects.
When I choose the "Not Be Made" WITH THE SAME USER ID & PASSWORD, I get the mapping error.

Create database permision denied in database ' master' (MS SQL SERVER, ERROR 262


Cn not do anything with my sql server, everything i trt to do i get this message, user does not have permision, etc, ,

I am running windows Vista Business, SQL SERVER 2005

so what going on here


Add Web reference in Visual Studio 2008 fails with Access denied error


i am trying to add a wsdl file to a C# project by using Add Web Reference utility but the tool fails with the error access denied to the path .. is denied. quite not sure where to check the params. any help would be appreciated.

Error: 5123 CREATE FILE encountered operating system error 5A(Access denied.)




 HI ,


 This is a problem I encountered when I had to detach a database file (type .mdf):


 1) I went to the MS SQL Management Server Studi and detached my database file successfully from a connection called Workhorse.


2) I needed to place the .mdf database file into a zip file in order to put it on a remote server. I did this using Shared Portal.  This was also successful


3) However when I tried reattaching the database file, I got this error:

CREATE FILE encountered operating system error 5A(Access denied.) while attempting to open or create the physical file "C\Program Files\MSSQL Server\MSSQL\Data\<databasename>.mdf'


Q) The database file and log file (ldf) exist in the correct directory so I don't know what happened. Can any one help?


 Thanks much




SQL Server 2008: Error in Creating Maintenance Plan



We are trying to create and edit a Backup Script in Maintenance plans.  It is throwing the following error. Please help.




See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.IO.FileNotFoundException: Could not load file or assembly 'msddsp, Version=,

Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the

file specified.
File name: 'msddsp, Version=, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'
   at Microsoft.DataTransformationServices.Design.DtrControlFlowDiagram.OnComponentChanged(Object

sender, ComponentChangedEventArgs chevent)
   at System.ComponentModel.Design.ComponentChangedEventHandler.Invoke(Object sender,

ComponentChangedEventArgs e)


ntChanged(Object component, MemberDescriptor member, Object oldValue, Object newValue)


ed(Object component, MemberDescriptor member, Obje

Access Denied error when i try to create a text file using vc++ project.



I have vc++ API project which  installes custom tool bar to adobe acrobat. I need to add a text file using this project. when i try to do it it's working in my computer, but when i run this api in another computer, it's giving access denied.

I am using Windows 7 and Visual Studio 8 for this project.

Please can any one give a suggestion or any other method to solve this issue.


Regarding "Cannot access disposed Object name:Transaction" DTC error in SQL server 2008


Hi all,

I have upgraded  my Sql server 2005 to Sql server 2008 in window 2003 server (SP 2 standard edition) . After upgrading  iam getting above mentioned MSDTC issue when try to make an distributed transaction with Sql server 2008 in my .Net application .

Note: No issues with SQL server 2005...

Please give me an solution

Access Denied error when i try to create a text file using vc++ project.



I have vc++ API project which  installes custom tool bar to adobe acrobat. I need to add a text file using this project. when i try to do it it's working in my computer, but when i run this api in another computer, it's giving access denied.

I am using Windows 7 and Visual Studio 8 for this project.

Please can any one give a suggestion or any other method to solve this issue.


SubscribeToEvents Server Method Error Hresult: 0x80070005 Access Denied


Hi there;

I am developping a smo app that uses the Server.Events.SubscribeToEvents Method and actually a have a

Access Denied Error if I use it local and I have a Hresult: 0x80070005 Access Denied if I use it remotly.

Are there somebody who can help me with these items????


PD. I hope that you forgive my english.



SQL Server 2008 R2, EXEC dbo.sp_cycle_agent_errorlog I get Access is denied?


When I execute the following SQL command I get a access denied message.  I am in the sysadmin and serveradmin roles. Why can I not execute the following command?

EXEC msdb.dbo.sp_cycle_agent_errorlog ;

Msg 22022, Level 16, State 1, Line 0
SQLServerAgent Error: Access is denied.

Thanks, Matt

sql server 2008 r2 install does not create database engine, also mmc creates error "Failed to create


I am loading sql server 2008 r2 developer edition into Windows Vista Home Basic. Product loads correctly with no error messages; except will not create database engine. And will not create integration services. When I try to open MMC, I will get error "MMC could not initialize the snap-in. Product may not have been installed correctly."

I understand this is a known issue for SQL Server 2008 RD installing on Windows Vista? What is the workaround or fix? Hot fixes available for this issue from support.microsoft.com do not install on my Windows Vista Home Basic machine.


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend