Note: if you are using Windows Authentication, your SQL Server and the client computer connecting to this SQL Server must be on a real Windows NT/2000/2003 Domain for Windows Authentication to work.
Samba may work, but I'm not sure. Also, with Mono, you must include your Windows NT/2000/2003 Domain User and Password when connecting via Windows Authentication. You can read more info here about Mono's SqlClient provider here: http://www.mono-project.com/SQLClient My advice, make sure SQL Server can accept TCP/IP connections. Make sure the server is set up for mix-mode authentication (windows authentication and sql server authentication). One more thing, do you even read the replies people send to you? I asked you this earlier: How does you connection strings look like? You can rename your actual user id and password to xxxx. Are you using an instance name in your connection string? You mentioned you are connecting via SQL Server Authentication. Have you increased the CONNECTION TIMEOUT? The default is 15 seconds. To know for sure you're connecting via .net the same way you are in mono, add this to your connection string for running on .net: ;network library=dbmssocn Then if you get the same thing on .net as you do with mono, then you know its something with connecting via TCP/IP. And if you were using a named instance, then you may need to open up access to UDP port 1434. Here is an entry from my blog about this. http://www.mfconsulting.com/danmorg/blog/archives/000145.html Here is the msdn doc on SqlConnection.ConnectionString http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectionstring.aspx --- Austin Winstanley <[EMAIL PROTECTED]> wrote: > Ok, So on this problem I have narrowed it down. On > my server I have > Sql 2000 and Sql 2005 running side by side. i only > get the connection > error when trying to connect to sql 2005. I can > connect to sql 2000 > just fine. > > The only difference is the instance name. To connect > to 2000 I would > just use my ip address. But to connect to sql 2005 I > have to use > myipaddress\\Server2005. In windows this works, but > in mac and linux > it doesnt. So the problem comes down to just the > Server2005 instance > name in mac/linux. > > Can anybody help me out with this?? It is driving me > crazy. Thanks! > > > > On 1/28/07, URBAN Leos <[EMAIL PROTECTED]> wrote: > > Try connection string: > > > > this.sqlConnection1.ConnectionString = > > > "uid=sa;pwd=alphaville;server=192.168.1.34,1433;database=Test"; > > > > Leos > > > > Austin Winstanley napsal(a): > > > I am running a Mono Winforms app and i have > gotten it to run great on > > > Windows, Linux, and Mac OSX. The problem is I > can only connect to a > > > Sql Server 2005 DB from Windows. It is a remote > DB and it connects > > > just fine when I am in Windows, but as soon as I > run my app from Mac > > > or Linux, It gives me Sql Server does not exist > or connection denied > > > error. I'm not understanding why it will connect > from Windows but not > > > Mac or Linux. Any help would be great. Thanks! > > > _______________________________________________ > > > Mono-winforms-list maillist - > [email protected] > > > > http://lists.ximian.com/mailman/listinfo/mono-winforms-list > > > > > > > > ____________________________________________________________________________________ 8:00? 8:25? 8:40? Find a flick in no time with the Yahoo! Search movie showtime shortcut. http://tools.search.yahoo.com/shortcuts/#news _______________________________________________ Mono-list maillist - [email protected] http://lists.ximian.com/mailman/listinfo/mono-list
