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.

1
vote
0answers
23 views

ODBC Driver 17 for SQL Server

Morning, Some background: Recently upgraded database and web servers from Server 2008R2 => 2016 OS Recently upgraded database instances from SQL Server 2008R2 => 2016 Recently upgraded the ODBC ...
-1
votes
0answers
12 views

Which AWS Server will be the best for our Migration [duplicate]

We have some of our SQL Server (Standard Editions) environments on AWS Cloud instances. We are planning to migrate the SQL Server Standard Editions to Enterprise. I have been given a task to determine ...
0
votes
0answers
10 views

PHP 7.1x MSSQL connect fails with SQLAllocHandle on SQL_HANDLE_ENV after Plesk update

I have a couple of servers running WISP stacks on Windows 2016 server using Plesk 17 when update #53 was applied. Up until last night all were functioning perfectly. Both servers are fully updated ...
-1
votes
0answers
30 views

How to protect database data from DBAs? [on hold]

So we have some compliance requirements around who/what can see data in a database. Ideally we'd like it only to be usable by the service that is in question -- and the user authorized to see the data ...
0
votes
0answers
6 views

PowerShell SQLServer.Management.Smo.Server can't connect

I am trying to use Microsoft.SQLServer.Management.Smo.Server to connect to my MSSQL server but whatever I try it keeps erroring out with "Failed to connect to server .." #Connect and run a command ...
0
votes
2answers
17 views

Moving Team Foundation Server 2013 to new machine

I want to move our TFS database and application to a newer server. Both the TFS application and the SQL instance reside on the old server. The new server will be set up similarly but with updated ...
0
votes
0answers
14 views

Linux SQL Server on OpenVZ Linux Instance

I've tried to install Linux SQL Server on 3 completely different VPS. 2 Running Centos 7 and one Ubuntu. All of them run on an OpenVZ Virtualization environment. To install SQL Server I follwed this ...
0
votes
0answers
6 views

Timeout error while syncing MS SQL 2014 database to azure sql

I'am working on a small Azure SQL Sync test setup and ran into problems. I want to sync an on prem database to the cloud via a sql sync group in azure. On Premise: 1x MS SQL 2014 Server, 1x ...
0
votes
2answers
76 views

How to Verify What Databases are Being Used and by Which Applications

There is an Old-SQL server, Running as a VM guest, that needs to be replace. The Old-SQL server will be replaced with a New-SQL server, running as a VM Guest. Currently the Old-SQL server needs to be ...
-1
votes
1answer
13 views

Openfire: org.jivesoftware.openfire.pubsub.PubSubPersistenceManager - Incorrect syntax near the keyword ‘LEFT’

Any idea what could be causing this error to be constantly produced in all.log and error. log. Openfire 4.3.2 on Windows connected to SQL Server 2012 (SP4) - although it shouldn’t matter. Could it be ...
0
votes
1answer
13 views

ejabberd and MS SQL on Windows?

Is it correct that if I install ejabberd on Windows machine I cannot use MS SQL instead of Mnesia? https://docs.ejabberd.im/admin/configuration/#microsoft-sql-notes seems to suggest it, it says, "For ...
1
vote
0answers
16 views

Use a 32-bit DSN for 64-bit MSSQL2016 server

We recently upgraded an MSSQL 2012 server to 2016 and found that this broke existing ODBC DSNs. It appears that the server no longer has 32-bit networking installed. In the SQL Server ...
1
vote
0answers
37 views

Blue question mark on SQL server and SQL server agent?

I just installed MS SQL server 2017 on MS Server 2019. All installation process were fine. Using SSMS 18 access SQL server locally was fine, no issue at all. But when I use SSMS 18 connecting SQL ...
0
votes
1answer
57 views

Cannot add SQL Server Always On Availability Group Listener to second subnet

I have a WSFC cluster between two 2016 nodes - DB1 and DB2. (Cluster Network 1 and 3 are set to NOT carry cluster traffic.) Failover cluster manager shows that Cluster Network 2 has two subnets: ...
0
votes
1answer
19 views

Switch AWS EC2 Instance from sql server enterprise to standard

I'm trying to downgrade my ec2 instance from sql enterprise to sql standard or express, the thing i wanna keep the server content and i can't start from scratch. i've tried uninstalling sql server and ...
1
vote
0answers
15 views

SQL Server Ubuntu 16.04 - “Nothing” works (It always hangs)

Note: I have asked this question on Database administrators previously, but I have deleted it over there because I think it suits better here. That's why this question already contains edits and I ...
-1
votes
0answers
13 views

How do delete duplicate key row in mssql server? [migrated]

I'm not a great mssql admin so this may be a lot easier, I just don't know where to start looking. ADO Err Description: [Microsoft][ODBC SQL Server Driver][SQL Server] Cannot insert duplicate key row ...
0
votes
1answer
13 views

NT Service\MSSQL$DEV

I have these services running I was supposed to change only the SQL Server Agent service but by mistake changed couple of SQL SERVER STORAGE PROCESSING SERVICES which was using NT Service\MSSQL$DEV ...
0
votes
0answers
13 views

SQL Proxying DMZ webserver connection

We've got a product coming in which is requesting us to open up a connection from the web server (WEB) in our DMZ to our production database server (PROD). The production database is literally only ...
0
votes
0answers
38 views

MS-SQL connection (from kubernetes) with IP and instancename not working; port is working

Situation: MS-SQL Server <--> Local Network <-- VPN --> Google Kubernetes <--> Pod (sql-client) our local network is connected via VPN to our Google Kubernetes cluster the ms-sql server is ...
0
votes
1answer
44 views

How to shrink SQL Server Log File Size?

To start off, I am a Software Engineer - nowhere near a DBA. I can install SQL Server and setup a simple SQL Server database, which I have done. I setup a simple SQL Server 2016 database on a client's ...
1
vote
0answers
25 views

Can I use a gMSA for stored credentials in a SSRS data source?

I have an instance of SQL Server 2016 Reporting Services service running under DOMAIN\reporting$ containing a data source that needs to query a database using the stored credential DOMAIN\database$. ...
0
votes
0answers
22 views

MSSQL database still hits the 10GB limit after enabling RBS

So i am new to the whole sharepoint/mssql thing, but i have managed to install sharepoint 2013 foundation, all is on one server (default installation) and i have RBS setup. Everything goes to the ...
1
vote
0answers
37 views

All things ADS (alas, TFS is no more…)

After an in-place upgrade from TFS 2018 to ADS 2019, I'm in the process of migrating all of my TFS nomenclature to ADS. For example, the supporting service accounts have been changed from TFS_Service /...
0
votes
0answers
30 views

MSSQL 2016 Peer to Peer Transactional Replication Broken because distributor cannot alter a system table in the subscriber's database

Our set up is 2016 SQL server and we are using P2P transactional replication among our four servers. Recently one of the servers is reporting that it is trying to apply command “if COLUMNPROPERTY(...
0
votes
0answers
31 views

SqlServer on linux getting very slow

I have an Ubuntu 16.04 VPS and started to test SQL Server on it. Installation went flawlessly and I was using it for about a month without any problems. Then I did an apt update and it didn't start. ...
0
votes
2answers
129 views

Unable to configure/start mssql-server

I get an error after following this guide: https://computingforgeeks.com/how-to-install-ms-sql-on-ubuntu-18-04-lts/ and running the configuration command. I've searched for a couple hours trying to ...
1
vote
0answers
17 views

Allow Guest User in Azure Access to SQL Server (DEV, Read/Write)

I'm a bit new to Azure AD. I have some software development offshored and have already created a guest account in Azure for the developer. I've create an account in SQL Server (Manually via the ...
0
votes
1answer
52 views

SQL Server Stretch Cluster

I would like a SQL Server instance on a VM in Azure to be in sync with an on premise SQL Server so applications on the VM and applications on premise are using the same in sync data. Could a stretch ...
0
votes
0answers
8 views

SQL Server / Unable to setup RML Reporter as a part of RML utilities

I am trying to use the Reporter from the RML Utilities. In the Reporter screen, I connect with the database I want to work with, I click on OK. I get the following error message, Error: Database ...
0
votes
2answers
26 views

How do I back up my Azure SQL Server Database to my local machine?

I have an Azure SQL Server database that I need to get rid of off of Azure, but that I don't want to lose the data within it. I cannot figure out how to backup/export the data. How do I do so?
0
votes
0answers
12 views

SQL Server transaction log storage on AWS Disk type

We are moving our SQL Server to an Amazon EC2 instance. For the various disk types under consideration gp2, io1, st1, It is unclear to me which type of drive to store the transaction logs on. I ...
0
votes
0answers
17 views

SQL Server 2016 Service Account Issue

I installed SQL Server 2016 on Windows Server 2016. It has been working fine for several days. This morning after an unexpected reboot I noticed one of my applications was not working. I noticed the ...
0
votes
0answers
47 views

Two versions of SQL Server LocalDB - how to connect to/create automatic instance for newer version?

Providing a bit of background in case it's relevant. I have to test two of our databases locally on my computer. When I tried to restore the databases I received an error that they had been backed up ...
0
votes
0answers
23 views

Resource Governor on Azure SQL Database (Not managed instance)

my problem is the following: when an user runs a very long and CPU-intensive query, the entire database is locked (when another user tries to run another query, that's one is blocked by the first one)....
0
votes
2answers
16 views

Add SQL-feature with what Servicepack

I need to add an SQL-feature (SQL-replication) to an existing SQL-instance. It's SQL Server 2012 Standard SP1 that has been upgraded to SP3 a few years ago. What installation media should I use to ...
1
vote
0answers
39 views

Apache Webserver Config issues in Windows

I'm trying to configure an apache 2.4 webserver for data entry that will feed into a SQL server. I've got the individual processes up and running but I can't get the webform to load. I just get the ...
0
votes
1answer
135 views

How to migrate a MySQL 5.7 database to MySQL 8.0?

Currently I have a Drupal 8 site in production with a database on MySQL 5.7 How to migrate a MySQL 5.7 database to MySQL 8.0? Do I just need to export my Drupal 8 database from MySQL 5.7 and import ...
1
vote
1answer
45 views

SQL Server Multiple File Backups - AWS EC2 Disk I/O Cap?

Running a 1 TB SQL Server database on an AWS EC2 C5.4xl server (16 vCPU / 32 GB). A full backup is starting to approach 3 hours so I figured I should look into multiple file backups. I expected to do ...
0
votes
0answers
18 views

Typo or not? (DBMSSCON vs DBMSSOCN?)

I'm troubleshooting this SQL Server connection issue which is set on our client's server and I cannot find anything wrong with our application. They are using aliases and usually they use the TCP/IP ...
0
votes
0answers
65 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). ...
0
votes
2answers
174 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
302 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
89 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
36 views

SQL Server Linked Server Remove “Allow in Process” Authentication Failure

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 ...
0
votes
1answer
23 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
220 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
233 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
21 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
16 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 ...