How to grant full permissions to user in SQL Server

In this article, we will learn how to grant permissions in SQL Server step by step.

Step-1: Open SQL Server with Administrator Permissions.

Step-2: Connect to the server either by any of the Authentication modes: - Windows Authentication or SQL Server Authentication.

 

Grant permission in SQL Server

Step-3: Once connected to the server. Expand ‘Security’ Tab. Expand ‘Login’ Tab. Select the Connection name for which you want to grant permission -> R.Click and select properties.

Step-4: Click Server Roles. Initially, you may notice that only ‘public’ checkbox is checked. But to access the reports you need to check all checkboxes. Means all permission need to be granted. Click OK.

Step-5: Restart the System.

There you go, you have granted full permission to selected user in SQL Server.

But, if you are trying to access RSCM. Then read the next two steps: -

Step-6: Once the system is started. Start the Reporting Services Configuration Manager (RSCM). And select the ‘Report Manager URL’ tab and click the URL to open the SQL Server Reporting Service in Internet Explorer.

Step-7: Hopefully, Reporting Server open this time.

Hope you find the article interesting.

For any query, comment us below.

Previous – How to: Start Reporting Services Configuration Manager

Next – Types of SQL Server Joins #1

Click imagination hunt to read latest blogs.

Posted By - +Manish Kumar Gautam +LIVE VIAR +ASP.NET SOLUTIONS 

Keep learning and sharing...

Read More »

How to: Start Reporting Services Configuration Manager

In this article, we will learn how to start RSCM (Reporting Services Configuration Manager) to configure a Report step by step. But first we need to see what are the software requirements: -

(1) First, we need to have a MS SQL Server. Download SQL Server.

(2) Second, we need Report Builder. Download Report Builder directly from here.

This article is the continuation of the previous article How to create SSRS Report using SQL Server and Report Builder?

Now, we will proceed step by step to understand better. Guys, following first three steps, will start your reporting service which is the aim of this article. And last two steps help you to give a URL which we will use to host our service in our upcoming SSRS article series. Without wasting time let’s start:

Step-1: Press Windows and search ‘reporting service’. Open Reporting Services Configuration Manager (RSCM) with Administrator permission.

Step-2: Click ‘Find’ it will automatically find the local server name/computer name on which the RSCM is going to RUN. But if you want to connect to a remote SQL Server that is installed on the remote server just type the server name. Once you’ve your Server Name and Report Server Instance. Click Connect button.

Note: Only Report Server Instance for the current version of SQL Server appear in the list. Earlier and advance version of SQL Server are not supported.

Step-3: Once connected. Click "Start" button to start the reporting server.

Note: If you are facing error in starting the server.

Solution: What you have to do is Press CTRL + ALT + DELETE Key or directly open Task Manager Window. Open ‘Processes’ Tab -> Search for Reporting Services Service and Click End Task button. Restart your RSCM and try to connect. Hopefully, you will connect this time.

Following the next two steps will help you to give a URL which we will use to host our service to the internet.

Step-4: Go to "Web Service URL" Tab.

(1) Then, Click "Advanced" button. Add a new HTTP Port. By default 80 port is created.

Add a new TCP Port 9090 or whatever and IP Address to "All Assigned". Click ‘OK’ button. Again click ‘OK‘ button at Advanced Multiple Web Site Configuration windows.

(2) Change the Virtual Directory from ReportServer_SQLEXPRESS to ReportServer and Click ‘Apply’ button.

Step-5: Go to "Report Manager URL" Tab.

(1) Then, Click "Advanced" button. Add a new HTTP Port. By default 80 port is created.

Add a new TCP Port 9090 or whatever and IP Address to "All Assigned". Click ‘OK’ button. Again click ‘OK’ button at Advanced Multiple Web Site Configuration windows.

(2) Change the Virtual Directory from Reports_SQLEXPRESS to Reports and Click ‘Apply’ button.

Step-6: Copy both the URL. It may look something like this

Web Service URL

http://<servername>:<PortNumber>/ReportServer

For eg.- http://lenovo-pc:9090/ReportServer

Report Manager URL

http://<servername>:<PortNumber>/Reports

For eg.- http://lenovo-pc:9090/Reports

Hope you find the article interesting.

For any query, comment us below.

Previous – How to create SSRS Report using SQL Server and Report Builder?

Next – Configuration with SQL Server Reporting Services

Click imagination hunt to read latest blogs.

Posted By - +Manish Kumar Gautam +LIVE VIAR +ASP.NET SOLUTIONS 

Keep learning and sharing...

Read More »

How to view computer hidden files in Windows 10, 8.1, 8, 7 and XP?

In Windows, to view hidden files are quite easy. In this article, we will see how to view hidden files and folders in Windows 10, 8.1, 8, 7, and XP.

Note: Hidden files and folder appear lighter in color than normal files.

Windows 10/8.1/8

To view hidden files in Windows 10/8.1/8 follow these steps:

 

Hidden files image 1

1)    Open My Computer or Press Window key and E.

2)    In the Menu Bar click ‘View’ tab located in top left corner of the screen.

3)    Check the Hidden items field.

4)    And you are done. The hidden files automatically become visible to you in a lighter color.

Windows 7

To view hidden files in Windows 7 follow these steps:

 

Hidden files image 2

1)    Open My Computer or Press Window key and E.

2)    In the Tool Bar click ‘Organize’ button located in top left corner of the screen. Select folder and search options.

3)    A Folder Options dialog box open. Click the ‘View’ tab.

4)    Select show hidden files, folders, and drives. Click ‘Ok’ button to save the settings.

5)    And you are done. The hidden files automatically become visible to you in a lighter color.

Windows XP

To view hidden files in Windows XP follow these steps:

 

Hidden files image 3

1)    Open My Computer or Press Window key and E.

2)    In the Menu Bar click ‘Tools’ tab located in the top left corner of the screen and then Folder options.

3)    A Folder Options dialog box open. Click the ‘View’ tab.

4)    Under Advanced settings. Select show hidden files, folders, and drives. Click ‘Ok’ button to save the settings.

5)    And you are done. The hidden files automatically become visible to you in a lighter color.

Hope you find the article helpful.

For any query, comment us below.

Previous – Top 10 Run Commands #6

Next – How to delete Temporary files from windows?

Click imagination hunt to read latest blogs.

Posted By - +Manish Kumar Gautam +LIVE VIAR +ASP.NET SOLUTIONS 

Keep learning and sharing...

Read More »

How to create the SSRS Report using SQL Server and Report Builder?

In this article, we will learn how to create a SSRS Report step by step. But first we need to see what are the software requirements: -

(1) First, we need to have a MS SQL Server. Download SQL Server.

(2) Second, we need Report Builder. Download Report Builder directly from here.

Database

For this article, I am using the tblTeacher table of MySchoolDB database. Click to read more about How to create the table in SQL Server.

Report Builder

For this article, I am creating Teacher Report using the above the tblTeacher table. I already wrote down all the SQL queries please do copy the queries to proceed.

We will proceed step by step to understand better.

Step-1: Open the Report Builder with Administrator permission.

SSRS Creation Image 1

Step-2: Create a new blank report. Once you click blank report, a new report window open.

SSRS Creation Image 2

As you can see the below image I have marked important four points.

SSRS Creation Image 3

(1) Click on the Insert menu to get the options how you can design your report. For this you can use Data regions(Table, Matrix, List), Data Visualization(Chart, Guage, Maps, Data Bar), Report Items(Line, TextBox, Image, Rectangle), Sub-reports(means report in a report) and suitable Header and footer.

(2) This shows the report design window. I am using Line, Textbox, and Image to create my first report. What you have to do is double-click this item and the item will add-up to your design window.Once added arrange these items as per your report design.

(3) In this region, you will add the data source, dataset, image, and parameter.

(4) And last is the Run button to preview your report.

Step-3: Add the data source see image below. For that R.Click Data source -> Add Data source -> Change the data source name -> Select Use a connection embedded in my report. -> Select Connection type as “SQL Server” -> Click Build button -> Add up the credential -> Select database name as “MySchoolDB” -> Click Ok -> Test Connection it must give “Connection created successfully”. If it failed then maybe your credentials are not correct or check whether the database service is running or not. Not sure how to check database service is running or not. -> Click Ok. Your data source is created.

SSRS Creation Image 4

Step-4: Add dataset see image below. For that R.Click Datasets -> Add Dataset -> Change the Dataset name -> Select Use dataset embedded in my report. -> Select DataSource1 -> Click Quick Designer button -> Click “Edit as Text” on top left corner -> Write your sql query ” select * from tblTeacher where teacherCode=1” and click Ok button -> Click Ok. Your dataset is created.

SSRS Creation Image 5

Step-5: Now, prepare a design for the report. Once completed your report will look like this.

SSRS Creation Image 6

Step-6: Once completed. Click the Run button to preview your report.

Step-7: You can download the report in available format.

SSRS Creation Image 7

Hope you find the article interesting.

For any query, comment us below.

Previous – Most commonly used SQL Server Data Types #6

Next – How to: Start Reporting Services Configuration Manager

Click imagination hunt to read latest blogs.

Posted By - +Manish Kumar Gautam +LIVE VIAR +ASP.NET SOLUTIONS 

Keep learning and sharing...

Read More »

Creating table in SQL Server

In this article, we have prepared queries to design database and table.

We have designed this table as per our need to create SSRS report.

--Creating database

create database MySchoolDB

--Using database

use MySchoolDB

Go

--Creating table

create table tblTeacher

(

TeacherCode int identity(1,1) primary key,

TeacherName varchar(50),

Address varchar(50),

City varchar(50),

State varchar(50),

Pincode varchar(6),

Designation varchar(50),

DOB varchar(10),

AdditionalInformation varchar(300),

Salary money,

CurrDate varchar(10),

Remarks varchar(100)

)

--Inserting records in table

insert into tblTeacher(TeacherName,Address,City,State,Pincode,Designation,

DOB,AdditionalInformation,Salary,CurrDate,Remarks)

values('Vijay Singh','Sector-100, H.No-1000, ABC Society, XYZ Nagar','Nirman Vihar',

'Delhi','100000','Head PE Coach','21-09-1979',

'Vijay Singh holds a BPE in Physical Education from Delhi University. He was assigned this job in 2003 as Assistant PE Coach.',

70000.00,'21-09-2017','This is system generated report.')

--Retrieving records from table

select * from tblTeacher

Use above records in our following SSRS Reporting article series.

For any query, comment us below.

Previous – Introduction to Asp.net Web Services

Next – Types of SQL Server Joins #1

Click imagination hunt to read latest blogs.

Posted By - +Manish Kumar Gautam +LIVE VIAR +ASP.NET SOLUTIONS 

Keep learning and sharing...

Read More »