On Fri, 2009-02-27 at 08:11 +0100, laas wrote: > I have set the port to 1433; the server name in the connection string > is "SERVER\INSTANCE" and there is only one SQL Server instance on the > machine. > > > The message is not changed. >
As Gonzalo pointed out, trunk and 2.4 has quite a lot of SqlClient improvements and fixes. One option would be to upgrade to either of these versions or send me a .pcap (wireshark - mask your server name/ip address) that captures your unsuccessful connection attempt to the server. V. Varadhan > > LAAS > > On Fri, Feb 27, 2009 at 5:31 AM, Veerapuram Varadhan > <[email protected]> wrote: > On Thu, 2009-02-26 at 13:25 +0100, laas wrote: > > SQL Server is working fine. I have another web application > running on > > IIS that uses the same database constantly with no errors. > The problem > > arise with mono running the sample code on my Debian > machine. > > And, again, the strange thing is that one or two times it > works fine, > > in the next connection the message is always the same "SQL > Server does > > not exist or access denied". > > > > What is "Data Source/Server" field in your connection string > set to - IP > of the box running SQL Server or DNS resolvable name? > > If you are using IP address, it may fail for certain cases > whenever the > reverse lookup for the host name fails. > > Have a look at > https://bugzilla.novell.com/show_bug.cgi?id=407208 - > fixed after 1.9.x. > > I am not sure whether SQL 2005 Express has dynamic port > support, if so, > please choose the default port by disabling dynamic port. > > HTH, > > V. Varadhan > > > > > > Regards > > LAAS > > > > On Thu, Feb 26, 2009 at 1:16 PM, Petit Eric > <[email protected]> > > wrote: > > 2009/2/26 laas <[email protected]>: > > > Hi all, > > > reading and using the sample code in the following > page: > > > http://www.mono-project.com/SQLClient#Testing > > > > > > every time i connect to the remote SQL Server > instance I > > receive the > > > following: > > > "SQL Server does not exist or access denied" > > > The strange thing is that sometimes the same > executable file > > works fine > > > (with no re-compilation). > > > The used SQL Server (sql server express 2005) > allows remote > > connections and > > > has TCP/IP protocol turned on. I'm using the code > referred > > to the topic "C# > > > Example using SQL Server Authentication"; > > > Some idea ? > > > > You don't have network trouble or SQL server "crash" > and > > restart ? > > > Many thanks in advance > > > -- > > > [LAAS] > > > WebSite: http://www.laas02.org > > > YTSite: http://www.laas02.org/?page_id=17 > > > > > > > > _______________________________________________ > > > Mono-list maillist - [email protected] > > > http://lists.ximian.com/mailman/listinfo/mono-list > > > > > > > > > > > > > > -- > > > > Cordially. > > > > Small Eric Quotations of the days: > > > > --------------------------------------------------------------------------- > > If one day one reproaches you that your work is not > a work of > > professional, say you that: > > Amateurs built the arch of Noah, and professionals > the > > Titanic. > > > > --------------------------------------------------------------------------- > > > > Few people are done for independence, it is the > privilege of > > the powerful ones. > > > > --------------------------------------------------------------------------- > > > > No key was wounded during the drafting of this > message. > > > > > > > > -- > > [LAAS] > > WebSite: http://www.laas02.org > > YTSite: http://www.laas02.org/?page_id=17 > > > > _______________________________________________ > > Mono-list maillist - [email protected] > > http://lists.ximian.com/mailman/listinfo/mono-list > > > > > > -- > [LAAS] > WebSite: http://www.laas02.org > YTSite: http://www.laas02.org/?page_id=17 _______________________________________________ Mono-list maillist - [email protected] http://lists.ximian.com/mailman/listinfo/mono-list
