Questions tagged [license]
The license tag has no usage guidance.
85 questions
0
votes
1
answer
90
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 ...
- 855
0
votes
1
answer
267
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 ...
- 13
0
votes
0
answers
57
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....
- 47
2
votes
1
answer
363
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. ...
- 121
1
vote
2
answers
2k
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 ...
- 3,489
0
votes
1
answer
930
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 ...
- 401
3
votes
2
answers
10k
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 ...
- 131
-1
votes
1
answer
75
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:...
- 115
0
votes
1
answer
855
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 ...
- 1,063
0
votes
1
answer
3k
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 ...
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 ...
- 758
0
votes
1
answer
858
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 ...
- 7,484
0
votes
2
answers
92
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 ...
- 1,063
0
votes
2
answers
4k
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 ...
0
votes
2
answers
3k
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
445
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) ...
8
votes
2
answers
2k
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 ...
- 83
1
vote
0
answers
979
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".
- 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 ...
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 ...
- 2,053
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-...
0
votes
1
answer
98
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 ...
- 565
0
votes
1
answer
1k
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 ...
1
vote
0
answers
113
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 "...
- 64.7k
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 ...
- 709
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?
- 1,038
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 ...
- 322
-1
votes
2
answers
439
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 ...
- 16.6k
2
votes
2
answers
270
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?
- 841
1
vote
1
answer
178
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-...
- 11
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 ...
- 1,350
3
votes
1
answer
144
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 ...
- 145
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/...
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 ...
- 175
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 ...
- 2,410
3
votes
1
answer
365
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 ...
- 1,928
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 ...
- 64.7k
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 ...
- 133
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 ...
- 530
4
votes
1
answer
136
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 ...
- 625
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 ...
- 113
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 ...
- 1,399
0
votes
1
answer
480
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 ...
- 1
0
votes
1
answer
273
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 ...
- 1
0
votes
1
answer
38
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 ...
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 ...
- 11
0
votes
1
answer
136
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 ...
- 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 ...
- 111
2
votes
1
answer
126
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....
- 1,289
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 ...
- 21