Cant enter user&password for Integration Services

I'm about to start using Integration Services in Mgmt Studio 2005.

But, when I try to register a server for Integration Services,
the option for choosing between Windows authentication and SQL Server
authentication is greyed out, and it's set to Windows.
My domain user is automatically filled in, but greyed out. I can't enter
my password since this field is also greyed out.
Is this some installation problem? (Connection to a Database Engine works fine.)SSIS doesn't support sql auth (at least not from SSMS). there is only windows auth.

SSAS is the same way.|||My next problem is that I can't make my domain account connect
without making it a member of the server's local Administrators group.

I read this article:

http://msdn2.microsoft.com/en-us/library/aa337083.aspx

which describes how to fix this. I gave my users all kind of rights
for the MsDtsServer component and restarted the Integration Services service on the server, but it doesn't help. What can be missing?|||I had to add my user to the Distributed DCOM Users group, and
the Users group had to get full access to the MsDtsServer component.
Now it works.

Can''t connect to sql ce using sql server mgmt. studio express

Hi everybody,

i apperciate any help you guys can give me regarding this. I'm trying to connect to a sql ce db using sql server mgmt. studio express but from some reason i can't change the server type from the native engine (db engine) to sql ce (it's simply greyd out). I think I've installed all relevants to this (engine, sdk, etc...) but still nothing. The thing is, that on another machine I can do it and i can't figure out what more do I need for this to work.

Thanks again for your help.

Asaf Matyas

Tzunami Inc.

You need to install SQL Server Management Studio Express SP2 to be able to administer SQL Compact files. Download from:

http://www.microsoft.com/downloads/details.aspx?familyid=6053C6F8-82C8-479C-B25B-9ACA13141C9E&displaylang=en

Can''t connect to sql ce using sql server mgmt. studio express

Hi everybody,

i apperciate any help you guys can give me regarding this. I'm trying to connect to a sql ce db using sql server mgmt. studio express but from some reason i can't change the server type from the native engine (db engine) to sql ce (it's simply greyd out). I think I've installed all relevants to this (engine, sdk, etc...) but still nothing. The thing is, that on another machine I can do it and i can't figure out what more do I need for this to work.

Thanks again for your help.

Asaf Matyas

Tzunami Inc.

You need to install SQL Server Management Studio Express SP2 to be able to administer SQL Compact files. Download from:

http://www.microsoft.com/downloads/details.aspx?familyid=6053C6F8-82C8-479C-B25B-9ACA13141C9E&displaylang=en