error 1722 starting sqlserveragent

(this is a repost, the original post was mistakenly posted to the odbc
group)
Hello all,
I have a nightly job which runs under the SQLServerAgent service on my
SQLServer2000 database. Someone mentioned that the jobs did not run
last night, so I logged in to the server to see why, and I noticed that
the SQLServerAgent service was not running, which seemed like something
that would prevent jobs under it from being executed.
However, when I try to right-click/Start the SQL Server Agent i get the
following error:
An error 1722 - (The RPC server is unavailable) occurred while
performing this service operation on the SQLServerAgent service.
But that's all it says. I've looked in the SQL Server Agent logs, as
well as the Windows Event View application logs, and no further
information is provided in either location.
Can anyone tell me what kinds of things might cause this error? I'm not
even sure where to begin looking.
Thanks
JasonMy guess (only a guess, though) is that you aren't sitting on the SQL Server
machine doing this. So
you are using EM remotely to start the service and something goes bad in the
remote communications
to start the service. First step I'd try is to login locally on the machine
(possibly using Remote
Desktop) and start the service using the Services Applet.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"jason" <iaesun@.yahoo.com> wrote in message
news:1132076344.251481.299800@.g14g2000cwa.googlegroups.com...
> (this is a repost, the original post was mistakenly posted to the odbc
> group)
> Hello all,
> I have a nightly job which runs under the SQLServerAgent service on my
> SQLServer2000 database. Someone mentioned that the jobs did not run
> last night, so I logged in to the server to see why, and I noticed that
> the SQLServerAgent service was not running, which seemed like something
> that would prevent jobs under it from being executed.
> However, when I try to right-click/Start the SQL Server Agent i get the
> following error:
> An error 1722 - (The RPC server is unavailable) occurred while
> performing this service operation on the SQLServerAgent service.
> But that's all it says. I've looked in the SQL Server Agent logs, as
> well as the Windows Event View application logs, and no further
> information is provided in either location.
> Can anyone tell me what kinds of things might cause this error? I'm not
> even sure where to begin looking.
> Thanks
> Jason
>|||that was indeed the problem. thanks a lot Tibor
jason

Error 16954

Hello.
What maybe the reason of error 16954: "Executing SQL Directly; no
cursor". I have SQL 2000 SP3, application runs from client machine. What
elements can affect this error?
bye...
__ __
|__\\ | || |_// / \\ \_// FreeBSD: The Power To Serve
|__// |__|| | \\ \__// / \\ +--+
+[ http://bukox.prv.pl ][ http://total.bukox.dmkproject.pl ]+Hi
Does this werror occur every time, or only now and then?
What code is being executed?
Regards
Mike
"[BuKoX]" wrote:

> Hello.
> What maybe the reason of error 16954: "Executing SQL Directly; no
> cursor". I have SQL 2000 SP3, application runs from client machine. What
> elements can affect this error?
> bye...
> --
> __ __
> |__\\ | || |_// / \\ \_// FreeBSD: The Power To Serve
> |__// |__|| | \\ \__// / \\ +--+
> +[ http://bukox.prv.pl ][ http://total.bukox.dmkproject.pl ]+
>|||Mike Epprecht (SQL MVP) wrote:

> Does this werror occur every time, or only now and then?
> What code is being executed?
This error occured as long as application is running and queries are
executed (every queries). Application connect db through MDAC.
bye...
__ __
|__\\ | || |_// / \\ \_// FreeBSD: The Power To Serve
|__// |__|| | \\ \__// / \\ +--+
+[ http://bukox.prv.pl ][ http://total.bukox.dmkproject.pl ]+|||does your SQLServer crash (or very slow) after this?
any other application(s) able to connect and run a query on this server
after that?

Error 16954

Hello.
What maybe the reason of error 16954: "Executing SQL Directly; no
cursor". I have SQL 2000 SP3, application runs from client machine. What
elements can affect this error?
bye...
--
__ __
|__\\ | || |_// / \\ \_// FreeBSD: The Power To Serve
|__// |__|| | \\ \__// / \\ +--+
+[ http://bukox.prv.pl ][ http://total.bukox.dmkproject.pl ]+Hi
Does this werror occur every time, or only now and then?
What code is being executed?
Regards
Mike
"[BuKoX]" wrote:
> Hello.
> What maybe the reason of error 16954: "Executing SQL Directly; no
> cursor". I have SQL 2000 SP3, application runs from client machine. What
> elements can affect this error?
> bye...
> --
> __ __
> |__\\ | || |_// / \\ \_// FreeBSD: The Power To Serve
> |__// |__|| | \\ \__// / \\ +--+
> +[ http://bukox.prv.pl ][ http://total.bukox.dmkproject.pl ]+
>|||Mike Epprecht (SQL MVP) wrote:
> Does this werror occur every time, or only now and then?
> What code is being executed?
This error occured as long as application is running and queries are
executed (every queries). Application connect db through MDAC.
bye...
--
__ __
|__\\ | || |_// / \\ \_// FreeBSD: The Power To Serve
|__// |__|| | \\ \__// / \\ +--+
+[ http://bukox.prv.pl ][ http://total.bukox.dmkproject.pl ]+|||does your SQLServer crash (or very slow) after this?
any other application(s) able to connect and run a query on this server
after that?

Error 16954

Hello.
What maybe the reason of error 16954: "Executing SQL Directly; no
cursor". I have SQL 2000 SP3, application runs from client machine. What
elements can affect this error?
bye...
__ __
|__\\ | || |_// / \\ \_// FreeBSD: The Power To Serve
|__// |__|| | \\ \__// / \\ +--+
+[ http://bukox.prv.pl ][ http://total.bukox.dmkproject.pl ]+
Hi
Does this werror occur every time, or only now and then?
What code is being executed?
Regards
Mike
"[BuKoX]" wrote:

> Hello.
> What maybe the reason of error 16954: "Executing SQL Directly; no
> cursor". I have SQL 2000 SP3, application runs from client machine. What
> elements can affect this error?
> bye...
> --
> __ __
> |__\\ | || |_// / \\ \_// FreeBSD: The Power To Serve
> |__// |__|| | \\ \__// / \\ +--+
> +[ http://bukox.prv.pl ][ http://total.bukox.dmkproject.pl ]+
>
|||Mike Epprecht (SQL MVP) wrote:

> Does this werror occur every time, or only now and then?
> What code is being executed?
This error occured as long as application is running and queries are
executed (every queries). Application connect db through MDAC.
bye...
__ __
|__\\ | || |_// / \\ \_// FreeBSD: The Power To Serve
|__// |__|| | \\ \__// / \\ +--+
+[ http://bukox.prv.pl ][ http://total.bukox.dmkproject.pl ]+
|||does your SQLServer crash (or very slow) after this?
any other application(s) able to connect and run a query on this server
after that?

error - microsoft jet database engine can not find the object tabble_name

Hi,
I try to export my data from sql server to excel, when i preview the
data, it all runs fine. When i run export, it prompt me this error. How can
i ensure this object is exist? and how do i verify this error? In the
enterprise manager, i can view the records for my table.
--
Thank you very much!
Best regards,
FlorenceHi Forence,
Florence Lee wrote:
> I try to export my data from sql server to excel, when i preview the
> data, it all runs fine. When i run export, it prompt me this error. How can
> i ensure this object is exist? and how do i verify this error? In the
> enterprise manager, i can view the records for my table.
If you can use the Enterprise Manager to view your table records, you
may want to consider just using the EM to export your table to a comma
delimited file. You should be able to do this by using the "export"
task from within the Enterprise Manager, using the DTS wizard. Once you
have the comma delimited file, you can then use Excel to import that.
It's a workaround, but a workaround that should work for you. :)
Hope this helps.|||Hi,
I try to use the dts to direct export to excel, come out this error why?
I dun want to export to text files then just back to excel.
--
Thank you very much!
Best regards,
Florence
"William R. Lorenz" <wrl@.express.org> wrote in message
news:eFoSj5K6EHA.3944@.TK2MSFTNGP12.phx.gbl...
> Hi Forence,
> Florence Lee wrote:
> > I try to export my data from sql server to excel, when i preview
the
> > data, it all runs fine. When i run export, it prompt me this error. How
can
> > i ensure this object is exist? and how do i verify this error? In the
> > enterprise manager, i can view the records for my table.
> If you can use the Enterprise Manager to view your table records, you
> may want to consider just using the EM to export your table to a comma
> delimited file. You should be able to do this by using the "export"
> task from within the Enterprise Manager, using the DTS wizard. Once you
> have the comma delimited file, you can then use Excel to import that.
> It's a workaround, but a workaround that should work for you. :)
> Hope this helps.

error - microsoft jet database engine can not find the object tabble_name

Hi,
I try to export my data from sql server to excel, when i preview the
data, it all runs fine. When i run export, it prompt me this error. How can
i ensure this object is exist? and how do i verify this error? In the
enterprise manager, i can view the records for my table.
Thank you very much!
Best regards,
Florence
Hi,
I try to use the dts to direct export to excel, come out this error why?
I dun want to export to text files then just back to excel.
Thank you very much!
Best regards,
Florence
"William R. Lorenz" <wrl@.express.org> wrote in message
news:eFoSj5K6EHA.3944@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> Hi Forence,
> Florence Lee wrote:
the[vbcol=seagreen]
can
> If you can use the Enterprise Manager to view your table records, you
> may want to consider just using the EM to export your table to a comma
> delimited file. You should be able to do this by using the "export"
> task from within the Enterprise Manager, using the DTS wizard. Once you
> have the comma delimited file, you can then use Excel to import that.
> It's a workaround, but a workaround that should work for you.
> Hope this helps.

Erro trapping question

I have a batch file that runs SQL Server scripts using commands like:

OSQL -Umyname -Pmypassword -iScript_01.sql -w200 -e -n
>>Consolidation.log

Script_01.sql will contain statements like:
Update SASI.AACT set schoolnum='071' where schoolnum in ('000',' ')
update SASI.AATD set schoolnum='071' where schoolnum in ('000',' ')
update SASI.AATP set schoolnum='071' where schoolnum in ('000',' ')
update SASI.ACHS set schoolnum='071' where schoolnum in ('000',' ')
update SASI.ACLS set schoolnum='071' where schoolnum in ('000',' ')

If one of those tables should not exist, how could I have it continue,
but hopefully the log would have a reference to the error?

I am experimenting, but I am unsuccessfull with something like:
BEGIN TRAN
select count(*) from sasi.aact --this could be an update
statement
if @.@.ERROR =208 GOTO err_handle
select count(*) from sasi.astu
if @.@.ERROR <> 0 GOTO err_handle
select count(*) from sasi.astu
if @.@.ERROR <> 0 GOTO err_handle
select count(*) from sasi.astu
if @.@.ERROR <> 0 GOTO err_handle
err_handle:
return
commit Tran<OakRogbak_erPine@.yahoo.com> wrote in message
news:13fdc9b4.0410140645.305d53d3@.posting.google.c om...
>I have a batch file that runs SQL Server scripts using commands like:
> OSQL -Umyname -Pmypassword -iScript_01.sql -w200 -e -n
>>>Consolidation.log
> Script_01.sql will contain statements like:
> Update SASI.AACT set schoolnum='071' where schoolnum in ('000',' ')
> update SASI.AATD set schoolnum='071' where schoolnum in ('000',' ')
> update SASI.AATP set schoolnum='071' where schoolnum in ('000',' ')
> update SASI.ACHS set schoolnum='071' where schoolnum in ('000',' ')
> update SASI.ACLS set schoolnum='071' where schoolnum in ('000',' ')
> If one of those tables should not exist, how could I have it continue,
> but hopefully the log would have a reference to the error?
> I am experimenting, but I am unsuccessfull with something like:
> BEGIN TRAN
> select count(*) from sasi.aact --this could be an update
> statement
> if @.@.ERROR =208 GOTO err_handle
> select count(*) from sasi.astu
> if @.@.ERROR <> 0 GOTO err_handle
> select count(*) from sasi.astu
> if @.@.ERROR <> 0 GOTO err_handle
> select count(*) from sasi.astu
> if @.@.ERROR <> 0 GOTO err_handle
> err_handle:
> return
> commit Tran

Error handling is rather awkward in MSSQL:

http://www.sommarskog.se/error-handling-I.html
http://www.sommarskog.se/error-handling-II.html

In your case, the easiest thing is probably to avoid the error by checking
if the table exists before trying to query it:

if object_id('sasi.aact') is not null and
objectproperty(object_id('sasi.aact'), 'IsTable') = 1
begin
... -- do something here
end
else
begin
... -- log to an error table
end

Simon

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
>
>