Questions tagged [sql-server]

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. For the latter use the specific tag [ms-sql], or if related with a specific version with the relative tag [sql-server-2012], [sql-server-2008]...

Filter by
Sorted by
Tagged with
1 vote
0 answers
12 views

Excel ODBC connection to MS SQL server refresh issue

I've created an ODBC connection in Excel in order to create pivots on a large table held in MS SQL Server. The connection string looks like this: Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist ...
user avatar
  • 11
0 votes
0 answers
12 views

Save SQL Server 'Server Name' values when running SQL Server as user with different domain

So I need to periodically run SSMS as a user other than the windows user I am logged into my machine as. This user has a different domain than the user I am logged into my computer as, therefore what ...
user avatar
  • 1
1 vote
3 answers
70 views

Avoid Excel to chop off the last digits of my numbers

As indicated in this URL, the largest number Excel can handle is about 10^307. Nevertheless, Excel seems to have problems with smaller numbers too (about 10^17) as you can see from my example: I'm ...
user avatar
  • 1,438
0 votes
0 answers
15 views

Uninstall complitly and install SQLServer 2019

How can uninstall SQL Server 2019? I deleted each folder one by one and stopped all SQL Server related services. I can not delete again and again. These products that appear to be installed can not be ...
user avatar
  • 101
0 votes
1 answer
16 views

Advice about fixing SQL Server 2014 database performance

I noticed that a system I have in a production server is running slow so I start studying about the causes. This is a SQL Server 2014 database whose data file size is 361.472 KB and log file was 427....
user avatar
  • 265
0 votes
1 answer
65 views

Silent Install SQL without having to Restart

In short, I am running a silent install of SQL Server 2016 using a *.ini file. At the end of the installation, I must restart to use any sort of sqlcmd/invoke-sqlcmd to call a SQL file. Does anyone ...
user avatar
1 vote
1 answer
363 views

Setup Failed Fatal Error during installation (0x80070643) SSIS Projects

I installed Microsoft visual studio 2019 and wanted to add the SSIS extension but got the following error. Microsoft AS OLE DB Provider for SQL Server 2016: An error occurred during the installation ...
user avatar
  • 21
0 votes
0 answers
33 views

send email issue on SQL-Server 2014 using msdb.dbo.sp_send_dbmail function

I am using Windows OS 2016 and MS SQL 2014 without any service pack. Since last couple of days i am not able send email from SQL DB using msdb.dbo.sp_send_dbmail utility. There is no change on ...
user avatar
  • 1
0 votes
0 answers
22 views

How to mirror SQL Server databases into Salesforce automatically?

I'd like to mirror some SQL Server databases in Salesforce. (Mirror = "keep the data in Salesforce in sync with what's in SQL Server without me having to do anything much".) Does anyone know ...
user avatar
  • 151
0 votes
0 answers
153 views

ODBC with active directory password authentication using a login ID and password not configurable

The server MYSERVER holds the SQL database MyDatabase. The account MYCOMPANY\myaccount is registered for MyDatabase with server roles public and sysadmin and with permission Connect SQL granted by sa. ...
user avatar
  • 177
0 votes
0 answers
120 views

Painfully slow local development and MS-SQL connection

I know some may suggest that this question needs to be asked on StackOverFlow, but I do not believe this is not a Dev issue and probably an IT/Security thing. I have posted this on ServerFault as well....
user avatar
  • 115
0 votes
0 answers
30 views

Inplace Upgrade Windows Server 2012 with Sql Server 2014

Can I do an inplace upgrade from Windows Server 2012 R2 to Server 2016 if an SQL Server 2014 is install? Will the update break the sql server?
user avatar
0 votes
0 answers
26 views

MS-Access keeps stealing focus from VBA

When I'm working on MS Access VBA scripting, the Access application keeps stealing focus from VBA, even mid typing. So I will be typing code, there will be a pause, a brief lock up, and all of a ...
user avatar
0 votes
0 answers
22 views

How can I view non-default databases associated to a user in Microsoft Access

I have an AD user account nested in a group where the group was given access to several DBs (db_reader) on a SQL 2016 server, Excel is primarily used to interact with the data and when the user starts ...
user avatar
  • 1,166
-1 votes
1 answer
99 views

ERROR dbeaver on manjaro

i downloaded dbeaver from the aur but it failed to open . it gives : " version 1.8 of JVM is not suitable for this product . Version 11 or greater is required" but in the aur there is only ...
user avatar
0 votes
1 answer
22 views

Microsoft SQL server management studio 18 commandline replacement

I have created an SQL file for my SQL server. When I double-click on that, Microsoft SQL server Management Studio 18 is opened, username and password are asked, the query is opened and I can launch it....
user avatar
  • 1,438
0 votes
0 answers
194 views

SQL Server: error message "Value cannot be null. Parameter name: urn" while creating backup job script

I'm trying to create a script for a backup job in SQL Server Management Studio (SSMS). However, I face the error message Value cannot be null. Parameter name: urn. The workflow up to that point is: ...
user avatar
  • 177
0 votes
0 answers
104 views

SSDT with Visual Studio Professional Edition vs Enterprise Edition

We need to setup SSDT for SSIS on SQLServer 2019. We would like to understand what is the difference if we go for Visual Studio Professional edition versus Visual Studio Enterprise edition. I see no ...
user avatar
0 votes
1 answer
42 views

Group multiple excel rows just like SQL

I have some trading data as below : I want to group data on some columns and do sum for Quantity and Average for price. And output the data as SQL style like below. How can i achieve this in excel. ...
user avatar
  • 103
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
28 views

MariaDB: How do I load a copy of a table into RAM for frequent reading?

Colleagues, tell me how to keep a copy of the table in RAM? I have a database server on MariaDB. One of its databases contains a small table - about five fields and several dozen records. The records ...
user avatar
  • 1
0 votes
0 answers
38 views

SQL Availability Group Failover Automation through PowerShell - Slow response

I am trying to automate the process of failing over AGs on SQL Server 2017 and I run the below command remotely through PowerShell over remoting (port 5985) Invoke-Sqlcmd -ServerInstance .\INSTANCE01 -...
user avatar
  • 125
0 votes
0 answers
16 views

SQL Server Ubuntu: connect to the dualboot windows SQL server from ubuntu

I installed SQL Server and SSMS on my Windows 10. I started SSMS and played a little with databases. But I have Dual Boot and I installed SQL Server and Azure Studio on my other OS: Linux Lite 5.4 (...
user avatar
0 votes
0 answers
180 views

SQLCMD Error 0xc000007b

The Environment: Windows Server 2019 Standard SQL Server 2019 Standard SQL CMDLINE Utitlies V15 for x64 ODBC Driver 17 for x64 The Problem: I am trying to run the sqlcmd command in Powershell and ...
user avatar
  • 395
1 vote
1 answer
180 views

MS SQL Server: Windows authentication works from a local account but not from an MS account

I use MS SQL Server Management Studio to work on a database using Windows authentication from my home Win64 laptop computer. If I log my laptop to a local Windows account ("LocalAag"), I ...
user avatar
  • 139
1 vote
2 answers
197 views

Sysprep removes all SQL users

I have two instances running on SQL Server (2017) - SQLEXPRESS and MYINSTANCE I've added a few users to MYINSTANCE However when I run Sysprep on the device, it deletes all but sa and Builtin\Users. It ...
user avatar
  • 225
0 votes
0 answers
16 views

Use MS 365 Business accounts as login to SQL Server via Windows Authentication?

Company uses MS 365 Business for online features provided by MS such as Exchange Online, OneDrive, SharePoint. We have few servers that run MSSQL Servers that host databases for some of our business ...
user avatar
  • 101
0 votes
1 answer
92 views

"Operating System is not configured to use this application" when migrating a DB using the Access SQL server migration assistant

I have (re)installed Microsoft SQL Server migration assistant latest version today, and i have installed Ms SQL server Management studio 18 in order to migrate my accdb access database from Access to ...
user avatar
0 votes
0 answers
48 views

Error compiling GnuCOBOL with embedded SQL

I'm trying to compile a GnuCobol with embedded SQL. I installed OpenCobolIDE 4.7.6 on Windows 10 and followed the steps indicated in GNUCOBOL with embedded sql runtime error : module '...
user avatar
-1 votes
1 answer
252 views

What is the difference between "client-server" and „file-server“ database? [closed]

I am trying to answer a question put on the exam but cannot find answer that is precise enough. Please help to understand what are the major difference between "client-server" database such ...
user avatar
  • 123
1 vote
1 answer
140 views

How can I share an Excel sheet with embedded SQL queries with another user without asking them for log-in credentials?

I created an Excel (Microsoft 365) sheet for a (non-tech-savvy) coworker that pulls data from a SQL database. However, he is not able to refresh the queries (by hitting 'Refresh All') on his machine ...
user avatar
  • 11
2 votes
1 answer
23 views

Can I separate some tables in my SQL DB for backups?

I've got a large database with many tables. Numbers not important. MSSQL 2017 (14.0.2037.2) on Server 2016 that I have full control of. A huge amount of my data is in two or three tables. Imagine you ...
user avatar
0 votes
0 answers
809 views

Unable to install MS SQL Server or SSMS due to missing DLL, how do I find and install this DLL?

I have the exact issue as the OP of this question but their fix did not work for me: Related Stack Overflow Question I need to install MS SQL Server and SQL Server Management Studio on my computer. No ...
user avatar
0 votes
2 answers
320 views

Is NT SERVICE a local or shared network domain account?

The sql agent job runs under the NT SERVICE/InstanceName account. Is the NT SERVICE domain private to the current computer or is it shared across all computers in the network?
user avatar
  • 182
0 votes
1 answer
67 views

Is it possible to use sp_addrolemember on a SQL Server database without Management Studio? Only using sqlcmd

I’m trying to avoid installing Management Studio on multiple servers. Is it possible to add Sp_addrolemember to a database only using sqlcmd? I tried: sqlcmd -S .\SQLEXPRESS -E USE [DBName] EXEC ...
user avatar
  • 57
0 votes
1 answer
48 views

Excel to access file data tranfer by SQL server

I have an issue While Transfer Data From Ms Excel to MS Access by SQL Server here is my program Public Sub DoTrans() DoEvents Sheets("Temp").Select Set cn = CreateObject("ADODB....
user avatar
  • 113
0 votes
1 answer
17 views

Hello is there are keyboard shortcut for switching to the messages tab?

I have looking around by a lot but I did not find anythink. Any ideas?
user avatar
0 votes
1 answer
123 views

From Powershell, Open Multiple SQL files in a single SSMS Instance

I have an automated Powershell process that ends with an Invoke-Item command to open multiple SQL files (currently 4 SQL files) for the testers, so they can run their scripts. Keep in mind, I am not ...
user avatar
  • 434
0 votes
1 answer
27 views

What are the real risks of making a Azure SQL DB accessible for all Azure Services?

This is more of a general question regarding network security which came up while I was brainstorming about SQL Databases on Azure. When you configure a SQL Database you have the Option to make the ...
user avatar
  • 3
0 votes
2 answers
9k views

How to remove SQL Server completely?

I have faulty installatinon of SQL Server and want to remove it completely. The problem is there are too many entries in Apps & features in control panel (Uninstall programs). I followed this ...
user avatar
  • 1,581
1 vote
1 answer
506 views

C drive getting full in windows 10 for no reason

I had 37 GB free on my main OS drive (C:) in my 512 GB SSD hard-drive. I installed a 2nd 1 TB drive anticipating needing more disk space soon. Just in few days c:\ drive got full for no apparent ...
user avatar
  • 1,581
1 vote
0 answers
16 views

Some Virus is creating "Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\SqlManagement" folder again and again [duplicate]

c:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\SqlManagement folder is creating again and again in our Windows server 2008 R2. SqlManagement folder contains some files with ...
user avatar
0 votes
1 answer
168 views

How can I make SQL Server 2017 retry to start if startup fails?

We have a SQL Server that is used internally for testing. We shut down the server every night to save on Azure costs. Sometimes it fails to startup due to the paths it uses not being available like ...
user avatar
  • 469
0 votes
1 answer
70 views

Date Calculation

I have a Date range, 2020-11-25 as Start Date 2020-12-10 as End date I wanted to get the count of December month days in the above Date range if I am looking for December month.(I need the output as ...
user avatar
  • 3
0 votes
1 answer
1k views

SQL Server Job - Login failed for user

I am trying to run a SQL Server job nightly, but I am getting an error. executed as user: NT SERVICE\SQLSERVERAGENT. Login failed for user 'SERVER\INSTANCE$'. [SQLSTATE 28000](Error 18456) The job is ...
user avatar
  • 209
0 votes
1 answer
2k views

SSIS package runs fine in Visual studio but not in SSISDB

I have a SSIS package developed in Visual studio 2019, but then as the server has got only version 2016, so Changed my package to 2016 and deployed. I am using ODBC source to connect to MYSQL database ...
user avatar
  • 3
0 votes
1 answer
69 views

Dates in between the Date Range - SQL Server

I have a table which holds: PlaceID, STARTDATE, ENDDATE, OCCUPANCY 100, Jan 1, Jan 10, Occupied 100, Jan 15, Jan 20, Occupied 100, Jan 11, Jan 14, Empty 100, Jan 21, Jan 31, Empty 200, Jan ...
user avatar
  • 3
0 votes
1 answer
80 views

On an VDI that allows multiple users to connect at a time, how can I configure SQL to run with a different port for each user?

I am trying to launch an application named Aura, which uses SQL as its database engine, in a VDI that allows multiple users to connect at the same time. When the program is first launch, it works fine,...
user avatar
0 votes
1 answer
44 views

SQL Server started, but SQL Server Management Studio not connecting to it

Problem statement I have installed (Developer Edtion) and started my SQL Server, but when trying to connect to it through SQL Server Management Studio, it shows this error: My configuration for SQL ...
user avatar
-1 votes
1 answer
2k views

SSIS Error - ODBC Source

I am using ODBC connection to connect to MYSQL in SSIS - the connection is successful, but when the SSIS package is executed, I get the below error. [ODBC Source [30]] Error: SQLSTATE: 22018, Message: ...
user avatar
  • 3

1
2 3 4 5
15