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
1
vote
3answers
1k 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 ...
2
votes
1answer
2k views

Classic asp site, randomly slow DB connection

We are running a site with classic asp and ASP.NET MVC 4 (C#) side by side. During high traffic, database queries are running really slow in the asp pages. At the same time, in the same site, C# ...
3
votes
2answers
6k 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 ...
0
votes
1answer
2k 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 # ...
0
votes
0answers
28 views

dcexec -c -s 2 -i “$(ESCAPE_DQUOTE(MACH))\$(ESCAPE_DQUOTE(INST))” -m 1

Failed to load the master package from the resources. The Data Collector resource file is corrupted. Inner Error ------------------> Cannot create a file when that file already exists. Can anyone ...
0
votes
0answers
27 views

SQL Server 2012 AAG not failing over in case of SQL Server crash/stop

I have created the following structure: Two hardware servers with Windows Server 2012R2 installed, SQL Server 2012R2 installed. Then Windows went fully updated and SQL Server was patched to SP4, ...
1
vote
1answer
3k 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 ...
1
vote
1answer
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\...
2
votes
2answers
3k 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 ...
5
votes
1answer
22k 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. ...
0
votes
1answer
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: ...
2
votes
1answer
1k views

SQL Server 2012 installation shared feature directory and instance root directory

During installation, is it ok to choose different Drives (say D and E) for Installation shared feature directory and Instance root directory or they should be on the same drive, or should any of them ...
0
votes
0answers
23 views

SQL Server 2012 Database engine failed to install everytime

I am trying to install SQL Server 2012 -64 bit in our dev server running Windows Server 2012. Everytime, Database engine fails to install. I've checked the event logs it shows. Operating system error ...
0
votes
0answers
70 views

Scheduled Job Failing on SQL Server Job Agent for AWS Redshift ODBC Connection

1- SSIS package is using AWS Redshift ODBC driver (32Bit)/Data source ("Redshift") to execute SQL statements. 2- I can run the package from the studio or job agent manually without any issue but when ...
2
votes
2answers
1k 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 (...
2
votes
1answer
3k views

Cant connect to sql server database using ip

I've created a sql server database on server A. I was always using Windows Authentication to connect, but now I want to connect to database from server B. Then, I added a new user to database and ...
0
votes
1answer
6k 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 ...
2
votes
3answers
1k 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 ...
0
votes
1answer
44 views

How to change concurrent users = 0?

First I was facing a network issue whenever I was trying to connect to my remote SQL Server. Some times the error was not shown and connected successfully but sometimes it was giving me this kind of ...
3
votes
1answer
609 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 ...
1
vote
1answer
2k views

SQL Server 2012 constant CPU load

I'm trying to diagnose an abnormal CPU usage of the sqlservr.exe process from a SQL Server 2012 Express installation. The installation is running in a VM with Windows Server 2012 R2, 8-core Xeon E5 ...
2
votes
1answer
1k views

Where Does sqlpackage.exe Store Database Backups?

I have a deployment script which uses sqlpackage.exe to deploy incremental changes to a database. (The project is maintained in the database edition of Visual Studio 2012 Express.) One of the flags I'...
0
votes
2answers
17 views

Add SQL-feature with what Servicepack

I need to add an SQL-feature (SQL-replication) to an existing SQL-instance. It's SQL Server 2012 Standard SP1 that has been upgraded to SP3 a few years ago. What installation media should I use to ...
25
votes
6answers
44k 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?
2
votes
0answers
283 views

Importing data from Informix DB to SQL Server

Configured Informix drivers (32-bit) ODBC on my local machine and trying to import the data to SQL Server using SQL Server IMPORT and export wizard. I selected source tables and views(steps in SQL ...
18
votes
3answers
39k 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 ...
7
votes
1answer
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 ...
5
votes
3answers
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 ...
0
votes
1answer
48 views

How to run SQL server 2012 instead of 2014 when both are installed and 2014 is currently running?

I need to backup a DB using SQL server 2012 to match another server it is going to. However on my local machine I'm currently running 2014. I can see that SQL server 2012 is installed along with ...
0
votes
1answer
24 views

How to keep Active Directory and SQL users from breaking after a database restore?

I'm trying to copy production CRM MSSQL data to another isolated server stack (server 2) via a backup-and-restore process. Server 2 already has most of the data after a restore I did from the ...
0
votes
1answer
950 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 ...
6
votes
4answers
60k 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 (...
0
votes
2answers
39 views

schedule backup job runs up to 9 hrs without errors

I'm very new to administration job... I have SQL server 2012, on that my senior scheduled a job for schedule backup. But, recently I noticed, after 8-May-2018(up to 26-May-2018) the backup files are ...
0
votes
1answer
51 views

Transaction backup job is run event Full and Different job can't run

I'm very new to DBA. I've SQL SERVER 2012. On that, Backup schedule jobs(under Maintenance Plan) runs for Full, Differential and Incremental Backups. The specific DB are selected in SSMS, . ...
-1
votes
1answer
25 views

Sql server 2012 installation error

one of my friends is currently installing Sql server 2012 and she encountered at "shared features" step. At "Shared features" step, normal installation would give user to select Management tool -...
0
votes
2answers
1k views

Install WSUS with remote SQL on port different to default

How do I specify the connection parameter to a remote MSSQL Server during WSUS setup that's default instance is not running on the default port?
0
votes
0answers
661 views

Amazon RDS SQL Server permissions with legacy application

I am trying to run a legacy Windows application in AWS without modifying the code. The application uses Windows Authentication for the DB connection so this is what I have set up: a Simple Directory ...
0
votes
0answers
248 views

How to restart windows server - not just SQL Server after a job completes?

I know. It's a stupid question, or at least a dangerous one, but my supervisors are having to restart DP jobs every time I run a LOG truncation job that reduces the size of our LDF file from what was ...
1
vote
0answers
75 views

Using AlwasyOn Failover Cluster Instance in conjunction of Peer to Peer Transactional Replicaiton

We are deploying two physical sites each with writable/readable access to its local SQL server. Each site has site redundancy and also cross site synchronization is required. My thought is to use the ...
1
vote
0answers
482 views

Sql Server Analysis Services won't start after reboot

Had to restart a server running SQL Server and SQL Server Analysis Services. (The reboot was related to the Hyper-V Host it was running on.) The SQL service works fine, but the SSAS refuses to start. ...
1
vote
1answer
257 views

Restore incorrect syntax near 'dbname'

I'm trying to restore a db to a new location, using the following in SQL Server Management Studio for Server2012: RESTORE [newdb-name] FROM DISK = '..\backupfile.bak' WITH MOVE 'olddb-name.mdf' to '.....
0
votes
0answers
51 views

SQL Server 2012 not reinstalling

I have uninstalled everything from control panel with sql server 2012 It can never get past the first window of installation which has product key, license terms, product updates, install Setup files....
-2
votes
1answer
68 views

Cannot grant server roles to self using local DB SQL Server [closed]

I am not the admin on my work machine. I had SQL Server 2012 installed and I cannot create or import a DB. Under security I tried granting my windows UN 'dbcreator' and do not have permission. I log ...
0
votes
1answer
534 views

Why are SQL Server 2012 tokens are not expanding when used in agent jobs?

I am trying to use tokens in my SQL Server agent jobs as described here, but some of the tokens are not working as I expect. When running an agent job, the tokens which are supposed to expand to ...
1
vote
1answer
547 views

SQL Server slow in guest machine over time (virtualization with KVM on a Centos 7 Host)

We have a new server a HP DL360, 64GB RAM, 2x8 core CPU, SAS HDD Raid1 array and one SSD Raid1 array. The SSD Array is configured with 2 Samsung 850 Pro devices (not HP certified). We installed a ...
1
vote
2answers
7k views

SSRS-error about report server database version after hotfixing SQL. The found version is '164'. The expected version is '163'

After applying hotfix KB3194725 to our SQL server, the SSRS server throws the following exception when trying to generate a report: Exception type: InvalidReportServerDatabaseException ...
4
votes
2answers
10k 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 ...
2
votes
1answer
5k views

5.7.1 SMTP error when running stored proc using DB Mail in SQL Server 2012

I am getting an error in SQL Server 2012 Database Mail when executing a stored proc to send an email from a specified address to a specified address using Office 365 as the SMTP server. The mail ...
-2
votes
1answer
419 views

I need to fully automate sql server restores , PLease help me

I'm New to Sql server and dont have experience in automate restores I need a script to restore a database from a .bak file and move the logical_data and logical_log files to a specific path. I can ...
2
votes
1answer
3k 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 ...

1
2 3 4 5 6