I used the Surface Area tool and found that under Remote Connections I had Local and Remote Connections using TCP/IP only. I changed that to Local and Remote Connections using TCP/IP and named pipes. I restarted the MSSQLSERVER service. I am still able to telnet to it and connect to it using SQL Management Studio but I'm still seeing the same Server does not exist or connection refused' error.
From: Bill Seddon [mailto:[EMAIL PROTECTED] Sent: Monday, December 17, 2007 3:05 AM To: Konstantin Bokarius Subject: RE: [Mono-list] FW: SQL Server 2005 Support Konstantin Unless you have already done so you MUST use the surface area tool on the SQL Server host machine to allow remote connections to it. This affects SQL Server 2005 only. If you have not used this utility to allow remote access you get the behaviour you observe. That is, you can telnet to the port but you cannot connect. This is because the default configuration after installation is to disable remote access. Bill Seddon Lyquidity Solutions Limited <http://www.lyquidity.com/> http://www.lyquidity.com Europe: +44 (0)20 7043 2777 USA/Canada: 1-800 401 0289 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Konstantin Bokarius Sent: 17 December 2007 04:06 To: [email protected] Subject: [Mono-list] FW: SQL Server 2005 Support I can telnet to port 1433 and when I do a port scan I can see port 1433 open for SQL Server. I can use SQL Server Management Studio to connect to the MS SQL Server 2005 system using default settings. I tried a couple different forms of connections strings in Mono that work on an older MS SQL Server system none of which worked on MS SQL Server 2005. When I try connecting with Mono I get the 'Server does not exist or connection refused' error. Not sure what to try at this point. From: Dale Moore [mailto:[EMAIL PROTECTED] Sent: Sunday, December 16, 2007 2:55 PM To: Konstantin Bokarius Cc: Nagappan A; [email protected] Subject: Re: [Mono-list] SQL Server 2005 Support I recall one MS SQL 2005 I installed needed to be configured to allow remote connections. On Dec 16, 2007 4:33 PM, Konstantin Bokarius <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > wrote: The service is running and it is not protected by a firewall as I can telnet to port 1433 on 10.10.1.152 from the system running Mono. When I change the connect string to connect to 10.10.1.150 running an older version of MS SQL it works fine, only when I point it to 10.10.1.152 MS SQL 2005 do I see the error. From: Nagappan A [mailto:[EMAIL PROTECTED] Sent: Saturday, December 15, 2007 8:45 PM To: Konstantin Bokarius Cc: Austin Winstanley; [email protected] Subject: Re: [Mono-list] SQL Server 2005 Support Hi, It looks like either the service is not running in the default port or its protected with firewall. Thanks Nagappan On Dec 15, 2007 5:37 PM, Konstantin Bokarius < [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > wrote: Here is my code: private static string strConnect = "Server=10.10.1.152;" + "Database=TESTDB;" + "User ID=userid;" + "Password=pwd;"; private static SqlConnection dbCon; private static IDbCommand dbCmd; private static IDataReader dbReader; ... dbCon = new SqlConnection(strConnect); dbCon.Open(); Here is the error I get: Unhandled Exception: System.Data.SqlClient.SqlException: Server does not exist or connection refused. ---> Mono.Data.Tds.Protocol.TdsInternalException: Server does not exist or connection refused. ---> System.Net.Sockets.SocketException: Connection refused at System.Net.Sockets.Socket.Connect (System.Net.EndPoint remote_end) [0x00000] at Mono.Data.Tds.Protocol.TdsComm..ctor (System.String dataSource, Int32 port, Int32 packetSize, Int32 timeout, TdsVersion tdsVersion) [0x00000] --- End of inner exception stack trace --- I have tried specifying the port (1433) and using Net=dbmssocn; and I still get the same error. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Austin Winstanley Sent: Saturday, December 15, 2007 3:15 PM To: Konstantin Bokarius Cc: Nagappan A; [email protected] Subject: Re: [Mono-list] SQL Server 2005 Support What does your connection string look like? I had to use the port number to connect. My connection string looks like this: Net=dbmssocn;Server=xxx.xxx.xx.xxx, 1226;Database=[mydatabase];User ID=[myusername];Password=[mypassword]; where the x's are my ip address and 1226 is the port On Dec 15, 2007 5:04 PM, Konstantin Bokarius <[EMAIL PROTECTED]> wrote: I can't seem to get Mono connected to MS-SQL2005. What Mono SQL Client should I be using? From: Nagappan A [mailto:[EMAIL PROTECTED] Sent: Friday, December 14, 2007 9:09 AM To: Veerapuram Varadhan Cc: [EMAIL PROTECTED]; [email protected] Subject: Re: [Mono-list] SQL Server 2005 Support Hi, MS-SQL 2005 works fine under Mono. But the additional features like SqlNotification won't work. Thanks Nagappan On Dec 14, 2007 3:29 AM, Veerapuram Varadhan < [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > wrote: Hi Bokarius, On Fri, 2007-12-14 at 02:52 -0800, Konstantin Bokarius wrote: > Does Mono have SQL Server 2005 support yet? Which SQL Client > available today would be the best bet? > SQLServer 2005 is yet to be supported in Mono and all prior versions are very much supported. V. Varadhan -- Veerapuram Varadhan <[EMAIL PROTECTED]> _______________________________________________ Mono-list maillist - [email protected] http://lists.ximian.com/mailman/listinfo/mono-list -- Linux Desktop Testing Project - http://ldtp.freedesktop.org http://nagappanal.blogspot.com _______________________________________________ Mono-list maillist - [email protected] http://lists.ximian.com/mailman/listinfo/mono-list _______________________________________________ Mono-list maillist - [email protected] http://lists.ximian.com/mailman/listinfo/mono-list -- Linux Desktop Testing Project - http://ldtp.freedesktop.org http://nagappanal.blogspot.com _______________________________________________ Mono-list maillist - [email protected] http://lists.ximian.com/mailman/listinfo/mono-list
_______________________________________________ Mono-list maillist - [email protected] http://lists.ximian.com/mailman/listinfo/mono-list
