Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange
Join us in building a kind, collaborative learning community via our updated Code of Conduct.

Questions tagged [sql-server]

Questions related to Microsoft SQL Server. If your question is version specific please tag it specifically for that version as well. Does your SQL Server question belong here or on another site? Click the about the sql-server tag link on the line below.

0
votes
1answer
52 views

How can I get Microsoft Command Line Utilities 14 for SQL Server to install?

In order to run a third-party WSUS script (against the Windows Internal Database) I downloaded the x64 version of the Microsoft Command Line Utilities 14 for SQL Server, but when I attempt the ...
0
votes
0answers
13 views

Sharepoint 2016 Backup Database Permissions

We have a VMware Windows Server 2012R2 server VM running Sharepoint Server 2016. It connects to a separate dedicated SQL Server 2016 for all its DB needs. Whenever our Veeam Backup & Replication ...
0
votes
1answer
31 views

Azure SQL to On-Premise SQL Server Data Transfer

I need to securely transfer data from a SQL Server in Microsoft Azure to a SQL Server on-premises. I have been researching different methods but I have not found the right way. Following is the list ...
1
vote
0answers
11 views

T-SQL Finding who attempted to backup the “master” database?

I'm running SQL Server 2016. For the last two nights at 7pm the SQL Server Alert System sent me this alert: 'Severity 016: Miscellaneous User Error' DATE/TIME: 8/8/2018 7:02:19 PM DESCRIPTION: ...
0
votes
0answers
20 views

Backup Scenario with CQRS (MSSQL)

I have a question regarding a backup scenario since we are going to move our software to CQRS and I am not sure how to make a consistent backup on the database side. We have a software that was in ...
0
votes
0answers
11 views

Bad performance on SQL server (express) because of indexed view [migrated]

We have a SQL server express 2017 with an indexed view (clustered index) to speed up database reading. When we insert/alter data which will change the view, the query runs "for ever" (even longer then ...
0
votes
1answer
60 views

Where does DPM use space on a protected SQL Server?

I'm using Microsoft System Center Data Protection Manager 2016 to protect SQL Server 2017 on Windows Server 2016. I believe that whenever DPM does a backup (synchronization or express full) it will ...
0
votes
0answers
15 views

How to run SQL server 2012 instead of 2014 when both are installed and 2014 is currently running?

I need to backup a DB using SQL server 2012 to match another server it is going to. However on my local machine I'm currently running 2014. I can see that SQL server 2012 is installed along with ...
0
votes
1answer
47 views

So does MediaWiKi support MSSQL or not?

So I am trying to install MediaWiKi 1.31.0 on a machine running IIS 8 on server 2012 R2. We are running MSSQL server 2012. I followed the instructions on the media wiki page to install for MSSQL, but ...
1
vote
0answers
90 views

Importing BACPAC via SSMS to Azure SQL Server fails with AzureAD user

Recently, trying to import a BACPAC to an Azure SQL Server using SSMS (SQL Server Management Studio) has been failing with the following error: Failed to connect to server ___.database.windows.net. ...
0
votes
0answers
31 views

Sql server on ubuntu doesn't respnod

I have installed sql server 14.0.3030 express with .netcore 1.1 on ubuntu 16.04 and everything was fine till last night suddenly i encountered with this err message from my dot net core web app ...
0
votes
1answer
20 views

SQL Server Sort Order to Binary Search on SQL Server 2008 SP1

I am installing an OLT Software that requires Windows SQL Server 2008. I am getting this error below; The database sort order must be "binary sort". Please run the Transact-SQL command ...
1
vote
0answers
16 views

It is not possible to establish a connection with SQL Server 2008 R2

I'm having a little weird inconvenience. 9 months ago I have a Windows VPS with SQL Server database, which I was always using from a WebHosting that was connected remotely to my server. Yesterday ...
3
votes
0answers
242 views

Parallel Redo Is Shutdown

When looking in Windows event logs, i'm seeing the following messages on an almost continuous basis - Starting up database 'Database'. Parallel redo is started for database 'Database' with worker ...
0
votes
0answers
65 views

Linux : Undefined symbol: php_pdo_register_driver in Unknown on line 0

When i add the extenstion extension=pdo_sqlsrv.so in php.ini file in linux server with PHP v7.0 it's giving following error undefined symbol: php_pdo_register_driver in Unknown on line 0 Please ...
0
votes
2answers
122 views

Can't access remote SQL Server instance even if its firewall its disabled

I'm trying to remotely access to an old SQL Server 2005 instance in order to port some data over to another server, however I am unable to access to the database while using my database administrator ...
0
votes
0answers
21 views

Sql availability group listener not failing over

We have built two sql clusters with always on availability groups, based on the windows failover cluster service. This is done as per Microsoft documented process, however we are getting some ...
0
votes
0answers
28 views

SQL Server 2016 replication monitor from the slave ( subscriber ) without admin access to the publisher

Question: Is it possible to check the replication status of SQL Server 2016 from the slave ( subscriber ) without admin access to the publisher? We have an SQL Server 2016 which is a slave ( ...
0
votes
0answers
39 views

MSSQL Integration RHEL with Apache 2 and PHP Version 7.0.30

This was working correctly until my client decided to yum update everything without asking me. I've installed sqlsrv.so and pdo_sqlsrv.so to /etc/php.d/ PHP -m shows both modules loaded as does ...
2
votes
0answers
25 views

Bizarre SQL SRS error when trying to access SCCM reporting reports

In case this is an X-Y problem, what I'm trying to do is grab logs from SQL Server Reporting Services to tell me who did a couple horrible things in our SCCM environment - 1) deploying a rather large ...
0
votes
1answer
30 views

Find outdated statistic in SQL server?

I have a stored proc which searches "bad" data in our application database (sql server 2016 enterprise, ~500gb data). "bad" in a business/process sense. It normally takes 10-30s to execute. After ...
0
votes
0answers
41 views

Cannot open .jpg on Windows Server using Delphi

Enviroment: I have a Delphi program that is connected with SQL-Server. Through the program I open some photos. All photos are opened just fine expect one. When I try to open it with windows photo ...
0
votes
0answers
38 views

List Everything that uses a linked server in sql

I am currently facing an issue communicating with a SQL server which has been moved and the database which I was looking info has been removed. I have been using an alias manager to divert all traffic ...
0
votes
0answers
174 views

How to install PDO dblib (mssql) on PHP 7.1 on a directadmin server (CentOS)

On a directadmin CentOS server I'm running PHP 7.1, and I'm trying to connect to a remote mssql server. I'm missing PDO dblib extension. How can I install it?
0
votes
1answer
72 views

CustomScriptExtension on Azure with SQL Server Image not downloading the file because of already used Sequence Number from a Golden Image

I'm trying to deploy a Windows SQL Server on Azure and running a script on it using the CustomScriptExtension resource. I've been using CustomScriptExtension successfully when deploying Windows ...
1
vote
1answer
89 views

IIS and SQL Server Performance Issues when not on same machine

Issue: Trying to get the same (or better) performance with a separate SQL Server 2017 and IIS 7.5 server than with having both on the same machine. Trying to move toward scalability for future ...
1
vote
0answers
34 views

SQL Server outbound IP address inconsistency in Azure VM

I have this setup: Azure VM (B-series) Static public IP SQL Server running outside of Azure, with IP whitelisting on the firewall set tot he public static IP of the Azure VM Two ASP.NET apps that ...
1
vote
0answers
168 views

Can SQL Server 2005 Use TLS 1.2 for Web Apps?

Hoping for some help as this is a bit new to me. We have a legacy app running ASP with a separate SQL Server 2005 running on Server 2003 instance. I'd like to required TLS 1.2 for all web app ...
0
votes
1answer
24 views

SQL Server - Firewall Blocking Replication Even Though Port 1433 is Allowed

I have two servers, Server 1 and Server 2, both are stand-alone, Windows Server 2016 with SQL Server 2017 using default instance. They are not members of a domain, and connected over a VPN (using ...
0
votes
0answers
23 views

How to resolve SQLServer Error: 15404?

SQLServer Error: 15404, Could not obtain information about Windows NT group/user 'WIN-443PT0LULQU\Administrator', error code 0x534. [SQLSTATE 42000] (ConnIsLoginSysAdmin) I vaguely understand that - ...
1
vote
1answer
35 views

Can I restore a SQL Server instance from file backups only?

Our windows 2016 server failed to restart after a windows update yesterday. In order to avoid the update that crashed it issue (whatever it was), I'm in the process of rebuilding it clean. So I've ...
0
votes
0answers
25 views

Azure SQL database upgrade

Im wondering something regarding this article: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-manage-application-rolling-upgrade We would like to perform a database upgrade ...
1
vote
1answer
55 views

How can I determine why db access appears to be slow with one db server but not another using the same site?

We have a setup with two web servers and one DB server in both the UK and Australia. These servers are with Rackspace and the webservers connect to the db servers via private IP in both circumstances....
-1
votes
1answer
21 views

How to create (or use the existing) database on an SQL 2017 deployed via Azure VM?

Please note the question is about the SQL 2017 that comes inside an Azure VM, not the Azure Databases. Basically, I deployed an Azure VM with SQL 2017 Enterprise installed on it already, by MS. Now, ...
0
votes
0answers
32 views

SQL Server on Linux as Witness server

Is it possible to use SQL Server on Linux as a Witness server for SQL DB Mirroring? The infrastructure I am supporting was built with the Witness installed on DB2 and there is no money available ...
0
votes
0answers
500 views

After windows 10 update, cant connect to sql server from program on a shared folder

After the new windows 10 update (may 10) my program cant connect to the sql server anymore. The executable is on a shared folder on another computer. I've tried to run it as administrator, disabled ...
0
votes
0answers
22 views

Why does BIDS installation for SQL Server 2008 fails with error 1911?

I am trying to Install Business Intelligence Development Studio and I get this error message: Error 1911. Could not register type library for file C:\Program Files (x86)\Common Files\Microsoft Shared\...
0
votes
0answers
26 views

SQL Server Installation Thinks I Am Running On Server Core

I am running windows 10 Enterprise 2016 LTSB and am trying to install SQL Server 2017. When I try to run setup directly, the command window closes immediately, but when I try to run setup.exe from ...
0
votes
1answer
46 views

sql server slow only on LAN

I have a MS SQL Server instance on my server. Running select * from sys.columns takes 00:00 seconds. (just as a sample, most queries have same issue) When i run the same query in SSMS, it takes 30 ...
0
votes
1answer
107 views

migrate stopped mariadb server to new one

Hi I'm running a freenas system where I have two jails. One jail is broken in a way that I cannot start the mariadb server anymore due to userland and kernel version mismatch. So I created a new jail ...
1
vote
1answer
22 views

Minimal permission for restoring *some* databases on SQL Server 2012

I am trying to create a set of permissions where an SQL login can create backups of all databases, but only restore the backups on the TEST databases. Another login should be used for restoring to ...
0
votes
0answers
16 views

SQL Server instance setup: ConfigurationFile.ini parameter problems

I'm attempting to setup an SQL Server 2008 R2 instance using the ConfigurationFile.ini. I'm well aware of the parameters that can be used through the MS resources: Install SQL Server 2012 Using a ...
0
votes
0answers
134 views

SQL Server instance Setup: System cannot find the file specified

I have a couple of Windows 2012 R2 VM servers I'm using to test setting up an SQL cluster. I'm specifically testing the upgrade process from SQL Server 2008 R2 to SQL Server 2016. The first run went ...
0
votes
1answer
45 views

Misnamed MS SQL server MSBD and Model DB log file names during move

I've made an interesting problem for myself on SQL 2008R2. I moved my MSDB and Model databases to a new drive, but in the process of doing so I transposed the log file names for each and they are now ...
-4
votes
1answer
136 views

sql server can't start error code 1814

My pc can't start sqlserver 2008 R2. this is my sql server errorlog 2018-05-02 16:32:47.26 Server Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright ...
-2
votes
1answer
147 views

SQL Cluster Between Cloud Providers - Multi Cloud SQL

I want to explore the options available to me in setting up MS SQL replication between Azure and Amazon AWS. Has anyone got any ideas? I think Always On Availability Groups is off the table. -- ...
0
votes
1answer
2k views

Exception of type “System.OutOfMemoryException” deploying database to Azure

I installed SQL Server Express 2017 on a VM in Azure and restored my 2 Gig Kentico 9 database to it. Then I tried to deploy to an Azure database. Things seemed to be going well for 30 minutes, then I ...
0
votes
1answer
158 views

Unclosed quotation mark after the character string restoring from Azure blob

I am using the following command ( with altered blobname and datbase name) to try to restore into an Azure SQL Server database from a backup of a 2014 database I am using Australia South East with my ...
0
votes
1answer
54 views

SQL Server with MSA cannot write to UNC share

I have SQL Server 2012 running in an Active Directory Domain environment. I set up a Managed Service Account for the SQL services to run under, as per this document. Since my domain functional level ...
0
votes
1answer
29 views

Slow SQL Queries over local net

Slow Queries for SQL over 1Gb link between servers using just SSMS Server Configs: Main SQL Node: 32GB Ram 16 cores Sage Evolution Server: 16 cores 16GB ram The config of the servers is that they ...