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]...
327
questions with no upvoted or accepted answers
3
votes
0
answers
1k
views
Sql Server does not start after server reboot
I have a SQL server 2012 installed on Windows 2012.
The last five times the server rebooted, the SQL server did not start at system startup.
When I then log in as administrator, opened services.msc ...
- 765
3
votes
0
answers
1k
views
Getting error (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY) when migrating from MS Access 2013 to SQL Server 2014
OK.... I've checked and rechecked Google, StackFault, Experts-Exchange, etc... for a resolution on this error and they all say to register the DAO360.DLL and add its path to the environment settings. ...
- 300
3
votes
1
answer
3k
views
Calculation takes forever in large data set on Excel
I connected my excel to ODBC SQL Database(SQL Server) and now my excel pivot table is getting its data from the sql server VIEW. There is a total of about 1 million plus rows from the QUERY. From the ...
- 31
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 ...
- 179
2
votes
0
answers
20
views
Is it possible to restore a single project plan from a full database backup
Using MS Project 2013, one of our PCO deleted tasks from a project plan, while work had been entered via timesheets on those same tasks, some of which weren't approved, yet.
The project is now in a ...
- 31
2
votes
1
answer
443
views
SQL Server 2012 Setup Failure
I am installing SQL Server 2012 in my computer but this error message always shows up. I tried installing it in a Virtual Machine, and it worked! Other threads says that the issue is permission access,...
- 21
2
votes
0
answers
944
views
Unable to connect to SQL server after update
I updated my server today with all pending update and after reboot I was unable to connect to SQL server. Prior to reboot I've also enabled the firewall but now it's disabled again and server is after ...
- 21
2
votes
0
answers
393
views
Why i am not able to connect to SQL Server via VSCode?
OS: Ubuntu 19.04
I have installed SQL Server using tutorial by Microsoft, and after running command systemctl stop mssql-server i can see it's running.
But when i'm trying to connect to this ...
- 21
2
votes
0
answers
861
views
Visual Studio + SQL integration services projects
I am trying to install SQL Server Integration Services with Visual Studio 2019 however when I opend the exe file with SISP I am not able to select Visual Studio instance because I have the following ...
- 21
2
votes
0
answers
527
views
Sql Server Management Studio 18.1
I recently installed SSMS 18.1 and I am having an issue when trying to drag and drop table names from the object explorer to the query window. For example, I am writing a query and dont want type out ...
- 21
2
votes
0
answers
1k
views
Insert data to database using Excel VBA is not working
I have a macro that will upload data from multiple workbooks to the database. Table will differs based on what type of value/data being inserted. I have there tables. I can insert value in the first ...
- 23
2
votes
1
answer
3k
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 ...
- 21
2
votes
0
answers
30
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 ...
- 21
2
votes
1
answer
56
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 ...
- 21
2
votes
0
answers
96
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 ...
- 1,182
2
votes
1
answer
3k
views
Windows Scheduled Task executes SQL scripts as Anonymous Logon, despite being associated with a domain account
I've built an EXE that I need to run every hour, for the rest of forever. To do this, I'd like to use Windows Task Scheduler.
It would be more appropriate to run this on Windows Server, but ...
- 121
2
votes
1
answer
3k
views
How do I connect from IIS to remote SQL via Windows Auth w/o a service account?
I have a pretty typical .NET app that uses Entity Framework, MS SQL, and IIS. The app was developed with the expectation that the SQL server would run local to IIS and with SQL authentication for the ...
- 131
2
votes
1
answer
3k
views
How do I safely uninstall the many components of past SQL Server versions?
I recently installed SQL Server 2017 Express on my Windows 10 operating system (PC). I also though have installations of 2016, 2012 and apparently 2008 as well from older installs. I'd like to ...
- 21
2
votes
0
answers
3k
views
Restore databases in SQL Server without creating orphaned users
I have seen this in just about every version of SQL Server and blog posts about it seem to treat it as something that occurs sporadically, but since I always seem to encounter this problem, up and ...
- 1,473
2
votes
0
answers
438
views
Run out of virtual memory after added to triple physical RAM and change SQL Server memory option?
Recently, we added some physical RAM to our server which running SQL Server 2008 R2 instance, the total memory was changed from 64GB to 192GB.
And we tuned the memory option of SQL Server by changing ...
- 21
2
votes
0
answers
4k
views
LDAP connection - how to query active directory and get this information?
I am following this article below:
Querying Active Directory Data from SQL Server
and for me to get it right I need the following information below.
Querying Active Directory Once the linked server ...
2
votes
0
answers
566
views
SQL Server Express no longer starts up automatically
I had SQL Server 2008 Express (SP1) on Windows 7 Pro and it was working fine.
After upgrading to Windows 10, SQL Server 2008 Express was still working normally.
However, after the last Windows update (...
- 509
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
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 ...
- 1,105
2
votes
0
answers
1k
views
How to install SQL Server ODBC driver on OSX?
I'm using MySQL Workbench on a Macbook to migrate a SQL Server database to MySQL. When I try to connect to SQL Server I get the error:
The ODBC driver that was selected for the source connection ...
- 5,736
2
votes
0
answers
129
views
Using Cloudberry SQL Server backup and Amazon Glacier efficiently
I'm using Cloudberry Serverbackup to backup my SQL databases once a month to Amazon Glacier.
I know that just getting an inventory from Glacier can take a long time.
Is there a way that when the ...
- 311
2
votes
1
answer
3k
views
excel sql server error: Invalid object name
I access a stored procedure on a Microsoft SQL Server 2005 database within excel using
Select *
from [dbo].[fn_ph_by15minbyQueue] ('2013-09-01','2013-09-30','LocationCode')
in the data connection, ...
- 3,704
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 ...
- 29
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 -...
- 75
2
votes
2
answers
3k
views
Restore a database with LDF file only
First of all, i know how stupid it is not to have a any backup. I can't help it, but i have to (try) to solve it.
I have a transaction log (LDF) file from a SQL Server 2000 database that contains all ...
- 121
2
votes
0
answers
682
views
View numeric columns in hex - SQL Server Management Studio
In SQL Server Management Studio, when I run a query which outputs a numeric column (int or similar types), they are displayed in decimal (example: 193). I want them to display in hex (example: 0xC1). ...
- 3,537
2
votes
1
answer
279
views
NetWork Intrusion Attack: MSSQL.worm.helkern attempting to attack local port 1434 from IP address 94.188.21.147?
I was on the internet the other just finishing up a project for work and I saw my internet security saying network attack intrusion and I read about some of it but I can't fully understand the full ...
Tyler
2
votes
0
answers
824
views
Access losing db connections
I have a weird problem going on at work.
People have been using MS Access to connect to SQL Server db and lately people are getting sporadic problems with connecting to the servers. It's not always ...
- 173
2
votes
1
answer
745
views
How can I add a keyboard shortcut for Find-In-Files in SQL Server Management Studio?
I'd like to make it Ctrl-Shift-F to match Visual Studio.
I realize to do that I need to remove that binding from the Query->Save to File item.
But, I can't even add ANY shortcut. When I pull up the ...
- 133
2
votes
1
answer
133
views
Accessing a local SQL server 2014 from within a VM running vista using VS2005 fails
My laptop is running Win 7 (x64) and is part of a domain. I've installed SQL Server 2014 Dev and VS2012 on it as I want to use the laptop for development.
Since some of my development has to be done ...
- 233
1
vote
0
answers
116
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 ...
- 11
1
vote
0
answers
242
views
Excel ODBC connection to MS SQL server refresh issue
I've created an ODBC connection in Excel in order to create pivots on a large table held in MS SQL Server.
The connection string looks like this:
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist ...
- 21
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....
- 125
1
vote
0
answers
383
views
SSDT with Visual Studio Professional Edition vs Enterprise Edition
We need to setup SSDT for SSIS on SQLServer 2019. We would like to understand what is the difference if we go for Visual Studio Professional edition versus Visual Studio Enterprise edition. I see no ...
1
vote
1
answer
846
views
How can I share an Excel sheet with embedded SQL queries with another user without asking them for log-in credentials?
I created an Excel (Microsoft 365) sheet for a (non-tech-savvy) coworker that pulls data from a SQL database. However, he is not able to refresh the queries (by hitting 'Refresh All') on his machine ...
- 11
1
vote
0
answers
613
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) ...
- 111
1
vote
0
answers
532
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) ...
- 11
1
vote
1
answer
818
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 ...
1
vote
0
answers
209
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 ...
- 11
1
vote
1
answer
317
views
Database Reverse engineering wizard Fails
I am using Visio 2019, trying to reverse engineer a Azure SQL server. I have successfully created multiple User data sources to use in the wizard using both our DB-admin user and my admin azure ...
1
vote
0
answers
926
views
Why won't SSMS-Setup-ENU.exe start?
I need to install SQL Server Management Studio. I downloaded the setup file then I click on the setup file to install it, but nothing happens.
I tried to open it as administrator. Yet again, nothing ...
- 11
1
vote
0
answers
271
views
How to set up SQL User that can only do one thing (run stored procedure) and nothing else?
I would like to allow any user within a certain group of our domain access to login to one of our databases and run a specific Stored Procedure. This is the only action these users should be able to ...
- 983
1
vote
0
answers
375
views
SSIS OLE DB Destination transfer decreased between SQL to SQL DB
Short Story, after a weekend I started getting errors about some jobs IN the SQL Server Agent failing.
What I found out is that the issue is only present in X server and when I try to use a Data Flow ...
1
vote
1
answer
398
views
Syntax for SQL IN when using Excel database connection
I'm using a number of Excel files to connect to an SQL Server database, fetching sales data for a particular product number which is specified in a cell in the Excel sheet.
This was set up by ...
- 23
1
vote
0
answers
42
views
Db Mirror Issue
We are having a Weird issue with the DB Mirroring and to post the the issue I will have to explain our Architecture first.
We have a TWO Nodes [NODE 1 and NODE 2] cluster with Two FCIs Installed on ...
- 11