[Mono-list] FW: SQL Server 2005 Support

Mon Dec 17 06:15:10 EST 2007

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/> 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
<mailto: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.152 MS 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
<mailto: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
<mailto: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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ximian.com/pipermail/mono-list/attachments/20071217/d6bd97a9/attachment-0001.html 