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
20 views

Database: Using a .NET application for a frontend to an SQL Server backend [closed]

I'm developing a series of small database applications to be used for internal processes at my company. So far I've been working in MS Access but it's old, limiting, and I see this as a good ...
0
votes
0answers
3 views

SQL Server - Get the Date Ranges [migrated]

I have a table with Start date and End Date, For Example, PlaceID | StartDate | EndDate 1 | 2020-01-01 | 2020-01-04 2 | 2020-01-03 | 2020-01-06 1 | 2020-01-10 | 2020-01-15 2 | 2020-01-20 | 2020-01-...
0
votes
0answers
44 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 ...
1
vote
0answers
9 views

Limit memory usage of an application with multiple instances [migrated]

I got a program installed in 3 different machines, pointing to the same database, running at the same time. They are responsible for reading a huge file, process everything and then save on database. ...
0
votes
1answer
22 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
0answers
7 views

Have SSMS not retrieve VARBINARY(MAX) blob data for “Select Top 1000 Rows”

I'm using SQL Server 2017 and SQL Server Management Studio ("SSMS") v18.5. In my database, I have a couple tables that have blobs stored in VARBINARY(MAX) columns in tables that look like this: ...
0
votes
1answer
43 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
30 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
320 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
11 views

How to pivot multiple rows into one by placing them next to each other in LibreOffice Calc?

Let's say I have data like this, showing what video games each person owns (not my actual data but that's sensitive information): Name Game Publisher ---- ---- ----...
0
votes
0answers
36 views

How to connect to MS SQL Server from SQL Server Management Studio on my laptop, via AWS Session Manager?

I want to use MS SQL Server Management Studio on my laptop to connect to SQL Server on an AWS EC2 instance. The EC2 instance is in a Private subnet (behind a Public subnet), so does not have Internet ...
0
votes
0answers
36 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
48 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
0answers
39 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
36 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
46 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 ...
0
votes
1answer
47 views

What is “localcomputer” or domain and how to get it?

I am trying to install a program (Microsoft SQL Data Sync Agent), and in one step it is asking me the following: Enter the account you want to run Windows Service under. E.g. domain\user. ...
0
votes
0answers
27 views

How to install SQL Server 2017 Express in “Quiet Simple” mode without an extraction folder?

I need to install SQL Server 2017 Express with as little user interaction as possible. I am using the SQLEXPR_x64_ENU.exe setup file that I found a Microsoft download for. Currently I can do exactly ...
1
vote
0answers
58 views

Apex SQL complete freezes SQL management studio

I am using SSMS 18.4 I installed APEX sql complete, and every 30 minutes it freezes my management studio. So I'd have to go to Task Manager and end it from there. Did anybody have issues like ...
-2
votes
1answer
44 views

Connect to Database between two computers without internet [closed]

I want to connect my database on another computer without internet with a LAN cable, I've tried connected 2 machines with a LAN cable but it didn't work with database. My application works offline. ...
1
vote
1answer
1k views

Where is the SQL Configuration Manager in SQL Server Management Studio 18?

I am setting up a new computer, a Surface Laptop 3. I have installed SQL Server Management Studio 18.4, downloading it from here. I am just trying to install client tools and not the server software....
5
votes
2answers
307 views

Does Azure Backup for Windows Server affect regular SQL Server backups on the same server?

I have a virtualized Windows Server 2019 instance configured as failover cluster node with SQL Server 2016 Availability Group node running on it. I have already set up "traditional" SQL server ...
0
votes
2answers
116 views

Is it safe port forwarding my sql server?

I have recently made a SQL server from Microsoft and I was wondering if it is safe port forwarding it. This database isn't gonna be out there and I'm just using it as kind of as a test sql server. I ...
0
votes
0answers
42 views

VM can connect to SQL SERVER but not to ping the server

my schema is like this: Windows Server 2016 with NAT adapter and Only Host Adapter using 192.168.3.2 255.255.255.0 acting as Active Directory Domain Service with DNS and DHCP enabled. The DHCP is ...
1
vote
1answer
934 views

How to connect to a Microsoft SQL Server from Linux shell?

I have the following problem: I am working on an Ubuntu Linux server (I have access only to the shell, no desktop environment) and I have to interact with a Microsoft SQL server to create some tables ...
0
votes
0answers
317 views

“Connection reset by [IP] port 22” when trying to access server via SSH on MacOS

I am having trouble accessing the databases of my Wordpress using public and private SSH key access. I am trying to connect to the server and have exactly followed these steps. For the record: I ...
0
votes
0answers
55 views

Why VM in domain can't see SQL Server outside domain?

I have the following scenario: 1 Windows 10 home host machine with SQL Server up 2017 and running. 1 Domain server VM running over host machine. 1 Windows 10 pro VM running over host machine, and ...
0
votes
0answers
26 views

Tab-completion not working in SqlServer provider

It appears that tab-completion not work for SqlServer provider objects. In the commands below, neither variables nor gettype() would tab-complete. Is this expected? Is there any setting I can change ...
1
vote
0answers
58 views

Unable to connect to Analysis Service Server from Excel, Visual Studio and PowerBI

Within our domain we have an analysis service server running with cubes. When trying to retrieve this data using Excel (Get data from Analysis Service), Visual Studio (using source control explorer) ...
0
votes
0answers
109 views

How to avoid “View any definition” permission warning in Visual Studio?

I'm relatively new to Visual Studio. In comparing my project to my SQL Server database I am getting the warning: "The login for the target does not have the VIEW ANY DEFINITION permission. The ...
0
votes
0answers
285 views

I can't connect to my SQL server using my public IP

As of now, I am currently using SQL Server Management. I can connect to my SQL Server hosted on a different computer on the network. For explaining purposes, my computer is computer A and the computer ...
0
votes
0answers
92 views

Configure SQL Server listening port with Ansible

I installed SQL Server Express Edition in remote Windows machine using Ansible-playbook, Ansible module "win_chocolatey" and Chocolatey package "sql-server-express". Here is my Ansible-playbook task: ...
0
votes
0answers
46 views

Error connecting to SQL Server in Power BI Desktop

I am a newbie using Power BI and am just trying to install the server-side software to get access to our database informaiton. I am working on a somewhat old setup of Windows Server 2008 R2 and SQL ...
0
votes
0answers
25 views

How to Create a single setup file for many of them?

I've written an C# application that must run on Windows and I want to create a single setup file for my customers. The Packages that I want to inclusion in the setup file are: vcredits ...
2
votes
1answer
189 views

SQL Server (SQLEXPRESS) Service cannot start. It's referring to a file that doesn't exist

I'm learning how to create an application in Visual Studio and following a tutorial to create a service-based database. When I try to add the new item (service-based db) in Visual Studio, I got the ...
17
votes
3answers
6k views

Does a Window 10 license allow using it as a Web server?

I am looking to set up a Web server for a project. The server would be using a custom application developed in VB.Net using SQL Server for data storage. The application uses 3rd party components (DLL'...
-2
votes
1answer
146 views

installing sql server management studio 2017

i want to install ssms2017 but it get error code 0x800b0003 here is the log file [3744:1E78][2019-10-27T16:43:04]e310: Failed to verify payload: HelpViewer2_3 at path: C:\ProgramData\Package Cache\....
1
vote
1answer
133 views

convert sql-excel date to recognisable format

I have a large csv file(1.1G) exported from SQL Server. I would like to do data wrangling in python, but I had a few problems doing this. The original csv file dates look like this 00:07.5, 00:08.3, ...
0
votes
1answer
15 views

Restore large backup on SQL Server's VM currently replicating to a remote VM both Hyper-V

I am looking for ideas to restore a large backup on a VM hosting SQL Server that is replicating to another VM in a remote location (Hyper-V VM Replicaton). Restoring it will replicate the restored ...
0
votes
0answers
11 views

Website in web hosting service and DB in local server

I have my webapp (ASP.NET) and database (SQL SERVER) in my own server. I plan on moving the website to a web hosting service like GoDaddy but I need to keep the DB in my server. Is there a way to get ...
0
votes
0answers
12 views

SQL select from from a table in EXCEL statement

I have two tables in a workbook, let's say TblA and TblB I want to know how can I use SQL to extract data from the two table. It seems that I can not directly use the table name (TblA or TblB). When ...
1
vote
1answer
174 views

Importing DatetimeOffset Data into Snowflake

When I load DatatimeOffset Data into Snowflake the offset defaults to the Timezone of America/Los_Angeles. The only question I have besides this is how we maintain the provided UTC offset with our ...
0
votes
2answers
35 views

SQL with an error

I am trying to create a table using SQL STUDIO and keep receiving this syntax error: Incorrect syntax near 'CourseNo'.
0
votes
0answers
12 views

Apply SQL Server Policy to New Objects Only

I have set up the naming conventions for views using the SQL Server 2017 Policy Based Management. The rule requires all views to start with "vw_". The evaluation mode is set to "On Change: prevent". ...
0
votes
1answer
23 views

MS SQL server log file growing

The monitoring system has raised an alert that a drive on a server that hosts SQL Server instances is low on space. It was found that a transaction log file has grown very large and the file cannot be ...
0
votes
0answers
132 views

The target principal name is incorrect. Cannot generate SSPI context

We have an application hosted on IIS. There are three servers in play here: TEST IIS application server PROD IIS application server SQLServer that hosts the DB for both application instances These ...
0
votes
0answers
6 views

Issues after Failover of SQL nodea

Our fail-over cluster consist of 2 nodes(node1 & node2).And we have 4 SQL instances(like 'prod1\sqlins', 'prod2\sqlins','prod3\sqlins','prod4\sqlins') running under the cluster set up. On 22nd ...
0
votes
0answers
56 views

Add files to zip using 7zip (or any tool) with MODIFIED/Created date in search criteria

I found couple of answers but most of them are focusing on adding the files that are named with date or timestamp within name (prefix/suffix), which i'm currently handling with following command. ...
1
vote
0answers
16 views

SSAS - Issue with SQL Server Data Source

I am working on SSAS Tabular model and have an SQL Server data source (Provider=SQLNCLI11) to which it connects and processes data successfully. However, since a few weeks, the data source connection ...
0
votes
1answer
578 views

Visual Studio (SSDT) SSIS create new project issue

When I open Visual Studio SSDT click on new project for Integration Services Project then I get the following error.. Cannot load the component 'Microsoft.AnalysisServices.Database'. Make sure that ...

1
2 3 4 5
16