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]...
768
questions
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 ...