Pages

Banner 468 x 60px

 

Sunday, 9 September 2012

A network-related or instance-specific error occurred while establishing a connection to SQL Server


After install SQL server 2008 in my machine I try to connect sql server using my machine IP Address in that time I got error 
                                                                                                    
TITLE: Connect to Server
Cannot connect to xxx.xxx.xxx.xxx
ADDITIONAL INFORMATION:
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) (Microsoft SQL Server, Error: 5)



Now I will explain How to solve the error by step by step
Step 1
            Click start-> All Program->Microsoft SQL Server 2008->Configuration Tools->click on SQL Server Configuration Manager

 Expand SQL Server Network Configuration Double click Protocols for SQLEXPRESS and Right click on t TCP/IP and select Enable
It will ask you to restart SQl server

Already I will explain How to restart the SQL server in following post

The project type is not supported by this installation

When I try open MVC project developed from MVC3 Frame work From Visual studio 2010 with Mvc 4 Frame work, I will got error " The project type is not supported by this installation"

In This post I will explain How to solve this problem.

First up all we will saw why this error is occur

        When we install VS 2010 in our machine MVC 2 is default install in our system. So By default We can only develop MVC2 project using VS 2010.
The Microsoft Asp.Net folder looks like bellow

For my developing purpose I install MNC4 in my machine so the Microsoft Asp.Net folder looks like bellow


Then I will down Load sample MVC 3 project from Internet and try to open the project in VS 2010,In that time I will got the following error “The project type is not supported by this installation” because I did not install Mvc 3 in My machine. So try to install MVC3 in my machine after that I try to open the Mvc 4 project in VS 2010.It will open the project without saying any error.