Problems to enable remote access SQL Server + Android

1

Good afternoon I made a webservice in asp.net, and I need to access it through an android application. In any normal function, it works normally, but if it is some function that has access to the database, it causes the following error:

  

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.

After some research, I saw that I had to enable an option in SQL Server Management, causing remote access to be enabled, however, I use the local Visual Studio database and not the SQL Server itself. How to proceed?

    
asked by anonymous 27.01.2016 / 20:07

1 answer

2

First you have to see if you have any firewall blocking SQL Server (either on your computer or on the server). Port 1433 is the default.

Then you have to go to the SQL Server settings and set this option. Here's a good tutorial: link

    
28.01.2016 / 22:23