Running both 2000 & 2005 ?

Is it possible to run SqlServer 2000 & 2005 on the same Server? We're
only a small company with 1 server, and we'd like to try 2005 without
losing access to our 2000 databases.Jon
Yes , it is.
"Jon Brunson" <JonBrunson@.NOSPAMinnovationsoftwareDOTcoPERIODuk> wrote in
message news:egCB1uJAGHA.3296@.TK2MSFTNGP12.phx.gbl...
> Is it possible to run SqlServer 2000 & 2005 on the same Server? We're only
> a small company with 1 server, and we'd like to try 2005 without losing
> access to our 2000 databases.|||Hi
Yes, they are supported side-by-side. The 2nd instance has to be a named
instance "servername\instancename", but otherwise, the 2 reside happily
together.
Don't forget, since you have 2 DB engines on 1 server, they have to share
resources, including RAM, so don't expect both to run at 100% if you are
beating both hard.
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/
"Jon Brunson" <JonBrunson@.NOSPAMinnovationsoftwareDOTcoPERIODuk> wrote in
message news:egCB1uJAGHA.3296@.TK2MSFTNGP12.phx.gbl...
> Is it possible to run SqlServer 2000 & 2005 on the same Server? We're only
> a small company with 1 server, and we'd like to try 2005 without losing
> access to our 2000 databases.|||Thank-you Mike & Uri for your prompt (and unexpected!) replies.
Mike Epprecht (SQL MVP) wrote:
> Hi
> Yes, they are supported side-by-side. The 2nd instance has to be a named
> instance "servername\instancename", but otherwise, the 2 reside happily
> together.
> Don't forget, since you have 2 DB engines on 1 server, they have to share
> resources, including RAM, so don't expect both to run at 100% if you are
> beating both hard.
> 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/
> "Jon Brunson" <JonBrunson@.NOSPAMinnovationsoftwareDOTcoPERIODuk> wrote in
> message news:egCB1uJAGHA.3296@.TK2MSFTNGP12.phx.gbl...
>>Is it possible to run SqlServer 2000 & 2005 on the same Server? We're only
>>a small company with 1 server, and we'd like to try 2005 without losing
>>access to our 2000 databases.
>
>

Running BCP from a webserver

I am executing BCP within a web application. SQL Server
client is not installed on the web server there although
we have copied the BCP.exe and BCP.RLL, an error message
displays saying it is missing the Resource Library. What
are my options to get this work?
Robert Complusman (anonymous@.discussions.microsoft.com) writes:
> I am executing BCP within a web application. SQL Server
> client is not installed on the web server there although
> we have copied the BCP.exe and BCP.RLL, an error message
> displays saying it is missing the Resource Library. What
> are my options to get this work?
The simplest would be to run the SQL Server install on the web server,
and install "Tools and utilities only". Now, whether this is
compliant with your license, I don't know.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
|||Hi
Maybe you would be better using Bulk Insert?
You may also want to consider using a DTS job to get (FTP) the file and put
it onto a different server, then process it.
John
"Robert Complusman" <anonymous@.discussions.microsoft.com> wrote in message
news:1974701c44cc6$df510140$a001280a@.phx.gbl...
> I am executing BCP within a web application. SQL Server
> client is not installed on the web server there although
> we have copied the BCP.exe and BCP.RLL, an error message
> displays saying it is missing the Resource Library. What
> are my options to get this work?
sql

Running batches of reports

Hi,
we are making an interesting use of report services...we are actually
using it to generate programming specification for Informatica Mappings
from our mapping spreadsheets..LOL!!
Anyway, we have a couple of hundre mapping specifications and we want
to generate the couple of hundred PDFs associated with those
mappings...I recall reading in my hitchhikers guide how to do this but
that book is about 1,500 miles away from me at the moment.
Would anyone be kind enough to please share the command I need to enter
at the command line to run a report with specific parameters and spit
the output into a specific PDF file also specified as a parameter. I'd
be ever so grateful to not have to wait a few days to go home and read
my book!!
Thanks
Peter
www.peternolan.comHi All,
I got somewhere on this.....if I export and save I get this on the
address line of the browser...
http://ger-eutst/ReportServer?%2fIDW+Reports%2fMetadata%2fMIN0102A+-+Infa+Mappings+Detailed+Documentation&spreadsheet_name=StagingToODSMappingOAP&spreadsheet_version=V00.14&mapping_name=m_ODS_MTL_DEMAND&rs%3aCommand=Render&rs%3AFormat=PDF
So, surely there is some way to enter some kind of similar command via
a command line or via an vb.net program to capture a list of such
pdsf....
Anybody done this before?
Thanks
Peter
www.peternolan.com

Running bat files in SSIS

Folks -

Did you have any success when running bat files (Execute Process Task) from SSIS through SQL Server Agent jobs? My package will succeed when I run it from my machine, when I ask the DBA to run it manually from the Server but not when we run from a job.

The job will hang and the bat file does not seem to be executed. The executable property does evaluate to the right path and the package owner does have write/execute permissions in the folder where the bat file is located.

Everything I could find close to that is under <http://support.microsoft.com/kb/918760>. Would you shed any light on this? When I run the same bat file from a DTS through SQL Server Agent job, it will work with no issues. Any help would be very much appreciated.

Thanks.

Does the batch file have any prompts that require user input?|||

What is SQL Agent Service account running with?

Is it the same account that you are your DBA use - when running the package manually?

Because when you run the job - it runs with the credential of SQL Agent account.

|||Phil, thxs 4 your reply. No prompts that will require user input. The bat file will do a ftp. Thanks again.|||

How do I check what is SQL Agent Service account running my job? I know when I run the pkg manually it will run under my ID.

I do own the SQL Agent job in the Development environment so the DBA told me that my ID should be trying to execute the bat file (as I said before my ID has the permissions so there is something very strange happening). She said when I move to MO it will be owned by SA.

I can't go to MO if it is not working in DEV

Thanks for your reply.

|||If you are using the SSIS job step to run the package, it runs under the service account that the Agent is set up to use, not the job owner's account. Try setting up a proxy account - check books online for details.|||

Hi,

It's simple. Use an Execute Process Task.

Double Click the Task, Under Process Tab, set the values for the following properties:

1) Executable = cmd.exe

2) Arguments = /c C:\BatchFolder\MyFile.bat.

Make Sure when you run the job, The Service account that runs your job should have access to this batch file.

Thanks

Subhash Subramanyam

|||

Jwelch -

There is a proxy account set by the DBA already... When we add a step to a job, for type we do "Operating system (CmdExec)" and for run as we do "SQLAgentJobProxy".

So... Do you believe this proxy account is the one with no access to run the bat file?

Thanks.

|||

That would be my guess.

Also, is the bat file located on a local drive, network share with UNC path, or a mapped drive?

|||Network share with UNC path.|||Might try copying it locally and see if that makes a difference.|||

I don't have Integration Services installed locally. I will check with the DBA on the permissions mentioned here and I will let you guys know.

Thanks.

|||

Folks,

The feedback I had from my DBA was that the SQLAgentProxyAccount does have access to execute the bat file in question... This is proved when I run a dts through the same job and the same bat file is fired successfully. She also agreed that the Executable Property in the Execute Process Task step was evaluating correctly.

So, our work-around was to remove the bat file execution from the SSIS pkg and add it to the second step of the job. Dirty and scary if you think that the ftp might not be the last step of a whole process. In my case, thanks to God it is... But since we have lack of time right now, this is the solution we put in place.

I would say the issue is still not clarified but I will mark this as closed and if somebody in the future runs into the same problem a new thread could be opened.

Thanks to all.

Running bat files in SSIS

Folks -

Did you have any success when running bat files (Execute Process Task) from SSIS through SQL Server Agent jobs? My package will succeed when I run it from my machine, when I ask the DBA to run it manually from the Server but not when we run from a job.

The job will hang and the bat file does not seem to be executed. The executable property does evaluate to the right path and the package owner does have write/execute permissions in the folder where the bat file is located.

Everything I could find close to that is under <http://support.microsoft.com/kb/918760>. Would you shed any light on this? When I run the same bat file from a DTS through SQL Server Agent job, it will work with no issues. Any help would be very much appreciated.

Thanks.

Does the batch file have any prompts that require user input?|||

What is SQL Agent Service account running with?

Is it the same account that you are your DBA use - when running the package manually?

Because when you run the job - it runs with the credential of SQL Agent account.

|||Phil, thxs 4 your reply. No prompts that will require user input. The bat file will do a ftp. Thanks again.|||

How do I check what is SQL Agent Service account running my job? I know when I run the pkg manually it will run under my ID.

I do own the SQL Agent job in the Development environment so the DBA told me that my ID should be trying to execute the bat file (as I said before my ID has the permissions so there is something very strange happening). She said when I move to MO it will be owned by SA.

I can't go to MO if it is not working in DEV

Thanks for your reply.

|||If you are using the SSIS job step to run the package, it runs under the service account that the Agent is set up to use, not the job owner's account. Try setting up a proxy account - check books online for details.|||

Hi,

It's simple. Use an Execute Process Task.

Double Click the Task, Under Process Tab, set the values for the following properties:

1) Executable = cmd.exe

2) Arguments = /c C:\BatchFolder\MyFile.bat.

Make Sure when you run the job, The Service account that runs your job should have access to this batch file.

Thanks

Subhash Subramanyam

|||

Jwelch -

There is a proxy account set by the DBA already... When we add a step to a job, for type we do "Operating system (CmdExec)" and for run as we do "SQLAgentJobProxy".

So... Do you believe this proxy account is the one with no access to run the bat file?

Thanks.

|||

That would be my guess.

Also, is the bat file located on a local drive, network share with UNC path, or a mapped drive?

|||Network share with UNC path.|||Might try copying it locally and see if that makes a difference.|||

I don't have Integration Services installed locally. I will check with the DBA on the permissions mentioned here and I will let you guys know.

Thanks.

|||

Folks,

The feedback I had from my DBA was that the SQLAgentProxyAccount does have access to execute the bat file in question... This is proved when I run a dts through the same job and the same bat file is fired successfully. She also agreed that the Executable Property in the Execute Process Task step was evaluating correctly.

So, our work-around was to remove the bat file execution from the SSIS pkg and add it to the second step of the job. Dirty and scary if you think that the ftp might not be the last step of a whole process. In my case, thanks to God it is... But since we have lack of time right now, this is the solution we put in place.

I would say the issue is still not clarified but I will mark this as closed and if somebody in the future runs into the same problem a new thread could be opened.

Thanks to all.

Running Backup through Maintenance Plan

I am receiving an Event 208 when running our autmated backup in Enterprise
Manager. The job use to run fine however possibly a change in password
caused this to stop working? The error states:
Event Type:Warning
Event Source:SQLSERVERAGENT
Event Category:Job Engine
Event ID:208
Date:11/21/2006
Time:8:45:00 AM
User:N/A
Computer:CROMWELL-DBPROD
Description:
SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'DB
Maintenance Plan1'' (0x8E8A44BEA81D964CAAF7E3F3338674D3) - Status: Failed -
Invoked on: 2006-11-21 08:45:00 - Message: The job failed. The owner () of
job DB Backup Job for DB Maintenance Plan 'DB Maintenance Plan1' does not
have server access.
How can I become owner of this job?
Check the properties for the job named
DB Backup Job for DB Maintenance Plan 'DB Maintenance Plan1'
and change the owner to your login if you want to be the
owner.
-Sue
On Tue, 21 Nov 2006 06:57:02 -0800, Andrew Harlan
<AndrewHarlan@.discussions.microsoft.com> wrote:

>I am receiving an Event 208 when running our autmated backup in Enterprise
>Manager. The job use to run fine however possibly a change in password
>caused this to stop working? The error states:
>Event Type:Warning
>Event Source:SQLSERVERAGENT
>Event Category:Job Engine
>Event ID:208
>Date:11/21/2006
>Time:8:45:00 AM
>User:N/A
>Computer:CROMWELL-DBPROD
>Description:
>SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'DB
>Maintenance Plan1'' (0x8E8A44BEA81D964CAAF7E3F3338674D3) - Status: Failed -
>Invoked on: 2006-11-21 08:45:00 - Message: The job failed. The owner () of
>job DB Backup Job for DB Maintenance Plan 'DB Maintenance Plan1' does not
>have server access.
>
>How can I become owner of this job?

Running Backup Jobs

Hi everyone
I have a SQL Server 2005. On this server is a database that only a handfull
of users may access - This excludes the normal IT people such as Domain
Admins etc. Only problem is that if I remove BuiltIn\Administrators from the
sysadmin server role I am no longer able to do backups of the database. If I
leave the BuiltIn\Administrator in the SysAdmin role they can access the
database.
Any help would be appriciated.
Thanks.
Regards
JonasJonas
By default all members of Administrators group have login SQL Server .
What is an account SQL Server Agent running under? Is it Local Account?
Create a user domain account/group on the box SQL Server running on. Change
Sql Server Agent's/MSSqlService account to this new one but make sure that
this account has an appropriate permissions to access the network
"Jonas Larsen" <JonasLarsen@.discussions.microsoft.com> wrote in message
news:C06D17CC-95A2-48A3-BFD7-6288CA2918BE@.microsoft.com...
> Hi everyone
> I have a SQL Server 2005. On this server is a database that only a
> handfull
> of users may access - This excludes the normal IT people such as Domain
> Admins etc. Only problem is that if I remove BuiltIn\Administrators from
> the
> sysadmin server role I am no longer able to do backups of the database. If
> I
> leave the BuiltIn\Administrator in the SysAdmin role they can access the
> database.
> Any help would be appriciated.
> Thanks.
> Regards
> Jonas|||Thanks for that. The Agent was running Local System, changed that as
suggested and then removed builtin admin from the sysadmin role. Everything
works.
"Uri Dimant" wrote:

> Jonas
> By default all members of Administrators group have login SQL Server .
> What is an account SQL Server Agent running under? Is it Local Account?
> Create a user domain account/group on the box SQL Server running on. Chan
ge
> Sql Server Agent's/MSSqlService account to this new one but make sure that
> this account has an appropriate permissions to access the network
>
>
> "Jonas Larsen" <JonasLarsen@.discussions.microsoft.com> wrote in message
> news:C06D17CC-95A2-48A3-BFD7-6288CA2918BE@.microsoft.com...
>
>sql