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


Top 5 Contributors of the Month
Kaviya Balasubramanian
Sgraph Infotech
Imran Ghani
Post New Web Links

Error 14258: Cannot perform this operation while SQLServerAgent is starting. Try again later.

Posted By:      Posted Date: September 18, 2010    Points: 0   Category :Sql Server
 
I'm getting the following error on two of my SQL Servers - Error 14258: Cannot perform this operation while SQLServerAgent is starting. Try again later. The only solution that I have seen is the same solution that Microsoft has published in the following article - KB303287 [http://support.microsoft.com/?scid=http%3a%2f%2fwww.support.microsoft.com%2fkb%2f303287%2fen-us%2f] The solution is to unflag the use of NT Fibers.  However, our software application provider is advising us against doing this.  Is there another fix anywhere that I could get my hands on - another solution? Thanks in advance.


View Complete Post


More Related Resource Links

Error "user does not have permission to perform this operation" with User Instance = True.

  

I setup SQL Server 2005 / SQL Express. All works fine in SQL Server 2005.

I am connecting to a SQL Database from VS 2005,  Tools/Connect to Database. I set the Data Source to "Microsoft SQL Server Database File (SqlClient)" (meaning SQL Server Express) and User Instance = True, and Integrated Security = True.

The above is working successfully on all machines except my Laptop. On my Laptop, I am getting this error "user does not have permission to perform this operation". On my Laptop, if I change User Instance = False, it works fine. Also, If I connect to SQL Server 2005 it works fine only if User Instance = False.

I tried all kind of security changes, nothing worked. For example, I setup Everyone as Full Control for the Folder and the MDF File of SQL Server. I gave my user ID as sysadmin role in SQL Server Express. Also, I enabled creating User Instance form SQL Server Express, Nothing is working.

Appreciate your help.

Tarek.


Error "user does not have permission to perform this operation" with User Instance = True.

  
I setup SQL Server 2005 / SQL Express. All works fine in SQL Server 2005. I am connecting to a SQL Database from VS 2005,  Tools/Connect to Database. I set the Data Source to "Microsoft SQL Server Database File (SqlClient)" (meaning SQL Server Express) and User Instance = True, and Integrated Security = True. I am using Windows Authentication mode in SQL Server Express. The above is working successfully on all machines except my Laptop. On my Laptop, I am getting this error "user does not have permission to perform this operation". On my Laptop, if I change User Instance = False, it works fine. Also, If I connect to SQL Server 2005 it works fine only if User Instance = False. I tried all kind of security changes, nothing worked. For example, I setup Everyone as Full Control for the Folder and the MDF File of SQL Server. I gave my user ID as sysadmin role in SQL Server Express. Also, I enabled creating User Instance form SQL Server Express, Nothing is working. I am already added to the Administrator Group locally on my Laptop. Still same problem. Checked this article: http://msdn.microsoft.com/en-us/library/ms254504.aspx, same problem. I enabled User Instances and also tried to Disable User Instances. When I disable user instances, and then try to connect from VS, I get a different error, which is asking to enable user instances.

Encountering error when trying to perform any AS operation because of corrupt file

  

Hi,

I tried to restore a database i had downloaded from the net, but i guess the file was corrupted or I hadn't done it the proper way. However, now, am not able to do anything with my other AS databases as well ( ie, not able to browse, write MDX etc ). I tried deleting the problematic database but still encountered the same error :

File system error: Error opening file; \\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Foodmart 2000.2.db\0.CryptKey.bin is not a disk file or file is not accessible.
Errors in the metadata manager. Processing for the database will be disabled because of an error occured hile loading the 'Foodmart 2000' database cryptography key. One possible reason for this error is that the service account has changed.
(Microsoft.AnalysisServices)

Kindly help!!


--Mark the thread as answered if one of the replies answers your question. Thank you

Attempted to perform an unauthorized operation Error when customizing theme of a new site

  

I am just trying to change the color of the site.  when I click apply, i get this error.

 

Error

Attempted to perform an unauthorized operation.

 

Troubleshoot issues with Microsoft SharePoint Foundation.

Correlation ID: 6164e755-f413-4e3b-a79b-be7bf7739f42

Date and Time: 11/23/2010 1:18:20 PM

 

Any help will be greatly appreciated


ToggleDebugCompilation fails trying to perform "an unauthorised operation"

  

Hi,

We're having a problem with the Visual Studio 2008 RTW version of the web deployment projects on a colleagues machine. The project works fine if I run it on my machine, but when he tries to run it on his machine he gets:

<SNIP : Most output removed>
  Task "Exec"
    Command:
    if exist ".\TempBuildDir\" rd /s /q ".\TempBuildDir\"
  Done executing task "Exec".
  Using "ToggleDebugCompilation" task from assembly "C:\Program Files\MSBuild\Microsoft\WebDeployment\v9.0\Microsoft.WebDeployment.Tasks.dll".
  Task "ToggleDebugCompilation"
    Updating Web.config <compilation> element debug attribute to 'True'.
    C:\Program Files\MSBuild\Microsoft\WebDeployment\v9.0\Microsoft.WebDeployment.targets(639,7): error : Attempted to perform an unauthorized operation.
    C:\Program Files\MSBuild\Microsoft\WebDeployment\v9.0\Microsoft.WebDeployment.targets(639,7): error MSB4018: The "ToggleDebugCompilation" task failed unexpectedly.
    C:\Program Files\MSBuild\Microsoft\WebDeployment\v9.0\Microsoft.WebDeployment.targets(639,7): error MSB4018: System.ArgumentNullException: Parameter "message" cannot be null.
    C:\Program Files\MSBuild\Microsoft\WebDeployment

show data in grid view error Arithmetic operation resulted in an overflow.

  

sir

i have a table there is 17 columns in 17 column 3 are number and other are varchar . when i try to display all data of that column error occures.

one more intersting think is when i try to display 6 column then grid show there data an no more error occures. 

when i run my project this error occures in grid view

Arithmetic operation resulted in an overflow. 


Can not perform this operation.The file is no longer checked out or has been deleted?

  
In my sharepoint designer 2007, when I try to check in a file, it give me the following errors:

Can not perform this operation.The file is no longer checked out or has been deleted.

Please advise me how to fix this problem?

Thanks.

Error starting SQL Server Agent - Could not load the DLL xpstar90.dll. Reason: 126

  
AD Service account password was changed.  Now the SQL Server Agent (MSSQLSERVER) will not start even after updating the password.  Have no access into the databases.  Log files say "Could not load the DLL xpstar90.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.)."  Service Account has Full rights on system.  Any help in solving the problem would be great.

WCF Tracing Error: An operation was attempted on a nonexistent network connection

  
I setup WCF service tracing because 1 client out of about 30 wasn't able to finish the connection to the server. After setting up test case on that client, the WCF trace report gave me these exceptions:     An operation was attempted on a nonexistent network connection and then     The I/O operation has been aborted because of either a thread exit or an application request I found this MSDN question and solution that applies to Windows 2000 Server and Terminal Services and offers a hotfix to fix the issue. I'm using Windows 2003 Server, so the hotfix doesn't apply to me. Does anyone know what is happening to this 1 client while the other 29 connect just fine? The client returns this exception when trying to open the connection to the server:     An error occurred while receiving the HTTP response to http://endpointaddress/. This could be due to the service endpoint binding not using the HTTP protocol. This could also be due to an HTTP request context being aborted by the server (possibly due to the service shutting down). See server logs for more details.

SQLServerAgent could not be started (reason: Startup error: The 'msdb' database does not exist)

  
After installing Service pack 3 for Microsoft SQL Server 2005 the SQLServerAgent wont start: From SQLAGENT.OUT: 2010-08-30 17:10:08 - ! [298] SQLServer Error: 208, Invalid object name 'sys.configurations'. [SQLSTATE 42S02] (DisableAgentXPs) 2010-08-30 17:10:08 - ! [298] SQLServer Error: 208, Invalid object name 'master.dbo.sysdatabases'. [SQLSTATE 42S02] 2010-08-30 17:10:08 - ! [000] Startup error: The 'msdb' database does not exist 2010-08-30 17:10:08 - ! [298] SQLServer Error: 208, Invalid object name 'sys.configurations'. [SQLSTATE 42S02] (DisableAgentXPs) 2010-08-30 17:10:08 - ? [098] SQLServerAgent terminated (normally)

processing measure group : memory error : the operation cannot be completed because the memory quota

  
Hi, I'm stucked with this problem. Untill last week, the cube processed without any problem. Since last week, I'm getting this error. I have been searching in different forums, and I tried some suggestions, like changing memory limit properties, ... It is getting worse.. So I reset all properties to default again. I am running SQL-Server + MS-AS 2005 SP2 on server with 4GB of memory. This is a dedicated server, nothing else is running on it. The fact table has +/- 14 million records, several dimensions en 2 measure groups. I don't have problems to process the dimensions, but when I try to process the cube or the measure groups of that cube separately , the error persists. I have changed the datasource view, and replaced the fact table by a Named query. Even when I put a 'WHERE datapart( year , fact_date ) >= 2009 ' clause to reduce the number of records to +/- 5 million, I'm still getting the error. I don't understand what is wrong, the cube always processed since +/- 2 years. As I said, I have found a lot of this kind of Issues on different websites, I have been trying to change some properties. But this still does not solve the problem. Could it be that MS-AS settings are corrupt somewhere ? Is it a good idea to re-install MS-AS 2005 + SP1 + SP2 ? Or is there another reason possible ? I really appreciate any kind of help, because I'm

Error occurred in deployment step 'Retract Solution': Attempted to perform an unauthorized operati

  
Hi, Is there any reason why I got the error above in my dev machine? It works perfectly fine if I login using the service account. So permission do I need for a regular account? Thanks in advance.

Could not complete the operation due to error 800a025e

  
Hi Does anyone got this message before:  Could not complete the operation due to error 800a025e.   What does this message means? I have no idea how to proceed with this......   Anyone?

Error creating Read Item or Read List operation in Sharepoint Designer 2010

  
In terms of high-level requirements, I need to pull in lists from a couple of different web apps.  To do this, I’m using SPD 2010 to create an External Content Type for the list of interest.  I’m able to create a SOAP Service or WCF Service connection just fine.  However, when I try to create the external content type and create a Read Item Operation on one of the GetList or any other Get* (or other Update methods for that matter) methods, I get the following error:"The method that your operation is based on has parameters with complex types that do not have default parameterless constructor.  This kind of data source methods cannot be used in Business Data Catalog."I tried defining an operation on the “AddAttachment” method, and that worked just fine.  I also tried providing default values to the listName and viewName parameters when creating the SOAP Service connection, but still get the error.  Same issue with a WCF Service connection as well. Does anyone know if this is a 2010 issue, or am I approaching this requirement incorrectly?  What are other approaches for connecting to lists that reside in a different web app than yours? 

Memory error: The operation cannot be completed because the memory quota estimate when trying to dep

  
Hi All: We have installed SQL Server 2008 Integration Services in a Windows 2003 machine. RAM capacity is 4GB We have a created a sample project with necessary data source, data view, cubes and dimension definition. When we try to build the cube, it is throwing the below exception Memory error: The operation cannot be completed because the memory quota estimate (1504MB) exceeds the available system memory (1331MB). We even tried with data view of few columns but encountering the same error. How to fix this issue? Please help Regards, Swami

Backup failing - Error "operation is not valid due to the current state of the object" ...........Ca

  
Hi, I am having a problem backing up a site collection, when trying to backup the collection I get the following error  "operation is not valid due to the current state of the object"............. "Category Info :InvalidData" . I'm getting the same error whether I use CA "granular backup" or "Farm backup", and using either STSAMD or Powershell. I can backup CA or the mysite collection but not the Home Portal site collection. As this is a production system I am really worried that something is going to happen and I'll have no backup. Does anyone have any suggestions on what i can do to either fix the problem or an alternative way to backup the collection or farm.  P.S. I am not using the "UseSQLSnapshot" parameter. Any ideas ? 

SharePoint 2010 search error - Illegal operation attempted on a registry key that has been marked fo

  

I've come across an error with SP2010 standard search a few times now.  The error message is "Illegal operation attempted on a registry key that has been marked for deletion", and it happens when "SearchService.svc" is accessed by SP Search.  I have seen this error on my dev environment, test environment and a client's UAT environment.  The resolution is a reboot of the server, but that's obviously far from ideal.  I've tried to restart all SharePoint related services too without any luck.  This error doesn't seem to occur regularly, and can take days before it happens after a reboot.

 

The full error message is below:

 

Server Error in '/4ca4d32e32d848338cab8aeeb78f7a2b' Application.


Categories: 
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