ArcServ and SQl Server 2000

Hi,

I am trying to create a backup agent for a SQl Server. I have given the information for the following: instance, AUTHENTICATION, USERNAME, PASSWORD, CONFIRM PASSWORD.

I keep getting the error message, enter valid instance, even though i am entering in the instance.

any ideas?

Is this a named instance? Do you have any special characters like dashes in the server name?

-Sue

|||Problem solved ? If yes, post how you solved it, or if the hint from Sue helped you′.

Jens K. Suessmeyer

http://www.sqlserver2005.de

sql

Application

Does anyone know of an agent/application that runs on SQL Server that will
allow me to do some sort of process billing? Used to be quite common in the
old days, to bill back users for their usage. Since I have a hosted
application, I want to bill for CPU usage.
I know that I can use SQL Profiler, but was hoping for an agent or service
that would allow me to bill based on DB or User.
See my post in the microsoft.public.sqlserver.server thread.
----
-
Need SQL Server Examples check out my website
http://www.geocities.com/sqlserverexamples
"Kevin Antel" <kevina@.cqlcorp.com> wrote in message
news:%23IBOkgH3EHA.1192@.tk2msftngp13.phx.gbl...
> Does anyone know of an agent/application that runs on SQL Server that will
> allow me to do some sort of process billing? Used to be quite common in
the
> old days, to bill back users for their usage. Since I have a hosted
> application, I want to bill for CPU usage.
> I know that I can use SQL Profiler, but was hoping for an agent or service
> that would allow me to bill based on DB or User.
>

Application

Does anyone know of an agent/application that runs on SQL Server that will
allow me to do some sort of process billing? Used to be quite common in the
old days, to bill back users for their usage. Since I have a hosted
application, I want to bill for CPU usage.
I know that I can use SQL Profiler, but was hoping for an agent or service
that would allow me to bill based on DB or User.I would set up a server side trace that logged the the events that you need
to a sql server table. Here is an article I wrote on the subject that
might help you get started with server side tracing:
http://www.dbazine.com/larsen6.shtml
--
----
----
-
Need SQL Server Examples check out my website
http://www.geocities.com/sqlserverexamples
"Kevin Antel" <kevina@.cqlcorp.com> wrote in message
news:%23M5QpgH3EHA.1524@.TK2MSFTNGP09.phx.gbl...
> Does anyone know of an agent/application that runs on SQL Server that will
> allow me to do some sort of process billing? Used to be quite common in
the
> old days, to bill back users for their usage. Since I have a hosted
> application, I want to bill for CPU usage.
> I know that I can use SQL Profiler, but was hoping for an agent or service
> that would allow me to bill based on DB or User.
>

Application

Does anyone know of an agent/application that runs on SQL Server that will
allow me to do some sort of process billing? Used to be quite common in the
old days, to bill back users for their usage. Since I have a hosted
application, I want to bill for CPU usage.
I know that I can use SQL Profiler, but was hoping for an agent or service
that would allow me to bill based on DB or User.
I would set up a server side trace that logged the the events that you need
to a sql server table. Here is an article I wrote on the subject that
might help you get started with server side tracing:
http://www.dbazine.com/larsen6.shtml
----
-
Need SQL Server Examples check out my website
http://www.geocities.com/sqlserverexamples
"Kevin Antel" <kevina@.cqlcorp.com> wrote in message
news:%23M5QpgH3EHA.1524@.TK2MSFTNGP09.phx.gbl...
> Does anyone know of an agent/application that runs on SQL Server that will
> allow me to do some sort of process billing? Used to be quite common in
the
> old days, to bill back users for their usage. Since I have a hosted
> application, I want to bill for CPU usage.
> I know that I can use SQL Profiler, but was hoping for an agent or service
> that would allow me to bill based on DB or User.
>

Anyway to track SQL Server Agent error messages

We are in on SQL2000 and our SQL Server Agent started to receive errors for
Mail Profile not available. It wasn't until we looked at the agent error log
we saw the problem.
Is there any way to report the SQL Server Agent Warnings/Errors via email or
alert as a pro-active stance?
JTS
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200611/1There is product called ProIT 4 (I work for the company and wrote the SQL
monitoring function in it) that will do it. ProIT is a server & network
monitoring software package. In additionally to writting it, we use it
internally and have customers using it to monitor both the sql error log and
the system eventlogs for SQL Agent job failures and SQL errors.
"jsheldon via SQLMonster.com" wrote:
> We are in on SQL2000 and our SQL Server Agent started to receive errors for
> Mail Profile not available. It wasn't until we looked at the agent error log
> we saw the problem.
> Is there any way to report the SQL Server Agent Warnings/Errors via email or
> alert as a pro-active stance?
> JTS
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200611/1
>|||Netmon what is the web address?
Thanks
Netmon wrote:
>There is product called ProIT 4 (I work for the company and wrote the SQL
>monitoring function in it) that will do it. ProIT is a server & network
>monitoring software package. In additionally to writting it, we use it
>internally and have customers using it to monitor both the sql error log and
>the system eventlogs for SQL Agent job failures and SQL errors.
>> We are in on SQL2000 and our SQL Server Agent started to receive errors for
>> Mail Profile not available. It wasn't until we looked at the agent error log
>[quoted text clipped - 4 lines]
>> JTS
--
Message posted via http://www.sqlmonster.com

Anyway to track SQL Server Agent error messages

We are in on SQL2000 and our SQL Server Agent started to receive errors for
Mail Profile not available. It wasn't until we looked at the agent error log
we saw the problem.
Is there any way to report the SQL Server Agent Warnings/Errors via email or
alert as a pro-active stance?
JTS
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums.aspx/sql-server/200611/1
There is product called ProIT 4 (I work for the company and wrote the SQL
monitoring function in it) that will do it. ProIT is a server & network
monitoring software package. In additionally to writting it, we use it
internally and have customers using it to monitor both the sql error log and
the system eventlogs for SQL Agent job failures and SQL errors.
"jsheldon via droptable.com" wrote:

> We are in on SQL2000 and our SQL Server Agent started to receive errors for
> Mail Profile not available. It wasn't until we looked at the agent error log
> we saw the problem.
> Is there any way to report the SQL Server Agent Warnings/Errors via email or
> alert as a pro-active stance?
> JTS
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums.aspx/sql-server/200611/1
>
|||Netmon what is the web address?
Thanks
Netmon wrote:[vbcol=seagreen]
>There is product called ProIT 4 (I work for the company and wrote the SQL
>monitoring function in it) that will do it. ProIT is a server & network
>monitoring software package. In additionally to writting it, we use it
>internally and have customers using it to monitor both the sql error log and
>the system eventlogs for SQL Agent job failures and SQL errors.
>[quoted text clipped - 4 lines]
Message posted via http://www.droptable.com

Anyway to track SQL Server Agent error messages

We are in on SQL2000 and our SQL Server Agent started to receive errors for
Mail Profile not available. It wasn't until we looked at the agent error lo
g
we saw the problem.
Is there any way to report the SQL Server Agent Warnings/Errors via email or
alert as a pro-active stance?
JTS
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200611/1There is product called ProIT 4 (I work for the company and wrote the SQL
monitoring function in it) that will do it. ProIT is a server & network
monitoring software package. In additionally to writting it, we use it
internally and have customers using it to monitor both the sql error log and
the system eventlogs for SQL Agent job failures and SQL errors.
"jsheldon via droptable.com" wrote:

> We are in on SQL2000 and our SQL Server Agent started to receive errors fo
r
> Mail Profile not available. It wasn't until we looked at the agent error
log
> we saw the problem.
> Is there any way to report the SQL Server Agent Warnings/Errors via email
or
> alert as a pro-active stance?
> JTS
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200611/1
>|||Netmon what is the web address?
Thanks
Netmon wrote:[vbcol=seagreen]
>There is product called ProIT 4 (I work for the company and wrote the SQL
>monitoring function in it) that will do it. ProIT is a server & network
>monitoring software package. In additionally to writting it, we use it
>internally and have customers using it to monitor both the sql error log an
d
>the system eventlogs for SQL Agent job failures and SQL errors.
>
>[quoted text clipped - 4 lines]
Message posted via http://www.droptable.com