linked win2003 server with sql2000 problem

I have two new win2003 server running sql2000. I am using mapped logins to
get from a win2000/sql2000 to win2003/sql2000 and am getting access denied.
Everything is set up exactly the same on machines running this config with
win2000 and am having no problems. I have also enabled DTC access in the
control panel.
Any ideas?
nivek"nivek" <eckart_612@.hotmail.com> wrote in message
news:Qu2dneQ3kP9hA4HfRVn-pA@.centurytel.net...
> I have two new win2003 server running sql2000. I am using mapped logins to
> get from a win2000/sql2000 to win2003/sql2000 and am getting access
denied.
> Everything is set up exactly the same on machines running this config with
> win2000 and am having no problems. I have also enabled DTC access in the
> control panel.
> Any ideas?
What security mode are you using for SQL Server? Can you use the mapped
login locally on the Windows Server 2003? Keep in mind that compared to
Windows Server 2000, almost everything security related is disabled or
restricted in Windows Server 2003...
Steve|||> What security mode are you using for SQL Server?
We are using mixed mode authentication

>Can you use the mapped login locally on the Windows Server 2003?
yes
"Steve Thompson" <stevethompson@.nomail.please> wrote in message
news:%237JhVBcGFHA.2356@.TK2MSFTNGP12.phx.gbl...
> "nivek" <eckart_612@.hotmail.com> wrote in message
> news:Qu2dneQ3kP9hA4HfRVn-pA@.centurytel.net...
> denied.
> What security mode are you using for SQL Server? Can you use the mapped
> login locally on the Windows Server 2003? Keep in mind that compared to
> Windows Server 2000, almost everything security related is disabled or
> restricted in Windows Server 2003...
> Steve
>|||Does the user account/password have access to the server (hosting sql
server) itself? As a test you could temporarily enable the guest account on
the server.
Also, you may want to the SQL Server security setting, enable failed login,
check the sql server logs for failed login entries.
Steve
"nivek" <eckart_612@.hotmail.com> wrote in message
news:cfmdnW979cCRNIHfRVn-rQ@.centurytel.net...
> We are using mixed mode authentication
>
> yes
>
> "Steve Thompson" <stevethompson@.nomail.please> wrote in message
> news:%237JhVBcGFHA.2356@.TK2MSFTNGP12.phx.gbl...
the[vbcol=seagreen]
>|||It looks like it isnt even hitting the sql server. I dont think its getting
past the OS level.
"Steve Thompson" <stevethompson@.nomail.please> wrote in message
news:erdbPCeGFHA.3912@.TK2MSFTNGP10.phx.gbl...
> Does the user account/password have access to the server (hosting sql
> server) itself? As a test you could temporarily enable the guest account
> on
> the server.
> Also, you may want to the SQL Server security setting, enable failed
> login,
> check the sql server logs for failed login entries.
> Steve
> "nivek" <eckart_612@.hotmail.com> wrote in message
> news:cfmdnW979cCRNIHfRVn-rQ@.centurytel.net...
> the
>|||I suspected that... did you try enabling the Guest account? If that works
you'll need to allow the user account/group to have access to the server
itself. Windows 2000 server allowed anonymous access, Windows 2003 server
does not.
Steve
"nivek" <eckart_612@.hotmail.com> wrote in message
news:iYmdnV7RpanVdIHfRVn-rA@.centurytel.net...
> It looks like it isnt even hitting the sql server. I dont think its
getting
> past the OS level.
>
> "Steve Thompson" <stevethompson@.nomail.please> wrote in message
> news:erdbPCeGFHA.3912@.TK2MSFTNGP10.phx.gbl...
config[vbcol=seagreen]
mapped[vbcol=seagreen]
to[vbcol=seagreen]
or[vbcol=seagreen]
>|||Guest account enabled, no luck with linked server though.
"Steve Thompson" <stevethompson@.nomail.please> wrote in message
news:%23SfhpfeGFHA.1476@.TK2MSFTNGP09.phx.gbl...
>I suspected that... did you try enabling the Guest account? If that works
> you'll need to allow the user account/group to have access to the server
> itself. Windows 2000 server allowed anonymous access, Windows 2003 server
> does not.
> Steve
> "nivek" <eckart_612@.hotmail.com> wrote in message
> news:iYmdnV7RpanVdIHfRVn-rA@.centurytel.net...
> getting
> config
> mapped
> to
> or
>|||Got it working. Created an alias on the Win2000 machine to connect with
tcp/ip to the Win2003 machine, Everything is working great.
Not really a fix, but its good for now. Looks like lots of people are having
this problem, maybe it will be addressed formally by MS soon
"nivek" <eckart_612@.hotmail.com> wrote in message
news:Qu2dneQ3kP9hA4HfRVn-pA@.centurytel.net...
>I have two new win2003 server running sql2000. I am using mapped logins to
>get from a win2000/sql2000 to win2003/sql2000 and am getting access denied.
>Everything is set up exactly the same on machines running this config with
>win2000 and am having no problems. I have also enabled DTC access in the
>control panel.
> Any ideas?
> nivek
>