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
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...
> 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
> thanks in advance
>|||Hi,
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...
> 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
> thanks in advance
>|||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.
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...
> 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.
> how to open the port 1433 '?
> 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...
> 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
> thanks in advance|||are you saying you get this error when trying to connect to sql server using
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...
> it also show "no associate trust SQL Server Connection"
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment