Error 14258 while creating a publication

Hi all,
I am trying to create a merge-publication (SQL 2000 SP4).
Unfortunately, it is not working because the wizard pops up with error
14258: Cannot perform this operation while SQL Server Agent is
starting. Try again later.
Checked both services, they seem correct. Both are using (the same)
domain-user with sufficient privs to access the SQLServer box. They
both run fine (all in the green) and there are no errors in the logs.
SQL itself runs fine and I can access all data from any computer in the
network.
Just to be sure, I've stopped and restarted both services but the same
error comes back again. I've checked all settings but as far as I can
see, the box is configured properly.
Any ideas?
Thx,
FS
Check out this MS article:
http://support.microsoft.com/?id=303287
John Steen
"Ferry" wrote:

> Hi all,
> I am trying to create a merge-publication (SQL 2000 SP4).
> Unfortunately, it is not working because the wizard pops up with error
> 14258: Cannot perform this operation while SQL Server Agent is
> starting. Try again later.
> Checked both services, they seem correct. Both are using (the same)
> domain-user with sufficient privs to access the SQLServer box. They
> both run fine (all in the green) and there are no errors in the logs.
> SQL itself runs fine and I can access all data from any computer in the
> network.
> Just to be sure, I've stopped and restarted both services but the same
> error comes back again. I've checked all settings but as far as I can
> see, the box is configured properly.
> Any ideas?
> Thx,
> FS
>
>
|||Hmm, I guess I was too fast... Solved the problem already by googling a
bit further. As a thank you for reading I will share the solution :-)
When having MSDTC switched on _and_ using NT-fibres in the SQL
configuration, you can encounter this error. Switching the NT-fibres
off (and stopping and starting the services again) resolved the
problem. MSKB article, aaaaargh, how could I missed it in the first
place...
From Ferry :
> Hi all,
> I am trying to create a merge-publication (SQL 2000 SP4). Unfortunately, it
> is not working because the wizard pops up with error 14258: Cannot perform
> this operation while SQL Server Agent is starting. Try again later.
>

Error - SuperSocket info: (SpnRegister): Error 8206

We just installed SQL Server 2000 (as part of SBS 2003) including service pack 3a.

When we reboot the server a message pops up that a service did not start properly.

The error is 'SuperSocket info: (SpnRegister): Error 8206'.

I have searched here and other places on the Internet without any success.

All assistance is appreciated as we cannot continue.

Hello, Allan!

You should check if the SQL SErver service account has permission enough in your server. This error normally occours when you start SQL Server service and you are not in a domain environment or your SQL Server couldn't find Domain Controller to create a SPN.

First: check the SQL Server service Account. If you don't have a specific account for that, use Local System or use another domain account and put it inside the local administrators group.

Error - SuperSocket info: (SpnRegister): Error 8206

We just installed SQL Server 2000 (as part of SBS 2003) including service pack 3a.

When we reboot the server a message pops up that a service did not start properly.

The error is 'SuperSocket info: (SpnRegister): Error 8206'.

I have searched here and other places on the Internet without any success.

All assistance is appreciated as we cannot continue.

Hello, Allan!

You should check if the SQL SErver service account has permission enough in your server. This error normally occours when you start SQL Server service and you are not in a domain environment or your SQL Server couldn't find Domain Controller to create a SPN.

First: check the SQL Server service Account. If you don't have a specific account for that, use Local System or use another domain account and put it inside the local administrators group.