MS SQLServer non-default Instance

michel.weber
Posts: 256
Joined: Sat Oct 08, 2005 12:40 pm

MS SQLServer non-default Instance

Post by michel.weber »

Hi

I have been trying to get DB Walker to work with a non-default instance of SQLServer 2005. Unfortunately i have no luck so far.

Any ideas what could be wrong? i keep getting the message below :

Configuration Error

There was a problem with the request:
Error on Creating SQL Connection: java.sql.SQLException: Unknown server host name 'PFB417\MIKE'.
User avatar
jason112
Site Admin
Posts: 347
Joined: Tue Oct 26, 2004 5:35 pm

MS SQLServer non-default Instance

Post by jason112 »

I'm guessing you're entering "PFB417\MIKE" as the host, where "PFB417" is the actual host and "MIKE" is the named instance?

Each instance should be listening on its own port, so you can configure DBWalker to connect to the proper port without using the name of the instance.
michel.weber
Posts: 256
Joined: Sat Oct 08, 2005 12:40 pm

MS SQLServer non-default Instance

Post by michel.weber »

Thanks

That did it.