Hello everyone I have one of your sql server databases on a test server, but they cant seem to access it. Can anyone give me some suggestion I'm sure its something I am obviously missing
Why do you have one of my databases on your server?
There are a couple ways to grant access. One is to use a SQL Login with a password, but this isn't the recommended method because everyone will have to know the password. Create a AD domain account and add members. Use this account as a login in SQL with windows authentication.