Clever Geek Handbook

How do I resolve error 26 in SQL Server?

We access our database with our server (another computer). I used to be able to connect to it, but it suddenly stopped and now I can't connect and I ran into this error which is Error 26 Locating Server.

Others can connect to our server. I don't know what I did or what changed with my machine, which makes me not connect to our server. Can anyone suggest what should I do?

I am using SQL Server 2008 R2.

BTW, I can access our server using Remote Desktop Connection, but when I connect using SQL Server 2008 R2, I really can't connect. I am using the correct server name but it doesn't work.

I tried to connect to another server and it works. What should I do? I don't know why this happened.

enter image description here

0


source to share


2 answers


Try flushing your DNS .

Open a DOS window to do this.



  • Click the Start button
  • Type CMD and hit enter

  • Type this into the black box that appears: ipconfig / flushdns and hit enter to see:

    Windows IP address configuration

    Successfully flushed the DNS resolver cache.

See if this fixes the problem.

0


source


I tried using (Server IP) \ SQLEXPRESS and it works. However, I still don't know why it cannot get the server instance name.



0


source






More articles:


All Articles