Clever Geek Handbook

Best approach to connect to SQL Server from a non-domain web host

I want to connect to SQL Server using a domain account from a web host that is NOT on the domain. This is a common ASP.NET vanillin web application. This out-of-domain site hits Reporting Services using domain credentials and I don't know why this is invalid for SQL connections.

We have many backend applications (win form and web form) and this is the latest version to convert to integrated security, so we can manage permissions through the system via AD, but if I need to do it in SQL then I can accept defeat.

Has anyone figured out how to do this or is it just not possible?

+3


source to share


2 answers


Join a SQL Server 2005 domain from a non-domain machine and later, but this requires you to be able to join the domain from a remote computer.



You can connect to Reporting Services using domain credentials because it uses NTLM for Windows Integrated Authentication, which is HTTP authenticated. Direct connections to SQL Server do not use HTTP, so this type of authentication is not available.

0


source


You will need to join a SQL block in the web application domain or vice versa, or create trusts between domains

runas /netonly /user:domain\username "c:\path\ssms.exe"


have a look here: http://www.mssqltips.com/sqlservertip/3250/connect-to-sql-servers-in-another-domain-using-windows-authentication/

0


source






More articles:


All Articles