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.