Category: SQL Server

  • How to give password to the excel file?

    Most of us know, how to give the password to the excel file. But we are not giving it J, As best practice if you are exporting data to excel file and sharing with the client, never forget it to make it password protected.

     

    To make the excel file password protected follow below steps.

    Step 1: File -> Prepare -> Encrypt Document

    Step 2: Enter and Re-enter the password.

    Step 3: Save the file.

  • User ‘XXXX’ does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.

    Today while configuring the Reporting Service I got the below error.

     

    User ‘XXXXX’ does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.

     

    You can change the UAC Restriction by following the below steps.

    Step 1: Go to Start -> Control Panel -> User Accounts


     

    Step 2: Click on Change User Account Control settings.


    Step 3: Drag the slider to never notify and it will fix the issue.

    Step 4: Reboot the box and issue will be fixed. To reboot you can use the shutdown –i dos command as well.

  • Steps to change logged in account password on Remote Desktop Session Windows Server 2008/R2 box

    You can follow the below steps to change the password of the logged in account using RDP.

    Step 1: Go to Start -> Windows Security

    Step 2: Click on change password

    Step 3: Change the password as mentioned in the below screen.

  • Setting the PowerShell Execution Policy

    Problem
    Recently I moved PowerShell script files to a production environment and when executing it from the command prompt, I got this error: “File cannot be loaded because the execution of scripts is disabled on this system. Please see “get-help about_signing” for more details”. In this tip we cover what needs to be done to resolve this issue.

    Solution
    http://www.mssqltips.com/sqlservertip/2702/setting-the-powershell-execution-policy/

  • How to make SQL Server View Read Only?

    In SQL Server a view represents a virtual table. Just like a real table, a view consists of rows with columns, and you can retrieve data from a view (even you can INSERT/UPDATE/DELETE data in a view). The fields in the view’s virtual table are the fields of one or more real tables in the database. You can use views to join two tables in your database and present the underlying data as if the data were coming from a single table, thus simplifying the schema of your database for users performing ad-hoc reporting. You can also use views as a security mechanism to restrict the data available to end users

    See the below example how we can make the view read only.

    
--creating a sample table
Create table tbl1
(
	myID int,
	name varchar(10)
)

--inserting data
insert into tbl1 values(1,'Jugal'),(2,'SQL'),(3,'DBPool')

--creating sample view
create view vwtbl1
as
select * from tbl1

--inserting data using view
insert into vwtbl1 values(1,'Jugal'),(2,'SQL'),(3,'DBPool')

--altering view to make it readOnly
alter view vwtbl1
as
select myid,name from tbl1
union all
select 0,0 where 1 =0

    INSERT/UPDATE/DELETE will fail with the below errors.

    Msg 4406, Level 16, State 1, Line 1
    Update or insert of view or function 'vwtbl1' failed because it contains a derived or constant field.

    Msg 4426, Level 16, State 1, Line 1
    View 'vwtbl1' is not updatable because the definition contains a UNION operator.