Error trying to establish connection between SQL Server 2014 and Visual Studio

2

I'm having trouble connecting to Visual Studio 2010 [c #] with Sql server 2014. I followed some tutorials but I was not successful.

Why is such a mistake occurring?

    
asked by anonymous 18.06.2014 / 16:29

2 answers

1

Pegasus, try this;

  • Make sure the instance name is correct. (EX: InstanceName \ BankName)
  • Make sure that the machine used as a server is accessible. (You can use ping at the command prompt to check if the machine is on)
  • Make sure that SQL Server is running on the server. (If possible go to the server and try to connect through SQL Server Management Studio with your credentials)
  • If the firewall is enabled on the server, you will need to add a permission for sqlbrowser.exe and / or UDP port 1434 in exception.
  • Source: link

        
    26.06.2014 / 02:45
    1

    Error 26 is because the SQL server is not running. I mean, it's off. This is normal to happen when the machine is rebooted. It's easy to solve. Go to the start menu, search for Microsoft SQL Server Version (2008,2012,2014) click and browse for Configuration Tools, then click SQL Server Configuration Manager. Clicking it goes a window and then go to SQL Server Services and search for SQL Server (SQLEXpress) then just double-click and ready, the server ta up! I hope I have helped!

        
    26.06.2014 / 05:17