Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
WIN2000 users profile into SQL2000 server
Finally I found such a way to import WIN2000 users into SQL2000 by doing these steps: - Export win2000 users profile into text or excel file - Import this file into sql2000 table using DTS import. - Write a smal stored procedure to read from this table and add users into sql2000 security table...- suzan
- Post #3
- Forum: Microsoft SQL Server: Programming
-
WIN2000 users profile into SQL2000 server
I want to apply a windows authentication to get users connect to the SQL2000 server under WIN2000 server. Is there a way to copy win2000 user profile into sql2000 table instead of defining 120 users manually. Obviously I need to go through each user to give it a certain authority but at least...- suzan
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
