I'm new Geoserver user and have problem to understanding "how can I make
connection between Geoserver and SQL Server in DataStore". I've already had
my imported shapefile with spatial part and geometry field in table at SQL
Server. When I try to enter the details in Geoserver data store page
(Microsoft SQL Server) and click on Save button I've got the following error
message:
/Error creating data store, check the parameters. Error message: Unable to
obtain connection: Cannot create PoolableConnectionFactory (Login failed for
user 'VIS'.)/
So could anyone please help me and show me the solution or tell me what is
the problem?
Any guidance would be greatly appreciated...
Kind Regards,
Mary
P.S. please find attached log file for more details.
>So could anyone please help me and show me the solution or tell me what is the problem? Any guidance >would be greatly appreciated...
Well at risk of being too simple, but have you checked that you can log into the sql server database with those credentials from the server with geoserver installed? (ie dont have firewalls etc in the way).
Notice: This email and any attachments are confidential.
If received in error please destroy and immediately notify us.
Do not copy or disclose the contents.
I've already connected to my database in SQL Server 2008 R2 and can see all
details and spatial part of my shpefile.
As it mentioned in error message the problem is about the USER! Do I need to
create any username and password in SQL database? Actually I just entered
the name of USER in my PC!
On Thu, Nov 7, 2013 at 12:04 PM, Mary [via OSGeo.org] <[hidden email]> wrote:
Hi Phil,
Thanks indeed for answering
I’ve already connected to my database in SQL Server 2008 R2 and can see all details and spatial part of my shpefile.
As it mentioned in error message the problem is about the USER! Do I need to create any username and password in SQL database? Actually I just entered the name of USER in my PC!
Regards,
Mary
If you reply to this email, your message will be added to the discussion below:
Hi Mary,
to be able to connect to SQLServer from GeoServer, you should enable the mixed mode authentication in SQLServer (if it’s not already enabled) and connect using a SQLServer user credentials, not the PC user ones. You can use the sa system user or create a new one from SQLServer Admin UI and give it access to the database.
I’ve already connected to my database in SQL Server 2008 R2 and can see all
details and spatial part of my shpefile.
As it mentioned in error message the problem is about the USER! Do I need to
create any username and password in SQL database? Actually I just entered
the name of USER in my PC!
Sent from the GeoServer - User mailing list archive at Nabble.com.
November Webinars for C, C++, Fortran Developers
Accelerate application performance with scalable programming models. Explore
techniques for threading, error checking, porting, and tuning. Get the most
from the latest Intel processors and coprocessors. See abstracts and register http://pubads.g.doubleclick.net/gampad/clk?id=60136231&iu=/4140/ostg.clktrk
SQL Server 2008 R2.docx (1M)