error connecting to msde

Hi everybody this is my problem:
I've just installed MSDE2000 on my machine an it all works fine.
I'm able to create tables, storedprocedures whithin an access project, but i
cant' connect any client, i tried to use the ip address and also the
computer name but it doesnt' connect.
I receive a strange error:
(it's a free traslation from italian)
not supported interface
[dbbetlib][connectionOpen]Connect())] Sql server not exist o denied access
the parameters used for the installations were:
setup SAPWD="mypwd"
SECURITYMODE=SQL
DISABLENETWORKPROTOCOLS=0
hi,
ciroteo wrote:
> Hi everybody this is my problem:
> I've just installed MSDE2000 on my machine an it all works fine.
> I'm able to create tables, storedprocedures whithin an access
> project, but i cant' connect any client, i tried to use the ip
> address and also the computer name but it doesnt' connect.
> I receive a strange error:
> (it's a free traslation from italian)
> not supported interface
> [dbbetlib][connectionOpen]Connect())] Sql server not exist o denied
> access
> the parameters used for the installations were:
> setup SAPWD="mypwd"
> SECURITYMODE=SQL
> DISABLENETWORKPROTOCOLS=0
please have a look at
http://support.microsoft.com/default...06&Product=sql
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
|||"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> ha scritto nel messaggio
news:36bjn6F4vqnh0U1@.individual.net...
> hi,
> ciroteo wrote:
> please have a look at
> http://support.microsoft.com/default...06&Product=sql
> --
> 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
>
Ciao andrea grazie per la risposta, credo sia un problema di windows
firewall, perch avendo fatto un'altra installazione su un pc dove
disabilitato funziona tutto correttamente ...
bah!
ciao
|||hi,
ciroteo wrote:
> Ciao andrea grazie per la risposta, credo sia un problema di windows
> firewall, perch avendo fatto un'altra installazione su un pc dove
> disabilitato funziona tutto correttamente ...
> bah!
> ciao
as we are on an english NG, it's better to continue in english language (or
the better sort of... :D)
if it may depends on Windows Firewall, you can have a look
http://support.microsoft.com/default.aspx?kbid=841249
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
|||"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> ha scritto nel messaggio
news:36bp7qF4v61k0U1@.individual.net...
> hi,
> ciroteo wrote:
> as we are on an english NG, it's better to continue in english language
> (or
> the better sort of... :D)
> if it may depends on Windows Firewall, you can have a look
> http://support.microsoft.com/default.aspx?kbid=841249
> --
> 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
>
Ok sorry! You are right.
I'll check it out, thank you so much.
|||"ciroteo" <ciroteo_chiocciola@.libero.it> ha scritto nel messaggio
news:ev03tTRCFHA.392@.TK2MSFTNGP14.phx.gbl...
> "Andrea Montanari" <andrea.sqlDMO@.virgilio.it> ha scritto nel messaggio
> news:36bp7qF4v61k0U1@.individual.net...
>
> Ok sorry! You are right.
> I'll check it out, thank you so much.
>
>
If the pc isn't in the same domain as server, or it has a different
operative system (i.e. win98) is it possbile to receive a connection error?
|||hi,
ciroteo wrote:

> If the pc isn't in the same domain as server, or it has a different
> operative system (i.e. win98) is it possbile to receive a connection
> error?
as regard different OSs, this is not a problem at all, as all the related
traffic is handled by the MDAC stack and the network protocols subsystem...
as regard the domain... it depends... you can connect to web hosted servers,
which for sure are not on the same domain of the remote client, but the
connecting pc has to be recognized some way by the server... as trusted
authenticated connections are not available in this scenario, SQL Server
authenticated connection are usually used...
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