Sql Server Security
-
:laugh: Hi all, I wanna add security to Database of Sql Server 2000 that means no body will be able to manully open the database in Sql Server EnterPrise Manager without authentication. ;P Hope u will understand wht i mean to say :-O .... Thanks with anticipation with looking fwd 4 ur response..........
The Great Pleasure In Doing That Things That Other People Say U Can't By Doing This U Can Shut Their Mouth
-
:laugh: Hi all, I wanna add security to Database of Sql Server 2000 that means no body will be able to manully open the database in Sql Server EnterPrise Manager without authentication. ;P Hope u will understand wht i mean to say :-O .... Thanks with anticipation with looking fwd 4 ur response..........
The Great Pleasure In Doing That Things That Other People Say U Can't By Doing This U Can Shut Their Mouth
-
:laugh: Hi all, I wanna add security to Database of Sql Server 2000 that means no body will be able to manully open the database in Sql Server EnterPrise Manager without authentication. ;P Hope u will understand wht i mean to say :-O .... Thanks with anticipation with looking fwd 4 ur response..........
The Great Pleasure In Doing That Things That Other People Say U Can't By Doing This U Can Shut Their Mouth
Basically you will need set up your SQL Server installation using Windows authentication so that each user logs in using their Windows credentials. You can then apply security settings for each user depending on which tables etc you want them to have access to. There is a lot more behind this which google will more than help with. What I have described above should get you heading in the right direction. Regards Guy
Continuous effort - not strength or intelligence - is the key to unlocking our potential.(Winston Churchill)
-
:laugh: Hi all, I wanna add security to Database of Sql Server 2000 that means no body will be able to manully open the database in Sql Server EnterPrise Manager without authentication. ;P Hope u will understand wht i mean to say :-O .... Thanks with anticipation with looking fwd 4 ur response..........
The Great Pleasure In Doing That Things That Other People Say U Can't By Doing This U Can Shut Their Mouth
Thanks to both of u for reply Sorry i m facing a problem in login I right clicked on Local n then select property->Security Tab n select sql server authentication mode set the username prof and password prof i worked but when i wanna connect ,it ask authentication when i enter prof username n password prof it says: Login Failed please varify the sql server is running and check your sql server registration properties using right click but when i select property it ask athentication again The username n password is right then wht's the problem???
The Great Pleasure In Doing That Things That Other People Say U Can't By Doing This U Can Shut Their Mouth