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 |
|
KingCarlos
Yak Posting Veteran
74 Posts |
 Posted - 2010-12-06 : 17:37:30
|
| Hi there, I have an application that connects by default to a SQL database via Windows Authentication. In the environment the client uses they only support SQL authentication.How do I set up the end users PC to connect to the server using named pipes? |
|
|
KingCarlos
Yak Posting Veteran
74 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2010-12-06 : 18:16:08
|
| You can create an alias on each client that specifies named pipes. In the registry entry for the alias, it would say DBMSSOCN for TCP/IP. I don't recall the dll name for named pipes, but it's something like DBNMPTW. You can create aliases using SQL Server Configuration Manager, Client Network Utility, ODBC Data Sources, or directly in the registry. I've got detailed instructions in several threads at SQLTeam on how to do them, so please search for them.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
|
|
|
SQL Named Pipes