SQL Server Express 2012 SocketException with Unity

Question

I've been having a connection problem with SQL Server Express 2012, I cannot seem to connect to it from Unity, I keep getting the error message:

SocketException: An existing connection was forcibly closed by the remote host.

Code:

var connectionString: String =
      "Server=Jay\\MSSQLSERVER" +
      "Database=bfcrg;" +
      "User ID=Myuserid;" +
      "Password=mypassword;";

   var dbcon: IDbConnection;

   dbcon = new SqlConnection(connectionString);
   dbcon.Open();

I did do some research & I found out that people have been having this same issue with SQL Server Express 2008 & Unity getting the same SocketException.

As one person had suggested, I uninstalled the server which was installed as a named instance (SQLExpress) & re-installed it as the default instance (MSSQLSERVER). But yeah that didn't fix it.

I have also checked it with the Firewall turned off so no it's nothing to do with the Firewall.

However, I can connect to the Server with the SQL Server Management Studio so the server seems to be working fine I suppose.

So if anyone has any ideas, please let me know!

Cheers! Thanks a lot!

Connecting to the default instance should not require you to specify an instance name! E.g. you just use server=. or server=(local) (or specify the machine name) without an instance name. — marc_s
– marc_s, Commented Aug 16, 2013 at 4:52
There is no semicolon after your Server=Jay\\MSSQLSERVER part. — pabdulin
– pabdulin, Commented Aug 16, 2013 at 5:08
Well, that's exactly what I thought as well, when accessing the default instance that you don't need to specify the instance name, but whenever I leaver the server=machinename or server=localhost or server=127.0.0.1 or my server=localip, it throws another socketException saying No connection could be made because the target machine actively refused it. — Jay Gunawardena
– Jay Gunawardena, Commented Aug 16, 2013 at 5:36
& Petr, thanks for noticing that! I had it before but I guess I accidentally removed it & now when I try with the semicolon, with the instance name for the server, it says: NotImplementedException: Mono does not support names pipes or shared memory for connecting to SQL Server. Please enable the TCP/IP protocol. What exactly should I do about that?? — Jay Gunawardena
– Jay Gunawardena, Commented Aug 16, 2013 at 5:38
You should go into SQL server configuration manager, locate the SQL server network configuration section and enable the TCP/IP protocol for your instance, then restart the SQL server service — steoleary
– steoleary, Commented Aug 16, 2013 at 9:28

Steve Parker · Accepted Answer · 2015-10-09 14:10:21Z

2

Another gotchya is The SQL Browser service being disabled.

answered Oct 9, 2015 at 14:10

Steve Parker

313 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jay Gunawardena · Accepted Answer · 2013-08-16 14:50:51Z

1

So this is what I figured out in the end, it didn't matter if I had the default instance installed but for some reason I still needed to specify the instance name followed by the machine name in the connection string.

& for the MS SQL Server Express 2012 to accept TCP/IP connections, you should go to the SQL Server Configuration Manager & click on the SQL Server Network Configuration on the left & click on Protocols for your server instance & change the TCP/IP disabled value to enabled & i should work just fine with Unity as long as you have the other necessary DLLs in place.

Thanks a lot everyone for the help!

edited Aug 16, 2013 at 14:50

answered Aug 16, 2013 at 14:39

Jay Gunawardena

652 silver badges12 bronze badges

Collectives™ on Stack Overflow

SQL Server Express 2012 SocketException with Unity

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related