Since SQL Server 2012 permissions are assigned to the per-service SID for each of its instance. This blog will show how to configure file & folder permission for the SQL Server Database Engine. SQL Server must have permission of the Windows file system to access the file folder where database files are stored. The default SQL server data and backup folder permission are configured during setup. But if your database files saved in a different folder, you might need to follow below steps to setup SQL Server permission to that folder
Configure folder permission for SQL Server instance
Using Windows Explorer, navigate to the file system location where the database files are stored. Right-click the file system folder, and then click Properties.
On the Security tab, click Edit, and then Add.
In the Select Users, Computer, Service Account, or Groups dialog box, click Locations, at the top of the location list, select your computer name, and then click OK.
In the Enter the object names to select box, type the name of instance. If you database use default name then use NT SERVICE\MSSQLSERVER, or for named instance please use NT SERVICE\MSSQL$InstanceName
Click Check Names to validate the entry
In the Group or user names box, select the name added at step 4, and then in the Permissions for box, select the Allow check box for Full control.
Recently, one of my deployed SSIS package keep failing and when I check execution report, the error messages shows:
Error: CS2001 – Source file ‘C:\Windows\TEMP.NETFramework,Version=v4.0.AssemblyAttributes.cs’ could not be found, CSC, 0, 0
As this package was running well at the back-end before and there is not new release, So at the first stage, I thought maybe is dll register issue, as I was using third part dll in the Script Task code. I registered it again. But still now working,I started to check on website. I one clue from below stackoverflow link:
I opened folder C:\Windows\Temp and checked the Temp folder Properties->Security, I noticed there is odd account: ‘Account Unknown s-1-15-3-xxxx’.
In the Temp folder Properties-> Security ->Advanced page, ‘disable inheritance’ to remove this ‘Unknown account’ and click ‘Apply’ . Once this unknown account removed, ‘enable inheritance’ again. Issue is fixed now.
I created a SSIS Script Component task (C#4.0 VS2012) and I want to debug the C# code inside the Script component. I set few break points then run with debugging. The break point does not fire at all. I double checked the script editor and package, both shows break point set up successful.
The reason it might not be triggered is that it may be using the 64 bit runtime. Try running it in the 32 bit runtime. To fix it –
Go to the Solution Explorer
Right click your SSIS project node > Properties
In Configuration Properties > Debugging > Debug Options > Set Run64BitRunTimeto False.
Created SSIS Script component task with script languageC# VS2012, but added .net 4.6 dll or used upper C# 4.0 feature then break point cannot triggered as well.
In this blog, I will show you how to use powershell Select-String cmdlet to string or words from multiple files on Windows quickly?
Select-String is based on lines of text. By default, Select-String finds the first match in each line and, for each match, it displays the file name, line number, and all text in the line containing the match.
Find matches in special files
This command searches all files with the .php file name extension in the current directory
select-string *.php -pattern function
The output displays the lines in those files that include the specified string.
Find a string in subdirectories
This example searches a directory and all of its subdirectories for a specific text string.
Get-ChildItem uses the Path parameter to specify folder, The Include parameter indicate the file type will be searched The Recurse parameter includes the subdirectories. The objects are sent down the pipeline to Select-String.
Select-String uses Pattern parameter and specifies the string ‘ function posted_on ‘
Whenever a new website created, IIS will create an application pool that has the same name as website. For example, if you create an website with the name “fictionlib,” an application pool with the name ” fictionlib ” is created. Each application pool has a spcial a security identifier in Windows, system files and folders can be secured by using this identity. However, the identity is not a real user account and will not show up as a user in the Windows User Management Console.
To config, website folder permission, you need to follow below steps:
Open Windows Explorer
Select Website folder
Right click the directory and select Properties
Select the Security tab
Click the Edit button and then Add button
Click the Locations button and make sure that you select your computer.
Enter IIS AppPool\ (eg: IIS AppPool\website name) in the Enter the object names to select: text box
Click the Check Names button and click OK.
Check Modify under the Allow column, and click OK, and OK.
But there is not warning or error at all in in the design view. When I check the properties of derived column, I found the type is Unicode String and and Size always 0.
If adding data to a new column, the Derived Column TransformationEditor dialog box automatically evaluates the expression and sets the column length for string data. The value of this column is read-only.
Which means, by default SSIS will retrieve the data size from variable definition. The string variable content I was using always blank, that’s why size is 0 by default.
For pass this issue, I know there are two options:
we can using Derived Column ‘Advanced Editor ‘ to manually changed the new derived column type and length to correct one
Assign default value to string variable, make the content is not blank.