Questions tagged [sql-server-2012]
The sql-server-2012 tag has no usage guidance.
50
questions
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 ...
-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\....
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,...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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
...
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 ...
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 ...
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 (...
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 ...
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?
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 ...
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 ...
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 ...
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 ...
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 ...
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
...
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 ...
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 ...
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:\...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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,...
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 ...
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? ...
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.
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 ...
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)$($...
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, ...
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 ...
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"...
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 ...
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" ...
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 ...
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 ...
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 ...
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 ...
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 ...
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:
...
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 ...