CODEWITHSUNDEEP
sql-serverliferay
Clay Banks
Clay Banks

Reputation: 4581

Connecting Liferay to SQL Server Database

So I'm trying to connect to our SQL Server Database via the portal-ext.properties, but before I do I want to make sure I do it correctly.

I'm confused as to what goes in place of "localhost" and "/lportal"

jdbc.default.driverClassName=net.sourceforge.jtds.jdbc.Driver
jdbc.default.url=jdbc:jtds:sqlserver://localhost/lportal
jdbc.default.username=my_user
jdbc.default.password=my_password

Do I replace localhost with my site's url? and Do I keep lportal as is?

Any help would be greatly appreciated

Upvotes: 1

Views: 5339

Answers (2)

Up_One
Up_One

Reputation: 5271

Maybe this picture will explain better- where A are your databases!

Maybe this picture will explain better- where A are your databases

Upvotes: 1

Up_One
Up_One

Reputation: 5271

jdbc.default.url=jdbc:jtds:sqlserver://localhost/lportal

Shold be something like this 

jdbc.default.url=jdbc:jtds:sqlserver://"Sql Server hostname here"/"database name here"

And also you can specify the port if is diferent from default !! 1433 !

With the port should be like :

jdbc:jtds:sqlserver://"Sql Server hostname here":"port nr"/"database name here"

Upvotes: 2

Related Questions