[Mono-list] FW: SQL Server 2005 Support
Nagappan A
nagappan at gmail.com
Mon Dec 17 12:16:43 EST 2007
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 <bokarius at comcast.net> 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:bill.seddon at lyquidity.com]
> *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:* mono-list-bounces at lists.ximian.com [mailto:
> mono-list-bounces at lists.ximian.com] *On Behalf Of *Konstantin Bokarius
> *Sent:* 17 December 2007 04:06
> *To:* Mono-list at lists.ximian.com
> *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:daleemoore at gmail.com]
> *Sent:* Sunday, December 16, 2007 2:55 PM
> *To:* Konstantin Bokarius
> *Cc:* Nagappan A; Mono-list at lists.ximian.com
> *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 <bokarius at comcast.net >
> 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:nagappan at gmail.com]
> *Sent:* Saturday, December 15, 2007 8:45 PM
> *To:* Konstantin Bokarius
> *Cc:* Austin Winstanley; Mono-list at lists.ximian.com
>
>
> *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 < bokarius at comcast.net>
> 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:* austinwinstanley at gmail.com [mailto:austinwinstanley at gmail.com] *On
> Behalf Of *Austin Winstanley
> *Sent:* Saturday, December 15, 2007 3:15 PM
> *To:* Konstantin Bokarius
> *Cc:* Nagappan A; Mono-list at lists.ximian.com
>
>
> *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 <bokarius at comcast.net> wrote:
>
>
> I can't seem to get Mono connected to MS-SQL2005. What Mono SQL Client
> should I be using?
>
>
>
> *From:* Nagappan A [mailto:nagappan at gmail.com]
> *Sent:* Friday, December 14, 2007 9:09 AM
> *To:* Veerapuram Varadhan
> *Cc:* bokarius at comcast.net; Mono-list at lists.ximian.com
> *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 < vvaradhan at novell.com>
> 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 <vvaradhan at novell.com>
>
> _______________________________________________
> Mono-list maillist - Mono-list at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-list
>
>
>
>
> --
> Linux Desktop Testing Project - http://ldtp.freedesktop.org
> http://nagappanal.blogspot.com
>
>
> _______________________________________________
> Mono-list maillist - Mono-list at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-list
>
>
>
>
> _______________________________________________
> Mono-list maillist - Mono-list at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-list
>
>
>
>
> --
> Linux Desktop Testing Project - http://ldtp.freedesktop.org
> http://nagappanal.blogspot.com
>
>
> _______________________________________________
> Mono-list maillist - Mono-list at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-list
>
>
>
> _______________________________________________
> Mono-list maillist - Mono-list at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-list
>
>
--
Linux Desktop Testing Project - http://ldtp.freedesktop.org
http://nagappanal.blogspot.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ximian.com/pipermail/mono-list/attachments/20071217/8611836b/attachment-0001.html
More information about the Mono-list
mailing list