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.
271
questions
1
vote
0
answers
266
views
Windows Server 2008 R2 alias or Cname
On one of our client server, Windows Server 2008 R2 is installed. On the same machine, on SQL Server 2012, I am seeing 2 server names MHMSDB01 and user_DB1 are actually same server (IP address.) host ...
- 11
1
vote
0
answers
462
views
Strange error in SQL Server from ASP.NET app
I posted this question on stack overflow, but to no avail. Getting desperate here.
So we have an extremely random error (by which I mean, there appears to be no usage pattern that precedes the error) ...
- 121
10
votes
1
answer
44k
views
Does an SQL Server instance allow both secure and non-secure connections at the same time?
we have an application running MS SQL Server 2012. For one specific use case we'd like to SSL protect the jdbc connection. I've checked the following links:
How to enable SSL encryption for an ...
- 1
0
votes
1
answer
2k
views
MS SQL replication run only with system account
I'm trying to configure a new replication with SQL Server 2012
I configured the distribution
While configuring the publication, it asked for a user to run the snapshot agent. I set a strong user ...
- 30.7k
0
votes
2
answers
613
views
Publish-AXReport Gives Error "Name cannot begin with the ' ' character"
Running the below PowerShell script (i.e. to deploy all SSRS reports for AX) gives an error:
$axdllname = "Microsoft.Dynamics.AX.Framework.Management.dll"
$gacfolder = join-path $env:windir "assembly\...
- 1,312
0
votes
0
answers
248
views
SQL Server Management Studio 2012 DB Backup script
I have SQL Server Management Studio 2012 installed on a VM. We have an active DB (attached to an ASP.Net application whose target Framework is 4.0). What I was looking for is a script to backup a DB ...
- 103
0
votes
1
answer
4k
views
Failing SQL Server Cluster installation, Addnode: Remote registry call failed
I'm adding a node to a SQL Server failover cluster. The installer throws the error "Addnode: Remote registry call failed. Unable to retrieve primary node Filestream settings" when adding node two
...
CommunityBot
- 1
-2
votes
1
answer
60
views
SQL 2012 Integration Services installation
Can you please suggest me the EXE to install SQL integration and Analysis services
I have installed
SQLEXPRADV_x64_ENU.exe, SQLEXPR_x64_ENU.exe from MSDN site.however, I could not find the integration ...
- 18.6k
1
vote
2
answers
12k
views
SQL Server 2012 support for TLS 1.2, 2 downloads, Which One?
If you disable TLS 1.0 and SSL 3.0 for PCI, SQL Server will stop working.
SQL Server 2012 r2 out-of-the-box only supports SSL protocols up to and including TLS 1.0 by default. Unfortunately, PCI has ...
- 111
0
votes
2
answers
854
views
Unable to start SQL server agent automatically
I am working on SQL 2012, I already been set up my SQL server agent in automatic start up mode in windows services as well in SQL config. Even though it was not starting automatically. How can I fix ...
- 32k
0
votes
3
answers
112
views
Changes to data ordering between SQL Server 2000 and 2012
My company recently migrated a .NET 1.1/SQL Server 2000 web application to SQL Server 2012. We've had a couple of support calls relating to unusual behaviour - particularly with stored procedure ...
- 11
0
votes
1
answer
759
views
SQL Server 2012 event ID 18487
Good morning guys. We have a SQL 2012 instance we use to store data on the parts we create. We have software that goes and pulls data out of the PLC on the machine and dumps the data into the SQL ...
0
votes
3
answers
7k
views
SQL 2012 server alias works locally but not remotely
I'm preparing for a server migration and am attempting to redirect a named instance of SQL Server 2012 (DW) to the default instance. There is currently no DW instance on the test server - I'd like to ...
- 11
3
votes
1
answer
5k
views
Unattended installation of MS SQL Server (2008|2012) EXPRESS?
My goal is to install MS SQL Server 2012 R2 Express.
I've downloaded SQLEXPRADV_x64_ENU.exe and used /ACTION=Install /UIMODE=Normal to generate and modify a configuration file. No matter how I fiddle ...
- 1,441
1
vote
2
answers
2k
views
SQL Server express - Management studio installation hangs at native images installation
I've been trying to install SQL server express edition (2014) with management studio and consistently failing to do so because installation stalls at step 'Install_sql_common_core_Cpu64_Action : ...
3
votes
2
answers
706
views
Can I access the failover server on AWS RDS?
I am trying to create a working proof-of-concept in AWS for our web application which suddenly needs to scale out very quickly. Currently it is hosted on a local VMware server and we are migrating to ...
1
vote
1
answer
263
views
I'm getting a warning that disk space on C: is below 5% when it's not
It's a database server running SQL Server 2012 on Windows Server 2012 R2.
C: is the boot/windows drive, but does NOT contain the data (mdf), log (ldf), or temp files (tempdb.mdf) for the database. So ...
- 1,304
4
votes
1
answer
6k
views
Random connection failures between IIS8 and MSSQL 2012 in RackSpace Cloud [closed]
Background
For years I hosted all of my server functionality, including IIS, Apache, MySql, and MSSQL on a single server instance, yikes! As my client base grew this led to persistent SQL Timeouts ...
CommunityBot
- 1
0
votes
1
answer
3k
views
Restoring a differential database file "the backup set holds a backup of a database other than the existing"
I am trying to test restoring a SQL database using a full/differential approach to a different server than it was backed up from. The database is in simple recovery mode as it is a test data warehouse....
- 3,044
4
votes
1
answer
698
views
Best practice for application logging database replacement
Our web apps (30 or so) log application specific stuff to a centralized logging database (Sql Server 2012) with log4net, so the logging database gets huge quickly. Thus we decided to replace it every ...
- 5,941
0
votes
1
answer
47
views
What is Best Practice for migrating SQL 2012 system databases to failover cluster?
What is the best practice for copying system databases when migrating from SQL Server 2012 (no SP) to 2012 SP2 in a Failover Cluster?
Just backup and restore? Or, script out and script in?
- 18.1k
1
vote
1
answer
2k
views
Azure network latency between VM and Cloud Service
We have recently setup a virtual network that consists of one virtual machine (A3) running MSSQL, and one cloud service (Medium) running a web role.
Our web role will connect to the database using ...
- 3,879
1
vote
1
answer
40
views
Why are SQL Backups slower on Server OS?
We are a hardware and software provider to small government agencies, where many offices have just 1-3 computers, with a few others that are bigger having 5-12 workstations. For the small offices we ...
- 151
0
votes
1
answer
126
views
IIS 8 with SSL Fails To Connect to Remote SQL Server
I have recently setup a new testing environment consisting of a load balancer routing HTTPS traffic to a single IIS 8 webserver (more will be added once I work through this issue). The IIS 8 webserver ...
- 13.7k
0
votes
1
answer
390
views
sql web replication ?diag errors
Trying to configure web replication, and running into a number of issues.
When running replisapi.dll?Diag, I receive the following errors:
CLSID_SQLReplErrors FAILED 0x80040154
replrec.dll classes ...
- 165
1
vote
1
answer
9k
views
In SQL Server 2012 Failover Clustering, we are getting "The action 'Move' did not complete. Error Code: 0x80071398"
We have setup 2 VM Nodes for SQL Server 2012 Failover Clustering. The iSCSI drives are on our SAN. Cluster setup and SQL Server 2012 SP2 install succeeded without errors. Connecting to SQL Server from ...
- 31
4
votes
0
answers
2k
views
Local DTC is missing on server 2008r2
I've recently had an issue where MSDTC was unable to start up.
The error in the command line when running net start msdtc indicated that there were configuration issues.
I went into the registry and ...
- 5,617
0
votes
1
answer
89
views
Multiple SQL Standard Instances on 4 Processor/32-core Server
We have a large 4 processor/32-core server with 192GB of memory available in the data center and over twenty small SQL Standard databases to consolidate. They are a mix of SQL 2012 and 2008 R2 for ...
- 18.4k
0
votes
1
answer
796
views
SQL Server 2012 Service not starting (Probably related to Service Agent issue)
I have an application (Dynamics AX 2012) that can't connect to the SQL server. I log onto the SQL server, and open SQL Server Management studio and can't connect to the database engine.
I check the ...
- 111k
2
votes
1
answer
998
views
Manage SQL Agent Jobs On Multiple Servers
Is there a way to deploy/modify/remove//manage SQL Agent Jobs across multiple servers within a domain without third-party software?
CommunityBot
- 1
1
vote
1
answer
1k
views
Latency & SQL Connections over Fiber WAN - Application E-manage
I am hosting an encrypted SQL server database (SQL Server 2012) on a VMware host at my Salt Lake location. My Salt Lake data pipe is 100 Mbps over fiber via Comcast. My Phoenix side has a 50 Mbps over ...
- 111k
0
votes
0
answers
705
views
SQL 2012 AlwaysOn Availability Groups Failover Successfully But Application Complains About Login Failed for User
I am trying to get SQL 2012 AlwaysOn Availability Groups working for an application. The cluster has 2 SQL nodes and 1 witness server.
Everything appears to be failing over successfully when I do ...
- 147
2
votes
1
answer
510
views
Hyper-V Guest data encryption
I have a new requirement to encrypt the data inside an sql database while it is at rest.
So far I've looked at Bitlocker (see below), and other commercial products (I won't name because I'm not ...
- 36.8k
0
votes
1
answer
2k
views
Install SQL Server 2012 to Windows Server 2008
I'm trying to install SQL Server 2012 in Windows Server 2008 R2 Standard Operating System. However this Error keep appearing even though I installed both .NET Framework 3.5.1 and 4.0
The operating ...
- 51.9k
1
vote
2
answers
885
views
Can't connect after NEW Install SQL Server 2012 on Win 7 Pro SP1 with Windows Auth or SQL Server Auth
Trying to install SQL Server 2012 (Eval) to work with the new BI tools using AdventureWorksDW tutorial. Therefore, I feel I've gotten bogged down in SA activities that would be done by others in the ...
- 633
1
vote
1
answer
10k
views
No 'Instance Features' in installation setup of Sql Server 2012
I try to install SQL Server 2012 Express on my personal computer (fresh install of Win 8). I downloaded the installation files on the Microsoft Website. The filename is SQLManagementStudio_x86_ENU.exe ...
0
votes
1
answer
717
views
Does the amount of disks in a RAID10 matter for a Microsoft SQL server in regards of the block size?
We are planning to deploy a Microsoft SQL Server and to store the databases on a RAID10 (RAID1+0) block-level-storage.
Does it matter how many drives altogether I put into the array for optimum ...
CommunityBot
- 1
-1
votes
1
answer
543
views
What are my options to run MS SQL 2012 on Amazon RDS for development if I only have MSDN license? [duplicate]
I want to run MS SQL 2012 SE BYOL on Amazon RDS under my own MSDN license but it looks like MSDN license doesn't allow me to run MS SQL unless I host it on the dedicated hardware
Microsoft Volume ...
- 17.1k
0
votes
1
answer
551
views
Slow merge replication over a WAN link - only downloads
We've been using SQL Server merge replication for a few years to synchronise data between our data centres, but we are now suffering with a big performance issue. This may be because the amount of ...
- 1
4
votes
2
answers
1k
views
How much memory does my SQL need?
I have a VM (SQL database server) that I think has more memory then it needs, however I'm not sure what I can reduce it to because I don't understand exactly what "In use", "Available", "Committed" ...
- 18.1k
2
votes
1
answer
399
views
How to setup user accounts on a secondary server in High Availability?
Working with two Microsoft SQL 2012 servers in Always On High Availability configuration running on Windows Server 2012 R2. Setup works well and failover is almost flawless.
However, the software ...
- 311
4
votes
1
answer
233
views
High Available SQL Server without SAN by using AlwaysOn feature
I have two Microsoft SQL Servers (v 2012) and I want to make them mirror and when one of them goes down the second one will be replaced.
AlwaysOn is a new feature in SQL Server 2012 that is ...
- 18.4k
1
vote
1
answer
14k
views
ADSI Linked Server: Why can I query AD in VBA, but not as a Linked Server?
After all the reading and research I've done, this seems like the most logical place to post this question:
Why can I query Active Directory using VBA, but not a Linked Server in SQL Management ...
- 622
0
votes
2
answers
112
views
Migrate MSSQL 2008R2 to 2012 (new hardware)
Since hardware support for our server ends we are migrating to a new hardware and simultaneously upgrading MSSQL 2008R2 to MSSQL 2012. I searched a little bit and found some guides, but they all ...
CommunityBot
- 1
6
votes
1
answer
13k
views
Will SQL Server 2012 install + run Windows 2003
I can't seem to find any information but can I install SQL Server 2012 Standard Edition on a server running Windows Server 2003 R2 x64?
I don't intend to use this for production just for testing and ...
- 54k
0
votes
1
answer
2k
views
How to attach a database created by sql 2008 to sql 2012 when full text catalog missing? [closed]
I have an already created mdf file which was created by sql server 2008.But when I attach this mdf file to sql server 2012 it asks me to add necessary full text catalogs. I have no idea what to do....
- 18.6k
1
vote
1
answer
2k
views
SQL Server Management Tools available on SQL Server 2012 express?
My goal is to access a server with some cube data and query it. If I understand correctly I need Analysis Services in order to accomplish this.
My Current install of SQL Server Management Studio ...
- 54k
3
votes
1
answer
95
views
What are the downsides of running all SQL Servers under same domain account?
I am running two SQL Servers 2012 (for Always On) under the same domain account and would like to know what are the downsides in doing so. Few articles that I have read prior setting up the servers ...
- 1,102
-2
votes
1
answer
837
views
In MS SQL 2012 Database how to insert a very large table data in chunks
I need to archive large chunks of information in SQL Server 2012 by moving the data to a new table without blocking other users from using the original table. Is the best way to do this using a T-SQL ...
- 54k
0
votes
2
answers
773
views
SQL Server: Upgrade CPU or add a second CPU? [closed]
Currently have a 2 socket server with a single xeon e5-2407 @2.2Ghz running SQL Server 2012. There are no performance issues at the moment but wondering for the future if it would be better to upgrade ...
- 51.9k