Problems enabling SQL Server + Android remote access
Good afternoon I made a webservice in asp.net, and 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, making remote access enabled, however, I use Visual Studio's local bank and not SQL Server itself. How to proceed?
1 answers
First you have to see if you have any firewall blocking SQL Server (on your computer or server). Port 1433 is the default.
Then you have to go to SQL Server settings and set this option. Here is a good tutorial: http://blog.citrix24.com/configure-sql-express-to-accept-remote-connections /