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.

Filter by
Sorted by
Tagged with
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 ...
Agustin Meriles's user avatar
1 vote
1 answer
2k views

Cannot reach SQLServer after join domain

I'm configuring TFS 2012 in advanced mode, that means that Sql Server is on another machine. When I need to specify the database server (in the TFS Configuration) it fails because the SqlServer host ...
Agustin Meriles's user avatar
1 vote
1 answer
8k views

"CREATE DATABASE permission denied in database 'master'" to sysadmin user in SQL Server Express 2012

I'm seeing some odd behaviour with SQL Server 2012 Express Edition, where a sysadmin user does not have permission to create databases. The evolution of this installation has been somewhat trying: ...
alastairs's user avatar
  • 3,235
0 votes
0 answers
97 views

Allow VM2 access VM1's SQL Server Database

I have two VMs running on a Mac Server using VM Fusion 4. Both VMs are running windows 7, and I have SQL Server 2012 installed and data imported into VM1. Right now, I'm trying to figure out a way to ...
Firyn's user avatar
  • 111
1 vote
1 answer
3k views

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

Alright, a little explanation. I have two separate PCs, both of which have virtually an identical installation of SQL Server 2012 Express on them. During installation for both, I had chosen the ...
Ahmad's user avatar
  • 133
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 ...
Steven Murawski's user avatar
2 votes
2 answers
13k views

MS SQL Server 2012 - Unable to access Instance on localhost

5 days ago I was access able to access SQL Server on my localhost machine via SSMS perfectly, no errors logging in with credentials. Now I get this error: =============================================...
loonison101's user avatar
1 vote
1 answer
2k views

How do I grant IIS APPPOOL\Orchard access to SQL Server 2012 Developer?

When I tried to install Orchard CMS to it's own web site, IIS create a web pool called Orchard. After supplying a connection string of Data Source=(local);Initial Catalog=Orchard;Integrated Security=...
ProfK's user avatar
  • 493
0 votes
0 answers
288 views

Failure running SQL2012 on Windows 8 with local service accounts

I have installed SQL2012 on a Windows 8 laptop that is on a domain. The domain includes a group policy that defines accounts that can "Log on as a service". I installed SQL Server 2012 using the ...
Martin Robins's user avatar
0 votes
1 answer
538 views

SQL Server 2012 Multiple Instance Priority

I'm in the process of upgrading our small SQL databases to SQL Server 2012. We have at least 3 instances, (1) Critical work databases, (2) low-importance System Maintenance databases, (3) WSUS. Can I ...
Dom's user avatar
  • 741
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 ...
TCM's user avatar
  • 161
0 votes
1 answer
560 views

LINQPad and SQL2012 management studio cannot talk to network Database Servers (SQL2008R2)

I installed LinQPad 4.0 on my machine. LinQPad can talk to local database servers on my machine, but cannot communicate or add a connection to network database servers on the network. SQL2008 ...
Mohan Deval's user avatar
0 votes
1 answer
2k views

Package run on SQL Server Job Agent - Login failed for user

I created a package on my SQL Server (2012) through the import/export data wizard which exports data to another SQL Server (2008). I set up a job which runs this package but I get an error: ...
Rivka's user avatar
  • 353
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 ...
MikeMurko's user avatar
  • 204
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 ...
AX1's user avatar
  • 1,289
1 vote
5 answers
6k views

Accessing SQL with the PC name not the IP

I'm trying to connect to a SQL instance (default instance) on a machine. When using the IP of the machine it connects to the machine. Using the name of the machine on that machine you are able to ...
Cornelius's user avatar
  • 131
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:...
Rivka's user avatar
  • 353
0 votes
1 answer
78 views

DB access account for SharePoint 2013

I am installing SharePoint Server 2013 on Windows Server 2008 R2 SP1 with SQL 2012 on a VMware. During the SharePoint Configuration Wizard, I need to provide a DB access account. The VM is not part ...
user1847609's user avatar
1 vote
2 answers
3k views

SQL 2012 operating system requirements

I am trying to install SQL server 2012 on a VMware with Microsoft Server 2008 R2. But it gives me an Error indicating your operating system does not meet the minimum requirement for SQL server 2012. ...
user1847609's user avatar
1 vote
1 answer
2k views

How to unlock sa user in SQL Server 2012 if Windows Authentication doesn't work?

I am logged in as an admin on the computer. For some reason I can't log into SQL Server 2012 which is running on the same machine. The SA user is locked out. SQL Server was installed when I was logged ...
Tony_Henrich's user avatar
1 vote
3 answers
2k views

Can I use SQL-Server on Windows Server 2008 R2 core?

Is it possible to run SQL-Server 2008R2 or 2012 on Windows Server 2008 R2 Core installation. There are three questions to answer: Does the license allow this? Can I install and operate it? Is it ...
Peter Hahndorf's user avatar
-1 votes
1 answer
436 views

SQL Server 2012 memory usage steadily growing

I am very worried about the SQL Server 2012 Express instance on which my database is running: the SQL Server process memory usage is growing steadily (1.5GB after only 2 days working). The database is ...
pgmo's user avatar
  • 1
1 vote
0 answers
61 views

SQL Server 2012 : Installing on D:

i am trying to install SQL Server 2012 i choose D: for everything but still it told me during installation itself that it's going to install config file on C: following is the path C:\Program Files\...
hpsoftware's user avatar
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, ...
Mahdi Ghiasi's user avatar
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 ...
cooplarsh's user avatar
1 vote
1 answer
10k views

No 'Instance Features' in installation setup of Sql Server 2012

I try to install SQL Server 2012 Express on my personal computer (fresh install of Win 8). I downloaded the installation files on the Microsoft Website. The filename is SQLManagementStudio_x86_ENU.exe ...
Bronzato's user avatar
  • 155
1 vote
1 answer
553 views

database size limit in SQL Server 2012 Express Edition

I want to use SQL Server 2012 Express Edition. Does someone know the maximum file size limitation of the database?
msh's user avatar
  • 221
0 votes
1 answer
187 views

SQL Server 2012 Memory usage

Since i upgraded to SQL Server 2012 I've noticed that it almost doesn't consume any memory at all. Before when i used SQL Server 2008 R2 it used at least 2-4 GB of RAM and now it only used like 150 MB ...
Olaj's user avatar
  • 183
2 votes
1 answer
4k views

Missing menu items for Azure SQL tables within SQL Server Management Studio?

I have a table (say Table1) that is replicated via SQL Data Sync Agent across a local SQL Server 2012 as well as an Azure SQL Server (part of Microsoft Azure). Everything about Table1 (schema, table ...
DeepSpace101's user avatar
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 ...
user avatar
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 ...
Seph's user avatar
  • 185
2 votes
1 answer
12k views

SQL Server (2012 Enterprise) Browser service failing

SQL Server (2012 Enterprise) Browser service failing I have a problem as described below: I have an instance of SQL Server 2012 Enterprise (thanks to MSDN) for local development on my PC. I try to ...
Watki02's user avatar
  • 617
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 ...
YetAnotherDeveloper's user avatar
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 ...
Sheree's user avatar
  • 51
-1 votes
1 answer
6k views

Licensing SQL Server 2012 Reporting Services w/ SharePoint 2010 [duplicate]

Possible Duplicate: Can you help me with my software licensing issue? Here's my situation: I have 1 VM that is running SharePoint 2010 SP1. I have a different physical server that is running SQL ...
Evan M.'s user avatar
  • 842
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 ...
bobble14988's user avatar
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 ...
Dan Ribar's user avatar
0 votes
1 answer
2k views

Restarting MSSQLSERVER service on the principal or on the mirror the database is set in "In Recovery" mode

I'm running MSSQL Server 11.0.2100 (SQL Server 2012) and every time I restart the MSSQLSERVER service on the principal or on the mirror, the database mirror breaks and the database is set into In ...
Kalle's user avatar
  • 121
1 vote
1 answer
128 views

When using Transparent Data Encryption for SQL Server 2012, can you use different encryption keys for each database?

I am new to using TDE for SQL Server and one of the requirements that a client has is that their database be encrypted using a different key that is unique to only their database. I was wondering if ...
CheckRaise's user avatar
0 votes
1 answer
154 views

SQL Server on Hyper-V on SQL Server 2012

I saw that this is the feature of AlwaysOn for SQL Server 2012. Can anyone explain the meaning of this? I mean can anyone give example or scenario? SQL Server on Hyper-V SQL Server instances hosted ...
Alisa's user avatar
  • 101
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 ...
Valamas's user avatar
  • 365
0 votes
1 answer
696 views

SQL Server 2012 using MSA -- SharePoint 2010 Powershell backups impossible?

I'm having trouble trying to do a simple backup of our 2-server SharePoint 2010 farm. I'm running the backup process with a Powershell command, backing up to a UNC shared folder on the SharePoint ...
Jeff Harris's user avatar
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 ...
CJM's user avatar
  • 730
1 vote
1 answer
2k views

PowerPivot dashboard no data - Last successful refresh run: The cube has not been processed

I used AutoSPInstaller to install my farm, I then installed PowerPivot 2012 and configured with the following script: # Open PowerShell library from: C:\Program Files\Microsoft SQL Server\110\Tools\...
morleyc's user avatar
  • 1,150
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. ...
Mike's user avatar
  • 1,293
2 votes
1 answer
1k views

SQL Server 2012 Mirroring / AlwaysOn - need for SAN?

There appears to be a great deal of conflicting information about whether or not SAN is required for a Sql Server 2012 Mirroring setup. I currently have an Active-Passive-Witness SQL 2008R2 setup ...
Kenny's user avatar
  • 520
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 ...
Alasdair C-S's user avatar
1 vote
1 answer
2k views

error when trying to load SQL server 2008 R2 native client x86

There's technically 2 problems interlinked with each other here... I'm currently working on connecting to a mssql database from a website and testing everything through Xampp on a VM. When running ...
hmmk's user avatar
  • 13
0 votes
1 answer
120 views

Upgrading SQL Server 2000 to 2012

please is there any checklist available for upgrading SQL server 2000 to 2012? What is your experience with performing this? Could be the upgrade performed directly at all, or will I need to go ...
Matej's user avatar
  • 101
0 votes
0 answers
32 views

Cannot log in to SQL 2012 - no known login [duplicate]

Possible Duplicate: How to recover a MSSQL user's password? We recently installed SQL 2012 on one of our servers, but have been unable to log in. Another tech did the installation so I don't ...
gillonba's user avatar
  • 343