| SQL DB ownership - how to change? | |
Posted: Tue Jan 20, 2015 1:22 am |
Points: 0 |
|
mesteel |
GoldMine Apprentice |
|
|
Joined: 27 Oct 2007 |
Posts: 19 |
|
|
|
|
|
|
|
|
hi,
need advise from experts.
i installed GMPE 2014.2 on a new Win 2012 R2 server and SQL server 2014, which will replace our old server with GMPE 9.0 & SQL 2005.
there are no issues with the installation.
created a similar maintenance plan as on the old server.
however, the backup isn't working and the error log shows the database owner as,
"WINDOWS-MPPH3JC\Administrator."
WINDOWS-MPPH3JC being the server name when it was purchased.
after windows installation and server configuration, SQL software was also installed.
Before, installing goldmine, I renamed it to the same name as old server to avoid any conflict.
in the old server, the database owner shows as "sa"
now, how can i change the ownership to "sa"?
if I change the ownership, will there be any repercussions on the way goldmine works for users on their PC's?
can experts here suggest how to rectify this issue.... |
|
|
|
|
| | |
Posted: Tue Jan 20, 2015 7:00 am |
Points: 0 |
|
DJ |
GoldMine Guru |
|
|
Joined: 29 Jun 2006 |
Posts: 2055 |
Location: Fitchburg, MA, USA |
|
|
|
|
|
|
|
You should easily be able to change the Ownership of the sa administrator via the SQL Management Tools. |
|
_________________ DJ Hunt
Phone: (978)342-3333
Email: DJ@DJHunt.US
GoldMine Premium - The Defintive Guide
One-on-One GoldMine Technical Support ( Fee Based )
www.DJHunt.US |
|
|
|
Posted: Wed Jan 21, 2015 2:32 am |
Points: 0 |
|
mesteel |
GoldMine Apprentice |
|
|
Joined: 27 Oct 2007 |
Posts: 19 |
|
|
|
|
|
|
|
|
DJ wrote: |
You should easily be able to change the Ownership of the sa administrator via the SQL Management Tools. |
Thank you DJ,
managed to change it..
its working fine now.. |
|
|
|
|
ContactReview Forum Index » GoldMine 8 - 2019 (Premium Edition)
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
All times are GMT - 7 Hours
Page 1 of 1
|
|
|
Brought to you by Castell Computers, Doug Castell, Admin
Powered by phpBB © 2001-2004 phpBB Group Theme created by Vjacheslav Trushkin
|