Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

need help for SQL Server2000 Expand / Collapse
Author
Message
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
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 11:41 AM
Points: 114, Visits: 903
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:
http://technet2.microsoft.com/windowsserver/en/library/c11d0f80-8f42-4ddd-ac35-2e6a204ebb941033.mspx?mfr=true

Sql Server how to for creating logins:
http://msdn2.microsoft.com/en-us/library/aa337562.aspx

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


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 11:24 AM
Points: 33,088, Visits: 15,197
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