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

Asked

Viewed 6,591 times

2

I’m having problems connecting Visual Studio 2010 [c#] with Sql server 2014. I followed some tutorials but did not succeed.

Why is such a mistake happening?

c# sql-server visual-studio

  • Have you seen if the "SQL Server Browser Service" is enabled?

  • 1

    Please also post the part of your code where you connect to the bank

  • 1

    Post to your Connectionstring.

  • I was following this tutorial, I created the project but when I went to add the Service-based Database the error occurred. Following tutorial:[link]http://msdn.microsoft.com/pt-br/library/ms233763%28v=vs.100%29.aspx

  • Is running.

  • I didn’t get to configure a String Nection, as I haven’t seen how to do it yet..

  • This may be because of the firewall: http://msdn.microsoft.com/en-us/library/cc646023.aspx or because it is not configured to accept external links: http://support.webecs.com/kb/a868/how-do-configure-i-configurae-server-expressto-allow-remoteaspx.

  • They could inform me some version to download Sql Server in an earlier version, I use Windows 8 x64 and whenever I try to install another version occurs compatibility error.

  • This does not provide an answer to the question. To criticize or ask for clarification from an author, leave a comment below its publication - you can always comment on your own publications and when you have reputation points enough you will be able comment on any publication.

  • Disable firewall solves? My English is not helping..

  • Have you tried disabling the firewall? Which SQL Server communication protocols are active - memory, Pipes, tcp?

  • Shared memory, tcp/ip, named Pipes, via

  • You’ve cleared door 1433?

  • @Pegasus looks at this tutorial on how to configure the http://support.webecs.com/kb/a868/how-do-configure-sql-server-expressto-allow-remote.aspxport

  • I just found the answer on MSDN. The following is an interesting link: http://msdn.microsoft.com/en-us/library/e8db82f0-50ed-4531-9209-940006ed34cb(v=sql.110)#connect

  • I was able to resolve it. Follow the same link in English: http://msdn.microsoft.com/pt-br/library/ms345332.aspx

Show 11 more comments

2 answers

1

Pegasus, try this on;

  1. Make sure the instance name is correct. (EX: Database Name)
  2. Make sure that the machine used as the server is accessible. (You can use ping at the command prompt to check that the machine is turned on)
  3. Make sure that SQL Server is running on the server. (If possible go to the server and try to connect through SQL Server Managment Studio with your credentials)
  4. 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: http://goo.gl/hDnMXZ

1

Error 26 is because the SQL server is not running. That is, ta off. This is normal to happen when restarting the machine. It’s easy to solve. Go to Start menu, search for Microsoft SQL Server Version(2008,2012,2014) click and search for Configuration Tools, then click SQL Server Configuration Manager. When clicking it goes a window and then go to SQL Server Services and search for SQL Server(Sqlexpress) from there just click twice and that’s it, the server ta up! I hope I’ve helped !

Browser other questions tagged c# sql-server visual-studio

You are not signed in. Login or sign up in order to post.