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
623
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
469
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
431
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
235
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
826
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
180
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
6k
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
10k
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
...
6
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
83
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
586
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
564
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
684
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?