I'm a newbie, and only vaguely aware of "mixed mode" security issues on SQL Server.
When I'm installing my product, I have the user sign me on to their SQL Server box "as" themselves (typically with all authorities). I then use Query Analyzer to run a TQSL script to install the product. (It creates a db, a login, grants a couple of authorities...)
To make this easier, I'm considering embedding that same TQSL into some Java, and then running that from a batch file on the user's desktop. However, I'm not sure I'd have the same authorities double-clicking on a batch file while signed on to the SQL box itself as my customer as I would being inside QA as my customer.
Is there a fairly simple answer for this?