Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ronin2307
Posting Yak Master
126 Posts |
 Posted - 2007-08-14 : 12:39:13
|
| i have to admit I am not that familiar with named pipes, but i do have an issue with them that I would like to understand a bit better.I installed the SQL 2005 express version on a machine and using a express manager i tried connecting to the instance i just installed. However i was getting an error message referencing the NAMED PIPES. after hours of trying to figure out what the problem was i found that using the SQL Server COnfiguration Manager, under the SQL Server 2005 Network Configuration there is a node called Protocols for SQLEXPRESS. there are four protocols, one of which is the NAMED PIPES. Under the properties for this protocol there is the PIPE NAME which is what i had to change to "\\.\pipe\sql\query". the default was longer and if i remember it correctly it was something like "\\.\pipe\MSSQLSERVEREXPRESS\sql\query".Once i made that change i was able to connect. Can somebody please explain to me what I have done (i can't find the article that lead me to this) and if there is any way to make this change in some sort of a script or something.reason being is that I have an VB app that deploys the SQL 2005 express version as well and i would like to eliminate this step from the user to configure before using the app.many thanx |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2007-08-14 : 13:04:59
|
| I have never used named pipes, but always use TCP/IP |
 |
|
|
ronin2307
Posting Yak Master
126 Posts |
Posted - 2007-08-14 : 13:16:51
|
| i don't even know why or how i am using named pipes. all i did was accept the defaults in the installation. no idea why it is using named pipes or how to change that |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-14 : 22:18:36
|
| Did you specify correct instance name when connect to it? Shouldn't change pipe name. If you want to use tcp/ip only, just disable named pipes on the server. |
|
|
|
ronin2307
Posting Yak Master
126 Posts |
Posted - 2007-08-15 : 09:00:12
|
| i never set any name for the instance so it should be the default one. therefore i don't understand why i would have to change the pipe name to make it connect |
|
|
|
|
|
|
named pipes question