3 replies to this topic

[mohsen]

I want to create a database and password protect it so that it can only be accessed through a program. How would I go about making such a database in MS SQL Server 2000?

[WingedPanther]

You can restrict access to the database to certain users. I'm not sure if that's what you had in mind, however.

[mohsen]

Ummm, I only want to have 1 user, and that user should only be able to login using a password

[WingedPanther]

So you would set a password for a user in the database manager. The user will always have to provide the password to access the database. Then associate that user with the database in question.