Cannot login

[winword]

The server is started and no errors on logs... the problem is i cant login... im using chumpy's repack...

when i login, it will say invalid account if password/username is invalid but if i enter the correct username and password (which i registered) it say server connection failed?

 

[sevenmore]

Use the login fix or w/e that is + sauron patch

 

[winword]

applied it already sir...
i guess i found the error:

EXECUTE permission denied on object 'xp_md5', database 'master', owner 'dbo'.

how to fix this?

 

[cypher]

I should have watched my mouth and not said/talked poop to DeadlyData telling him things like your are not welcome here because then I become the one who is truly not welcome here.

 

[sevenmore]

EXECUTE permission denied on object 'xp_md5', database 'master', owner 'dbo'" You need to add md5 to your database, search the forum and you`ll find the soulution.

That's not the fix. You need to make the cabal user being the owner of the db, or even better don't make the user name cabal, make it cabalserver.

 

[winword]

i added the xp_md5.dll already sir...

ill try...
so it means on the security i will add a user named 'cabal'?

log from the GlobalDBAgent.

[Thu Aug 28 2008 22:56:58.341572 3013094304]: [##ERROR##] DB ERROR(STM_TEXT) : {                                             call cabal_sp_auth( ?               , ?               , ?          ,  ?                                                            )}
[Thu Aug 28 2008 22:56:58.548548 3013094304]: Database Connect success!
[Thu Aug 28 2008 22:56:58.548689 3013094304]: [##ERROR##] 'OnIPCAuthAccount' fai                                             l (Database/Auth.cpp:283)
[Thu Aug 28 2008 22:56:58.548729 3013094304]: [##ERROR##] UsrMap Fail : MainCmd(                                             30) Ret(11B:0:283) Addr(127.0.0.1)
[Thu Aug 28 2008 22:57:47.928933 3044563872]: [##ERROR##] OnIPCAuthAccount fail                                              (usernum: 0)
[Thu Aug 28 2008 22:57:47.929256 3044563872]: [##ERROR##] DB ERROR(MSG)      : [                                             FreeTDS][SQL Server]EXECUTE permission denied on object 'xp_md5', database 'mast                                             er', owner 'dbo'.
[Thu Aug 28 2008 22:57:47.929593 3044563872]: [##ERROR##] DB ERROR(CODE)     : 2                                             29
[Thu Aug 28 2008 22:57:47.929618 3044563872]: [##ERROR##] DB ERROR(VAR_INFO) :
[Thu Aug 28 2008 22:57:47.929642 3044563872]: [##ERROR##] DB ERROR(SQLSTATE) : 4                                             2000
[Thu Aug 28 2008 22:57:47.929666 3044563872]: [##ERROR##] DB ERROR(STM_TEXT) : {                                             call cabal_sp_auth( ?               , ?               , ?          ,  ?                                                            )}
[Thu Aug 28 2008 22:57:49.663280 3044563872]: Database Connect success!
[Thu Aug 28 2008 22:57:49.663847 3044563872]: [##ERROR##] 'OnIPCAuthAccount' fai                                             l (Database/Auth.cpp:283)
[Thu Aug 28 2008 22:57:49.663881 3044563872]: [##ERROR##] UsrMap Fail : MainCmd(                                             30) Ret(11B:0:283) Addr(127.0.0.1)
[Thu Aug 28 2008 22:58:28.712963 3065543584]: Database Connect success!
[Thu Aug 28 2008 22:58:31.252684 3065543584]: [##ERROR##] OnIPCAuthAccount fail                                              (usernum: 0)
[Thu Aug 28 2008 22:58:31.254681 3065543584]: [##ERROR##] DB ERROR(MSG)      : [                                             FreeTDS][SQL Server]EXECUTE permission denied on object 'xp_md5', database 'mast                                             er', owner 'dbo'.
[Thu Aug 28 2008 22:58:31.255104 3065543584]: [##ERROR##] DB ERROR(CODE)     : 2                                             29
[Thu Aug 28 2008 22:58:31.255130 3065543584]: [##ERROR##] DB ERROR(VAR_INFO) :
[Thu Aug 28 2008 22:58:31.255155 3065543584]: [##ERROR##] DB ERROR(SQLSTATE) : 4                                             2000
[Thu Aug 28 2008 22:58:31.255180 3065543584]: [##ERROR##] DB ERROR(STM_TEXT) : {                                             call cabal_sp_auth( ?               , ?               , ?          ,  ?                                                            )}
[Thu Aug 28 2008 22:58:31.321598 3065543584]: Database Connect success!
[Thu Aug 28 2008 22:58:31.321717 3065543584]: [##ERROR##] 'OnIPCAuthAccount' fai                                             l (Database/Auth.cpp:283)
[Thu Aug 28 2008 22:58:31.322586 3065543584]: [##ERROR##] UsrMap Fail : MainCmd(                                             30) Ret(11B:0:283) Addr(127.0.0.1)
[Thu Aug 28 2008 22:59:19.278500 3055053728]: Database Connect success!
[Thu Aug 28 2008 22:59:20.460417 3055053728]: [##ERROR##] OnIPCAuthAccount fail                                              (usernum: 0)
[Thu Aug 28 2008 22:59:20.468367 3055053728]: [##ERROR##] DB ERROR(MSG)      : [COLOR="Red"][FreeTDS][SQL Server]EXECUTE permission denied on object 'xp_md5', database 'master', owner 'dbo'[/COLOR].
[Thu Aug 28 2008 22:59:20.468432 3055053728]: [##ERROR##] DB ERROR(CODE)     : 2                                             29
[Thu Aug 28 2008 22:59:20.469048 3055053728]: [##ERROR##] DB ERROR(VAR_INFO) :
[Thu Aug 28 2008 22:59:20.469073 3055053728]: [##ERROR##] DB ERROR(SQLSTATE) : 4                                             2000
[Thu Aug 28 2008 22:59:20.469184 3055053728]: [##ERROR##] DB ERROR(STM_TEXT) : {                                             call cabal_sp_auth( ?               , ?               , ?          ,  ?                                                            )}
[Thu Aug 28 2008 22:59:20.977054 3055053728]: Database Connect success!
[Thu Aug 28 2008 22:59:20.977168 3055053728]: [##ERROR##] 'OnIPCAuthAccount' fai                                             l (Database/Auth.cpp:283)
[Thu Aug 28 2008 22:59:20.977207 3055053728]: [##ERROR##] UsrMap Fail : MainCmd(                                             30) Ret(11B:0:283) Addr(127.0.0.1)
[Thu Aug 28 2008 23:03:08.763901 3055053728]: [##ERROR##] OnIPCAuthAccount fail                                              (usernum: 0)
[Thu Aug 28 2008 23:03:08.764329 3055053728]: [##ERROR##] DB ERROR(MSG)      : [COLOR="Red"][FreeTDS][SQL Server]EXECUTE permission denied on object 'xp_md5', database 'master', owner 'dbo'.[/COLOR]
[Thu Aug 28 2008 23:03:08.764359 3055053728]: [##ERROR##] DB ERROR(CODE)     : 2                                             29
[Thu Aug 28 2008 23:03:08.764384 3055053728]: [##ERROR##] DB ERROR(VAR_INFO) :
[Thu Aug 28 2008 23:03:08.764409 3055053728]: [##ERROR##] DB ERROR(SQLSTATE) : 4                                             2000
[Thu Aug 28 2008 23:03:08.764433 3055053728]: [##ERROR##] DB ERROR(STM_TEXT) : {                                             call cabal_sp_auth( ?               , ?               , ?          ,  ?                                                            )}
[Thu Aug 28 2008 23:03:08.815403 3055053728]: Database Connect success!
[Thu Aug 28 2008 23:03:08.815905 3055053728]: [##ERROR##] 'OnIPCAuthAccount' fai                                             l (Database/Auth.cpp:283)
[Thu Aug 28 2008 23:03:08.815952 3055053728]: [##ERROR##] UsrMap Fail : MainCmd(                                             30) Ret(11B:0:283) Addr(127.0.0.1)

 

[sevenmore]

Listen:
The user that will access the sql gotta have a different name than cabal. I have it cabalserver. You need to give full access to this user, he needs to be a sysadmin and also db_owner of the 6 cabal db and the master db.

 

[winword]

i found the solution sir... thanks for your tips...
what i did is, i set my (db user account) as the owner of master database, then puf....i can now log in...thanks...