BCP install

Hi,

I need to have on a client machine the bcp.exe installed. What components do I need to install from SQL Server 2005. I would like to have the absolute minimal installed on this machine.

Thanks.

Solved the problem:

download the SQLEXPR_TOOLKIT.EXE and installed only the connections component.

Baster fix on win2000

Dear,
I install the Baster fix on win2000 server laster saturday,
After the fix install, the SQL agents can't start use NT
domain account. It can start only local system account. I
try to un-install the Baster fix but still not work. How
can i resume the agents that run on domain account?
Thanks
JohnYES, Please Help
John
>--Original Message--
>are you talking about MS03-026?
>"John" <acos3ltd@.yahoo.com.hk> wrote in message
>news:07d801c36af3$947d1b50$a301280a@.phx.gbl...
>> Dear,
>> I install the Baster fix on win2000 server laster
saturday,
>> After the fix install, the SQL agents can't start use NT
>> domain account. It can start only local system account.
I
>> try to un-install the Baster fix but still not work. How
>> can i resume the agents that run on domain account?
>> Thanks
>> John
>
>.
>

basic Server setup and user accounts

I have just installed SQL server 2005 standard edition - how do I create a
basic server and user accounts in order to then install Project Server?
Hi
Project Server is not yet officially certified to run with SQL 2005.
Postings in the project server news groups discuss how you can work around
this to get it working, but you should not use this on a production system
http://www.microsoft.com/office/comm...=&sloc=en -us
http://blogs.lv0.net/mpatest/archive...11/18/182.aspx
John
"Steve Scott" wrote:

> I have just installed SQL server 2005 standard edition - how do I create a
> basic server and user accounts in order to then install Project Server?

basic Server setup and user accounts

I have just installed SQL server 2005 standard edition - how do I create a
basic server and user accounts in order to then install Project Server?Hi
Project Server is not yet officially certified to run with SQL 2005.
Postings in the project server news groups discuss how you can work around
this to get it working, but you should not use this on a production system
http://www.microsoft.com/office/com...exp=&sloc=en-us
http://blogs.lv0.net/mpatest/archiv.../11/18/182.aspx
John
"Steve Scott" wrote:

> I have just installed SQL server 2005 standard edition - how do I create a
> basic server and user accounts in order to then install Project Server?

basic Server setup and user accounts

I have just installed SQL server 2005 standard edition - how do I create a
basic server and user accounts in order to then install Project Server?Hi
Project Server is not yet officially certified to run with SQL 2005.
Postings in the project server news groups discuss how you can work around
this to get it working, but you should not use this on a production system
http://www.microsoft.com/office/community/en-us/default.mspx?query=SQL+2005&dg=microsoft.public.project.server&cat=en-us-microsoftproject&lang=en&cr=US&pt=a1d023a3-f612-4da2-acb8-fda8f850d645&catlist=&dglist=&ptlist=&exp=&sloc=en-us
http://blogs.lv0.net/mpatest/archive/2005/11/18/182.aspx
John
"Steve Scott" wrote:
> I have just installed SQL server 2005 standard edition - how do I create a
> basic server and user accounts in order to then install Project Server?

Basic Security

I am trying to understand the basic security that RS uses.
During install, a userid is used to install/create the databases. That
userid is then tied to the basic services, like scheduling etc...
Is this correct?
Are all services using that first-supplied ID?
After that when users run a report with a connection that has the
credentials stored, are those the credentials used for the database
access?
I am currently using RS and have 2 shared connections (one to live dB
and one to Test dB), both with stored credentials. Is is safe to assume
that any report activity using that connection will show that userid?
I just want to make sure I can track down problems when they arise.
Thanks.The credentials you supply when you install RS are completely seperate from
the connections you use in your reports. They are only used so that the
report server can talk to the reportserver (metadata) database. A report
that is using stored credentials will use those credentials independent of
the setup credentials.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"John Geddes" <john_g@.alamode.com> wrote in message
news:eX2q$NR7EHA.4040@.TK2MSFTNGP14.phx.gbl...
>I am trying to understand the basic security that RS uses.
> During install, a userid is used to install/create the databases. That
> userid is then tied to the basic services, like scheduling etc...
> Is this correct?
> Are all services using that first-supplied ID?
> After that when users run a report with a connection that has the
> credentials stored, are those the credentials used for the database
> access?
>
> I am currently using RS and have 2 shared connections (one to live dB and
> one to Test dB), both with stored credentials. Is is safe to assume that
> any report activity using that connection will show that userid?
> I just want to make sure I can track down problems when they arise.
> Thanks.
>