question

StefanLalic-5558 avatar image
0 Votes"
StefanLalic-5558 asked OlafHelper-2800 answered

Can't connect to any DB instace/ Failed to retrieve data for this request

Hi All,

I'm getting an error below whenever I try to connect to DB instance, local or remote.

TITLE: Microsoft SQL Server Management Studio



Error connecting to 'TESTSERVER'


ADDITIONAL INFORMATION:

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476



[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




I was looking for a solution, but unfortunately, I did not find anything that helped.
I found that the suggestion was to restart services (SQL agent, Remote Registry) and test SQL connection with UDL(Connection is ok).

Your input on my issue will be much appreciated.
Thank You

sql-server-general
· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Which version of SSMS do you have? Check this under Help->About.

0 Votes 0 ·

I have the same issue on SSMS v18.5 (15.0.1833.0) and 2014(12.0.6024.0).

0 Votes 0 ·

18.9.2. is the most recent version. You can get it here: https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms.

To be honest, I don't expect this to resolve the issue, but let's start there.

I don't think I've ever seen that error message "No string associated with token." before. It seems that something is broken on your machine - but what, I don't know.

0 Votes 0 ·
Show more comments
Criszhan-msft avatar image
0 Votes"
Criszhan-msft answered

Hi,

Welcome to Microsoft Q&A!

Please try to execute it as an administrator when starting SSMS.( run as administrator)

Then please check whether only the SSMS installed on this specific computer cannot connect to the SQL Server instances on the local or remote server. Can SSMS installed on other machines connect to these instances? From this to determine if this is a problem specific to this computer or may be an instance problem.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

StefanLalic-5558 avatar image
0 Votes"
StefanLalic-5558 answered Criszhan-msft edited

Hi,

Thank you.

I have the same problem,. Even when I enter whit admin.

SMSS issue is only on my PC, so it's probably a PC issue.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi,

It looks like you have installed the latest SSMS 18.9.2 but still facing the same problem. Please try to use the Azure Data Studio to connect to SQL Server, which is automatically installed with SSMS 18.9.2.

0 Votes 0 ·
OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.