Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Installation - SQL Server Authentication for SSIS Expand / Collapse
Author
Message
Posted Monday, September 22, 2008 6:45 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Monday, September 22, 2008 7:30 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 9:58 AM
Points: 13,872, Visits: 9,600
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
Posted Monday, September 22, 2008 8:44 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, September 22, 2014 10:56 PM
Points: 282, Visits: 2,212
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 »

Add to briefcase

Permissions Expand / Collapse