Authentication permissions

Hi,
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?
Thanks,
JJ> 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.]
> If I can't how about using Forms authentication instead for RS. What do I
> need to change for this to happen?
Here's a white paper that can get you started:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/ufairs.asp
Adrian M.
MCP
"JJ" <jjmraz@.-NOspAM*hotmail.com> wrote in message
news:%23s$77MIBFHA.2112@.TK2MSFTNGP09.phx.gbl...
> Hi,
> 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.
>
> Thanks,
> JJ
>|||Adrian,
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.
Thanks
Martin
"Adrian M." <absolutelynospam@.nodomain_.com> wrote in message
news:OoSThJKBFHA.2112@.TK2MSFTNGP14.phx.gbl...
>> 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.]
>> If I can't how about using Forms authentication instead for RS. What do I
>> need to change for this to happen?
> Here's a white paper that can get you started:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/ufairs.asp
>
> --
> Adrian M.
> MCP
>|||Looks like No Credentials is the appropriate option when passing sql auth
credentials in connection string.
Martin
"Martin" <x@.y.z> wrote in message
news:efIbvyWIFHA.3108@.tk2msftngp13.phx.gbl...
> Adrian,
> 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.
> Thanks
> Martin
> "Adrian M." <absolutelynospam@.nodomain_.com> wrote in message
> news:OoSThJKBFHA.2112@.TK2MSFTNGP14.phx.gbl...
>> 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.]
>> If I can't how about using Forms authentication instead for RS. What do
>> I
>> need to change for this to happen?
>> Here's a white paper that can get you started:
>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/ufairs.asp
>>
>> --
>> Adrian M.
>> MCP
>|||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.
MCP
"Martin" <x@.y.z> wrote in message
news:uLbKntXIFHA.2456@.TK2MSFTNGP09.phx.gbl...
> Looks like No Credentials is the appropriate option when passing sql auth
> credentials in connection string.
> Martin
> "Martin" <x@.y.z> wrote in message
> news:efIbvyWIFHA.3108@.tk2msftngp13.phx.gbl...
>> Adrian,
>> 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.
>> Thanks
>> Martin
>> "Adrian M." <absolutelynospam@.nodomain_.com> wrote in message
>> news:OoSThJKBFHA.2112@.TK2MSFTNGP14.phx.gbl...
>> 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.]
>> If I can't how about using Forms authentication instead for RS. What do
>> I
>> need to change for this to happen?
>> Here's a white paper that can get you started:
>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/ufairs.asp
>>
>> --
>> Adrian M.
>> MCP
>>
>