<div>
First try to connect to the database with Query Analyzer to make sure your UserID and Password is correct and working fine.<br />
Then<br />
If you are running the BCP command on the server itself then you don't need to use -S parameter if not then use it but it is advisable to use -S parameter all the time...<br />
<br />
Try the following code...<br />
<br />
bcp &quot;DBname.dbo.view for horizon&quot; out &quot;c:\mytest.txt&quot; -SServerName -c -t, -U &quot;user&quot; -P &quot;pw&quot;
</div>


First try to connect to the database with Query Analyzer to make sure your UserID and Password is correct and working fine.
Then
If you are running the BCP command on the server itself then you don't need to use -S parameter if not then use it but it is advisable to use -S parameter all the time...

Try the following code...

bcp "DBname.dbo.view for horizon" out "c:\mytest.txt" -SServerName -c -t, -U "user" -P "pw"

<div>
same result - the user definitely has rights...<br />
&nbsp;<br />
I tried sql authentication and windows authentication account - neither worked.<br />

</div>


same result - the user definitely has rights...
 
I tried sql authentication and windows authentication account - neither worked.


<div>
Did you try to connect with Query analyser?<br />
Are you connecting locally if not try it on the server using Query analyzer...
</div>


Did you try to connect with Query analyser?
Are you connecting locally if not try it on the server using Query analyzer...

<div>
Make sure the Login has the access to the database.
</div>


Make sure the Login has the access to the database.

<div>
<div class="content wysiwyg-content">
BCP will not work - I can not get a connection - any thoughts?<br />
<br />
bcp &quot;server.dbo.view for horizon&quot; out &quot;c:\mytest.txt&quot; -c -t, -U [user] -P [pw]<br />
<br />
The user is a a SQl server suthentication account with read access from the view.<br />
<br />
SQLState = 37000, NativeError = 4060<br />
Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database requ<br />
ested in login 'server'. Login fails.
</div>
</div>


BCP will not work - I can not get a connection - any thoughts?

bcp "server.dbo.view for horizon" out "c:\mytest.txt" -c -t, -U [user] -P [pw]

The user is a a SQl server suthentication account with read access from the view.

SQLState = 37000, NativeError = 4060
Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database requ
ested in login 'server'. Login fails.

BCP  [view] out c:\whatever.txt -c -t, -U [cred] -P[pw] not working

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.