<div>
To CEHJ: I'm afraid I didn't post this to the SQL Server forum as I intended. &nbsp;Don't know how to correct, so I'll accept your answer here and repost...<br />
<br />
Thanks...
</div>


To CEHJ: I'm afraid I didn't post this to the SQL Server forum as I intended.  Don't know how to correct, so I'll accept your answer here and repost...

Thanks...

<div>
OK, but i think i'd put the same answer in there ;-)
</div>


OK, but i think i'd put the same answer in there ;-)

<div>
<div class="content wysiwyg-content">
Dear Experts,<br />
<br />
I'm a newbie, and only vaguely aware of &quot;mixed mode&quot; security issues on SQL Server.<br />
<br />
When I'm installing my product, I have the user sign me on to their SQL Server box &quot;as&quot; themselves (typically with all authorities). &nbsp;I then use Query Analyzer to run a TQSL script to install the product. &nbsp;(It creates a db, a login, grants a couple of authorities...)<br />
<br />
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. &nbsp;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. <br />
<br />
Is there a fairly simple answer for this?<br />
<br />
Thanks,<br />
BrianMc1958
</div>
</div>


Dear Experts,

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?

Thanks,
BrianMc1958

NEWBIE: Is SQL Server authority equal between Query Analyzer and Windows batch file?

Windows 2000 is an operating system for use on both client and server computers. It is the successor to Windows NT 4.0, and is the last version of Microsoft Windows to display the "Windows NT" designation. Four editions of Windows 2000 were released (Professional, Server, Advanced Server, and Datacenter Server) that shared a core set of features, including many system utilities such as the Microsoft Management Console. All versions of the operating system support NTFS 3.0, Encrypting File System, as well as basic and dynamic disk storage. The Windows 2000 Server family includes support for Active Directory services, Distributed File System and fault-redundant storage volumes.

Windows 2000

Java is a platform-independent, object-oriented programming language and run-time environment, designed to have as few implementation dependencies as possible such that developers can write one set of code across all platforms using libraries. Most devices will not run Java natively, and require a run-time component to be installed in order to execute a Java program.