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 ...
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 ...
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
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 ...
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
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 = ...
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 ...
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 ...
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.
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 ...
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 ...
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,...
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 ...
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
...
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).
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 [...
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 ...
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 ...
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 ...
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 ...
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.
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.
...
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 ...
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:
#...
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 ...
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 ...
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 ...
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 ...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
sql-server-2012 × 270sql-server × 114
sql × 26
windows-server-2012 × 18
sql-server-2008-r2 × 16
windows-server-2012-r2 × 15
windows-server-2008-r2 × 14
sql-server-2008 × 12
failovercluster × 9
alwayson × 9
azure × 8
high-availability × 8
database × 7
cluster × 7
failover × 7
iis-8 × 7
ssrs × 7
windows-cluster × 7
windows × 6
backup × 6
installation × 6
database-administration × 6
database-backup × 6
permissions × 5
performance × 5