>
> 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.
If you need to connect to SQL Server using Windows authentication, you'll
have to run the CF service from the appropriate Windows user account,
instead of SYSTEM.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
