Solved

Could not get license information correctly

Posted on 2004-04-27
7
324 Views
Last Modified: 2012-06-27
I am trying to run transactional replication between two SQL 7 Servers.  Both of the servers are within the same domain and are registered within Enterprise Manager.  I can browse the databases of each server using EM.  One server is setup as Distributor and Publisher.  The other is the Subscriber.  When replication runs the publisher snapshot is created fine but when the push to the subscriber is attempted I get:

"Could not get license information correctly."

Both servers are set to use the Administrator account to run the SQL Agent.  What am I doing wrong here?

Thanks,

Matt
0
Comment
Question by:porcrim
  • 3
  • 2
7 Comments
 
LVL 3

Expert Comment

by:Frostbyte_Zero
ID: 10932780
Check the Licensing Options on both the servers. This would be under Control Panel/Administrative Options.

I had a similar problem when using DTS. The DTS package requires more than one license. The license was created when the SQL Server was installed.

0
 

Author Comment

by:porcrim
ID: 10933308
I looked at both.  One is set for 40 concurrent users, the other for 20.
0
 
LVL 3

Expert Comment

by:Frostbyte_Zero
ID: 10933621
What version of SQL on each? Enterprise? Developer? Personal? Standard?
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

Author Comment

by:porcrim
ID: 10933659
Both are SQL7 Enterprise
0
 

Author Comment

by:porcrim
ID: 10943272
I figured out that niether server had a service pack installed.  After installing SP4 on both I was able to get replication working.

Matt
0
 
LVL 1

Accepted Solution

by:
GhostMod earned 0 total points
ID: 11588820
PAQd with 125 points refunded

GhostMod
CS Moderator
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Suggested Solutions

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now