How do I configure SQL Server to allow other users to access a database?
- by Zian Choy
Environment:
Windows 7 Ultimate
SQL Server 2005 Express
2 users on the computer
I tried making the 2nd user a user in SQL Server (THINKPAD\2ndUser) and adding him to the database ("2ndUser"). Then, I logged in as 2ndUser and started Visual Studio 2008. When I tried to connect to the database, I got the following error message:
The database '<bleep>' does not exist or you do not have permission to see it.