bramsey 85298 (4/25/2016)

---

I tried removing the entire folder structure for SSMS in the appdata folder, and it still makes no difference. Honestly the file I mentioned is the only file...

bramsey 85298 (4/22/2016)

---

YES!!!

Instructions slightly different for me because I'm using SSMS 2014

Close SSMS

Go To

%APPDATA%\Roaming\Microsoft\Microsoft SQL Server\120\Tools\Shell

delete the RegSrvr.xml file

open SSMS

Fixed!

As a side note... the previous RegSrvr.xml and the new.... are...

The solution that cathrinegarcia24 referenced with clearing the MRU worked for me.

Just happened to see another post about this was at the top of the page:

http://www.sqlservercentral.com/Forums/Topic1660437-2799-1.aspx

One poster there mentioned clearing the MRU, I did that and it looks like...

joel.munn (2/17/2015)

---

We tried his fix and it does solve the problem for a single attachment for only one of my users and then SMSS reverts to this same puzzling behavior....

We found the problem, turns out the issue was SSRS and not IIS. Once I updated the .config file for SSRS to use Kerberos

We needed to add this entry:

<Authentication>

<AuthenticationTypes>

...

I have no idea, it's a pretty frustrating issue, it does make me wonder if something isn't right with my laptop.

I have been wanting to follow up on this with...

We have reference a number of different articles on the topic of double hops, but none of them seem to help us resolve the issue.

I am not sure if there...

One workaround that I found (Although I still haven't found the solution) is that if I run SSMS as Administrator it works as expected.

Eric M Russell (1/8/2016)

---

This type of behaviour would be situation normal for a Java app, but not for a Windows executable. Using SysInternals Process Explorer, see what SSMS.EXE is doing...

Eric M Russell (1/8/2016)

---

This type of behaviour would be situation normal for a Java app, but not for a Windows executable. Using SysInternals Process Explorer, see what SSMS.EXE is doing...

It happens with both Windows and SQL Authentication so that rules out AD

If happens with all servers and I have run profiler and verified that SQL doesn't know anything about...

I should also mention that this occurs when using both Windows Authentication AND SQL Authentication

Lowell (1/8/2016)

---

if you connect via IP address instead of server name, is it near-instant? maybe it's still networking/dns?

how about fully qualified instead of WINS name?

ie connecting to 10.40.10.100 or SQLProd.Yourdomain.local...

1)...