Post reply

WMI Query Data Reader connection string

  • April 20, 2010 at 2:26 am

    #1154381

    Hi Vinesh,

    yes I think I did.

    Apologies, I thought I had actually posted a reply, but apparantly not 🙂

    I found that if you are trying to connect to a machine with a user name and password that is local to that machine - you must put the machine name in the user name field, i.e.: username=MyPC\UserAcc1;

    Also another minor thing, but it stopped my package from working, was the semi colon after password - if it's missing it won't work.

    So your connection string, should look like this if you want to connect to SQLDBSERVER.domain.network.org:

    ServerName=\\SQLDBSERVER.domain.network.org;Namespace=\root\cimv2;UseNtAuth=False;UserName=SQLDBSERVER\\AccUserName;PassWord=AccPwd;

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

Viewing post 46 (of 45 total)

You must be logged in to reply to this topic. Login to reply