Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

0
votes
2answers
13 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 ...
0
votes
0answers
9 views

Find time intervals excluding overlapping time

In our scenario, Production time is always includes downtimes if there is a downtime (internal and other), idea is calculate exact production time, excluding the downtimes. Problem here is, internal ...
3
votes
1answer
54 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
0answers
124 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 ...
0
votes
0answers
43 views

Where could a SQL Server shrink operation be hiding?

I've started using the Blitz scripts from BrentOzar.com to help me improve the SQL server instances that I manage. One of the message lines has me stumped. The message is to the effect of 'SQL ...
0
votes
0answers
73 views

SQL server named instance connection

On several occasions I have observed a intermittent connection failure to SQL server (2012) resulting in the following stacktrace System.Data.SqlClient.SqlException (0x80131904): A network-related or ...
0
votes
1answer
17 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
45 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
0answers
54 views

SQL Server 2012 Express SysPrep

I have a very basic question and I feel stupid for not understanding all the materials I've read but I cant find a clear yes or no answer anywhere. Thank you in advance. It's regarding SQL Server ...
0
votes
1answer
45 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, . ...
0
votes
2answers
35 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
0answers
38 views

Using SSL for Report Server - SSL used already by web application

I am configuring our SQL Server Reporting Services to make use of SSL, to be installed into it. However, I encountered difficulties with this. I've searched for this kind of scenario but no useful ...
-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
0answers
198 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
66 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
54 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 ...
0
votes
0answers
16 views

perfmon schedules following DST change

I'm having a problem with schedules created as part of a Data Collector Set in perfmon. I set up schedules for perfmon to run some way in advance. When the clocks went back in November, an issue ...
1
vote
1answer
74 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
40 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....
1
vote
0answers
256 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. ...
-2
votes
1answer
40 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 ...
-2
votes
1answer
277 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 ...
1
vote
1answer
28 views

Windows 2012 Server inaccessible (using rdp) but SQL Server databases are accessible (ssms)

We have a Windows Server 2012 Standard, which runs SQL Server 2012 Enterprise edition. This morning we found the reporting services was inaccessible. We attempted to use Remote Desktop to connect to ...
0
votes
1answer
386 views

sql server 2012 service not running

When starting my VM with windows server 2012 R2 which is my SQL-server, I get the following error: My SQL-server service won't run if I start it or if it gets started automaticly. What I have done ...
1
vote
1answer
260 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 ...
2
votes
1answer
561 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 ...
4
votes
1answer
7k 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. ...
-1
votes
3answers
3k views

How do I move an entire SQL instance for SQL Server 2012 to a different server?

I tried this with SQL Server 2012, no joy: How can I copy a SQL Server 2008 instance to another server? SQL would not start on the target server it first complained about not being able to write to ...
0
votes
2answers
796 views

Not sending mail job notifications

I have a job created to do a backup of all my dbs with a schedule time and I have set to this job a notification by mail to my email when the job completes, but I am not receiving any. So I will post ...
0
votes
1answer
799 views

SQL server authentication is grayed out when connecting to integration services

Why SQL server authentication is only available for connecting to Database Engine but grayed out for rest of all services, AS, RS and IS? I am on SQL Server 2012. How can I enable the sa login to AS,...
0
votes
1answer
77 views

Unable to login to stand alone SSRS 2012 from domain joined computers

We have a non-domain joined SQL 2012 server running in Azure supporting several web sites, earlier this week an issue popped up where domain joined computers could not log in. There were no updates or ...
1
vote
1answer
132 views

Hyper-V Host, with Windows SQL Server 2012, Boot Failed

This question has been asked plenty, but none of them resolve the issue for me. I have a hypervisor (Hyper-V 2012). When I go to add a new VM from this .iso, which is the Microsoft SQL Server 2012 ...
1
vote
0answers
131 views

For SQL server with one User CAL, can one user be logged in concurrently from multiple devices?

So basically our client had no idea what they were doing when licensing SQL Server, and ended up only purchasing one User CAL. What I'm wondering is, can that same User CAL be used across multiple ...
0
votes
1answer
65 views

default service account for maintenance plan backups on SQL Server 2012

What is the default service account used for backups created with the Maintenance Plan Wizard? I am trying to put the backup files on a share on a different server, and that service account will ...
0
votes
2answers
101 views

Server 2008 R2 Replication Small Issue

I have two 2008 R2 Servers. When I Connect those two Servers By Name, I Can Use Replication. But When I Connect This Two Servers By IP Address, I Can't Use Replication. I Get Error Like: SQL ...
0
votes
0answers
37 views

How to use SQL Agent to schedule a recurring process to run as a singleton

Is there a way to set up a recurring process to run only if an instance of it is not already running? (one that doesn't require me to set my own semaphores). Is there a way to query the system to ...
0
votes
2answers
5k 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 ...
0
votes
1answer
851 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 ...
1
vote
2answers
6k views

SQL 2012 Transaction Log backup does not truncate the logs

I'm a beginner in DB administration so bear with me. I have a small DB 500MB with a very large transaction log (19GB). I'd like to keep this in "Full Recovery" mode, so please do not suggest "Simple" ...
0
votes
0answers
674 views

Trying to determine cause of cluster failover

SQL Server 2012 running on a Windows 2012 Failover Cluster Instance. (**The cluster contains only a single node. Yes, I know that's terrible. No, it wasn't my decision....) The issue is that at ...
1
vote
2answers
625 views

Issue installing SQL SERVER EXPR 2012/2016 on Server 2012 R2

I have been running SQL SERVER Express 2008 on Server 2012 R2 for some time. I recently began researching the migration process to move to SQL SERVER EPXRESS 2016. Because the original DB was migrated ...
2
votes
1answer
2k 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 ...
1
vote
0answers
201 views

[SQL Server Native Client 11.0]Unable to complete login process due to delay

We have one SQL Server 2012 Fail-over cluster instance where 11 database is running. Application is installed in different server. Application connects from application server to database server. ...
-1
votes
1answer
57 views

WSUS refuse to install

Dears.. I hope you are doing well.. I am facing issue with WSUS. Actually, It was working fine and works with SCCM until an issue appears. So, I decided to reinstall WSUS, but I faced another ...
1
vote
1answer
34 views

How can I isolate data-warehouse workloads from production/on-demand queries?

I'm using VMware's vSphere 6 and I'm considering consolidating several SQL servers, these servers have different usage profiles; On-demand burst reporting (Cognos/Data-warehouse) Interactive web ...
0
votes
1answer
943 views

SQL 2012 Restore Issue - Exclusive Access cannot be obtained

Situation - We have a Live_db database, and a Test_db database. I'm trying to Take a copy of Live to use as Test. A Backup of Live was taken. The existing Test database was deleted (closing ...
0
votes
1answer
469 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 ...
0
votes
1answer
92 views

Vmware Site Recovery Manager Bubble network with SQL Server

We are trying to test an application that uses sql server 2012 in a bubble network with vmware site recovery manager. This means when we test the replication the servers are on a vlan that can't ...
1
vote
1answer
4k views

How do I configure the Windows Firewall to allow specific computers to connect to a SQL Server Instance?

I'm trying to allow only specific computers on my domain to connect to a SQL Server instance but I appear to be inadvertently blocking all computers from connecting. When I go in to configure the ...
0
votes
1answer
23 views

Why is SSIS reading so much data from my hard drive?

We're running SQL Server 2012 on Windows Server 2008 R2 for a our CRM and ERP services. Unfortunately, the majority of the setup was outsourced to an "expert" company who neglected to provide any ...