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 TESTSVRThe 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