<div>
yes, using windows authentication.<br />
this means that instead of -U&lt;username&gt; &nbsp;-P&lt;password&gt; you just end up with -E<br />
<a href="https://technet.microsoft.com/en-us/library/aa214012%28v=sql.80%29.aspx" rel="ugc">https://technet.microsoft.com/en-us/library/aa214012%28v=sql.80%29.aspx</a><br />
<br />
this requires that your batch file is executed with a windows user (if this is run from a scheduler, this needs to be configured there) that is defined in the sql server side as login and being granted the necessary rights
</div>


yes, using windows authentication.
this means that instead of -U<username>  -P<password> you just end up with -E
https://technet.microsoft.com/en-us/library/aa214012%28v=sql.80%29.aspx [https://technet.microsoft.com/en-us/library/aa214012%28v=sql.80%29.aspx]

this requires that your batch file is executed with a windows user (if this is run from a scheduler, this needs to be configured there) that is defined in the sql server side as login and being granted the necessary rights

<div>
Hi Guy,<br />
thanks.<br />
<br />
<br />
The batch file is executed from a program (Crystal Reports). &nbsp; I assume that the Crystal user would need the relevant permissions?<br />
If so, where would the Crystal user permissions need to be granted?
</div>


Hi Guy,
thanks.


The batch file is executed from a program (Crystal Reports).   I assume that the Crystal user would need the relevant permissions?
If so, where would the Crystal user permissions need to be granted?

<div>
looking at this right now..
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I am sending an OSQL command from one server to another that is executed via a batch file. &nbsp;The command starts an SQL Job.<br />
<br />
sqlcmd.exe -S &quot;MyServerName&quot; -U *myUser* -P *myPassword* -Q&quot;exec msdb.dbo.sp_start_job ' TEST'&quot;<br />
<br />
The problem is that the OSQL command contains the username, password and server name.<br />
<br />
I am worried about security. <br />
<br />
Is there a way of doing this securely? &nbsp; <br />
<br />
Thanks<br />
<br />
Stuart
</div>
</div>


Hi,

I am sending an OSQL command from one server to another that is executed via a batch file.  The command starts an SQL Job.

sqlcmd.exe -S "MyServerName" -U *myUser* -P *myPassword* -Q"exec msdb.dbo.sp_start_job ' TEST'"

The problem is that the OSQL command contains the username, password and server name.

I am worried about security. 

Is there a way of doing this securely?   

Thanks

Stuart

Is there a way to securely send a an OSQL command?

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Security is the protection of information systems from theft or damage to the hardware, the software, and the information on them, as well as from disruption or misdirection of the services they provide. The main goal of security is protecting assets, and an asset is anything of value and worthy of protection.  Information Security is a discipline of protecting information assets from threats through safeguards to achieve the objectives of confidentiality, integrity, and availability or CIA for short. On the other hand, disclosure, alteration, and disruption (DAD) compromise the security objectives.