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
0 answers
23 views

Website hung issue IIS server after use at the time multi users ASP.NET Appplication

I need a solution for load balancing within a single website, in which multiple users can simultaneously do this and that within a single website and send multiple clicks, multiple hits, multiple HTTP ...
Ashish Rathod's user avatar
-1 votes
2 answers
140 views

SQL is not showing up when trying to connect to it via odbc from a client computer after migrating database to a new server

I installed SQL 2012 on a new Server 2022 vm and restored a database on the new server from a SQL generated backup. The new SQLserver/instance is not showing up in the Odbc client on a windows client. ...
Mark's user avatar
  • 79
1 vote
0 answers
89 views

SQL Express 2012 - Unable to select "Force Encryption" option in SQL Configuration Manager 11

Sorry if this is a completely stupid question, but I don't know where else to look. I'm not seeing any options under the "Force Encryption" for my SQL Express 2012 instance. Here's a ...
Blaine Lafreniere's user avatar
2 votes
1 answer
1k views

Issue installing a SQL Security Update on Windows Server 2012 R2

We're having a weird issue with the "Security Update for SQL Server 2012 Service Pack 4 CU (KB4583465)" update on one of our servers. It will show as installing successfully, but then after ...
Harrison's user avatar
0 votes
0 answers
191 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, ...
Vesper's user avatar
  • 804
0 votes
0 answers
145 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 ...
Kunal Basu's user avatar
0 votes
1 answer
133 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 ...
Gayatri Gokhale's user avatar
0 votes
2 answers
22 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 ...
Andreas's user avatar
  • 309
3 votes
1 answer
1k 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 ...
ACummins's user avatar
2 votes
0 answers
531 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 ...
aditya y's user avatar
0 votes
1 answer
73 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 ...
Cohaven's user avatar
  • 51
0 votes
1 answer
99 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 ...
Rob's user avatar
  • 31
0 votes
1 answer
80 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, . ...
Pugal's user avatar
  • 103
0 votes
2 answers
51 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 ...
Pugal's user avatar
  • 103
-1 votes
1 answer
29 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 -...
Kyaw Zin Thant's user avatar
0 votes
0 answers
1k 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 ...
macbutch's user avatar
  • 141
0 votes
1 answer
525 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 ...
Fandango68's user avatar
1 vote
0 answers
97 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 ...
MidTierDeveloper's user avatar
1 vote
1 answer
331 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 '.....
whybull's user avatar
  • 13
0 votes
0 answers
61 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....
BobTheCat's user avatar
1 vote
0 answers
1k 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. ...
Andreas's user avatar
  • 309
-2 votes
1 answer
137 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 ...
Chris's user avatar
  • 103
-2 votes
1 answer
448 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 ...
DBA_Fresher's user avatar
1 vote
1 answer
60 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 ...
kevcri's user avatar
  • 11
0 votes
1 answer
1k 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 ...
SPottuit's user avatar
  • 111
1 vote
1 answer
1k 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 ...
Enovator's user avatar
2 votes
1 answer
2k 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 ...
nam's user avatar
  • 217
7 votes
1 answer
40k 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. ...
Tom A's user avatar
  • 218
-1 votes
3 answers
8k 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 ...
Ted Mittelstaedt's user avatar
0 votes
2 answers
2k 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 ...
marafado88's user avatar
0 votes
1 answer
3k 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,...
Root Loop's user avatar
  • 912
0 votes
1 answer
214 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 ...
Matt Bear's user avatar
  • 874
1 vote
1 answer
243 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 ...
trueCamelType's user avatar
1 vote
0 answers
619 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 ...
Nerdrave87's user avatar
0 votes
1 answer
258 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 ...
Tim's user avatar
  • 213
0 votes
2 answers
111 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 ...
Rohit Tarang's user avatar
1 vote
2 answers
9k 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 ...
Henrik H's user avatar
  • 111
1 vote
1 answer
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 ...
tsmr's user avatar
  • 11
1 vote
2 answers
14k 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" ...
user2629636's user avatar
0 votes
0 answers
2k 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 ...
Bob Pusateri's user avatar
1 vote
2 answers
1k 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 ...
htm11h's user avatar
  • 170
2 votes
1 answer
4k 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 ...
Damian's user avatar
  • 21
1 vote
0 answers
654 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. ...
Arif's user avatar
  • 11
-1 votes
1 answer
75 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 ...
Mr. Ali's user avatar
  • 45
1 vote
1 answer
41 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 ...
makerofthings7's user avatar
0 votes
1 answer
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 ...
SysAdminUK's user avatar
0 votes
1 answer
623 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 ...
barbecue's user avatar
  • 362
0 votes
1 answer
152 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 ...
Stephen Jesse's user avatar
1 vote
1 answer
8k 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 ...
Jake's user avatar
  • 111
0 votes
1 answer
37 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 ...
HorusKol's user avatar
  • 781

1
2 3 4 5 6