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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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.
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 ...
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 ...
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 ...
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 ...
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 ...
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
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 ...
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 ...
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
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 ...
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.
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 ...
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 ...
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 ...
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
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.
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 ...
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 ...
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 ...
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 "...
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 ...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
ms-sql × 90sql-server × 21
sql × 9
linux × 7
database × 5
sql-server-2008 × 5
ssms × 5
windows-10 × 4
networking × 4
backup × 4
query × 4
odbc × 4
microsoft-excel × 3
ubuntu × 3
php × 3
csv × 3
windows × 2
windows-7 × 2
windows-xp × 2
powershell × 2
installation × 2
centos × 2
user-accounts × 2
docker × 2
visual-studio × 2