Microsoft SQL Server is a relational database server product by Microsoft. Its primary query languages are T-SQL and ANSI SQL.

learn more… | top users | synonyms (1)

1
vote
0answers
39 views

ArcSDE post installation error?

I had a problem during post installation of ArcSDE for SQL server 2008, and this is the message : The ArcSDE Repository was unsecessfully completed. would you like to view this error? then when I ...
1
vote
1answer
768 views

Unable to register gdb with the server due to sql server client incompatibility

There are two virtual machines: One where I've created an enterprise geodatabase on a Microsft SQL 2014 server- with a Windows Server 2012 R2 64-bit Operating system And a second machine where ...
1
vote
1answer
22 views

Creating layer where more attributes are presented

I would like to create a layer in ArcGIS containing polylines, that are rendered by combination of more than one attribute. I can create layer where the polylines are of different thickness or ...
0
votes
1answer
34 views

How Update one table row with combare with the other polygon table using their geom in SQL Server

a-> points b -> Polygon i want to update city trow in table a with compare b of geom in SQL server this is the PostgreSQL Query update a set city=b.name from b where st_contains(b.the_geom, a....
0
votes
0answers
82 views

WFS query against SQL Server - Returned results not restricted by query

I have an SQL Server 2012 table, which contains a DbGeometry column with a spatial index. Then a Geoserver 2.7 using it. The problem is that when I do a WFS query it doesn't restrict the results to ...
2
votes
2answers
75 views

Any free Tools to display more than 5000 geography objects in SQL Server?

SQL Server 2008 and up allow you to create a spatial index. If you select records that include a geography or geometry object, a spatial data tab appears that can display up to 5000 points or lines or ...
4
votes
1answer
62 views

Can a computer with ArcGIS Server connect to SQL Express in a different domain?

As you can see in my diagram, we have ArcGIS set up with 2 other computers for load balancing. We also have SQL Express 2008 but it's under a different domain. My manager's goal was to a) register ...
5
votes
1answer
71 views

How to use MAX SQL statement in ArcGIS?

I would like to use a MAX SQL query for a column in a definition query, where there records that are being queried are the MAXIUM from the field UPDATE_DATE_DATE while grouping by the field NUMBERCYLA....
1
vote
0answers
190 views

What if 'geometry_columns' already exists in MSSQL Server Database?

When trying to load a .SHP into MSSQLSpatial using OGR2OGR, I get the following error: ERROR 1: Error initializing the metadata tables : [Microsoft][ODBC SQL Server Dr iver][SQL Server]There is ...
0
votes
0answers
35 views

Copying ArcSDE environment from LIVE to TEST with SQL Server?

I was looking for some advice on how best to go about migrating a copy of our LIVE sde environment across to our TEST sde environment which are on two separate servers - both running MS SQL 2012. I ...
1
vote
2answers
240 views

Using Python to backup ArcSDE geodatabase on SQL Server Express?

Is it possible to use Python to do a backup of ArcSDE databases stored in SQL Server Express? I have been using a custom executable that uses Arcobjects IDataServerManagerAdmin.BackupGeodatabase() ...
1
vote
0answers
139 views

QGIS Connection with MSSQL localdb not possible correctly

I installed MSSql Server Express with localDB. Everything looks ok. The connection with the LocalDB is nessesary and the tables and views are displayed in the QGIS MSSQL Dioalog. A primary key is ...
8
votes
3answers
2k views

How to convert from SQL Server geometry BLOB to something else?

I have a CSV data file from a 3rd party that is an exported SQL Server table. They simply did a select * from foo and output the result to a text file and sent it over. In their table is column of ...
4
votes
3answers
137 views

Migrate datatypes from geometry to geography in MS SQL

I have three ESRI feature classes (POINT, LINE and POLYGON) that contain a geometry datatype column with data in a projected coordinate system. I'm looking for a way that I can convert & project ...
6
votes
2answers
425 views

Draw SQL server geometry records as graphics on map using ArcGIS API for WPF 2.4 -can it be done and how?

I have records (of public festivals changing daily) in the in SQL server 2012 that have a geometry column (polygons where they occur). I need to show the records as graphics on a map using ArcGIS ...
1
vote
0answers
142 views

Reverse geocoding from sql server

I have a lot long/lat data in MS SQL Server, i want to do reverse geocoding by using openstreetmaps or some other free web service, and on the end i want to display all of that in report builder, does ...
0
votes
1answer
52 views

Geodatabase disappears

I have an old ArcGIS 10.1 in my laptop. While I'm trying to create a geodatabase it gets created, but doesn't let me create new featureclass and/or feature dataset. I get the error:" failed to connect ...
1
vote
1answer
75 views

Does SQL Server Data Need to be Spatial

In reference to my previous question. I am looking for the benefits of telling SQL Server your data is spatial. For instance, I have a duplicate of that table generated by the Shape2SQL tool (see ...
1
vote
1answer
1k views

SQL Server Spatial Querying

I am looking for ways to learn querying for SQL Server Spatial (2008/2012). I have a table created from Shape2SQL and have been trying to run a simple intersection query to get results from that ...
1
vote
0answers
46 views

sql server geometry find points intersection buffer

How do I find the point of intersection of buffer?
2
votes
0answers
170 views

ArcGIS Operation Dashboard

I am working on ArcGIS operation Dashboard. There is an widget on the top left corner “ Model Manager”. Here the Model manager will read the data from ForecastStage_MPT and ForecastTimePT database ...
2
votes
0answers
93 views

How to create MBtiles from geoserver [closed]

How to generate mbtiles in geoserver? using openlayers for displaying geoserver layer for example calling wms layer like this new OpenLayers.Layer.WMS("Kanpur", "http://localhost:8080/...
0
votes
0answers
71 views

How to load points in a SQL server polygon table?

I have a spatial table in SQL server which stores both points and polygons geometry and I am using the table to return geoJSON for API calls. I want to load some points to this table with shapetype ...
1
vote
1answer
345 views

why can one user register a geodatabase with the server and the other user can not?

So i have two users; arcgis_db and AD\raclark, one can publish a service the other can not. It all goes fine till i get to the 'service editor' screen and click 'analyze'. One user, arcgis_db comes ...
1
vote
0answers
40 views

GeoWebCache Speed SQL Server Store

How to increase GeoWebCache speed, Am using geoserver 2.7.2 for tile cache and data store creating from a SQL Server database it will take 1 day and above to complete cache and it terminated several ...
4
votes
0answers
241 views

QGIS 2.10.1 & SQL Server 2014

I'm struggling to load spatial data into QGIS from SQL Server 2014. I have a table with 4 geography columns (3 are polygon layers, one is a point layer). The table has a primary key column that is a ...
2
votes
0answers
371 views

Deploy Web AppBuilder for external access

I am developing an app using Web AppBuilder within ArcGIS Online. The data are hosted in in-house SQL Server, not in ArcGIS Online. I have tested deploying in IIS, it works well, no issues. ...
0
votes
1answer
56 views

Error: Failed to convert: Database Connections… when trying to export to shape file

I have created a table with some derived data in SDE using sql server. The following is an example row of the table: T_OBJECTID T_GEOID T_STATE T_COUNTY T_TRACT T_NAME T_LSAD T_CENSUSAREA ...
0
votes
0answers
51 views

Styling MSSQL Layers in QGIS

I have set up Ordnance Survey MasterMap as 2 MSSQL layers (area and text) which are working great, I can style the layers as I would do usually with shape files but I'm struggling to work if it's ...
1
vote
0answers
48 views

Managing privileges for an ArcSDE database using SSMS

I am trying to mange users for my ArcSDE database via SSMS as opposed to tools in ArcGIS, to do this i want to set up two new user roles, data-viewer and data-editor, and then assign users to those ...
1
vote
1answer
642 views

Database connection fails when using db authentication, succeeds using OS

When i attempt to make a connection to a database on my SQL Server 2014 sever via Database connections in ArcCatalog using with db authentication i get "Connection was attempted with an older ...
0
votes
0answers
88 views

Remote SQL Server, Crystal Reports and Geospatial Join

I have: A remote SQL server (2008 R2) that I have access to (But NOT full control of) which contains my source data including OSGB 1936 Geometry [ESPG: 27700] In house SQL Server 2008 R2 A Crystal ...
1
vote
0answers
183 views

qgis unable to connect to ms sql server using sql authentication

I am getting the following error when I try to set up a connection to a MS SQL Server database using sql server authentication. I did find a bug report from 2014, but that was apparently fixed and ...
0
votes
1answer
230 views

SQL Server table not updating in ArcGIS Online map

I have a SQL Server table in my ArcGIS Online web app. It is related to 2 other feature classes also in my map. The source table is a non spatial table being related on a common field. Not sure ...
2
votes
1answer
196 views

How to correct topology area boundary errors (slivers/gaps) on arcs in arcgis / arcsde

I use arcgis 10.1 (arcinfo licence) with arcsde to connect to a SQL Server database. The initial dataset has around 100k polygons (used for land registration, having a resolution that is around 1cm ...
0
votes
1answer
103 views

How do I generate 3d WKT FROM A Sql Server geometry or geography types

If I have the point POINT (-75.45454 25.12345 1024 ) in a geometry or geography column in SQL Server, but render it with STAsText() I lose the Z dimension. SELECT geography::STGeomFromText('POINT (...
2
votes
1answer
271 views

convert ordnance survey easting and northing data to WGS84 latitude longitude values

The C# code published here is not very accurate as also mentioned by tanoshimi. I think this has to do with the lack of 'approximate Helmurt transformation'. Just curious is anyone aware of some ...
0
votes
1answer
182 views

MS SQL table with geometry field to feature class

I have a table in a native SQL database (no geodatabase, dc_geobank_public.sde in the code) with cca. 300 000 records and 18 fields. Two of the field contains projected X and Y coordinates, and one ...
1
vote
0answers
50 views

ArcGIS SQL Server - Using Windows Authentication

I want to use a domain level service account to manage my database connections. This account is added as a Windows authenticated account in SQL Server 2012 as a sysadmin. If I try to use this ...
2
votes
1answer
2k views

Adding SQL Trigger to update field on INSERT (multiple rows)

I have an address point Feature Class that has an addressID field. I am trying to write a trigger that will in effect auto increment this field when a new address is added to the map. I cannot alter ...
1
vote
2answers
86 views

Database Server Node vs. Database Connection Node

What are the main differences between the Server Node and the Connection Node? The only difference I have been able to find is that the Server Node is intended for administrative tasks while the ...
1
vote
0answers
214 views

FME 2015.1.01 and SQL Server 2012 Native Client Issues

I'm having trouble connecting to a SQL Server 2008 database from FME 2015.1.01 on a computer with SQL Server Management Studio 2012, including SQL Server Native Client. Here's the error message: MS ...
5
votes
1answer
79 views

Move/Shift a line toward x and y axises in SQL-Server

Is there a function in SQL Server to move/shift a geometry toward X or Y axises?
0
votes
1answer
381 views

Cannot add database connection using windows authetication SQL Server and ArcSDE 10.3

We can't seem to add a database connection from ArcSDE to sql server 2008 using ArcCatalog 10.3.1 from a specific computer with a specific username. When trying to add a database connection using this ...
1
vote
0answers
96 views

LOX table shows up instead of an address locator in SDE geodatabase on SQL server 2012

Tried to copy an address locator from a network share to an SDE database, that worked. Tried the same thing on another database and it shows up in the target geodatabase as an SDE table with LOX in ...
1
vote
1answer
292 views

Adding point layer in QGIS from SQL Server failing

I just downloaded QGIS a few days ago (version 2.8.2-Wien) but I am not able to get it to work as I thought it would. I tried pulling in spatial data from sql server (a "geometry" column containing ...
1
vote
1answer
250 views

How to import UTF-8 encoded Shapefiles into SQL Server?

I am trying to load a shape file to sql, using ogr2ogr and Shape2SQL tools. The shape file uses UTF-8 encoding, specified in a .cpg file, and confirmed when opening the file with QGIS. However, as ...
1
vote
1answer
222 views

Heatmap failing in QGIS (2.8.2-Wien)

I am super new to QGIS so I may be doing something really dumb, but it doesn't seem to work to create a heatmap in QGIS Desktop 2.8.2 (just downloaded this yesterday so I think it is the most current ...
0
votes
0answers
143 views

import table from sql database results in empty ouput - ArcMap

I am trying to import a table to a .gdb from a SQL Server database (not spatial). I can see the table's rows and data in ArcCatalog preview. When I import, there are no errors but I get a message: ...
2
votes
1answer
207 views

SQL Server Geography Query works but Geometry Query Does Not - Different Tables, Similar Schemas

I am trying to get a Geometry query to work. A similar Geography query works fine but I must work with a table that uses a Geometry type. Although the Geography version returns lots of records as ...