February 21, 2008 at 11:51 am
I want to preface with saying I am a total newbie at running stuff on SQL, so things might have to be explained...
I am trying to bcp a flat .txt file to my local machine. When I do so, I get the following errors in the output file:
SQLState = 08001, NativeError = 17
Error = [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.
SQLState = 01000, NativeError = 1703
Warning = [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).
I (along with our system support) cannot figure out why this is occurring - I cannot fathom that I cannot connect to my own machine!!!
Please help me!!!!
February 21, 2008 at 12:09 pm
You want to make sure to take a trip through the "SQL Surface Area Configuration" tool. Look for the tab relating to "remote connections", and turn on TCP/IP. In this case, remote = anything other than SQL Server itself....
Also - try making sure that the SQL Browser service is started.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply