RE: Security in DMZ

Yes i Use impersonate
Try this link
http://www.garvander.com/arne/impersonate.htm
--
Arne Garvander
(I program VB.Net for fun and C# to get paid. When get paid, I laugh all the
way to the bank.)


"Mohit K. Gupta" wrote:

Hmm interesting; my mistake then. Mind listing the settings for me? I would
like to note it if I need it :).

So I am taking a guess you had to do impersonation by in windows? Sorry not
a Windows Server expert? Mind explaining to me, I would like to learn :).
Thanks.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/


"Arne Garvander" wrote:

Actually I got it done with a local account today.
I had to go through a list of about half a dozen settings before i was done.
I had to create two identically local accounts on the SQL server and DMZ
server and a few other settings. Now it works great.
--
Arne Garvander
(I program VB.Net for fun and C# to get paid. When get paid, I laugh all the
way to the bank.)


"Mohit K. Gupta" wrote:

Computer?

If I am understanding you right; you can't. Because those accounts are
local to that computer, there is no way for SQL Server to get the
authentication token from a local computer account. If you have Domain
Controller out there; then you can create a DMZ account on an internal server.

Thanks

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/


"Arne Garvander" wrote:

CREATE LOGIN [wep-2\ccc]] FROM WINDOWS WITH DEFAULT_DATABASE=[master]
Error Message
Windows NT user or group 'wep-2\ccc' not found. Check the name again.
How do I make SQL server trust a computer in the DMZ?

--
Arne Garvander
(I program VB.Net for fun and C# to get paid. When get paid, I laugh all the
way to the bank.)
.

Relevant Pages

  • Re: Cant connect
    ... Hitchhiker’s Guide to Visual Studio and SQL Server ... "Arne Garvander" wrote in message ... I am not able to connect to SQL 2000 from Management studio on two different ... When get paid, I laugh all the ...
    (microsoft.public.sqlserver.connect)
  • Re: LinQ
    ... I also laugh at wisdom from hillbillies. ... Arne Garvander ... (I program VB.Net for fun and C# to get paid. ... When get paid, I laugh all the ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Security in DMZ
    ... there is no way for SQL Server to get the ... then you can create a DMZ account on an internal server. ... "Arne Garvander" wrote: ... When get paid, I laugh all the ...
    (microsoft.public.sqlserver.security)
  • Re: System.Reflection
    ... On Jun 9, 8:30 am, Arne Garvander ... (I program VB.Net for fun and C# to get paid. ... When get paid, I laugh all the ...
    (microsoft.public.dotnet.languages.csharp)
  • VBA Security warning
    ... Arne Garvander ... (I program VB.Net for fun and C# to get paid. ... When get paid, I laugh all the ...
    (microsoft.public.access.security)