Problem with all SQL server management studio

I have problem whenever try to connect to any database in SQL server management studio. Following is error. I know database path is correct, error happens with both local and remote database connections

I have tried reinstalling SQL but that didn't work. Please advisescreenshot
TITLE: Connect to Server
------------------------------

Cannot connect to .\sqlserver2014.

------------------------------
ADDITIONAL INFORMATION:

The type initializer for 'System.Data.SqlClient.SqlConnection' threw an exception. (System.Data)

------------------------------

The type initializer for 'System.Data.SqlClient.SqlConnectionFactory' threw an exception. (System.Data)

------------------------------

The type initializer for 'System.Data.SqlClient.SqlPerformanceCounters' threw an exception. (System.Data)

------------------------------

[C:\WINDOWS\Microsoft.Net\assembly\GAC_32\System.Data\v4.0_4.0.0.0__b77a5c561934e089\System.Data.dll] No string associated with token. (System.Data)

------------------------------
BUTTONS:

OK
------------------------------

[C:\WINDOWS\Microsoft.Net\assembly\GAC_32\System.Data\v4.0_4.0.0.0__b77a5c561934e089\System.Data.dll] No string associated with token. (System.Data)
rwallacejAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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.

Vitor MontalvãoMSSQL Senior EngineerCommented:
Are you using SSMS 2014? If so, install SP1 that fixes some known bugs.
rwallacejAuthor Commented:
Yes and I installed update to no avail
Vitor MontalvãoMSSQL Senior EngineerCommented:
Which version of SNAC are you using?
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

rwallacejAuthor Commented:
what des SNAC stand for ?
Russell FoxDatabase DeveloperCommented:
It looks like your .Net assembly might be corrupt. Try reinstalling .Net 4:

https://www.microsoft.com/en-us/download/details.aspx?id=30653

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
rwallacejAuthor Commented:
Why trying to reinstall I just get message to say .net is already installed
It's not listed in add remove programs
Windows 10
Russell FoxDatabase DeveloperCommented:
It's probably hidden because you cannot uninstall files required by Windows (which I guess .Net 4 is in Windows 10?), but I just found this: Microsoft .NET Framework Repair Tool.
rwallacejAuthor Commented:
I have .net 4 and 4.5 installed. tried 4.6 too
I had already run this program to repair but it didn't fix anything
I also found a ".net validator" program on MSDN, run this, and every version of .net is valid
so no answer yet
Russell FoxDatabase DeveloperCommented:
When you reinstalled on your local machine, did you use the same source (download, DVD) that you used originally? Your source could be corrupt - try downloading a fresh copy.
Vitor MontalvãoMSSQL Senior EngineerCommented:
what des SNAC stand for ?
Sql server NAtive Client.
Do you have more than one version of SSMS installed?
rwallacejAuthor Commented:
I downloaded fresh copy


its seems like have two copies, 2008 and 2012, I can't see a simple uninstall, there are many, many SQL Server items in control panel, not e.g. "SQL Server management studio"
Russell FoxDatabase DeveloperCommented:
It's installed as part of the SQL database, usually. The good news is that you can have two of them installed, even running, at the same time. It might be worthwhile to poke around each of them in Start-All Programs: maybe one is broken but the other is working:

Start-All Programs-SQL Server 2008 R2-SQL Server Management Studio
OR
Start-All Programs-SQL Server 2012-SQL Server Management Studio

You can also download just the "SQL Server Management Studio" (previously "management tools"), which might be easier than uninstalling the entire database (though honestly if it's corrupt, you probably should).
Vitor MontalvãoMSSQL Senior EngineerCommented:
You don't need two different versions of SSMS. My guess is that somehow the 2nd installation messed up and now you can't use both.
I recommend you to uninstall both and the reinstall SSMS 2012, since it can also connect to MSSQL 2008 databases.
rwallacejAuthor Commented:
I gave up on this, taking too much time, and started using another PC. I will perhaps format PC with issue
Vitor MontalvãoMSSQL Senior EngineerCommented:
An uninstall and re install with take less time than a format but is up to you.
Good luck.
rwallacejAuthor Commented:
Per previous comments I have already tried reinstall
Vitor MontalvãoMSSQL Senior EngineerCommented:
I have tried reinstalling SQL but that didn't work. Please advise
Your comment was about reinstalling SQL Server. I'm only recommend you to reinstall SSMS. That's different thing.
Vitor MontalvãoMSSQL Senior EngineerCommented:
I have tried reinstalling SQL but that didn't work. Please advise
Your comment was about reinstalling SQL Server. I'm only recommend you to reinstall SSMS. That's different thing.
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.