Questions tagged [sql-server-2012]
Microsoft SQL Server 2012 (often abbreviated as SQL Server 2012 or MSSQL 2012) is a version of Microsoft's SQL database server software. It includes new features and upgraded functionality from its predecessor, SQL Server 2008 R2, went RTM on March 6th, 2012 and to general release on April 1st, 2012.
270
questions
27
votes
5
answers
50k
views
What is SQL Server Core Edition?
I was browsing my technet downloads for SQL Server 2012 and I noticed a bunch of products labelled "core" edition:
Is this something to do with their new per-core licensing model, or something else?
21
votes
3
answers
74k
views
Trying to add a new SQL Server user throws the error "is not a valid login or you do not have permission”
I am trying to add a new user to an SQL Server 2012 database using SQL Server Management Studio. I right-click and select 'Add User' under Security -> Users, fill out the user information, and click ...
15
votes
3
answers
9k
views
How to change default recovery for new databases?
How can i configure the database server on our development server so that when new databases are created that they are Simple recovery model by default?
Currently if we remember, when creating a ...
11
votes
1
answer
33k
views
SQL Server express service is not starting [closed]
I've bought my first VPS yesterday, and I have installed Microsoft SQL Server 2012 Express on it.
Then I have restarted my VPS. But SQL Server Service didn't start. I've tried to start it manually, ...
10
votes
1
answer
43k
views
Does an SQL Server instance allow both secure and non-secure connections at the same time?
we have an application running MS SQL Server 2012. For one specific use case we'd like to SSL protect the jdbc connection. I've checked the following links:
How to enable SSL encryption for an ...
8
votes
1
answer
3k
views
Very uneven CPU utilization with SQL Server 2012 on 2 processor computer with 16 cores / processor
After installing SQL Server Enterprise 2012 with the Server + Cal license model, on a computer with 2 processors each with 16 cores (and no hyperthreading involved) and putting the server under ...
7
votes
4
answers
44k
views
Limitations of SQL Server 2012 Express version?
I'm aware that the SQL Server 2008 R2 Express was limited to 1 CPU and 10 GB Databases. It's not clear if Microsoft bumped those numbers up to be more reflective of 2012. I looked at several places ...
7
votes
1
answer
3k
views
SQL Server Debugging: "Unable to Step. Invalid operation"
I'm debugging a call to a Stored Procedure in SSMS (2012). Frequently, and various random points in the code, a dialog pops up:
Microsoft SQL Server Management Studio:
Unable to Step. Invalid ...
7
votes
1
answer
40k
views
TLS Error 70 issues
I have a web application (IIS 8) on one server (Windows Server 2012) connecting to SQL Server Reporting Services 2012 on another server (Windows Server 2008) that until recently was working fine. ...
7
votes
1
answer
2k
views
Can only connect to sql server express 2012 via named pipes
I have sql server express 2012 installed on windows 2008, locally everything works just fine i can connect via tcpip and named pipes. Remotely i can connect with ssms only using named pipes. By ...
6
votes
4
answers
68k
views
How do I install SQL Svr Native Client 10.1 after SQL 2012 has been installed
On a Windows Server 2012 I have SQL Server 2012 installed which has the SQL Server Native Client version 11. I am being told by a developer that he needs the SQL Server Native Client version 10.1 (...
6
votes
1
answer
13k
views
Will SQL Server 2012 install + run Windows 2003
I can't seem to find any information but can I install SQL Server 2012 Standard Edition on a server running Windows Server 2003 R2 x64?
I don't intend to use this for production just for testing and ...
6
votes
1
answer
5k
views
Medialayout Silent installation sp1 sql2012
My silent installation for SQL Server 2012 SP1 is failing and giving an error as below. Any ideas?
TITLE: SQL Server Setup failure.
SQL Server Setup has encountered the following error:
...
6
votes
0
answers
402
views
SQL server language media doesn't support the language of the OS [duplicate]
While trying to install SQL server 2012, I get the error: "SQL server language media doesn't support the language of the OS"
I've downloaded the SQL server 2012 in English language only (2 times to ...
5
votes
3
answers
8k
views
SQL Server Collation settings for System Center Service Manager 2012
There is a lot of conflicting or confusing information surrounding the required collation settings for SQL Server, as it pertains to hosting the SCSM 2012 database and associated data warehouse ...
5
votes
3
answers
15k
views
destination directory for SQL Server 2012 is greyed out
I tried to install SQL Server 2012 Standard on Windows 2008 and on Windows 7 (I only wanted to install management studio on Win7). Same ISO; both machines are newly built. However, on Windows 7 Shared ...
5
votes
2
answers
8k
views
SQL Server 2012 - Transparent Data Encryption not available in this edition
Let me start by saying that the instance of SQL Server 2012 I am attempting to set up TDE (Transparent Data Encryption) on, is the Enterprise edition.
However, when following the MSDN tutorial ...
5
votes
3
answers
18k
views
AlwaysOn SQL Server 2012 - any option for true active/active?
I'm about to upgrade and consolidate a group of SQL Server 2008R2 to a single SQL Server 2012.
I want have high availability and looking for the different options. The number of databases is fairly ...
5
votes
1
answer
3k
views
Re configure TFS 2012 reporting services
I have a TFS 2012 installation that is working perfectly. I've installed TFS using advanced configuration and choose to not configure at that moment the Reporting and Sharepoint features.
Now, I ...
5
votes
1
answer
3k
views
Should I Use the Default SQL Server 2012 Accounts or Make Specific Ones?
I'm installing the 180 day trial of SQL Server 2012 on a virtual machine with the intent of buying a license for it later on. From past experiences with installing SQL Server I would always make ...
4
votes
3
answers
5k
views
How to sysprep SQL Server Express?
We plan to deploy Hyper-V VHD with Windows Server 2008 R2 and SQL Server 2012 Express installed to multiple hosts. From my understanding, the correct way to do this is to install SQL Server in ...
4
votes
2
answers
1k
views
How much memory does my SQL need?
I have a VM (SQL database server) that I think has more memory then it needs, however I'm not sure what I can reduce it to because I don't understand exactly what "In use", "Available", "Committed" ...
4
votes
1
answer
233
views
High Available SQL Server without SAN by using AlwaysOn feature
I have two Microsoft SQL Servers (v 2012) and I want to make them mirror and when one of them goes down the second one will be replaced.
AlwaysOn is a new feature in SQL Server 2012 that is ...
4
votes
1
answer
1k
views
Regarding High Availability for MSSQL Server
Already used in MySQL : Real Time Replication (synchronization) between primary and secondary server is done using master and slave commands. So What is the equivalent feature for MsSQL. Which ...
4
votes
3
answers
3k
views
How do I configure active directory when Sql Server 2012 is using a Virtual Account?
I'm getting the following event log entry from Sql Server 2012:
SQL Server Scheduled Job 'Replication agents checkup' - Status: Failed - Invoked on: 2012-08-04 10:00:00 - Message: The job failed. ...
4
votes
2
answers
11k
views
Unable to Install SQL Server on Server 2012
The problem
I have been trying to install SQL Server 2012 on Windows Server 2012. I continually get the same error:
Managed SQL Server Installer has stopped working
Problem signature:
Problem ...
4
votes
1
answer
823
views
SQL Server 2012 Management Studio Express - no server
I am having trouble with SQL Server 2012 Management Studio. There is no server name.
Earlier I installed the 2008 version but something wasn't right so I uninstalled and installed 2012. Upon ...
4
votes
1
answer
694
views
Best practice for application logging database replacement
Our web apps (30 or so) log application specific stuff to a centralized logging database (Sql Server 2012) with log4net, so the logging database gets huge quickly. Thus we decided to replace it every ...
4
votes
0
answers
2k
views
Local DTC is missing on server 2008r2
I've recently had an issue where MSDTC was unable to start up.
The error in the command line when running net start msdtc indicated that there were configuration issues.
I went into the registry and ...
4
votes
1
answer
6k
views
Random connection failures between IIS8 and MSSQL 2012 in RackSpace Cloud [closed]
Background
For years I hosted all of my server functionality, including IIS, Apache, MySql, and MSSQL on a single server instance, yikes! As my client base grew this led to persistent SQL Timeouts ...
4
votes
0
answers
2k
views
Grant Kerberos Constrained Delegation to SQL Server 2012 running as Managed Service Account
I can't see how to grant Kerberos Constrained Delegation for a service identified by a Managed Service Account.
I have a Windows 2008 R2 functional level single domain single forest, two 2008 R2 SP1 ...
3
votes
2
answers
1k
views
Dealing with Stretch (Geo) Cluster Node Failures
Scenario:
Three node (shared nothing) cluster on Windows Server 2012.
Two nodes in the primary data center, both with votes (node weight = 1), and a file share witness. The third node is in a remote ...
3
votes
3
answers
8k
views
AWS RDS (SQL Server): SSL Connection - The target principal name is incorrect
I have a Amazon Web Services (AWS) Relational Database Service (RDS) instance running SQL Server 2012 Express.
I've installed Amazon's aws.amazon.com/rds certificate in the client machine's Trusted ...
3
votes
1
answer
5k
views
Unattended installation of MS SQL Server (2008|2012) EXPRESS?
My goal is to install MS SQL Server 2012 R2 Express.
I've downloaded SQLEXPRADV_x64_ENU.exe and used /ACTION=Install /UIMODE=Normal to generate and modify a configuration file. No matter how I fiddle ...
3
votes
1
answer
1k
views
Is SQL Management Studio 2012 avaliable, without Engine itself?
On my dev machine, I have SQL Management Studio 2008 R2 installed. I tried to upgrade to SSMS 2012 Express, setup finished but nothing happened.
Is it possible to get SQL Management Studio 2012 ...
3
votes
1
answer
2k
views
What happens to running queries when stopping a Microsoft SQL Server instance?
Consider that a MS SQL Server instance is executing a long-running query the service is stopped via services.msc or - as it actually happening - a system shutdown triggered by a UPS as the server is ...
3
votes
2
answers
6k
views
Restore transaction log backup - media family error
Our backup procedure is as follows: midnight full backup, every 8 hour differential backups, and every 5 minutes transaction log backups. Maintenance plans keep everything rolling and tidy.
To ...
3
votes
1
answer
11k
views
SQL Server 2012 Installation Hangs
We have a Windows 8 machine that we installed SQL Server 2005 on first.
We then uninstalled it and installed SQL Server 2012 - unsuccessfully. The installation wizard hung at the point where it says:...
3
votes
2
answers
4k
views
Best Practice - SQL 2012 & IIS in VMWare
We are pretty new to VMWare and looking for some thoughts on our environment.
We have a VMWare cluster that has on one host:
VM#1: MS Windows 2008 R2 Enterprise & SQL Server 2012
VM#2: MS Windows ...
3
votes
1
answer
1k
views
IIS8 Application Pool Identity with Integrated Security to a SQL Server in a non-trusted domain?
Here is the scenario that we are experiencing and why we are trying to solve this:
We are a consulting company that support a particular third-party software application for a number of clients. The ...
3
votes
2
answers
58
views
SQL 2012 Standard - AlwaysOn FCI - Single point of contact?
I am looking at HA options for SQL 2012 Standard.
I like the look of AlwaysOn FCI. I am using a SAN, so I think I can meet all of the requirements, but one of the applications I am looking at cannot ...
3
votes
2
answers
701
views
Can I access the failover server on AWS RDS?
I am trying to create a working proof-of-concept in AWS for our web application which suddenly needs to scale out very quickly. Currently it is hosted on a local VMware server and we are migrating to ...
3
votes
2
answers
8k
views
Failover Cluster Client Access Point Only Responds to Pings on the Owner Node
Background
We're running two VMs (Windows Server 2012 R2) on Azure with SQL Server installed, set up as an availability group. We also, of course, have another VM as a dedicated DC. These are all ...
3
votes
1
answer
1k
views
How can I set up a SQL file share that doesn't need sysadmin access to write to it?
We have a SQL Server 2012 installation with the file share feature enabled. We then have an IIS application that can write directly to the \localhost\MSSQLServer... share that the database creates.
...
3
votes
0
answers
843
views
Why is SQL Server using all ephemeral ports connecting to itself and causing TIME_WAITs?
I've got an AWS server with Windows 2008 R2, SQL Server 2012, and Tomcat 7. When I run netstat -ano the screen is flooded with TIME_WAIT. I posted the output in a Gist.
When I run CurrPorts, filter ...
3
votes
1
answer
95
views
What are the downsides of running all SQL Servers under same domain account?
I am running two SQL Servers 2012 (for Always On) under the same domain account and would like to know what are the downsides in doing so. Few articles that I have read prior setting up the servers ...
2
votes
1
answer
253
views
Shrinking Database using the AUTO_SHRINK ON , helpful or is it consuming to many resources?
I have multiple databases which are constantly growing. So from time to time, I truncate the log table and shrink the biggest databases. For the biggest one (>40gb) it takes quiete some time.
So I ...
2
votes
1
answer
989
views
Manage SQL Agent Jobs On Multiple Servers
Is there a way to deploy/modify/remove//manage SQL Agent Jobs across multiple servers within a domain without third-party software?
2
votes
3
answers
2k
views
How to run PHP + IIS8 as Windows User, or should I?
I am creating a PHP website on IIS8 that needs to connect to an SQL Server that is in the same Windows Domain as the IIS8. I am given a Windows Domain user account and asked to connect using its ...
2
votes
2
answers
4k
views
SQL Server 2012 Maintenance Plan succeeds but does not perform backup
I have a new SQL Server 2012 AlwaysOn Availability Group on Windows Server 2008 R2 Ent SP1.
I'm creating a Maintenance Plan on the Primary Replica which is supposed to do Full (non-copy-only) backups ...