• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 87
  • Last Modified:

SQL Server Issue with New Windows Account

I have sql server express 2012 installed on a windows 10 pro laptop.  I just added another local user with admin privileges to the windows account.  Now, when I open SSMS under the new account I can open one of my two databases but not the other.  When I try to open the second one I get a "not accessible" error.  I assume it is something with the security of that database but I cant see what is wrong.  If someone could give me some direction as to where to look it would be much appreciated.
0
Bob Schneider
Asked:
Bob Schneider
2 Solutions
 
David Johnson, CD, MVPOwnerCommented:
from the original account open Sql Server management studio and add the new user in both login and securtyssmsssms2
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
For long that local admin users doesn't have automatically access to SQL Server, meaning that you really need to explicitly add them as David posted above.
The reason for why it has access to 2 databases it might be because there are available to 'public'. Review their permissions.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now