MSDE /XP Problem -Please Help

Hi,
I have2 machines connected to each other. Both the systems
have MS XP operating systems with SP2 patch on them. I
have installed MSDE SP3 on both the systems.
I would like to run a query from one machine on a database
on the other using osql.I was unable to. It gives an error
saying "Access denied"
Are there any settings that i will have to change. I want
one to be like a server and another a client. Each has
its own database.
osql -Usa -Ppassword -S<servername> <enter>
Does not work.
-ZS
If you aren't getting a logon failure, check to make sure you have port 1433
(or the MSDE sqlserver exe) set up as an exception in the XP SP2 firewall
settings.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"ZS" <anonymous@.discussions.microsoft.com> wrote in message
news:07f001c4b7af$fc2835f0$a301280a@.phx.gbl...
> Hi,
> I have2 machines connected to each other. Both the systems
> have MS XP operating systems with SP2 patch on them. I
> have installed MSDE SP3 on both the systems.
> I would like to run a query from one machine on a database
> on the other using osql.I was unable to. It gives an error
> saying "Access denied"
> Are there any settings that i will have to change. I want
> one to be like a server and another a client. Each has
> its own database.
> osql -Usa -Ppassword -S<servername> <enter>
> Does not work.
> -ZS
>
>
|||Thanks Greg. Yes the problem was with the firewall.
So it is fixed now. Thanks.
=ZS
>--Original Message--
>If you aren't getting a logon failure, check to make sure
you have port 1433
>(or the MSDE sqlserver exe) set up as an exception in the
XP SP2 firewall
>settings.
>HTH,
>--
>Greg Low [MVP]
>MSDE Manager SQL Tools
>www.whitebearconsulting.com
>"ZS" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:07f001c4b7af$fc2835f0$a301280a@.phx.gbl...
systems[vbcol=seagreen]
database[vbcol=seagreen]
error[vbcol=seagreen]
want
>
>.
>

MSDE / ODBC install problem...please help...

I have installed MSDE (and ODBC) at my client site on their 2003 server. I
have attached my SQL database via Teratrax Database Manager to the MSDE
server however when I try to setup the ODBC connection it doesn't list the
database in the drop-down. I cannot attach to the database from my notebook
either because I am not authenticated onto their domain.
I have also applied the regedit on the LoginMode key setting it to 2 and
rebooted but I still cannot connect to the database via the ODBC manager.
What am I doing wrong? I am NOT good with the scripts for configuring things
- generally I use the Enterprise Manager.
Try running the client config (cliconfig.exe) and create an alias for the
server. Specify the protocol to talk to it - (probably TCP/IP vs. named
pipes). On my system its in \windows\system32.
Brian
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:46518420-EF43-475F-BECA-9E5A7E6A21D2@.microsoft.com...
>I have installed MSDE (and ODBC) at my client site on their 2003 server. I
> have attached my SQL database via Teratrax Database Manager to the MSDE
> server however when I try to setup the ODBC connection it doesn't list the
> database in the drop-down. I cannot attach to the database from my
> notebook
> either because I am not authenticated onto their domain.
> I have also applied the regedit on the LoginMode key setting it to 2 and
> rebooted but I still cannot connect to the database via the ODBC manager.
> What am I doing wrong? I am NOT good with the scripts for configuring
> things
> - generally I use the Enterprise Manager.