12 votes
Accepted

Additional User Account, Windows Authentication in SQL Server Management Studio

You need to add the user with his/her required roles and permissions: In the SQL Server Management Studio, open Object Explorer Click Server_instance_name > Security > Logins Right-click Logins and ...
harrymc's user avatar
  • 479k
5 votes
Accepted

mssql error: The evaluation period has expired

It is important to understand that the Instructions for RedHat 7.3 and 7.4 apply to the applicable versions of CentOS. Since you didn't specify which version of CentOS you are using, I can only ...
Ramhound's user avatar
  • 42.9k
4 votes
Accepted

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

The source of the problem seems to be a broken installation of .Net 4.7.2 that occasionally happens with installing the 1803 Windows 10 Update. The only way I've managed to resolve this is with a ...
ysalmi's user avatar
  • 156
3 votes
Accepted

Convert DateTime with Decimal Time Longer Than 3 digits?

DATETIME2 is the SQL data type you're looking for. It takes seconds precision to 7 decimal places. TechNet gives full information, with examples comparing the various types here. The following will ...
BillP3rd's user avatar
  • 6,445
2 votes

Event log warning Registry setting specifying configuration file does not exist

For SQL Server 2014 registry key location is HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\120\SSIS\ServiceConfigFile (Default) registry value should be C:\Program Files\Microsoft SQL ...
J-M's user avatar
  • 166
2 votes

Why does it take so long for SQL Management Studio to connect?

For me, the problem was that my machine name was longer than is allowed by NETBIOS (15 characters). Once I shortened it, navigating SSMS became lightning fast. Windows warns you if you try to set your ...
Jeremy Prine's user avatar
2 votes

Why does it take so long for SQL Management Studio to connect?

The solution for me was to disable the Hyper-V NIC: Simply right-click and then click disable Update 2021: Problem came back. This time it was a reverse DNS entry that solved it.
RobIII's user avatar
  • 137
2 votes

Join 2 mssql queries

If you want to union, name the columns: SELECT COUNT(*) AS 'Column' FROM sysjobhistory WHERE run_status <> 1 AND step_id = 0 UNION SELECT MAX (run_date) AS 'Column' FROM sysjobhistory WHERE ...
Ryan Pavely's user avatar
2 votes
Accepted

How to reduce the database size of MS SQL server

The Process On your "production" server from within SSMS go to Server Properties > Database Settings on this instance of SQL Server and ensure the Compress database option is selected. Next delete or ...
Vomit IT - Chunky Mess Style's user avatar
2 votes
Accepted

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

At the top of your procedure block or before the slice of DML code you are working with, add the setting: SET NOCOUNT ON GO https://msdn.microsoft.com/en-us/library/ms189837.aspx This will prevent ...
Frank Thomas's user avatar
  • 36.1k
2 votes
Accepted

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

You could try to repair or even reinstall SSMS, but if it doesn't help, the fact that booting in Safe Mode fixes the problem might indicate that some third-party application is responsible for it. In ...
harrymc's user avatar
  • 479k
2 votes

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

I've add this exact problem before when filling out grades in an online spreadsheet. Assuming that it isn't caused by another program and is the result of windows itself, you might be able to globally ...
freebird's user avatar
  • 152
1 vote
Accepted

Cannot connect to reporting services from SSMS MSSQL 2017?

Whatever I fixed the problem in report server configuration manager I changed the web service and web portal url , I created a database from there , I ran ssms as administrator and voila it worked
Johnny Adams's user avatar
1 vote
Accepted

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

This is a valid connection set I just tested on my desktop: By the description in your question you only specified Server, Port and Username. Verify that you have all the other information. Please ...
Ronaldo's user avatar
  • 381
1 vote
Accepted

Can I add Maintenance Plan in SQL Server for Linux?

As you can read on Microsoft SQL Server documentation (here on the Known Issues section), maintenance plans are not supported on SQL Server Management Studio for SQL Server on Linux. However, you can ...
Alberto Morillo's user avatar
1 vote

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

sudo /opt/mssql/bin/mssql-conf set network.ipaddress 0.0.0.0 works too
Derek's user avatar
  • 11
1 vote

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

Ok, found a solution in environment vars. Just use sudo MSSQL_IP_ADDRESS=0.0.0.0 /opt/mssql/bin/mssql-conf setup This will also force config to bind to any <ipv4> after restart. Since this ...
mmix's user avatar
  • 111
1 vote

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

Installing Management Studio does not installs SQL Server database engine. You need to install SQL Server also.
Zeeshan's user avatar
  • 125
1 vote

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

Look for the culprit(s) You could run sp_WhoIsActive and see who is running what and look over the logic of those running processes/active transactions. Check to see if any T-SQL queries can be ...
Vomit IT - Chunky Mess Style's user avatar
1 vote

SQL query to find 3 consective records and rspective data

WITH cte AS ( SELECT series, date_time, value, LEAD(value) OVER (PARTITION BY series ORDER BY ...
Akina's user avatar
  • 3,215
1 vote

Network unreachable - MSSQL

fe80:: is a IPv6 link-local address, so that's not a public IP. Those can be used within a network, but not across routers. So if the fe80::... IP is the one you are using i'm positive it's not the ...
remote mind's user avatar
1 vote

Dbeaver export result set to multiple CSV files

As of today (2020-05) you can only split by file size, not number of rows. See https://github.com/dbeaver/dbeaver/issues/1646
motobói's user avatar
  • 752
1 vote

Connect to MS SQL Server on Arch Linux

found it. I had to run this command sudo /opt/mssql/bin/mssql-conf setup in order to set the password for the SA user. Now I can connect.
Vasileios Pallas's user avatar
1 vote

Unable to Install MSSQL Server on CentOS 7

I've just fixed this very same issue on a brand new Fedora 25 install, hosted on a chunky OVH server. It turns out that I had a broken symlink in /var: [tom@aaa ~]# ls -la /var lrwxrwxrwx. 1 ...
Thomas Buck's user avatar
1 vote

Compiling PHP 7 with mssql support

Since you mentioned php5-sybase, I'm guessing you are using Debian or something Debian-based. Debian 9 (Stretch) and Ubuntu 16.04 currently have php7.0-sybase packages. If you need it on anything ...
carlwgeorge's user avatar
1 vote
Accepted

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

Due to the environment, my only choice was to do a raw forwarding using iptables. As we had no DPI, everything was forward depending of 3 filters : Source Destination Port Also, as it had to be ...
Kaël's user avatar
  • 181
1 vote

User Friendly CSV to MSSQL import with column match

I'd suggest you look at Data Transformer (disclaimer - I'm its developer). It can convert CSV to SQL (and others). The generated SQL contains "insert" statements for each line and a "...
Geo Systems's user avatar
1 vote

Why does it take so long for SQL Management Studio to connect?

In my case it was not every time, but when it did, it would take 10 min to get back even my connection box. So I looked at Configuration manager and disabled shared memory. Works like charm every time ...
user61982's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible