[Geoserver-users] SQL Server 2008 datastore connection

GeoServer GeoServer User
1

Hi,

I'm trying desperately to get my connection to work so that I can create a
datastore for SQL Server 2008 running on my machine. I read in an earlier
post from apollolm that they felt their problem getting a connection was due
to the fact they were using the SQL Server 2008 Developer Edition. Is there
a known problem using the Developer Edition with Geoserver 1.7.2? Is my
only recourse to switch to a different version of SQL Server 2008?

Here's what I'm running:
XP Pro SP3
Tomcat 6.0.18
Geoserver 1.7.2 (WAR install)
Plug-ins for 1.7.2
SQL Server 2008 Dev. Ed. (10.0.1600)

I've added all the .jar files for SQL Server for Geoserver 1.7.2 and the
recommended jdbc driver from Microsoft and placed them in the lib folder for
Geoserver per the instructions.

Any help you can provide will be appreciated.

Thanks,
Geney

--
View this message in context: http://www.nabble.com/SQL-Server-2008-datastore-connection-tp22461607p22461607.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

2

Hi all,

I found the solution to my own problem by continuing to dig. First, there
does not appear to be any problem using the Developer Edition of SQL Server
2008 as I have been able to make a connection. Second, even though I got a
connection, I still wasn't seeing the feature datasets in the listings.
That too took some digging and resetting of properties, but it finally
worked. So here are a few things to check out if you are having trouble
getting a connection set up for SQL Server 2008 and/or if you are not seeing
your datasets listed after getting a connection:

1. Make sure listening on the tcp port has not been disabled. I kept
finding that the instance of SQL Server that I was trying to access wasn't
showing up when I did netstat -an however the registry showed that it was
using TcpPort 1433, which is the default. I found this a bit confusing as I
had no problems getting a connection to a different database on the same SQL
Server installation through the ArcSDE plug-in which uses a different port
and was enabled. It seemed illogical that one was working and the other
wasn't. So make sure you go into SQL Server Connection Manager and check
the protocols and ports for the instance you're working with. And if you
find that it's using Dynamic Ports rather than Static Ports, you'll need to
change to Static.

2. I made sure I enabled the SQL Server Agent and Browser services. They
were disabled on my system. Don't know if that made a difference, but after
they were enabled, not only could I establish a connection, but I could see
all my datasets in the listing under creating New Feature Type
Configuration.

3. It appears that you may not be able to use Windows Authentication in the
connection properties. I have SQL Server set up to use both Windows
Authentication and SQL Server Authentication. Once I got the port issue
worked out and found I could create a connection, I tried both user accounts
to see what would work. Leaving everything in a working connection the same
except for the user and password, it failed every time with my Windows
account, but worked with the SQL Server account.

Hope that info helps even a little for anyone else struggling to get SQL
Server set up.

Geney

Geney wrote:

Hi,

I'm trying desperately to get my connection to work so that I can create a
datastore for SQL Server 2008 running on my machine. I read in an earlier
post from apollolm that they felt their problem getting a connection was
due to the fact they were using the SQL Server 2008 Developer Edition. Is
there a known problem using the Developer Edition with Geoserver 1.7.2?
Is my only recourse to switch to a different version of SQL Server 2008?

Here's what I'm running:
XP Pro SP3
Tomcat 6.0.18
Geoserver 1.7.2 (WAR install)
Plug-ins for 1.7.2
SQL Server 2008 Dev. Ed. (10.0.1600)

I've added all the .jar files for SQL Server for Geoserver 1.7.2 and the
recommended jdbc driver from Microsoft and placed them in the lib folder
for Geoserver per the instructions.

Any help you can provide will be appreciated.

Thanks,
Geney

--
View this message in context: http://www.nabble.com/SQL-Server-2008-datastore-connection-tp22461607p22467147.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

3

Hi Geney,

Thank you very much for sharing your experience and solution, I have no doubt it will be invaluable to other years. It would be great if we could capture this on the wiki. Any chance you would be willing to throw this into a "trouble shooting" page for us?

-Justin

Geney wrote:

Hi all,

I found the solution to my own problem by continuing to dig. First, there
does not appear to be any problem using the Developer Edition of SQL Server
2008 as I have been able to make a connection. Second, even though I got a
connection, I still wasn't seeing the feature datasets in the listings. That too took some digging and resetting of properties, but it finally
worked. So here are a few things to check out if you are having trouble
getting a connection set up for SQL Server 2008 and/or if you are not seeing
your datasets listed after getting a connection:

1. Make sure listening on the tcp port has not been disabled. I kept
finding that the instance of SQL Server that I was trying to access wasn't
showing up when I did netstat -an however the registry showed that it was
using TcpPort 1433, which is the default. I found this a bit confusing as I
had no problems getting a connection to a different database on the same SQL
Server installation through the ArcSDE plug-in which uses a different port
and was enabled. It seemed illogical that one was working and the other
wasn't. So make sure you go into SQL Server Connection Manager and check
the protocols and ports for the instance you're working with. And if you
find that it's using Dynamic Ports rather than Static Ports, you'll need to
change to Static.

2. I made sure I enabled the SQL Server Agent and Browser services. They
were disabled on my system. Don't know if that made a difference, but after
they were enabled, not only could I establish a connection, but I could see
all my datasets in the listing under creating New Feature Type
Configuration.

3. It appears that you may not be able to use Windows Authentication in the
connection properties. I have SQL Server set up to use both Windows
Authentication and SQL Server Authentication. Once I got the port issue
worked out and found I could create a connection, I tried both user accounts
to see what would work. Leaving everything in a working connection the same
except for the user and password, it failed every time with my Windows
account, but worked with the SQL Server account.

Hope that info helps even a little for anyone else struggling to get SQL
Server set up.

Geney

Geney wrote:

Hi,

I'm trying desperately to get my connection to work so that I can create a
datastore for SQL Server 2008 running on my machine. I read in an earlier
post from apollolm that they felt their problem getting a connection was
due to the fact they were using the SQL Server 2008 Developer Edition. Is
there a known problem using the Developer Edition with Geoserver 1.7.2? Is my only recourse to switch to a different version of SQL Server 2008?

Here's what I'm running:
XP Pro SP3
Tomcat 6.0.18
Geoserver 1.7.2 (WAR install)
Plug-ins for 1.7.2
SQL Server 2008 Dev. Ed. (10.0.1600)

I've added all the .jar files for SQL Server for Geoserver 1.7.2 and the
recommended jdbc driver from Microsoft and placed them in the lib folder
for Geoserver per the instructions.

Any help you can provide will be appreciated.

Thanks,
Geney

--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.

4

Justin,

I'm new to your list. How do I put this into a trouble shooting page?

Geney

Justin Deoliveira-6 wrote:

Hi Geney,

Thank you very much for sharing your experience and solution, I have no
doubt it will be invaluable to other years. It would be great if we
could capture this on the wiki. Any chance you would be willing to throw
this into a "trouble shooting" page for us?

-Justin

Geney wrote:

Hi all,

I found the solution to my own problem by continuing to dig. First,
there
does not appear to be any problem using the Developer Edition of SQL
Server
2008 as I have been able to make a connection. Second, even though I got
a
connection, I still wasn't seeing the feature datasets in the listings.
That too took some digging and resetting of properties, but it finally
worked. So here are a few things to check out if you are having trouble
getting a connection set up for SQL Server 2008 and/or if you are not
seeing
your datasets listed after getting a connection:

1. Make sure listening on the tcp port has not been disabled. I kept
finding that the instance of SQL Server that I was trying to access
wasn't
showing up when I did netstat -an however the registry showed that it was
using TcpPort 1433, which is the default. I found this a bit confusing
as I
had no problems getting a connection to a different database on the same
SQL
Server installation through the ArcSDE plug-in which uses a different
port
and was enabled. It seemed illogical that one was working and the other
wasn't. So make sure you go into SQL Server Connection Manager and check
the protocols and ports for the instance you're working with. And if you
find that it's using Dynamic Ports rather than Static Ports, you'll need
to
change to Static.

2. I made sure I enabled the SQL Server Agent and Browser services.
They
were disabled on my system. Don't know if that made a difference, but
after
they were enabled, not only could I establish a connection, but I could
see
all my datasets in the listing under creating New Feature Type
Configuration.

3. It appears that you may not be able to use Windows Authentication in
the
connection properties. I have SQL Server set up to use both Windows
Authentication and SQL Server Authentication. Once I got the port issue
worked out and found I could create a connection, I tried both user
accounts
to see what would work. Leaving everything in a working connection the
same
except for the user and password, it failed every time with my Windows
account, but worked with the SQL Server account.

Hope that info helps even a little for anyone else struggling to get SQL
Server set up.

Geney

Geney wrote:

Hi,

I'm trying desperately to get my connection to work so that I can create
a
datastore for SQL Server 2008 running on my machine. I read in an
earlier
post from apollolm that they felt their problem getting a connection was
due to the fact they were using the SQL Server 2008 Developer Edition.
Is
there a known problem using the Developer Edition with Geoserver 1.7.2?
Is my only recourse to switch to a different version of SQL Server 2008?

Here's what I'm running:
XP Pro SP3
Tomcat 6.0.18
Geoserver 1.7.2 (WAR install)
Plug-ins for 1.7.2
SQL Server 2008 Dev. Ed. (10.0.1600)

I've added all the .jar files for SQL Server for Geoserver 1.7.2 and the
recommended jdbc driver from Microsoft and placed them in the lib folder
for Geoserver per the instructions.

Any help you can provide will be appreciated.

Thanks,
Geney

--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.

------------------------------------------------------------------------------
Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
View this message in context: http://www.nabble.com/SQL-Server-2008-datastore-connection-tp22461607p22477762.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

5

Hi Geney,

I just added a troubleshooting section on this page:

http://geoserver.org/display/GEOSDOC/SQL+Server+DataStore

If you are interested, you can just put all the info there. You only need an account on the wiki:

http://geoserver.org/signup.action

Or if you tell me your desired username i can create a account for you. With an account you can freely edit the page (click the "Edit" link at the bottom of the page once you are logged in).

If you don't have the time no problem, I will be sure to throw it on my todo list to put the info you provided up there regardless.

-Justin

Geney wrote:

Justin,

I'm new to your list. How do I put this into a trouble shooting page?

Geney

Justin Deoliveira-6 wrote:

Hi Geney,

Thank you very much for sharing your experience and solution, I have no doubt it will be invaluable to other years. It would be great if we could capture this on the wiki. Any chance you would be willing to throw this into a "trouble shooting" page for us?

-Justin

Geney wrote:

Hi all,

I found the solution to my own problem by continuing to dig. First,
there
does not appear to be any problem using the Developer Edition of SQL
Server
2008 as I have been able to make a connection. Second, even though I got
a
connection, I still wasn't seeing the feature datasets in the listings. That too took some digging and resetting of properties, but it finally
worked. So here are a few things to check out if you are having trouble
getting a connection set up for SQL Server 2008 and/or if you are not
seeing
your datasets listed after getting a connection:

1. Make sure listening on the tcp port has not been disabled. I kept
finding that the instance of SQL Server that I was trying to access
wasn't
showing up when I did netstat -an however the registry showed that it was
using TcpPort 1433, which is the default. I found this a bit confusing
as I
had no problems getting a connection to a different database on the same
SQL
Server installation through the ArcSDE plug-in which uses a different
port
and was enabled. It seemed illogical that one was working and the other
wasn't. So make sure you go into SQL Server Connection Manager and check
the protocols and ports for the instance you're working with. And if you
find that it's using Dynamic Ports rather than Static Ports, you'll need
to
change to Static.

2. I made sure I enabled the SQL Server Agent and Browser services. They
were disabled on my system. Don't know if that made a difference, but
after
they were enabled, not only could I establish a connection, but I could
see
all my datasets in the listing under creating New Feature Type
Configuration.

3. It appears that you may not be able to use Windows Authentication in
the
connection properties. I have SQL Server set up to use both Windows
Authentication and SQL Server Authentication. Once I got the port issue
worked out and found I could create a connection, I tried both user
accounts
to see what would work. Leaving everything in a working connection the
same
except for the user and password, it failed every time with my Windows
account, but worked with the SQL Server account.

Hope that info helps even a little for anyone else struggling to get SQL
Server set up.

Geney

Geney wrote:

Hi,

I'm trying desperately to get my connection to work so that I can create
a
datastore for SQL Server 2008 running on my machine. I read in an
earlier
post from apollolm that they felt their problem getting a connection was
due to the fact they were using the SQL Server 2008 Developer Edition. Is
there a known problem using the Developer Edition with Geoserver 1.7.2? Is my only recourse to switch to a different version of SQL Server 2008?

Here's what I'm running:
XP Pro SP3
Tomcat 6.0.18
Geoserver 1.7.2 (WAR install)
Plug-ins for 1.7.2
SQL Server 2008 Dev. Ed. (10.0.1600)

I've added all the .jar files for SQL Server for Geoserver 1.7.2 and the
recommended jdbc driver from Microsoft and placed them in the lib folder
for Geoserver per the instructions.

Any help you can provide will be appreciated.

Thanks,
Geney

--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.

------------------------------------------------------------------------------
Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.