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
