19 votes

What is SQL Server Core Edition?

Sorry to necro here, but just in case someone else hits this page with a similar question, and since there's so little documentation about this... Short: The regular "Enterprise" (non-"core") edition ...
Greg S's user avatar
  • 191
5 votes
Accepted

SQL 2012 Transaction Log backup does not truncate the logs

Your transaction log backup is truncating the logs in the sense that it's making room in the existing log file for more transactions. If you want to shrink the log file, you need to choose the "shrink ...
Katherine Villyard's user avatar
4 votes

How do I move an entire SQL instance for SQL Server 2012 to a different server?

SQL DBA here. I think you are misunderstanding how sp_help_revlogin works: http://support.microsoft.com/kb/918992 It is a set of scripts you run on the source server, the output will be a big long ...
BradC's user avatar
  • 2,210
2 votes

AWS RDS (SQL Server): SSL Connection - The target principal name is incorrect

Originally we were using the short name which seemed to work for awhile. However, for some reason later it stopped working throwing this error message. When we changed it to the FQDN it seemed to ...
Eric's user avatar
  • 21
2 votes

Getting "error: 26 - Error Locating Server/Instance Specified" all of a sudden

Ensure that the SQL Server Browser service is set to automatic and Running. If this isn't running, then outside sources can't view the client information. Once that is running, Open sQL Server ...
DarkLinkRising's user avatar
2 votes

Trying to add a new SQL Server user throws the error "is not a valid login or you do not have permission”

This worked for me : CREATE USER [chris23] FROM LOGIN [##MS_PolicyEventProcessingLogin##]; EXEC sp_addrolemember N'db_datareader', 'chris23'; GO
Badr Bellaj's user avatar
2 votes

Trying to add a new SQL Server user throws the error "is not a valid login or you do not have permission”

If you are trying to create a user under the Contained database user model (so no global login for it), you have to provide a password during creation like this: CREATE USER user_name WITH PASSWORD = ...
Tarnay Kálmán's user avatar
2 votes

Unable to start SQL server agent automatically

What edition of SQL Server are you running? SQL Server Express does NOT include the Agent. If that's the case, the solution is buying a valid license for a web, standard, developer or enterprise ...
Rob Moir's user avatar
  • 32k
2 votes
Accepted

What happens to running queries when stopping a Microsoft SQL Server instance?

It depends on whether you shut the server down with or without NOWAIT. From MSDN: Unless the WITH NOWAIT option is used, SHUTDOWN shuts down SQL Server by: Disabling logins (except for ...
Katherine Villyard's user avatar
2 votes
Accepted

Why are SQL Server 2012 tokens are not expanding when used in agent jobs?

Late reply I know, but tokens prefixed with A- will only expand if the job step is activated by an SQL Server alert or WMI event.
Tomas Lind's user avatar
2 votes

How can I isolate data-warehouse workloads from production/on-demand queries?

This is staggeringly simple to do in vSphere using either resource pools (can get messy), vApps or directly applied to individual VMs. What you do need to do is have a VM per class of work, you can't ...
Chopper3's user avatar
  • 102k
2 votes
Accepted

Unable to login to stand alone SSRS 2012 from domain joined computers

In order to resolve the issue I had to edit C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportServer\reportserver.xml Under: <AuthenticationTypes> Comment out ...
Matt Bear's user avatar
  • 874
2 votes
Accepted

SQL server authentication is grayed out when connecting to integration services

Analysis and Integration services only use Windows Authentication. SQL Server Reporting Services would require different configuration to handle different authentication. More detail can be found by ...
Antoine Hernandez's user avatar
2 votes
Accepted

Not sending mail job notifications

The missing step was that I should have activated alerts for the SQL Server Agent. To be able to do this I went in SQL Server Agent Properties, then Alert System tab, and activate Enable mail profile,...
marafado88's user avatar
2 votes

How do I move an entire SQL instance for SQL Server 2012 to a different server?

I think it's probably a ACL/rights thing but the security looks the same, all I did was overwrite the existing SQL install directory with the SQL directory from the source server. Why didn't you just ...
joeqwerty's user avatar
  • 111k
2 votes
Accepted

Issue installing a SQL Security Update on Windows Server 2012 R2

The system requirements for this update reads: Supported Operating System Windows Server 2008 R2, Windows Server 2008, Windows 8, Windows 8.1, Windows Server 2003, Windows 7, Windows Vista, Windows XP ...
Stephen Bank's user avatar
1 vote
Accepted

default service account for maintenance plan backups on SQL Server 2012

If you run a BACKUP query under a certain Windows/SQL Server account, it is actually the SQL Server Agent account which "does" the BACKUP and needs full control permissions to the UNC path (see here).
BastianW's user avatar
  • 2,888
1 vote

SSRS-error about report server database version after hotfixing SQL. The found version is '164'. The expected version is '163'

Based on the version that you got which is 163, try to apply this query on the instance hosting your reporter server database. In my below example, the database is named ReportServer : USE [...
Scorpion99's user avatar
1 vote

SQL Server 2012 constant CPU load

You would require at least either the view server state or view database state before you could think of analysing any performance issues inside SQL Server: What can user do with VIEW SERVER STATE ...
John K. N.'s user avatar
  • 2,055
1 vote

SQL 2012 Transaction Log backup does not truncate the logs

OK, First thing to understand is why the Log file is the size it is. You say the Data is 500MB are you sure? thats a very small Data file in comparison to the Log file. If that is true the LOG is the ...
JayBay2279's user avatar
1 vote

Issue installing SQL SERVER EXPR 2012/2016 on Server 2012 R2

I would consider posting this as a comment but due to a lack of rep, i can't. Try moving the SQL database files (.mdf and .log) to a new Windows VM, and upgrade the database files there. Then ...
Muh Fugen's user avatar
  • 309
1 vote

Cant connect to sql server database using ip

As can be seen in the SQL Server Configuration Manager utility, none of your actual IP addresses have been activated. IP Configuration You have to set the following option for the IP addresses you ...
John K. N.'s user avatar
  • 2,055
1 vote
Accepted

SQL 2012 Restore Issue - Exclusive Access cannot be obtained

There was a tick box in Take Tail-log backup before restore by default, which was causing the restore to fail. Removing the check made it work.
SysAdminUK's user avatar
1 vote

How do I configure the Windows Firewall to allow specific computers to connect to a SQL Server Instance?

You can do this using the Windows Server 2012 built-in firewall and issuing simple and applicable Netsh AdvFirewall Firewall Commands from a command prompt (or batch script) run as administrator. ...
Pimp Juice IT's user avatar
1 vote

Why is SSIS reading so much data from my hard drive?

CRM is probably integrating your SSIS for an ETL job. Possibly this is done through either Scribe, as most CRM environments I've come across are, or directly through SSIS, as SSIS has become more ...
Reaces's user avatar
  • 5,617
1 vote
Accepted

Ubuntu - SQL Server 2012 - Microsoft ODBC Driver 13 - Error: 18456, Severity: 14, State: 8

"Microsoft ODBC Driver 13 for SQL Server" does not work with isql. You must use sqlcmd. Connecting with sqlcmd and Use the sqlcmd Utility are far better than the sqlcmd man page. To use a DSN: #...
David's user avatar
  • 13
1 vote
Accepted

Should I continue to use MSDTC in my new virtual environment for MSSQL?

No, you do not. Obviously nothing will ever use the DTC in the setup you made, as all there is running in the cluster are virtual machines. THAT SAID: You also gave up "a lot" of high availability by ...
TomTom's user avatar
  • 51.9k
1 vote

SQL 2012 Standard - AlwaysOn FCI - Single point of contact?

When you setup AlwaysOn, it is backed by Windows Clustering. As part of the setup you'll create a Cluster IP Address and host name and that is how you will connect to the active instance. The IP will ...
Zypher's user avatar
  • 37.5k
1 vote

MS SQL replication run only with system account

The Snapshot Agent Windows account must at minimum be a member of the db_owner fixed database role in the publication and distribution database and have read, write, and modify permissions on the ...
Brandon Williams's user avatar
1 vote

SQL 2012 Integration Services installation

These are options of the main SQL Server installer. (Image from this MSDN blog article.) Analysis Services is the fourth item from the top under Instance Features. Integration Services is the third ...
Katherine Villyard's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible