More Problems With 32 Bit Package on x64 SQL Server

Hello,

I have gone through some documentation on how to execute a 32 bit package on SQL Server 2005 x64, and I'm still running into problems when I attempt to execute such a package from a Job.

Critical Points:

-The package was imported into an instance of Integration Services 2005 from the file system to a subdirectory of the MSDB folder. From Management Studio, Integration Services, the path to the package looks like this: Stored Packages\MSDB\CPS\CPS_Collections. 'CPS_Collections' is the name of the package.

-This package has a connection to an Access 2000 database using the Native OLE DB\Microsoft Jet 4.0 OLE DB Provider. I understand that there is not a 64 bit version of this provider. The Access database is stored on a different machine than the one that hosts the SQL Server 2005 x64 instance.

-According to this; http://msdn2.microsoft.com/en-us/library/ms141766.aspx I should be able to create the command line with the dtexecui.exe utility and copy and paste this line into a Job Step with the Job Step Type as operating system. Here is what my command line looks like: /SQL "\CPS\CPS_Collections" /SERVER bwdbfin1 /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING E . I have the Job Type set up as Operating System, and the Job runs as SQL Agent Service Account

-When I attempt to run the Job, the Job fails. Here is a part of the error message from the Job history:

The process could not be created for step 1 of job 0x9B318B226174A24B8BD63CE8F4814864 (reason: The system cannot find the file specified).

Does this point to a problem of where the Access datbase is located? Could it be that the account that runs SQL Agent does not have access rights to the directory? Is there a way to run an operating system command as someone other than SQL Agent? Is there something wrong with the command line that I am using?

Please share if you have any ideas on this.

Thank you for your help!

cdun2

On a 64-bit server, the SSIS job step calls the 64-bit version of DTEXEC. You need to call the 32-bit version (located in C:\Program Files (x86)\Microsoft Sql Server\90\DTS on most installs). To do this, you need to use a CmdExec job step.|||Hi,

Since the error description said : The system cannot find the file specified, maybe you set the location of Access database into a mapping drive or something, try using this format \\ip_address_of_the_machine\

Best regards,

Hery|||

cdun2 wrote:

-According to this; http://msdn2.microsoft.com/en-us/library/ms141766.aspx I should be able to create the command line with the dtexecui.exe utility and copy and paste this line into a Job Step with the Job Step Type as operating system. Here is what my command line looks like: /SQL "\CPS\CPS_Collections" /SERVER bwdbfin1 /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING E . I have the Job Type set up as Operating System, and the Job runs as SQL Agent Service Account

You can use DTEXECUI to construct the command arguments, but you still need to supply the executable name for the command line. I.e. your full command line should look like

"C:\Program Files (x86)\Microsoft Sql Server\90\DTS\Binn\DtExec.exe" /SQL "\CPS\CPS_Collections" /SERVER bwdbfin1 /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING E

|||

Thanks for the help, and sorry for the late response. I'll take your responses and look into this further. I can say that the location to the Access database is not expressed as a mapped drive.

More Memory

Is there any way to get Standard SQL Server 2000 to use more than 2GB of
memory? I am running on a 2003 standard server w/the 3GB switch in the
boot.ini, but SQL still appears to only use 2GB of memory in the task manager.
Thanks> Is there any way to get Standard SQL Server 2000 to use more than 2GB of
> memory?
No. You need to step up to Enterprise Edition to use more than 2GB. See
'Maximum Capacity Specifications' in the Books Online for details.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Matt L." <Matt L.@.discussions.microsoft.com> wrote in message
news:6795FFF1-A0DB-40CB-82C5-35D3473FFB42@.microsoft.com...
> Is there any way to get Standard SQL Server 2000 to use more than 2GB of
> memory? I am running on a 2003 standard server w/the 3GB switch in the
> boot.ini, but SQL still appears to only use 2GB of memory in the task
> manager.
> Thanks|||OK, Thanks Dan
"Dan Guzman" wrote:
> > Is there any way to get Standard SQL Server 2000 to use more than 2GB of
> > memory?
> No. You need to step up to Enterprise Edition to use more than 2GB. See
> 'Maximum Capacity Specifications' in the Books Online for details.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Matt L." <Matt L.@.discussions.microsoft.com> wrote in message
> news:6795FFF1-A0DB-40CB-82C5-35D3473FFB42@.microsoft.com...
> > Is there any way to get Standard SQL Server 2000 to use more than 2GB of
> > memory? I am running on a 2003 standard server w/the 3GB switch in the
> > boot.ini, but SQL still appears to only use 2GB of memory in the task
> > manager.
> >
> > Thanks
>
>

More Memory

Is there any way to get Standard SQL Server 2000 to use more than 2GB of
memory? I am running on a 2003 standard server w/the 3GB switch in the
boot.ini, but SQL still appears to only use 2GB of memory in the task manage
r.
Thanks> Is there any way to get Standard SQL Server 2000 to use more than 2GB of
> memory?
No. You need to step up to Enterprise Edition to use more than 2GB. See
'Maximum Capacity Specifications' in the Books Online for details.
Hope this helps.
Dan Guzman
SQL Server MVP
"Matt L." <Matt L.@.discussions.microsoft.com> wrote in message
news:6795FFF1-A0DB-40CB-82C5-35D3473FFB42@.microsoft.com...
> Is there any way to get Standard SQL Server 2000 to use more than 2GB of
> memory? I am running on a 2003 standard server w/the 3GB switch in the
> boot.ini, but SQL still appears to only use 2GB of memory in the task
> manager.
> Thanks|||OK, Thanks Dan
"Dan Guzman" wrote:

> No. You need to step up to Enterprise Edition to use more than 2GB. See
> 'Maximum Capacity Specifications' in the Books Online for details.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Matt L." <Matt L.@.discussions.microsoft.com> wrote in message
> news:6795FFF1-A0DB-40CB-82C5-35D3473FFB42@.microsoft.com...
>
>

moount points

I know how to create mount point in windows 20003 cluster, I am not sure how
to set it up with SQL 2005 running on the cluster.
Does sql need to be dependant on any of the disks? I have tried looking for
a guide, but cannot find.
current setup active active cluster running. I need to add san space which
will hold the databases. The san will be carved up into drive letters. each
drive letter will hold 3 mount points.
ie.
node 1
J:-2 mount point
k:2 mount point
l:2 mount point
node 2-
r:-2 mount point
s:2 mount point
t:2 mount point
each node would be able to own the disk if the other node failed over.
any help is appreciate. I have tried books online etc.. cannot find a good
step by step.;
Vision,
there are three area's you want to get familiar with prior to setting up a
production cluster
1) how to setup mountpoints in a cluster
http://support.microsoft.com/kb/280297
2) Be aware of this one, I have seen this once or twice after installing
SP1, if you do not have the symptom you do not need the hotfix.
http://support.microsoft.com/kb/898790
3) SQL 2005 and mount points
http://www.microsoft.com/technet/prodtechnol/sql/2005/physdbstor.mspx
http://support.microsoft.com/kb/819546
Test everything thoroughly before you put this into any production.
HTH,
_Edwin.
"vision" <vision@.discussions.microsoft.com> wrote in message
news:F0C6D7D8-F9F2-46DF-A128-2D384DACD40C@.microsoft.com...
> I know how to create mount point in windows 20003 cluster, I am not sure
how
> to set it up with SQL 2005 running on the cluster.
> Does sql need to be dependant on any of the disks? I have tried looking
for
> a guide, but cannot find.
> current setup active active cluster running. I need to add san space
which
> will hold the databases. The san will be carved up into drive letters.
each
> drive letter will hold 3 mount points.
> ie.
> node 1
> J:-2 mount point
> k:2 mount point
> l:2 mount point
> node 2-
> r:-2 mount point
> s:2 mount point
> t:2 mount point
> each node would be able to own the disk if the other node failed over.
> any help is appreciate. I have tried books online etc.. cannot find a
good
> step by step.;

monthly database merging

Hi,

I have to set up a project in SQLServer Express that will allow the export of tables from multiple PC's running SQLServer Express each month.

These have to be loaded into a single identical database on SQLServer Express each month for combined reporting.

so its basicaly

insert update on PC

export

import overlaying last months data (handle dup keys from the other pc's etc)

report

I've had a look at the SQLServer replication docs and got confused....

So if anyone can point me at appropriate documentation, or suggest a good method for this it would be appreciated

Thanks

SQL Server 2005 Express to SQL Server 2005 Express does NOT support replication. However there is a Import/Export tool (DTSWizard.exe) included with the Express Toolkit (Note: Requires SQL Express SP1 or higher.)

Download the Express Toolkit (and SQL Express SP2) here: http://msdn.microsoft.com/vstudio/express/sql/download/

After installing the toolkit, the Import/Export tool (called DTSWizard.exe) is located at:

"C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe".

Add a 'shortcut to SSMSE: [Tools], [External Tools], name and add the shortcut by linking to the DTS file above.

In order to Schedule the process, you may have to employ the Windows Scheduler and add a Task that will run DTSRun.exe.

I recommend creating 'staging' tables, identical schemas to the actual tables. Load your data into the staging tables, then you can move the conforming data to the actual tables, leaving behind the non-conforming data for 'clean-up'.

|||

Thanks

Peter

monthly database merge

Hi,

I have to set up a project in SQLServer Express that will allow the export of tables from multiple PC's running SQLServer Express each month.

These have to be loaded into a single identical database on SQLServer Express each month for combined reporting.

so its basicaly

insert update on PC

export

import overlaying last months data (handle dup keys from the other pc's etc)

report

I've had a look at the SQLServer replication docs and got confused....

Can I do this with replication ?

So if anyone can point me at appropriate documentation, or suggest a good method for this it would be appreciated

Thanks

Yes, it's possible to do it with replication.

Look up the topic on merge replication on MSDN.

Also check out the following links for some additional info:

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1527294&SiteID=17

http://msdn2.microsoft.com/en-us/library/ms151819.aspx

Gary

|||

Hello Peter,

Express Edition is not able to be a Publisher. It's capable of being a Subscriber only.

Check header "Integration and Interoperability" from the following link:

Features Comparison:

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

and these links to learn more about SQL Server Replication from BOL:

Replication Basics for Express Edition:

http://msdn2.microsoft.com/en-us/library/ms165700.aspx

SQL Server Replication:

http://msdn2.microsoft.com/en-us/library/ms151198.aspx

Ekrem ?nsoy

|||

Unfortunatly that was the documentation that confused me. Is there something a little more practical and less theoretical around.?

|||

The Remote PC's in my system are self sufficient (ie dont need recieve data back from the merge) and are not physically connected to the machine that aggregates the data.

The documentation seems to imply that although I can set up a copy of SQLServer Express to merge the data recieved on CD from the remote sites, that I cannot set up the SQLServer Express remote sites to generate the replication data to the CD's

Do you agree with that statement, from your experiance?

Month and Day Date Selection

Hi Folks:

I'm running a query whereby my users will select between "FromCloseDate" and "ToCloseDate". The easy part is when they're searching for month, day and year between the close dates however, they have a boolean report parameter that allow them to select month and day between the close dates. Has anyone done a between date selection for month and day?

Thanks in advance

Couldn't you just use the MONTH() and DAY() functions to extract the month and day for use in your query? Or you could use SUBSTRING().

Monitoring the server

I am new to the forum and have a question. I would like to monitor the SQL
Server 2000 to make sure that it is running fine. Sometimes our server
couldn't be connected even the server is running. I have to re-start the SQL
Server in order to solve the problem. I am not sure why does this happen.
That would be nice if I could monitoring the server. Does anyone know how
to do it? Can I monitoring certain port(s)? Or ping those ports? Thanks in
advance for your help
"Skylander" <Skylander@.discussions.microsoft.com> wrote in message
news:10710AC1-A2C8-45D1-9CE5-A7032970D502@.microsoft.com...
> I am new to the forum and have a question. I would like to monitor the
SQL
> Server 2000 to make sure that it is running fine. Sometimes our server
> couldn't be connected even the server is running. I have to re-start the
SQL
> Server in order to solve the problem. I am not sure why does this happen.
> That would be nice if I could monitoring the server. Does anyone know how
> to do it? Can I monitoring certain port(s)? Or ping those ports? Thanks
in
> advance for your help
There are a variety of monitoring options available, from high-end to basic:
Microsoft Operation Monitor (MOM), network monitor, performance monitor,
home grown application.
Also, you'll want to give this article a read:
http://support.microsoft.com/default...b;en-us;827422
Steve
sql

Monitoring the server

I am new to the forum and have a question. I would like to monitor the SQL
Server 2000 to make sure that it is running fine. Sometimes our server
couldn't be connected even the server is running. I have to re-start the SQ
L
Server in order to solve the problem. I am not sure why does this happen.
That would be nice if I could monitoring the server. Does anyone know how
to do it? Can I monitoring certain port(s)? Or ping those ports? Thanks in
advance for your help "Skylander" <Skylander@.discussions.microsoft.com> wrote in message
news:10710AC1-A2C8-45D1-9CE5-A7032970D502@.microsoft.com...
> I am new to the forum and have a question. I would like to monitor the
SQL
> Server 2000 to make sure that it is running fine. Sometimes our server
> couldn't be connected even the server is running. I have to re-start the
SQL
> Server in order to solve the problem. I am not sure why does this happen.
> That would be nice if I could monitoring the server. Does anyone know how
> to do it? Can I monitoring certain port(s)? Or ping those ports? Thanks
in
> advance for your help
There are a variety of monitoring options available, from high-end to basic:
Microsoft Operation Monitor (MOM), network monitor, performance monitor,
home grown application.
Also, you'll want to give this article a read:
http://support.microsoft.com/defaul...kb;en-us;827422
Steve

Monitoring the server

I am new to the forum and have a question. I would like to monitor the SQL
Server 2000 to make sure that it is running fine. Sometimes our server
couldn't be connected even the server is running. I have to re-start the SQL
Server in order to solve the problem. I am not sure why does this happen.
That would be nice if I could monitoring the server. Does anyone know how
to do it? Can I monitoring certain port(s)? Or ping those ports? Thanks in
advance for your help
Hi
There are quite a few different ways to monitor your server, but for your
immendiate problem you will have to look at the SQL Server error log or the
event log to see if there are any messages relating to the times you are
having the problems. Going forward you may want to look at third party tools
such as Tivoli or Perfmon or SQL Server Alerts or your own scripts that
monitor various aspects of the system.
John
"Skylander" wrote:

> I am new to the forum and have a question. I would like to monitor the SQL
> Server 2000 to make sure that it is running fine. Sometimes our server
> couldn't be connected even the server is running. I have to re-start the SQL
> Server in order to solve the problem. I am not sure why does this happen.
> That would be nice if I could monitoring the server. Does anyone know how
> to do it? Can I monitoring certain port(s)? Or ping those ports? Thanks in
> advance for your help
>
|||Hi John,
Thanks for your quick reply. I have an application called 'SiteScope' that
can monitoring ports and stuff (don't know the detail function of this
application). Can I setup that to monitor certain SQL Server components to
make sure it's running fine?
BTW, is SQL Server Alert part of the components of SQL Server 2000? Thanks
Vince
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> There are quite a few different ways to monitor your server, but for your
> immendiate problem you will have to look at the SQL Server error log or the
> event log to see if there are any messages relating to the times you are
> having the problems. Going forward you may want to look at third party tools
> such as Tivoli or Perfmon or SQL Server Alerts or your own scripts that
> monitor various aspects of the system.
> John
> "Skylander" wrote:
|||Hi
Monitoring SQL Server is not really about monitoring the ports, that
tend to imply you have network issues or even a DOS attack!!!!
You can look at what alerts can do by reading books online or starting
at
http://msdn.microsoft.com/library/de...omaem_0uwk.asp
John
|||Hi
You may also find these useful
http://www.databasejournal.com/scrip...le.php/3494931
or SQLPing useful
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=26
John
John Bell wrote:
> Hi
> Monitoring SQL Server is not really about monitoring the ports, that
> tend to imply you have network issues or even a DOS attack!!!!
> You can look at what alerts can do by reading books online or
starting
> at
>
http://msdn.microsoft.com/library/de...omaem_0uwk.asp
> John

Monitoring the server

I am new to the forum and have a question. I would like to monitor the SQL
Server 2000 to make sure that it is running fine. Sometimes our server
couldn't be connected even the server is running. I have to re-start the SQ
L
Server in order to solve the problem. I am not sure why does this happen.
That would be nice if I could monitoring the server. Does anyone know how
to do it? Can I monitoring certain port(s)? Or ping those ports? Thanks in
advance for your help Hi
There are quite a few different ways to monitor your server, but for your
immendiate problem you will have to look at the SQL Server error log or the
event log to see if there are any messages relating to the times you are
having the problems. Going forward you may want to look at third party tools
such as Tivoli or Perfmon or SQL Server Alerts or your own scripts that
monitor various aspects of the system.
John
"Skylander" wrote:

> I am new to the forum and have a question. I would like to monitor the SQ
L
> Server 2000 to make sure that it is running fine. Sometimes our server
> couldn't be connected even the server is running. I have to re-start the
SQL
> Server in order to solve the problem. I am not sure why does this happen.
> That would be nice if I could monitoring the server. Does anyone know how
> to do it? Can I monitoring certain port(s)? Or ping those ports? Thanks
in
> advance for your help
>|||Hi John,
Thanks for your quick reply. I have an application called 'SiteScope' that
can monitoring ports and stuff (don't know the detail function of this
application). Can I setup that to monitor certain SQL Server components to
make sure it's running fine?
BTW, is SQL Server Alert part of the components of SQL Server 2000? Thanks
Vince
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> There are quite a few different ways to monitor your server, but for your
> immendiate problem you will have to look at the SQL Server error log or th
e
> event log to see if there are any messages relating to the times you are
> having the problems. Going forward you may want to look at third party too
ls
> such as Tivoli or Perfmon or SQL Server Alerts or your own scripts that
> monitor various aspects of the system.
> John
> "Skylander" wrote:
>|||Hi
Monitoring SQL Server is not really about monitoring the ports, that
tend to imply you have network issues or even a DOS attack!!!!
You can look at what alerts can do by reading books online or starting
at
http://msdn.microsoft.com/library/d...>
aem_0uwk.asp
John|||Hi
You may also find these useful
http://www.databasejournal.com/scri...cle.php/3494931
or SQLPing useful
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=26
John
John Bell wrote:
> Hi
> Monitoring SQL Server is not really about monitoring the ports, that
> tend to imply you have network issues or even a DOS attack!!!!
> You can look at what alerts can do by reading books online or
starting
> at
>
[url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_automaem_0uwk.asp[/ur
l]
> John

Monitoring the server

I am new to the forum and have a question. I would like to monitor the SQL
Server 2000 to make sure that it is running fine. Sometimes our server
couldn't be connected even the server is running. I have to re-start the SQL
Server in order to solve the problem. I am not sure why does this happen.
That would be nice if I could monitoring the server. Does anyone know how
to do it? Can I monitoring certain port(s)? Or ping those ports? Thanks in
advance for your help :)Hi
There are quite a few different ways to monitor your server, but for your
immendiate problem you will have to look at the SQL Server error log or the
event log to see if there are any messages relating to the times you are
having the problems. Going forward you may want to look at third party tools
such as Tivoli or Perfmon or SQL Server Alerts or your own scripts that
monitor various aspects of the system.
John
"Skylander" wrote:
> I am new to the forum and have a question. I would like to monitor the SQL
> Server 2000 to make sure that it is running fine. Sometimes our server
> couldn't be connected even the server is running. I have to re-start the SQL
> Server in order to solve the problem. I am not sure why does this happen.
> That would be nice if I could monitoring the server. Does anyone know how
> to do it? Can I monitoring certain port(s)? Or ping those ports? Thanks in
> advance for your help :)
>|||Hi John,
Thanks for your quick reply. I have an application called 'SiteScope' that
can monitoring ports and stuff (don't know the detail function of this
application). Can I setup that to monitor certain SQL Server components to
make sure it's running fine?
BTW, is SQL Server Alert part of the components of SQL Server 2000? Thanks
Vince
"John Bell" wrote:
> Hi
> There are quite a few different ways to monitor your server, but for your
> immendiate problem you will have to look at the SQL Server error log or the
> event log to see if there are any messages relating to the times you are
> having the problems. Going forward you may want to look at third party tools
> such as Tivoli or Perfmon or SQL Server Alerts or your own scripts that
> monitor various aspects of the system.
> John
> "Skylander" wrote:
> > I am new to the forum and have a question. I would like to monitor the SQL
> > Server 2000 to make sure that it is running fine. Sometimes our server
> > couldn't be connected even the server is running. I have to re-start the SQL
> > Server in order to solve the problem. I am not sure why does this happen.
> >
> > That would be nice if I could monitoring the server. Does anyone know how
> > to do it? Can I monitoring certain port(s)? Or ping those ports? Thanks in
> > advance for your help :)
> >|||Hi
Monitoring SQL Server is not really about monitoring the ports, that
tend to imply you have network issues or even a DOS attack!!!!
You can look at what alerts can do by reading books online or starting
at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_automaem_0uwk.asp
John|||Hi
You may also find these useful
http://www.databasejournal.com/scripts/article.php/3494931
or SQLPing useful
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=26
John
John Bell wrote:
> Hi
> Monitoring SQL Server is not really about monitoring the ports, that
> tend to imply you have network issues or even a DOS attack!!!!
> You can look at what alerts can do by reading books online or
starting
> at
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_automaem_0uwk.asp
> John

Monitoring the running and execution of SSIS packages with MOM

Hi,

Has anyone monitored the execution of SSIS packages with MOM? Are there extreme benefits over just utilizing the built in execution and event logs, as well as the Windows Event Viewer?

What is the recommended way to monitor SSIS execution?

Thanks,

- Joel

Joel,

I have a very very limited knwoledge of MOM... However you can log many things to the event log with SSIS (job execution with SQL Agent, logging to event log, ...). I'm not aware of anything "standard" for SSIS & MOM...

|||

They're not quite there yet with MOM integration. We had a similar project to integrate into Tivoli and the way I got around it was to use logging providers to output into the Windows Event Log. Tivoli had hooks into the Event Log for the events I gave it and whalla....pagers blaring. If your concern is more from the operations perpective, you may have better luck using the SQL Server log provider and creating operations reports for your production support. You can use these and events like the OnPipelineRowsSent to trap "hung" packages or tasks.

Sorry there's not a better answer but direct MOM integration is just a matter of time.

-- Brian

sql

Monitoring Statistics inside a DTS package

Hi,
Can some one tell me if I can monitor the statistics information for each
query
running inside a DTS package. The DTS package takes a long time to complete.
I need this help to fine tune the DTS pacakge.
--
Thanks and Regards,
PrasanthYou can
Set Statistics IO on
Set statistics Time on
etc...but save the output to a file..
you might also run Profiler to capture additional information.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Prasanth" <Prasanth@.discussions.microsoft.com> wrote in message
news:8E3F74FE-5505-4A44-9E1E-0F1948AF3D18@.microsoft.com...
> Hi,
> Can some one tell me if I can monitor the statistics information for each
> query
> running inside a DTS package. The DTS package takes a long time to
complete.
> I need this help to fine tune the DTS pacakge.
> --
> Thanks and Regards,
> Prasanth

Monitoring SqlServer 2000 performance with Express

Hi,

I'm using Visual Web Developer Express and Management Studio Express, and my web site is on a shared web host′, running SqlServer2000. I'm looking for software that enables me to monitor the server, but is it possible? The only apps I've found (and downloaded and installed and unistalled) so far need administrative rights to the server so they won't work on a shared web host.

All help would be welcome!

Thanks in advance,

Pettrer

Goto Administrative Tools...Performance.

Right mouse click on the graph and select "Add Counters..."

Drop down the Performance Objects listbox.

There are many performance counters installed with SQL Server, IIS and .NET.

|||

Hello,

This little app seems quite powerful, but it's only for times when one has physical access and the correct permissions to the db server, isn't it? I can only find SQLServer Express in the list of availabale servers, that is, my own computer's (inactive) web server.

I was thinking more of a third-party purchase, if any of those works in a hosted environment.

Thanks for replying!

Pettrer, Sweden

|||

>> but it's only for times when one has physical access and the correct permissions to the db server, isn't it?

A third party tool will also need permissions. In the Add Counters dialog, there's a pull down to select from other computers. However, I admit I've never tried or done this :)

There must be a way to get it to work. From the help:

Choosing the computer to use for monitoring
When monitoring computers remotely, you have some options for how to collect data. For example, you could run performance logging on the administrator's computer, drawing data continuously from each remote computer. In another case, you could have each computer running the service to collect data and, at regular intervals, run a batch program to transfer the data to the administrator's computer for analysis and archiving.

Centralized data collection (that is, collection on a local computer from remote computers that you are monitoring) is simple to implement because only one logging service is running. You can collect data from multiple systems into a single log file. However, it causes additional network traffic and might be restricted by available memory on the administrator's computer. To do centralized data collection, use the Add Counters dialog box to select a remote computer while running System Monitor on your local computer.

Distributed data collection (that is, data collection that occurs on the remote computers you are monitoring) does not incur the memory and network traffic problems of centralized collection. However, it does result in delayed availability of the data, requiring that the collected data be transferred to the administrator's computer for review. To do distributed data collection, use Computer Management on a local computer to select a remote computer on which to collect data.

When monitoring remote computers, note that the remote computer will only allow access to user accounts that have permission to access it. In order to monitor remote systems from your computer, you must start the Performance Logs and Alerts service using an account that has permission to access the remote computers you want to monitor. By default, the service is started under the local computer's "system" account, which generally has permission only to access services and resources on the local computer. To start this under a different account, use the Run As option when configuring data collection, or use Services under Computer Management and update the properties of the Performance Logs and Alerts service.

|||

Hi again,

Thanks for your replies. I found the option you mentioned but didn't see a "remote" option or the like. In any case, I bellieve I wont be able to access the server's system folder anyway. I don't know much about this, but it seems as if the majority of these apps are diving into the system, which may be a prerequisite, at least for diagnosing the internal performance. What I'm looking for is how well the server performs, how long before it jams and so on, and it might not be possible to it this way.

Pettrer

monitoring sql error log for keywords

Hello,
We have Patrol monitoring running on our SQL Server 2000/2005 instances.
One of the alerts for Patrol is ErrorLogUpdates.
This sends out an alert when a particular keyword is found in the error log.
There are two parameters I can specify, INCLUDE keywords and EXCLUDE keywords.
I have been taking a look at quiet a few of our error logs and not making
any headway so far.
Does anyone have any suggestions as to what I can put in INCLUDE list and
EXCLUDE list of keywords to look for in SQL error log.
Thanks in advance.
Cheers.
Kunal.
Hi
Products like MOM come with preconfigured scripts, therefore I would expect
the software vendor to supply this.
John
"kunalap" wrote:

> Hello,
> We have Patrol monitoring running on our SQL Server 2000/2005 instances.
> One of the alerts for Patrol is ErrorLogUpdates.
> This sends out an alert when a particular keyword is found in the error log.
> There are two parameters I can specify, INCLUDE keywords and EXCLUDE keywords.
> I have been taking a look at quiet a few of our error logs and not making
> any headway so far.
> Does anyone have any suggestions as to what I can put in INCLUDE list and
> EXCLUDE list of keywords to look for in SQL error log.
> Thanks in advance.
> Cheers.
> Kunal.
|||First, you really have to determine what you want to be alerted on. For
instance, we monitor all the SQL errors with severity 17 or higher, backup
failure, port binding failure, restarts, and so on. Each of rthese error
types has a certain patterns that you can use. Unfortunately, MS has not been
very good at keeping the error messages consistent on many dimensions, making
life somewhat difficult.
Anyway, for port binding failure for instance, you can look for the
following text string; "SuperSocket Info: Bind failed on TCP port", and for
severe SQL errors, you may want to enumerate all the patterns like "Severity:
17", replacing 17 with 18, 19, 20, and so on. Patrol has a perl like language
and should be very easy to specific a regular expression pattern here.
Linchi
"kunalap" wrote:

> Hello,
> We have Patrol monitoring running on our SQL Server 2000/2005 instances.
> One of the alerts for Patrol is ErrorLogUpdates.
> This sends out an alert when a particular keyword is found in the error log.
> There are two parameters I can specify, INCLUDE keywords and EXCLUDE keywords.
> I have been taking a look at quiet a few of our error logs and not making
> any headway so far.
> Does anyone have any suggestions as to what I can put in INCLUDE list and
> EXCLUDE list of keywords to look for in SQL error log.
> Thanks in advance.
> Cheers.
> Kunal.

monitoring sql error log for keywords

Hello,
We have Patrol monitoring running on our SQL Server 2000/2005 instances.
One of the alerts for Patrol is ErrorLogUpdates.
This sends out an alert when a particular keyword is found in the error log.
There are two parameters I can specify, INCLUDE keywords and EXCLUDE keywords.
I have been taking a look at quiet a few of our error logs and not making
any headway so far.
Does anyone have any suggestions as to what I can put in INCLUDE list and
EXCLUDE list of keywords to look for in SQL error log.
Thanks in advance.
Cheers.
Kunal.Hi
Products like MOM come with preconfigured scripts, therefore I would expect
the software vendor to supply this.
John
"kunalap" wrote:
> Hello,
> We have Patrol monitoring running on our SQL Server 2000/2005 instances.
> One of the alerts for Patrol is ErrorLogUpdates.
> This sends out an alert when a particular keyword is found in the error log.
> There are two parameters I can specify, INCLUDE keywords and EXCLUDE keywords.
> I have been taking a look at quiet a few of our error logs and not making
> any headway so far.
> Does anyone have any suggestions as to what I can put in INCLUDE list and
> EXCLUDE list of keywords to look for in SQL error log.
> Thanks in advance.
> Cheers.
> Kunal.|||First, you really have to determine what you want to be alerted on. For
instance, we monitor all the SQL errors with severity 17 or higher, backup
failure, port binding failure, restarts, and so on. Each of rthese error
types has a certain patterns that you can use. Unfortunately, MS has not been
very good at keeping the error messages consistent on many dimensions, making
life somewhat difficult.
Anyway, for port binding failure for instance, you can look for the
following text string; "SuperSocket Info: Bind failed on TCP port", and for
severe SQL errors, you may want to enumerate all the patterns like "Severity:
17", replacing 17 with 18, 19, 20, and so on. Patrol has a perl like language
and should be very easy to specific a regular expression pattern here.
Linchi
"kunalap" wrote:
> Hello,
> We have Patrol monitoring running on our SQL Server 2000/2005 instances.
> One of the alerts for Patrol is ErrorLogUpdates.
> This sends out an alert when a particular keyword is found in the error log.
> There are two parameters I can specify, INCLUDE keywords and EXCLUDE keywords.
> I have been taking a look at quiet a few of our error logs and not making
> any headway so far.
> Does anyone have any suggestions as to what I can put in INCLUDE list and
> EXCLUDE list of keywords to look for in SQL error log.
> Thanks in advance.
> Cheers.
> Kunal.

Monitoring Production Instances.

We will soon have 200 + production instances. In an effort to be more
pro active, I am looking for a way to monitor jobs, both failed and
long running, Disk space, and other such things like CPU load etc.
I would appreicate any suggestions you might have on accomplishing
this. For instance, is there anything in reporting services that might
help accomplish this ? Most of the instances are 2k, but we also have
some 2k5.
Best Regards
SGB(sgbergkam@.gmail.com) writes:
> We will soon have 200 + production instances. In an effort to be more
> pro active, I am looking for a way to monitor jobs, both failed and
> long running, Disk space, and other such things like CPU load etc.
> I would appreicate any suggestions you might have on accomplishing
> this. For instance, is there anything in reporting services that might
> help accomplish this ? Most of the instances are 2k, but we also have
> some 2k5.

I think you should look at MOM, Microsoft Operations Manager.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Monitoring Invalid Logins

I have a feeling someone is running a brute force password program against my
SQL Server. How can i see how many invalid attempts there was? And from which
IP Address? sp_monitor does not give me much information.
Thank you!
You can try a network sniffing utility like Network Monitor.
"DOTNETGUY" wrote:

> I have a feeling someone is running a brute force password program against my
> SQL Server. How can i see how many invalid attempts there was? And from which
> IP Address? sp_monitor does not give me much information.
> Thank you!
|||You can log failed logon attempts to the SQL Server log. Right-click the
server in Enterprise Manager and choose properties. Go to the security tab
and check the appropriate option under Audit level. Failure is I think the
default anyway. You can check the SQL Server logs, under the management
folder for the results.
From there you can see how many attempts there were, and against which
account, but that's about all the information you get. If you want more
information, you can set up a SQL Profiler trace, using the Audit Login
Failed Event.
Jacco Schalkwijk
SQL Server MVP
"DOTNETGUY" <DOTNETGUY@.discussions.microsoft.com> wrote in message
news:309EE9B2-BA33-4D7C-984E-4BA5934295C6@.microsoft.com...
>I have a feeling someone is running a brute force password program against
>my
> SQL Server. How can i see how many invalid attempts there was? And from
> which
> IP Address? sp_monitor does not give me much information.
> Thank you!
|||DOTNETGUY wrote:
> I have a feeling someone is running a brute force password program
> against my SQL Server. How can i see how many invalid attempts there
> was? And from which IP Address? sp_monitor does not give me much
> information.
> Thank you!
You can also set up a server-side trace and monitor the following event:
Security Audit: Audit Login Failed
David Gugick
Quest Software
www.imceda.com
www.quest.com

Monitoring Invalid Logins

I have a feeling someone is running a brute force password program against m
y
SQL Server. How can i see how many invalid attempts there was? And from whic
h
IP Address? sp_monitor does not give me much information.
Thank you!You can try a network sniffing utility like Network Monitor.
"DOTNETGUY" wrote:

> I have a feeling someone is running a brute force password program against
my
> SQL Server. How can i see how many invalid attempts there was? And from wh
ich
> IP Address? sp_monitor does not give me much information.
> Thank you!|||You can log failed logon attempts to the SQL Server log. Right-click the
server in Enterprise Manager and choose properties. Go to the security tab
and check the appropriate option under Audit level. Failure is I think the
default anyway. You can check the SQL Server logs, under the management
folder for the results.
From there you can see how many attempts there were, and against which
account, but that's about all the information you get. If you want more
information, you can set up a SQL Profiler trace, using the Audit Login
Failed Event.
Jacco Schalkwijk
SQL Server MVP
"DOTNETGUY" <DOTNETGUY@.discussions.microsoft.com> wrote in message
news:309EE9B2-BA33-4D7C-984E-4BA5934295C6@.microsoft.com...
>I have a feeling someone is running a brute force password program against
>my
> SQL Server. How can i see how many invalid attempts there was? And from
> which
> IP Address? sp_monitor does not give me much information.
> Thank you!|||DOTNETGUY wrote:
> I have a feeling someone is running a brute force password program
> against my SQL Server. How can i see how many invalid attempts there
> was? And from which IP Address? sp_monitor does not give me much
> information.
> Thank you!
You can also set up a server-side trace and monitor the following event:
Security Audit: Audit Login Failed
David Gugick
Quest Software
www.imceda.com
www.quest.com