Jim Metcalf
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
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
ASKER
this server is also a named instance
attached is a new error
attached is a new error
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
its got 2008 and 2012 installed.
ASKER
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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