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
1 answer
4k views

"The 'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine. (System.Data)" after installing

Can anyone help me with this error. I have seen the question asked on here before, but none of the solutions or patches have so far worked. I am in the process of setting up a sql server for my work ...
2 votes
1 answer
4k views

How to force SQL server to use maximum network bandwidth

I have a program written in Delphi that uses SQL Server 2008 as database engine. I am on a p2p link provided by two nano station m5. When I run a specific query inside of the program, the network ...
2 votes
2 answers
4k views

Import-CSV with powershell using a variable path

I am trying to import a CSV file with powershell in a database, with the path defined in a variable. But it doesn't seem to work. $path = "C:\Users\Admin\Desktop\TestFolder\file.txt" Import-CSV -...
2 votes
2 answers
12k views

Cannot uninstall SQL Server 2005, no matter what I do

Windows 2003 Server R2 64 bit I do Control Panel, remove programs, and get: Setup failed.. the dialog box disappears so fast that I am unable to write down all the messages, but the items get the ...
1 vote
3 answers
5k views

Connect to SQL Server through SSH tunnel?

I'll preface this by saying that I'm not familiar with SSH and doing this sort of stuff, so I'm really looking for a whole explanation of how to go about this. I have an idea that I might be able to ...
0 votes
1 answer
4k views

SSMS 18.2 cannot create database diagram

As the title say, my SQL Server Management Studio cannot create database diagram as it keep show me an error is Index was outside the bounds of the array. How can I solve it? This is my SSMS version ...
2 votes
1 answer
336 views

Microsoft SQL Server 2014 Standard Edition - Minimum Setup

We have a corporate license for Microsoft SQL Server 2014 Standard Edition and for time to time I have to install (or re-install it) on different Servers and computers. The setup folder size is about ...
1 vote
2 answers
5k views

SQL Server Management Studio 2014 won't start: Exception has been thrown by the target of an invocation

I'm on Windows 7 Professional SP1. I just installed SQL Server Management Studio 2014 using the 64-bit download from Microsoft: SQLManagementStudio_x64_ENU.exe, and when I click on the shortcut in ...
1 vote
2 answers
5k views

Why I can't see the users that I have created

I have created 4 users on Active Directory Users and Computer: But I can't see the users on my computer management under "local users and groups" nor on my sql server! So, why I does not have "local ...
2 votes
2 answers
4k views

SQL Server Results to File Creates extra lines at end

When I route the output of my queries to a file, there are one or two blank lines at the bottom. When I run the query though SSMS (2008 or 2012), I get two extra blank lines. When I run the query ...
3 votes
1 answer
4k views

SQL Server 2012 Connecting to MS Access 2003

SQL Server 2012 - Access 32-bit 2003 - I can import the database, I don't understand why I can't link to it. SQL 2012 may have changed the connection string or something. I just installed SQL Server ...
-1 votes
1 answer
48 views

Add User to database that is on server canot be found

I have a SQL Server Express instance, 2 databases on the server 3 and 4. Server 4 has [IIS APPPOOL.NET v4.5] as a user I want to add [IIS APPPOOL.NET v4.5] as a user to Server 3. Cannot get Database ...
0 votes
0 answers
258 views

An error occurred but no ODBC error information was available

I have an odd issue with Excel 365 v16.0.16827.20278 installed on a host machine. When trying to access an ODBC source, used successfully by several other individuals, Excel throws the error An error ...
0 votes
1 answer
5k views

SQL server missing in ODBC

I installed a SQL Express server on a 32-bit Windows 2008 server r2. I installed this while installing a Phoenix fueling station program. When I am trying to add a user DSN in ODBC I am unable to find ...
0 votes
1 answer
57 views

Does't Attach Database sql Server 2008 r2

unfortunately delete F Drive from My pc . here location Sql 2008 R2(main DB) .mdf and .ldf file. anyway I recover with data recovery software All this file same drive and same folder. As like previous....
1 vote
1 answer
5k views

"Configuration file does not exist", Event ID 274

SQL Server 2014 Standard in Server 2012 r2 I installed SQL server 2014 in drive D: I get the following error: Microsoft SSIS Service: Registry setting specifying configuration file does not exist....
0 votes
3 answers
2k 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 ...
0 votes
0 answers
18 views

RDP Session Utilizing Connections from Multiple NICs on Local Computer

I apologize if this sounds complicated. We've recently setup a RDS for users to utilize an application that queries a SQL Database Server for security cameras setup at a manufacturing plant (located ...
-1 votes
1 answer
244 views

Attuinity connectors SSIS package migrate to SSIS 2022

I have 2015 SSIS solution with attuinity oracle connectors, I am unable to open the package in VS 2022 since it does not support attuinity any more, I get Object reference not set to instance of the ...
0 votes
1 answer
736 views

Invalid command line argument when install Microsoft SQL Server

Overall summary: Final result: Failed: see details below Exit code (Decimal): -2068052377 Start time: 2023-08-18 11:44:13 End time: ...
0 votes
0 answers
34 views

SQL Server Connection to Excel Workbook

Upon re-opening my excel workbook, the SQL Server connection and associated queries are not saved and unable to be refreshed. How do I resolve this issue? I am accessing the DB via a remote connection ...
0 votes
1 answer
269 views

Unable to access sql servers from host machine DNS issue

Bonjour, I'm trying to learn MS SQL Server Configuration: VMWARE 17 Pro - 3 VMs Windows Server 2019 with SQL Server 2019; Network Adapters: Ethernet0(Internet), VMware(static) ; VM Network : Host-Only ...
0 votes
0 answers
62 views

Program wont connect through OpenVPN

I have a MAC M1 that needs to run a windows native app (no MAC option of such app) and to do so I installed a Windows 11 arm x64 with VmWare Fusion - the app that runs needs to connect to SQL on my ...
0 votes
0 answers
452 views

Connect to a remote sql server without port forwarding

On our main office we have a Windows 10 Pc that has Sql server. Here we have the database. On another office ( that is not on local network ) we have another windows 10 Pc , with an application that ...
0 votes
0 answers
284 views

Setting up Windows server 2022 to VPN server

I'm trying to set up application and VPN connection on new Win Server 2022 like it's currently set up on old Win Server 2008 and I'm stuck...Basically I'm trying to mirror everything on Win Server ...
4 votes
3 answers
12k views

Is there a way to enable tcp/ip protocol through powershell script or sql script?

The context: I got a Vagrantfile to provision a VM, this VM have SQL-SERVER 2012, 2014, 2016 and 2017 installed. When I check on the SQL SERVER CONFIGURATION MANAGER I saw that in every SQL-SERVER ...
3 votes
1 answer
1k views

How can I activate the Linux version of Microsoft SQL Server 2022 Enterprise?

I followed the steps on the Microsoft website to install SQL Server 2022 on Ubuntu Server. After I entered the command on step 4 of the instructions to enter the setup wizard, I selected the ...
0 votes
0 answers
27 views

Can onenote have runners

Is there a way to make OneNote recognize snippet of code (of tsql) and execute sample (top 50 of the select) of the output and include the answer like jupyter for python? a. Native method to run a ...
0 votes
0 answers
193 views

Multiple values using the N prefix

I need to put multiple values in the @RefValue parameter to speed up the result: I tried : @RefValue = N'204' --205 ' however, it only returned the value of the register 204. Command: DECLARE @...
0 votes
0 answers
1k views

"Error encountered during SQL installation"

During my internship at a company that utilizes Sage software, I faced challenges while attempting to install Microsoft SQL Server, which is required for Sage. I encountered multiple errors during the ...
0 votes
1 answer
699 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 ...
0 votes
1 answer
208 views

Installed SQL Express on IaaS VM in Azure, SQL Virtual Machine resource appeared in resource group?

I installed SQL Express on a Windows Server VM in Azure, a few days later a new resource appeared in the RG with the same resource name of the VM but as a SQL Virtual Machine. I take it this won't ...
0 votes
0 answers
363 views

SQL Server database upgrade - 2016 to 2019

We upgraded our SQL server from 2016 to 2019. Now we need to upgrade/convert our custom 2016 database to make it 2019 compatible. What's the process? We are running SQL Server management studio 2019 ...
0 votes
1 answer
692 views

SSH tunnel to MS SQL Server works with PuTTY but not from ssh command line

I'm trying to create an SSH tunnel to MS SQL Server from my Windows 10 local computer. When I create a tunnel with PuTTY, it works flawlessly. But when I create the same tunnel in command line (...
0 votes
0 answers
2k views

VM and local network access with Port forwarding in UTM on M1

I'd like to connect a Win11 arm VM inside UTM on macOS M1 to a Win10 intel macbook pro in Bootcamp mode on my local network (wifi). I was advised to "use Emulated VLAN with port forwarding on and ...
0 votes
1 answer
601 views

Unable to import access database to SQL Server - unrecognized database format '.mdb'. (microsoft jet database engine)

I am trying to import .mdb (Access database file) to SQL Server. Adding the sys-admin privilege username and password also does not help and gives an error - not a valid account name or password.
0 votes
1 answer
765 views

Why can I no longer connect to SQL Server from another PC on my local network?

Why has a SQL Server client stopped connecting to SQL Server running on another node on my local network? This has been working correctly for a long time. The client PC (PC A) was connecting two days ...
1 vote
0 answers
113 views

SSRS Sql Server Reporting Server Custom Security 2019 exception in Windows Server 2019

I am facing a problem with respect to SSRS(Sql Server Reporting Server) 2019 Custom security Exception in windows server 2019. SSRS report works fine from winforms vb.net code in previous version of ...
0 votes
1 answer
54 views

Automate SQL Queries with a Config File

I am trying to generate a weekly list of reports, each in the form of a folder containing multiple excel files that use SQL queries. Is there a way to have a "config" file of some sort to ...
2 votes
2 answers
2k views

sqlcmd AAD token authentication fails with cannot discover user realm

I am trying to authenticate to Azure SQL database using AAD user account. According to the documentation I should use -G to enable AAD authentication and then pass the token via -P. So I try it with ...
0 votes
0 answers
58 views

Word shows error message when saving a docx on an SQL FILESTREAM

I have a SQL Server. I created access to a file stream table. I have a UNC path to the specific folder \Pc\mssqlserver\DBShare\Files. I can open the explorer and I can navigate through the subfolders ...
0 votes
1 answer
519 views

Problems connecting to database on remotesql.com

I have been using remotemysql.com as a remote database and have had issues attempting to log in since 1.5 days ago. I'm getting SQL connection error: connect ECONNREFUSED in my app and ...
1 vote
1 answer
2k 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....
0 votes
1 answer
208 views

Is it possible to have a replica for MS SQL multi cloud?

I have a task where a Microsoft SQL database which is hosted on an AWS Windows EC2 instance and will need to have a replica on Azure. This is so that a team who manages the Azure infrastructure can ...
4 votes
2 answers
3k views

Cannot open backup device '/home/ec2-user/db-name.bak'. Operating system error 2 (The system cannot find the file specified.)

Recently when I restore a database backup, I met a very strange issue. It failed when I restore from /homne/ec2-user/db-name.bak, and then succeeded when restore from /var/opt/mssql/backup/db-name.bak....
23 votes
2 answers
69k views

How to: Database Model in Visio 2013

I am unable to find the "Database Model" in Visio 2013 and upon linking an existing database to Visio, there is no option to Reverse Engineer. Where do I find this functionality?
0 votes
1 answer
1k views

What can cause PowerShell to not support "-As Datatables" in a Invoke-Sqlcmd query

I'm trying to track down a failure on a CI server. It's running a PowerShell command: $dt = Invoke-Sqlcmd -server $dbServer -database $dbName $sqlQueryReport -As DataTables -QueryTimeout 900 This ...
1 vote
1 answer
875 views

Connect to SQL Server instance via VPN from WSL2

I'm trying to connect to a SQL Server instance from WSL2 (Arch Linux) with this command: sqlcmd -S tcp:XX.XXX.XXX.XX\\stix -U service_stix -C But I get: Sqlcmd: Error: Microsoft ODBC Driver 18 for ...
0 votes
2 answers
620 views

What's the point of having mysql root password for root user?

As a root user on Fedora I have install mysql server with a mysql root password . Then I forgot the password and used sudo mysqld_safe --skip-grant-tables & and bypassed the password , did some ...
5 votes
4 answers
11k views

Cannot connect with Sql Server Studio: error 18456, state 8 -- but password is correct

Using Sql Studio Express (on a Windows 7-64 machine) to connect to three different Sql Server 2005 servers using Sql Server Authentication, I'm getting Error: 1846, State: 8. According to Link, this ...

1
2 3 4 5
16