August 26, 2009 at 8:45 pm
Hi, I am currently developing an application for Mac OS that needs to connect to a Microsoft Sql Server database. Therefore I decided to use a virtual machine inside VMWare Fusion to simulate the real database that my application will have to connect.
Inside this virtual machine I've installed Windows XP and Sql Server 2000. I then created a test database with just one table to see if everything was working fine.
I could connect to this test database using the Query Analizer, however I just couldn't connect to it from using Squirrel SQL from my host machine.
I've worked with Oracle databases for some time, and I know that you should create a TNS Listener service so that others can connect to your database. Is there a similar thing in Sql Server?
What can I do to connect to this database?
Thanks,
Felipe
August 26, 2009 at 9:23 pm
Hello again. I've managed to solve it.
It appears that the jdbc connection string in Squirrel is wrong.
It is: jdbc:sqlserver://[server_name]:[1433]
When it should be: jdbc:sqlserver://[server_name]:[1433];databaseName=[db_name]
Thanks,
Felipe
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply