Hi gang,

I AM actually a somewhat accomplished .NET (among other things) developer, and consider myself pretty familiar with SQL Server 2K.

However, I just experienced a weird thing that I do not understand and am hoping someone can show me the light.

I have a simple VB.NET app that updates a table in SQL Server 2K. It was working just fine but after a reboot of my machine, stopped updating the DB. No error, nothing, just no updates or inserts to the DB.

I was looking to be sure the SQL Server Service was running, and just on a whim, I activated the SQL Server Agent Service. Suddenly the .NET app was working again! Stopped the Agent Service, and the app stopped working.

WHY?!?!? I'm not crazy in remembering that I have never had to do this in the past, right? Or was it always running and I have never noticed, and that is the way the SQL Server architecture is designed?

I am running XP Pro, .NET 2.0, and SP4 on SQL Server 2K. Can anyone either point me in the right direction, or confirm the title of this post?

Thanks!

Chris

That is very unusual but check what account your SQL server is running on.

1-Are you running the SQL Server under the local server account
2-Are you part of the domain or local administrator group
3-Do you still have the built/administrator account as a login to SQL?

Jaime E. Maccou

Hi Jaime,

Thanks for jumping in on this.

1) I am running SQL Server (and the services) as the Administrator WinXP user account.
2) We use a workgroup here, but no domain.
3) In my Security node for the local instance, I have BUILTIN/Administrators, <machine name>/ASPNET, sa, and the user account for the DB I am working with.

Additionally, in the Users node of the DB I am working with, I have ASPNET, dbo, and the user account.

Is there something missing there?

Thanks!

Chris

You certainly don't need the agent running to connect to SQL Server. If you start the agent it will start the SQL Service automatically. Are you sure the main service was running, can you reproduce this by turning off just the agent?

--

Joe (Microsoft MVP - XML)

Hi Joe,

Yeah, first thing I tried. I thought, at first, it was just coincidence, but it was totally reproducible.

However, I had shut everything down last night in a fit of frustration. Come in this morning, reboot, and suddenly everything works as expected. SQL Server service is ON, SQL Server Agent service is OFF, and the DB is updating.

I must have done something yesterday... maybe left a transaction open or something, that caused it.

Sorry for the wild goose chase, but thanks for the help.

Cheers,

Chris

PS - If either of you have any .NET experience, I have a post at http://p2p.wrox.com/topic.asp?TOPIC_ID=59444 that no one is responding to that I could really use some help with!