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
jamesmetcalf74Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

jamesmetcalf74Author Commented:
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
0
jamesmetcalf74Author Commented:
this server is also a named instance
attached is a new error
0
jamesmetcalf74Author Commented:
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Vitor MontalvãoMSSQL Senior EngineerCommented:
It seems you don't have SQL Server installed in that server.
Can you verify in the Add/Remove Programs if you see the SQL Server there?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jamesmetcalf74Author Commented:
its got 2008 and 2012 installed.
0
jamesmetcalf74Author Commented:
0
Deepak ChauhanSQL Server DBACommented:
@I can only login to the smss interface with a domain admin account at this point
 Check the SQL server property.  select the Security page and check Server authentication mode if it set to Windows Aithentication, change it to both (SQL server and Windows authentication).

@One thing that i find interesting is that there is an attribute missing called securables for the sa login

I think securables is no longer visible in SQL server 2012. I have checked in different Editions and service pack everywhere same. However i did not find any documentation for the same. Anyway we can not make any change in SA login  property.

No this is not the reason for SA login failed. I am connecting frequently.

@sql server configuration Manager - not showing any service.

I can see SQL server Native client 10 configuration in the screenshot. It should be 11.0  as you have installed SQL server 2012 on this server.

Can you check "SQLServerManager11.mmc" available here, if it is available , plese try to open it by double click on it.
"C:\Windows\SysWOW64\ "
0
Deepak ChauhanSQL Server DBACommented:
For 64bit version of sql server, SQLServerManager11.msc location will be C:\Windows\System32\

In addition try to repair the instance as SQL server management objects are not seems to be installed on this server.

SQL2012.jpg
0
Thunder724Commented:
Your not going to see securable because SA has access to all objects. Are you sure the SA account is not disabled?
Under properties look under STATUS.
1
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

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.