December 11, 2008 at 5:45 am
hi all,
Recently we purchased SQL Server 2005,we created one database,and i have to add 2000 logins at a time.
we have all login id's, but problem is how to add all user logins into sql server database.every one wants to access the application.
please do the needfull.
December 11, 2008 at 10:34 am
Does everyone need direct access to SQL Server or is there an application layer between the users and the database server?
Hopefully, the application uses stored procedures in SQL Server and you can have the application connect to the database with a single login. If you do need to add all the logins to SQL Server, have your network admin create a Windows group that includes everyone. Then you can just add the group as a login in SQL Server and give it access to the database.
Greg
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply