cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Unable to access MsSql databse in codefirst approach of c# MVC

Hi,

 

I have a c# MVC application, which involves the use of MSsql database. This application works perfectly fine in my localhost.  I am using CodeFirst approach in my code.

When I deployed the application to my server today, I am getting the following error as soon as the code encounters Database in the code. 

 

 

[SqlException (0x80131904): 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: SQL Network Interfaces, error: 52 - Unable to locate a Local Database Runtime installation. Verify that SQL Server Express is properly installed and that the Local Database Runtime feature is enabled.)]

 The connection string I am using is : 

Data Source=184.168.194.78;Integrated Security=False;User ID=********;Password=***********;

 

Capture.JPG