Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:nhibernate-1.0.2.0


Name and version of the database you are using:MS SQL Server 2005

Hi all,

How can I know the port used by the NHibernet to connect to SQL Server?

I need to do this to filter the IP´s and port on Windows Firewall of Server
where the SQL Server 2005 is located.

thanx!!!

Why do You think that NHibernate uses other port than all the other SQL server clients? So, better search/ask from MS SQL related forums/sites/newsgroups.

But anyway, the port can be seen on SQL server Network configuration, details of TCP/IP protocol. (SQLServer configuration manager)

Gert

The following information will asstist you in changing the default server port

When you use the hsqldb.jar to start the database the defualt port is set to 9001.

You can test easily with a netstat -a or telnet localhost 9001
So if you want to change the port do the following.

Edit the services file and add
hsql 1701/tcp #hibernate sql
This is not required by I like to do it so that it is reserved.

Next,
Start up the SQL database with the new port # defined.
Like so: java -classpath hsqldb.jar org .hsqldb.Server -port 1701

Again run a test to verify
netstat -a or telnet localhost 1701

If you want to make this a perm change then you need to edit the server.properties file. See link below for more details.

Also
See this link as a reference http://hsqldb.org/doc/src/org/hsqldb/Server.html
and
http://hsqldb.org/ for general info

I hope this helps.