View Single Post
  #5 (permalink)  
Old June 11th, 2003, 01:08 PM
Imar's Avatar
Imar Imar is offline
Wrox Author
Points: 72,022, Level: 100
Points: 72,022, Level: 100 Points: 72,022, Level: 100 Points: 72,022, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,076
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

No, I don't think it has to be so tough (although I am not 100% sure).

If you download the 120 day (or so) trial of SQL Server 2000 from the Microsoft site you'll get the Client tools (including the Enterprise Manager and Query Analyzer) with the download / CD. AFAIK (but like I said, I am not 100% sure) the 120 limit / license doesn't count for the client tools, so you can use them for your MSDE installation even after your trial expires.

Once you have those tools, it should be easy to switch security models. IMO, you're better of (security wise) using Integrated Security, although sometimes SQL Server authentication has its advantages (single user that connects to the database so it's easier to use Integrated Security on a website for example).

Cheers,

Imar