need help for SQL Server2000

  • 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 ...

  • 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

  • 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.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply