SQL server connection Error in SQL 2008 - "Cannot connect to PC." RRS feed

  • Question

  • Hi,

    I tried everything while installing sql server 2008 express in my Windows 7PC but i am still not able to connect to server.I always get this error when i try to connect to sql server through management studio - "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)(Microsoft SQL Server Error:2)"

    Steps taken to resolve issue but still unresolved :

    1.Upgraded my Visual studio 2008 to SP1.

    2.upgraded framework to 4.5

    3.Made TCP port 1433.

    4.All instances were made Enabled in configuration Manager

    5.Made firewall exception for sqlserver file.

    All the above didn't help me to connect to SQL server 2008.Every time i am getting the same error.

    Note : While installing SQL Server 2008 i do not get any error.

    Please guide what i am doing wrong & what should be done to make it work !!!!!!?

    Sunday, December 23, 2012 10:13 AM


All replies