I have a sql server db that works fine when I connect via the internet but when I try to connect after disconnecting from the network it doesn't find the database.
Is there something wrong with my connection string? Could it be the Windows/SQL Server/Mixed Authentication mode?
Maybe the best question I could ask is, if I want to run sql server as a web back-end and as a local db for a windows app, how should I have it set up from a security/authentication standpoint?
Thanks!