Blue question mark on SQL server and SQL server agent?
Server Fault Asked by Root Loop on February 11, 2021
I just installed MS SQL server 2017 on MS Server 2019. All installation process were fine. Using SSMS 18 access SQL server locally was fine, no issue at all.
But when I use SSMS 18 connecting SQL server remotely as sa I got a blue question mark on SQL server and SQL server agent.
I done a lot of researches and followed all suggestions, seems like none of “fix” can fix this issue. I never see this on previous version of SQL servers.
Is there anyone else get the same issue?
One Answer
I've also found this issue can be caused by using an FQDN when connecting to the SQL server in SSMS. So if you've tried everything above and its still not working try...
Adding an entry for the SQL server to your hosts file (C:WindowsSystem32driversetchosts) with the IP address and just the server name, not FQDN. Then try connecting to the SQL server again in SSMS using just the server name works as expected.
Answered by ShaneOss on February 11, 2021
Add your own answers!
Ask a Question
Get help from others!
Recent Answers
- Jon Church on Why fry rice before boiling?
- Lex on Does Google Analytics track 404 page responses as valid page views?
- Joshua Engel on Why fry rice before boiling?
- haakon.io on Why fry rice before boiling?
- Peter Machado on Why fry rice before boiling?
Recent Questions
- How can I transform graph image into a tikzpicture LaTeX code?
- How Do I Get The Ifruit App Off Of Gta 5 / Grand Theft Auto 5
- Iv’e designed a space elevator using a series of lasers. do you know anybody i could submit the designs too that could manufacture the concept and put it to use
- Need help finding a book. Female OP protagonist, magic
- Why is the WWF pending games (“Your turn”) area replaced w/ a column of “Bonus & Reward”gift boxes?