<div>
Are you the DBA?<br />
<br />
How will they run the Crystal Reports?<br />
<br />
Are the reports based on views, stored procedures, or just the tables?<br />
<br />
mlmcc
</div>


Are you the DBA?

How will they run the Crystal Reports?

Are the reports based on views, stored procedures, or just the tables?

mlmcc

<div>
<div class="content wysiwyg-content">
Hello, I want to grant access to a user to our database using SQL Server Management Studio (SQL Server 2005) in order that they can run Crystal Reports. We only have sa and another user for our main ERP system that it uses.<br />
<br />
How do I go about setting up another user so they can connect using Crystal Reports and have only Select (read-only) access? What are the steps?<br />
<br />
I'm not a SQL Server expert!<br />
<br />
Thanks!
</div>
</div>


Hello, I want to grant access to a user to our database using SQL Server Management Studio (SQL Server 2005) in order that they can run Crystal Reports. We only have sa and another user for our main ERP system that it uses.

How do I go about setting up another user so they can connect using Crystal Reports and have only Select (read-only) access? What are the steps?

I'm not a SQL Server expert!

Thanks!

Setting SQL Server Users for Crystal Reports

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

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.