1

I am not a SQL Server admin. I have tried to google this but can't seem to use the right words to get the right info and they all talk about remote connections to a SQL Server in terms of admin and remote access.

I have a database on one domain, that needs to accept connections and queries etc... from web code (page) I am hosting on another domain. I am using Windows 2012 servers on AWS in the case of both domains, and I have port 1433 opened on the domain server with the database, but open only to the ip address of this other domain. The SQL Server is using the default windows based auth.

Can someone tell me where to find a guide to set up the SQL Server to accept these external requests with a proper user name and password ?

migrated from stackoverflow.com Nov 18 '15 at 16:47

This question came from our site for professional and enthusiast programmers.

  • 1
    Does your domain trust the other domain? If not then there really isn't a way to do it. I would configure the SQL Server to use Windows and SQL Authentication and then create an account for the web server to use. – Jonathan Fite Nov 18 '15 at 16:54
1

It depends on what you mean by a proper user name and password.

Windows Authentication

You will need to setup the Domain trust relationship between each domain. Your domain hosting the database server will need to trust the domain holding the web application. This should allow the domain accounts access the web application can connect to the database server, without having to use a separate account.

SQL Login

If you do not want to deal with the domain relationship you can simple configure SQL Server in mixed mode. You can find those instructions here. You would just create a SQL Login and grant the required access to the database(s) for the web application.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy