I'm building an application that connects to a SQL Server 2008 database via connection string. The thing is, since the computer loading the app (or the user, in either case) is outside the Active Directory domain, I can't use Windows Authentication to connect to the DB. But when I include the database credentials, it won't let me connect either, telling me that since the computer logging in is from an untrusted domain, access is denied.
The connection string goes like this:
connectionString = "Data Source=" + ServerName + ";Initial Catalog=" + DatabaseName + _ ";Integrated Security=SSPI;User ID=" + UserID + ";Password=" + Pwd