When attempting to connect to SQL Server using LC LSX and calling an agent with RunOnServer Method and using SQL server authentication the following error is returned:
ErrorRecord: HResult: 0x80004005
Description: [DBNMPNTW]Specified SQL server not found.
03/12/2007 09:48:21 AM Agent printing: 12325
No error is returned when running agent from client.
Add .Network="DBMSSOCN" to your connection object.
.provider = "sqloledb"
.server = "serverName"
.Database = "dbName"
.Metadata = "tableName"
.Userid = "User"
.Password = "PW"
.MapByName = True
Hope this helps someone else, it took forever to figure out.