Hi, It looks strange to me ! What so ever default tests in Mono SqlClient are run against a MS-SQL Server 2005, I guess. Varadhan correct me if I'm wrong.
Thanks Nagappan On Dec 17, 2007 3:15 AM, Konstantin Bokarius <[EMAIL PROTECTED]> wrote: > 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 > 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] > > 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.152MS > 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]> > 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]> > 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 > > -- 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
