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
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
