Create Credentials of the network shared access in SQL server to be used by SQL Agent


0 Votes"
PraveenChannal-4099 asked    Monalv-msft commented  Sep 28 2020 at 2:03 PM

Create Credentials of the network shared access in SQL server to be used by SQL Agent

How to create 'Create Credentials of the network shared access in SQL server to be used by SQL Agent'

Thanks

sql-server-generalsql-server-transact-sqlsql-server-integration-services
 ·  2 
OlafHelper-2800 avatar image OlafHelper-2800 · 

For me it's not clear what you are lookup for, may can you explain it more detailed, please?

 0 Votes0 ·
PraveenChannal-4099 avatar image PraveenChannal-4099  OlafHelper-2800 · 


Create Credentials of the network shared access in SQL server to be used by SQL Agent
Create Proxy to copy the file to shared path from SQL Server Agent Job using shared credential
Create SQL Agent Job 'Full File' Step1 to use the SSIS package
Create SQL Agent Job 'Full File' step 2 to Copy file from local drive to network shared path with owner as proxy credential


This is my use case . Let me know how to go about

 0 Votes0 ·

1 Answer

Monalv-msft avatar image
0 Votes"
Monalv-msft answered    Monalv-msft commented   EXPERT ANSWER

Hi @PraveenChannal-4099,

Please do as the following steps:
1.Create new credential
28099-createcredential.png

2.Create new proxy
28129-createaproxy.png

3.Run the job using proxy
28192-runasaproxy.png

The following links will be helpful:
Create a Credential
Create a SQL Server Agent Proxy
SQL Server Agent Jobs for Packages
Running a SSIS Package from SQL Server Agent Using a Proxy Account

Best Regards,
Mona

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



createcredential.png (51.4 KiB)
createaproxy.png (45.0 KiB)
runasaproxy.png (56.0 KiB)
 ·  1
Monalv-msft avatar image Monalv-msft · 

Hi @PraveenChannal-4099,

Please don't hesitate to contact us if you have anything to update.

Best Regards,
Mona

 0 Votes0 ·

 Nguồn:  https://learn.microsoft.com/en-us/answers/questions/106561/create-credentials-of-the-network-shared-access-in.html

Comments

Post a Comment

Popular posts from this blog

ASP.NET MVC + AdminLTE

Image
  ASP.NET MVC + AdminLTE March 31, 2018 00:14 ASP.NET MVC + AdminLTE ( edit ) ASP.NET MVC Application with a Custom Layout ( Login screen ) https://code.msdn.microsoft.com/ASPNET-MVC-Application-b4b0dc3f A NuGet package for integrating Admin LTE 2.0.4 into ASP.Net MVC 5 https://github.com/eralston/AdminLteMvc  (AdminLTE version 2.0.4) ASP.NET  Example Version of Beautiful AdminLTE Template https://github.com/go2ismail/AdminLTE-ASP-NET-MVC  (AdminLTE version 2.4.0) Tutorials & Samples on adding Charts into ASP.NET MVC Applications https://canvasjs.com/docs/charts/integration/asp-net-mvc-charts/  (Chart) CRUD Operations in ASP.NET MVC Using AJAX and Bootstrap https://dzone.com/articles/crud-operation-in-aspnet-mvc-using-ajax-and-bootst AdminLTE +  ASP.NET MVC 5 + Net Framework 4.8 https://github.com/DiomedesDominguez/AdminLTE.NET ASP.NET MVC 5 Scaffolding https://github.com/robinli/MVC5-Scaffolder ASP.NET MVC 5 SmartCode Scaffolding ( HAY HAY HAY ) https://github.com/neozhu/MVC5-Scaf
Read more

Create schedule Restart SQL Server

 If you want to schedule the restart of SQL Server or Windows Server on a regular basis, you can use the Windows Task Scheduler. Here's a general guide on how to create a scheduled task for restarting SQL Server and Windows Server: Schedule SQL Server Restart: Open Task Scheduler: Press Win + R to open the Run dialog. Type taskschd.msc and press Enter. Create a Basic Task: In the Task Scheduler, select "Create Basic Task" from the right-hand actions pane. Name and Description: Provide a name and description for your task. Click Next. Trigger Configuration: Choose the trigger type (Daily, Weekly, Monthly) based on when you want the SQL Server to restart. Set the start date and time. Click Next. Action Selection: Choose "Start a program" as the action. Click Next. Program/Script: Browse and select the SQL Server service executable. The default path is typically C:\Program Files\Microsoft SQL Server\MSSQL<Instance>\MSSQL\Binn\sqlservr.exe. Add the following p
Read more

Bỏ dấu tiếng việt

     static string ConvertCombiningDiacriticsToPrecomposed(string input)     {         string normalized = input.Normalize(NormalizationForm.FormD);         StringBuilder precomposed = new StringBuilder();         foreach (char c in normalized)         {             UnicodeCategory category = CharUnicodeInfo.GetUnicodeCategory(c);             if (category != UnicodeCategory.NonSpacingMark)             {                 precomposed.Append(c);             }         }         return precomposed.ToString().Normalize(NormalizationForm.FormC);     }     static string ConvertCombiningDiacriticsToPrecomposedWithoutRemovingDiacritics(string input)     {         return input.Normalize(NormalizationForm.FormC);     }
Read more