Skip to main content

Questions tagged [license]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
45 views

What happens when you try to use more than 32 GB of memory-optimized data in a database on Standard Edition?

In SQL Server 2019, you cannot put more than 32 GB of memory-optimized data in a database on Standard Edition. What happens if you try anyway? I'd try it myself, but I don't want to risk discovering ...
J. Mini's user avatar
  • 467
0 votes
1 answer
139 views

SQL Server Replication Licensing

Production database is hosted on a SQL Server Standard instance and is replicated using merge replication with web synchronization to 10 subscriber databases hosted on 10 separate SQL Express server ...
db-hopper's user avatar
0 votes
0 answers
46 views

Azure Hybrid Benefit-Self-Installed SQL Server on Azure VM

The Microsoft documentation says if you self-install SQL Server on Azure VM, you need to manually register with the SQL IaaS Agent Extension and activate Azure Hybrid Benefit. https://learn.microsoft....
steve's user avatar
  • 47
2 votes
1 answer
189 views

Can I apply a different license without reinstalling the server?

I have downloaded a trial version of SQL Server 2017. After installation I got this: Microsoft SQL Server Enterprise Evaluation (64-bit) I want to buy a license for Standard edition after some time. ...
Farhan's user avatar
  • 121
1 vote
2 answers
1k views

What does `Limited to lesser of 4 sockets or 24 cores` for standard edition mean?

What does Limited to lesser of 4 sockets or 24 cores for standard edition mean? Since a socket has cores, I think of it like apples - for example: lesser of 4 apples or 24 slices. Is it assuming that ...
variable's user avatar
  • 3,644
0 votes
1 answer
811 views

db2 applying licensing file produces two licenses

I installed Db2 from fixpack v11.5.7.0 using db2_install command. I have downloaded "IBM Db2 Advanced Edition - VPC Option V11.5.6 - Activation (CC9WHML)" file from IBM Passport Advantage. I ...
folow's user avatar
  • 347
3 votes
2 answers
9k views

How get old versions from MS SQL Developer Edition?

I'm trying to get SQL Server 2016 Developer Edition but when I access to Microsoft Dev Essentials page I only can see Express Edition versions: And when I visit SQL Server Download page I only can ...
Cesar Miguel's user avatar
-1 votes
1 answer
74 views

What are my limits and pre req's for my Sql Server 2014 VM?

I have the following Virtual SQL Server (running in Windows Server 2016 Hypver-V environment): The VM is on one specific host shared with other vm's and can be moved around on other hosts. SQL Version:...
Kahn Kah's user avatar
  • 115
0 votes
1 answer
758 views

SQL Server License Migration [closed]

We need to move our SQL Server 2016 standard License. Our plan is to install SQL Server on the new box with the same license key , test the application / databases and then delete the old SQL server ...
SQL_NoExpert's user avatar
  • 1,061
0 votes
1 answer
2k views

SQL Server 2019 (RTM) - 15.0.2000.5 period has expired after upgrade to CU 8 [closed]

Hi i have MS SQL with version Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64) Sep 24 2019 13:48:23 Copyright (C) 2019 Microsoft Corporation Enterprise Evaluation Edition (64-bit) on Windows ...
sql query's user avatar
0 votes
1 answer
1k views

What happens to a SQL Server 2019 Standard instance with an Annual Subscription Licence when it expires?

We have 3 production SQL Server 2019 standard instances which we have licenced through a third party supplier on an annual subscription basis. In our use case this works out cheaper if you only ...
Ollie's user avatar
  • 738
0 votes
1 answer
745 views

The problem having different vms with the same sql server Licence key

I was hired in a new company 1 year ago. After doing all important stuff, i'm now hunting for problems and etc. Using a powershell that can give me the licence key using to install the SQL Server, I ...
Racer SQL's user avatar
  • 7,386
0 votes
2 answers
86 views

SQL Server Reporting Server Migration

I have a separate database server and a separate reporting server. I would like to upgrade and migrate the database server to a separate server and do not to touch the reporting server. Since the ...
SQL_NoExpert's user avatar
  • 1,061
0 votes
2 answers
3k views

SQL Server Standard Edition - Limitation

The below SQLServer License Edition comparison URL does NOT mention any limitation about the number of databases supported within an AlwaysOn Failover Cluster Instance - for standard edition. Is it ...
Balaji Ram's user avatar
0 votes
2 answers
2k views

Which SQL Server license is appropriate for my use case? Can I use a free license?

Mod note: This question is a poor fit or dba.se, but I am leaving this question because the number of people who are new to the field on an annual basis is still high, and licensing is always the ...
0 votes
1 answer
416 views

SSRS Standalone install license [closed]

For performance reasons we are thinking about moving our SSRS installation to a separate server. Since you can have a standalone installation of SSRS. Question being, if we install SSRS (standalone) ...
Preben Huybrechts's user avatar
8 votes
2 answers
1k views

Is it possible to accidentally use some paid feature in Oracle XE database while in an Enterprise environment?

IT in my org are wary about approving me installing Oracle Express Edition. https://www.oracle.com/database/technologies/xe-downloads.html Their reasoning is that apparently some DBA once said that ...
Jack Garbiec's user avatar
1 vote
0 answers
940 views

Does SQL Server 2017 Express support Linked Server connections to Oracle DB

Is there any restrictions with "Linked Servers" with SQL Server 2017 Express? Vs using SQL Server 2017 Standard. Only in regards to "Linked Servers".
sherveyj's user avatar
  • 111
2 votes
2 answers
5k views

Regarding Always On Licensing (Secondary replica no license required) [closed]

I have few questions regarding the licensing of SQL Server when it comes to Always On: Under which scenario / settings we can say that secondary replica is truly passive and will not be considered ...
sachin-SQLServernewbiee's user avatar
4 votes
2 answers
2k views

Power BI DESKTOP licensing - is it really free to share pbix files?

The Power BI Desktop app for Windows is free, which is great. However, the Microsoft site is loaded with talk of licensing to share/view Power BI content. Is that only for their hosted Power BI ...
SomeGuy's user avatar
  • 2,013
1 vote
2 answers
4k views

Is SQL Server Data Tools a paid product of Microsoft or a Free Product?

I don't find an evidence in Microsoft Pages regarding SQL Server Data Tools Licensing and Price details. https://learn.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-...
Sathiya Kumar V M's user avatar
0 votes
1 answer
92 views

SQL Server license from AWS Marketplace with ? cores

We are planning to buy a SQL Server 2012 Enterprise edition license from AWS Marketplace for our company. We have exhausted our previous licenses and we need to add a new region with SQL Server in ...
Pravs_thedataguy's user avatar
0 votes
1 answer
916 views

How to setup a SQL Cluster between 2 sites in active passive mode without shared storage

we need to install SQL at 2 sites, 1 primary and 1 DR. We don't to pay for license for the DR and need to know how will we setup a SQL cluster/replication/alwayson/bag or any other method that will ...
Nasser Fuzion's user avatar
1 vote
0 answers
105 views

How do SQL Server users deploy for different licenses of the same release of SQL Server?

Let's assume I want to deploy something like this to SQL Server, ALTER TABLE foo ALTER COLUMN a varchar(11) NOT NULL WITH (ONLINE = ON); This will work fine if your version of SQL Server is "...
Evan Carroll's user avatar
  • 63.6k
16 votes
2 answers
4k views

How to "self audit" all of the SQL Server licenses at an organization?

So I have started a new job with a nice non-profit organization, which has been around for a few decades. They have a wide variety of SQL Server editions and versions (ex: 2005 Express to 2016 SP2 ...
Jacob H's user avatar
  • 710
0 votes
1 answer
3k views

Oracle SecureFiles LOBs Licencing

We argued in our DBA team on whether an Oracle Database with SecureFiles LOBs needs to be an Enterprise Edition. Can I use Oracle Secure File Lobs in a Standard Edition?
r0tt's user avatar
  • 1,028
2 votes
1 answer
9k views

Transfer SQL Server 2017 Standard license to a new server [closed]

We recently purchased a license for SQL Server 2017 Standard (16 cores) in behalf of a client from an online reseller (not directly from Microsoft), and installed it without problem: we downloaded and ...
Alberto Martinez's user avatar
-1 votes
2 answers
419 views

information about licensing and patching SSAS [closed]

I have one server for data warehousing, and it has 2 instances of SSAS (SQL SERVER Analysis Services). The data warehouses are not that big, less that 200GB, and I backup the whole thing on a daily ...
Marcello Miorelli's user avatar
2 votes
2 answers
236 views

Availability Group Listener - Dedicated Server?

Should an AG Listener be set up on it's own server? If so, does it require it's own SQL Server license?
SQL_Deadwood's user avatar
1 vote
1 answer
173 views

Getting postgreSQL binaries without third party tools [closed]

Where can I download postgreSQL binaries without third party tools like pgAdmin, stackbuilder? From licencing point of view, can I download binaries from https://www.enterprisedb.com/download-...
Vijay Giri's user avatar
3 votes
2 answers
1k views

Installing Enterprise Edition in a virtual machine [closed]

Out of curiosity, just wondering if this is possible: I will download a 180-day trial of Enterprise edition of an Microsoft product (ex: SQL Server 2017). Install it in a virtual machine. Once the ...
Edgar Allan Bayron's user avatar
3 votes
1 answer
142 views

Microsoft SQL Server CAL - What is it?

I have trawled through masses of documentation both on Microsoft website and Stack Exchange, yet I have failed to find answers to some basic questions: What is a CAL? A license code that I need to ...
Tony Sepia's user avatar
2 votes
2 answers
4k views

SQL Server 2014 change license key

I need to change the Microsoft SQL Server 2014 license key (just key - not versions). I have found that it is possible via SQL Server Installation Wizard: http://www.alexandreviot.net/2015/11/10/...
Simon Kowalski's user avatar
0 votes
1 answer
3k views

SSIS Standalone Installation [closed]

In my organization we have several SQL Server 2016 Enterprise licenses in use. None of them are running SSIS. Since they are not in use, could I install just SSIS 2016 on a separate server and still ...
Steve Salowitz's user avatar
4 votes
1 answer
17k views

Does SQL Server 2016 Standard Edition include replication?

I was trying to create a distribution database on an instance of SQL Server 2016 SP1 Standard Edition. I got an error that the replication component of SQL Server was not installed. We have recently ...
Zach Smith's user avatar
  • 2,380
3 votes
1 answer
344 views

SQL Server 2014 EE not using all available processors

First of all let me apologize for not being clear on my requirements in my original question. I am now updating my question with my current scenario: I have few existing SQL 2014 Enterprise Edition ...
SQLPRODDBA's user avatar
  • 1,908
8 votes
2 answers
6k views

Is there a developer edition of Microsoft SQL Server 2017 for Linux? [closed]

I have SQL Server 2016 Developer Edition installed on Ubuntu, whis is free for development purposes: SQL Server 2016 SP1 Developer is a fully featured free edition licensed for use as a development ...
Evan Carroll's user avatar
  • 63.6k
1 vote
1 answer
2k views

How to install downgrade of SQL Standard 2016 to Standard 2014

This is probably a super basic question, but if I purchase an OEM SQL Server 2016 Standard edition, how would I install it as 2014 to match the other servers? Can I get a 2014 installer and use the ...
thomasjbarrett's user avatar
0 votes
1 answer
7k views

SQL Server + Reporting Services + SSIS + SSAS Licensing and Infrastructure

Actually I am running 3 environments (Dev / UAT / PROD ) with SQL Server installations on them. Development server has also Integration Services Service running on it an we are starting to actively ...
J1mmy's user avatar
  • 520
4 votes
1 answer
132 views

Which domain to use for sql server developer

My current company does not have a QA domain in a hosting data enter where all the data bases are located . I want to know that in order to use developer editions of sql server, should I be using it ...
buddinggeek's user avatar
1 vote
1 answer
1k views

How to change DB2 Demo license to a free license (Express Edition)

For a PoC (Proof of concept) I downloaded DB2 which comes with a 90 day trial license. Since we would like continuing to use the DB2 for further demonstrations I would like to import a license file ...
Thorsten Niehues's user avatar
1 vote
1 answer
2k views

Multiple instance on single SQL Server

We have a server running single instance of SQL SERVER in production environment. We are planning to create another Instance of SQL SERVER in same server. My question do we have to buy a new ...
Pரதீப்'s user avatar
0 votes
1 answer
468 views

In which extent can I use the Oracle Data Provider for .NET Managed Driver?

Good evening everybody, I am planing to dive into the oracle database world. Additionally, I want to develop some tools, which make my life easy by checking and modifying information in different ...
SethM's user avatar
  • 1
0 votes
1 answer
260 views

Redo log member and control files at Oracle DB Standard Edition

I am planing to dive into the oracle database world. Since the oracle database is such a complex machine, I want to inform myself as good as possible, before I start. I have some questions. How many ...
SethM's user avatar
  • 1
0 votes
1 answer
36 views

use different odbc conector to connect mysql server

We found out Mysql odbc connector is released under gplv2 license. We have a commercial application (in c#) that connects to mysql (using Mysql.data) so we are supposed not to use mysql odbc connector ...
Alejandro Bastidas's user avatar
1 vote
2 answers
4k views

Are older versions of MS SQL Server DEVELOPER edition now free? [closed]

Microsoft SQL Server Developer Edition is now free https://blogs.technet.microsoft.com/dataplatforminsider/2016/03/31/microsoft-sql-server-developer-edition-is-now-free/ I see that I can download ...
SMS's user avatar
  • 11
0 votes
1 answer
135 views

sql server 2012 developers edition license and 3rd party applications [closed]

Our company is using an ERP system for our product inventory management and customers orders. The newest version uses MS SQL 2012. if we are not developing software and the only users accessing the MS ...
Grant's user avatar
  • 1
1 vote
0 answers
86 views

SQL server 2014 Developer Edition [duplicate]

I need a Clarification about Sql server 2014 developer edition licensing.I came to know that,for a Cheap price(50$ or something) developer edition is available.also it is given that multiple users can ...
akhil kumar's user avatar
2 votes
1 answer
124 views

Using Standard Edition for a VLDB

In order to save licensing costs I'm evaluating whether I can get away with Standard Edition for a VLDB. I'll outline the scenario: Here, "VLDB" means 5TB. The size is expected to be stable over time....
boot4life's user avatar
  • 1,279
2 votes
1 answer
4k views

Mixed editions in Availability Group?

Looking to consolidate several different older SQL serves into one AG with an ent lic when Sql Server 2016 is released. Plan is to have a primary, a sync passive secondary, and an async third instance ...
Darin's user avatar
  • 21