2

So I found this question and believe this is related. SQL Server Management studio slow connection or timeout when using Windows Authentication

If I extend my timeout to 30 seconds I get SSMS connected but everything is terribly slow! The application is extremely slow/timing out when debugging.

They mention adding an entry to the hosts file to bypass DNS lookup. This is a local dev db running on my machine. What would I add to the hosts file to eliminate these DNS issues??? Servername = "ROG-DREAM-MACHI\SQLDEV".

I'm a db noob. Plz help. :(

Hardycore
  • 123
  • 1
  • 4

1 Answers1

5

Your DNS entry in the C:\Windows\System32\drivers\etc\hosts file will be:

ROG-DREAM-MACHI   127.0.0.1

You'll need to use Notepad with administrative rights, to be able to make any changes to that file.

(However, I'm voting to close this question as a duplicate of the one you posted.)

Randolph West
  • 3,733
  • 13
  • 27