[Mono-list] [Mono-winforms-list] Mono WinForms Problems Connecting to Sql 2005

[Björn Poppe]

In a terminal, manually type "telnet yourservername 1433" to see if you can
connect.

1433 is the default TCP port for SQL Server.

Example:

bjorn at bamse:~$ telnet 192.168.104.11 1433
Trying 192.168.104.11...
Connected to 192.168.104.11.
Escape character is '^]'.

Connection closed by foreign host.

If you can't connect to the server:

bjorn at bamse:~$ telnet 192.168.104.11 1433
Trying 192.168.104.11...
telnet: Unable to connect to remote host: Connection refused

If the connection fails, look for firewalls etc.

/ Björn

-----Original Message-----
From: mono-list-bounces at lists.ximian.com
[mailto:mono-list-bounces at lists.ximian.com] On Behalf Of Austin Winstanley
Sent: den 26 januari 2007 19:55
To: mono-list at lists.ximian.com
Subject: Re: [Mono-list] [Mono-winforms-list] Mono WinForms Problems
Connecting to Sql 2005

No, How would I do that? How would the connection string look? thanks!



On 1/26/07, Björn Poppe <bjorn at poppe.pp.se> wrote:
> Have you tried network connectivity? I.e. "telnet server 1433"?
>
> / Björn
>
> -----Original Message-----
> From: mono-list-bounces at lists.ximian.com
> [mailto:mono-list-bounces at lists.ximian.com] On Behalf Of Austin Winstanley
> Sent: den 26 januari 2007 19:33
> To: mono-list at lists.ximian.com
> Subject: Re: [Mono-list] [Mono-winforms-list] Mono WinForms Problems
> Connecting to Sql 2005
>
> Yea, I forgot to mention that. TCP/IP connections are enabled, along
> with Named Piped. I changed that when i first set up the server. I'm
> just wondering why I can get in perfectly fine in windows, but it cant
> find the database or it wont let me log in when coming from mac or
> linux...
>
>
> On 1/26/07, Björn Poppe <bjorn at poppe.pp.se> wrote:
> > Make sure the SQL Server accepts TCP/IP-connections and not only Named
> Pipes
> > which I believe is default.
> >
> > / Björn
> >
> > -----Original Message-----
> > From: mono-list-bounces at lists.ximian.com
> > [mailto:mono-list-bounces at lists.ximian.com] On Behalf Of Austin
Winstanley
> > Sent: den 26 januari 2007 18:29
> > To: mono-list at lists.ximian.com
> > Subject: Re: [Mono-list] [Mono-winforms-list] Mono WinForms Problems
> > Connecting to Sql 2005
> >
> > No, I am using Sql Server Authentication. I have it set to use both
> > and I am logging in with a sql server auth
> >
> >
> > On 1/26/07, Jackson Harper <jackson at ximian.com> wrote:
> > >
> > > Are you using windows only authentication on SQL server?
> > >
> > >
> > > On Fri, 2007-01-26 at 10:58 -0600, Austin Winstanley wrote:
> > > > Mac or Linux. Any help would be great. Thanks!
> > >
> > >
> > _______________________________________________
> > 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
>
_______________________________________________
Mono-list maillist  -  Mono-list at lists.ximian.com
http://lists.ximian.com/mailman/listinfo/mono-list