.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

SQLAgent2005 not starting

Posted By:      Posted Date: October 07, 2010    Points: 0   Category :Sql Server
I installed SQL 2005 successfully but sqlagent is not starting, giving the following error:

SQLServerAgent could not be started (reason: Error creating a new session).

And in the agent log I see the following error.
[298] SQLServer Error: 208, Invalid object name 'msdb.dbo.syssessions'. [SQLSTATE 42S02]

Can anybody give any ideas how to solve this?


View Complete Post

More Related Resource Links

SharePoint 2010 Long Starting if start workflow programatically


In SharePoint 2010, I'm starting workflow #2 programatically from my workflow #1. See code below:

					SPList currentList = web.Lists[new Guid(ListId)];
					SPListItem currentListItem = currentList.GetItemById(ListItem);

					//resolve any lookup parameters
					string workflowId = base.ProcessStringField(WorkflowIdentifier);

					//find workflow association by name
					SPWorkflowAssociation workflowAssoc = currentList.WorkflowAssociations.GetAssociationByName(workflowId, Thread.CurrentThread.CurrentCulture);

					if (workflowAssoc != null)
						//start the workflow
						SPWorkflow workflow = site.WorkflowManager.StartWorkflow(currentListItem, workflowAssoc, workflowAssoc.AssociationData, SPWorkflowRunOptions.Synchronous);

And workflow #2  will hang with Starting status (1-10 minutes), Then the workflow #2 status would be modified  to Completed.

I couldn't find how to start the workflow # 2 immediately and complete immediately without several minutes delay

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 Windows service hosting - not starting

Hi every experts i have WCF Service and a Windows service project for hosting that service when i install the win service with installutil and click start in services it show this message : "Windows could not start the Virtual WCF Service service on Local Computer. Error 5: Access is denied." i have this problem with this sample too : http://rapidshare.com/files/415123228/WCFSample.rar how can i fix this? THX

Failed to generate a user instance of SQL Server due to failure in starting the Process for the User

Could someone help with this please? I'm using VWD 2010 to build a new web site - I tried to add a new database file but it won't do it. I started by clicking on the folder 'App_Data', then right clicking and selecting 'Add new item' - after that I tried to add an SQL Server Database but received this message...  'Failed to generate a user instance of SQL Server due to failure in starting the Process for the User Instance' What does this mean? How do I start the 'Process for the User Instance'?  I imagined all that was done for me at the install stage, when I installed VWD2010, but it appears not.  Thank you for any help at all.    Regards

Starting with Company Website

I have a startup company that I plan on builind and publishing my website for. Nothing major with the first revision - just some information on the company - contact forms and quote request type things, and a blog page to highlight new products etc. I come mostly from using PHP for websites - however since I do a lot of .NET development profesionally I wanted to go the ASP route for my company site. Using Visual Studio 2010 I see I have the option of making an ASP.NET website - or I can go with a project and create an MVC2 application. Would there be any reason to use one over the other for what I wish to acomplish? Will both handle simple things such as in PHP hwere I can create a page and include it dynamically such as using the statement <?php include('header.inc.php') ?> My intention is not to get into a MVC vs WebForms debate - rather I'm trying to make a decision that will allow me to not have to scrap my code when at some point I decide to put in an application such as a portal for photo and video sharing.   Thanks 

Need advice on starting ASP and eCommerce programming

hello group,I'm about to start implementing an e-commerce using ASP.NET and C#. However, I'm moving from PHP to .NET platform, of course in past have done C# programming. I have few questions;Where to start? is only ASP.NET that I need to catch up with or other topics as well?How can I use an e-commerce template i.e. nop-commerce or ... such that I can write/read to/from a different database other than MS SQL Server?How can I learn to tie nop-eCommerce with my ASPX pages ? is there any reference that I can use to learn it or is it part of the documentation which come with online store API?Thanks in advance.

Microsoft .Net Framework needs deleting and starting over because it is a mess

Hello, I have a Hewlet Packard Computer and it is about 10 years old. Recently I was having problems with it and so I did a HP Systems Restore on it. The Compurer Repair man came to my house later and said that my computer only had the Service Pack 1 on it and that it needed more, so he added Service Pack 3 I think it was. Anyway then something else happened later and everything on my computer wasnt acting right again. I had tried adding the Microsoft .Net Framework stuff to it, and I knew absolutely nothing about it all, in fact, I wasnt even aware of it being on my computer till the Computer man had come here. I dont even know what it is for. But anyway, at one point I had tried to just remove it all off my computer entirely, going to my Control Panel and Add/Remove Programs, then I tried some kind of a Clean-up tool but I dont think I knew what I was doing. The whole thing is a mess and this morning it was acting up again. Can you please help me to be able to get this all off my computer completely then to add it properly back onto my computer? Also, I noticed the little yellow shield on the bottom right corner of my computer keeps saying Ive got one update, then it tries to add it, and I think its the Framework thing and it fails. It says it is installing Framework 3.5 then gives me a Fatal Execution Error OX7927f276 Then it pops up saying something about a debugger. Cou

how to display bread-crumb always starting from the root-web of the site collection, not the current

Hello all, In sharepoint 2010, the breadcrumb shown in the title area starts from the site you are currently into. Suppose my root web is Home and I have a subsite called Child1 and under this subsite I have another subsite called GrandChild1 My requirement : when I am at Home site .. currently the bread crumb shows Home .. as expected it shows Home when I am at Child1 site .. currently the bread crumb shows Child1 .. expecting it to be Home > Child1 when I am at Child1 site .. currently the bread crumb shows GrandChild1 .. expecting it to be Home > Child1 > GrandChild1   How can I achieve this ? Thanks mano   Mano Mangaldas | Blog : http://howtosharepoint.blogspot.com 

SPD workflow status show "starting" when I create a document from the library !!. and hangs

I have a document library in MOSS 2007. Have created a WF and that starts "autmatically when new item created" In the document library I have created couple of column those are mandatory (required columns) and user has to fill those column while uploading a document as well creating a document from library. WF has ran and completed succefully  when I use "upload" option to load a document.  As you are aware, when we "upload" a document, we will have to fill all "required columns" and the click "check in" command button.  After I do all this, document get loaded and WD ran succesfully. However, the WF is not running when I create a document (.docx) from this library (using "new" button) !!.  I have filled all required field in the document information panel . After save & exit from WORD application, I can see WF status as "starting". But, it never started and completed.  So I did following and found WF worked !! a) After creating document (.docx) using "new" option I found WF status "starting"!. So,  I did "Check-out and Check-in" manually from document library. After doing this,  WF ran and status has been changed as "completed" b) In SPD, I change workflow start option from "Automatic" to "Manually start".&nb

Adding starting text to a column field

I am wanting to know if there is a way you can add starting text within a field that displays within a page layout?  I have a page layout that has a field (column) called 'page summary'. What I want to do is when a content managers creates a new page based on that page layout, the text "This page contains a public notice" is automatically inserted in the page summary field and the content manager can continue typing or highlight the text and remove it. Kind of like adding a base 'Text Value' to the field (column).  I want to be able to do it without having to do custom code though.

Workflow stuck on starting When using Win 7 / Office 2007

I've recently created custom workflows for a document approval process. At first I set the workflows to be started manually, for testing purposes and everything worked well. However when I changed the workflows to start automatically I started get problems. The workflow progress would stick on "Starting". Im running Win 7 And Office 2007, so i decided to do some troubling shooting on a different machine (XP and 2003) This time the workflow work perfectly...!   It is really strange as to why the workflows work fine on XP and 2003 and not with Win 7 and 2007. Can anybody shed any light on this or had the same problem? Thanks Chris

Having trouble starting my very own MVC tutorial-sans web application.

I'm having trouble trying to understand what to do here. My objective isn't as simple as a regular old CRUD form to create a new entity, but rather a browse index page that will list all of the Evaluations in my database. Each evaluation is attached to a RegisteredCourse which in turn has a Teacher attached to it. Here is how I'd like to present the information:My table structure doesn't allow me to just invoke it simply, so I know I have to create a ViewModel to have my controller give my View something nice and useful. My question is how to create this ViewModel. I'm stumped because I've never tackled this sort of problem before. Thanks. Below is SQL schema if that helps.create table Grado( ID int identity(1,1) primary key, Nombre varchar(64) ) create table Jefe( ID int identity(1,1) primary key, Nombre varchar(128), Apellido varchar(256) ) create table Area( ID int identity(1,1) primary key, IDJefe int foreign key references Jefe(ID), Nombre varchar(64) ) create table Carrera( ID int identity(1,1) primary key, IDArea int foreign key references Area(ID), Nombre varchar(64) ) create table Docente( ID int identity(1,1) primary key, IDCarrera int foreign key references Carrera(ID), IDGrado int foreign key references Grado(ID), Nombre varchar(128), Apellido varchar(256), Carnet varchar(20), FechaNacimiento datetime ) create table Materia( ID int

Problem in starting the SQL Server Reporting Services

Hi All,   I have a problem in deploying the reports. when i try to deploy the reports it shows that  Report Sever not working but when i try to start my SQL Server Reporting Services will get the below mentioned error so please can one could suggest me on  this. "Could not Start the SQL Server Reporting Services (MSSQLSERVER) service on local computer ERROR1053: Service didnt respond to start or control request in a timely fashion" Regards, Snusha  

SQL Server not starting - FallBack certificate initialization failed

I can not start my SqlServer 2008 Express. The problem seemed to start when I changed my "Built In account, Log in as" from Local Service to Local System. If I try to change back to Local Service I get the messagebox with WMI Provider Error, "Cannot find object or property. [0x80092004]". Getting a bit confused, but read http://support.microsoft.com/kb/900497    mentioned about  HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\SuperSocketNetLib, Value name: Certificate, Type: REG_SZ not having a valid value then 2005 would not starte - my value is blank. Changing it to 0 did not work.How can I import a valid certificate using SQL Server Configuration Manager. And how do you turn off Forced Encryption? Not sure if this would fix it, but couldn't hurt.====================================== 2009-03-08 01:39:06.01 Server      Error: 17190, Severity: 16, State: 1.2009-03-08 01:39:06.01 Server      FallBack certificate initialization failed with error code: 1.2009-03-08 01:39:06.01 Server      Unable to initialize SSL encryption because a valid certificate could not be found, and it is not possible to create a self-signed certificate.2009-03-08 01:39:06.01 Server      Error: 17182, Severity: 16, State: 1.2009-03-08 01:39:06.01 Server      TDSSNIClient initialization failed with error 0x80092004, status code 0x80. Reason: Unable to i

Populate Excel Spreadsheet Starting At Specific Row

I am trying to populate an excel workbook using a data flow and it no longer works. I have a command button in cell a1, so the column headings need to start in row 3 and the data in row 4. also the column headings need to be red background. the data is ending up in the right row but no all the rows are also red. everything was working fine, now it is broken and cant figure out why. first i DROP TABLE, to clear the contents of the worksheet, this now only clears the column headings, the i CREATE TABLE, to put back the column headings, this works. Then using the data flow I populate the spreadsheet, it end up in row 3, which is right, but honetly i dnot know why. the problem is all the data rows are red. can anyone please help me with this. thanks.

User Profile Sync not starting anymore

Hi! http://www.harbar.net/articles/sp2010ups.aspx Followed this guide to enable User Profile syncronization excluded the creation of the two Web applications and User Profile Service. I had these already setup by default when I installed SharePoint Server 2010. The first time I started Syncronization service it did succesfully started the Forefront services in windows and the sync service, but when I began configuring import connection settings I got connection to AD and saw all the users in AD groups, but never got it done because a error that said something about "??? WA"...don't remember anymore. I figured out that it was just because that I didn't do "IIS reset" nor the  system restart. So I did IIS reset and also restarted the system just incase. When system got back up ForeFront Manager Service was down, cause everyone told that you shouldn't mess around Service.msc so I figured that I could just stop sync service and start it again. And here I am figuring out why nothing will come back on. Both ForeFronts are in disabled state and sync service stopped. When I try to start sync service it tries a while, "ForeFront sync service" -startup change to automatic but returns to disabled state and in SharePoint sync service comes back to stopped state. Yes SharePoint farm account is in local admin group! Any suggestion

Incoming E-Mail with attachment not starting SharePoint workflow (VS 2008)

I am working on SharePoint 2007 workflow in visual studio 2008. The workflow is attached to an email-enabled list and is supposed to automatically start on incoming email. It works fine when email (without attachment) is sent to the list but the workflow cannot start when the email is sent with attachment. There is no error message but the workflow status field is blank. The attachment field is also blank. When I manually run the workflow, it works fine. This problem happened on Staging and production servers. On Development server, the workflow works fine either way. The list is setup to save attachments. Any help please
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