C# connect to domain SQL Server 2005 from non-domain machine
- by user304582
Hi, I asked a question a few days ago (http://stackoverflow.com/questions/2795723/access-to-sql-server-2005-from-a-non-domain-machine-using-windows-authentication) which got some interesting, but not usable suggestions. I'd like to ask the question again, but make clear what my constraints are:
I have a Windows domain within which a machine is running SQL Server 2005 and which is configured to support only Windows authentication. I would like to run a C# client application on a machine on the same network, but which is NOT on the domain, and access a database on the SQL Server 2005 instance.
I CANNOT create or modify OS or SQL Server users on either machine, and I CANNOT make any changes to permissions or impersonation, and I CANNOT make use of runas.
I know that I can write Perl and Java applications that can connect to the SQL Server database using only these four parameters: server name, database name, username (in the form domain\user), and password.
In C# I have tried various things around:
string connectionString = "Data
Source=server;Initial
Catalog=database;User
Id=domain\user;Password=password";
SqlConnection connection = new
SqlConnection(connectionString);
connection.Open();
and tried setting integrated security to true and false, but nothing seems to work. Is what I am trying to do simply impossible in C#?
Thanks for any help, Martin
