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
40 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
46 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
26 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
26 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
0answers
39 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
18 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
17 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
45 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
16 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
7 views

How to delete SQL Server Database Mail history WITHOUT stored procedures [migrated]

This is really straight forward. The documented way to delete Database mail history in SQL server is to use the following two stored procedures:sysmail_delete_mailitems_sp and sysmail_delete_log_sp ...
0
votes
0answers
18 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
41 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
11 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
18 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
88 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
52 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
0answers
9 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
19 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
17 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
8 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
79 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
19 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
115 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
89 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
24 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 ...
0
votes
1answer
15 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
15 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
54 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
47 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
51 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
25 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
40 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
37 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
64 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
197 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
78 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
11 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
35 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
14 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
19 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
88 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
28 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 ...