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

learn more… | top users | synonyms

2
votes
1answer
1k views

Random connection failures between IIS8 and MSSQL 2012 in RackSpace Cloud

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 ...
0
votes
1answer
1k views

Failing SQL Server Cluster installation, Addnode: Remote registry call failed

I'm adding a node to a SQL Server failover cluster. The installer throws the error "Addnode: Remote registry call failed. Unable to retrieve primary node Filestream settings" when adding node two ...
0
votes
0answers
16 views

Any advice on those server upgrades? [duplicate]

Currently, im planning to upgrade some servers. 2 Dell R610 as Application Servers with 2x 4 Core Cpu Planning to put 32 gb ram, and 2x intel dc s3610 200g(Samsung 850 pro 256g, if money is a ...
1
vote
1answer
1k 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 ...
0
votes
0answers
8 views

MDX run slower in SSRS than in Management Studio

I have an mdx dataset for a SSRS 2012 report. Running MDX in Management Studio takes 1 sec, but in report it takes 1 minute. This is a critical report and the user want it as fast as possible. I have ...
0
votes
1answer
37 views

SQL Server 2012 Service not starting (Probably related to Service Agent issue)

I have an application (Dynamics AX 2012) that can't connect to the SQL server. I log onto the SQL server, and open SQL Server Management studio and can't connect to the database engine. I check the ...
2
votes
1answer
20 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?
0
votes
0answers
31 views

SQL Server 2012 Microsoft-Windows-Perflib Error Message Event Code 1010

I am seeing the below error message occur every 15 minutes on a Hyper-V guest running Server 2012 R2 with SQL Server 2012 with SP2 (DB, SSIS, SSRS). I am wondering how to diagnose what this error ...
0
votes
1answer
823 views

No file access permissions after restore database

I have a strange phenomon. When I restore a SQL-Server 2012 database to a folder on my D-Drive, it gets restored just fine. I can access the database and basically it works fine. But when I check the ...
0
votes
0answers
36 views

Considerations for SQL Server 2012 when performing in-place OS upgrade to 2012 R2

I'm running SQL Server 2012 Enterprise (11.0.3381.0) on Server 2012 (6.2.9200) and am preparing for an in-place OS upgrade to 2012 R2. We've got an Always-On Availability Group in a 2-server cluster ...
1
vote
1answer
36 views

Latency & SQL Connections over Fiber WAN - Application E-manage

I am hosting an encrypted SQL server database (SQL Server 2012) on a VMware host at my Salt Lake location. My Salt Lake data pipe is 100 Mbps over fiber via Comcast. My Phoenix side has a 50 Mbps over ...
0
votes
0answers
33 views

SQL 2012 AlwaysOn Availability Groups Failover Successfully But Application Complains About Login Failed for User

I am trying to get SQL 2012 AlwaysOn Availability Groups working for an application. The cluster has 2 SQL nodes and 1 witness server. Everything appears to be failing over successfully when I do ...
2
votes
1answer
42 views

Hyper-V Guest data encryption

I have a new requirement to encrypt the data inside an sql database while it is at rest. So far I've looked at Bitlocker (see below), and other commercial products (I won't name because I'm not ...
0
votes
1answer
66 views

Install SQL Server 2012 to Windows Server 2008

I'm trying to install SQL Server 2012 in Windows Server 2008 R2 Standard Operating System. However this Error keep appearing even though I installed both .NET Framework 3.5.1 and 4.0 The operating ...
1
vote
2answers
35 views

Can't connect after NEW Install SQL Server 2012 on Win 7 Pro SP1 with Windows Auth or SQL Server Auth

Trying to install SQL Server 2012 (Eval) to work with the new BI tools using AdventureWorksDW tutorial. Therefore, I feel I've gotten bogged down in SA activities that would be done by others in the ...
0
votes
2answers
203 views

SQL Server Management Studio 2012 - password lag and failure

In a new installation of SQL Server 2012 Standard, we have mixed-mode authentication enabled. Using Windows authentication, I can authenticate and use SQL Management Studio as expected. Using SQL ...
1
vote
1answer
1k 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 ...
0
votes
0answers
39 views
0
votes
1answer
176 views

Does the amount of disks in a RAID10 matter for a Microsoft SQL server in regards of the block size?

We are planning to deploy a Microsoft SQL Server and to store the databases on a RAID10 (RAID1+0) block-level-storage. Does it matter how many drives altogether I put into the array for optimum ...
-1
votes
1answer
120 views

What are my options to run MS SQL 2012 on Amazon RDS for development if I only have MSDN license? [duplicate]

I want to run MS SQL 2012 SE BYOL on Amazon RDS under my own MSDN license but it looks like MSDN license doesn't allow me to run MS SQL unless I host it on the dedicated hardware Microsoft Volume ...
0
votes
1answer
63 views

Slow merge replication over a WAN link - only downloads

We've been using SQL Server merge replication for a few years to synchronise data between our data centres, but we are now suffering with a big performance issue. This may be because the amount of ...
4
votes
2answers
221 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" ...
1
vote
1answer
120 views

Can we use FILESTREAM in case of SQL Server cluster

I saw this point on Technet article about RBS. The local FILESTREAM provider is supported only when it is used on local hard disk drives or an attached Internet Small Computer System Interface ...
0
votes
1answer
35 views

How to setup user accounts on a secondary server in High Availability?

Working with two Microsoft SQL 2012 servers in Always On High Availability configuration running on Windows Server 2012 R2. Setup works well and failover is almost flawless. However, the software ...
3
votes
1answer
111 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 ...
0
votes
1answer
1k views

ADSI Linked Server: Why can I query AD in VBA, but not as a Linked Server?

After all the reading and research I've done, this seems like the most logical place to post this question: Why can I query Active Directory using VBA, but not a Linked Server in SQL Management ...
0
votes
0answers
187 views

Sharepoint 2013 Access denied/file not found on login

I'm trying to setup a little sharepoint developement enviroment but i can't get it working. We use Sharepoint 2013 Foundation and Server 2012 R2 and SQL Server 2012 BI edition. If i try to login with ...
1
vote
0answers
76 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 ...
0
votes
2answers
54 views

Migrate MSSQL 2008R2 to 2012 (new hardware)

Since hardware support for our server ends we are migrating to a new hardware and simultaneously upgrading MSSQL 2008R2 to MSSQL 2012. I searched a little bit and found some guides, but they all ...
6
votes
1answer
8k 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 ...
0
votes
0answers
69 views

Upgrading SQL Server from 2008 to 2012 doesn't respect existing install paths

Basic Information : Running Microsoft Windows Server 2008 with MS SQL Server 2008 (version 10.0.5869), trying to upgrade to SQL Server 2012. Currently working in a cloned VM of our production server ...
0
votes
0answers
19 views

SQL Server 2012 Web uses max 4CPUs. AZ RDS allows deployment on R3.2xLarge (8vCPU) instance. Why?

According to MS documentation, SQL Server 2012 Web Ed. is limited to use 4CPUs. However, Amazon RDS allows it to be deployed on R3.2xLarge instance. BTW, R3.2xLarge offers 8vCPUs. So is it helpful ...
1
vote
0answers
366 views

SQL Server 2012 permissions from AD group login not refreshed until server restart

We have some IIS sites which runs under Managed Service Accounts (Windows Server 2012). Theese MSAs are members of resource groups in Active Directory. We are using resource groups as logins in SQL ...
0
votes
0answers
11 views

sql server 2012 licensing [duplicate]

I have a sql server 2012 instance (2x2 cores standard edition) running in hyper-v guest. The guest server is currently configured with 4 vcpu ( to respect the licensing), however the physical node is ...
1
vote
1answer
228 views

Is it possible to store a credential for Windows Authentication to an Analysis Services server?

SQL Server Analysis Services uses Windows authentication for server connections. Typically, you assign your domain account to a role (or the server administrator list), and then connect to the server ...
0
votes
1answer
181 views

How to attach a database created by sql 2008 to sql 2012 when full text catalog missing? [closed]

I have an already created mdf file which was created by sql server 2008.But when I attach this mdf file to sql server 2012 it asks me to add necessary full text catalogs. I have no idea what to ...
0
votes
1answer
526 views

SQL Server Management Tools available on SQL Server 2012 express?

My goal is to access a server with some cube data and query it. If I understand correctly I need Analysis Services in order to accomplish this. My Current install of SQL Server Management Studio ...
0
votes
1answer
160 views

Setting up Multi server environment in Sql Server 2012 - Enlist Failed Error

I am trying to Configure the Master target server / Multi server environment in Sql Server 2012. I changed : MSXENCryptChannnelOptions # Changed from 2 to 0 AllowDownloadedJobsToMatchProxyName # ...
2
votes
1answer
47 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 ...
0
votes
0answers
71 views

Kerberos and SQL server connection string

I am working on a project to migrate a legacy ASP program (NOT .NET!!) from W2k3 to W2K12 R2 (also from SQL server 2K -> 2K12). The ASP program file has a config for SQL server connection string which ...
0
votes
2answers
5k views

SQL server agent job to execute SSIS package fails, package succeds if run manually

I've got a SSIS package installed on a SQL server (SQL Server 2012). It's fairly simple and just fetches data from a remote data source and adds it into a local table. The remote connection string is ...
-2
votes
1answer
220 views

In MS SQL 2012 Database how to insert a very large table data in chunks

I need to archive large chunks of information in SQL Server 2012 by moving the data to a new table without blocking other users from using the original table. Is the best way to do this using a T-SQL ...
0
votes
2answers
88 views

SQL Server: Upgrade CPU or add a second CPU? [closed]

Currently have a 2 socket server with a single xeon e5-2407 @2.2Ghz running SQL Server 2012. There are no performance issues at the moment but wondering for the future if it would be better to upgrade ...
0
votes
0answers
12 views

SQL Server Chain Permission

We have the 2 databases. Reporting HR There are some users who want to extract data from HR database. But we don't want to give direct access to that HR database. So, we created the special views in ...
0
votes
1answer
106 views

TFS Database migration miss the detach step issue

We currently doing the TFS database migration, originally, we suppose to upgrade to 2012 which support SQL 2008 R2, after a period of time, we decide to upgrade to 2013, and unfortunately we are ...
0
votes
2answers
1k views

Windows Server Failover Clustering with two servers

I was going to create a Windows Server Failover Cluster, in order to set up MS SQL Server AlwaysOn Availability Groups. As a prerequisite of failover clustering, I've created and configured an ...
1
vote
1answer
4k 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: ...
2
votes
1answer
5k views

Windows Installer runs constantly in the background on Windows Server 2012?

While trying to install a program, it complained that something else was being installed and that Windows Installer was already running (msiexec.exe). Sure enough, there were two instances of the ...
0
votes
1answer
40 views

prevent replace sql database files with old one

i have a database that i use in my application. the operation i want to prevent is if i stop sql server and take the database files to another location then start the sql server and make some ...
4
votes
2answers
4k 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 ...