Installation - SQL Server Authentication for SSIS

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Installation - SQL Server Authentication for...

Installation - SQL Server Authentication for SSIS

Rate Topic

Display Mode

Topic Options

Author

Message

vijayraj105

Posted Monday, September 22, 2008 6:45 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, March 17, 2011 1:39 AM
Points: 14, Visits: 50

Hi SQL Gurus,

I have recently installed SQL 2005 on a machine with OS Windows 2003 server.
while connecting to Integration services by default it selects windows authentication.

I need to log into SSIS with SQL server authentication but there is no choice as the popup is disabled.

Is this issue with installation...?

Any help, installtion steps will be appreciated...
(Hope i have explained properly......)

Thanks in advance.
- Vijayraj.

Post #573441

GSquared

Posted Monday, September 22, 2008 7:30 AM

SSCoach

Group: General Forum Members
Last Login: Monday, May 06, 2013 1:09 PM
Points: 15,439, Visits: 9,569

I'm not sure what you mean when you say you are trying to log in to SSIS.

Normally, the way I get into SSIS is by opening Visual Studio. That doesn't require a login.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Post #573483

Jason Crider

Posted Monday, September 22, 2008 8:44 AM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, May 09, 2013 8:43 PM
Points: 282, Visits: 2,121

From my experience it doesn't matter if you are hitting an engine or integration services. The only way I can get the box enabled is to use SQL Server logins. I believe the default action is to use the current authenticated windows user.

I haven't found a way around that but it doesn't mean there isn't one.

MCITP, Database Administrator
A hodgepodge of Information Technology and Life
LinkedIn Profile
My Twitter

Post #573572

« Prev Topic | Next Topic »

Permissions