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.
268
questions
1
vote
0
answers
41
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 ...
2
votes
1
answer
860
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 ...
- 23
0
votes
0
answers
133
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, ...
- 774
0
votes
0
answers
120
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
1
answer
95
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 ...
- 101
0
votes
2
answers
20
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 ...
- 299
3
votes
1
answer
971
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 ...
- 33
2
votes
0
answers
403
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 ...
- 21
0
votes
1
answer
47
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 ...
- 51
0
votes
1
answer
64
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 ...
- 31
0
votes
1
answer
69
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,
.
...
- 103
0
votes
2
answers
47
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 ...
- 103
-1
votes
1
answer
27
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
0
answers
982
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 ...
- 141
0
votes
1
answer
418
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 ...
- 103
1
vote
0
answers
84
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
1
answer
302
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 '.....
- 13
0
votes
0
answers
60
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
0
answers
877
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.
...
- 299
-2
votes
1
answer
113
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 ...
- 103
-2
votes
1
answer
441
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
1
answer
46
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 ...
- 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 ...
- 111
1
vote
1
answer
923
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 ...
- 31
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 ...
- 217
7
votes
1
answer
39k
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. ...
- 218
-1
votes
3
answers
7k
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 ...
- 101
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 ...
- 412
0
votes
1
answer
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,...
- 902
0
votes
1
answer
156
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 ...
- 874
1
vote
1
answer
216
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,076
1
vote
0
answers
564
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 ...
- 11
0
votes
1
answer
186
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 ...
- 111
0
votes
2
answers
106
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
2
answers
8k
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
...
- 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 ...
- 11
1
vote
2
answers
12k
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" ...
- 762
0
votes
0
answers
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 ...
- 121
1
vote
2
answers
931
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 ...
- 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 ...
- 21
1
vote
0
answers
569
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. ...
- 11
-1
votes
1
answer
73
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 ...
- 35
1
vote
1
answer
38
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 ...
- 8,871
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 ...
- 113
0
votes
1
answer
593
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 ...
- 342
0
votes
1
answer
126
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
1
answer
7k
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 ...
- 111
0
votes
1
answer
29
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 ...
- 741
0
votes
1
answer
1k
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, ...
- 113
0
votes
0
answers
519
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 ...
- 5,587