discussion on protocol Name

• luckysql.kinda

  SSCertifiable

  Points: 7816

  More actions

  August 28, 2009 at 4:10 am

  #209280

  Hello All,

  I want a discussion on protocol Name which we use to connect to the sql server. There are four

  1. Shared Memory 2. Named Pipes 3. TCP/IP 4. VIA

  I have sql server 2008 developer edition installed on my local m\c. I connect to this from my local m\c only.

  Now I should need only Shared Memory protocol according to theory. But this is not getting connected. I have to enable TCP/IP and then I could connect this. The reason can be that I changed my system name yesterday.

  select @@servername--------------------> LK-PC\MSSQLSERVERDEV

  SELECT SERVERPROPERTY('SERVER')--------> NULL

  Eventhough I tried following query and restarted the server but the issue is same.

  sp_dropserver 'LK-PC\MSSQLSERVERDEV'

  sp_addserver 'LuckyPC',local

  -LK