can someone please help

04/18/2009 14:38 xX.blood.Xx#1

Hi can some1 help
with this error i have no matter what i do or edit
it stays the same
[Only registered and activated users can see links. Click Here To Register...]

odbc is made the account tests pass with no problems

04/18/2009 15:03 shakibsaidahmd#2

man can u add my msn?? iwil try to help [Only registered and activated users can see links. Click Here To Register...] ad me and we talk in msn

04/18/2009 19:28 *P*A*U*L*#3

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

04/19/2009 04:53 xX.blood.Xx#4

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

04/19/2009 06:21 PapaHarni#5

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

04/19/2009 10:13 xX.blood.Xx#6

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.