Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
baskaran.vishnu
Starting Member
1 Post |
 Posted - 2006-06-30 : 02:52:46
|
Hi,
I would like to enquire on the possibility on access control into the MSDE. I have downloaded and installed the MSDE 2000 with an instance name of TESTSVR
The Instance I created was of type mixed Windows and SQL connection with a strong SA password.
Once installed and running, I accessed my Instance and created a user with limited access to the database (read and write only). The problem I am currently facing is that despite setting a strong password for SA and creating a second user with limited access, I could still access my TESTSVR Instance using the trusted MSDE connection. Using this connection, I only have to specify the server name and I am able to access and control all aspect of the database (including creating and deleting tables, etc.)
Is there anyway I could disable the trusted connection for MSDE such that a user could only access it using the SQL authentication by either using the SA password or logging on as the created user?
I do not want anyone to access the MSDE engine via its trusted connection.
I am not sure if this is possible. However, I would be grateful for any replies on this issue.
Thanks.
Vishnu Monn Baskaran |
|
|
|
|
|
MSDE Trusted connection Issue