Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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

1
vote
0answers
7 views

Connect to an SQL Server (MSDE 2000) on a remotely hosted virtual machine

We have this old program that requires Windows XP and SQL Server MSDE 2000. We have solved the problem by installing Windows XP in VirtualBox. When inside the premises, we access the program via MS ...
-2
votes
0answers
10 views

How we can have the ability to build a new sharepoint server which have the same sharepoint patches installed

we have couple of sharepoint 2013/2016 farms, and they all shared these architecture :- one sharepoint application server which have sharepoint server installed. one database server which have the ...
0
votes
1answer
12 views

MSB4018: The “SqlBuildTask” task failed unexpectedly ==> System.OutOfMemoryException

Sometimes, rebuilding my solution I get following error. Solution is huge, 270+ projects and I have no idea how to get rid of this error. It happens sometimes, most of the times solution builds ...
0
votes
0answers
10 views

“The user is not associated with a trusted SQL Server connection”

My PC with Window 7 Home Premium was updated(windows update) 2 days ago for "Security and Quality Roll up for.Net Framework 3.5.1, 4.5.2 ...". Since then won't allow client PC to connect SQL Server ...
0
votes
1answer
16 views

Program connecting to SQL over port 445

I have a program called VHI(Visual Health Information - Network Version) that is a server/client model. I have installed the server portion and has a database. SQL Server Name\instance = "EDSERV03\...
0
votes
0answers
12 views

Excel, ODBC - desired database not listed

When I attempt to create an ODBC to a server (named DARKHELMET for all you spaceballs fans out there) it doesn't show in the list of available data sources. ..but it does show up under data source ...
0
votes
0answers
10 views

SQL Server CPU Utilisation won't exceed 10%

We have a virtual machine running in Azure. When i remote onto the server box desktop and run SQL queries, each query connection will only use 10% of the processing capability of the server. When i ...
0
votes
1answer
13 views

MSSQL database physical design: RAID or spreading filegroups across different physical drives? [on hold]

I'm going to build a Microsoft SQL server database which could end up being more than 40 TB in size. Which of the blow physical designs of the server will result in better performance1 and db ...
0
votes
0answers
6 views

Merge mySQL table to SQL server on a regular basis

I have a equipment that publishes data like time, date, temperature etc. to mySQL database periodically. However, all the other data infrastructure of my company is set-up using SQL server. Is there a ...
0
votes
0answers
14 views

Installing ODBC on Linux VM Instance

I have a python script that I want to place on a Linux VM running Ubuntu 18.04.1 LTS. The python script requires an ODBC driver to connect to a SQL Server. I installed the ODBC drivers to the ...
-1
votes
0answers
14 views

Connecting C# Windows Form Application and a Xamarin android to an MS SQL Server [closed]

I'm planning for a project, this project is two parts that can't work without each other, this first part is going to run on Windows using 'C# Windows Form Application', and the second part is going ...
0
votes
0answers
13 views

Will deadlocks occur when deleting rows from a table when being added to by another process? [migrated]

I have to archive data from a table into another table whilst the original table is in use. The archival process is to copy the rows into another table and then delete the rows from the original ...
0
votes
0answers
3 views

How do I get SQL Server Management Studio to find a .bak file to restore? [migrated]

I am trying to turn a .bak file into a database. I can't find the "Restore Database" button when I left-click "databases" when connected. This is what I should see. However, this is what I see. I ...
0
votes
0answers
9 views

VS2012 TFS build definition

In our organization we are using VS2012 to trigger build(Manual trigger) for deployment activities against Sql server 2012 and it is working as expected. Recently we are planning to migrate to Sql ...
0
votes
0answers
3 views

sql ssms on development - clear log.ldf files [migrated]

while working on building of a big DB i notice my C drive run out of space when running heavy SQL queries on SQL Server. by checking this folder size is over 150GB , when log.lpd files reach over ...
1
vote
1answer
40 views

How to calculate percentage with a SQL statement? [closed]

i have two sql tables i want to compare two tables ..comparing two tables is done now what i want is how many records are matched and not matched in the form of percentage .is it possible to write a ...
0
votes
0answers
10 views

Not able to access Secure SSRS report on port 443

I facing issue with SSRS report on port 443. I can configure URL but when I trying to access in in local computer or from remote server I am getting below message. This page can’t be displayed Make ...
0
votes
0answers
5 views

Data export tools in SQL Server

I'm trying to find a tool to export some filtered data from a group of related tables. Essentially, I have 1 parent table with a bunch of child tables, and I only want to export 1 record from the ...
0
votes
0answers
5 views

SQL server maintenance plan not working after renaming administrator [migrated]

I have renamed the windows administrator account to TEST using Local Group Policy Editor. After that the SQL server maintenance plans are not working: unable to determine if the owner of job has ...
0
votes
0answers
10 views

SSAS unexpected error during deployment cube

Today I have tried to deploy a cube (through Visual Studio), but the deployment process failed with these two useless errors: Internal error: The operation terminated unsuccessfully. Server: ...
1
vote
0answers
5 views

SQL2016 ODBC login fail on first attempt [migrated]

My current SQL server version is: Microsoft SQL Server 2016 (SP2) (KB4052908) - 13.0.5026.0 (X64) Mar 18 2018 09:11:49 Copyright (c) Microsoft Corporation Enterprise Edition (64-...
2
votes
1answer
24 views

Additional User Account, Windows Authentication in SQL Server Management Studio

I am transitioning my work laptop to a coworker (who we'll call Mary Smith) who is taking my place on my team as I move on to other things. One of the tools we use is Microsoft SQL Server Management ...
0
votes
0answers
42 views

Can not uninstall SQL Server 2017

I had SQL Server 2014 before installing SQL Server 2017; after I had installed SQL Server 2017, I decided to uninstall SQL Server 2014. I can uninstall SQL Server 2014 completely, but when I tried to ...
0
votes
0answers
18 views

Unable to run WAS Service in WINDOWS SERVER 2012 r2

I have a problem when I try to run websites in IIS, it tells me that the W3SVC service could not be started. I was looking for information and this address me to review the services of the server ...
0
votes
0answers
30 views

How to block sql server port only to don't allow to connect the sql server?

I tried to block SQL server TCP port 1433 in Kaspersky endpoint security 10 for certain range of user's IP. But I cannot block by that port number 1433. If I try to block all Inbounds for that ...
0
votes
0answers
18 views

SQL Compare 13, copy & paste from differences SQL View doesn't copy carriage return/newline?

I'm using SQL Compare 13 to compare a test and production database. Sometimes there are tiny differences and I just copy & paste it from the differences SQL View and run it in the target database. ...
0
votes
0answers
35 views

How access SQL Server “Backup” folder via FTP with IIS

I have on Azure VM an IIS running several websites. I can access those sites files using the FTP server feature of IIS. My problem is I am unable to add a new site to access de "Backup" folder of the ...
0
votes
0answers
25 views

Restore a database in clustered SQL Server instances

I have two Dell boxes and a SQL Server (2014 Enterprise) instance runs on each box. They are clustered through Always On. Now I have a new database on my laptop and I need to restore it into the ...
0
votes
0answers
46 views

How to copy read only database?

I'm using SQL Server 2012. I have a read-only database and I have to create a replica from it and a new database should be read-write I tried to copy but it failed Then someone told me it's because ...
0
votes
0answers
11 views

Export attached(type) files from MS Access to SQL

I want to export database from MS Access database to SQL server. The problem is that when it comes to attached files than sql doesn't recognize it, because there is no such type of data in SQL. I ...
0
votes
0answers
98 views

Batch Error SQL Server BULK INSERT

I am attempting to have a script in my batch file that runs a SQL Server Stored Procedure. The Stored Procedure bulk inserts data from a .CSV file into a SQL Server table. When I run the Stored ...
0
votes
1answer
97 views

SQL Server 2012 repair/installation fails

We have a Windows 2012 R2 server and want to run MS SQL Server 2012. It seems like someone attempted installation a while back but it is not installed properly since SQL Server does not show under ...
0
votes
0answers
51 views

How to do I make NPS properly create its SQL database?

NPS (Windows Server role) natively supports writing authentication logging events to a SQL database. Running through the wizard is supposed to create the database, the table, and the stored procedure(...
0
votes
0answers
52 views

SSRS Generating Large Log Files, Filling Drive

I've installed SSRS (v14.0.6681.5121) and configured it with my SQL Server 2017 instance. I noticed that my drive was filling up very quickly and tracked it down to this SSRS log as well as a 200MB ....
0
votes
0answers
51 views

What is the correct SQL command to use when “?” doesn't work as a parameter reference to a spread sheet in Excel?

When I changed the hard coded date (highlighted) to ? It returned conversion error message. What is the fix? Appreciate all the helps i can get. SET NOCOUNT ON DECLARE @lastdayofweek DATETIME ...
0
votes
0answers
18 views

All INSERTs done through MS Access old untouched forms now fail after creating new unrelated forms

I'm fairly new to MS Access, and the following issue has me completely stumped. I modified an existing .accdb MS Access project by creating new forms via the Form Creation Wizard that allow you to ...
0
votes
0answers
30 views

Can't connect to a SQL Server from Access

Via a Connection ODBC, we are trying to connect from an Access 2016 to a SQL Server, and we found this error message: Both computers are in the same workgroup and they can see each other. Also they ...
0
votes
0answers
22 views

SQL Server Manager Studio keeps creating Visual Studio 2015 and Vulnerability Assessment Reports folder in which both of these folder are empty

I'm using SSMS 2017. However, there is a problem. As soon as I open the app, it will create two folders: SQL Server Manager Studio (with Vulnerability Assessment Reports emptied ) Visual Studio 2015 ...
0
votes
0answers
51 views

Network and Machine configuration for Virtualbox VM running SQL Server 2016

(Not sure if this should be superuser or serverfault?) Background: My desktop machine is Win7 Enterprise, which won't run SQL Server (SS) 2016 or 2017. We'll upgrade to SQL Server 2016 in about 9 ...
0
votes
0answers
53 views

Sql server on ubuntu doesn't respnod

I have installed sql server 14.0.3030 express with .netcore 1.1 on ubuntu 16.04 and everything was fine till last night suddenly i encountered with this err message from my dot net core web app ...
0
votes
0answers
165 views

“Unable to enlist in the transaction” with Oracle linked server from MS SQL Server

We have a setup where we use MS SQL Server with a linked Oracle server. Our database has views on the Oracle database. We have in-house written software (I'm the lead developer) which uses this setup. ...
0
votes
0answers
114 views

Windows Authentication on Azure VM using Azure AD account from remote client

Issue When connecting with Windows Authentication "Cannot connect to 172.16.1.5. The target principal name is incorrect. Cannot generate SSPI context." Nothing appears in the SQL Server log. ...
0
votes
0answers
66 views

pyodbc issue - the session is in the kill state

I have an issue when run python script. I've got this error: pyodbc.Error: ('HY000', u'[HY000] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot continue the execution because the session is in ...
1
vote
1answer
24 views

Possibility to join OVPN when user is not logged on

I am trying to achieve an automation for SQL server agent to store backups in a remote computer, but sql server agent has first to join OVPN. I have tried all the methods described here, but in my ...
0
votes
0answers
16 views

SQLServer inaccessible from owner machine

I've a SQLServer instance in my server machine. The machine is accessible from server.myurl.com. In another machine client I've installed SqlServer Management Studio and try to connect to server.myurl....
2
votes
0answers
14 views

Anyone have success configured MySQL linked servers on SQL Server 2017 for Linux?

I am trying to figure out if SQL Server 2017 for Linux supports linked servers for MySQL? I know its possible on Windows OS if ODBC/OLEDB drivers are configured on the same server as SQL, but ...
2
votes
0answers
40 views

MS SQL Server Licenses

I was having a discussion at work about the licensing model of Microsoft, in particular for SQL Server and we couldn't agree on the interpretation of "Active SA Quantity". So the question is, if for ...
2
votes
0answers
42 views

SQL Server 2017 cannot connect to remote databases

I tried to uninstall some old versions of SQL Server I had installed just to free up hard drive space, and along the way I corrupted my SQL Server 2017 such that SSMS could no longer connect to any ...
0
votes
0answers
242 views

I get “rsProcessingAborted” and “rsErrorExecutingCommand” randomly in my SQL Server Report builder report

I have a report in which I get randomly the following error after pressing the "View Report" button (because in this report I need to select a parameter value from the dropdown field first): An error ...
0
votes
0answers
20 views

Creating an automatically generated locked field in Delphi

I need to create an automatically generated locked field (that can't be a free entry). This field looks like this (this is an example): 2-0103-1/2017. In this example, number 2 represents the number ...