Problem when making account

[Lazy]

Hi,

i'm using chumpy's server files now whit the database files
evrything installed, logs say database connect succes, so server is ok

ok, Now when i open query and type, exec cabal_tool_registerAccount 'test','test'
i get this error:

Server: Msg 515, Level 16, State 2, Procedure cabal_tool_registerAccount, Line 10
Cannot insert the value NULL into column 'Password', table 'ACCOUNT.dbo.cabal_auth_table'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Server: Msg 515, Level 16, State 2, Procedure cabal_tool_registerAccount, Line 16
Cannot insert the value NULL into column 'UserNum', table 'ACCOUNT.dbo.cabal_charge_auth'; column does not allow nulls. INSERT fails.
The statement has been terminated.

(1 row(s) affected)

xp_md5.dll is installed in master db
Reinstalled sql allready few times
Restored account db

i'm out of ideas

Chumpy or someone els, Help is appreciated

Thanks in Advance, Lazy

[MentaL]

[chumpywumpy]

I have not actually had this happen myself but apparently setting the UserNum column in the database to allow nulls fixes it.

[Lazy]

Hi,
if i click allow NULLS
tells me this:

Allow Nulls property cannot be set on a column which is part of the primary key.

bum bum

Thanks in Advance, Lazy

[chumpywumpy]

Ok, on your account db try the following query to test md5 is working properly as the password should not be null:

select dbo.fn_md5('test');

[Lazy]

Ok, on your account db try the following query to test md5 is working properly as the password should not be null:

select dbo.fn_md5('test');

Hi, ok did that

__| (No Column name) |
1_|NULL

Thanks in Advance, Lazy

[chumpywumpy]

There is the problem, md5 isn't working as you should get 098f6bcd4621d373cade4e832627b4f6. Check the Extended Procedures folder of yor master db and check the path to xp_md5.dll is correct and also check the permissions on the .dll to make sure the "everyone" group has read access at least.

Also, if the db server runs a 64 bit operating system check the FAQ sticky in this section for john_d's 64 bit tips. If you use mssql 2005 express on a 64 bit OS make sure it is the advanced services one too.

[Lazy]

Hi, i'm using sql 2000(whit your files), couze i cant work whit the 2005, 2000 is easyer for me
but, k gone check that

Edit: Chumpy Thanks bro, did what you said its working now
Hope i'm Able to connect now :p

Thanks, Lazy