MS SQL database editor

[Smithy]

Hi,

I'm looking for a free/open source MS SQL editor. Something I can run from my machine and connect to a remote database.

Any suggestions?

 

[Smithy]

I've tried SQL Server Management Studio. It seems overkill for what I wanted to do. It wasn't very intuitive and so I couldn't work out how to connect to and edit my database.

Edit: More specifically, I receievd an error when trying to connect to my database;

A network-related or instance-specific error occured while establishing a connection to SQL server

Very good, but what does that mean? And why won't it connect?

I'm after something similar to phpMyAdmin. Something which will easily allow me to edit my database.

 

[Smithy]

I'm using Connect Object Explorer. I've selected Database Engine as Server type, entered the correct IP under Server Name, SQL Server Authentication and then entered the correct login details.

 

[Smithy]

I've changed the Network Protocol to TCP/IP. No joy.

 

[Smithy]

I've just spoken to the hosting company. They do not have a block on remote connections.

Did you restart the MSSQL service after enabling TCP/IP?

I did.

Are you connecting to the correct instance?

I am.

Can you telnet to the remote machine on port 1433?

I cannot.

A message is displayed; "Could not open connection to the host, on port 1433: Connect failed"

If that doesnt work check that the TCP/IP service is running in Configuration Manager and verify the port its running on, run this in DOS window:

netstat -an

and look for port 1433 - or the port specified in configuration manager/tcpip

1433 is the port specified. The service is running in Configuration Manager but does not appear in the list when a run a netstat -an.

I have no experience with Windows grep. What does it do and how will it help me here?

 

[Smithy]

I believe it's shared.

 

[Smithy]

I'm using an address supplied to me by the previous website administrator. I trust that it is the correct address.