Cannot connect remotely to MSDE2000 database

Hi,
I have a win98 Pc connecting to a winxp pc - trying to connect to the
MSDE2000 database - the database is operating in mixed mode (allows SQL
logins) rather than windows integrated. The database is working ok on winxp
pc - i can use the SQL Web Data adminsitrator to verify that SQL Logins work
ok - also the ODBC Adminstrator can make connections to the database.
Now when i try using the ODBC Administrator to connect using the same
details it fails - SQL server does not exist or access denied.
Now i have disabled windows firewall to rule that out (although i had
enabled port 1433- sql server listening port).
Now how can i verify SQL server is listening on port 1433 for remote
connections?
How do i configre SQL server to listen for remote connections?
Any other ideas for resolving my connection problem?
Thanks a lot!
hi John,
John Blair wrote:
> Hi,
> I have a win98 Pc connecting to a winxp pc - trying to connect to the
> MSDE2000 database - the database is operating in mixed mode (allows
> SQL logins) rather than windows integrated. The database is working
> ok on winxp pc - i can use the SQL Web Data adminsitrator to verify
> that SQL Logins work ok - also the ODBC Adminstrator can make
> connections to the database.
> Now when i try using the ODBC Administrator to connect using the same
> details it fails - SQL server does not exist or access denied.
> Now i have disabled windows firewall to rule that out (although i had
> enabled port 1433- sql server listening port).
> Now how can i verify SQL server is listening on port 1433 for remote
> connections?
> How do i configre SQL server to listen for remote connections?
> Any other ideas for resolving my connection problem?
> Thanks a lot!
please verify, using Server Network Utility (svrnetcn.exe), that the MSDE
instance allows remote connections via the desired/required network
protocol...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks a lot - very immpressed - that did the trick - TCP/IP protocol was
disabled - i enabled it and it worked!
I've spent 2 days trying to get this working - eventually found out the
registry needed changing to allow mixed mode (SQL login)- found out my
firewall was blocking port 1433 - and finally your suggestion for enabling
the protocol - never even heard of that utility svrnetcn.exe - thanks very
much! John.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:37md0nF5eceloU1@.individual.net...
> hi John,
> John Blair wrote:
> please verify, using Server Network Utility (svrnetcn.exe), that the MSDE
> instance allows remote connections via the desired/required network
> protocol...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||Exposing SQL through a firewall by opening port 1433 is generally considered
to be a bad thing.
-Andrew
"John Blair" <john_blair@.hotmail.com> wrote in message
news:H2oRd.910$gv6.611@.newsfe3-gui.ntli.net...
> Thanks a lot - very immpressed - that did the trick - TCP/IP protocol was
> disabled - i enabled it and it worked!
> I've spent 2 days trying to get this working - eventually found out the
> registry needed changing to allow mixed mode (SQL login)- found out my
> firewall was blocking port 1433 - and finally your suggestion for enabling
> the protocol - never even heard of that utility svrnetcn.exe - thanks very
> much! John.
>
> "Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
> news:37md0nF5eceloU1@.individual.net...
>
|||I am only exposing this port on a local intranet - so i wasn't aware that
there are any security risks. Do you have a better way of letting VB6 apps
access a remote SQL Server database? Thanks.
"Andrew" <nemoby@.nospam.nospam> wrote in message
news:uVC2%23ofFFHA.4016@.TK2MSFTNGP09.phx.gbl...
> Exposing SQL through a firewall by opening port 1433 is generally
> considered to be a bad thing.
> -Andrew
> "John Blair" <john_blair@.hotmail.com> wrote in message
> news:H2oRd.910$gv6.611@.newsfe3-gui.ntli.net...
>