Halloween DealsAmazon USHalloween week deals: useful picks before month-endAmazon US: current deals, useful picks and tech finds.Check DealsWindows FixRecommendedWindows errors stealing your time? Find the fix fastScan stability, cleanup and performance issues.Fix NowHalloween DealsAmazon USOctober picks are moving - compare before checkoutAmazon US: current deals, useful picks and tech finds.See Picks×
FREEDOM251

Freedom251 › Blog › DLL errors

sqlserverspatial.dll Is Missing or Not Found: How to Fix It on Windows 11 and 10

By Freedom251 Team · · 10 min read

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

If Windows reports that sqlserverspatial.dll is missing, the application usually needs a specific SQL Server spatial library such as SqlServerSpatial130.dll or SqlServerSpatial160.dll. Install or repair the matching SQL Server component for the application’s SQL Server generation and x86/x64 architecture; do not download a random DLL and rename it.

What the “sqlserverspatial.dll is missing” error means

The unversioned name in a search result or error message is commonly shorthand for a versioned SQL Server native library. The full message may identify a file such as SqlServerSpatial130.dll, or it may say that Microsoft.SqlServer.Types could not load its native dependency. Those messages describe the same class of dependency problem: an application that uses SQL Server’s spatial types cannot find a compatible native component.

As an Amazon Associate I earn from qualifying purchases.

SQL Server spatial support implements the geometry, geography and hierarchyid types. Microsoft distributes the client components separately in the SQL Server System CLR Types package, commonly named SQLSysClrTypes.msi. Microsoft’s spatial-data documentation says the installer places the managed Microsoft.SqlServer.Types.dll in the SQL Server SDK assemblies directory and the native spatial assembly in the Windows system directory. The exact file and directory depend on the SQL Server generation and installer architecture.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

For example, Microsoft documents Microsoft.SqlServer.Types.dll under C:Program Files (x86)Microsoft SQL Server130SDKAssemblies and the native SqlServerSpatial130.dll under C:WindowsSystem32. The “130” identifies that generation; it is not interchangeable with a DLL from another release. A 64-bit application needs the x64 package, while a 32-bit application needs the x86 package, even when Windows itself is 64-bit.

#1 Best Overall
Sale
TOZO A1 Wireless Earbuds Bluetooth 5.3 Light Weight in Ear Headphones | IPX5 Waterproof,2 Mics for AI Calls,Immersive Premium Sound Bass Headset with Charging Case,32 EQ via App Black
  • [Ultra-Lightweight Ear Buds Designed for Small Ears] Each earbud weighs only 3.7g and features a compact, ergonomic in-ear design made especially for small ears. Secure, low-profile, and comfortable for workouts, all-day wear or overnight sleeping.The ultra-slim profile sits flush in your ear with no hard edges poking or rubbing, so you can even sleep on your side without discomfort.
  • [Immersive Stereo Sound with TOZO OrigX Technology] TOZO OrigX tuning delivers clear vocals, balanced mids, and natural stereo sound for music, podcasts, and videos.
  • [Long Battery Life for Daily Use] Get up to 7 hours of playtime on a single charge, with up to 32 hours total using the charging case—ideal for workdays, commuting, and extended listening sessions.
  • [Bluetooth 5.3 & Stable Connection] Bluetooth 5.3 provides fast pairing, stable wireless performance, and reduced dropouts as you move around home or office.
  • [Deep Bass with Clear Vocals] High-performance drivers produce punchy bass while keeping vocals clean and detailed for everyday listening.

Check the exact dependency before changing anything

Do these checks first. They prevent a repair that installs the wrong generation or the wrong processor architecture.

  • Copy the complete error text. Record every character in the filename, including the number after SqlServerSpatial. Search-language variants such as “sqlserverspatial.dll was not found,” “How do I fix SqlServerSpatial160.dll?” and “The code execution cannot proceed because SqlServerSpatial###.dll was not found” are not enough to choose a package.
  • Identify the application bitness. A 32-bit application requires x86 native components; a 64-bit application requires x64 components. On 64-bit Windows, Task Manager may show “(32 bit)” beside a 32-bit process. If it does not, check the application’s documentation or its executable properties, or ask the software vendor.
  • Identify the SQL Server generation. The number in the requested DLL, the installed SQL Server features, and the application’s deployment documentation should agree. Do not infer a generation solely from the Windows version.
  • Determine whether SQL Server is installed locally. A server installation can be repaired. A workstation that only runs a client application may need the standalone CLR Types package instead.
  • Back up application settings and databases. A component repair normally targets installed files, but database and application backups give you a recovery path if setup discovers a broader installation problem.

Choose the correct repair route

Situation Use this route What it changes
The SQL Server installation is present, but files are missing or corrupt Repair from matching SQL Server installation media Repairs the SQL Server installation and reruns setup prerequisite and support-rule checks
A client application needs spatial types but no local SQL Server server feature is required Install the matching SQLSysClrTypes.msi Adds the managed spatial assembly and its native dependency for the selected generation and architecture
Repair stops with missing MSI or MSP messages Restore the Windows Installer cache, then rerun repair Repairs the source files Windows Installer needs for SQL Server maintenance
The error remains after installation Check the full exception, architecture, generation and setup logs Finds a mismatch rather than replacing files blindly

The choice is about scope as well as convenience. SQL Server repair addresses the complete installed instance and features. SQLSysClrTypes is the narrower client-only option. Both require an exact version and architecture match.

Fix 1: Repair an existing SQL Server installation

Use matching installation media

  1. Obtain the original SQL Server installation media or an installation image for the same SQL Server generation and edition family as the installed instance. A different release can leave the requested native library unresolved.
  2. Open the media and run setup.exe with administrator rights. If Windows asks for consent, approve the elevation only after confirming that the media is trusted.
  3. In SQL Server Setup, select the maintenance option for the installed instance and choose Repair. Select the instance or shared feature set associated with the application.
  4. Allow setup to run its support-rule and prerequisite checks. Microsoft describes repair as replacing missing or corrupt files and rerunning those checks; it is not the same as copying one DLL into an application folder.
  5. Complete setup, restart Windows if setup requests it, and launch the application again. Test the operation that previously loaded the spatial types.

If you need unattended repair

SQL Server also supports a documented command-line repair workflow. Use the syntax and parameters for your exact SQL Server generation from Microsoft’s setup documentation and run it from matching media in an elevated command prompt. Do not adapt switches from a different release: setup parameters, instance names and feature selection must match the installed product. Record the setup result and retain the generated logs if the operation fails.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.
Rank #2
Sale
Smart Watch for Men Women Compatible with iPhone Samsung Android Phone 1.69 inch Full Touch Screen IP68 Waterproof Bluetooh Fitness Tracker Heart Rate/Sleep Monitor (Black)
  • 【IP68 Waterproof Multifunctinal Smart Watch】Torjalph fitness activity tracker smart watch is IP68 waterproof technology ,you can wear it when swimming,handwashing,it's rain-proof which means that you perform multiple exercise modes outside without worrying about sweat or rain corroding your fitness smart watch,and this watch equipped with a 230 mAh large capacity battery magnetic charging ,and this sports activity tracker watch can be used 5-7 days If fully charged.
  • 【Larger 1.83'' Full Screen Watch & Multi-dial Selection】1.83 inch full HD color touch screen smart watch for men / women provides excellent 240*284 resolution image quality ,This Bluetooth smart watch offers a better touch experience and remarkable immersion and ,more than 200 watch faces for you to choose from App"Da Fit ", you can change the dial style according to your mood to wear keeping the world on your wrist
  • 【Accurate Activity Tracker Smart Watch 】sports watch activity tracker uses sweat and dust resistant breathable silicone strap, our Fitness Tracker Smart Watch for Android iOS Phones supports 12 sports modes,walking,running,bicycle,swimming,badminton,basketball,football,rope skipping. This bluetooth calls smart watch for men women is lightweight and stylish, bringing more convenient and relaxing sports experience while also providing more protection.
  • 【Your 24 Hour Personal Daily Health Monitor】Fitness watch for women men full touch screen IP67 waterproof bluetooth smartwatch for Android iOS Phones with heart rate blood pressure monitor multifunction Andriod smart watch with steps counter sleep monitor sports fitness watch, monitoring blood oxygen saturation allows you to understand your physical condition in real time to track fitness progress ,to know your health status in time.
  • 【More Functions Bluetooth Call Smart Watch】This fitness activity smart watch full screen for iPhone and Android phones includes a bunch of new features including:The bluetooth smart watch can hang up the phone, receive and display WhatsAPP /Text /Facebook /Twitter /Messenger reminder.Support sedentary reminder, alarm clock, stopwatch, timer,weather information,music control, remote camera control compatible with Android 5.0 and above or iOS 9.0 and above smartphones.

Fix 2: Install SQL Server System CLR Types for a client application

When the application only needs the spatial client dependency, install Microsoft’s standalone SQL Server System CLR Types package rather than adding an entire server instance. Microsoft describes this package as containing the components that implement the geometry, geography and hierarchyid types and says it can be installed separately so client applications can use them outside SQL Server.

  1. From Microsoft’s Download Center, locate SQLSysClrTypes.msi for the SQL Server generation named by the application’s error. The package listed by Microsoft as version 15.0.2000.5 was published on 2024-07-15.
  2. Select the installer architecture that matches the application, not merely the operating system. Choose x64 for a 64-bit process and x86 for a 32-bit process.
  3. Close the affected application and any related service that might have loaded the old assembly.
  4. Run the MSI as an administrator and accept the installation prompts. If Windows Installer reports that a product of another generation is already present, stop rather than forcing files over it; confirm the application’s required generation first.
  5. Restart Windows, or at minimum restart the application and its related service, so the process loads the newly installed native library.
  6. Repeat the operation that produced the error. If the message changes to a different versioned filename, use that new filename to reassess the generation rather than renaming the file you just installed.

Important Windows 11 and package-version qualification

The Download Center listing for version 15.0.2000.5 names Windows 10, Windows Server 2016 and Windows Server 2019 as supported operating systems and labels the package for legacy SQL Server and Windows versions. Windows 11 is not listed in that support statement. That does not establish that every Windows 11 application will fail, but it does mean you should follow the application vendor’s supported dependency guidance and Microsoft’s direction to use the latest NuGet package for newer SQL Server versions rather than assuming the legacy MSI is the right choice.

Fix 3: Repair a damaged Windows Installer cache

A repair can fail even when the SQL Server files are genuinely missing because Windows Installer cannot find the cached MSI or MSP files it needs. Microsoft identifies %windir%Installer—normally C:WindowsInstaller—as the cache used for SQL Server update, uninstall and repair operations. Do not empty this directory to reclaim disk space.

Rank #3
New Bee Guitar Cable 10ft Electric Instrument Bass AMP Cord | 6.35mm Jack, Durable Design, Stage and Home Studio Use, Low Noise Shielded Electric Cord for Bass, Keyboard, Amp, Mixer
  • [Low Noise High Fidelity] New bee guitar cord with 22AWG oxygen-free-copper center conductors provides enhanced signal transfer, the PVC insulation material and the high-density stranded copper double shield provide noise rejection for quiet operation
  • [Ideal for Choice] New bee 1/4 straight and right angle metal connectors, ensures a secure connection in any instrument, pedal, or amp jack. L shape great fro on stage guitar stands
  • [Wide Compatible] Suitable for mixer, power amplifier, microphone, effector, decoder, equalizer, electoronic organ, electric guitar, electric bass and other electronic equipments. Widely used in the installation of smart home, karaoke speaker, professional stage audio, etc
  • [Easy Disassemble] Making incidental repairs quick and easy! Very nice, flexible cable
  • [Dont Hesite to Order] 24 hours customer services and professional technology team are standing by
  1. Read the exact setup error and note the missing .msi or .msp filename. The filename identifies the product and update that Windows Installer cannot locate.
  2. Use the original SQL Server media and Microsoft’s documented FixMissingMSI or FindSQLInstalls procedure to identify the missing source and restore the cache reference. These procedures are preferable to downloading an arbitrary package from a third-party archive.
  3. If the procedure requests installation media, mount the matching image or insert the original media and point setup to that source. Keep the SQL Server generation and edition consistent with the installed instance.
  4. After the missing cache entry is repaired, run SQL Server Setup Repair again. Capture the SQL Server Setup Bootstrap logs if the repair still fails; they contain the prerequisite and package-level failure details needed for the next diagnosis.

Do not manually rename an MSI, MSP or DLL to satisfy a prompt. Windows Installer validates product codes, patch relationships and signatures; a renamed file can make the cache appear complete while leaving the installation unusable.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

Fix 4: Diagnose a failure that remains after installation

The application and package use different bitness

A 32-bit process cannot use a 64-bit native DLL, and a 64-bit process cannot load a 32-bit DLL. This mismatch commonly produces a “could not load its native dependency” exception even when the file exists. Verify the process architecture again, remove the mismatched client component through Apps or Programs and Features if necessary, then install the correct x86 or x64 package. Do not copy a 32-bit file into a 64-bit process directory or the reverse.

The SQL Server generation is wrong

SqlServerSpatial130.dll and SqlServerSpatial160.dll are different versioned components. Installing one generation does not satisfy an application compiled for another. Use the exact number in the exception and the application’s deployment requirements to select the MSI or repair media.

Rank #4
BSIMB 15.6" Digital Family Calendar & Chore Chart, No Subscription Fees
  • Digital Family Calendar: BSIMB digital calendar wall touch screen puts an end to your chaotic life. Designed for busy families, the digital calendar keeps you organised and in step with your family. Assign different colours and tasks to each family member to make family scheduling easier and more intuitive.
  • Easy Setup and Auto-Sync: Plug in, connect to WLAN and auto-syn your electric calendar in minutes. Digital wall calendar compatible with Google calendar, iCloud calendar, Outlook calendar, Cozi calendar and Yahoo calendar. Add events directly on the device or through the ecalendar app. Electronic calendar stays current whether you're at work or traveling—no manual updates needed.
  • All-In-One Home Assistant: Smart calendar builds habits and encourage independence with personalised chores. Display daily meal plan to reduce the daily ‘What's for dinner?’ stress. To-do lists keep track of everything you want. Turning chores into valuable achievements with stars and rewards, making life easier and more enjoyable.
  • Manage Anytime Anywhere: BSIMB electronic calendar for family stay connected with the powerful ecalendar app. Access and manage your digital wall calendar anytime, anywhere with free features like stars & rewards, photo screensaver, chore charts, meals plans, to-do lists etc. Electronic planner paid features like Magic Import tailor advanced tools for users with special needs.
  • Stay in Touch with Loved Ones: Share photos or videos from your phone to electronic wall calendar with app, instantly update your life moment, and keep in touch with your family, especially those who are far away; you can also surprise your smart calendar digital wall by sending him a wish card; it's also great for keeping tech-illiterate elders in touch with the youngsters.

The managed assembly is present but the native dependency is not

Microsoft.SqlServer.Types.dll is the managed assembly; the versioned SqlServerSpatial###.dll is the native dependency. Seeing the managed file in an SDK assemblies directory does not prove that the native component required by the running process is installed for the same architecture. Recheck both files through a version-matched installation rather than copying either one independently.

The application still has an old process loaded

Close every instance of the application and any service that hosts it. A process that remained running during MSI installation may continue using its previous search path and loaded modules. Restart Windows when a service, scheduled task or background host is difficult to identify.

What’s actually slowing this PC down?

Pick the symptom - the matching free tool is one click away.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

Setup completed but the error changed

A new versioned filename in the error is useful evidence, not a reason to rename files. It usually means the application reached a later dependency check or that a different component has a generation mismatch. Record the complete exception, confirm the application architecture and inspect SQL Server Setup Bootstrap logs before making another change.

Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.Support on Ko-Fi

How to verify the repair safely

  1. Restart Windows if setup changed shared components or requested a reboot.
  2. Open the application using the same account and workflow that originally failed.
  3. Exercise the specific map, spatial query, import or feature that requires the SQL Server types; merely opening the application may not load the dependency.
  4. Confirm that the original error no longer appears and that no new architecture or version error replaces it.
  5. If it fails again, save the application’s full exception and the relevant SQL Server Setup Bootstrap logs. Give support the exact filename, application bitness, SQL Server generation, installer architecture and setup result.

What not to do

  • Do not use a single-DLL download site. The file may be modified, incomplete, incorrectly versioned or built for another architecture.
  • Do not rename a DLL from another SQL Server release. The version number is part of the compatibility information, not decorative text.
  • Do not copy a 32-bit file into a 64-bit process directory. Windows can report the same missing-dependency wording for an architecture mismatch.
  • Do not delete the Windows Installer cache. SQL Server maintenance can depend on files in C:WindowsInstaller.
  • Do not force an MSI from an unrelated generation. A successful-looking installation can leave the application bound to an incompatible managed/native pair.

Which route should you choose?

Decision factor SQL Server Setup Repair SQLSysClrTypes MSI
Scope Repairs the existing SQL Server installation and its selected features Installs the client spatial type components without repairing a complete server instance
Best fit A local SQL Server feature has missing or corrupt files A client-only application needs the spatial dependency
Required source Matching SQL Server installation media Microsoft’s Download Center package for the required generation and architecture
Architecture rule Use media and feature selection appropriate to the installed instance and application x86 or x64 must match the process that loads the DLL
Typical failure to investigate Missing prerequisites, damaged files or setup cache entries Wrong generation, wrong architecture or unsupported legacy package

Microsoft’s SQL Server 2016 SP1 Feature Pack also lists SQLSysClrTypes.msi as a standalone package. Treat that listing as a package-location reference, not proof that every application should use the SQL Server 2016 generation.

Is the DLL itself safe?

The filename alone does not establish whether a file is malicious or legitimate. A copy installed by a signed, version-matched Microsoft MSI or SQL Server setup is the appropriate source. A file obtained from an untrusted archive has no such assurance and can also be technically wrong even if it is not malicious. If you suspect tampering, stop the application, run your organization’s standard security scan, and reinstall the dependency from Microsoft media rather than trying to repair the downloaded file.

Final checklist

  • The full error identifies the exact versioned spatial DLL.
  • The application’s x86 or x64 architecture is known.
  • The SQL Server generation matches the requested filename and installer.
  • You selected SQL Server Repair for a damaged server installation or SQLSysClrTypes for a client-only dependency.
  • Any missing MSI or MSP cache entry was repaired before rerunning setup.
  • The application and related services were restarted and the original workflow was tested.
  • Persistent failures were checked against setup logs instead of being “fixed” by renaming or copying a random DLL.

As an optional shortcut after the manual checks, Outbyte PC Repair can address more than 100 common Windows issues, including broken system elements and shared DLL problems, and includes cleanup, vulnerability checks, a real-time boost and crash logging. It runs on Windows 11, 10, 8 and 7; its free trial lasts at least two days before a paid subscription. It complements antivirus software, does not replace it, and results vary—no tool repairs every crash.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.

DLL errorsMicrosoft.SqlServer.TypesSQL ServerWindows 10Windows 11

Leave a Reply

Your email address will not be published. Required fields are marked *

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

Recommended PC Tool
Recommended PC Tool
Crashes, No Sound, or Screen Glitches?Free driver scan
PC Slower Than It Used to Be?Free scan - under a minute

Two free Windows tools

One Free Minute Could Fix That PC

Before you go - each of these free tools takes about a minute and tackles what quietly slows a Windows PC down.

Special offer. View Outbyte info, uninstall instructions, EULA, and Privacy Policy.