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

Changes to data ordering between SQL Server 2000 and 2012

SQL Server 2012 does not guarantee the order of rows returned in SQL 2012. Neither did 2000, for that matter. (The citation I found for that is actually 2005, but close enough.) Essentially, the ...
Katherine Villyard's user avatar
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
Accepted

Azure network latency between VM and Cloud Service

Since you're using a web role, I would assume that it is connected to your VNet by means of using a VPN gateway and a Point-to-Site tunnel, as stated here: https://azure.microsoft.com/en-us/blog/azure-...
Noor Khaldi's user avatar
  • 3,869
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,220
3 votes
Accepted

Unattended installation of MS SQL Server (2008|2012) EXPRESS?

Wrong Installer? I think this is going to come down to the wrong installer. I downloaded the SQL Server 2012 Express Advanced Edition installer from the link you mention and was able to follow your ...
Joshua McKinnon's user avatar
3 votes
Accepted

Manage SQL Agent Jobs On Multiple Servers

Yes. Go to View -> Registered Servers. Go into Database Engine -> Local Server Groups and create a new server group. Add all the servers you want to that group. Highlight the group, then right-...
Katherine Villyard's user avatar
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

Why are SQL Backups slower on Server OS?

Ok, we were able to find a way to improve backup performance. By specifying MAXTRANSFERSIZE = 1048576 we cut it in half. The strange part is, that number is supposed to be the default, as far as we ...
Mark Dynna's user avatar
2 votes

Changes to data ordering between SQL Server 2000 and 2012

Order for sets is undefined and undocumented. "Undocumented" in this case means two things: We won't be able to provide you with a specific link or quote detailing changes or what the new behavior ...
Joel Coel's user avatar
  • 12.9k
2 votes
Accepted

Restoring a differential database file "the backup set holds a backup of a database other than the existing"

The OP and I figured it out in an interactive chat session. It turns out that the backup file in question had multiple backup sets. The one that he needed to restore was not in position 1, and so didn'...
Ben Thul's user avatar
  • 3,024
2 votes
Accepted

SQL Server express - Management studio installation hangs at native images installation

Disabling AVG virus protection before starting the install setup allowed me to proceed with the install past this point
Yaakov Ellis's user avatar
  • 556
2 votes
Accepted

Can I access the failover server on AWS RDS?

In short, no you cannot. From the Amazon RDS FAQs Q: When running my DB Instance as a Multi-AZ deployment, can I use the standby for read or write operations? No, the standby replica ...
Eric Westfall'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
  • 31.9k
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
  • 101k
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
  • 110k
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

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
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,597
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.7k

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