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, ...

learn more… | top users | synonyms

-1
votes
2answers
160 views

SQL 2012 Server Database Transaction Replication performance issue [duplicate]

We have configured SQL 2012 Server Database Transaction Replication for our client's .NET Web application to distribute SQL transaction and reporting on different SQL servers. We had implemented ...
2
votes
1answer
3k views

Windows Installer runs constantly in the background on Windows Server 2012?

While trying to install a program, it complained that something else was being installed and that Windows Installer was already running (msiexec.exe). Sure enough, there were two instances of the ...
0
votes
1answer
510 views

SQL Server 2008 side-by-side with SQL Server 2012, possible issues with SAP Business One 8.81 PL:07?

We have a Windows Server 2008 R2 Enterprise system running SQL Server 2008 Enterprise (x64) version 10.0.4067.0 and SAP Business One 8.81 PL:07. We would like to install a named instance of SQL Server ...
0
votes
1answer
57 views

Configuring SQL Server 2012 instance to have multiple instance names

I just installed SQL Server 2012 Standard Edition and set up a new default instance. Is there a way to "forward" connections from the old .\sqlexpress to the new default instance? Or do I need to hunt ...
1
vote
1answer
1k views

SQL Server: Cannot log into SQL Server Management Studio on Server

I installed SQL Server 2012 on a Windows Server 2012. I am going back a few days later and unable to log into SQL Server Management Studio (SMS) using Windows Authentication, even if I launch SMS ...
-1
votes
1answer
1k views

SQL Server 2012 - No connection could be made because the target machine actively refused it

I've searched for the solution for this problem for days now, found a lot of stuff but none of it worked. I've got an SQL Server 2012 running on Windows Server 2012. I'm trying to connect to the SQL ...
2
votes
0answers
29 views

SQL Server 2012 database availability design?

Can anyone please suggest me what is the best practice for me to follow when consolidating multiple stand alone DB from SQL Server 2005 - 2008 boxes into just 2x SQL Server 2012 Enterprise nodes in ...
1
vote
2answers
221 views

Benefit of extra memory in server hardware beyond what SQL Server can use?

My previous related question was flagged as "Not Constructive", because I asked to compare SQL Server & Oracle. So this time I will ask only about SQL-Server. My company has built an ...
3
votes
1answer
321 views

How can I set up a SQL file share that doesn't need sysadmin access to write to it?

We have a SQL Server 2012 installation with the file share feature enabled. We then have an IIS application that can write directly to the \localhost\MSSQLServer... share that the database creates. ...
2
votes
1answer
253 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 ...
1
vote
0answers
540 views

SQL Server Service refusing to start

Have attempted a number of things to get this service (SQL Server (MSSQLSERVER)) started without any luck Attempted to start service with local admin, domain admin, separate admin & standard ...
1
vote
1answer
760 views

SQL Command Line Setup Failing

When running SQLEXPRADV_x64_ENU.exe directly SQL Installation Center shows up and I can install SQLEXPRESS just fine. I want to perform automatic command line install so I have done the ...
-2
votes
2answers
81 views

Is it Safe to Install SQL Server 2012 on a machine which have SQL Server 2008 R2 running?

I am using SQL Server 2008 R2 quite a while. It is working great. Now I need to use SQL Server 2012. Will this effect my existing database. How much Risk involved in installing SQL Server 2012 on a ...
3
votes
4answers
15k 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 ...
0
votes
2answers
2k views

Unable to connect to SQL Server 2012 Enterprise local instance

Just installed SQL Server 2012 Enterprise on my work machine, and I'm unable to connect to my local instance (MSSQLSERVER). I get the "Login failed..." message. I enabled the SQL Server Browser ...
1
vote
1answer
335 views

How can I evaluate SQLServer 2012 Standard Edition

"Enterprise Evaluation Edition (64-bit)" was installed on my server by the hosting provider. I'd like to downgrade to "Standard Evaluation Edition (64-bit)". Does this even exist?
0
votes
1answer
2k views

SQL Server 2012 Evaluation has stopped working: is that expiration behavior? [duplicate]

We placed an order for physical media and CALs when the evaluation expired last week. SSMS said the evaluation had expired, and it would not connect to the database. The package with the CALs has not ...
0
votes
1answer
766 views

Get permissions in fixed or user-defined server roles in SQL Server 2012

I'd like to know how to get a list of permissions that belong to fixed and/or user-defined server roles in SQL Server 2012. In previous versions there was an sproc sp_srvrolepermission but this is ...
0
votes
2answers
908 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 ...
5
votes
3answers
3k views

SQL Server Collation settings for System Center Service Manager 2012

There is a lot of conflicting or confusing information surrounding the required collation settings for SQL Server, as it pertains to hosting the SCSM 2012 database and associated data warehouse ...
0
votes
1answer
219 views

AlwaysOn Automatic Failover Using Two Nodes with SQL Standalone Instances

We are building a new SQL 2012 cluster for our web environment. We decided to use two nodes and utilize AlwaysOn Availability Groups for High Availability. Server01 and Server02 have had a Standalone ...
0
votes
1answer
736 views

Migrating data from SQLEXPRESS local DB to SQL Azure

I have a process that is importing data from CSV files to a local SQL Express DB, then I can use the SQL Server 2012 migration tool to migrate the database to SQL Azure (as described in ...
1
vote
3answers
665 views

How to run PHP + IIS8 as Windows User, or should I?

I am creating a PHP website on IIS8 that needs to connect to an SQL Server that is in the same Windows Domain as the IIS8. I am given a Windows Domain user account and asked to connect using its ...
5
votes
1answer
2k views

Re configure TFS 2012 reporting services

I have a TFS 2012 installation that is working perfectly. I've installed TFS using advanced configuration and choose to not configure at that moment the Reporting and Sharepoint features. Now, I ...
1
vote
1answer
824 views

Cannot reach SQLServer after join domain

I'm configuring TFS 2012 in advanced mode, that means that Sql Server is on another machine. When I need to specify the database server (in the TFS Configuration) it fails because the SqlServer host ...
1
vote
1answer
3k views

“CREATE DATABASE permission denied in database 'master'” to sysadmin user in SQL Server Express 2012

I'm seeing some odd behaviour with SQL Server 2012 Express Edition, where a sysadmin user does not have permission to create databases. The evolution of this installation has been somewhat trying: ...
0
votes
0answers
37 views

Allow VM2 access VM1's SQL Server Database

I have two VMs running on a Mac Server using VM Fusion 4. Both VMs are running windows 7, and I have SQL Server 2012 installed and data imported into VM1. Right now, I'm trying to figure out a way to ...
0
votes
0answers
376 views

Getting “error: 26 - Error Locating Server/Instance Specified” all of a sudden

Alright, a little explanation. I have two separate PCs, both of which have virtually an identical installation of SQL Server 2012 Express on them. During installation for both, I had chosen the ...
3
votes
2answers
758 views

Dealing with Stretch (Geo) Cluster Node Failures

Scenario: Three node (shared nothing) cluster on Windows Server 2012. Two nodes in the primary data center, both with votes (node weight = 1), and a file share witness. The third node is in a remote ...
2
votes
2answers
4k views

MS SQL Server 2012 - Unable to access Instance on localhost

5 days ago I was access able to access SQL Server on my localhost machine via SSMS perfectly, no errors logging in with credentials. Now I get this error: ...
1
vote
1answer
966 views

How do I grant IIS APPPOOL\Orchard access to SQL Server 2012 Developer?

When I tried to install Orchard CMS to it's own web site, IIS create a web pool called Orchard. After supplying a connection string of Data Source=(local);Initial Catalog=Orchard;Integrated ...
0
votes
0answers
209 views

Failure running SQL2012 on Windows 8 with local service accounts

I have installed SQL2012 on a Windows 8 laptop that is on a domain. The domain includes a group policy that defines accounts that can "Log on as a service". I installed SQL Server 2012 using the ...
0
votes
1answer
331 views

SQL Server 2012 Multiple Instance Priority

I'm in the process of upgrading our small SQL databases to SQL Server 2012. We have at least 3 instances, (1) Critical work databases, (2) low-importance System Maintenance databases, (3) WSUS. Can I ...
6
votes
0answers
260 views

SQL server language media doesn't support the language of the OS [duplicate]

While trying to install SQL server 2012, I get the error: "SQL server language media doesn't support the language of the OS" I've downloaded the SQL server 2012 in English language only (2 times to ...
0
votes
1answer
337 views

LINQPad and SQL2012 management studio cannot talk to network Database Servers (SQL2008R2)

I installed LinQPad 4.0 on my machine. LinQPad can talk to local database servers on my machine, but cannot communicate or add a connection to network database servers on the network. SQL2008 ...
0
votes
1answer
698 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
1answer
2k views

Restore transaction log backup - media family error

Our backup procedure is as follows: midnight full backup, every 8 hour differential backups, and every 5 minutes transaction log backups. Maintenance plans keep everything rolling and tidy. To ...
2
votes
2answers
3k views

AWS RDS (SQL Server): SSL Connection - The target principal name is incorrect

I have a Amazon Web Services (AWS) Relational Database Service (RDS) instance running SQL Server 2012 Express. I've installed Amazon's aws.amazon.com/rds certificate in the client machine's Trusted ...
1
vote
5answers
501 views

Accessing SQL with the PC name not the IP

I'm trying to connect to a SQL instance (default instance) on a machine. When using the IP of the machine it connects to the machine. Using the name of the machine on that machine you are able to ...
2
votes
1answer
3k views

SQL Server 2012 Installation Hangs

We have a Windows 8 machine that we installed SQL Server 2005 on first. We then uninstalled it and installed SQL Server 2012 - unsuccessfully. The installation wizard hung at the point where it ...
0
votes
1answer
63 views

DB access account for SharePoint 2013

I am installing SharePoint Server 2013 on Windows Server 2008 R2 SP1 with SQL 2012 on a VMware. During the SharePoint Configuration Wizard, I need to provide a DB access account. The VM is not part ...
1
vote
2answers
2k views

SQL 2012 operating system requirements

I am trying to install SQL server 2012 on a VMware with Microsoft Server 2008 R2. But it gives me an Error indicating your operating system does not meet the minimum requirement for SQL server 2012. ...
1
vote
1answer
834 views

How to unlock sa user in SQL Server 2012 if Windows Authentication doesn't work?

I am logged in as an admin on the computer. For some reason I can't log into SQL Server 2012 which is running on the same machine. The SA user is locked out. SQL Server was installed when I was logged ...
0
votes
3answers
584 views

Can I use SQL-Server on Windows Server 2008 R2 core?

Is it possible to run SQL-Server 2008R2 or 2012 on Windows Server 2008 R2 Core installation. There are three questions to answer: Does the license allow this? Can I install and operate it? Is it ...
-1
votes
1answer
195 views

SQL Server 2012 memory usage steadily growing

I am very worried about the SQL Server 2012 Express instance on which my database is running: the SQL Server process memory usage is growing steadily (1.5GB after only 2 days working). The database is ...
1
vote
0answers
45 views

SQL Server 2012 : Installing on D:

i am trying to install SQL Server 2012 i choose D: for everything but still it told me during installation itself that it's going to install config file on C: following is the path C:\Program ...
3
votes
1answer
6k views

SQL Server express service is not starting [closed]

I've bought my first VPS yesterday, and I have installed Microsoft SQL Server 2012 Express on it. Then I have restarted my VPS. But SQL Server Service didn't start. I've tried to start it manually, ...
6
votes
1answer
1k views

Very uneven CPU utilization with SQL Server 2012 on 2 processor computer with 16 cores / processor

After installing SQL Server Enterprise 2012 with the Server + Cal license model, on a computer with 2 processors each with 16 cores (and no hyperthreading involved) and putting the server under ...
1
vote
1answer
975 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 ...
1
vote
1answer
129 views

database size limit in SQL Server 2012 Express Edition

I want to use SQL Server 2012 Express Edition. Does someone know the maximum file size limitation of the database?