Re: system databases

Thanks You Hari.
"Hari Prasad" <hari_prasad_k@xxxxxxxxxxx> wrote in message
news:eXiKSpfNFHA.1732@xxxxxxxxxxxxxxxxxxxxxxx
> Hi Soc,
>
> Look into the below site for moving system databases.In your case move
> only the transaction log files.
>
> http://support.microsoft.com/default.aspx?scid=kb;EN-US;224071
>
> Is it true that the system databases require the guest account?
>
> Do not remove Guest user from Master and Tempdb databases; But u could
> remove Guest from other databases.
>
> http://support.microsoft.com/kb/315523/EN-US/
>
> But you can can make the "guest" account unavailable for databases. So
> that Guest users can not login to user databases.
>
> Thanks
> Hari
> SQL Server MVP
>
>
> "soc" <zxc0@xxxxxxxxx> wrote in message
> news:e%23TDaRfNFHA.1604@xxxxxxxxxxxxxxxxxxxxxxx
>>I have installed sql server 2000,sp3a on a w2003 server. The server has a
>>separate disk array for os,data, transaction files and backups.
>>
>> The installation has put the system database data and transaction files
>> onto the data array. Should i move the transaction files onto the
>> transaction array? If so how would I do this?
>>
>> Also, is it true that the system databases require the guest account?
>> Why?
>>
>> Thanks Soc.
>>
>
>


.

Relevant Pages

  • Re: How can I remove Public access to SQL Express dbs?
    ... Will the SQL Server Management Studio work ... You can't delete guest but can render it unusable by revoking ... CONNECT permission in databases other than master and tempdb. ...
    (microsoft.public.sqlserver.security)
  • Re: Multi-Database Transactions
    ... SQL Server has supported the concept of cross-database (or even cross ... "2-phase commit". ... > I've been looking into adding transaction capabilities into my object ... people were talking about data _sources_ instead of databases. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: system databases
    ... Do not remove Guest user from Master and Tempdb databases; ... >separate disk array for os,data, transaction files and backups. ... is it true that the system databases require the guest account? ...
    (microsoft.public.sqlserver.setup)
  • Multi-Database Transactions
    ... I've been looking into adding transaction capabilities into my object ... transaction was done in a stored procedure or ADO ('classic ADO' or ... people were talking about data _sources_ instead of databases. ... using a single SQL Server 2000 Standard Edition with multiple databases ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Guest Account
    ... This comes from the book, "Professional SQL Server 2000 Programming", WROX ... "The guest account provides a way of having default access. ... >> Master, MSDB, Temp, Northwind, Pubs, and all other User databases. ...
    (microsoft.public.sqlserver.security)