Really thanks for your help. I'll try it out!
Gulden SAYLAN <[EMAIL PROTECTED]> wrote:
Hi,
I think, you have a problem about database owner user 'bmssa' on your
database
(But, You can try after database backup)
You should run script for on your database (query analyzer)
exec sp_change_users_login AUTO_FIX,'bmssa'
I hope that solve your problem.
-----Original Message-----
From: mchiat [mailto:[EMAIL PROTECTED]
Sent: Friday, May 21, 2004 5:22 AM
To: [EMAIL PROTECTED]
Subject: [development-axapta] SQL error when log into Axapta - Invalid
Object Name 'SQLSYSTEMVARIABLES'
Hi all,
Could anyone of you help me to resolve the problem? When i want to
log into axapta the following SQL error occurs
SQL has reported the following error:
[Microsoft][ODBC SQL Server Driver][SQL Server] Invalid Object
name `SQLSYSTEMVARIABLES'
You may refer to the error log file for further details.
Retry the operation?
If i click 'Yes' the same message box will keep on emerging. However
if i click 'No' the following message will appear:
Cannot select a record in ().
The SQL database has issued an error.
If i proceed the following message will appear:
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object
name `SQLSYSTEMVARIABLES'. [SELECT VALUE FROM SQLSYSTEMVARIABLES
WHERE PARM = `SYSVARID']
If i continue the system will ask me to enter System Variables:
One or more SQL system variables are unknown.
System variable STR
Permitted values Text
New value
After i enter the New Value as VARCHAR(%u)the system will
automatically exit and if i want to log into Axapta again the same
SQL error will appear.
May i know what is happening? Is there anyway to resolve the
problem?
Hope you all can reply to me as soon as possible. Thank you in
advance.
Yahoo! Groups Links
Yahoo! Groups SponsorADVERTISEMENT
---------------------------------
Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
Do you Yahoo!?
Yahoo! Domains - Claim yours for only $14.70/year
[Non-text portions of this message have been removed]
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
