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 - 17207, udopen: Operating system error 32(error not found) during the creation/openi

Hi there
I'm hoping somebody here can help with this problem. In the Application Event Viewer we're seeing a problem. The error message is below
The description for Event ID ( 17055 ) in Source ( MSSQLSERVER ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: 17207, udopen: Operating system error 32(error not found) during the creation/opening of physical device C:\Program Files\Microsoft SQL Server\MSSQL\Data\Genifax.mdf
Its promptly followed by this error
The description for Event ID ( 17055 ) in Source ( MSSQLSERVER ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: 17204, FCB::Open failed: Could not open device C:\Program Files\Microsoft SQL Server\MSSQL\Data\Genifax.mdf for virtual device number (VDN) 1
The machine is running MSDE as its SQL Server and has two DBs
DB on D: which is 148,628k
DB on C: which is 237,568k
I'm pretty stuck on this one, so if anybody knows what's causing this problem, and more importantly how I can go about fixing it, it'd be most appreciated - I'm no SQL Guru and haven't been able to find a huge amount on knowledgebase searches or google searches
Thanks in anticipation
Steve S
stevesdmREMOVETHIS@.hotmail.comI dont know if this will help anyone, but the sql log shows this
2004-05-26 12:33:58.27 spid7 Starting up database 'Genifax'
2004-05-26 12:34:56.71 spid52 Starting up database 'Genifax'
2004-05-26 12:34:58.60 spid7 Starting up database 'Genifax'
2004-05-26 12:35:06.49 spid52 Starting up database 'Genifax'
2004-05-26 12:35:28.27 spid7 Starting up database 'Genifax'
2004-05-26 12:35:53.69 spid52 Starting up database 'Genifax'
2004-05-26 12:35:58.68 spid7 Starting up database 'Genifax'
2004-05-26 12:36:00.65 spid52 Starting up database 'Genifax'
2004-05-26 12:36:28.43 spid7 Starting up database 'Genifax'
2004-05-26 12:36:53.69 spid52 Starting up database 'Genifax'
2004-05-26 12:37:52.49 spid52 Starting up database 'Genifax'
2004-05-26 12:38:01.08 spid52 Starting up database 'Genifax'
2004-05-26 12:38:53.72 spid52 Starting up database 'Genifax'
2004-05-26 12:38:53.72 spid52 udopen: Operating system error 32(error not found) during the creation/opening of physical device C:\Program Files\Microsoft SQL Server\MSSQL\Data\Genifax.mdf
2004-05-26 12:38:53.74 spid52 FCB::Open failed: Could not open device C:\Program Files\Microsoft SQL Server\MSSQL\Data\Genifax.mdf for virtual device number (VDN) 1
2004-05-26 13:23:09.55 spid3 SQL Server is terminating due to 'stop' request from Service Control Manager
The bottom line is where MSDE is restarted (which cures the problem for a day or two upon which MSDE causes problems again)
Like I said in my last message, any help is very very much appreciated
Thanks
Stev