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.

Filter by
Sorted by
Tagged with
0
votes
1answer
21 views

Installing MSSQL for Linux on Debian Buster (SSL 1.0??)

Would love to run my MS-SQL on a Debian Buster server but there are some obstacles. First of all the installation has dependencies not available in the Buster repository, one is the old libssl1.0.0 (...
0
votes
2answers
33 views

How do I test connection from Linux to Microsoft SQL Server?

What's the simplest way to check connectivity from a Linux server (e.g. Ubuntu 18.04) to a remote Microsoft SQL Server 2017 instance?
0
votes
0answers
7 views

New SQL server jobs apeared look like virus or sth [duplicate]

today I checked SQL Server's jobs and I found some new jobs with strange names (bat.exe, cook.exe. dll.exe, ftpbacks.exe,regs.exe, tasks.exe, sqlrc, wmi, ...). Most of them are failed. How can I know ...
0
votes
2answers
42 views

How does one begin entering data into a SQL/database server?

Does one start out with an Excel spreadsheet or Access database and then import that into SQL? Does SQL have its own spreadsheet interface as part of the software to enter data into it?
0
votes
0answers
11 views

Determining What Process Isn't Cleaning Semaphores

I was having the common issue of not being able to restart httpd because of a high number of locked semaphores. After clearing those and restarting httpd, I also doubled the semaphores. However, I'm ...
-1
votes
0answers
21 views

Write a query in SQL to find the names of departments with more than two employees are working [closed]

This code is working fine. select DPT_NAME from emp_department as e where DPT_CODE IN (select EMP_DEPT from emp_details where 2<( select count(*) from emp_details as a where a.EMP_DEPT=e....
0
votes
0answers
13 views

Cant connect to SQL Server 2008 from Window XP SP2 But work fine with SP3 and 7 and above?

Yesterday our windows server 2008 R2 Updated after 7 years! After that our Windows XP SP2 and Lower clients reported that the ERP software cant connect to server! But Windows 7 and above clients ...
0
votes
0answers
35 views

Backup on Share NFS fails - Windows Server 2008 R2

I've a network disk where backups are stored every night, but after some hour the backup fails with the following error: Executing the query "BACKUP DATABASE [foo] TO DISK = N'\\XXX.XX.XX...." ...
0
votes
1answer
66 views

changed the name of the computer - SQL server

i changed the computer name, and entered this commands in SQL server management studio (ssms) sp_dropserver <old_name>; sp_addserver <new_name>, local; i press this query select * ...
0
votes
1answer
60 views

Make SQL Server 2017 available over internet on Google Cloud Platform VM

I have set up a VM with Microsoft SQL Server 2017 installed on the Google Cloud Platform. I am able to access the server on the VM by using SQL Management Studio. The purpose of this server is for ...
0
votes
0answers
22 views

How to login to MS SQL Server using Ubuntu OS & ODBC with disabled SQL Server Authentication and only accept Windows Authentication?

It is only part of my problem but technically, I am trying to access an SQL Server with disabled SQL Server Authentication using ODBC connection string in Ubuntu OS. I already tried to connect with ...
0
votes
1answer
29 views

MsSQL Server for Linux: is SQLDMO / 2005 backward Compatibility available?

Is Ms SQL Server 2005 Backup Compatibility available in Linux environment? I'm trying to deploy a DB server, based on mssql-server 2017 under Linux, for an accounting software (namely InsERT GT, ...
0
votes
0answers
7 views

How to attach a sql db with blobs using a shared folder?

I use the following query for attaching a sql db: CREATE DATABASE [myDb] ON (FILENAME=N'C:\myDb\myDb.mdf'), (FILENAME=N'C:\myDb\myDb_log.ldf'), (FILENAME=N'C:\myDb\FILESTORE') FOR ATTACH In ...
0
votes
1answer
37 views

SQL Server ODBC Driver

When I create a new ODBC data source, I'm offered 4 different controllers to access SQL Server: ODBC Driver 13 for SQL Server (Version 2017.140.1000.169) SQL Server (Version 10.00.17763.01) SQL ...
0
votes
1answer
87 views

ADO NET Destination has failed to acquire the connection with the following error message: "Login failed for user

Created a SSIS package, it is running fine when I run it on premise but when i try to execute it from sql server agent it gives me error for login failed for user, I am using SQL authentication to ...
0
votes
0answers
19 views

SSMS doesn't open,doesn't show any errors but an error signal sounds

I have installed SQL Server 2017 and SSMS with it. It worked properly when i first opened ssms,but then it started not to open.The situation was just like I have described in title.I uninstalled both ...
1
vote
0answers
19 views

Nesting gMSA in security group for use in ACLs

I'm trying to solve a conundrum for my DBAs and developers. We have an application that is running under a gMSA (group managed service account) identity. This application needs to access a SQL ...
1
vote
1answer
46 views

Local Computer drives are not visible when creating backup through wizard

When I connect to a database on a remote server through SSMS running on my own computer and I follow the backup wizard for a database, none of my local computer drives are listed. All I can see are ...
0
votes
0answers
17 views

ASP.Net website on GoDaddy not connecting to the correct database

I have been assigned to transfer an ASP.NET website to a new host (GoDaddy). For some reason, the web application is not trying to connect to the new database specified in my connection string, and ...
0
votes
0answers
20 views

Log in to remote SQL Server as a domain user, but from computer outside domain

I have few Windows Servers (2016/2019), say WS1, WS2 and WS3, where WS1 is domain master and rest are within the domain. Each of those run separate SQL Server instance (2017). There are user accounts ...
1
vote
1answer
46 views

Best Practices for Deploying Microsoft SQL Server on AWS on EC2 instance with SSD storage

Does it makes sense to install SQL Server 2017 on one single SSD drive on m5.xlarge with tempdbs, databases, program files, backups and logs for best performance? According to Amazon EBS specs the ...
0
votes
0answers
16 views

deterministic or randomized encryption in SQL Server 2019 “Always Encrypted”

Example use case: We want to protect the privacy of potential patients, that is, keep their medical procedures, if any, from being divulged. Here is a simplistic schema to illuminate the issues that I ...
0
votes
0answers
7 views

What Windows server permissions are needed to manage an ASP.NET Core application on Windows 10

I am developing an ASP.NET Core application that uses a SQL Server database (on separate servers). The applications are being hosted on premises. The system admins are new to do this and would like me ...
0
votes
1answer
19 views

SQLLOGDIR token maps to wrong path

I've some jobs running, which use the SQLLOGDIR token. Currently it places output in the following location: D:\sql\MSSQL14.MSSQLSERVER\MSSQL\Log However, I'd like to log it to H:\ I've been into ...
0
votes
0answers
162 views

SQLSRV PDO driver on PHP 5.6 with Docker

I am trying to move a legacy application (CakePHP 2.5.5) running on PHP 5.6 to a Docker container but I can't get the PDO driver for Microsoft SQL Server to work. I have been searching around for ...
2
votes
0answers
57 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 ...
0
votes
1answer
13 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
20 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
21 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
11 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
81 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
21 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
16 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
193 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
119 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
30 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
16 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 ...
0
votes
1answer
16 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
18 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
63 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
49 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 ...
2
votes
0answers
59 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
27 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
42 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
38 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
88 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
233 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
18 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
86 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 ...