Authentication permissions



  • 1. Command line to pass parameters in SQL
    Hi, Do you know if any command I can use to pass parameters into reports, generate PDF report format and drop it into a shared folder? Thanks. Chuck
  • 2. Unable to Display Integer Values in the Report
    Hello, I have been trying to create a report which gets the Name and ID of a person and then print an X in the column of a Head H if the person belongs to the Head H. In the Stored Proc I insert a 0 if no entry exists under the head for a person or the # of times that persons name is under the head (eg 2 times value inserted is 2). I am able to print the name and ID just taking the values of the fields But when I try to print number in the columns using the iif(fields!head1.value = 0, "", "X") I dont print anything. i even tried to fields!head2.value but still I dont get any thing printed out. Is it a problem from the Stored Procedure or Some bug in my design/code ? Thanks Ravi
  • 3. Value Expression contains an error. Attempted to divide by zero.
    Hi, I have a matrix where a couple of columns are percentages derived from other fields. It is possible that one of the fields I am trying to divide on will have no data. I am using the following expression in the Value property of the textbox. =IIF(Sum( Fields!previous_month.Value)>0,(Sum( Fields!this_month.Value))/Sum( Fields!previous_month.Value),"") I wanted to try and not display anything if the field I was dividing by was Zero, but I still get the value displayed as "#Error" I am assuming this is because the report has to calculate the (Sum( Fields!this_month.Value))/Sum( Fields!previous_month.Value) value at the same time as it determines whether Sum( Fields!previous_month.Value)>0 My question is, is there a way to achieve what I am trying to do without an errror? Is there a way to see whether a value is zero or does not exist and then display something else or BLANK instead of the calculated value, but display the calculated value if the field value divided by is greater than zero? Thanks

Authentication permissions

Postby JJ » Sat, 29 Jan 2005 00:16:46 GMT


  How do I change RSs authentication from Windows to SQL Server only? What
config files need to be changed?
What else needs to be changed? I just want authentication at the SQL Server
level only.

If I can't how about using Forms authentication instead for RS. What do I
need to change for this to happen?



Re: Authentication permissions

Postby Adrian M. » Sat, 29 Jan 2005 03:59:50 GMT

>  How do I change RSs authentication from Windows to SQL Server only?
Can you explain what you mean here?...[If you mean the credentials RS needs 
to connect to the SQL server and execute the report you can set SQL Srv up 
to use SQL Server authentication, set up a user(s) that has access to your 
database, and in the shared data source choose the 'Connect Using' option 
you want.]

Here's a white paper that can get you started:

Adrian M.

Re: Authentication permissions

Postby Martin » Sun, 06 Mar 2005 19:20:05 GMT


What Connect Using option is appropriate when the SQL Server user name and 
password are specified in the connection string?

That is, using SQL Authentication to connect from RS to the datasource.  I 
want an option that says SQL Authentication in addition to all the windows 
authentication options already there.

Seems a lot of people are confused about this.  My user, report services and 
data source SQL server are on three different computers, and I don't have 
kerberos installed.


Re: Authentication permissions

Postby Martin » Sun, 06 Mar 2005 21:03:52 GMT

Looks like No Credentials is the appropriate option when passing sql auth 
credentials in connection string.


Re: Authentication permissions

Postby Adrian M. » Mon, 07 Mar 2005 06:41:55 GMT

I actually don't pass the SQL auth credentials in the connect string.  I use 
the 'Credentials Stored Securely in the Report Server' option.  That's 
because most of my reports have schedule subscriptions.  I haven't had an 
issue with this setup.

Adrian M.

Similar Threads:

1.ADMTv3 and SQL Windows authentication permissions

I'm planning on moving a SQL Server 2000 2-node cluster in a Windows 2000 
domain that uses Windows authentication to a Windows 2003 domain. Can the 
ADMTv3 modify the SQL permissions or is there another tool available that can 
handle that function?

2.Authentication/Permissions Configuration for RS/IIS?

I am making raw (not using the .NET framework) SOAP calls to RS web services 
from Classic ASP but have run into multiple RS permission and IIS logon 
failure problems.

I first created a new user on the machine (RSUser) and have given 
permissions for the user as a System User, and Browser and Publish on the 
Home directory (which includes my reports) with SSMS.

I also gave Full Control to RSUser for the directory holding the reports.

When I configure the ReportService website via IIS for Anonymous access 
(using Machine\RSUser) and then make a call to ListSecureMethods method I 
get an XML SOAP response with the ServerInfoHeader as expected. But when I 
try to call the LoadReport method, I get a "The permissions granted to user 
'Machine\RSUser' are insufficient for performing this operation" (in the XML 
SOAP response).

What am I missing with respect to permissions/logons to let my ASP pages 
make calls to web service methods of RS?

How should IIS actually be configured to work with RS via the public 
Internet (i.e. not requiring end-users to supply passwords and such)?

Thanks for any help or examples. 

3.General authentication problem windows authentication as SQL authentication


I have a problem with environment of two Windows Server 2008
Enterprise x64  systems:
1. AD
Domain Controller
SQL Server 2008

2. CRM
Microsoft Dynamics CRM 4.0

1. CRM works fine.
2. I can connect to SQL server from CRM using SQL Server Management
Studio as "sa" and as domain user. I can see databases > tables, but
when I try to open table I get unhandled exception.

3.  On CRM I have some web sites  which collects data directly from MS
CRM database using integrated security (from filtered views). Web site
is in the same Application pool as MS CRM. When I am logged in to the
CRM as domain administrator and open this site (web site is in "local
intranet" with automatic logon with current username and password
enabled) the sites connects to DB and collects data with no problems.

4. But when I am logged in to CRM as user other than DOMAIN
\administrator but also with domain administrator rights (also CRM
user with System Administrator role) the site tries to connect to SQL

5. When I log in as DOMAIN\administrator to AD and open the same site
(web site is in "local intranet" with automatic logon with current
username and password enabled) the site tries to connect to SQL as NT

I remind that the site use Integrated security in connection string
and works OK the this user logged in to CRM.

Some history...
AD was domain controller (domain: domain1) and CRM was connected to
this domain.
AD was reinstalled and set as domain controlled (domain: domain2) and
CRM was connected to new domain.

Right now we have totally no idea what can be a problem :/

Any suggestions?

4.Using Widows Authentication and accesssing SQL with SQL Authentication


I am working on an application with .NET 2005 and SQL server 2000.

I am using windows authentication for my web application authentication
and trying to connect to the SQL server with SQL authentication

My web.config reads as follows:

web application Authentication:

 <authentication mode="Windows" />
      <allow users="*" />
      <!-- Allow all users -->
      <!--  <allow     users="[comma separated list of users]"
                             roles="[comma separated list of roles]"/>
                  <deny      users="[comma separated list of users]"
                             roles="[comma separated list of roles]"/>
    <identity impersonate="true" />

SQL Authentication:

    <add name="DevDBConnection"
      providerName="System.Data.SqlClient" />

MY IIS directory security is set to "Integrated Windows
authentication". I am validating the user againt the Active Directory
for authentication and reading the user details and groups which works

But trying to open a connection object fails. I am getting a
"{"Cannot open database requested in login 'MyDB'. Login
fails.\r\nLogin failed for user 'MyUser'."}"

I have tried searching for a solution to my best, but could not solve
this problem.

I hope some one might have come accross the same problem ahd looking
forward for your help.


5.connect to SQL server: windows authentication / SQL Server authentication

I have install a while ago a SQL server on my home computer.
now, due to my work, I'm more confident with it and want to play around with
it at home.
I try to make a connection string to it and I keep having error:
SQL Query Analyzer
Unable to connect to server HERMES:

Server: Msg 18452, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'lloyd'. Reason: Not associated with a trusted SQL Server connection.

I try play around with user role, etc ... in SQL Enterprise manager, no way
I manage user lloyd to work.
this drives me crazy, how could I connect to this database.

(apparently windows authentication work, but I DON'T want to use it, I want
to use a login/password !)

BTW I was wondering, I don't really understand how windows authentication
work, nowhere I manage to find the right granted to myself or user ASP_NET,
where could I find that ?

6. SQL sever 2005 express move windowns authentication choice to mixed authentication

7. Change from SQL Authentication -> Windows Authentication failed

8. Slow Windows Authentication vs Fast SQL Authentication



Who is online

Users browsing this forum: No registered users and 11 guest