Web Development

Ask something
Discussion Locked

Sql Server

0 helpful
3 replies

by pardarling

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Dear sirs,
I want to use bcp utility with my sql server.
But I recive this erroe :

C:\>bcp "SELECT * FROM ntxeon2.ntinetlog.dbo.X3Usrdetail ORDER BY Clientusername
" queryout 'd:\logx3.txt' -c -S NTXEON2 -U sa -P xeon2_admin
SQLState = 37000,NativeError = 7411
Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Server 'ntxeon2' is not c
onfigured for DATA ACCESS.

I wnat to to know how can I confugure my server fot DATA ACCESS ?

Regard

3 replies

by lw

have you tried not specifying the server name in the object. i.e.

bcp "SELECT * FROM ntinetlog.dbo.X3Usrdetail ORDER BY Clientusername
" queryout 'd:\logx3.txt' -c -S NTXEON2 -U sa -P xeon2_admin

It sounds like SQL thinks NTXEON2 is a linked server, which presumably it is not (although you can link a server to itself if you want)

This discussion is closed to new replies.