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 ...
- 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 ...
- 18.6k
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 ...
- 18.6k
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-...
- 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 ...
- 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 ...
- 1,431
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-...
- 18.6k
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 ...
- 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 ...
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
- 121
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 = ...
- 1,038
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 ...
- 151
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 ...
- 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'...
- 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
- 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 ...
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 ...
- 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 ...
- 18.6k
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.
- 36
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 ...
- 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 ...
- 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 ...
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,...
- 412
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 ...
- 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
...
- 36
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 ...
- 305
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 ...
- 18.6k
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 ...
- 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:
#...
- 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 ...
- 51.7k
Only top scored, non community-wiki answers of a minimum length are eligible