Pass remote windows credencials in connection string

[idrisgani]

I am trying to fetch data from msdb systable like sysjobs using windows account. The SQL server window login is differnt from mine.
When i include the SQL server window login details in my connection string. its throwing me access denied error to sysobjects.

"Provider=SQLOLEDB.1;Initial Catalog=msdb;User id=SQLServerwindowsloginid; Password=pwd;Data Source=ServerName;Integrated Security=SSPI"

I can understand, that the above connection string is ignoring the userid and pwd that i have supplied as i gave Integrated Security is SSPI and its using mine.

My windows login dont have read permission to msdb sysobjects.

How can i use the SQL server windows login id in my connection string or how can i use windows authentication using SQLserver windows credencials?



Thanks in advance.

[vb5prgrmr]

See http://www.connectionstrings.com for the correct format of the correct connection string you want to use...



Good Luck

[idrisgani]

I have tried with the examples given in the connectionstring.com. But no use at all may be i looking in a wrong direction.

Can you please send me the connection string which suits my requirement.