What are the default directory security settings for each of the virtual
directories installed with RS?
/Reports
/ReportServer
In my quest to get authentication working properly I have changed 'em and
now they are totally broke.
If someone can help, it would be most appreciated.Integrated Windows Authentication.
--
Adrian M.
MCP
"Hunter Hillegas" <HunterHillegas@.discussions.microsoft.com> wrote in
message news:35464884-1C32-42B0-BC77-392E02A31B29@.microsoft.com...
> What are the default directory security settings for each of the virtual
> directories installed with RS?
> /Reports
> /ReportServer
> In my quest to get authentication working properly I have changed 'em and
> now they are totally broke.
> If someone can help, it would be most appreciated.sql
Showing posts with label directory. Show all posts
Showing posts with label directory. Show all posts
Tuesday, March 27, 2012
Sunday, March 25, 2012
default database directory
Is it possible like when I create the database so it creates the database in
C:\Data folder and log file at D:\log folder by default. I think we can do
some thing in model database, if yes then can any one let me know how can I
do this ?
thanks
See a post which was open a few days ago:
http://groups.google.de/groups?hl=de...le.com%26rnum%
3D1
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Joh" <joh@.mailcity.com> schrieb im Newsbeitrag
news:%23lYGo9QRFHA.600@.TK2MSFTNGP10.phx.gbl...
> Is it possible like when I create the database so it creates the database
> in
> C:\Data folder and log file at D:\log folder by default. I think we can do
> some thing in model database, if yes then can any one let me know how can
> I
> do this ?
> thanks
>
>
|||Thanks
"Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:OrLOTBRRFHA.356@.TK2MSFTNGP14.phx.gbl...
> See a post which was open a few days ago:
>
http://groups.google.de/groups?hl=de...0042.191fe 23
8%40posting.google.com&rnum=1&prev=/groups%3Fq%3Ddefault%2Bdirectory%2Bchang
e%2Bsql%2Bserver%26hl%3Dde%26lr%3D%26selm%3D8ef90b 6e.0504130042.191fe238%254
0posting.google.com%26rnum%3D1[vbcol=seagreen]
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "Joh" <joh@.mailcity.com> schrieb im Newsbeitrag
> news:%23lYGo9QRFHA.600@.TK2MSFTNGP10.phx.gbl...
database[vbcol=seagreen]
do[vbcol=seagreen]
can
>
C:\Data folder and log file at D:\log folder by default. I think we can do
some thing in model database, if yes then can any one let me know how can I
do this ?
thanks
See a post which was open a few days ago:
http://groups.google.de/groups?hl=de...le.com%26rnum%
3D1
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Joh" <joh@.mailcity.com> schrieb im Newsbeitrag
news:%23lYGo9QRFHA.600@.TK2MSFTNGP10.phx.gbl...
> Is it possible like when I create the database so it creates the database
> in
> C:\Data folder and log file at D:\log folder by default. I think we can do
> some thing in model database, if yes then can any one let me know how can
> I
> do this ?
> thanks
>
>
|||Thanks
"Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:OrLOTBRRFHA.356@.TK2MSFTNGP14.phx.gbl...
> See a post which was open a few days ago:
>
http://groups.google.de/groups?hl=de...0042.191fe 23
8%40posting.google.com&rnum=1&prev=/groups%3Fq%3Ddefault%2Bdirectory%2Bchang
e%2Bsql%2Bserver%26hl%3Dde%26lr%3D%26selm%3D8ef90b 6e.0504130042.191fe238%254
0posting.google.com%26rnum%3D1[vbcol=seagreen]
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "Joh" <joh@.mailcity.com> schrieb im Newsbeitrag
> news:%23lYGo9QRFHA.600@.TK2MSFTNGP10.phx.gbl...
database[vbcol=seagreen]
do[vbcol=seagreen]
can
>
Thursday, March 22, 2012
Default Backup Directory
I have put my backup directory on a seperate drive from the data and logs.
Is the only way to change the default backup directory (that shows up when
you create a new maintenance plan) is to change the registry entry or is
there some option/ parameter that will do this?
Thanks
MACason,
Declare @.Backup_Directory VarChar(255)
exec master..xp_regread 'HKEY_LOCAL_MACHINE' ,
'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer',
'BackupDirectory', @.Backup_Directory OUTPUT
Select @.Backup_Directory
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
MACason wrote:
> I have put my backup directory on a seperate drive from the data and logs.
> Is the only way to change the default backup directory (that shows up when
> you create a new maintenance plan) is to change the registry entry or is
> there some option/ parameter that will do this?
> Thanks
Is the only way to change the default backup directory (that shows up when
you create a new maintenance plan) is to change the registry entry or is
there some option/ parameter that will do this?
Thanks
MACason,
Declare @.Backup_Directory VarChar(255)
exec master..xp_regread 'HKEY_LOCAL_MACHINE' ,
'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer',
'BackupDirectory', @.Backup_Directory OUTPUT
Select @.Backup_Directory
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
MACason wrote:
> I have put my backup directory on a seperate drive from the data and logs.
> Is the only way to change the default backup directory (that shows up when
> you create a new maintenance plan) is to change the registry entry or is
> there some option/ parameter that will do this?
> Thanks
Default Backup Directory
I have put my backup directory on a seperate drive from the data and logs.
Is the only way to change the default backup directory (that shows up when
you create a new maintenance plan) is to change the registry entry or is
there some option/ parameter that will do this?
ThanksMACason,
Declare @.Backup_Directory VarChar(255)
exec master..xp_regread 'HKEY_LOCAL_MACHINE' ,
'SOFTWARE\Microsoft\MSSQLServer\MSSQLSer
ver',
'BackupDirectory', @.Backup_Directory OUTPUT
Select @.Backup_Directory
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
MACason wrote:
> I have put my backup directory on a seperate drive from the data and logs
.
> Is the only way to change the default backup directory (that shows up when
> you create a new maintenance plan) is to change the registry entry or is
> there some option/ parameter that will do this?
> Thanks
Is the only way to change the default backup directory (that shows up when
you create a new maintenance plan) is to change the registry entry or is
there some option/ parameter that will do this?
ThanksMACason,
Declare @.Backup_Directory VarChar(255)
exec master..xp_regread 'HKEY_LOCAL_MACHINE' ,
'SOFTWARE\Microsoft\MSSQLServer\MSSQLSer
ver',
'BackupDirectory', @.Backup_Directory OUTPUT
Select @.Backup_Directory
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
MACason wrote:
> I have put my backup directory on a seperate drive from the data and logs
.
> Is the only way to change the default backup directory (that shows up when
> you create a new maintenance plan) is to change the registry entry or is
> there some option/ parameter that will do this?
> Thanks
Default Allocation Size
In setting up the Data directory for SQL 2000 Im at at the
format partition. The default partition size is
recommended for general use but it says it depends on the
size of the disk.
We are connected to a SAN that is set to 64k stripe set.
Do we need to also set the format of the partition to the
same 64k or will default take care of that (my thinking).
Rob Thiebeau64k is good... you will be fine.!
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Rob Thiebeau" <anonymous@.discussions.microsoft.com> wrote in message
news:0afa01c3db7b$3bbf50c0$a501280a@.phx.gbl...
format partition. The default partition size is
recommended for general use but it says it depends on the
size of the disk.
We are connected to a SAN that is set to 64k stripe set.
Do we need to also set the format of the partition to the
same 64k or will default take care of that (my thinking).
Rob Thiebeau64k is good... you will be fine.!
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Rob Thiebeau" <anonymous@.discussions.microsoft.com> wrote in message
news:0afa01c3db7b$3bbf50c0$a501280a@.phx.gbl...
quote:
> In setting up the Data directory for SQL 2000 Im at at the
> format partition. The default partition size is
> recommended for general use but it says it depends on the
> size of the disk.
> We are connected to a SAN that is set to 64k stripe set.
> Do we need to also set the format of the partition to the
> same 64k or will default take care of that (my thinking).
> Rob Thiebeau
Default Allocation Size
In setting up the Data directory for SQL 2000 Im at at the
format partition. The default partition size is
recommended for general use but it says it depends on the
size of the disk.
We are connected to a SAN that is set to 64k stripe set.
Do we need to also set the format of the partition to the
same 64k or will default take care of that (my thinking).
Rob Thiebeau64k is good... you will be fine.!
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Rob Thiebeau" <anonymous@.discussions.microsoft.com> wrote in message
news:0afa01c3db7b$3bbf50c0$a501280a@.phx.gbl...
> In setting up the Data directory for SQL 2000 Im at at the
> format partition. The default partition size is
> recommended for general use but it says it depends on the
> size of the disk.
> We are connected to a SAN that is set to 64k stripe set.
> Do we need to also set the format of the partition to the
> same 64k or will default take care of that (my thinking).
> Rob Thiebeausql
format partition. The default partition size is
recommended for general use but it says it depends on the
size of the disk.
We are connected to a SAN that is set to 64k stripe set.
Do we need to also set the format of the partition to the
same 64k or will default take care of that (my thinking).
Rob Thiebeau64k is good... you will be fine.!
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Rob Thiebeau" <anonymous@.discussions.microsoft.com> wrote in message
news:0afa01c3db7b$3bbf50c0$a501280a@.phx.gbl...
> In setting up the Data directory for SQL 2000 Im at at the
> format partition. The default partition size is
> recommended for general use but it says it depends on the
> size of the disk.
> We are connected to a SAN that is set to 64k stripe set.
> Do we need to also set the format of the partition to the
> same 64k or will default take care of that (my thinking).
> Rob Thiebeausql
Subscribe to:
Posts (Atom)