Stack Exchange Network

Stack Exchange network consists of 175 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

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
0answers
3 views

SQL Server Configuration Manager - Can't change “Start Mode” to Manual

I'm running Windows 10 with SQL Server 2012. As I am not using SQL Server frequently, I am trying to change the "Start Mode" of all its processes to "Manual" (thru SQL Server Configuration Manager). ...
-2
votes
0answers
8 views

SQL Database tables sync

i'm looking for the easiest and safest way to replicate some tables (not the whole database) from a SQL Server 2012 Std Ed , to a SQL Server 2012 Express Ed. It doesnt need to be a real time sync, it ...
0
votes
1answer
6 views

Connecting from Java Azure function to managed Azure SQL instance

I have a Java Azure function that connects to an SQL Server database, and it used to work fine with "Azure SQL Service". The DB is now being migrated to Azure SQL "Managed Instance", so I changed the ...
4
votes
2answers
278 views

What are the drawbacks of putting my staging and production dbs into one Azure Elastic Pool?

I have a STAGING and PROD environment, web apps, SQL databases, etc in Azure. Currently, the scale of the SQL db for PROD is much higher than STAGING - no surprises there. I suppose there is some ...
2
votes
2answers
22 views

sqlservr.exe using 24GB of RAM for an inaccessible database

A server running SBS 2011 is causing me all kinds of headaches. All but 500MB of the 24GB of RAM is in use, mainly for sqlservr.exe. My first idea was to fix the amount of memory SQL could use. But ...
0
votes
0answers
14 views

SQL Server Linked Server Instability

Have been experiencing issues with linked servers within SQL Server 2014 (64 bit). The linked servers are linked to older legacy .mdb’s but our current version of office is Microsoft Access 2010 (32 ...
-1
votes
0answers
9 views

Optimize SQL syntax with conditional WHERE clause [migrated]

Is it possible to optimize the following parts of the stored procedure regarding the WHERE clause without using dynamic SQL? The only difference between the two alternatives is that if Admin = 1 then ...
0
votes
1answer
14 views

Azure Scheduler that updates both Azure Database and On Premise SQL Server Database

I have a REST Service that needs to update data into Azure SQL Server database and also into On Premise SQL Server database. Both databases should have same data in certain database tables. ...
1
vote
0answers
37 views

WSUS cleanup with SQL Management Studio

So I have an upstream WSUS server which never ran the cleanup wizard. The content folder is around 800GB and there were also a lot of unneeded product categories enabled including drivers. As a first ...
1
vote
1answer
71 views

SQL Server 2014 setup fails: SSL Provider, error: 0 - The token supplied to the function is invalid

I am attempting to install SQL Server 2014 Standard edition on a new Windows Server 2016 set up as a domain controller that replaces a retired DC. (I know it's not recommended, but we are a small ...
0
votes
0answers
9 views

sql server 2016 create trigger to grant permissions to user

I'm trying to create a trigger that will grant alter permissions to the new user in a database. The trigger fires, but the error message received is "Could not find stored procedure 'GRANT ALTER ON ...
0
votes
0answers
11 views

How do i use stored procedure in an sql server and continuously monitor by storing the output in a csv file?

Consider the stored procedure sp_monitor in mssql. I want to run this continuously in the terminal and monitor the output of this procedure and put the data into a CSV file stored on my disk. What do ...
0
votes
0answers
21 views

yum install php-mssql got issue conflicts

when i try to install yum install php-mssql on centos 7 i got the following error php55w-common conflicts with php-common-5.4.16-46.el7.x86_64 How to fix this issue am using centos 7.
0
votes
0answers
12 views

Why does sql server perform better after restart [migrated]

We had a performance issue that we solved by restarting the sql server service. That's obviously not the way we want to continue handling our performance issues. When a sql server performs better ...
0
votes
0answers
21 views

How to make SQL mirroring endpoint on clustered SQL 2012 instance listen to all IPs?

I have a clustered SQL 2012 standard instance and I want to set up database mirroring. I also need to route the mirroring traffic through a separate NIC. We added the secondary IP to the SQL server ...
0
votes
0answers
18 views

SQL Server Linux Docker network issue

Here is my environment Linux Debian 9 Kernel 4.9.0-8-amd64 8vCPU - 32GB Docker Swarm 18.09.1 (3 managers) I am running SQL Server in a docker container (Swarm service) and I encounter random ...
1
vote
2answers
23 views

Can I see the actual collation (of e. g. Latin1) as used in for instance MySQL or Windows? The order of characters, not the name

I searched, and all I find is descriptions of the names, and the selection of collations. For example: _Zulu 0Alpha Alpha alpha usually sorts this way (on US Windows, most SQL servers etc.), ...
0
votes
1answer
12 views

unixODBC in Apache broken after enabling Kerberos on Centos7

Had unixODBC working very well. Decided that we wanted to implement Kerberos authentication to lock down different sites in Apache to certain user groups. Once this got enabled, connecting to the ...
1
vote
2answers
30 views

Protecting SQL Server table data from developer

We have a web server running web application and SQL Server. Our developers have access to that server with Admin privilege and regularly upgrades the applications and add new stored procedures. ...
0
votes
0answers
9 views

Possible to CROSS JOIN a subquery without duplicating code? [migrated]

I'm wanting to get all permutations between two columns in the same table. Currently my query is this: declare @tgt int = 123456; select * from ( select T.id, T.parentId from Task T where ( ...
0
votes
1answer
44 views

Secure remote access to SQL Server in a multi-tenant environment using TLS tunnels

A similar question was answered here, and the option of opening an SSH tunnel was lightly touched, but the consensus was that VPN tunnels would be the easiest solution, which is true if the client is ...
1
vote
0answers
37 views

Can't load SQLsrv due to “zval_ptr_dtor” error

I am trying to install the PHP MSSQL Driver following this guide: https://serverpilot.io/docs/how-to-install-the-php-sqlsrv-extension But I keep running into this error after the installation (no ...
3
votes
1answer
29 views

IIS8 Application Pool Identity with Integrated Security to a SQL Server in a non-trusted domain?

Here is the scenario that we are experiencing and why we are trying to solve this: We are a consulting company that support a particular third-party software application for a number of clients. The ...
12
votes
6answers
2k views

Advantages of upgrading 32 bit Windows Server and SQL Server to 64 bit?

Suppose that I have a 32 bit Windows Server box that operates several server applications along with an SQL Server, with a RAM usage of about 2 GB at peak times. What would be the advantages of ...
4
votes
2answers
44 views

How we can have the ability to build a new sharepoint server which have the same sharepoint patches installed

we have couple of sharepoint 2013/2016 farms, and they all shared these architecture :- one sharepoint application server which have sharepoint server installed. one database server which have the ...
0
votes
1answer
17 views

SQL Server 2017 Database Mail Silent error

I have made an installation of a development environment in VMWare that contains: Windows Server 2016 SQL Server 2017 The objective is to perform migration tests of a base that is currently in: ...
0
votes
0answers
33 views

Why do some folders not appear in SSMS when restoring a database in SSMS18?

I tried adding NT SERVICE\MSSQLSERVER to the downloads folder security tab with read/write access but when I navigate to restore the database the folder doesn't appear: I know I can just move the ...
1
vote
0answers
44 views

MSSQL Server 2017 on Centos - AD auth - SSPI handshake failed

We have SQL Server 2017 installed on CentOS and connected to domain according to this tutorial - https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-active-directory-authentication?view=sql-...
0
votes
2answers
141 views

How do I get SQL Server Management Studio to find a .bak file to restore?

I am trying to turn a .bak file into a database. I can't find the "Restore Database" button when I left-click "databases" when connected. This is what I should see. However, this is what I see. I ...
0
votes
1answer
25 views

SQL SSMS on development - clear ldf files

Working on building a big SQL Server database, I noticed my C drive is running out of space when running heavy SQL queries. The following folder size is over 150GB, log.ldf files reach over 50GB. C:\...
0
votes
0answers
8 views

Commvault job details displaying wrong SharePoint version

I was checking my environment in detail this morning and noticed that the job details for our SharePoint SQL backups in Commvault are displaying the wrong SharePoint version. It's saying SharePoint ...
2
votes
2answers
55 views

Highly available virtualized SQL Server on 2 ESXi hosts and one SAN storage

I have two ESXi hosts. I am planning on installing a SQL Server instance on each hosts and make them highly available. The two hosts are connected to one SAN storage. The storage is Dell EMC ...
1
vote
1answer
8 views

Cannot connect remote sql server on aliyun

I have installed SQL Server Developer Edition 2017 on Windows Server 2016 in order to do some test on my aliyun server. However, I cannot connect remotely. On local SSMS, the "Allow remote ...
1
vote
0answers
36 views

Migrate Windows Server 2012 R2 Data Center to a physical Windows Server 2016

I am assisting a client to move from Windows Server 2012 R2 Datacenter Edition to a physical machine. The server is also running SQL Server which also needs to be migrated. Anyone can suggest the ...
0
votes
0answers
17 views

SQL server maintenance plan not working after renaming administrator

I have renamed the windows administrator account to TEST using Local Group Policy Editor. After that the SQL server maintenance plans are not working: unable to determine if the owner of job has ...
1
vote
1answer
18 views

SQL2016 ODBC login fail on first attempt

My current SQL server version is: Microsoft SQL Server 2016 (SP2) (KB4052908) - 13.0.5026.0 (X64) Mar 18 2018 09:11:49 Copyright (c) Microsoft Corporation Enterprise Edition (64-...
2
votes
0answers
25 views

How does DPAPI protect the master key for a service account?

I am trying to understand the security of TDE for MSSQL. The documentation says it relies on Windows DPAPI. DPAPI generates a master key using a user's credentials. This works well for human users ...
0
votes
1answer
35 views

Highest Active Time on SQL Server Disk

I have a SQL Server 2017 instance that seems to be running a bit slowly. CPU and Memory usage looks to be normal, but disk usage might be a bit high. The data files are on disk E and the log files are ...
1
vote
1answer
67 views

“Someone logged on to your SQL server from an unusual location.”

I'm using SQL Server on Azure and just received this security threat message. Unauthorized access that exploits an opening in the firewall; legitimate access from a new location. Google searches ...
3
votes
1answer
101 views

What may increase the latency 3-4 times for SQL FCI the database?

We have SQL Server Basic Availability Groups (BAG) configured to run an SQL database running over local Intel SSD drive. I was asked to move a database to SQL Server Failover Cluster Instance (FCI) to ...
-3
votes
2answers
48 views

SQLServer 2008 R2 (also SP1/SP2) on Windows 10 within Virtualbox does not start [closed]

The results of an epic afternoon... Installed SQLServer 2008 on Windows 10 within Virtual box. Service won't start. Installed SP1. Service won't start. Installed SP2. Service won't start. the ...
0
votes
1answer
94 views

MS SQL Server provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 5)

I have a server that is running a MS SQL Server 2016 database. I have two other servers: Server A and Server B. I can connect to the database using SSMS on Server A but I can't connect to the database ...
1
vote
1answer
13 views

Is SQL Server capable of sending certificate chain to the client?

I wonder if SQL Server is capable of sending certificate chain to the client, I tried every option while creating certificates and I am aware of what restrictions SQL Server puts on a certificate to ...
0
votes
0answers
30 views

Run SQL Server Standard 2017 Edition Together with SSRS 2017 Developer Edition

Has anybody ever tried running SQL Server 2017 Standard with SSRS Developer Edition and had it worked successfully? I'm setting up a client environment in Azure. This will be there production ...
0
votes
0answers
148 views

SQL Server service: the service did not start due to a logon failure (Error 1069)

I am administering a database server running SQL Server 2016. The MSSQLSERVER service has been running under a domain account (with a password that does not expire) for a long time now with no ...
1
vote
0answers
133 views

Use SSH Tunnel with MSSQL

An owner of a MS SQL db has allowed access to their db from an IP address of a remote machine I own. I can SSH into that machine and connect to the DB using: ssh -i my.pem 100.0.0.100 sqlcmd -...
0
votes
0answers
130 views

Configure SSRS remotely - A connection to the computer cannot be established

I just installed the newest SQL Server Reporting Services 2017 using this instructions: https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/install-reporting-services?view=sql-...
0
votes
0answers
108 views

Identity value incorrect after migration to Azure SQL

I used the new MS Data Migration Assistant (v4.1 link) to migrate a database from a SQL 2008 R2 server to an Azure SQL database. The process worked well and the data migration worked great! However, ...
1
vote
0answers
113 views

Importing data from Informix DB to SQL Server

Configured Informix drivers (32-bit) ODBC on my local machine and trying to import the data to SQL Server using SQL Server IMPORT and export wizard. I selected source tables and views(steps in SQL ...
0
votes
0answers
21 views

SQL Server Express limited by instance or by installation?

I've got one installation of SQL Server Enterprise and a couple of satellite installations of SQL Server Express. I can't justify additional installations of SQL Server itself for these satellites. ...