Integration services doesn't run under Management Studio

Asked By max damico

20-Nov-09 01:58 PM

Earn up to 0 extra points for answering this tough question.

Hi Lads,

I work with SQL2005 on WindowsServer 2003/R2 32bit and I'm also have admin privileges.

I can run Integration Services and design my package.

When I try to run Integration services under Management Studio, It doesn't work because I cannot select sql authentication but only windows authentication. When I try to launch with this limitation, always appears a msg that I cannot run it.

It's strange because in sql server manament I can't see the service.

What do I have to do ?

Thanks for your Help

The problem i think is

[)ia6l0 iii replied to max damico

22-Nov-09 05:38 AM

Reply

with the SQL Server and not with the Integration services or the Management Studio that you run all this under.

If the SQL Server that you are trying to work with supports only Windows Authentication, then the SQL Authentication would be disabled as in your case. So the easiest way out, is to allow "Mixed Authentication" on the SQL Server.

You can do this by doing a right-click on the SQL Server - Server Properties - Security page. Set the authentication type accordingly.

.

[)ia6l0 iii replied to [)ia6l0 iii

22-Nov-09 05:43 AM

Reply

.

[)ia6l0 iii replied to [)ia6l0 iii

22-Nov-09 05:43 AM

Reply

.