Wednesday, March 21, 2012

Odd Rights Issue

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!
ChuckI 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
>|||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 Serv
er 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...
transforamtion[vbcol=seagreen]
>

No comments:

Post a Comment