Re: Odd Rights Issue
From: CR (chuck.rich__ardson_at_sfcc.edu)
Date: 08/29/05
- Next message: Ben: "Users and Truncate Table"
- Previous message: Shri.DBA: "Re: viewing existing aliases"
- In reply to: CR: "Re: Odd Rights Issue"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 29 Aug 2005 14:20:37 -0400
I figured it out -- the problem client was missing a cleint network alias
for the server. Problem had nothing to do with XP or SP4.
"CR" <chuck.rich__ardson@sfcc.edu> wrote in message
news:OxYvzKLrFHA.716@TK2MSFTNGP10.phx.gbl...
> I forgot to include the actual error message in WinXP client:
>
> Error Source : Microsoft OLE DB Provider for SQL Server
> Error Description : [DNETLIB][ConnectionOpen (Connect()).]SQL Server does
> not exist or access denied.
>
> WinXP client has no difficulty registering the server and doing other
> functions. Since exact same account works on another client, leads me to
> believe something about either XP or SP4 that's causing the problem. Can
> SP4 cleint connect to SP3a server?
>
>
> "CR" <chuck.rich__ardson@sfcc.edu> wrote in message
> news:eZItbHLrFHA.2896@TK2MSFTNGP10.phx.gbl...
> > SQL Server 2000 Server at SP3a
> >
> > WinXP SQL Server 2000 Client at SP4
> > Win2K SQL Server 2000 Client at SP3a
> >
> > Identical local user account setup on both clients using peer-to-peer
> > windows authentication to server.
> >
> > The account on Win2K client at SP3a can successfully open pre-existing
> > transformation tasks in DTS.
> > The account on WinXP client at SP4 cannot open pre-existing
transforamtion
> > tasks in DTS (but can create new ones okay).
> >
> > What gives? Thanks for any help anyone can offer!
> >
> > Chuck
> >
> >
>
>
- Next message: Ben: "Users and Truncate Table"
- Previous message: Shri.DBA: "Re: viewing existing aliases"
- In reply to: CR: "Re: Odd Rights Issue"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|