Monday, February 13, 2012

Availability of SQL Server 2000

It may be not suitable to ask about SQL 2000 here, but I really want an answer from you experts.
I have my SQL 2000 installed in a Win2000 server, however, the SQL 2000 is not available to my application until I log into a shared folder of the Win2000 or I enable the Guest account of the Win2000.
What is the proper way to let the SQL 2000 available to my application? My SQL 2000 uses SQL Security Mode.
Thanks.If you're using SQL Authentication (also known as mixed mode--it still supports Windows Authentication, too), you can supply a SQL user name and password in your database connection string (or whatever provider you use).

Windows Authentication is by far preferred, because you can use all sorts of Windows domain policies to control access with a lot of flexibility.

-Ryan / Kardax

No comments:

Post a Comment