| Author |
Re: Problems connecting to SQL server on W2K3 from Win 2000 workst
|
|
| Mike Allen 2005-06-02, 11:23 am |
| The machines are in the same domain. The user I am logged on to the windows
2000 machine is a domain admin account.
"Mike Bulava" wrote:
> This is because you are using Windows authentication without a domain setup.
> If you aren't using a domain you shouldn't use windows authentication
> because it tends not to work, use SQL Authentication and you'll always
> connect. The problem is mainly that the users you are signed in to the W2k
> box doesn't match a user on the W2k3 box, or the user isn't passed properly
> to SQL, or if you really want to setup Windows authentication use to put the
> workstations that servers into a domain..
>
> Thanks,
> Mike Bulava, MCDBA
>
>
> "Mike Allen" < MikeAllen@discussion
s.microsoft.com> wrote in message
> news:071EE849-F61A-4729-8598- 67974D2D5269@microso
ft.com...
>
>
>
| |
| Mike Bulava 2005-06-02, 11:23 am |
| Are you sure you're signing the Station in to the domain and you're not just
signing in locally? Can you connect to a network share on the SQL server?
Also I know this isn't as important on 2k machines but is the primary DNS
server that is listed on the 2k station the Ip address of the w2k3 DC (which
is usally a DNS server too)? That could make a differance.
Mike Bulava, MCDBA
"Mike Allen" < MikeAllen@discussion
s.microsoft.com> wrote in message
news:997CBCF5-5D74-4A02-8C20- 09E43C624B88@microso
ft.com...[color=darkred]
> The machines are in the same domain. The user I am logged on to the
> windows
> 2000 machine is a domain admin account.
>
> "Mike Bulava" wrote:
>
| |
| Mike Allen 2005-06-02, 8:23 pm |
| Yes, I'm loggin in to the domain. I can map a drive to to that SQL server.
I'll have to check the DNS issue.
Thanks
"Mike Bulava" wrote:
> Are you sure you're signing the Station in to the domain and you're not just
> signing in locally? Can you connect to a network share on the SQL server?
> Also I know this isn't as important on 2k machines but is the primary DNS
> server that is listed on the 2k station the Ip address of the w2k3 DC (which
> is usally a DNS server too)? That could make a differance.
>
> Mike Bulava, MCDBA
>
>
> "Mike Allen" < MikeAllen@discussion
s.microsoft.com> wrote in message
> news:997CBCF5-5D74-4A02-8C20- 09E43C624B88@microso
ft.com...
>
>
>
| |
| Mike Allen 2005-06-06, 11:23 am |
| Checked the DNS IP address and they are pointing to the same DNS server. Any
more ideas?
"Mike Allen" wrote:
[color=darkred]
> Yes, I'm loggin in to the domain. I can map a drive to to that SQL server.
> I'll have to check the DNS issue.
>
> Thanks
>
> "Mike Bulava" wrote:
>
|
|
|
|