MS SQL Server security - Sql CE Security when using two servers who are not members of the

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Sql CE Security when using two servers who are not members of the

Niall C

2005-05-20, 1:23 pm

I am running SQLCE on Server 1 which is running IIS. I have SQL Server on
Server 2. My problem is that Server 1 is in a DMZ and Server 2 is part of the
internal network; they are not part of the same domain. Because of this I
cannot create a user which is common to both machines which means I cannot
give an IIS user access to a database on the SQL machine.

Is there any way of achieving this or must I have a user common to both
machines?

Thanks in advance,
Niall.

Sponsored Links