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.

ERROR - "The underlying connection was closed"

We are running Reporting Services on an SBS 2003 server and have created a
WinForms application that will print reports from RS. Everything works great
from the SBS server but when I run the application from another machine on
the same domain I get the following error: "The underlying connection was
closed: Unable to connect to the remote server."
We're not using SSL or proxies.
Does anyone have any idea what might be causing this problem? Any help would
be greatly appreciated!"Robert" <Robert@.discussions.microsoft.com> wrote in message
news:61AD6244-FDD6-43F0-A5C9-277F269128E2@.microsoft.com...
> We are running Reporting Services on an SBS 2003 server and have created a
> WinForms application that will print reports from RS. Everything works
> great
> from the SBS server but when I run the application from another machine on
> the same domain I get the following error: "The underlying connection was
> closed: Unable to connect to the remote server."
> We're not using SSL or proxies.
> Does anyone have any idea what might be causing this problem? Any help
> would
> be greatly appreciated!
Is this a web service call? I've found a very simple way to reduce 99.9% of
these errors with web services is to place the initial web service call in a
try...catch block. If it fails, immediately try the same web service call
again. That usually fixes it.
HTH,
Mike Rodriguez

Erratic connections to SQL database

We are running SBS 2003 Premium with SP1.
Each PC runs a small VB .exe, a booking program, which we use as a front end
to SQL database.
Since installing ISA Server 2004 and SQL2K SP4 several machines now have
trouble running the booking program. It hangs for up to 30 seconds at a time
in different parts of the process but always, apparently, when it is trying
to access the SQL data. A booking that should take no more than half a minute
is now taking 5 minutes or more.
All other machines running the same program do not have a problem. I have
slowly eliminated user issues, log in issues and possible physical (network)
problems.
Now I am baffled!
Any suggestions please!
"mh1959" <mh1959@.discussions.microsoft.com> wrote in message
news:685E71AD-84FC-4D5C-97EF-11CBC3954350@.microsoft.com...
> We are running SBS 2003 Premium with SP1.
> Each PC runs a small VB .exe, a booking program, which we use as a front
> end
> to SQL database.
> Since installing ISA Server 2004 and SQL2K SP4 several machines now have
> trouble running the booking program. It hangs for up to 30 seconds at a
> time
> in different parts of the process but always, apparently, when it is
> trying
> to access the SQL data. A booking that should take no more than half a
> minute
> is now taking 5 minutes or more.
> All other machines running the same program do not have a problem. I have
> slowly eliminated user issues, log in issues and possible physical
> (network)
> problems.
> Now I am baffled!
> Any suggestions please!
Is your ISA server throttling bandwidth for some reason?
What type of connection are you using? Named Pipes? TCP/IP?
What is the speed of the network? What are your NIC cards set to if they
can do both 10/100/1000 for example.
Rick Sawtell
|||Rick,
Thanks for your response, as soon as I saw your question about "named pipes"
I realised where the problem was.
Thanks for your help.
"Rick Sawtell" wrote:

> "mh1959" <mh1959@.discussions.microsoft.com> wrote in message
> news:685E71AD-84FC-4D5C-97EF-11CBC3954350@.microsoft.com...
> Is your ISA server throttling bandwidth for some reason?
> What type of connection are you using? Named Pipes? TCP/IP?
> What is the speed of the network? What are your NIC cards set to if they
> can do both 10/100/1000 for example.
> Rick Sawtell
>
>

Erratic connections to SQL database

We are running SBS 2003 Premium with SP1.
Each PC runs a small VB .exe, a booking program, which we use as a front end
to SQL database.
Since installing ISA Server 2004 and SQL2K SP4 several machines now have
trouble running the booking program. It hangs for up to 30 seconds at a time
in different parts of the process but always, apparently, when it is trying
to access the SQL data. A booking that should take no more than half a minute
is now taking 5 minutes or more.
All other machines running the same program do not have a problem. I have
slowly eliminated user issues, log in issues and possible physical (network)
problems.
Now I am baffled!
Any suggestions please!"mh1959" <mh1959@.discussions.microsoft.com> wrote in message
news:685E71AD-84FC-4D5C-97EF-11CBC3954350@.microsoft.com...
> We are running SBS 2003 Premium with SP1.
> Each PC runs a small VB .exe, a booking program, which we use as a front
> end
> to SQL database.
> Since installing ISA Server 2004 and SQL2K SP4 several machines now have
> trouble running the booking program. It hangs for up to 30 seconds at a
> time
> in different parts of the process but always, apparently, when it is
> trying
> to access the SQL data. A booking that should take no more than half a
> minute
> is now taking 5 minutes or more.
> All other machines running the same program do not have a problem. I have
> slowly eliminated user issues, log in issues and possible physical
> (network)
> problems.
> Now I am baffled!
> Any suggestions please!
Is your ISA server throttling bandwidth for some reason?
What type of connection are you using? Named Pipes? TCP/IP?
What is the speed of the network? What are your NIC cards set to if they
can do both 10/100/1000 for example.
Rick Sawtell|||Rick,
Thanks for your response, as soon as I saw your question about "named pipes"
I realised where the problem was.
Thanks for your help.
"Rick Sawtell" wrote:
> "mh1959" <mh1959@.discussions.microsoft.com> wrote in message
> news:685E71AD-84FC-4D5C-97EF-11CBC3954350@.microsoft.com...
> > We are running SBS 2003 Premium with SP1.
> > Each PC runs a small VB .exe, a booking program, which we use as a front
> > end
> > to SQL database.
> > Since installing ISA Server 2004 and SQL2K SP4 several machines now have
> > trouble running the booking program. It hangs for up to 30 seconds at a
> > time
> > in different parts of the process but always, apparently, when it is
> > trying
> > to access the SQL data. A booking that should take no more than half a
> > minute
> > is now taking 5 minutes or more.
> > All other machines running the same program do not have a problem. I have
> > slowly eliminated user issues, log in issues and possible physical
> > (network)
> > problems.
> > Now I am baffled!
> > Any suggestions please!
> Is your ISA server throttling bandwidth for some reason?
> What type of connection are you using? Named Pipes? TCP/IP?
> What is the speed of the network? What are your NIC cards set to if they
> can do both 10/100/1000 for example.
> Rick Sawtell
>
>

Erratic connections to SQL database

We are running SBS 2003 Premium with SP1.
Each PC runs a small VB .exe, a booking program, which we use as a front end
to SQL database.
Since installing ISA Server 2004 and SQL2K SP4 several machines now have
trouble running the booking program. It hangs for up to 30 seconds at a time
in different parts of the process but always, apparently, when it is trying
to access the SQL data. A booking that should take no more than half a minut
e
is now taking 5 minutes or more.
All other machines running the same program do not have a problem. I have
slowly eliminated user issues, log in issues and possible physical (network)
problems.
Now I am baffled!
Any suggestions please!"mh1959" <mh1959@.discussions.microsoft.com> wrote in message
news:685E71AD-84FC-4D5C-97EF-11CBC3954350@.microsoft.com...
> We are running SBS 2003 Premium with SP1.
> Each PC runs a small VB .exe, a booking program, which we use as a front
> end
> to SQL database.
> Since installing ISA Server 2004 and SQL2K SP4 several machines now have
> trouble running the booking program. It hangs for up to 30 seconds at a
> time
> in different parts of the process but always, apparently, when it is
> trying
> to access the SQL data. A booking that should take no more than half a
> minute
> is now taking 5 minutes or more.
> All other machines running the same program do not have a problem. I have
> slowly eliminated user issues, log in issues and possible physical
> (network)
> problems.
> Now I am baffled!
> Any suggestions please!
Is your ISA server throttling bandwidth for some reason?
What type of connection are you using? Named Pipes? TCP/IP?
What is the speed of the network? What are your NIC cards set to if they
can do both 10/100/1000 for example.
Rick Sawtell|||Rick,
Thanks for your response, as soon as I saw your question about "named pipes"
I realised where the problem was.
Thanks for your help.
"Rick Sawtell" wrote:

> "mh1959" <mh1959@.discussions.microsoft.com> wrote in message
> news:685E71AD-84FC-4D5C-97EF-11CBC3954350@.microsoft.com...
> Is your ISA server throttling bandwidth for some reason?
> What type of connection are you using? Named Pipes? TCP/IP?
> What is the speed of the network? What are your NIC cards set to if they
> can do both 10/100/1000 for example.
> Rick Sawtell
>
>