No Mail icon in control panel?

This is too weird.
I'm following
http://support.microsoft.com/Default.../wct091301.asp
to troubleshoot why SQLAgentMail does not send notifications on our SQL 2000
server. Looks like I need to logon as the startup user account to get mail
profile configured. But after I logon the SQL server using the startup
domain account that runs both the server and the agent, I don't see any Mail
icon in the control panel. Logging on as other users does not have this
problem.
Any ideas?
Bing
Have you considered other alternatives?
http://www.aspfaq.com/2403
http://www.aspfaq.com/
(Reverse address to reply.)
"bing" <bing@.discussions.microsoft.com> wrote in message
news:3B45529C-D273-4B72-9DEA-B01E13BC6F2C@.microsoft.com...
> This is too weird.
> I'm following
>
http://support.microsoft.com/Default.../wct091301.asp
> to troubleshoot why SQLAgentMail does not send notifications on our SQL
2000
> server. Looks like I need to logon as the startup user account to get
mail
> profile configured. But after I logon the SQL server using the startup
> domain account that runs both the server and the agent, I don't see any
Mail
> icon in the control panel. Logging on as other users does not have this
> problem.
> Any ideas?
> Bing
|||That indicates that mail is not configured for the service
account you are logging in as. Follow the steps in the
following:
INF: How to Configure SQL Mail
http://support.microsoft.com/?id=263556
-Sue
On Tue, 18 Jan 2005 14:57:02 -0800, "bing"
<bing@.discussions.microsoft.com> wrote:

>This is too weird.
>I'm following
>http://support.microsoft.com/Default.../wct091301.asp
>to troubleshoot why SQLAgentMail does not send notifications on our SQL 2000
>server. Looks like I need to logon as the startup user account to get mail
>profile configured. But after I logon the SQL server using the startup
>domain account that runs both the server and the agent, I don't see any Mail
>icon in the control panel. Logging on as other users does not have this
>problem.
>Any ideas?
>Bing
|||Yup, you said it right. Looks like Microsoft office outlook was upgraded
from 2000 to 2003 on our SQL server at some point. But the mail
configuration for the SQL service account was not maintained at the same
time. I just went into outlook 2003 and get mail configured for the service
account. SQLAgentMail works fine now. Thanks all who replied.
Bing
"Sue Hoegemeier" wrote:

> That indicates that mail is not configured for the service
> account you are logging in as. Follow the steps in the
> following:
> INF: How to Configure SQL Mail
> http://support.microsoft.com/?id=263556
> -Sue
> On Tue, 18 Jan 2005 14:57:02 -0800, "bing"
> <bing@.discussions.microsoft.com> wrote:
>
>
|||Glad it was that easy to sort out. In my experience, it usually involves a
lot more hair- and teeth-pulling. :-)
http://www.aspfaq.com/
(Reverse address to reply.)
"bing" <bing@.discussions.microsoft.com> wrote in message
news:382E13A2-F995-4FE0-86F4-124CA6BB3210@.microsoft.com...
> Yup, you said it right. Looks like Microsoft office outlook was upgraded
> from 2000 to 2003 on our SQL server at some point. But the mail
> configuration for the SQL service account was not maintained at the same
> time. I just went into outlook 2003 and get mail configured for the
service
> account. SQLAgentMail works fine now. Thanks all who replied.
>

No Mail icon in control panel?

This is too weird.
I'm following
http://support.microsoft.com/Defaul...1/wct091301.asp
to troubleshoot why SQLAgentMail does not send notifications on our SQL 2000
server. Looks like I need to logon as the startup user account to get mail
profile configured. But after I logon the SQL server using the startup
domain account that runs both the server and the agent, I don't see any Mail
icon in the control panel. Logging on as other users does not have this
problem.
Any ideas?
BingHave you considered other alternatives?
http://www.aspfaq.com/2403
http://www.aspfaq.com/
(Reverse address to reply.)
"bing" <bing@.discussions.microsoft.com> wrote in message
news:3B45529C-D273-4B72-9DEA-B01E13BC6F2C@.microsoft.com...
> This is too weird.
> I'm following
>
http://support.microsoft.com/Defaul...1/wct091301.asp
> to troubleshoot why SQLAgentMail does not send notifications on our SQL
2000
> server. Looks like I need to logon as the startup user account to get
mail
> profile configured. But after I logon the SQL server using the startup
> domain account that runs both the server and the agent, I don't see any
Mail
> icon in the control panel. Logging on as other users does not have this
> problem.
> Any ideas?
> Bing|||That indicates that mail is not configured for the service
account you are logging in as. Follow the steps in the
following:
INF: How to Configure SQL Mail
http://support.microsoft.com/?id=263556
-Sue
On Tue, 18 Jan 2005 14:57:02 -0800, "bing"
<bing@.discussions.microsoft.com> wrote:

>This is too weird.
>I'm following
>http://support.microsoft.com/Defaul...1/wct091301.asp
>to troubleshoot why SQLAgentMail does not send notifications on our SQL 200
0
>server. Looks like I need to logon as the startup user account to get mail
>profile configured. But after I logon the SQL server using the startup
>domain account that runs both the server and the agent, I don't see any Mai
l
>icon in the control panel. Logging on as other users does not have this
>problem.
>Any ideas?
>Bing|||Yup, you said it right. Looks like Microsoft office outlook was upgraded
from 2000 to 2003 on our SQL server at some point. But the mail
configuration for the SQL service account was not maintained at the same
time. I just went into outlook 2003 and get mail configured for the service
account. SQLAgentMail works fine now. Thanks all who replied.
Bing
"Sue Hoegemeier" wrote:

> That indicates that mail is not configured for the service
> account you are logging in as. Follow the steps in the
> following:
> INF: How to Configure SQL Mail
> http://support.microsoft.com/?id=263556
> -Sue
> On Tue, 18 Jan 2005 14:57:02 -0800, "bing"
> <bing@.discussions.microsoft.com> wrote:
>
>|||Glad it was that easy to sort out. In my experience, it usually involves a
lot more hair- and teeth-pulling. :-)
http://www.aspfaq.com/
(Reverse address to reply.)
"bing" <bing@.discussions.microsoft.com> wrote in message
news:382E13A2-F995-4FE0-86F4-124CA6BB3210@.microsoft.com...
> Yup, you said it right. Looks like Microsoft office outlook was upgraded
> from 2000 to 2003 on our SQL server at some point. But the mail
> configuration for the SQL service account was not maintained at the same
> time. I just went into outlook 2003 and get mail configured for the
service
> account. SQLAgentMail works fine now. Thanks all who replied.
>

No Mail icon in control panel?

This is too weird.
I'm following
http://support.microsoft.com/Default.aspx?scid=http://support.microsoft.com/servicedesks/webcasts/en/wc091301/wct091301.asp
to troubleshoot why SQLAgentMail does not send notifications on our SQL 2000
server. Looks like I need to logon as the startup user account to get mail
profile configured. But after I logon the SQL server using the startup
domain account that runs both the server and the agent, I don't see any Mail
icon in the control panel. Logging on as other users does not have this
problem.
Any ideas?
BingHave you considered other alternatives?
http://www.aspfaq.com/2403
--
http://www.aspfaq.com/
(Reverse address to reply.)
"bing" <bing@.discussions.microsoft.com> wrote in message
news:3B45529C-D273-4B72-9DEA-B01E13BC6F2C@.microsoft.com...
> This is too weird.
> I'm following
>
http://support.microsoft.com/Default.aspx?scid=http://support.microsoft.com/servicedesks/webcasts/en/wc091301/wct091301.asp
> to troubleshoot why SQLAgentMail does not send notifications on our SQL
2000
> server. Looks like I need to logon as the startup user account to get
mail
> profile configured. But after I logon the SQL server using the startup
> domain account that runs both the server and the agent, I don't see any
Mail
> icon in the control panel. Logging on as other users does not have this
> problem.
> Any ideas?
> Bing|||That indicates that mail is not configured for the service
account you are logging in as. Follow the steps in the
following:
INF: How to Configure SQL Mail
http://support.microsoft.com/?id=263556
-Sue
On Tue, 18 Jan 2005 14:57:02 -0800, "bing"
<bing@.discussions.microsoft.com> wrote:
>This is too weird.
>I'm following
>http://support.microsoft.com/Default.aspx?scid=http://support.microsoft.com/servicedesks/webcasts/en/wc091301/wct091301.asp
>to troubleshoot why SQLAgentMail does not send notifications on our SQL 2000
>server. Looks like I need to logon as the startup user account to get mail
>profile configured. But after I logon the SQL server using the startup
>domain account that runs both the server and the agent, I don't see any Mail
>icon in the control panel. Logging on as other users does not have this
>problem.
>Any ideas?
>Bing|||Yup, you said it right. Looks like Microsoft office outlook was upgraded
from 2000 to 2003 on our SQL server at some point. But the mail
configuration for the SQL service account was not maintained at the same
time. I just went into outlook 2003 and get mail configured for the service
account. SQLAgentMail works fine now. Thanks all who replied.
Bing
"Sue Hoegemeier" wrote:
> That indicates that mail is not configured for the service
> account you are logging in as. Follow the steps in the
> following:
> INF: How to Configure SQL Mail
> http://support.microsoft.com/?id=263556
> -Sue
> On Tue, 18 Jan 2005 14:57:02 -0800, "bing"
> <bing@.discussions.microsoft.com> wrote:
> >This is too weird.
> >
> >I'm following
> >http://support.microsoft.com/Default.aspx?scid=http://support.microsoft.com/servicedesks/webcasts/en/wc091301/wct091301.asp
> >to troubleshoot why SQLAgentMail does not send notifications on our SQL 2000
> >server. Looks like I need to logon as the startup user account to get mail
> >profile configured. But after I logon the SQL server using the startup
> >domain account that runs both the server and the agent, I don't see any Mail
> >icon in the control panel. Logging on as other users does not have this
> >problem.
> >
> >Any ideas?
> >
> >Bing
>|||Glad it was that easy to sort out. In my experience, it usually involves a
lot more hair- and teeth-pulling. :-)
--
http://www.aspfaq.com/
(Reverse address to reply.)
"bing" <bing@.discussions.microsoft.com> wrote in message
news:382E13A2-F995-4FE0-86F4-124CA6BB3210@.microsoft.com...
> Yup, you said it right. Looks like Microsoft office outlook was upgraded
> from 2000 to 2003 on our SQL server at some point. But the mail
> configuration for the SQL service account was not maintained at the same
> time. I just went into outlook 2003 and get mail configured for the
service
> account. SQLAgentMail works fine now. Thanks all who replied.
>

No data is displayed in a Report on Win98

Hi,

I have created an OCX control in VB6.0 that contains the crystal report viewer.

On development machine (i.e. Win2K), my OCX control shows the crystal report properly. But, when I install my application on the client machine (Win98) no data is displayed in the report.

I have created the report using ADO connection and I am using 'SetDataSource' method of report object to pass the recordset to the report.

I have installed Crystal Report Application on the client machine. Through crystal report application I could see the data in the report.

Can any one help me?

With regards,
PinakinI use CrystalRyport. I want to print records in the same line in succession, how do i do

No Agent Indication

How can I tell if my SQL Server Agent is running without using the EM? The
network admins have control of the server in such a way as to not let the DBA
start or stop the service on the server. This of course does not light up
the indicator in the EM for the Agent.
Hi
If you run sp_who2 or query sysprocesses, you will see connections from
Agent. They are always there as they poll for jobs.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:D060BCE2-BE0D-493A-81FD-C0E7E18C9E15@.microsoft.com...
> How can I tell if my SQL Server Agent is running without using the EM?
> The
> network admins have control of the server in such a way as to not let the
> DBA
> start or stop the service on the server. This of course does not light up
> the indicator in the EM for the Agent.

No Agent Indication

How can I tell if my SQL Server Agent is running without using the EM? The
network admins have control of the server in such a way as to not let the DBA
start or stop the service on the server. This of course does not light up
the indicator in the EM for the Agent.Hi
If you run sp_who2 or query sysprocesses, you will see connections from
Agent. They are always there as they poll for jobs.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:D060BCE2-BE0D-493A-81FD-C0E7E18C9E15@.microsoft.com...
> How can I tell if my SQL Server Agent is running without using the EM?
> The
> network admins have control of the server in such a way as to not let the
> DBA
> start or stop the service on the server. This of course does not light up
> the indicator in the EM for the Agent.sql

No Agent Indication

How can I tell if my SQL Server Agent is running without using the EM? The
network admins have control of the server in such a way as to not let the DB
A
start or stop the service on the server. This of course does not light up
the indicator in the EM for the Agent.Hi
If you run sp_who2 or query sysprocesses, you will see connections from
Agent. They are always there as they poll for jobs.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:D060BCE2-BE0D-493A-81FD-C0E7E18C9E15@.microsoft.com...
> How can I tell if my SQL Server Agent is running without using the EM?
> The
> network admins have control of the server in such a way as to not let the
> DBA
> start or stop the service on the server. This of course does not light up
> the indicator in the EM for the Agent.

Newbie-stop request from Service Control Manager

I an trying to install MSDE2000A, but it stops every time before finishing.
I have also tried with sql server 2000, but with same problem. Anyone that
knows why? Is there something I can do about it?
Please help...

KurtHi

You don't give any error message but these may help!

http://tinyurl.com/zo7n

John

"Kurt Molland" <kjmollan@.broadpark.no> wrote in message news:<3fdf4c14$1@.news.broadpark.no>...
> I an trying to install MSDE2000A, but it stops every time before finishing.
> I have also tried with sql server 2000, but with same problem. Anyone that
> knows why? Is there something I can do about it?
> Please help...
> Kurt