Authentication Mode question from a command line junkie

What is the syntax from to change the authentication mode from inside of the server(ie: osql)? And what system tables can be queried to identify which mode the server is currently running in?
To check the mode use
select serverproperty('IsIntegratedSecurityOnly')
or
exec master..xp_loginconfig 'login mode'
You can use the undocumented xp_regwrite/xp_instance_regwrite to change the
registry key that contols this (which is what EM does anyway) or use SQLDMO
but it needs a SQL Service restart to take effect e.g.
exec master..xp_instance_regwrite N'HKEY_LOCAL_MACHINE',
N'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer',
'LoginMode', N'REG_DWORD', 2
'Set security mode to mixed where oSQL is a SQLServer object
Set oSEC = oSQL.IntegratedSecurity
oSEC.SecurityMode = 2
0 or 2 = Mixed
1 = NT only
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Dean" <anonymous@.discussions.microsoft.com> wrote in message
news:C3B38A1E-32D5-4891-947F-56E5A9857A30@.microsoft.com...
> What is the syntax from to change the authentication mode from inside of
the server(ie: osql)? And what system tables can be queried to identify
which mode the server is currently running in?
sql

Authentication Mode question from a command line junkie

What is the syntax from to change the authentication mode from inside of the
server(ie: osql)? And what system tables can be queried to identify which
mode the server is currently running in?To check the mode use
select serverproperty('IsIntegratedSecurityOnly
')
or
exec master..xp_loginconfig 'login mode'
You can use the undocumented xp_regwrite/xp_instance_regwrite to change the
registry key that contols this (which is what EM does anyway) or use SQLDMO
but it needs a SQL Service restart to take effect e.g.
exec master..xp_instance_regwrite N'HKEY_LOCAL_MACHINE',
N'SOFTWARE\Microsoft\MSSQLServer\MSSQLSe
rver',
'LoginMode', N'REG_DWORD', 2
'Set security mode to mixed where oSQL is a SQLServer object
Set oSEC = oSQL.IntegratedSecurity
oSEC.SecurityMode = 2
0 or 2 = Mixed
1 = NT only
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Dean" <anonymous@.discussions.microsoft.com> wrote in message
news:C3B38A1E-32D5-4891-947F-56E5A9857A30@.microsoft.com...
> What is the syntax from to change the authentication mode from inside of
the server(ie: osql)? And what system tables can be queried to identify
which mode the server is currently running in?

Authentication Mode question from a command line junkie

What is the syntax from to change the authentication mode from inside of the server(ie: osql)? And what system tables can be queried to identify which mode the server is currently running in?To check the mode use
select serverproperty('IsIntegratedSecurityOnly')
or
exec master..xp_loginconfig 'login mode'
You can use the undocumented xp_regwrite/xp_instance_regwrite to change the
registry key that contols this (which is what EM does anyway) or use SQLDMO
but it needs a SQL Service restart to take effect e.g.
exec master..xp_instance_regwrite N'HKEY_LOCAL_MACHINE',
N'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer',
'LoginMode', N'REG_DWORD', 2
'Set security mode to mixed where oSQL is a SQLServer object
Set oSEC = oSQL.IntegratedSecurity
oSEC.SecurityMode = 2
0 or 2 = Mixed
1 = NT only
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Dean" <anonymous@.discussions.microsoft.com> wrote in message
news:C3B38A1E-32D5-4891-947F-56E5A9857A30@.microsoft.com...
> What is the syntax from to change the authentication mode from inside of
the server(ie: osql)? And what system tables can be queried to identify
which mode the server is currently running in?

audit UpLoad function

I'd like to create an audit report identifying all UpLoads that have been
done. Is it possible to identify this from the ReportServer or
RSExecutionLog databases?
Thanks
--
Rickselect * from catalog where type = 3
all the uploaded files have type 3.
Amarnath.
"Rick" wrote:
> I'd like to create an audit report identifying all UpLoads that have been
> done. Is it possible to identify this from the ReportServer or
> RSExecutionLog databases?
> Thanks
> --
> Rick|||The Type column in the Catalog table appears to be the object type:
1 Folder
2 Report
3 Resource
4 Linked Report
5 Data Source
I'd like to track each time a report (Type = 2) has been Uploaded.
Thanks,
--
Rick
"Amarnath" wrote:
> select * from catalog where type = 3
> all the uploaded files have type 3.
> Amarnath.
> "Rick" wrote:
> > I'd like to create an audit report identifying all UpLoads that have been
> > done. Is it possible to identify this from the ReportServer or
> > RSExecutionLog databases?
> >
> > Thanks
> > --
> > Rick|||Rick,
You want to find out the deployed report or uploaded because type =2 will
give you deployed report and from "report manager" when you upload then it is
option type =3
Amarnath
"Rick" wrote:
> The Type column in the Catalog table appears to be the object type:
> 1 Folder
> 2 Report
> 3 Resource
> 4 Linked Report
> 5 Data Source
> I'd like to track each time a report (Type = 2) has been Uploaded.
> Thanks,
> --
> Rick
>
> "Amarnath" wrote:
> > select * from catalog where type = 3
> > all the uploaded files have type 3.
> >
> > Amarnath.
> >
> > "Rick" wrote:
> >
> > > I'd like to create an audit report identifying all UpLoads that have been
> > > done. Is it possible to identify this from the ReportServer or
> > > RSExecutionLog databases?
> > >
> > > Thanks
> > > --
> > > Rick

Audit logins

Is there a way to identify users within sql server 2005/2000 that have not
accessed a database within 90 days ?
In 2005 with sp2, you can do this by writing a login trigger that logs the accesses.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Prem" <u33747@.uwe> wrote in message news:71562115407e5@.uwe...
> Is there a way to identify users within sql server 2005/2000 that have not
> accessed a database within 90 days ?
>
|||Tibor Karaszi wrote:[vbcol=seagreen]
>In 2005 with sp2, you can do this by writing a login trigger that logs the accesses.
Thanks ! Any idea in SQL 2000 ?
|||Having a Profiler (server-side) trace running is the only way I can see...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Prem" <u33747@.uwe> wrote in message news:7156d142d3854@.uwe...
> Tibor Karaszi wrote:
> Thanks ! Any idea in SQL 2000 ?
>

Audit logins

Is there a way to identify users within sql server 2005/2000 that have not
accessed a database within 90 days ?In 2005 with sp2, you can do this by writing a login trigger that logs the accesses.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Prem" <u33747@.uwe> wrote in message news:71562115407e5@.uwe...
> Is there a way to identify users within sql server 2005/2000 that have not
> accessed a database within 90 days ?
>|||Tibor Karaszi wrote:
>In 2005 with sp2, you can do this by writing a login trigger that logs the accesses.
>> Is there a way to identify users within sql server 2005/2000 that have not
>> accessed a database within 90 days ?
Thanks ! Any idea in SQL 2000 ?|||Having a Profiler (server-side) trace running is the only way I can see...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Prem" <u33747@.uwe> wrote in message news:7156d142d3854@.uwe...
> Tibor Karaszi wrote:
>>In 2005 with sp2, you can do this by writing a login trigger that logs the accesses.
>> Is there a way to identify users within sql server 2005/2000 that have not
>> accessed a database within 90 days ?
> Thanks ! Any idea in SQL 2000 ?
>

Audit logins

Is there a way to identify users within sql server 2005/2000 that have not
accessed a database within 90 days ?In 2005 with sp2, you can do this by writing a login trigger that logs the a
ccesses.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Prem" <u33747@.uwe> wrote in message news:71562115407e5@.uwe...
> Is there a way to identify users within sql server 2005/2000 that have not
> accessed a database within 90 days ?
>|||Tibor Karaszi wrote:[vbcol=seagreen]
>In 2005 with sp2, you can do this by writing a login trigger that logs the
accesses.
>
Thanks ! Any idea in SQL 2000 ?|||Having a Profiler (server-side) trace running is the only way I can see...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Prem" <u33747@.uwe> wrote in message news:7156d142d3854@.uwe...
> Tibor Karaszi wrote:
> Thanks ! Any idea in SQL 2000 ?
>