Re: BCP Usage with SQL Server 2005 Clustered Server

This syntax "appears" to work...

bcp [sqlcls1dev\inst2005dev].[BusinessContacts].[Branch] format -x -T
-fc:\temp\myfile.xml

However, I get a connection timeout error that also states that the SQL
Server 2005 by default doesn't allow remote connections. But, I see
that this server does allow remote connections in the options. I am
logged into the box using Win authent and my Win acct has sysadmin
privileges on the sql server instance. Any information would be
appreciated.

-ak

Ayron wrote:
How can I use BCP to create an XML format file on a SQL Server 2005
cluster that has multiple instances of SQL Server running? Is there
some sample syntax, etc.?

Thx.

-ak

.

Relevant Pages

  • Re: administering new installation of MS SQL Server 2005
    ... By default SQL 2005 express doesnt allow remote connections to it. ... You can do that through SQL Server ... be able to access remotely are the Workgroup edition and the developer ...
    (microsoft.public.sqlserver.setup)
  • Re: access cmd to sql server "grant insert on.."
    ... You need to create a SPT query. ... This uses the syntax of the SERVER. ... Ditto for SQL Server. ...
    (microsoft.public.access.externaldata)
  • Re: Running a Store procedure from DAO
    ... in which you have coded the Server Database's SQL ... That SQL Syntax will differ from server DB to server DB. ... my work into the on-site database that had a back end Informix database, ...
    (microsoft.public.access.modulesdaovba)
  • Re: Accessing MS Access and SQL Server from VB 6
    ... Best way to avoid any syntax issues is to use stored procedures in a SQL ... Server and stored queries in a Access. ...
    (microsoft.public.vb.database.ado)
  • Re: SQL Server 2005 Express Connection
    ... Both of them can connect to the remote SQL Server 2005 database ... that under the default settings SQL Server does not allow remote connections. ...
    (microsoft.public.sqlserver.connect)
Loading