When I run the code I get the following error:
Server: Msg 18456, Level 14, State 1, Line 1
Login failed for user 'us/orl1jdt'.
[OLE/DB provider returned message: Invalid connection string attribute]
select *
from OPENROWSET('SQLoledb','UID=domain/uid;PWD=pass;
Network=DBMSSOCN;Address=server_IP,1433;TIMEOUT=2000',
'select *
from INFORMATION_SCHEMA.tables
where table_type =''base table'' AND TABLE_NAME NOT LIKE ''DTPROP%'' AND
TABLE_NAME NOT LIKE ''SYS%''
AND TABLE_NAME NOT LIKE ''MS%'' ') as a
Yes the userid has rights to the server. This code works frin with a sql id
and password but I need to know how to run it with a domain id and pass.
Joshua Tipton
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF
community.
http://affiliates.macromedia.com/b.asp?id=2439&p=go/ct_aff1
Message: http://www.houseoffusion.com/lists.cfm?link=i:6:1690
Archives: http://www.houseoffusion.com/lists.cfm?link=t:6
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:6
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=<:emailid:>.<:userid:>.<:listid:>
