September 22, 2008 at 6:45 am
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.
September 22, 2008 at 7:30 am
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
September 22, 2008 at 8:44 am
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply