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
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
28 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, ...
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
71 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 ...
0
votes
1answer
45 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 ...
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 ...
3
votes
1answer
613 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 ...
2
votes
0answers
284 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
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
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
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, . ...
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 ...
-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
665 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
249 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
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....
1
vote
0answers
484 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
69 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
420 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
38 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
847 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
552 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
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 ...
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. ...
-1
votes
3answers
6k 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
1k 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
2k 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
122 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
170 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
336 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
108 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
102 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 ...
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 ...
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 ...
1
vote
2answers
10k 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
1k 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
800 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
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 ...
1
vote
0answers
405 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
67 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
35 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
1k 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
535 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
103 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
6k 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
26 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 ...
0
votes
1answer
864 views

SQL Server 2012 Copy Database for Test DB fails

I'm trying to copy a database from our live system to the test system. (same Server, different DB) The Test DB has been deleted in preparation so we have a clean slate. I've tried backing up the DB, ...
0
votes
0answers
424 views

Virtual machine snapshot fails, followed by a hung server

We've had a rather annoying incident yesterday. During a routine snapshot backup, a machine failed with the following error: Backup virtual machine Cannot complete the operation. See the event log ...

1
2 3 4 5 6