Definitely.. IF the ARAdmin user is not the owner of the table, it could be a
lot more severe than just the errors you are seeing.. There is a lot more the
ARAdmin user might not be able to do such as backup or restore the database or
even redefine the form (Alter Table)
I'd suggest you should use the SQL enterprise manager or query analyzer and
list all the ARSystem table and make sure that the ARAdmin user has the dbo
role on the database, AND (not OR) all the tables, views, and other objects in
the ARSystem database.
If this is not the case there are sql tools to repair that.
sp_changedbowner will help you change the dabtabse owner
sp_changeojectowner will help you change the owner of the objects (Tables,
views etc)
You can write an SQL to create a .sql file that could create a script to change
all the object ownership and role to ARAdmin and dbo. A single line would look
like
EXEC sp_changeobjectowner 'T1', 'ARAdmin';
This would change the ownership of T1 to ARAdmin as a dbo.
You might probably see the object as ARAdmin.T1 even when logged in as ARAdmin,
if ARAdmin is not the dbo in which case the above statement would be
EXEC sp_changeobjectowner 'ARAdmin.T1', 'ARAdmin';
Joe
----- Original Message ----
From: Brandi Barbour <[EMAIL PROTECTED]>
To: arslist@ARSLIST.ORG
Sent: Thursday, October 16, 2008 2:49:02 PM
Subject: Re: Replication
**
Joe,
We are trying to use SQL Transactional
Replication.
If ARAdmin is not the owner of the table
could that cause these issues? We were not having issues before the
replication was put in place.
Joe DeSouza <[EMAIL PROTECTED]>
Sent by: "Action Request System
discussion list(ARSList)" <arslist@ARSLIST.ORG>
10/16/2008 03:30 PM
Please respond to
arslist@ARSLIST.ORG
To arslist@ARSLIST.ORG
cc
Subject Re: Replication
**
Brandi,
I have replicated databases on MS-SQL, Oracle and other databases successfully
and not have Remedy throw up on the users..
What method of replication did the dba use?
Does the ARAdmin user that owns the ARSystem database have the same rights
and privileges as the ARAdmin user on the original database? Typically
on MS-SQL the ARAdmin user should be the dbo of the ARSystem database.
Joe
----- Original Message ----
From: Brandi Barbour <[EMAIL PROTECTED]>
To: arslist@ARSLIST.ORG
Sent: Thursday, October 16, 2008 1:11:25 PM
Subject: Replication
**
All,
We have windows 2003 with sql 2005, ARS 7.1.0, ITSM 7.0.3. Our database
engineer set up SQL replication for our production sql server to our backup
sql server. The problem is that when he does the SQL replication
set up the remedy system does not agree with it. We get errors when
someone modifies a request and it pushes a value to a char field with an
attached menu with the pattern = $MENU$. It says that the value we are
sending does not meet $MENU$. We also get errors if we go to the
admin tool and try to move a field.. Errors concerning the sql view does
not exist. It seems that somehow the views are being changed. I know
someone on the list had said that the replication adds columns to the views
so the system is not recognizing the views correctly. I have seen some
questions on arslist but did not know if anyone had a solution as of yet.
Has anyone successfully set up SQL replication successfully?
Thanks,
Brandi
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where
the Answers Are" html___
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
