Reseller Hosting, Shared Hosting, Dedicated Hosting by Vortech Inc.

Go Back   Reseller Hosting, Shared Hosting, Dedicated Hosting by Vortech Inc. > >> General Public > H-Sphere Pre-Sales
User Name
Password
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

H-Sphere Pre-Sales Post your questions about H-Sphere plans here.

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 10-20-2004, 07:04 PM
hari hari is offline
Registered User
Junior Member
 
Location: Austin, Texas
Has anyone experienced MS SQL Replication problems due to inadequate user rights?

I setup a database and gave access to a vendor to setup replication. When he tries to push data, he gets an error message saying -

Only members of the sysadmin or db_owner roles can perform this operation
Source: THUMMAS.COM (Data source); Error number: 21050

I have already opened a ticket but figured this could help others who are in a similar situation (I didn't find any postings on this site that seemed relevant to this problem).

BTW, I am a Technical Project Manager so I know a little bit about databases but I am not a DBA. Thanks in advance for any help.
Reply With Quote
  #2  
Old 10-20-2004, 08:48 PM
Brangwyn Brangwyn is offline
T3CHN0 STUD
Vortech Inc. Customer
 
Location: New Zealand (Wellington)
Vortech doesn't support replication. If your just copying data to the server to populate the database then use a DTS Job instead.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -5. The time now is 08:22 AM.


Powered by vBulletin Version 3.5.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Vortech Inc. ©2005
Page generated in 0.36497 seconds with 15 queries
[Output: 35.54 Kb. compressed to 33.50 Kb. by saving 2.04 Kb. (5.73%)]