sql server - underlying provider failed on open Error in Asp.Net MVC 4 Application -

sql server - underlying provider failed on open Error in Asp.Net MVC 4 Application -

i getting error saying underlying provider failed on open error in asp.net mvc 4 application when seek query database using entityframework

here connectionstring

<connectionstrings> <add name="=resultscontext" connectionstring="data source=127.0.0.1,13874; initial catalog= mysampleapplication; user id=sa; password=password; integrated security=false;" providername="system.data.sqlclient" /> </connectionstrings>

i have tested connection using x.udl file. able found connection successfully.

where mvc4 application unable open connection. might issue.

i have tried other possibilities posted in stackoverflow same kind of questions. gives me no luck.

is database server on same machine web server?

if not problem part

...data source=127.0.0.1,13874;...

another problem log in restrictions sa account.

sql-server database asp.net-mvc-4