asked on

SQL database manager

I'm looking for a SQL database manager that I can remotely access on my site and delete records, fields, etc. Anybody have any clue what I should look for?

ASKER CERTIFIED SOLUTION

Ryan Chong

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Ryan Chong

More info:
http://msdn.microsoft.com/vstudio/express/sql/

Sham Haque

[no points for me - download link for SSMSE:]

http://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

jumpstart0321

ASKER

Thanks guys, but I believe this tool is only for local management. What if I have to manage my database at a seperate location? I would like to do something like www.mysite.com/Manage.aspx. Any ideas?

Ryan Chong

>>What if I have to manage my database at a seperate location?

Yes, you can. You can use it to connect to your remote database.

Ryan Chong

Refer to this image:

http://www.development.ccs.neu.edu/home/rasala/images/sql/Connect_to_Server_Remote.jpg

try enter the Remote IP address, or Domain Name in field "Server Name", select the "Authentication Mode" and then enter appropiate login user info to login.

ptjcb

SSMSE has no problems connecting to remote servers.

jumpstart0321

ASKER

Thanks guys, I don't know why I didn't try that earlier. I thought I read somewhere that the express edition didn't allow remote connections. I'm very happy:) thanks again:)

Sham Haque

jumpstart:

FYI - you may well have read about Express edition not allowing remote connections. This will refer to the default installation of the database engine - not to the client tools. Glad you got it working!