Setting up SQL 2000

[dodgyone]

I am planning on installing MS Windows Server 2000 and MS SQL 2000 Server Standard learn the DB system. It will be on a stand alone computer not on a network. I just want to get an understanding of what I need before I go ahead with it all.

What I would like to know is can I experiment and test the security features on a stand alone computer or do I need a second computer networked? I was wondering if I could log out of server and then log back in as another user with access permissions set. would the permissions take eefct ok?I don't have a second computer available and just waned to clarify if this was possible before I started.

Many thanks...

================================
"Chaos, panic & disorder - my work here is done!"
================================

 

[dodgyone]

I might of answered this for myself. Do I just use the SQL authentication rather than Windows authentication? I know Windows is the most sensible option but for testing purposes would this work out alright?

================================
"Chaos, panic & disorder - my work here is done!"
================================

 

[SQLBill]

You could set the server for Windows Authentication only and once you've tested everything else, switch it to Mixed Mode Authentication and test that. Just make sure you create accounts that use SQL Server Authentication before you switch the server.

-SQLBill