access sql server across domain thru windows authentication

Hi,
I have a sql server in a domain which is different than the one I log into,
and thats server has Windows authenticatrion, I have a domain account in the domain where sql is running, now how do I provide that domain acc info en EM to connect to that sql server. If I just select windows authenication while registering that server it gives me Cannot generate SSPI context error.

Any help will be appricaited.

Tia,
ParthYou can not do this from EM, as far as I know!
Or if you can, I would like to know that, too.

Best regards!

Access denied thru ole db but not DSN

I have an asp page that at one time worked.
Now I get the below error msg. It only happens on my asp
page. I can run through access or vb and it connects fine.
It also works fine through a dsn. I have looked everywhere
to no avail. it is sql 2k sp 3.
any help is mucho appreciated
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNMPNTW]Access denied.
/macro/conn_test.asp, line 20
code:
<%
dim lca, sql, region
set lca = server.createobject
("adodb.connection")
lca.connectionstring
= " Provider=SQLoLEDB;Server=231v9;UID=LCAP;
Pwd=fxtool;Datab
ase=LCAOPS"
lca.connectiontimeout = 30
lca.Open
lca.close
%>Have you checked permissions on the registry keys? You could use regmon
from sysinternals.com to see what keys it accesses and see if it gets any
access denied messages.
Or maybe it can't find (or doesn't have security to see) the actual OLE DB
driver?
Will a UDL on the IIS machine, using that same driver and connection info,
connect to the SQL Server?
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||This connection that is failing is using named pipes. Try adding this to
the connect string,
Network Library = dbmssocn. this will force it to use tcp/ip.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||I am having the same problem Kevin is.
when I try to connect to my SQL Server (it is on a separate box from my
development workstation) through a simple windows application it works fine.
When I use the exact same code in an .aspx file, I get SQL Server does not
exist or access is denied.
I tried adding Network Library=dbmssocn, but when I did, even the windows
app stopped working.
Any suggetions would be appretiated.
thank you
Kirk Graves
"Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> wrote in message
news:fQ93b$d5DHA.2768@.cpmsftngxa07.phx.gbl...
> This connection that is failing is using named pipes. Try adding this to
> the connect string,
> Network Library = dbmssocn. this will force it to use tcp/ip.
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>