[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.axapta.programming

Invalid object name "SQLSYSTEMVARIABLES"

Adam Tarkowski

12/29/2005 1:06:00 AM

And another problem, what can i do with this problem:
[microsoft][odbc sql server driver][sql server]invalid object name
"sqlsystemvariable"

It is not the first time when this problem ocures but still i dont know how
to fix this

Can someone help
2 Answers

lindo

12/29/2005 7:26:00 AM

0

Hi,

This error message informs you can login to the SQL server but there is not
enough rights to use the Axapta database. This is the common problem after
you have attached or restored database from another SQL server instance. Even
if the visible user name is identical to the original one it is not valid.

Please use sp_addalias (see SQL help) or change ownership of tables

br,
--



"Adam Tarkowski" wrote:

> And another problem, what can i do with this problem:
> [microsoft][odbc sql server driver][sql server]invalid object name
> "sqlsystemvariable"
>
> It is not the first time when this problem ocures but still i dont know how
> to fix this
>
> Can someone help
>
>
>

rheu

12/29/2005 8:39:00 AM

0

Hi Adam,

It's also possible that the user to connect to SQL Server which is used in
your configuration has the role 'System Administrator' in SQL Server. By
removing this role in the Enterprise Manager, Security, Logins, Properties
the problem could also be resolved.
--
Regards,
Rob