Error 18483 while configuring distributor

I want to setup a publisher, distributor and subscriber on the same machine.
While configuring my distributor using Wizard, I received the following
error:
Error 18483: Could not connect to server 'HONB" because "distributor_admin"
is not defined as a remote login at the server.
I am using SQL Server Developer version and "HONB" is my computer name. Can
someone tell what I have mis-configed?
This is usually a naming issue.
Try:
Use Master
go
Select @.@.Servername
This should return your current server name but if it
returns NULL then try:
Use Master
go
Sp_DropServer 'Server1'
GO
Use Master
go
Sp_Addserver 'Server1', 'local'
GO
Stop and Start SQL Services
If this is not the issue, but you are working across non-trusted doamins
there is the same error, so you might want to have a look at his article:
http://support.microsoft.com/?id=321822.
Regards,
Paul Ibison
|||I tried to run the sql, the servername is ok.
I read articale, but it seems not related to my problem, since I want to
setup the replication on a single machine.
Is it related to sql server agent? I am using system account as the startup
account in Sql server agent.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> bl
news:Oocp%23YwKEHA.4052@.TK2MSFTNGP11.phx.gbl g...
> This is usually a naming issue.
> Try:
> Use Master
> go
> Select @.@.Servername
> This should return your current server name but if it
> returns NULL then try:
> Use Master
> go
> Sp_DropServer 'Server1'
> GO
> Use Master
> go
> Sp_Addserver 'Server1', 'local'
> GO
> Stop and Start SQL Services
> If this is not the issue, but you are working across non-trusted doamins
> there is the same error, so you might want to have a look at his article:
> http://support.microsoft.com/?id=321822.
> Regards,
> Paul Ibison
>
|||The system account is OK if it is all done on the same box.
You might be able to use sp_remoteoption and sp_addremotelogin to fix the
issue.
HTH,
Paul Ibison
|||can you remove replication, and then re-install it.
"gh" <ghghghgh@.FSAF.COM> wrote in message
news:uinEcarKEHA.1388@.TK2MSFTNGP09.phx.gbl...
> I want to setup a publisher, distributor and subscriber on the same
machine.
> While configuring my distributor using Wizard, I received the following
> error:
> Error 18483: Could not connect to server 'HONB" because
"distributor_admin"
> is not defined as a remote login at the server.
> I am using SQL Server Developer version and "HONB" is my computer name.
Can
> someone tell what I have mis-configed?
>
>
>

error 17805; invalid buffer received from client

Seen this ?
http://support.microsoft.com/default.aspx?scid=kb;en-
us;832977
Peter
"Action speaks louder than words but not nearly as often"
Mark Twain

>--Original Message--
>I am trying to capture this error at its source. It is
very random and when
>using sql profiler I get too many rows that overload the
system. I simply
>want to catch the stored proc. (or T-sql statement) that
is causing this
>error. When I run sql profiler to only capture this
error that is fine but I
>in the TextData column I only get the error message,
again not the stored
>proc or statement that is causing this.
>Is there another way I should be running sql profiler?
Is there an error
>table that I can put a trigger on? ANY suggestions would
be appreciated.
>Thanks.
>.
>yes, but I did not notice the link to the sp_blocker_pss80 before. This
still gives me too much information (and will quickly fill up my hard drive)
when I just want to capture the event that is causing this. I will double
check but I'm pretty sure we are not using the utilities that are mentioned
in those articles.
Thanks anyway for you help.
"Peter The Spate" wrote:

> Seen this ?
> http://support.microsoft.com/default.aspx?scid=kb;en-
> us;832977
> Peter
> "Action speaks louder than words but not nearly as often"
> Mark Twain
>
> very random and when
> system. I simply
> is causing this
> error that is fine but I
> again not the stored
> Is there an error
> be appreciated.
>

error 17805; invalid buffer received from client

Seen this ?
http://support.microsoft.com/default.aspx?scid=kb;en-
us;832977
Peter
"Action speaks louder than words but not nearly as often"
Mark Twain

>--Original Message--
>I am trying to capture this error at its source. It is
very random and when
>using sql profiler I get too many rows that overload the
system. I simply
>want to catch the stored proc. (or T-sql statement) that
is causing this
>error. When I run sql profiler to only capture this
error that is fine but I
>in the TextData column I only get the error message,
again not the stored
>proc or statement that is causing this.
>Is there another way I should be running sql profiler?
Is there an error
>table that I can put a trigger on? ANY suggestions would
be appreciated.
>Thanks.
>.
>
yes, but I did not notice the link to the sp_blocker_pss80 before. This
still gives me too much information (and will quickly fill up my hard drive)
when I just want to capture the event that is causing this. I will double
check but I'm pretty sure we are not using the utilities that are mentioned
in those articles.
Thanks anyway for you help.
"Peter The Spate" wrote:

> Seen this ?
> http://support.microsoft.com/default.aspx?scid=kb;en-
> us;832977
> Peter
> "Action speaks louder than words but not nearly as often"
> Mark Twain
>
> very random and when
> system. I simply
> is causing this
> error that is fine but I
> again not the stored
> Is there an error
> be appreciated.
>
sql

Error 17805 Invalid buffer received from Client when executing stored Procedure

Hello,
I am receiving this error when I try to execute a Stored Procedure in
SQL Server 2000 using SYBASE dblib.
I have been able to connect to connect to SQL Server from Unix, but
when I try to execute a Stored Procedure via dblib, I get the error:
"Error 17805 Invalid buffer received from Client"
My Stored Procedure does not receive parameters, so I don't know what
is happening.
If I execute a simple SQL Statement, it works fine
I have a SQL Server 2000 running SP 4.
anyone can help?
Thank you in advanced
Jose Manuel
Jose Manuel wrote:
> Hello,
> I am receiving this error when I try to execute a Stored Procedure in
> SQL Server 2000 using SYBASE dblib.
> I have been able to connect to connect to SQL Server from Unix, but
> when I try to execute a Stored Procedure via dblib, I get the error:
> "Error 17805 Invalid buffer received from Client"
> My Stored Procedure does not receive parameters, so I don't know what
> is happening.
> If I execute a simple SQL Statement, it works fine
> I have a SQL Server 2000 running SP 4.
> anyone can help?
> Thank you in advanced
> Jose Manuel
Just curious: Why are you executing SQL on SQL Server 2000 usin the
Sybase dbLib instead of a SQL Server client library?
David Gugick
Imceda Software
www.imceda.com
|||Jose Manuel,
I am having exactlly the same problem as you had.
Could you please tell me how did you solve it?
Thanks
creo que voy varios pasos atras de ti. ojal me puedas ayudar. tengo el
mismo problema.
te ha contactado alguien ?
lo pudiste resolver?
gracias.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

Error 17805

Error 17805 Severity 20 State 3 Invalid Buffer received
from client, logged in SQL Server (2K) Log.
Please help.Hi Allan,
I have SQL Server 2K with Service Pack 3 running on WIN
2K Advanced Server Plus Service Pack 3. The server is
accessed by clients over the internet.(Database engine
for an e-commerce site.)
The Error 17805 Severity 20 State 3 invalid buffer
recieved from client suggest the client is sending a
corrupt packet to the SQL server(only a guess).
Please help.
Regards
>--Original Message--
>I have no idea when you are seeing this as you do not
say but if it is after
>trying to pass data to SQL Server through a client app
then make sure that
>things like parameter definitions to stored procs etc
are the correct type
>i.e
>varchar not nvarchar etc etc
>
>
>--
>--
>Allan Mitchell (Microsoft SQL Server MVP)
>MCSE,MCDBA
>www.SQLDTS.com
>I support PASS - the definitive, global community
>for SQL Server professionals - http://www.sqlpass.org
>
>"Olutimi" <Olutimi@.hotmail.com> wrote in message
>news:09c001c366f6$c95ed850$a401280a@.phx.gbl...
>> Error 17805 Severity 20 State 3 Invalid Buffer received
>> from client, logged in SQL Server (2K) Log.
>> Please help.
>
>.
>|||You could also try making sure the clients are communicating through the
same API. Where I have seen mention of this error before is as I said in
command parameter (ADO) datatype mismatches
--
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Olutimi" <olutimi@.hotmail.com> wrote in message
news:0a0801c366fc$f930e9f0$a401280a@.phx.gbl...
> Hi Allan,
> I have SQL Server 2K with Service Pack 3 running on WIN
> 2K Advanced Server Plus Service Pack 3. The server is
> accessed by clients over the internet.(Database engine
> for an e-commerce site.)
> The Error 17805 Severity 20 State 3 invalid buffer
> recieved from client suggest the client is sending a
> corrupt packet to the SQL server(only a guess).
> Please help.
> Regards
>
> >--Original Message--
> >I have no idea when you are seeing this as you do not
> say but if it is after
> >trying to pass data to SQL Server through a client app
> then make sure that
> >things like parameter definitions to stored procs etc
> are the correct type
> >i.e
> >
> >varchar not nvarchar etc etc
> >
> >
> >
> >
> >--
> >
> >--
> >Allan Mitchell (Microsoft SQL Server MVP)
> >MCSE,MCDBA
> >www.SQLDTS.com
> >I support PASS - the definitive, global community
> >for SQL Server professionals - http://www.sqlpass.org
> >
> >
> >
> >"Olutimi" <Olutimi@.hotmail.com> wrote in message
> >news:09c001c366f6$c95ed850$a401280a@.phx.gbl...
> >> Error 17805 Severity 20 State 3 Invalid Buffer received
> >> from client, logged in SQL Server (2K) Log.
> >> Please help.
> >
> >
> >.
> >

Error 1222 Lock request

I received the Error 1222 lock request time out period
when trying to open SQL Server Current Activity folder
under the Management folder to display locks.
This was caused by several locks.
This made it very difficult to resolve the locks without
the GUI.
What would cause the SQL Server GUI to be unable to
display the locks?
Thank You,
Mickey Autry
mautry@.ev1.netThat's know to happen when you have a lot of locks. You can
use Query Analyzer to execute sql statments and system
stored procedures to view the same info you look at in the
Current Activity part of Enterprise Manager. Check books
online for more information on sp_lock, sp_who, sp_who2 and
the sysprocesses table.
-Sue
On Tue, 23 Sep 2003 15:41:17 -0700, "Mickey"
<mautry@.ev1.net> wrote:
>I received the Error 1222 lock request time out period
>when trying to open SQL Server Current Activity folder
>under the Management folder to display locks.
>This was caused by several locks.
>This made it very difficult to resolve the locks without
>the GUI.
>What would cause the SQL Server GUI to be unable to
>display the locks?
>Thank You,
>Mickey Autry
>mautry@.ev1.net
>