MSSQLSERVER connect problem. 1

[JonMa]

Hello.
I have just installed MSDE 2000 with all the latest updates and advice for XP service pack 2. I can connect to any database using (local) or the direct IP-address but when I use MSSQLSERVER I get the error:

Error == [DBNETLIB][ConnectionOpen (Connect()).]SQL-server does not exist or there is no permitted access to it (translated from another language).

Hope someone can help.

 

[mrdenny]

You won't be able to connect to MSSQLSERVER unless that is the name of the machine. When you are connecting you should put in the name of the machine that you installed MSDE on.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[JonMa]

Hi.
Thank you for your kind comment, that clearify some of my misunderstanding.
I've tried to use the computername but that did not work either, however that it is of no importance to me. What is important is that I get the following error when using asp from web to my local computer:

Microsoft OLE DB Provider for SQL Server error '80004005'

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

I use the following source:
objConn.Open "PROVIDER=SQLOLEDB;" & _
" DATA SOURCE=130.67.18.171;" & _
" INITIAL CATALOG=Arkivsql;" & _
" USER ID=test;" & _
" PWD=test;"

 

[pytzamarama]

I don t know if this means something but SP2 allows up to 5 (or a bit more) connections at the same time

 

[mrdenny]

I see that you said that you have XP with SP2 installed. Please check the firewall config. By default SP2 activates the builtin firewall which will by default block connections to SQL Server. You will want to allow access to TCP port 1433 on our machine.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[JonMa]

Hi Denny.
All problems solved thanks to you. You are a genius.
Also I've found out that I had not upgraded MSDE correctly.
I installed MSDE again directly from the update file SP3a.
Thanks.
Jon.