Solved

Could not get license information correctly

Posted on 2004-04-27
7
337 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
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Is there a better way to combine two queries 7 28
CDC and AOG on MS SQL 2012 13 25
Error when creating an UPDATE Trigger in SQL 6 23
Dynamic SQL select query 4 38
Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
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.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

821 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