we have a requirement to connect to a custom SQL 2000 instance on a server that is running in workgroup mode and doesn't support mixed mode authentication. is there any way to send the credentials through SSIS to connect?
Is the SSIS package running from a different workgroup or different domain?
Jason...AKA CirqueDeSQLeil _______________________________________________ I have given a name to my pain...MCM SQL Server, MVP SQL RNNR Posting Performance Based Questions - Gail Shaw[/url] Learn Extended Events
the SSIS would be running from a SQL server on our domain, the SQL servers with the data are in workgroup mode and not on any domain. the database is for some Cisco software
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply