i having i workstation with running in windows 98, now i want link it to the
SQL server which are in windows 2000. when i try to link it the following e
rror message " no associate trust SQL Server Connection". Can i know how to
settle this problem
thanks in advanceare you trying to connect to the server using windows integrated
authentication? If so, make sure you're logged on to the domain in your
workstation before trying to connect to sql server. You might want to try to
connect using standard authentication (i.e using sa or another login) just
to verify you can connect to the server successfully. If this doesn't work,
make sure you can get to the server through tcp port 1433 (sql server port);
this can be tested using the following command:
telnet servername 1433
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 programming by Example
"how" <how_world@.hotmail.com> wrote in message
news:7A83A2A1-FE31-4439-B87D-2D50FE705A30@.microsoft.com...
quote:
> hi every one
> i having i workstation with running in windows 98, now i want link it to
the SQL server which are in windows 2000. when i try to link it the
following error message " no associate trust SQL Server Connection". Can i
know how to settle this problem
quote:|||Hi,
> thanks in advance
>
Windows 98 will only support SQL server Authentication.
So while linking from SQL 2000, use SQL server Login credentials.
Thanks
Hari
MCDBA
"how" <how_world@.hotmail.com> wrote in message
news:7A83A2A1-FE31-4439-B87D-2D50FE705A30@.microsoft.com...
quote:
> hi every one
> i having i workstation with running in windows 98, now i want link it to
the SQL server which are in windows 2000. when i try to link it the
following error message " no associate trust SQL Server Connection". Can i
know how to settle this problem
quote:|||when i using window intergrate authentication that can sucess link to the SQ
> thanks in advance
>
L server, but when i using the SQL authentication it fail at the end so what
should i do now.
how to open the port 1433 '?
thanks in advance|||is there a firewall between the client and the server? If they are in the
same network you don't have to open ports or anything.
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 programming by Example
"how" <anonymous@.discussions.microsoft.com> wrote in message
news:D6026E6E-7EE4-4739-A280-9EA3BAD30032@.microsoft.com...
quote:
> when i using window intergrate authentication that can sucess link to the
SQL server, but when i using the SQL authentication it fail at the end so
what should i do now.
quote:|||that r not any firewall install in that server, i just format and reinstall
> how to open the port 1433 '?
> thanks in advance
the window for that server. so waht action i can take
thanks in advance|||what error are you getting?
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 programming by Example
"how" <anonymous@.discussions.microsoft.com> wrote in message
news:1256EDE4-FAA1-4A10-BF29-AAD182FBC94A@.microsoft.com...
quote:
> that r not any firewall install in that server, i just format and
reinstall the window for that server. so waht action i can take
quote:|||it also show "no associate trust SQL Server Connection"|||are you saying you get this error when trying to connect to sql server using
> thanks in advance
STANDARD authentication? It's weird, that error shows up when you can't
connect to sql but using integrated authentication.
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 programming by Example
"how" <anonymous@.discussions.microsoft.com> wrote in message
news:85BAB5CE-BD59-4559-A7E1-1ED4A36596BE@.microsoft.com...
quote:
> it also show "no associate trust SQL Server Connection"
No comments:
Post a Comment