21

I know of no hacks to get SQL Server 2000 to install on an existing Windows 10 installation. There are probably forces against you from both within the setup program (which looks for certain things on the host system) and within the operating system (which prevents many flavors of older software from getting installed, mostly for security reasons but also ...


12

Thanks to suggestion from Daniel Vérité I was able to fix it without dumping the entire db server. My understanding of locales on Windows is very limited but from what I've learned it seems like Microsoft changed region name of czech locale from "Czech Republic" to "Czechia" during Fall Creators update (presumably so it conforms to ISO 3166-1). Postgres ...


11

Had the same error. Turns out that it was my setting in Region -> Formats -> Format. When it was on English (World) or English (Europe), I would get this error. Setting it to English (United States) solves it. I'm guessing that English (World) or English (Europe) were new formats with Windows 10, and SSMS is not prepared for it.


10

I managed to install following these steps: Extract SP4 Copy ..SP4\x86\other\sqlredis.exe to ..\originalinstallpath\x86\other (this avoid mdac insall freezing) Create this folder structure (any place): Microsoft SQL Server\80\Tools\Binn Microsoft SQL Server\MSSQL\Binn Find out sqlunirl.dll on SP4 path and copy to Binn folder above Copy dll files on .....


9

Is there a way to get updates automatically? SQL Server 2008 R2 is not supported on Windows 10. This means the SQL Server team will not be releasing any security updates or patches if they find any specific issues related to SQL Server 2008 R2 code. There is no way to get updates automatically as none would be released related to Windows 10. Having said ...


9

Every time I reboot windows, for some databases comes out this error. (OS Error 21 - Device not ready) This is due to a disk being offline or not being online either at the time SQL Server started, or had transitioned states after SQL Server has been online. 3.If I restart SQL Server the errors disappears Yes, because the databases have been remounted ...


5

I think I've found the cause. Most likely the problem is due to "Fast startup" power options. It'a a Windows technique to reduce the boot time; Fast Startup combines elements of a cold shutdown and the hibernate feature. Here you can find another article about pros and cons I have disabled it and the problem seems to be resolved.


5

Vendors will need to catch up, as the add-in model and API have changed. This will lead to better extensibility, but for now you'll need to wait for the vendors to do this work. There is usually not much advantage to doing all of that work while the product is still in beta and the add-in model is still changing (the version of SSMS released on Friday is on ...


5

RECOMMENDATION #1 You have innodb_thread_concurrency at 17. It really needs to be zero(0). Why ? Rather than rehash stuff I wrote in the past, please read the 7 posts I wrote about innodb_thread_concurrency being the best choice at 0. RECOMMENDATION #2 Using a small log buffer can be a bottleneck when writing to the redo logs. Please read my 3-yr-old ...


4

You are installing SQL Server 2014 Enterprise Edition on Windows 10 (a client OS), which is not supported. If you were to take this case to Microsoft they would say you are trying an unsupported scenario. Although your installation won't fail as such if you are trying to install Enterprise Edition on a client OS, what is the point in wasting such a costly ...


4

SQL Server 2016 will allow for Availability Groups without a domain, but sorry, I don't think your operating system is going to cut it. To support your scenario, you could put an eval of a proper server OS in a virtual machine or dual boot scenario, but to really test AGs, you'd need multiple copies of Windows in order to understand failover, availability ...


4

I think 3072 (0x0c00) is an invalid locale ID, at least according to this. So this looks like a corrupted Windows installation, perhaps from a flaky disk (eg. a byte overwrite of a locale 0x0c1a, which is the code for "Serbia and Montenegro (Former)"). You can try changing the current locale from Control Panel.


3

These are my observations and how I solved the problem (for the benefit of others who may have the same problem) I was using amazon ec2 instance running Sql server. I had an EBS Block device attached to the ec2 instance, that mapped to the D: drive. My data and logs were in the D: drive. When I stop the ec2 instance and bring it up later, I always ...


3

I think it is fine; the documentation was just written long before Windows 10 was released and hasn't been updated (I've sent in a note that it should be corrected). In fact it is listed as fully supported here, with no special caveats for MDS. I have never heard of any components of SQL Server 2014 having any compatibility issues with Windows 10.


3

SQL Server 2014 works on Windows 10 just fine. Some upgrade paths, though, will move all your apps and services to Windows.old (this happened to me one upgrade out of 4 or 5), so be careful and take the usual backups and other precautions. Thankfully, reinstalling SQL Server is not an extremely elaborate process.


3

Oracle Database 12.1.0.2 is the first version that is certified on Windows 10. Oracle Database 11.2 is not certified on Windows 10. Just click Yes and continue. By the way, the 11.2.0.4 installer does not throw this error on Windows 10.


3

I've found that the database diagram tool seems to crash if you modify things outside of the diagram. Diagrams appear to remain stable if: The database diagram tool is used to do all of your modifications, thus retaining all metadata of the process within the diagram. Your database structure is modified outside of the diagram which is then deleted and ...


3

You can set the service property to restart it (service properties --> recovery --> first / second / third failure and have a delay between each restarts e.g. 1 min). You should also, have the service set to automatic delayed start. Alternatively, you can use powershell and schedule it in task manager to check if the service is running or not. If not ...


2

I installed SQL Server Developer Edition (x64) instead, and in the end it worked! I have successfully setup this edition. Actually, the key point is the part of Feature Selection. If you click Select All option at Feature Selection, this installation will probably fail. At least, it has failed for me (using a Client OS). Instead of this, you should ...


2

Gather up multiple queries into a single BEGIN ... COMMIT transaction. This will cut down on the overhead and disk hits. Don't do this blindly -- a million queries in a single transaction has other problems. And error checks need to be handled differently; think ROLLBACK.


2

There is known issue with Windows 10 not with SQL Server as such. What happens is when you upgrade your system to windows 10 from previous version and you either have SQL Server 2012/SQL Server 2014 and you restart your windows machine the SQL Server services will not come online even if startup mode is automatic. You would have to manually go and start the ...


2

You can use Microsoft's Virtual Labs to practice : Virtual labs enable you to quickly evaluate and test Microsoft's newest products and technologies through a series of guided, hands-on labs that you can complete in 90 minutes or less. There is no complex setup or installation required, and you can use virtual labs online immediately for free. Some ...


2

Given this image, I can imagine you are selecting to install every single feature during setup: I would start with just the set of features you need, since selecting everything - especially if you don't actually need everything - creates a whole bunch of dependencies for little gain. You can always go back and add features as you realize you need them....


2

Found this post after doing some research on SQL ODBC drivers for a business user today and wanted to clarify. The SQL native client is not supported beyond 2012. The new hotness (in your case) is the MS ODBC driver 11 for SQL server. However, both SNAC11 and ODBC11 should work just fine for you. MS - "ODBC Driver 11 for SQL Server contains new features as ...


2

What type of partitioning scheme and USB chipset (USB-sata bridge) does the drive use? There are all sorts of unexpected limits you can still hit on a modern USB drive with certain partition types/sizes and chipsets. I've run into issues with 2TB limits imposed by some USB drive controllers. You can format a partition larger than that but when you try to ...


2

In the error is states the reason which seems fairly self-explanatory: You have selected a feature that is not supported for Windows Server Core... [Features Supported] One of your input arguments is SQL which translates into: SQL Engine Replication Fulltext DQ Polybase Advanced Analytics (R) R Packages Instead of putting SQL in the features list, only ...


2

When you launch your app using "runas" command, you use some domain user, and that user has Windows login at your SQL server. Or that domain user is part of some AD group that has Windows login at your SQL Server When you launch app without "runas" command, the app is running, but under different security context (under different windows user), right ? In ...


1

How can I make SSAS use the tnsnames.ora file that I need? The best answer is don't bother. Use the Easy Connect naming method, and bypass the TNSNAMES.ORA file entirely. Alternatively you can set the TNS_ADMIN environment variable to the folder containing your TSNNAMES.ORA file and reboot your server for the SSAS service to see get the changed ...


1

I found a free tool that will set SetSystemFileCacheSize here with 16 gigs of RAM I set it to 1024 4096 and the mongod warning went away


1

I ran into the same problem. The database did not start with the service. First I checked the setting for the service using the Oracle Administration Assistant for Windows and configured the DB to start with the service start (by the way, I prefer the database to shut down immediately when the service is shut down). But enabling the database to open at ...


Only top voted, non community-wiki answers of a minimum length are eligible