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.
270
questions
2
votes
2
answers
4k
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 ...
0
votes
0
answers
25
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 ...
-1
votes
2
answers
169
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.
...
1
vote
1
answer
425
views
How many MSDTC clustered services (if any) are needed for a multiple-instance SQL Server 2012 cluster?
I'm creating a new SQL Server 2012 cluster, running on 2 physical nodes (the O.S. is Windows Server 2012 R2); the cluster will host multiple SQL Server instances; the exact number is yet to be defined,...
0
votes
1
answer
2k
views
Restarting MSSQLSERVER service on the principal or on the mirror the database is set in "In Recovery" mode
I'm running MSSQL Server 11.0.2100 (SQL Server 2012) and every time I restart the MSSQLSERVER service on the principal or on the mirror, the database mirror breaks and the database is set into In ...
2
votes
1
answer
4k
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 ...
6
votes
4
answers
68k
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 (...
2
votes
2
answers
3k
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# ...
0
votes
1
answer
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 # ...
1
vote
1
answer
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\...
0
votes
1
answer
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
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 ...
1
vote
3
answers
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 ...
0
votes
2
answers
906
views
Sql Express 2012 Upgrade to SP1
I have Sql Server Express 2012 installed on one server. As I'm trying to install TFS 2015 and it require Sql Express 2012 with SP1 I would like just to update my instance to SP1, but I can't find a ...
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. ...
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 ...
1
vote
2
answers
2k
views
How do I resolve the message "Validating WSFC quorum vote configuration - Action Required."
I have a 3 node AlwaysOn Availability Group on a 3 node WSFC using node majority. 2 nodes are setup as synchronous with automatic fail-over, the 3rd is setup as asynchronous with manual fail-over. ...
21
votes
3
answers
74k
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 ...
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 ...
1
vote
0
answers
91
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 ...
3
votes
2
answers
8k
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
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, ...
0
votes
0
answers
147
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 ...
2
votes
2
answers
2k
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
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 ...
0
votes
1
answer
8k
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
3
answers
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
1
answer
135
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
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 ...
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 ...
2
votes
1
answer
2k
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
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 ...
27
votes
5
answers
50k
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
0
answers
536
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 ...
7
votes
1
answer
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
3
answers
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
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 ...
0
votes
1
answer
74
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
1
answer
1k
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 ...
0
votes
2
answers
52
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
1
answer
81
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
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 -...
0
votes
2
answers
2k
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
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 ...
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 ...
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.
...
1
vote
1
answer
333
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
0
answers
62
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
1
answer
138
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
1
answer
624
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 ...