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
>>
>

Auditing Config

I need to query system tables for various config options. Anyone know if the auditing options(login-success/fail/all) are stored in a table and what that table might be?
Jeffexec sp_configure is the supported way to query this, or you can look at
master.dbo.spt_values
Kevin Connell, MCDBA
----
The views expressed here are my own
and not of my employer.
----
"Jeff Ericson" <jeff.ericson@.mbna.com> wrote in message
news:FB99D88D-62D5-44D2-8D01-9AC00EF28731@.microsoft.com...
> I need to query system tables for various config options. Anyone know if
the auditing options(login-success/fail/all) are stored in a table and what
that table might be?
> Jeff|||Couple of options
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Jeff Ericson" <jeff.ericson@.mbna.com> wrote in message
news:FB99D88D-62D5-44D2-8D01-9AC00EF28731@.microsoft.com...
I need to query system tables for various config options. Anyone know if
the auditing options(login-success/fail/all) are stored in a table and what
that table might be?
Jeff|||Oops sent that last post a bit quick
Easiest way would be
exec xp_loginconfig 'audit level'
Details are in BOL
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Jeff Ericson" <jeff.ericson@.mbna.com> wrote in message
news:FB99D88D-62D5-44D2-8D01-9AC00EF28731@.microsoft.com...
I need to query system tables for various config options. Anyone know if
the auditing options(login-success/fail/all) are stored in a table and what
that table might be?
Jeff|||the detail actually is stored in registry...
>--Original Message--
>I need to query system tables for various config
options. Anyone know if the auditing options(login-
success/fail/all) are stored in a table and what that
table might be?
>Jeff
>.
>|||Hi Jeff
Thank you for using MSDN Newsgroup! It's my pleasure to assist you with
your issue.
You can get the Audit Level in the database security option from the
registry table or by extensive stored procedure 'xp_loginconfig'.
From the 'Start' menu of you Windows system, click 'Run', and run
'regedit'. You will get the a registration key 'AuditLevel' at the location
'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer'
I should explain more about this key.
If your Audit Level is set to:
'None', the value would be 0x00000000(0);
'Success', the value would be 0x00000001(1);
'Failure', the value would be 0x00000002(2);
'All', the value would be 0x00000003(3).
You can also use the following code to retrieve the value of the Audit
Level:
Use master
exec xp_loginconfig 'audit level'
go
You will get
name config_value
----
audit_level success
I hope this would answer your question. If you still have questions, please
feel free to post any new message here and I am ready to help!
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||Thanks for all the replies, I'll thry the extended SP, we don't have access to the registry(or the server (&%*(&()!!!!).