Real Simple Quetion - I think!

Hi Folks!
I am trying to use 1 computer running XP home networked to a machine using
XP Proand SQL Server (Desktop Edition from Developer) on 1 other computer.
My MSACESS ADP refuses to see the SQL server even though I can do file
shares/printer shares between the two. Is XP home or Desktop SQL incapable
of this? I really don't want to spend an exasperating weekend if its
futile!!
Thanks for youe help and advice,,,
Jim
Hi
Try comnection with the IP address, and not the machine name.
Also, if you are running Windows XP SP2:
SQL 2000 and XP SP2:
http://msdn.microsoft.com/library/de...ar_ts_7eur.asp
Regards
Mike
"JimD" wrote:

> Hi Folks!
> I am trying to use 1 computer running XP home networked to a machine using
> XP Proand SQL Server (Desktop Edition from Developer) on 1 other computer.
> My MSACESS ADP refuses to see the SQL server even though I can do file
> shares/printer shares between the two. Is XP home or Desktop SQL incapable
> of this? I really don't want to spend an exasperating weekend if its
> futile!!
> Thanks for youe help and advice,,,
> Jim
>
>
|||Hi,
If you have the XP SP2 firewall running then it may be blocking traffic to
SQL Server on port 1433.
It will by default. Take a look in the firewall.log file when you try to
connect...
"JimD" <jimd4115@.verizon.net> wrote in message
news:HcI5e.1264$1p4.1219@.trndny06...
> Hi Folks!
> I am trying to use 1 computer running XP home networked to a machine using
> XP Proand SQL Server (Desktop Edition from Developer) on 1 other computer.
> My MSACESS ADP refuses to see the SQL server even though I can do file
> shares/printer shares between the two. Is XP home or Desktop SQL incapable
> of this? I really don't want to spend an exasperating weekend if its
> futile!!
> Thanks for youe help and advice,,,
> Jim
>
|||Hi And Thank You!
I have firewall completely shut off on both machines and Norton AutoProtect
shutoff as well on both. I have TCP/IP ports set at 1433 on both as well. I
need to connect with the machine name as the app is written that way. Could
it possibly be something to do with accounts? I've tried Guest both on and
off to no avail on the marching running SQL Developer (Desktop) Edition. I
have tried for the last 12 hours and cannot even get Enterprise Manager to
connect. I'm going crazy and this is business critical. If anyone can
suggest anything else I'm, all ears...I need this connectivity by Monday
morning or I'm in big trouble...I've tried everything I can thing of...
Thanks so much...
Jim
jimd@.aries.com
"Mercury" <me@.spam.com> wrote in message
news:d38h1r$nn8$1@.lust.ihug.co.nz...
> Hi,
> If you have the XP SP2 firewall running then it may be blocking traffic to
> SQL Server on port 1433.
> It will by default. Take a look in the firewall.log file when you try to
> connect...
>
> "JimD" <jimd4115@.verizon.net> wrote in message
> news:HcI5e.1264$1p4.1219@.trndny06...
>
|||JimD wrote:
> I've tried Guest both on and off to no avail on the
> marching running SQL Developer (Desktop) Edition. I have tried for
> the last 12 hours and cannot even get Enterprise Manager to connect.
>
I'm confused. Do you have a SQL account to log in to the server? It
sounds like you may not know a valid account to use. Can you connect
using the IP address?
David Gugick
Imceda Software
www.imceda.com
|||look at the following MS KB Article:
http://support.microsoft.com/kb/319930/EN-US/
and you may want to look at the following too:
http://support.microsoft.com/default...;EN-US;q325003
Good luck!
"JimD" <jimd4115@.verizon.net> wrote in message
news:Kh06e.1815$4v3.304@.trndny03...
> Hi And Thank You!
> I have firewall completely shut off on both machines and Norton
AutoProtect
> shutoff as well on both. I have TCP/IP ports set at 1433 on both as well.
I
> need to connect with the machine name as the app is written that way.
Could[vbcol=seagreen]
> it possibly be something to do with accounts? I've tried Guest both on and
> off to no avail on the marching running SQL Developer (Desktop) Edition. I
> have tried for the last 12 hours and cannot even get Enterprise Manager to
> connect. I'm going crazy and this is business critical. If anyone can
> suggest anything else I'm, all ears...I need this connectivity by Monday
> morning or I'm in big trouble...I've tried everything I can thing of...
> Thanks so much...
> Jim
> jimd@.aries.com
> "Mercury" <me@.spam.com> wrote in message
> news:d38h1r$nn8$1@.lust.ihug.co.nz...
to
>
|||You should be able to find odbcping on the bin folder for sql server. lookup
BOL for info on how to use it.
(I didn't see it mentioned in the above links - but I could be blind).
"JimD" <jimd4115@.verizon.net> wrote in message
news:Kh06e.1815$4v3.304@.trndny03...
> Hi And Thank You!
> I have firewall completely shut off on both machines and Norton
> AutoProtect shutoff as well on both. I have TCP/IP ports set at 1433 on
> both as well. I need to connect with the machine name as the app is
> written that way. Could it possibly be something to do with accounts? I've
> tried Guest both on and off to no avail on the marching running SQL
> Developer (Desktop) Edition. I have tried for the last 12 hours and cannot
> even get Enterprise Manager to connect. I'm going crazy and this is
> business critical. If anyone can suggest anything else I'm, all ears...I
> need this connectivity by Monday morning or I'm in big trouble...I've
> tried everything I can thing of...
> Thanks so much...
> Jim
> jimd@.aries.com
> "Mercury" <me@.spam.com> wrote in message
> news:d38h1r$nn8$1@.lust.ihug.co.nz...
>
|||Hope this helps.
Search for the hosts file in your machine. you edit it with your notepad and
enter the machine name together with its IP address.
The downside of this is when your machine doesn't have a static IP, an
example of this is when it is getting its IP address from DHCP server, unless
you configure the DHCP server to reserve a certain IP address for the
machine, the IP address your machine will get may vary and you may need to
edit your hosts file everytime the IP address changes.
You may want to use DNS server in your network.
"JimD" wrote:

> Hi And Thank You!
> I have firewall completely shut off on both machines and Norton AutoProtect
> shutoff as well on both. I have TCP/IP ports set at 1433 on both as well. I
> need to connect with the machine name as the app is written that way. Could
> it possibly be something to do with accounts? I've tried Guest both on and
> off to no avail on the marching running SQL Developer (Desktop) Edition. I
> have tried for the last 12 hours and cannot even get Enterprise Manager to
> connect. I'm going crazy and this is business critical. If anyone can
> suggest anything else I'm, all ears...I need this connectivity by Monday
> morning or I'm in big trouble...I've tried everything I can thing of...
> Thanks so much...
> Jim
> jimd@.aries.com
> "Mercury" <me@.spam.com> wrote in message
> news:d38h1r$nn8$1@.lust.ihug.co.nz...
>
>
|||Are you using MSDE SP3a? If so, network access is turned off by default for
security reasons (slammer is one of the reasons). You'll need to turn it
back on so you can access your MSDE from a remote machine via the network.
joe.
"JimD" <jimd4115@.verizon.net> wrote in message
news:Kh06e.1815$4v3.304@.trndny03...
> Hi And Thank You!
> I have firewall completely shut off on both machines and Norton
AutoProtect
> shutoff as well on both. I have TCP/IP ports set at 1433 on both as well.
I
> need to connect with the machine name as the app is written that way.
Could[vbcol=seagreen]
> it possibly be something to do with accounts? I've tried Guest both on and
> off to no avail on the marching running SQL Developer (Desktop) Edition. I
> have tried for the last 12 hours and cannot even get Enterprise Manager to
> connect. I'm going crazy and this is business critical. If anyone can
> suggest anything else I'm, all ears...I need this connectivity by Monday
> morning or I'm in big trouble...I've tried everything I can thing of...
> Thanks so much...
> Jim
> jimd@.aries.com
> "Mercury" <me@.spam.com> wrote in message
> news:d38h1r$nn8$1@.lust.ihug.co.nz...
to
>