Aspet Golestanian Namagerdi (10/25/2009)

---

In Managment studio(SQL SERVER 2008),I am trying to connect to Integration Services.But it is always in windows Authetication and I can not chnage it to SQL authentication .My login is sysadmin, but when I am trying to connect in window Authentication it says access denied.
1-How is it possible to change the authentication mode to SQL Authentication of cnnecting to SQL SERVER 2008 Intgration Services?
2-why my login (sysadmin) can not access to Integration Services and How can I give this permission to my user?

Thanks

Aspet Golestanian Namagerdi (10/26/2009)

---

Thx for reply,But the SQL Server is on "SQL SERVER and Windows Authentication mode",but still I can chnage it during connecting to Integration Services.

Aspet Golestanian Namagerdi (10/26/2009)

---

Thanks alot for th replys.
I guess I found the answer.Please refer to the link
http://technet.microsoft.com/en-us/library/ms180068.aspx
but How can I give this permission(Connecting to intigration Services) to a user

Aspet Golestanian Namagerdi (10/26/2009)

---

I know,My question is related to Managment studio environment.Now,how can I give the right of access to "Integration Service" to an windows account.Actually this will solve my problem.

Thanks