Link to home
Start Free TrialLog in
Avatar of Jim Metcalf
Jim MetcalfFlag for United States of America

asked on

sa user for sql does not have "Securables" listed under login properties

Hey guys- I can only login to the smss interface with a domain admin account at this point.
i have changed the password for sa and tried to login as the sa and have no access.
One thing that i find interesting is that there is an attribute missing called securables for the sa
login.   for the domain admin, it is there.

What does this signify?  could this be part of the problem of why i can't login using the sa account
attached is a screenshot of the sa properties.
securables-attribute-missing-from-sa.jpg
Avatar of Jim Metcalf
Jim Metcalf
Flag of United States of America image

ASKER

also- in the screenshot I just provided.  it says there are no sevices from the sql service configuration manager.
the sql server is running in the normal services administrator tool.

any insight?  no one can login to sql management studio except for a domain admin.
no-sql-services-listed.jpg
this server is also a named instance
attached is a new error
ASKER CERTIFIED SOLUTION
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
its got 2008 and 2012 installed.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial