People who code: we want your input. Take the Survey

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
0
votes
0answers
5 views

Impact of scaling Azure SQL elastic pool on existing connections

I have an Azure SQL SQL elastic pool configured for a few hundred databases with shared compute and storage resources. Every day, we initiate a scale process where we upgrade the compute power of the ...
0
votes
0answers
8 views

how to set SQL server db connection timeout and query timeout in java [migrated]

Im trying to set db connection timeout and query timeout Here is my Code import java.sql.Connection; import java.sql.DatabaseMetaData; import java.sql.DriverManager; import java.sql.PreparedStatement; ...
0
votes
0answers
12 views

SSIS Runs package correctly in visual studio, deployed to sql server fails in job execution

SSIS Runs package correctly in visual studio community 2019, deployed to SQL Server 2014 fails in job execution. SSIS package contains two connections. first connection to data warehouse used in T-...
2
votes
1answer
17 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 ...
0
votes
0answers
17 views

15 Minute SQL job stops overnight during Veeam Backup, must be manually restarted

I've tried digging into this from both the Veeam side and the SQL side but here is a strange issue. Windows 2012 R2 server running SQL 2014. Job runs every 15 minutes; imports from another database ...
0
votes
0answers
25 views

MS Access sub-form combobox disappears when linked to SQL Server table

I have an MS Access frontend with both an Access and SQL Server 2019 backend. I am converting the Access backend to a SQL Server 2019. However, when I switch my source table tblFiresCostEstimates from ...
0
votes
0answers
30 views

The process “openvpn-gui.exe” not found

I'm trying to run the OpenVPN through SqlAgent using a batch file for this. When I run it on CMD everything works fine, but when I run the job , the step failed with the follow message: The process &...
0
votes
0answers
98 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 ...
0
votes
0answers
15 views

Technical limitations when using Windows 10 as the Host OS for running Sql Server Standard edition

SQL Server 2014 Standard edition shows Windows 10 as compatible OS. SQL Server allows a maximum 32767 concurrent connections concurrent connections, but Windows 10 OS has a limit on concurrent ...
0
votes
2answers
31 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?
0
votes
0answers
23 views

How to open .bin SQL file

I'm stuck and not sure if somebody had similar issue. I have an old database stored as .bin files. It relates back to 2012. I can see an xml catalogue file which indicates to me that it is sql data ...
0
votes
1answer
30 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 ...
0
votes
0answers
13 views

Continuous windows events 4648 and 4624 generated when ODBC driver is configured with Integrated windows authentication

We are running a C# application in my VM,which is configured to run as a windows service. The service runs as local system account and talks to a locally installed SQL database server. I have access ...
0
votes
1answer
39 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....
0
votes
0answers
20 views

How to connect Amazon Seller Central to SQL Database?

I am a seller on Amazon USA with the seller account. We have access to the dashboard data and can also export data in .csv format. But this is a slow and painful process. I am learning SQL and I am ...
0
votes
1answer
14 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?
0
votes
0answers
12 views

Connect to non-local SQL Server using ODBC

We have an accounting software that uses SQL Server as the database. We currently host the database in house but are moving it to another off site location. I currently have several excel ...
0
votes
1answer
61 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 ...
0
votes
1answer
19 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 ...
0
votes
1answer
1k 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 ...
1
vote
1answer
329 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 ...
0
votes
0answers
85 views

SQL Server Management Studio (SSMS) Setup Failed (0x800B010C)

I am trying to install SSMS on my Windows 10 machine. However, any version 18.0 or greater gives me an error: "A certificate was explicitly revoked by its issuer (0x800B010C). With version 18.0, ...
0
votes
0answers
334 views

How can I open this file: Windows NTbackup archive NT, with file catalog, soft size 1*512, software (0x1200): Microsoft SQL Server

I've an extensionless file of about 100 MB. I tried to open it, but it's binary. I got the file type: $ file demo demo: Windows NTbackup archive NT, with file catalog, soft size 1*512, software (...
0
votes
0answers
311 views

unable to install sql server 2019 on window 10

after downloading and installation I got this error Opps Unable to install SQL Server (setup exe) Exit code (decimal): -2068052294 Error description : there is a problem with this installer package, ...
0
votes
0answers
35 views

SQL Server generating 1G dump files

I have a SQL Server generating large dump (mdmp) files, some of them are 1 GB in size, these are generated daily, sometimes 2 or 3 in a single day. This server is used heavily for PowerBI reports. ...
0
votes
0answers
10 views

SQL Profiler Starts but Doesn't Show on Screen

When I start a SQL Profiler session the splash screen shows, the login prompt shows, but when the actual session "starts" the SQL Profile window is non-existent. I can see the application ...
1
vote
0answers
13 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 ...
0
votes
0answers
15 views

Connecting to a remote server in a distanced computer

A couple of months ago, I have established a server which consists of a database server(VM) and a domain server. However, my goal is to able to manage the warehouse and biometric fingerprint scanner. ...
0
votes
1answer
74 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 ...
0
votes
1answer
68 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 ...
0
votes
0answers
115 views

Connect to SQL server from batch file

I have a batch file that I use to start application from Win 7 client. It will connect to remote SQL Server and start application. It looks like this pushd \\<server>\MITRE\SoftwareReleases\v23-...
0
votes
1answer
308 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 ...
0
votes
1answer
816 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 ...
0
votes
1answer
26 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 ...
0
votes
0answers
21 views

Connect to Azure SQL Database

I have an Azure SQL Server that includes one custom database (let's call it my_db). Up to this point, I've been accessing this database using my server password. However, I want to make it more secure....
0
votes
1answer
39 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,...
0
votes
1answer
30 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 ...
-1
votes
1answer
673 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: ...
0
votes
0answers
284 views

SSIS fails in Integration Services Catalog

The SSIS package is Deployed in Integration Services catalog and a SQL Agent Job is created. The Job Fails giving the error - 'Could not create a managed connection manager', But the SSIS runs fine in ...
0
votes
1answer
65 views

SQL Server 2019 Local Instance

I connected to my SQL Server Local Instance yesterday using windows authentication. But today I am not able to connect and getting the error - Error Number: 18456 Severity: 14 State: 5 Line Number: ...
0
votes
0answers
54 views

How to connect SQL Server 2014 via Static IP?

This question might be duplicate but I read a lot of questions present on internet but still can't get a solution. I have successfully created the connection of my server. But I am facing problems ...
0
votes
2answers
155 views

Trouble opening ports in SQL Server 2019 Express - WMI Error [0x80071779]

Update: Going back one version to SQL Server 2017 Express allowed me to save TCP/IP ports and IP addresses entered in SQL Server Configuration Manager. None of these variables were saved in the ...
0
votes
1answer
93 views

Allow remote computer access to SQL Server via SQL Server Management Studio

I have both SQL Server and Windows on version 2016. I am trying to set the firewall to allow SQL Server Management Studio to connect from my PC to it. I have created an entry for port 1433 TCP local ...
0
votes
2answers
80 views

Is it safe to kill and uninstall sqlserver.exe?

I am a student who mainly works with Visual Studio/Visual Studio Code/Emacs. I think the SQL server was installed with visual studio. I don't really do anything related to SQL servers and especially ...
1
vote
3answers
3k views

How to downgrade MS SQL Server 2019 Enterprise (evaluation) to Standard (purchased)?

SQL Server 2019 was installed in evaluation edition. When entering the activation code for a purchased copy of Standard edition I received the following message: I entered the activation code that is ...
0
votes
0answers
268 views

Can't connect from Excel to SQL Server 2017 on Windows / On Mac it works

I have the following setup: A Windows Server running SQL Server 2017 joined to a domain. Some groups of the AD Domain have the permission set to sysadmin and public. When I open Excel (Version 1908) ...
0
votes
1answer
69 views

Is it safe to only use the Public firewall on a Windows 7 computer with SQL server which has no connectivity to the Internet?

One of our Windows 7 computer with SQL server installed on it only uses the Public firewall because other computers on the network cannot access the SQL server if the private firewall is turned on. Is ...
0
votes
1answer
668 views

Sql Server 2014 Setup Stuck on Feature Selection

I think this problem is due to windows 10 bug due to which we can't click anywhere and this forum should be suitable for it. I am installing SQL server 2014 on my other PC which has little ...
0
votes
0answers
188 views

Executing SQL query through VBA

I am new here, but I always check this website whenever I have issues with excel and so far you've always helped me! Now I have a problem with VBA: I want to "call" an SQL query through a macro, so ...
0
votes
1answer
96 views

Is there a way to run MySQL queries from Windows Powershell or Command Prompt?

I currently use Microsoft SQL Server Management Studio to run queries on my databases, but it's a bit clunky and I prefer to do everything through a CLI if possible. Is there a way to do this on ...

1
2 3 4 5
15