Home Forums SQL Server 2008 SQL Server Newbies Cannot connect to (server name) after sql server 2008 installation RE: Cannot connect to (server name) after sql server 2008 installation

  • When you have installed your SQL Server instance , I hope that you are kept the name of your instance as you have to use it in the Server name box.

    It seems that you have a named pipe problem according the error message ( if my remembrance is good , it is the default choice ). If your SQL Server is installed on your own laptop, you may use the connection form to get access to information not provided in this connection form by clicking on the 4th button ( at the right side ) labeled "Options>>".

    But before the use of this button , I would suggest to click on the little arrow at the right end of the Server name ComboBox and select the last choice ( <Brows for more...> ). After some seconds , you will see the correct name of your local instance ( I suppose that you have only one local instance ). Select it and try to connect.

    You may change the network protocol by clicking on the button labeled "Options>>" . You will arrive on the Options tab and for the network protocol "Shared Memory" which avoids some problems with Named Pipes protocol which is the "default" protocol . Be careful , you cannot used Shared Memory to connect to an instance which is not local.

    You should try to use the SQL Server Configuration Manager to verify the network protocols which are enabled and whether your instance is started.

    Don't hesitate to post again for more help or explanation.