Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Is there a way to manage sql server express db, remotly, without installing a software.

As a portable apps or a web admin (like phpmyadmin)

share|improve this question
    
I tried sql manager, but I do not have administrator rights so it will not install –  forX Oct 26 '11 at 15:47

2 Answers 2

up vote 2 down vote accepted

There are a couple of web based tools, but last I looked at them they were pretty old and feature incomplete. You really should be using the SQL Server Management tool that comes with SQL Server. There is a downloadable version that can be installed, but you will need admin rights to install it on your machine.

There is no cost to installing SQL Server Management Studio on your computers, so there is no license to worry about purchasing.

share|improve this answer
    
yeah but I dont have admin rights on my computer and will never have. Thats why I need something else. I can also not use remote desktop or software like teamviewer, they'r lock or prohibited. –  forX Oct 26 '11 at 16:41
    
Are you trying to get something so that you can use it from home when VPNed in? –  mrdenny Oct 26 '11 at 16:47
    
no, I want to found a software that some of my colleague can have on their pc and manage the database. but they cant install software like sql manager because they dont have admin right. –  forX Oct 26 '11 at 17:44
    
As far as I know nothing like that exists. They will need to have someone with admin rights install the SQL Server Management Studio. –  mrdenny Oct 26 '11 at 18:24
    
I found this sqlmanager.net/en/products/mssql/manager/matrix, I will try when I got my sql db, seem interesting –  forX Oct 26 '11 at 20:35

Possible duplicate: https://stackoverflow.com/questions/5170/sql-server-management-studio-alternatives-to-browse-edit-tables-and-run-queries/5270#5270

I agree with the accepted answer there: LinqPad which is small and portable (you can use SQL instead LINQ, no worries).

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.