Showing posts with label regarding. Show all posts
Showing posts with label regarding. Show all posts

Thursday, March 22, 2012

book recommendations: ETL

Could any one please recommend some good books on sql server 2000 ETL best
practices '
I am trying to learn some best practices regarding this subject so any white
papers, articles, web sites, books would be greatly appreciated.
TIA...sqlster,
Check out:
http://www.sqldts.com/
and
http://www.sqldts.com/default.aspx?400
HTH
Jerry
"sqlster" <nospam@.nospam.com> wrote in message
news:FF107389-91B8-4397-ABA2-903C89EEAB30@.microsoft.com...
> Could any one please recommend some good books on sql server 2000 ETL best
> practices '
> I am trying to learn some best practices regarding this subject so any
> white
> papers, articles, web sites, books would be greatly appreciated.
> TIA...|||TechNet and MSDN have articles on the subject:
SQL Server 2000 Administrator's Pocket Consultant: Importing and Exporting
Data with DTS and BCP
http://www.microsoft.com/technet/pr...s/c07ppcsq.mspx
Of course, you can find a slew of books on the technical aspects of using
SQL Server DTS specifically. However, if you are wanting to learn more about
best practices and ETL in general, then go to Barnes&Noble or Borders this
wend and browse through these.
The Data Warehouse ETL Toolkit: Practical Techniques for Extracting,
Cleaning, Conforming, and Delivering Data
by Ralph Kimball, Joe Caserta
Building the Data Warehouse
by W. H. Inmon
"sqlster" <nospam@.nospam.com> wrote in message
news:FF107389-91B8-4397-ABA2-903C89EEAB30@.microsoft.com...
> Could any one please recommend some good books on sql server 2000 ETL best
> practices '
> I am trying to learn some best practices regarding this subject so any
> white
> papers, articles, web sites, books would be greatly appreciated.
> TIA...

Sunday, March 11, 2012

Blocking Transactions

Hi Guys...

Another issue, this time regarding transactions.
It seems that blocking occurs very often when processes are being put into transactions.

For example, I have two tables, tableA and tableB.

I create a sequence container, and inside, i put in two process.
1. Execute SQL - this to insert data into tableA.
2. Data Flow Task - move data from tableA to tableB
Set the sequence container transactions to required.

When I run the package, it always get stuck at process 2.
I tried running the SP_WHO2 command, and it shows that its suspended, being blocked by id "-2".
Any idea to solve this?

Thanks.

Cheers,

Ryan TanSince the transaction is active when #2 is running, #1 probably gets X locks that prevent #2 from getting data. Looks like you either need to commit the transaction after #1 is done, or change the connection manager to allow a less severe isolation level.

Wednesday, March 7, 2012

Block Port 1433 on windows 2000 server

Hi
I have a question regarding the SQL Server(SQL Server 7) port 1433.
Some body is trying to hack into our Windows 2000 server through port
1433. Is there a way i can close this port? I tried using a tool
called Ipsecpol.exe ( Internet Protocol Security Policies Tool). But
when we run netstat, it still looks like they are able to connect to
the server using port 1433. Has anyone come across this problem? I
would appreciate it very much if somebody could send in any
suggestions regarding this.
Thanks,
AnnIPSec can be used or a Personal Firewall.
813878 How to Block Specific Network Protocols and Ports by Using IPSec
http://support.microsoft.com/?id=813878
If this computer is on the internet it should be behind a firewall. By
default a firewall will block all incoming traffic, unless you specifically
allow it.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||The issue isn't really "closing ports" - it's blocking access to them.
Are you using ISA? If not, you need a firewall. I'd pick up a cheap and
cheerful firewall appliance - I like the NetGear FR114P.
Ann wrote:
> Hi
> I have a question regarding the SQL Server(SQL Server 7) port 1433.
> Some body is trying to hack into our Windows 2000 server through port
> 1433. Is there a way i can close this port? I tried using a tool
> called Ipsecpol.exe ( Internet Protocol Security Policies Tool). But
> when we run netstat, it still looks like they are able to connect to
> the server using port 1433. Has anyone come across this problem? I
> would appreciate it very much if somebody could send in any
> suggestions regarding this.
> Thanks,
> Ann|||On 12 Jul 2004 14:56:40 -0700, nsajus@.yahoo.com (Ann) wrote:

>I have a question regarding the SQL Server(SQL Server 7) port 1433.
>Some body is trying to hack into our Windows 2000 server through port
>1433. Is there a way i can close this port?
Don't open it in your firewall. Or any other port you don't want
accessed.
Jeff|||Hi
This sounds like your SQL Server is not behind the firewall or as the others
have suggested the firewall is not configured correctly.
How do you know someone is trying to access the SQL Server? If this is being
reported from the firewall then it may be because it is dropping it!!
If you are not using windows only authentication, then make sure that you
have a strong sa password.You could run the Microsoft Baseline Security
Analyzer http://www.microsoft.com/technet/se...s/mbsahome.mspx to
make sure it is configured sensibly. I would also look at running IIS
lockdown on any webserver
http://www.microsoft.com/security/g...odtech/IIS.mspx
Check out the advice on:
http://www.microsoft.com/sql/techin...t.aspx?tabid=24
John
"Ann" <nsajus@.yahoo.com> wrote in message
news:cca0635f.0407121356.55ef3590@.posting.google.com...
> Hi
> I have a question regarding the SQL Server(SQL Server 7) port 1433.
> Some body is trying to hack into our Windows 2000 server through port
> 1433. Is there a way i can close this port? I tried using a tool
> called Ipsecpol.exe ( Internet Protocol Security Policies Tool). But
> when we run netstat, it still looks like they are able to connect to
> the server using port 1433. Has anyone come across this problem? I
> would appreciate it very much if somebody could send in any
> suggestions regarding this.
> Thanks,
> Ann|||Hi Ann.
The easy one is to buy a firewall box from your local computer store
or If you are using a windows server 2003 use the firewall insite
windows server 2003 (ICF). Click on the link to see how to enable it.
http://www.microsoft.com/resources/...le_firewall.asp
After you either buy a firewall box or enabled ICF on your server then
try this link:
- www.grc.com
- Click ShieldsUp
- Roll down to HOT SPOT and click again shieldsUp
- click proceed
- write 1433 in the text field and click "User Specified Custom Port
Probe"
- See if its stealth.
- You can then click common ports to see if the common ports are
stealth or click all service ports to see if other ports are
open...(The best is if every one are green and not red)
Hope you understand this and solve this problem..
Danni, MCP[vbcol=seagreen]|||Sorry. i forgot it was a Windows 2000 server. There is not a ICF.
You could also get a software firewall like ZoneAlarm? If the server
is in a big firm it mabye better with a firewall box.
Danni|||On 13 Jul 2004 01:22:45 -0700, dev@.euro-consult.dk wrote:

>Sorry. i forgot it was a Windows 2000 server. There is not a ICF.
>You could also get a software firewall like ZoneAlarm?
For home machines, that is fine, as would be the Sygate product. For
anything used 'in anger' this is a risky solution.

>If the server is in a big firm it mabye better with a firewall box.
In any situation where the data and system availability/integrity is
valuable, a hardware firewall solution is the only way to go.

Block Port 1433 on windows 2000 server

Hi
I have a question regarding the SQL Server(SQL Server 7) port 1433.
Some body is trying to hack into our Windows 2000 server through port
1433. Is there a way i can close this port? I tried using a tool
called Ipsecpol.exe ( Internet Protocol Security Policies Tool). But
when we run netstat, it still looks like they are able to connect to
the server using port 1433. Has anyone come across this problem? I
would appreciate it very much if somebody could send in any
suggestions regarding this.
Thanks,
Ann
IPSec can be used or a Personal Firewall.
813878 How to Block Specific Network Protocols and Ports by Using IPSec
http://support.microsoft.com/?id=813878
If this computer is on the internet it should be behind a firewall. By
default a firewall will block all incoming traffic, unless you specifically
allow it.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||The issue isn't really "closing ports" - it's blocking access to them.
Are you using ISA? If not, you need a firewall. I'd pick up a cheap and
cheerful firewall appliance - I like the NetGear FR114P.
Ann wrote:
> Hi
> I have a question regarding the SQL Server(SQL Server 7) port 1433.
> Some body is trying to hack into our Windows 2000 server through port
> 1433. Is there a way i can close this port? I tried using a tool
> called Ipsecpol.exe ( Internet Protocol Security Policies Tool). But
> when we run netstat, it still looks like they are able to connect to
> the server using port 1433. Has anyone come across this problem? I
> would appreciate it very much if somebody could send in any
> suggestions regarding this.
> Thanks,
> Ann
|||On 12 Jul 2004 14:56:40 -0700, nsajus@.yahoo.com (Ann) wrote:

>I have a question regarding the SQL Server(SQL Server 7) port 1433.
>Some body is trying to hack into our Windows 2000 server through port
>1433. Is there a way i can close this port?
Don't open it in your firewall. Or any other port you don't want
accessed.
Jeff
|||Hi
This sounds like your SQL Server is not behind the firewall or as the others
have suggested the firewall is not configured correctly.
How do you know someone is trying to access the SQL Server? If this is being
reported from the firewall then it may be because it is dropping it!!
If you are not using windows only authentication, then make sure that you
have a strong sa password.You could run the Microsoft Baseline Security
Analyzer http://www.microsoft.com/technet/sec.../mbsahome.mspx to
make sure it is configured sensibly. I would also look at running IIS
lockdown on any webserver
http://www.microsoft.com/security/gu...dtech/IIS.mspx
Check out the advice on:
http://www.microsoft.com/sql/techinf...ty/default.asp
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=24
John
"Ann" <nsajus@.yahoo.com> wrote in message
news:cca0635f.0407121356.55ef3590@.posting.google.c om...
> Hi
> I have a question regarding the SQL Server(SQL Server 7) port 1433.
> Some body is trying to hack into our Windows 2000 server through port
> 1433. Is there a way i can close this port? I tried using a tool
> called Ipsecpol.exe ( Internet Protocol Security Policies Tool). But
> when we run netstat, it still looks like they are able to connect to
> the server using port 1433. Has anyone come across this problem? I
> would appreciate it very much if somebody could send in any
> suggestions regarding this.
> Thanks,
> Ann
|||Hi Ann.
The easy one is to buy a firewall box from your local computer store
or If you are using a windows server 2003 use the firewall insite
windows server 2003 (ICF). Click on the link to see how to enable it.
http://www.microsoft.com/resources/d...e_firewall.asp
After you either buy a firewall box or enabled ICF on your server then
try this link:
- www.grc.com
- Click ShieldsUp
- Roll down to HOT SPOT and click again shieldsUp
- click proceed
- write 1433 in the text field and click "User Specified Custom Port
Probe"
- See if its stealth.
- You can then click common ports to see if the common ports are
stealth or click all service ports to see if other ports are
open...(The best is if every one are green and not red)
Hope you understand this and solve this problem..
Danni, MCP[vbcol=seagreen]
|||Sorry. i forgot it was a windows 2000 server. There is not a ICF.
You could also get a software firewall like ZoneAlarm? If the server
is in a big firm it mabye better with a firewall box.
Danni
|||On 13 Jul 2004 01:22:45 -0700, dev@.euro-consult.dk wrote:

>Sorry. i forgot it was a windows 2000 server. There is not a ICF.
>You could also get a software firewall like ZoneAlarm?
For home machines, that is fine, as would be the Sygate product. For
anything used 'in anger' this is a risky solution.

>If the server is in a big firm it mabye better with a firewall box.
In any situation where the data and system availability/integrity is
valuable, a hardware firewall solution is the only way to go.

Block Port 1433 on windows 2000 server

Hi

I have a question regarding the SQL Server(SQL Server 7) port 1433.
Some body is trying to hack into our Windows 2000 server through port
1433. Is there a way i can close this port? I tried using a tool
called Ipsecpol.exe ( Internet Protocol Security Policies Tool). But
when we run netstat, it still looks like they are able to connect to
the server using port 1433. Has anyone come across this problem? I
would appreciate it very much if somebody could send in any
suggestions regarding this.

Thanks,
AnnThe issue isn't really "closing ports" - it's blocking access to them.
Are you using ISA? If not, you need a firewall. I'd pick up a cheap and
cheerful firewall appliance - I like the NetGear FR114P.

Ann wrote:
> Hi
> I have a question regarding the SQL Server(SQL Server 7) port 1433.
> Some body is trying to hack into our Windows 2000 server through port
> 1433. Is there a way i can close this port? I tried using a tool
> called Ipsecpol.exe ( Internet Protocol Security Policies Tool). But
> when we run netstat, it still looks like they are able to connect to
> the server using port 1433. Has anyone come across this problem? I
> would appreciate it very much if somebody could send in any
> suggestions regarding this.
> Thanks,
> Ann|||On 12 Jul 2004 14:56:40 -0700, nsajus@.yahoo.com (Ann) wrote:

>I have a question regarding the SQL Server(SQL Server 7) port 1433.
>Some body is trying to hack into our Windows 2000 server through port
>1433. Is there a way i can close this port?

Don't open it in your firewall. Or any other port you don't want
accessed.

Jeff|||Hi

This sounds like your SQL Server is not behind the firewall or as the others
have suggested the firewall is not configured correctly.

How do you know someone is trying to access the SQL Server? If this is being
reported from the firewall then it may be because it is dropping it!!

If you are not using windows only authentication, then make sure that you
have a strong sa password.You could run the Microsoft Baseline Security
Analyzer http://www.microsoft.com/technet/se...s/mbsahome.mspx to
make sure it is configured sensibly. I would also look at running IIS
lockdown on any webserver
http://www.microsoft.com/security/g...odtech/IIS.mspx

Check out the advice on:
http://www.microsoft.com/sql/techin...ity/default.asp
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=24

John

"Ann" <nsajus@.yahoo.com> wrote in message
news:cca0635f.0407121356.55ef3590@.posting.google.c om...
> Hi
> I have a question regarding the SQL Server(SQL Server 7) port 1433.
> Some body is trying to hack into our Windows 2000 server through port
> 1433. Is there a way i can close this port? I tried using a tool
> called Ipsecpol.exe ( Internet Protocol Security Policies Tool). But
> when we run netstat, it still looks like they are able to connect to
> the server using port 1433. Has anyone come across this problem? I
> would appreciate it very much if somebody could send in any
> suggestions regarding this.
> Thanks,
> Ann|||Hi Ann.

The easy one is to buy a firewall box from your local computer store
or If you are using a windows server 2003 use the firewall insite
windows server 2003 (ICF). Click on the link to see how to enable it.
http://www.microsoft.com/resources/...le_firewall.asp

After you either buy a firewall box or enabled ICF on your server then
try this link:
- www.grc.com
- Click ShieldsUp
- Roll down to HOT SPOT and click again shieldsUp
- click proceed
- write 1433 in the text field and click "User Specified Custom Port
Probe"
- See if its stealth.
- You can then click common ports to see if the common ports are
stealth or click all service ports to see if other ports are
open...(The best is if every one are green and not red)

Hope you understand this and solve this problem..

Danni, MCP
> >I have a question regarding the SQL Server(SQL Server 7) port 1433.
> >Some body is trying to hack into our Windows 2000 server through port
> >1433. Is there a way i can close this port?|||Sorry. i forgot it was a windows 2000 server. There is not a ICF.
You could also get a software firewall like ZoneAlarm? If the server
is in a big firm it mabye better with a firewall box.

Danni|||On 13 Jul 2004 01:22:45 -0700, dev@.euro-consult.dk wrote:

>Sorry. i forgot it was a windows 2000 server. There is not a ICF.
>You could also get a software firewall like ZoneAlarm?

For home machines, that is fine, as would be the Sygate product. For
anything used 'in anger' this is a risky solution.

>If the server is in a big firm it mabye better with a firewall box.

In any situation where the data and system availability/integrity is
valuable, a hardware firewall solution is the only way to go.

Tuesday, February 14, 2012

Black Windows when starting SQL Server Agent

Hello guys,
I just wanted to ask you a question regarding a funny
behavior on my server. Out of nowhere, when I start the
SQL Server Agent, a command window appears, with the path
to sqlagent.exe, but nothing else happens. The Agent runs
fine while that window is open, but when I close it, it
stops. This was not happening before. I wonder if the
agent is corrupted or something like that. I tried copying
the sqlagent.exe file from another computer, where this
behavior is not showing and it still happens. I wonder if
another file is corrupted.
Any comments and/or suggestions will be appreciated.
Thanks.What version / service pack of SQL Server are you running ..?
--
HTH
Ryan Waight, MCDBA, MCSE
"Francisco Elizondo" <drcoco@.softhome.net> wrote in message
news:0c5b01c3a53f$77c2be80$a301280a@.phx.gbl...
> Hello guys,
> I just wanted to ask you a question regarding a funny
> behavior on my server. Out of nowhere, when I start the
> SQL Server Agent, a command window appears, with the path
> to sqlagent.exe, but nothing else happens. The Agent runs
> fine while that window is open, but when I close it, it
> stops. This was not happening before. I wonder if the
> agent is corrupted or something like that. I tried copying
> the sqlagent.exe file from another computer, where this
> behavior is not showing and it still happens. I wonder if
> another file is corrupted.
> Any comments and/or suggestions will be appreciated.
> Thanks.|||I'm running SQL Server 2000, with Service Pack 3, but the
problem started before I applied SP3. I applied it to see
if that would fix the problem, but it didn't.
Thanks
>--Original Message--
>What version / service pack of SQL Server are you
running ..?
>--
>HTH
>Ryan Waight, MCDBA, MCSE
>"Francisco Elizondo" <drcoco@.softhome.net> wrote in
message
>news:0c5b01c3a53f$77c2be80$a301280a@.phx.gbl...
>> Hello guys,
>> I just wanted to ask you a question regarding a funny
>> behavior on my server. Out of nowhere, when I start the
>> SQL Server Agent, a command window appears, with the
path
>> to sqlagent.exe, but nothing else happens. The Agent
runs
>> fine while that window is open, but when I close it, it
>> stops. This was not happening before. I wonder if the
>> agent is corrupted or something like that. I tried
copying
>> the sqlagent.exe file from another computer, where this
>> behavior is not showing and it still happens. I wonder
if
>> another file is corrupted.
>> Any comments and/or suggestions will be appreciated.
>> Thanks.
>
>.
>|||Francisco,
In the services configuration panel, open sqlserveragent service. In the
LogOn tab, uncheck "Allow service to interact with desktop" checkbox which
is available only when running the service undes localsystem account.
"Francisco Elizondo" <drcoco@.softhome.net> wrote in message
news:0c5b01c3a53f$77c2be80$a301280a@.phx.gbl...
> Hello guys,
> I just wanted to ask you a question regarding a funny
> behavior on my server. Out of nowhere, when I start the
> SQL Server Agent, a command window appears, with the path
> to sqlagent.exe, but nothing else happens. The Agent runs
> fine while that window is open, but when I close it, it
> stops. This was not happening before. I wonder if the
> agent is corrupted or something like that. I tried copying
> the sqlagent.exe file from another computer, where this
> behavior is not showing and it still happens. I wonder if
> another file is corrupted.
> Any comments and/or suggestions will be appreciated.
> Thanks.|||Are you seing any messages in the SQL Agents ErrorLog.
Right Click 'SQL Server Agent' and Display ErrorLog
--
HTH
Ryan Waight, MCDBA, MCSE
"Francisco Elizondo" <drcoco@.softhome.net> wrote in message
news:0b3e01c3a546$526fd3a0$a601280a@.phx.gbl...
> I'm running SQL Server 2000, with Service Pack 3, but the
> problem started before I applied SP3. I applied it to see
> if that would fix the problem, but it didn't.
> Thanks
> >--Original Message--
> >What version / service pack of SQL Server are you
> running ..?
> >
> >--
> >HTH
> >Ryan Waight, MCDBA, MCSE
> >
> >"Francisco Elizondo" <drcoco@.softhome.net> wrote in
> message
> >news:0c5b01c3a53f$77c2be80$a301280a@.phx.gbl...
> >> Hello guys,
> >>
> >> I just wanted to ask you a question regarding a funny
> >> behavior on my server. Out of nowhere, when I start the
> >> SQL Server Agent, a command window appears, with the
> path
> >> to sqlagent.exe, but nothing else happens. The Agent
> runs
> >> fine while that window is open, but when I close it, it
> >> stops. This was not happening before. I wonder if the
> >> agent is corrupted or something like that. I tried
> copying
> >> the sqlagent.exe file from another computer, where this
> >> behavior is not showing and it still happens. I wonder
> if
> >> another file is corrupted.
> >> Any comments and/or suggestions will be appreciated.
> >> Thanks.
> >
> >
> >.
> >|||No errors in the errorlog. Only loading information for
the service. The service runs fine, but I'm just concerned
about the command window not closing. If I close it, the
service stops.
Thanks.
>--Original Message--
>Are you seing any messages in the SQL Agents ErrorLog.
>Right Click 'SQL Server Agent' and Display ErrorLog
>--
>HTH
>Ryan Waight, MCDBA, MCSE
>"Francisco Elizondo" <drcoco@.softhome.net> wrote in
message
>news:0b3e01c3a546$526fd3a0$a601280a@.phx.gbl...
>> I'm running SQL Server 2000, with Service Pack 3, but
the
>> problem started before I applied SP3. I applied it to
see
>> if that would fix the problem, but it didn't.
>> Thanks
>> >--Original Message--
>> >What version / service pack of SQL Server are you
>> running ..?
>> >
>> >--
>> >HTH
>> >Ryan Waight, MCDBA, MCSE
>> >
>> >"Francisco Elizondo" <drcoco@.softhome.net> wrote in
>> message
>> >news:0c5b01c3a53f$77c2be80$a301280a@.phx.gbl...
>> >> Hello guys,
>> >>
>> >> I just wanted to ask you a question regarding a funny
>> >> behavior on my server. Out of nowhere, when I start
the
>> >> SQL Server Agent, a command window appears, with the
>> path
>> >> to sqlagent.exe, but nothing else happens. The Agent
>> runs
>> >> fine while that window is open, but when I close it,
it
>> >> stops. This was not happening before. I wonder if the
>> >> agent is corrupted or something like that. I tried
>> copying
>> >> the sqlagent.exe file from another computer, where
this
>> >> behavior is not showing and it still happens. I
wonder
>> if
>> >> another file is corrupted.
>> >> Any comments and/or suggestions will be appreciated.
>> >> Thanks.
>> >
>> >
>> >.
>> >
>
>.
>|||Did you check the other recommendation? The service config?
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Francisco Elizondo" <drcoco@.softhome.net> wrote in message
news:0bcd01c3a54c$739f40a0$a601280a@.phx.gbl...
> No errors in the errorlog. Only loading information for
> the service. The service runs fine, but I'm just concerned
> about the command window not closing. If I close it, the
> service stops.
> Thanks.
> >--Original Message--
> >Are you seing any messages in the SQL Agents ErrorLog.
> >
> >Right Click 'SQL Server Agent' and Display ErrorLog
> >
> >--
> >HTH
> >Ryan Waight, MCDBA, MCSE
> >
> >"Francisco Elizondo" <drcoco@.softhome.net> wrote in
> message
> >news:0b3e01c3a546$526fd3a0$a601280a@.phx.gbl...
> >> I'm running SQL Server 2000, with Service Pack 3, but
> the
> >> problem started before I applied SP3. I applied it to
> see
> >> if that would fix the problem, but it didn't.
> >>
> >> Thanks
> >> >--Original Message--
> >> >What version / service pack of SQL Server are you
> >> running ..?
> >> >
> >> >--
> >> >HTH
> >> >Ryan Waight, MCDBA, MCSE
> >> >
> >> >"Francisco Elizondo" <drcoco@.softhome.net> wrote in
> >> message
> >> >news:0c5b01c3a53f$77c2be80$a301280a@.phx.gbl...
> >> >> Hello guys,
> >> >>
> >> >> I just wanted to ask you a question regarding a funny
> >> >> behavior on my server. Out of nowhere, when I start
> the
> >> >> SQL Server Agent, a command window appears, with the
> >> path
> >> >> to sqlagent.exe, but nothing else happens. The Agent
> >> runs
> >> >> fine while that window is open, but when I close it,
> it
> >> >> stops. This was not happening before. I wonder if the
> >> >> agent is corrupted or something like that. I tried
> >> copying
> >> >> the sqlagent.exe file from another computer, where
> this
> >> >> behavior is not showing and it still happens. I
> wonder
> >> if
> >> >> another file is corrupted.
> >> >> Any comments and/or suggestions will be appreciated.
> >> >> Thanks.
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >|||Well, it seems like that did the trick. Thanks a lot for
all the help. I will keep you updated if anything else
happens. Sorry to bother you if my dumb questions. :-D
Francisco
>--Original Message--
>Francisco,
>In the services configuration panel, open sqlserveragent
service. In the
>LogOn tab, uncheck "Allow service to interact with
desktop" checkbox which
>is available only when running the service undes
localsystem account.
>"Francisco Elizondo" <drcoco@.softhome.net> wrote in
message
>news:0c5b01c3a53f$77c2be80$a301280a@.phx.gbl...
>> Hello guys,
>> I just wanted to ask you a question regarding a funny
>> behavior on my server. Out of nowhere, when I start the
>> SQL Server Agent, a command window appears, with the
path
>> to sqlagent.exe, but nothing else happens. The Agent
runs
>> fine while that window is open, but when I close it, it
>> stops. This was not happening before. I wonder if the
>> agent is corrupted or something like that. I tried
copying
>> the sqlagent.exe file from another computer, where this
>> behavior is not showing and it still happens. I wonder
if
>> another file is corrupted.
>> Any comments and/or suggestions will be appreciated.
>> Thanks.
>
>.
>|||Yeps, tried the service config, and it did work. This is
the first time something like this happened and I was
scared that it had to do with the sql server install.
Thanks again for all your help.
>--Original Message--
>Did you check the other recommendation? The service
config?
>--
>Tibor Karaszi, SQL Server MVP
>Archive at:
>http://groups.google.com/groups?
oi=djq&as_ugroup=microsoft.public.sqlserver
>
>"Francisco Elizondo" <drcoco@.softhome.net> wrote in
message
>news:0bcd01c3a54c$739f40a0$a601280a@.phx.gbl...
>> No errors in the errorlog. Only loading information for
>> the service. The service runs fine, but I'm just
concerned
>> about the command window not closing. If I close it, the
>> service stops.
>> Thanks.
>> >--Original Message--
>> >Are you seing any messages in the SQL Agents ErrorLog.
>> >
>> >Right Click 'SQL Server Agent' and Display ErrorLog
>> >
>> >--
>> >HTH
>> >Ryan Waight, MCDBA, MCSE
>> >
>> >"Francisco Elizondo" <drcoco@.softhome.net> wrote in
>> message
>> >news:0b3e01c3a546$526fd3a0$a601280a@.phx.gbl...
>> >> I'm running SQL Server 2000, with Service Pack 3, but
>> the
>> >> problem started before I applied SP3. I applied it to
>> see
>> >> if that would fix the problem, but it didn't.
>> >>
>> >> Thanks
>> >> >--Original Message--
>> >> >What version / service pack of SQL Server are you
>> >> running ..?
>> >> >
>> >> >--
>> >> >HTH
>> >> >Ryan Waight, MCDBA, MCSE
>> >> >
>> >> >"Francisco Elizondo" <drcoco@.softhome.net> wrote in
>> >> message
>> >> >news:0c5b01c3a53f$77c2be80$a301280a@.phx.gbl...
>> >> >> Hello guys,
>> >> >>
>> >> >> I just wanted to ask you a question regarding a
funny
>> >> >> behavior on my server. Out of nowhere, when I
start
>> the
>> >> >> SQL Server Agent, a command window appears, with
the
>> >> path
>> >> >> to sqlagent.exe, but nothing else happens. The
Agent
>> >> runs
>> >> >> fine while that window is open, but when I close
it,
>> it
>> >> >> stops. This was not happening before. I wonder if
the
>> >> >> agent is corrupted or something like that. I tried
>> >> copying
>> >> >> the sqlagent.exe file from another computer, where
>> this
>> >> >> behavior is not showing and it still happens. I
>> wonder
>> >> if
>> >> >> another file is corrupted.
>> >> >> Any comments and/or suggestions will be
appreciated.
>> >> >> Thanks.
>> >> >
>> >> >
>> >> >.
>> >> >
>> >
>> >
>> >.
>> >
>
>.
>