STDItems Permissions error

[batman]

M2Server

Loaded client version information and server table...
Loading StdItem.DB...
[05/08/2007 18:10:39] StartTimer exception: [Microsoft][ODBC SQL Server Driver][SQL Server]SELECT permission denied on object 'TBL_STDITEMS', database 'TestGod', owner 'dbo'
[05/08/2007 18:11:35] -- SQL KeepAlive
[05/08/2007 18:11:35] -- --> Error Keeping Query Alive!
[05/08/2007 18:11:35] -- --> Error Keeping QueryCommand Alive!

anyone kno how 2 sort this? ( using thedeaths files )

 

[¤]´)÷¤--§îr Äürøñ--¤÷(`[¤]

Re: M2Server

Looks like your SQL login is wrong, the table doesn't exist, or, as it says, your permissions for that table are messed up.

Check the login, make sure the table exists, and check your permissions.

All this should be done through Enterprise Manager.

--

Post moved, renamed to be more descriptive.

 

[batman]

Re: M2Server

Looks like your SQL login is wrong, the table doesn't exist, or, as it says, your permissions for that table are messed up.

Check the login, make sure the table exists, and check your permissions.

All this should be done through Enterprise Manager.

--

Post moved, renamed to be more descriptive.

im usin enterprise manager ive got the table but i cnt edit the dbo account but im not even trying to log on that 1 tho im using this in !Setup

[SQL]
UseSQL=True
SQLHost=127.0.0.1
SQLUsername=test
SQLPassword=test
SQLDatabase=TestGoD
SQLType=mysql
SQLPort=3306

ive uninstalled and re-installed it tried everything

 

[nettim2k]

switch the use SQL=False i changed it and it all worked for me ))

 

[batman]

switch the use SQL=False i changed it and it all worked for me ))

thx but i wanted 2 edit the items etc etc ive got a non-sql version of server files working lol

 

[StevieLCFC]

add [email protected] ill tell ya how i fixed that

 

[StevieLCFC]

Re: M2Server

Looks like your SQL login is wrong, the table doesn't exist, or, as it says, your permissions for that table are messed up.

Check the login, make sure the table exists, and check your permissions.

All this should be done through Enterprise Manager.

--

Post moved, renamed to be more descriptive.

Your Wrong Mate got nothing to do with M2server its just a simple setting in SQL

 

[batman]

problem sorted thx 4 help..

 

[koni]

add [email protected] ill tell ya how i fixed that

wouldnt it of been better to post the solution to the problem here ? so that if anyone else gets the problem they also know how to fix it.

also in future edit your original post and dont double post.

cheers