Microsoft SQL Server 2012 (often abbreviated as SQL Server 2012 or MSSQL 2012) is the latest 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 ...

learn more… | top users | synonyms

0
votes
0answers
4 views

SQL Server Reporting Services 2012 Chinese Language

When running reports in SQL Server 2012 Reporting Services (SSRS), Chinese (Asian) characters show up as question marks (?). Any idea on how to have the characters display properly in reports? ...
1
vote
1answer
52 views

MS SQL Server connection reset on AWS if column has more than 39kb

We migrated an app that does some business inteligence, so it does manage a lot of data. This app works perfectly on our own environment, but when running in AWS we received a lot of "connection ...
1
vote
1answer
62 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 ...
1
vote
0answers
6 views

SQL 2012 SQL server Agent Jobs

I am trying to figure out how to troubleshoot a situation with SQL Server Agent (2012). A job that has been running nightly (user SQL Server Agent as its scheduler) for over a year in 2 to 4 seconds ...
-1
votes
0answers
16 views

Uninstalling Sql Server 2012

I am trying to uninstal SQL Server 2012 to do a new clean install. I get an error message that "The operating system... minimum requirements etc" I have uninstalled all the other SqlServer related ...
0
votes
0answers
26 views

SQL Server database backup to Windows Azure Recovery Service

I have some VMs on Windows Azure and IIS and SQL Server 2012 is installed on them. I also created a Backup Vault on Windows Azure and installed the Windows Azure Backup Agent on the VMs. It works ...
0
votes
0answers
21 views

Can SharePoint 2013 and Microsoft Dynamics GP 2013 run on the same server?

We have a new Windows 2012 server with SQL Server 2012 and Microsoft Dynamics GP 2013 running on it. I have been asked to install SharePoint 2013 on this server also. I know GP 2013 now uses SSRS for ...
1
vote
1answer
14 views

Error in cross server sqlcmd execution due to firewall issue

I have an application server with an IP of 10.107.0.100 and one database server on which SQL Server 2012 is installed, with an IP of 10.107.0.101. Remote connections are made to this server, and the ...
3
votes
1answer
42 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 ...
0
votes
1answer
68 views

SQL Server 2012 Reporting Services to export CSV

I have an SQL Server 2012 Reporting Services instance, and by default, it can only export to PDF, Excel and Word. Users require CSV export as well. All I found is that there are different extensions, ...
-1
votes
0answers
35 views

CPU 99% in new server [closed]

Two of our clients have recently upgraded to brand new servers running Windows server 2012, but servers worked great for a while (a month or so) after that the cpu utilization is steady at 99% At ...
1
vote
1answer
38 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 ...
1
vote
1answer
21 views

Is this the correct way to wait for an idle database catalog before restoring a log (for Sql Server log shipping)?

I want to have a separate instance of Sql Server dedicated to a "reporting" role. I've decided to populate that server via Log Shipping (since mirroring won't work, and Availability Groups is ...
1
vote
1answer
39 views

Installing SQL Server 2012 on older instance

I have SQL Server 2008R2 installed on my server which I can connect either by providing server name "xyz" or IP address "127.xx.xx.xxx". Does it mean my installation is done with default instance? ...
0
votes
1answer
29 views

How can I get SQL 2012 Web Edition?

If I want to get a copy of SQL 2012 Web Edition, do I have to go through a hosting provider such as Rackspace? What about if I am in the MS Select program and a Volume Licensing account? How is it ...
0
votes
0answers
40 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
32 views

SQL Server Failover Cluster on Azure (HA Strategy)

In the context of SQL Server 2012 Standard Edition, is it possible to make Azure Blob storage available to a SQL Failover cluster directly as a shared SCSI resource on a Windows Cluster? An Azure blob ...
-1
votes
1answer
56 views

Unable to install SQL Server 2012

Unable to install SQL Server 2012 Error SQL Server Setup has encountered the following error: 1: 2229 2: Q:\PCUSOURCE\1033_ENU_LP\x86\setup\x86\sqlncli.msi 3: Property 4: SELECT Value FROM Property ...
1
vote
0answers
76 views

SQL Server 2012 Cluster BSOD

I'm trying to set up a SQL Server 2012 SP1 "AlwaysOn Failover Cluster Instance" on top of a Windows Server 2012 R2 cluster (cl01) consisting of 2x 2012 R2 nodes (sql1 and sql2). Hosted on VMWare ESXi ...
0
votes
0answers
52 views

Disabling locked page allocations in SQL Server 2012

Locked page allocations are enabled in my instance of SQL server 2012 even though I have no accounts with the "lock pages in memory" user right. This article by Microsoft - ...
0
votes
0answers
47 views

Use AWS ephemeral drives for SQL Server for redundancy/read-only/other live purposes

Are there any good uses for the ephemeral drives on AWS Windows instances when using SQL Server besides putting TempDB and the pagefile there? I'm wondering, for example, if one could replicate the ...
0
votes
1answer
42 views

How do I upgrade sql server 2012 RTM to sql server 2012 SP1

I'm really confused by the 2 different editions of SQL Server 2012. There is RTM and SP1 which both seem like different code branches. How do I upgrade an RTM install to a SP1 install. I've tried ...
0
votes
0answers
19 views

Automatic failover in SQL server alwayson availability group

I have 2 nodes in my SQL server fail over cluster. I use SQL server 2012 always on feature for HA purpose. The problem is that when one my server goes down the automatic fail over does not happen! ...
0
votes
1answer
50 views

SQL server databases are stucked in restoring state

I have a single server in my SharePoint 2010 server farm. Today some of users complained about that some of Infopath forms can not be opened. When I checked the SOL Server Management Studio I saw that ...
0
votes
1answer
234 views

SQL Server 2008/2012 Express install fails on scenarioengine.exe [closed]

I'm trying to install SQL Server 2012 Express on a Windows 7 64-bit PC. It also fails to install SQL Server 2008 R2. The bootstrapper extracts all the files, runs setup.exe (with UAC popup) then ...
3
votes
1answer
49 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 ...
1
vote
1answer
104 views

Setting up a SQL Server 2012 Failover Cluster Instance on an Azure VM

I'm trying to set up a test lab in Windows Azure for a SQL Server 2012 Standard Failover Cluster. When deploying a SQL Server 2012 VM through the gallery, the instance that's created is pre-installed ...
1
vote
1answer
44 views

Colliding/overlapping full and differential backups in SQL Server

I am trying to set up a monthly full backup and a daily differential. The full backup is currently on the 1st, but I might change it to the first Saturday. I need to retain full backups for a few ...
-1
votes
1answer
38 views

Cannot install Microsoft SQL Server 2012 prerequisites on Windows Server 2008 Core

I have the server with Windows Server 2008 core SP2 and I need to install SQL Server 2012 in it. The problem is that SQL Server requires .NET 4.5 and when I try to install .NET 4.5, the OS gives an ...
0
votes
1answer
45 views

TFS 2012 Backups w/DPM

I have a few servers running (mixture of 2012 and 2012 R2) and am playing with Microsoft's DPM as a backup solution. One of the things it complained about during installation was ensuring the SQL ...
1
vote
1answer
35 views

Does Win 2012 Standard Edition support clustering of SQL 2012 Enterprise Edition?

Can you cluster SQL 2012 Enterprise Edition on Win 2012 Standard Edition? The features doesn't seem to clarify whether it allowed or not. We are seeing warning “Cluster Nodes Failed" in the SQL ...
0
votes
2answers
47 views

Does it change anything when I disable obsolete parameters in SQL Backups? SKIP , stats, Nounload , norewind etc

I am pretty new in managing Computersystems but I always want to know everything to get out the maximum. When we last time deployed a new version of our application I was given a backup script to ...
0
votes
1answer
307 views

sql error “Service Broker needs to access the master key in the Database ”xxx" Master Key has to exist

I am pretty new to SQL and administration of databases and still learning. We receive one SQL error for quiete a long time, which has as far as we know no effect on our application. So we put that to ...
0
votes
2answers
63 views

Possible to take a backup of SQL Server 2012 DB and restore on 2008?

I want to take a backup of SQL 2012 and restore on 2008, is that possible ? I have this options which I can't change on DB. Thank you
0
votes
2answers
155 views

Just a few questions about Hyper-V virtual machines and clustering

I have been using Microsoft’s Hyper-V technology for a little while now, but I am just now dipping my toe into clustering. In particular, I am trying to implement a fault-tolerant SQL DB. This ...
1
vote
0answers
60 views

Alternative method of viewing a database diagram in SQL Server to see what tables have gone missing? [closed]

I have a database diagram for my database, but when I open it in SQL Server, I almost immediately get a message saying some permissions changed or tables in the diagram were dropped or renamed, and ...
0
votes
1answer
743 views

Error with SQL Server Setup 2012 on Windows 2012

I am trying to install SQL Server on Windows 2012. I was able to finally get the wizard up and running after making some changes on the server, but now it fails no matter what I do with the following ...
0
votes
1answer
51 views

If a SQL Server Replication Distributor and Subscriber are on the same server, should a PUSH or PULL subsciption be used?

Thanks in advance for any help. I'm setting up a new Microsoft SQL Server replication and I have the Distributor and Subscriber running on the same server. The Publisher is on a remote server (as it ...
3
votes
1answer
650 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 ...
0
votes
0answers
51 views

After installing MS SQL Server 2012 not able to log into SSMS

Okay, lot's of posts around the internet on this subject. But I haven't been able to find an answer I was looking for. I installed SQLS 2012 on Windows Server 2012. I installed the Engine and the ...
0
votes
1answer
76 views

Microsoft Dynamics CRM 2011 + SQL Server 2012 database compatibility level

I know that Microsoft CRM 2011 is compatible with SQL Server 2012 since UR6 (UR10 for SP1). According to official documentation: During an upgrade or a new installation, Microsoft Dynamics CRM ...
0
votes
1answer
71 views

Windows Server and SQL Server Licenses [duplicate]

I have the following servers: PROD: 2 x web servers (content delivery) 1 x cms server 2 x database servers (SQL) UAT: 1 x web server (content delivery + cms) 1 x database server (SQL) I'm a ...
1
vote
1answer
19 views

SQL Server Access Logs

Is it possible to show some type of access log where a valid user (who had access to a specific database [or multiple ones]) tried to access a database they didn't have access to? For example, if I ...
0
votes
1answer
158 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
1answer
144 views

SSIS/ETL jobs fail with network related errors, when network is OK

We have a SQL Server 2012 instance that is our main ETL/DW server. The daily jobs consist of about 40+ ETL processes querying other data sources, updating the DataMart, standard ETL and BI processes. ...
2
votes
1answer
113 views

Upgrade Expired SQL Server 2008R2 Evaluation to SQL Server 2012

We have been working on developing several SharePoint sites as a POC using the evaluation versions of SharePoint 2013 and SQL Server 2008R2 Enterprise Evaluation. POC worked, went into limited ...
0
votes
0answers
246 views

Error 1639 Reporting Services - Native failed with errors SQL Server 2012

I get Error 1639 when attempting to install SQL Server 2012 Reporting Services. My research, conclusion, and question about a resolution are all outlined below. Thank you in advance for your help. ...
0
votes
1answer
31 views

SQL Server 2012 Management Studio Connect after some time (File not found error)

I've a root server with Window Server 2008 R2 where MS SQL Server 2012 is installed. Get a error while connecting. Management Studio Error Message File not found This error only occur directly after ...
0
votes
1answer
135 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 ...
1
vote
1answer
460 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: ...