sql server user authentication
-
hello all, am using sqlserver 2000 as my database. my problem is am the DB administrator. i totally granting Permission to 10 user. i want to restrict 3 user can only access the DB at a time. All the others trying to enter, then it will shows that already 3 user's login u should try after some time... Is It Possible? Please help me to solve this Problem.
-
hello all, am using sqlserver 2000 as my database. my problem is am the DB administrator. i totally granting Permission to 10 user. i want to restrict 3 user can only access the DB at a time. All the others trying to enter, then it will shows that already 3 user's login u should try after some time... Is It Possible? Please help me to solve this Problem.
-
Yes. SQL server licensing can be set from control pannel. by which max number of simultanious connections can be controlled.
Regards KP
-
Yes. SQL server licensing can be set from control pannel. by which max number of simultanious connections can be controlled.
Regards KP
I was tried your suggestion. in that case i am getting some error. i also want to know how to do it without any errors.error is come from my software only but i dont know how to solve it. Am going to controlpanel->administrative tools->computer management->services and application->microsoft sqlserver->localwindowsNT then its property am changing the connections to zero to five. whenever am doing this the computer management console not responding and am also not able to start my database services. it was shown some error message and the error number is -1073741724. what it is? how to rectify it? Please help me....
-
hello Mr.Krish Can u tell me the details... how to do it? in control panel where i have to restrict? Please tell me more about such things.
-
I was tried your suggestion. in that case i am getting some error. i also want to know how to do it without any errors.error is come from my software only but i dont know how to solve it. Am going to controlpanel->administrative tools->computer management->services and application->microsoft sqlserver->localwindowsNT then its property am changing the connections to zero to five. whenever am doing this the computer management console not responding and am also not able to start my database services. it was shown some error message and the error number is -1073741724. what it is? how to rectify it? Please help me....
-
Start -> Settings -> Control Panel -> SQL Server 2000 Licensing setup need to set "per seat for" form the "Choose Licensing Mode" dialog box
Regards KP
-
Pls set per seat for any errors pls give full error message displayed. with would help in solving the same.
Regards KP