2022 Developer Survey is open! Take survey.

Questions tagged [ms-sql]

Use this tag for questions related to the MS SQL Server, the management relational database by Microsoft. Tag with [sql-server] the question related to each database server that implements SQL (Structured Query Language) and not related with the specific Microsoft one. Do not confuse it with [mysql], the Oracle's one. Tag questions specific to a version with [sql-server-2012], [sql-server-2008]...

Filter by
Sorted by
Tagged with
0 votes
0 answers
5 views

Subscribe option missing on linked report

We are running SSRS in native mode on SQL2016. I have deployed a report from Visual Studio that uses a shared data source and that datasource saves sql credentials. When I right click the report I get ...
user avatar
  • 101
0 votes
0 answers
31 views

Change bash to replace string in all future commands or edit mssql server to accept network drives

I'm currently trying to get MSSQL on Ubuntu 20.04 to work with omega software (https://www.kros.sk/omega/). It's industry standard for accounting in my country but it can't be found outside of it. And ...
user avatar
0 votes
0 answers
273 views

WikiJs installation wizard is not continuing on during the installation

I use windows as os, mssql as database I've downloaded wikijs 2.5.274 .tar.gz file I've extracted the files into C:\wiki folder I've created database which named wiki I've changed the config....
user avatar
0 votes
0 answers
24 views

SQL Database Restore

I am having an issue with restoring a database over another database. So our setup is that we have clients, and they have a live database and a test database. Occasionally we will need to copy the ...
user avatar
  • 1
0 votes
0 answers
16 views

MDT Allow Passwords in logs

I'm trying to troubleshoot why my MDT deployment can't connect to the SQL server to query some info during deployment. So I have my ZTIGather.log file. And in it there is OPENING STANDARD SECURITY ...
user avatar
  • 620
0 votes
1 answer
29 views

SQL management studio actions through GUI usually giving errors when SQL commands aren't

This is a bit of a noob question: while using SQL server management studio many times when I'm performing actions such as, for example, changing data type (a non primary/foreign key text field from ...
user avatar
0 votes
0 answers
22 views

Altium default sorting order when using SQL Database Libary for components

We are planning to migrate from MS-Access Database Libraries for our components to a company-wide SQL server (MS SQL) to use it with Altium 20/21. So far I have managed to connect to the SQL server ...
user avatar
0 votes
0 answers
37 views

MSSql Database randomly not answering

We have a 32 Bit production machine that has MS SQL 2014 installed. 32 Bit is forced by twincat 2 running on it, (not compatible with 64 bit), thus the available ram is limited. Randomly, about twice ...
user avatar
0 votes
0 answers
139 views

SQL Server 2017 - High CPU usage after service start

For a long period now we have an issue after a reboot of the host OS or restart of SQL Server 2017 service that the sqlservr.exe process takes 100% CPU. It uses so much CPU it is almost impossible to ...
user avatar
  • 161
6 votes
3 answers
2k views

How to mute windows beep sound in SSMS 18.5 everytime you tab in the table designer?

FOUND THE ISSUE: Seems it's not a known bug and I've reported it on their Uservoice. This seems to happen only on SSMS 18.3.1 onwards up to SSMS 18.5. On SSMS 18.2 and lower the issue does not happen. ...
user avatar
  • 249
0 votes
1 answer
424 views

Connecting Azure Data Studio to Microsoft SQL Express fails with connection error: Invalid argument

I am running Microsoft SQL Express in a docker container on a Linux VM on my mac. In order to make the VM available from my mac, there is some port forwarding necessary, since Virtualbox uses NAT on ...
user avatar
  • 411
0 votes
1 answer
1k views

Cannot connect to reporting services from SSMS MSSQL 2017?

I have installed MSSQL Server on localhost although when I try to open reporting services from ssms v18.3.1 I get the following error message: Unable to connect to the server at DOMAIN\SSRS. The ...
user avatar
0 votes
1 answer
965 views

MSSQL Reporting Server slow on first connection

I'm relatively new to the MSSQL world, and we have a newly installed reporting server that is in an availability group. The first time any report is executed, it seems to take about 30-40 seconds to ...
user avatar
0 votes
0 answers
141 views

T-SQL Error Messages in Visual Studio 2019 not showing anymore

I would like some suggestions if this could be fixed you I need to fix/re-install Visual Studio. The error messages were visible a few days ago. I am using Visual Studio for SQL queries for two weeks ...
user avatar
1 vote
1 answer
2k views

Why am I unable to access Object Explorer in Microsoft SQL Server Management Studio?

For reference, I am using MS-SSMS version 14.0.17289.0 and I have Microsoft Visual Studio 2019 installed, on Windows 10. I am unable to locate or open Object Explorer. I have installed the Microsoft ...
user avatar
0 votes
0 answers
13 views

MS SQL use trigger to update field

I have a table with fields for length, width, and area. I want to use a trigger to calculate the area when a new record is inserted or an existing record is updated. How do I do this?
user avatar
0 votes
1 answer
708 views

Trying to get a local MSSQL server for SQLTools plugin for vscode working under linux

I enrolled in a DBMS course in college, the professor has been explicitly using MySQL. The labs have Ubuntu and Windows on dual boot, but the Windows installation is old and really slow. I have been ...
user avatar
  • 160
2 votes
0 answers
47 views

Restore an SQL database from FTP to Google Cloud

I have an FTP site from a third-party vendor that updates with weekly .bak files and daily .diff files for a Microsoft SQL 2016 database. I do not have access to the original database. My eventual ...
user avatar
1 vote
1 answer
2k views

Can I add Maintenance Plan in SQL Server for Linux?

I am using SQL Server 2017 for Linux, and the Maintenance Plans are missing from the Management menu. Does anyone knows if the Maintenance Plans are available for SQL Server for Linux? I can't find ...
user avatar
  • 113
1 vote
0 answers
19 views

Getting randomly non English character in SQL

Getting some random non English character when I execute DBCC CHECKCONSTRAINTS WITH ALL_CONSTRAINTS in MS SQL database. Some time it's work or some time not. Some errors are : The multi-part ...
user avatar
0 votes
1 answer
55 views

Connection to MSSQL timed out

from a Kubernetes Linux pod, i am trying to establish a MSSQL connection to a Windows Server on Port 1433. I have full admin access to all the machines. I already made sure that the SQL Server ...
user avatar
  • 111
0 votes
2 answers
1k views

Force SQL Server 2019/Ubunti to use ipv4 instead of ipv6

We are testing usability of Microsoft's SQL Server on Linux servers for our internal products, and we ran into a bump during config. We are trying to setup and configure SQLServer 2019 (preview) and ...
user avatar
  • 111
0 votes
1 answer
2k views

not able to connect to localhost in MS SQL Management Studio 2017

I have installed MS SQL Server Management Studio 2017. After installing, when I try to connect to the local host by typing either "127.0.0.1" or "local" or "." (dot) in ...
user avatar
1 vote
1 answer
1k views

How can sql server log space used be more than 100 percent?

We are seeing application errors (exceptions) that report the transaction log "is full due to ACTIVE_TRANSACTION". There are no pending transactions reported by DBCC OPENTRAN. Running DBCC SQLPERF('...
user avatar
  • 11
2 votes
1 answer
1k views

MS SQL on Ubuntu 18.04 configuration setup not working as expected

I am trying to install MS SQL server on Ubuntu 18.04. Everything went fine until I ran sudo /opt/mssql/bin/mssql-conf setup First I got: usermod: no changes Choose an edition of SQL Server: 1) ...
user avatar
1 vote
1 answer
20 views

SQL query to find 3 consective records and rspective data

Need to pick the data where values are >=0.7 and appearing at least 3 consecutive times then hourly recorded per day Hours 00 0100 0200 0300 0400 0500 ValueNumber .7 ...
user avatar
  • 11
0 votes
1 answer
1k views

MS ODBC SQL Driver 13 version issue, How do I get/install a newer version?

It simply seems that MS has not updated their download site to have the most up to date version of the version 13 ODBC driver. When I download the MS SQL ODBC driver 13 from the Microsoft site, it ...
user avatar
6 votes
1 answer
15k views

Additional User Account, Windows Authentication in SQL Server Management Studio

I am transitioning my work laptop to a coworker (who we'll call Mary Smith) who is taking my place on my team as I move on to other things. One of the tools we use is Microsoft SQL Server Management ...
user avatar
1 vote
0 answers
36 views

Intermittent issues connecting to a SQL CE Database

I'm trying to work on a local development copy of a website in Visual Studio 2017. This website uses a SQL CE database in an .MDF file, and I run the site locally through VS using IIS Express. When I ...
user avatar
  • 11
1 vote
1 answer
81 views

PHP 7.0 round function and MsSQL módule

I've a Debian server that acts as web server. Recently I've needed to install the MsSQL module to use a Microsft SQL Server as source, but after install it I've noticed that php round function has ...
user avatar
1 vote
0 answers
568 views

Can't connect SQL Server when EXE is run from network share

After last update of Windows 10, one program is not connecting to SQL Server when its executable is started from network share (e.g. \\192.168.1.2\share\the_tool.exe). When it is copied to local HDD,...
user avatar
  • 160
1 vote
0 answers
426 views

Security concerns with users created for R scripts in SQL Server

As discussed in this question and this MSDN forum post, installing R with a Microsoft SQL Server 2017 installation (possibly other versions) creates 20 users in the SQLRUserGroup. As explained in the ...
user avatar
  • 11
2 votes
0 answers
27 views

Anyone have success configured MySQL linked servers on SQL Server 2017 for Linux?

I am trying to figure out if SQL Server 2017 for Linux supports linked servers for MySQL? I know its possible on Windows OS if ODBC/OLEDB drivers are configured on the same server as SQL, but ...
user avatar
3 votes
1 answer
971 views

PowerShell SqlServer module only imports functions and aliases, but no cmdlets

I am trying to use the SqlServer PowerShell module, available on the PowerShell Gallery. After installing, either to -Scope CurrentUser or in an admin session, doing Import-Module SqlServer only ...
user avatar
  • 5,751
1 vote
0 answers
2k views

[unixODBC][Driver Manager]Can't open lib '/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.1.so.0.1

I am trying to run windows command line program that uses ODBC to connect to a remote MSSQL server. It works fine in Windows 10. Now I want to run the same program in Linux using Wine. I have ...
user avatar
  • 111
1 vote
1 answer
2k views

How to reduce the database size of MS SQL server

I have a website that runs on MS SQL Server 2014 Enterprise with two clustered virtual machines and AlwaysOn. A database backup is created each night and the size is now 20GB. On my laptop, I also ...
user avatar
  • 161
1 vote
0 answers
83 views

Can I save 'Outlining in my MS SQL Query

When writing a query, I will often use Cross Apply, or multiple sub queries. To make the query easy to read I realized you can outline parts of the query, and then hide them. Using: Edit -> ...
user avatar
  • 7,136
1 vote
1 answer
3k views

mssql error: The evaluation period has expired

I am trying to install MSSQL on Centos. I followed the article here. I typed the following command to configure mssql to set a password etc. sudo /opt/mssql/bin/mssql-conf setup I got the following ...
user avatar
  • 43
2 votes
1 answer
6k views

Dbeaver export result set to multiple CSV files

I'm using the latest version of DBeaver on Mac, querying against a remote MSSQL database and I've got a query that results in 24 million rows. I need to get this data into CSV format, but rather than ...
user avatar
  • 121
1 vote
1 answer
4k views

Connect to MS SQL Server on Arch Linux

I installed on my arch machine mssql-server and mssql-tools via yaourt. I started the server from /opt/mssql/bin/sqlservr and tried to connect with my credentials, but with no luck. I found this ...
user avatar
1 vote
2 answers
2k views

Unable to Install MSSQL Server on CentOS 7

I was following along with: Install SQL Server on Red Hat Enterprise Linux and I ran into the following error at the configuration portion: Setting system administrator (SA) account password... ...
user avatar
0 votes
0 answers
55 views

Last Week Job Schedule

I'm looking for a way to scheduled MSSQL jobs to run only on the last week of the month? I see the current options are daily,weekly or month, When selecting monthly, you can select the day number, ...
user avatar
  • 492
2 votes
1 answer
526 views

In Microsoft SQL Server, how can I disable "X rows affected" at the end of my output?

I'm querying a database in Microsoft SQL Server and writing the output to a csv file. When importing the outputdata into another program i get an error because the last line of my output file ...
user avatar
0 votes
2 answers
647 views

Edit multiple rows in MSSQL ".rpt" file

I have a report from MSSQL, that has been exported to an .rpt format. I have installed the necessary addons to open and edit the file in excel, however one such report has come out strangely. For ...
user avatar
  • 1,152
-1 votes
1 answer
4k views

How to troubleshoot Microsoft VBScript runtime error '800a0046' Permission denied?

The line the error formulates from is: Set newfolder = filesys.CreateFolder(Server.MapPath(newfolderpath)). Here is the code below: If Request.Form("add")= "true" then Dim prop, user, pwd, dir ...
user avatar
0 votes
2 answers
361 views

Network unreachable - MSSQL

I am trying to connect remotely to a sql server 2008. I am able to make the connection with the local ip address (I am doing so from terminal in a linux os connected to the local network, using ...
user avatar
1 vote
1 answer
64 views

MS SQL Server query which split to other table columns

I have two tables: table1: Manager | USER --------+------ John | Tom John | David John | Marry James | Henry table2: Now is empty, but must be like this: Manager | User1 | User2 | ...
user avatar
3 votes
1 answer
4k views

Convert DateTime with Decimal Time Longer Than 3 digits?

I'm trying to import some data from CSV into MS SQL 2008 Server. I'm using PowerShell's Invoke-SQL, and an SQL script that utilizes BULK INSERT. CSV fields get imported as VarChars and I'm trying to ...
user avatar
5 votes
1 answer
3k views

Compiling PHP 7 with mssql support

So I'm trying to switch to PHP 7. Unfortunately I'm in need to connect to an MSSQL Server so I'll need the dblib driver for pdo. With PHP5 you could ust the php5-sybase Package. So I tried to do it ...
user avatar
  • 101
0 votes
1 answer
1k views

Squid reverse proxy, DMZ, how to forward any non-http request

I'm actually facing an issue with some network-protocol related problem. I have my own domain, a owned DMZ, and externals users. In my DMZ, I have a reverse proxy who handle HTTP connection very well....
user avatar
  • 161