I have read one two three related threads but im not clear if SQL Server 2008 needs TCP/IP to make this work. Can it not accomplish with a pipe? I would prefer not to open up the machine to the internet just to test my development machine Win7 and the server WS2008R2 for testing model and ETL performance.
My app uses a connection string:
Driver={SQL SERVER}; SERVER=myserver; Database=test; Uid=mike; Pwd=password;
but i get "dialog error" returned from ODBC (C++)
I found a nice tutorial on setting up TCP/IP but is this the answer?
ADDED:
OK well I began with this article which says:
"The shared memory protocol cannot be enabled for remote connections."
After enabling TCP/IP and VIA (whatever that is) I was instructed to restart the server.
Using Cinfiguration managere and then a restart, the service "SQL Server (MSSQLSERVER)" will not start….
Server log shows
"THE SQL Server failed to intialize VIA support library ..indicates library does not exist"
Is VIA required as this article suggests?
ADDED:
No it isnt! Follow the instructions here and use the connection string above and you will be good. Sheesh what a pain. I wasted 12 hours on this simple stuff, so if you feel this question saved you that much time, please feel free vote it up.
Best Answer
TCP/IP is required for you to use a TCP network to connect to a SQL Server. You do not have to use a network to connect to the server if you are connecting from the same machine. If you do use a network you do not have to use the Internet. Most modern networks use a protocol called IP - this includes the largest public network known as the Internet. TCP is a protocol build on top of IP that is used to provide additional features on top of IP which are very handy for doing things across a network - like connecting to a database.
TCP: http://en.wikipedia.org/wiki/Transmission_Control_Protocol Internet: http://en.wikipedia.org/wiki/Internet