Connecting using shared memory

• Chris Chilvers

  SSCrazy

  Points: 2260

  More actions

  October 5, 2006 at 4:56 am

  #174611

  I have a laptop with sql server express installed. I am trying to run an .net application on this laptop but the application was connecting using tcp/ip, which ment if the network connection was lost it would lose the connection to the database (dispite the fact it was connecting to localhost).

  To try and solve this I tried the following connection string:

  server=.\express; trusted_connection=true; database=mine; network library=dbmslpcn;

  dbsmlpcn is the shared memory network library, but dispite telling the connection to use shared memory it continued to connect using tcp/ip. To prevent this I disabled all the network libraries except shared memory, rebooted, and tried again. This time it connect using named pipes (which is now disabled!).

  Any ideas on both why it is refusing to connect using shared memory, and how it is able to connect using a disabled protocol.