Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

need help for SQL Server2000 Expand / Collapse
Posted Monday, April 21, 2008 5:02 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 21, 2008 10:02 AM
Points: 3, Visits: 1
dear friend
i want to configer SQL Server in a domain network envairment. SQL server is installed in a client machine. i want to connect all users (almost 35 users) to connect with that client machine. these users are not using their own machine. if one user is using A machine ana may be that user will use G machine after some time .... i can say total users are 35 and total mahines are 20. if any machine is free the user can b use that ...

my sql server name is 'PRJ-ACCT8'

please help me how to connect this by using stap by stap .
thanks ...
Post #487827
Posted Monday, April 21, 2008 12:20 PM


Group: General Forum Members
Last Login: Tuesday, March 29, 2016 11:59 AM
Points: 120, Visits: 977
I believe you are referring to group domain accounts? If that is the case, from a basic point of view you will need to create a network group and include the 35 user’s network accounts in this group. You can then create a login on the SQL Server ‘PRJ-ACCT8’ for the group.

Some things to look into, if you have an Active Directory:

Sql Server how to for creating logins:

Good Luck,
Post #488158
Posted Monday, April 21, 2008 10:02 PM



Group: Administrators
Last Login: Yesterday @ 12:35 PM
Points: 34,363, Visits: 18,578
This will work if each user is logging onto the machine with their account. If they are sharing logins to Windows, then you need to use SQL Server accounts. Depending on your application, this might or might not work.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #488341
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse