June 3, 2014 at 1:34 am
Hi,
I'm new to using SQL express, and currently only using it in relation to another piece of software which needs an SQL database.
I have been using the software, and it has been working fine (on windows user A).
Now, I have created another windows user (User B), and would like to use the same software/database. The software launches fine (User B), but cannot access the created SQL database (created with user A)
How do I setup the database to allow access from all users on the same PC?
Any help is much appreciated!
June 3, 2014 at 2:33 am
What error message does User B get? Has their login been granted access to the database? (To check, expand the database node, then the Security node, then the Users node; is User B visible in that list? if not is User B a member of the sysadmin server role?)
How do I setup the database to allow access from all users on the same PC?
I don't think you can allocate permissions based on hostname. Do you have an Active Directory environment? It's usually a good idea to grant access to an AD group.
June 3, 2014 at 2:33 am
[dup]
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply