I reapplied SP 4 and it works now...I think I did not check the blank
password box during install. Luckily it is a test server. Thanks for the
help.

-----Original Message-----
From: Long, Charles (euler:eti) [mailto:Charles.[Email Address Removed] Tuesday, June 11, 2002 10:32 AM
To: 'Shawn Smith'
Subject: RE: SA Permission issue


Lets start with the ODBC data source; on the second window displayed - after
source name and description and server idf have been entered - I get 'How
should SQL Server verify the authenticity of the login ID?'; underneath are
two radio buttons - 'With Windows NT...........' and 'With SQL Server...';
if you are wanting to log in as sa, you need to reset these from the default
'With Windows Nt' to 'With SQL Server..'. Since DTS will be using the ODBC
source this should fix the lot. Apologies, if I'm ending up on egg-sucking
for grandmothers - but this is exactly what the error message sounds like.

> -----Original Message-----
> From: Shawn Smith [SMTP:[Email Address Removed] Sent: Tuesday, June 11, 2002 4:20 PM
> To: 'Long, Charles (euler:eti)'; '[Email Address Removed] Subject: RE: SA Permission issue
>
> Check which boxes, on server or Client. Why do I get error DTS on the
> server? I think something happened when I went to service pack 4, any
> clues why?
>
> -----Original Message-----
> From: Long, Charles (euler:eti) [ <mailto:Charles.[Email Address Removed]
> Sent: Tuesday, June 11, 2002 10:11 AM
> To: 'Shawn Smith'; '[Email Address Removed]
> Subject: RE: SA Permission issue
>
>
> GUI connection handlers usually have a check box for Trusted Connection or
>
> SQL Security; sounds like you're supplying a SQL login while requesting
> 'Trusted Connectio'; check your check boxes.
>
> > -----Original Message-----
> > From: Shawn Smith [SMTP:[Email Address Removed]
> > Sent: Tuesday, June 11, 2002 3:56 PM
> > To: '[Email Address Removed]
> > Subject: SA Permission issue
> >
> > When trying to DTS or setup DSN for application I get the following
> error.
> >
> > Login Failed fro sa. Not associated with a trusted SQL Server
> Connection.
> >
> > What is going on? I can connect to it through Enterprise Manager and
> Query
> > Analyzer. I am running SQL 7 with Service Pack 4.
> >
> > Shawn Smith
> > Database Administrator
> > Fort Worth Star-Telegram
> > 817-390-7094
> > 817-291-5240 cell
> > 817-667-2757 pager
> > [Email Address Removed]
> >
>
MS Sql Server LazyDBA home page