SQL Server supports two authentication modes:
1) Windows Authentication - which requires domain credintials to log into the server
2) SQL Server Authentication - which requires a username and password, which are not related to the domain.
Make sure your server is set up to support BOTH Windows & SQL Server Authentication. To do this, open the SQL Server Management Studio, right click on the server in the tree and select "properties"
Then select "Security" and click the "SQL Server and Windows Authentication mode" and save. Restart the Server. You can then assign a username and password and allow that user specific rights for each database.
"The illiterate of the 21st century will not be those who cannot read and write, but those who cannot learn, unlearn, and relearn." ~ Alvin Toffler
| 
