can someone please help

xX.blood.Xx · 04/18/2009, 14:38

Hi can some1 help
with this error i have no matter what i do or edit
it stays the same

odbc is made the account tests pass with no problems

shakibsaidahmd · 04/18/2009, 15:03

man can u add my msn?? iwil try to help

ad me and we talk in msn

~~*P*A*U*L*~~ · 04/18/2009, 19:28

reinstall SQL and while installing choose dual authentication mode (SQL + windows)

xX.blood.Xx · 04/19/2009, 04:53

Quote:

Originally Posted by maniek12

reinstall SQL and while installing choose dual authentication mode (SQL + windows)

already done that.
reinstalled about 5 times now still doesnt work

PapaHarni · 04/19/2009, 06:21

Wrong SQL version? I think u use MSSQL 2005 or MSSQL MSDE 2000 not MSSQL 2000 Enterprise Edition the English version with SP 4 .

You have activated the IP/TCP protocol? You have check the SQL Server Port?

I've the same error on begin , i have used MSSQL 2005 not MSSQL 2000 E.M. the English version

xX.blood.Xx · 04/19/2009, 10:13

Its ok thanks for the ideas
i figured out the problem

the problem actually lies with sql server 2000.

even tho the defult ports are set and what not the
server wasnt actually listening on that port
and there for it would not connect.

after installing service pack 3 it worked perfectly.

so cheers and thanks for trying to help me out.