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]...
326
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
469
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
964
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
408
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
902
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
543
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
97
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