Questions tagged [sql-server-2012]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
3k views

SQL Server Job - Login failed for user

I am trying to run a SQL Server job nightly, but I am getting an error. executed as user: NT SERVICE\SQLSERVERAGENT. Login failed for user 'SERVER\INSTANCE$'. [SQLSTATE 28000](Error 18456) The job is ...
Peter Sun's user avatar
  • 199
-2 votes
1 answer
606 views

installing sql server management studio 2017

i want to install ssms2017 but it get error code 0x800b0003 here is the log file [3744:1E78][2019-10-27T16:43:04]e310: Failed to verify payload: HelpViewer2_3 at path: C:\ProgramData\Package Cache\....
Ali's user avatar
  • 1
2 votes
1 answer
437 views

SQL Server 2012 Setup Failure

I am installing SQL Server 2012 in my computer but this error message always shows up. I tried installing it in a Virtual Machine, and it worked! Other threads says that the issue is permission access,...
Jmarco29's user avatar
0 votes
1 answer
384 views

Removing cluster node from always on cluster

I have an alwaysOn configuration for SqlServer 2012 that is installed in two node windows cluster. We had a disk failure on the second node, and there is no way to recover it, so I should run a new ...
user1018847's user avatar
0 votes
0 answers
185 views

SQL Server 2012 Job Seemingly not running at all, manual or scheduled, no logs

We recently installed a side-by-side instance of SQL Server 2017 on our DEV environment, and almost all of our DBs and jobs have migrated over. However due to compatibility issue, we still have a ...
Andrew83's user avatar
0 votes
1 answer
776 views

Accessing the database is very slow from a hosted website and fast when accessed from localhost

We've been having a problem which seems to have just sprung out of nowhere. We have a NopCommerce website which our client has hosted off his own server. We have 1 web server which has Windows 2008R2 ...
Madhav Shenoy's user avatar
0 votes
0 answers
169 views

SQL Server 2012: Create audit failed (user permission)

I am logged in SQL Server 2012 as db_owner user, I am trying to create an Audit but I receive this error: User does not have permission to perform this action What kind of permission does the ...
aggicd's user avatar
  • 101
1 vote
1 answer
5k views

How to change edition of SQL 2012 from express to standard

I have a Windows Server 2012 R2 Standard that is running SQL 2012 Express. How do I go about changing it to be SQL 2012 Standard? I have the media (and ISO image) and it is currently mounted. I ...
Mike's user avatar
  • 159
1 vote
2 answers
5k views

Net stop <service> system error 5 access denied

From SQL server 2012 I try to do this: DECLARE @COMMAND nvarchar(4000) SET @COMMAND = 'net stop <servicename>' exec master.dbo.xp_cmdshell @COMMAND I get system error 5 and Access denied as ...
Sjef's user avatar
  • 11
3 votes
2 answers
9k views

Elegent way to set variables in .ini files

I'm currently trying to script the installation of Microsoft Sql Server 2012, and I've run into a problem with letting the user set options for the installation process in my powershell script ...
comp.sci.intern's user avatar
5 votes
2 answers
10k views

SQL Server Management Studio CPU and RAM usage keeps increasing for no reason

I have a weird problem with SQL Server Management Studio, version 11.0.2100.60. When I was writing some query, sometimes the CPU gets hogged, and RAM usage keeps increasing. Usually closing and ...
rcs's user avatar
  • 901
0 votes
1 answer
82 views

Windows / SQL Server upgrade

We are currently using Windows server 2008 R2 OS and SQL SERVER 2008 R2 and asp.net 3.5. Now we are planning to upgrade to Windows server 2012 OS and SQL SERVER 2012. Windows server 2012 is comes with ...
Venkat Krishna's user avatar
2 votes
0 answers
558 views

SQL Server Express no longer starts up automatically

I had SQL Server 2008 Express (SP1) on Windows 7 Pro and it was working fine. After upgrading to Windows 10, SQL Server 2008 Express was still working normally. However, after the last Windows update (...
Peter's user avatar
  • 509
1 vote
1 answer
546 views

How to schedule a recurring SQL Server 2012 DB backup using sqlcmd ?

I'm looking for a way to create a monthly recurring backup of a SQL server database using sqlcmd. I've seen scripts for SQL Express, but they only execute once. I'm looking for a sql script that will ...
garym's user avatar
  • 201
0 votes
1 answer
682 views

Prevent Help Make Microsoft SQL Server 2012 Better message

When starting Microsoft SQL Server, I get this message: Help Make Microsoft SQL Server 2012 Better How can I prevent this from showing?
Al Lelopath's user avatar
13 votes
2 answers
19k views

Results view does not change with zoom feature in SQL Server Management Studio

The zoom feature in SQL Server Management Studio is not changing the results window. I have come across many posts that say the zoom controls both the query window and the results window. What do I ...
Matt Slavicek's user avatar
1 vote
1 answer
824 views

How to debug unattended installation of MS SQL Server 2012?

How can I diagnose and debug a configuration file for an unattended installation of MS SQL Server 2012? What I'm doing -- I'm building an installer for a product. The product requires MS SQL Server ...
KlaymenDK's user avatar
  • 1,419
0 votes
1 answer
2k views

Upgraded to windows 10 and now can't connect to sql server 2012

I upgraded to Windows 10 on my laptop. I have opened SQL Server Management Studio, but it can't connect to the server. I have looked at a few other questions, but nothing seems to work. I get the ...
mHelpMe's user avatar
  • 135
1 vote
1 answer
48 views

Copy columns between tables in different servers

Recently I moved to SQL Server 2012 from SQL Server 2005. Current scenario worked without any problem in SQL Server 2005. 1)Connect to server A 2)Open table X 3)Copy 3 columns(Clicking on ...
mybirthname's user avatar
1 vote
0 answers
206 views

How do I connect a SQL Server synonym to an Excel data model?

I have a SQL Server (12.0.411) database with a view that is referenced by a synonym. I want to load the data from the view into Excel's data model using the synonym. In Excel (Microsoft Office ...
Richard A's user avatar
  • 111
4 votes
3 answers
35k views

SQL Server not working after upgrading windows 10 from windows 8.1

My Sql server 2012 has stopped working and now its not letting me login. Here is the error: https://drive.google.com/file/d/0ByGXmosQgHUqdGw4alFSb3otVkk/view?usp=sharing TITLE: Connect to Server ...
Vikas Bansal's user avatar
1 vote
0 answers
149 views

SSMS2012 Help going to Chrome rather than MSIE

Running Win7 Ent 64bit From within SSMS 2012 SP2, when I hit F1 (or Help, View Help), I am taken to Google Chrome rather than MSIE11. By every indication I can find, MSIE11 is my default browser, not ...
Kennah's user avatar
  • 126
0 votes
0 answers
44 views

SQL Server 2012 change query result position [duplicate]

Traditionally in SQL Server while executing a query the result is displayed below the query dividing the screen horizontally. Is there any settings that can be done to displays the result to the side ...
RandomUser's user avatar
1 vote
0 answers
236 views

Cannot install SQL Server 2012

I'm trying to install SQL Server 2012 and got this message: SQL Server Setup has encountered the following error: The resource 'Microsoft.SQL.Chainer.PackageData.Package.xml' failed to load from 'E:\...
blueseal's user avatar
  • 117
2 votes
1 answer
3k views

How to find out MS SQL Server Enterprise Edition Expiration Date?

I have MS SQL Server Enterprise 64bit Install on VMplayer, Version: 11.0.3128.0 Product LVL: SP1 Upon installed, there is no documents indicates how long this license will last. Anyone can ...
shadow master's user avatar
1 vote
0 answers
763 views

SSMS and SSDT requires administrator

I connect to a client's Server (Server 2012R2) via RDP. I always get the UAC prompt when I start the SQL tools, managemant studio (SSMS) and data tools (SSDT). If I press cancel in the UAC dialog the ...
adrianm's user avatar
  • 295
2 votes
1 answer
972 views

Freshly installed wiki still shows red links for pages that have been created?

I just set up MediaWiki for a test run on my laptop. Windows 7, PHP 5.4, SQL Server 2012 SP2, IIS 7, MediaWiki 1.23.6. The installation went smoothly once I got everything in order and I can create ...
Corey Ogburn's user avatar
0 votes
2 answers
229 views

Sql Server 2012 Merge Replication Report

We have about 30 users with local installs of SQL Server that have to replicate merge their local data once a month with a central SQL Server 2012 repository. Is there a SQL Server first-party or ...
Eoin Connolly's user avatar
1 vote
1 answer
804 views

Missing arguments in SQL 2012 command line installation

I am new to SQL installation through command line. We are developing an application and using Installation Shield. I need to install SQL server on clients pc, so I am using command line silent ...
Vikram Singh's user avatar
0 votes
1 answer
3k views

SQL 2012 in Hyper-V. Why are my queries slow until I drop and create any spatial index?

I have a spatial application that queries several tables (layers) each time the user pans/zooms the map. When I moved the SQL server into Hyper-V, I noticed that there was a several second delay when ...
Damien's user avatar
  • 129
0 votes
1 answer
1k views

Trying to change the color of database and variable names

I am customizing the colors and can't for the life of me find the option to change the color of database/table and variable names ..they are stuck that odd teal color, Ive changed the color of ever ...
RustyH's user avatar
  • 147
3 votes
2 answers
3k views

Broken dropdowns in SQL Server Configuration Manager on Windows 8.1

I recently installed a new virtual VMWare machine for development purposes. The machine has Windows 8.1 (64 bit), Visual Studio 2013 and Microsoft SQL Server 2012 Standard Edition, all with latest ...
JustAMartin's user avatar
  • 1,571
1 vote
1 answer
2k views

SQL Server 2012 installation on Windows 8.1 Single Language

I tried to install SQL Server 2012 with SP1 on Windows 8.1 Single Language, but it terminates straight after starting with this helpful error: I've read that you need SQL Server 2012 SP2 on Windows 8,...
SeanW's user avatar
  • 153
0 votes
1 answer
3k views

Assign login to SQL user without login

Environment: SQL Server 2012 Express Edition and Microsoft SQL Server Management Studio. All users are local SQL users, NOT Windows authentication. I attached a database file which came from another ...
Damn Vegetables's user avatar
1 vote
0 answers
613 views

Changing font color in SSMS for different database elements?

I'm trying to change font color of different database elements, for database name to show up one color, table name to show up another and table aliases to be separate color. Is it even possible? ...
Vladimir Oselsky's user avatar
1 vote
2 answers
6k views

SQL Server 2012 configuration manager not opening in windows 8.1

I run SQLServerManager11.msc in apps to search but nothing happen. Need Help. It is install and showed in control panel.
user3090763's user avatar
1 vote
3 answers
10k views

Error message on SQL Server 2012 install

I am trying to install SQL Server 2012 Standard Edition on my Windows Server 2012. The installation keeps failing, and I have tried everything that I can come up with, but nothing helps. The error ...
Androme's user avatar
  • 260
1 vote
1 answer
4k views

Execute Backup-SqlDatabase cmdlet remotely

When I run the following script line locally on an SQL Server machine, it executes perfectly: Backup-SqlDatabase -ServerInstance $serverName -Database $sqldbname -BackupFile "$($backupFolder)$($...
Maxim V. Pavlov's user avatar
0 votes
1 answer
981 views

List of Services for SQL Server 2012 Express

I recently installed VS2013 Preview onto a clean OS and I'm trying to figure out if SQL Server Express 2012 got installed. Unfortunately, when I look in Control Panel->Administrative Tools->Services, ...
Shawn Eary's user avatar
1 vote
1 answer
10k views

Windows Server 2012, SQL Server 2012 and .NET Framework 4.0

We want to start developing on the newer versions of Windows Server 2012 and SQL Server 2012. At the moment we are using Visual Studio 2010 with the .NET Framework of 4.0. We are not creating desktop ...
nate's user avatar
  • 1,172
1 vote
1 answer
2k views

SQL Server Express "hangs", on startup

I recently installed SQL Server 2012 "Express", and, also, Visual Studio 2012. I was working with it, and all worked ok. At some point, a few hours ago, SQL Server Express, however, started "hanging"...
user2606742's user avatar
1 vote
1 answer
5k views

Impossible to Start SQL Server browser

I installed SQLserver Express 2012 on a Win7 machine. The lan is made out of 2 PCs (Win7 and Win XP). I cannot access the SQL server from the Win XP machine. I cannot start SQL server browser. I ...
user193655's user avatar
1 vote
2 answers
4k views

MS SQL Server 2012 Express Setup crashes with .NET error

I'm trying to install MS SQL Server 2012 Express on a virtual machine at a client. It's fresh install of Windows Server 2008 R2 Enterprise SP1. I added the "File Services" and "Application Server" ...
alexkelbo's user avatar
  • 111
1 vote
2 answers
10k views

How do I download SQL Server 2012 Express?

I feel like an idiot asking this question, but I can't seem to find the magic combination. (Or maybe Microsoft's website is broken. I'm not sure which.) Anyway, here's what I'm trying. Open SQL ...
jpmc26's user avatar
  • 503
1 vote
1 answer
58 views

Default text for SQL scripts

In MS SSQL Server Management Studio 2012, is it possible to get new scripts to contain some default text? I want to encourage colleagues to comment their scripts more consistently, so I'd like ...
Richard Cotton's user avatar
0 votes
1 answer
7k views

Unable to install SQL Server 2012

When I am trying to install a new instance of SQL server 2012 on my server, I get the following error message when I try to run the iso (before any gui appears): The operating system on this computer ...
Logan Bissonnette's user avatar
23 votes
4 answers
16k views

Floating or vertical results pane in SQL Server Management Studio

I have a multi monitor configuration and would like to be able to have my query editor on one monitor and the results pane on another. Can this be achieved? Either by having the results pane ...
Shevek's user avatar
  • 16.6k
1 vote
2 answers
28k views

SQL Server 2012 fails to install or remove

Got an odd problem here. Installed programs is showing SQL Server 2012 installed, but fails to remove itself when running the uninstaller. To add insult to injury, it also won't let install the ...
user978122's user avatar
0 votes
2 answers
7k views

SQL Server 2012 Maintenance Plan can't modify

Click on any created Maintenance Plan: TITLE: Microsoft SQL Server Management Studio Value cannot be null. Parameter name: component (System.Design) BUTTONS:OK Create a new Plan I get this error: ...
Crazyd's user avatar
  • 179
29 votes
7 answers
110k views

Move database from SQL Server 2012 to 2008

I have a database on a SQL Sever 2012 instance which I would like to copy to a 2008 server. The 2008 server cannot restore backups created by a 2012 server (I have tried). I cannot find any options ...
Rich's user avatar
  • 274