Help with SQL Server 2008 datastore connection

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Help with SQL Server 2008 datastore connection

Jim Dillon

Hello,

 

I’m hoping somebody can help me with setting up a SQL Server 2008 data store. I can’t find any explicit instructions in the documentation, and I’ve searched the mailing list threads back to early 2008. Please excuse me if I’ve overlooked something!

 

Here’s the problem: when I try to set up a SQL Server 2008 data store I can’t get past the connection setting page.

 

What I’ve done so far:

1)      Installed SQL Server 2008 Express

a.       Mixed mode authentication

b.      Created a GISTest database

c.       “gisuser” database user, set to owner of the GISTest database with SQL Server Auth

d.      Loaded some shapefiles using the sqlSpatialTools shape2sql utility

                                                               i.      http://www.sharpgis.net/page/SQL-Server-2008-Spatial-Tools.aspx

e.      Used the SQL Server Configuration Manager to allow TCP/IP settings on port 1433

                                                               i.      http://blogs.msdn.com/b/sqlexpress/archive/2005/05/05/415084.aspx

f.        Tested the TCP/IP connection by running the following in a command window: SQLCMD -E -S YourServer\SQLEXPRESS,1433

2)      Installed uDig to c:\uDig\1.2.2

3)      Installed Microsoft’s JDBC driver for SQL Server (version 3.0)

a.       Copied sqljdbc4.jar to c:\uDig\1.2.2\udig\jre\lib\ext

b.      Copied the x86 versions of sqljdbc_xa.dll  and sqljdbc_auth.dll to c:\windows\system32 (I’m on Windows XP Pro SP3)

c.       Similar to the GeoServer instructions http://suite.opengeo.org/opengeo-docs/geoserver/data/sqlserver.html

4)      Installed imageio-ext

a.       Installed to C:\uDig\1.2.2\udig\imageio-ext

b.      Set environment vars for GDAL_DATA and GDAL_DRIVER_PATH

c.       Copied the java libraries to c:\uDig\1.2.2\udig\jre\lib\ext

5)      Try to set up SQL Server DataStore

a.       Catalog -> “Import…”

b.      Other-> Data, next

c.       DataStore, next

d.      Click on Microsoft SQL Server (no error message at top!)

e.      Connection Page

                                                               i.      Host: <my computer name> or <localhost>, not <computer name>\sqlexpress

                                                             ii.      Port: 1433

                                                            iii.      User: gisuser

                                                           iv.      Integrated Security: false

f.        FAIL

 

The same connection works for the GeoServer SQL Server plugin, so I’m not sure what I’m missing. Please help!

 

Thanks,

Jim


_______________________________________________
udig-users mailing list
[hidden email]
http://lists.refractions.net/mailman/listinfo/udig-users
Reply | Threaded
Open this post in threaded view
|

Re: Help with SQL Server 2008 datastore connection

Stanley Sufficool
Ditto using "Integrated Security" = true and no user name.

On Wed, Aug 10, 2011 at 4:34 PM, Jim Dillon <[hidden email]> wrote:

Hello,

 

I’m hoping somebody can help me with setting up a SQL Server 2008 data store. I can’t find any explicit instructions in the documentation, and I’ve searched the mailing list threads back to early 2008. Please excuse me if I’ve overlooked something!

 

Here’s the problem: when I try to set up a SQL Server 2008 data store I can’t get past the connection setting page.

 

What I’ve done so far:

1)      Installed SQL Server 2008 Express

a.       Mixed mode authentication

b.      Created a GISTest database

c.       “gisuser” database user, set to owner of the GISTest database with SQL Server Auth

d.      Loaded some shapefiles using the sqlSpatialTools shape2sql utility

                                                               i.      http://www.sharpgis.net/page/SQL-Server-2008-Spatial-Tools.aspx

e.      Used the SQL Server Configuration Manager to allow TCP/IP settings on port 1433

                                                               i.      http://blogs.msdn.com/b/sqlexpress/archive/2005/05/05/415084.aspx

f.        Tested the TCP/IP connection by running the following in a command window: SQLCMD -E -S YourServer\SQLEXPRESS,1433

2)      Installed uDig to c:\uDig\1.2.2

3)      Installed Microsoft’s JDBC driver for SQL Server (version 3.0)

a.       Copied sqljdbc4.jar to c:\uDig\1.2.2\udig\jre\lib\ext

b.      Copied the x86 versions of sqljdbc_xa.dll  and sqljdbc_auth.dll to c:\windows\system32 (I’m on Windows XP Pro SP3)

c.       Similar to the GeoServer instructions http://suite.opengeo.org/opengeo-docs/geoserver/data/sqlserver.html

4)      Installed imageio-ext

a.       Installed to C:\uDig\1.2.2\udig\imageio-ext

b.      Set environment vars for GDAL_DATA and GDAL_DRIVER_PATH

c.       Copied the java libraries to c:\uDig\1.2.2\udig\jre\lib\ext

5)      Try to set up SQL Server DataStore

a.       Catalog -> “Import…”

b.      Other-> Data, next

c.       DataStore, next

d.      Click on Microsoft SQL Server (no error message at top!)

e.      Connection Page

                                                               i.      Host: <my computer name> or <localhost>, not <computer name>\sqlexpress

                                                             ii.      Port: 1433

                                                            iii.      User: gisuser

                                                           iv.      Integrated Security: false

f.        FAIL

 

The same connection works for the GeoServer SQL Server plugin, so I’m not sure what I’m missing. Please help!

 

Thanks,

Jim


_______________________________________________
udig-users mailing list
[hidden email]
http://lists.refractions.net/mailman/listinfo/udig-users



_______________________________________________
udig-users mailing list
[hidden email]
http://lists.refractions.net/mailman/listinfo/udig-users
Reply | Threaded
Open this post in threaded view
|

Re: Help with SQL Server 2008 datastore connection

Jim Dillon

Thank you for your reply, Stanley. Unfortunately still no success.

 

From: Stanley Sufficool [mailto:[hidden email]]
Sent: Wednesday, August 10, 2011 8:39 PM
To: Jim Dillon
Cc: [hidden email]
Subject: Re: [udig-users] Help with SQL Server 2008 datastore connection

 

Ditto using "Integrated Security" = true and no user name.

On Wed, Aug 10, 2011 at 4:34 PM, Jim Dillon <[hidden email]> wrote:

Hello,

 

I’m hoping somebody can help me with setting up a SQL Server 2008 data store. I can’t find any explicit instructions in the documentation, and I’ve searched the mailing list threads back to early 2008. Please excuse me if I’ve overlooked something!

 

Here’s the problem: when I try to set up a SQL Server 2008 data store I can’t get past the connection setting page.

 

What I’ve done so far:

1)      Installed SQL Server 2008 Express

a.       Mixed mode authentication

b.      Created a GISTest database

c.       “gisuser” database user, set to owner of the GISTest database with SQL Server Auth

d.      Loaded some shapefiles using the sqlSpatialTools shape2sql utility

                                                               i.      http://www.sharpgis.net/page/SQL-Server-2008-Spatial-Tools.aspx

e.      Used the SQL Server Configuration Manager to allow TCP/IP settings on port 1433

                                                               i.      http://blogs.msdn.com/b/sqlexpress/archive/2005/05/05/415084.aspx

f.        Tested the TCP/IP connection by running the following in a command window: SQLCMD -E -S YourServer\SQLEXPRESS,1433

2)      Installed uDig to c:\uDig\1.2.2

3)      Installed Microsoft’s JDBC driver for SQL Server (version 3.0)

a.       Copied sqljdbc4.jar to c:\uDig\1.2.2\udig\jre\lib\ext

b.      Copied the x86 versions of sqljdbc_xa.dll  and sqljdbc_auth.dll to c:\windows\system32 (I’m on Windows XP Pro SP3)

c.       Similar to the GeoServer instructions http://suite.opengeo.org/opengeo-docs/geoserver/data/sqlserver.html

4)      Installed imageio-ext

a.       Installed to C:\uDig\1.2.2\udig\imageio-ext

b.      Set environment vars for GDAL_DATA and GDAL_DRIVER_PATH

c.       Copied the java libraries to c:\uDig\1.2.2\udig\jre\lib\ext

5)      Try to set up SQL Server DataStore

a.       Catalog -> “Import…”

b.      Other-> Data, next

c.       DataStore, next

d.      Click on Microsoft SQL Server (no error message at top!)

e.      Connection Page

                                                               i.      Host: <my computer name> or <localhost>, not <computer name>\sqlexpress

                                                             ii.      Port: 1433

                                                            iii.      User: gisuser

                                                           iv.      Integrated Security: false

f.        FAIL

 

The same connection works for the GeoServer SQL Server plugin, so I’m not sure what I’m missing. Please help!

 

Thanks,

Jim


_______________________________________________
udig-users mailing list
[hidden email]
http://lists.refractions.net/mailman/listinfo/udig-users

 


_______________________________________________
udig-users mailing list
[hidden email]
http://lists.refractions.net/mailman/listinfo/udig-users