Print Page | Close Window

SQL Server manage

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=30596
Printed Date: 14 April 2024 at 11:36am
Software Version: Web Wiz Forums 12.07 - https://www.webwizforums.com


Topic: SQL Server manage
Posted By: Roberto Randall
Subject: SQL Server manage
Date Posted: 13 December 2012 at 1:13pm

I propose an idea to make a new program:

It is necessary for everyone to have a quick and easy access to the databases "SQL Server" and "MySQL".

Whenever I want to create, delete or modify a table or field in one of my SQL Server database I have to create ASP code to do so. As happens to me will happen to many people.

If you make a program (web Asp) entering connection data database can be managed easily think that would very good sale.



-------------
https://www.lanocion.es - https://www.lanocion.games - https://www.lanocion.chat



Replies:
Posted By: WebWiz-Bruce
Date Posted: 14 December 2012 at 11:58am
Although most web based Database Managers for SQL Server are quite expensive, you do have SQL Server Manager Studio Express free from Microsoft to install on your desktop to manage SQL Server databases with.

With mySQL you have PhpMyAdmin which is a free web based Database management tool for managing mySQL databases with, which is pretty much industry standard now.


-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: Roberto Randall
Date Posted: 14 December 2012 at 6:24pm

SQL Server Management Studio Express must be installed on the server?

I need a program to install it on my pc. I have not the server.

Thanks,



-------------
https://www.lanocion.es - https://www.lanocion.games - https://www.lanocion.chat


Posted By: IanSmithISA
Date Posted: 15 December 2012 at 8:03am
Good  morning

You can goto 

http://www.microsoft.com/en-gb/download/details.aspx?id=26729

and down SQL Server EXpress with tools.

Although this download will include the SQL Server database, when you do the install you can select the management tools only.

I have been managing my SQL Server databases this way since I started hosting here without any problems.

Bye

Ian


-------------
Why does anyone need more than an 80x25 character only VDU?


Posted By: WebWiz-Bruce
Date Posted: 15 December 2012 at 9:29am
You can also download SQL Server Management Studio on it's own to install on your PC:-

http://www.microsoft.com/en-gb/download/details.aspx?id=29062

You need to download either of the two below depending if you are running 64 or 32 bit versions of Windows:-

ENU\x64\SQLManagementStudio_x64_ENU.exe
ENU\x86\SQLEXPRWT_x86_ENU.exe


-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: Roberto Randall
Date Posted: 15 December 2012 at 9:47am
Thanks, I will download and set it up.

-------------
https://www.lanocion.es - https://www.lanocion.games - https://www.lanocion.chat


Posted By: Roberto Randall
Date Posted: 15 December 2012 at 9:20pm
Sorry, I speak Spanish and do not quite understand. I present the installation screen. Please tell me what options I have to choose. Thank you.
 
 


-------------
https://www.lanocion.es - https://www.lanocion.games - https://www.lanocion.chat


Posted By: WebWiz-Bruce
Date Posted: 17 December 2012 at 9:32am
I would uncheck the one for LocalDB as this is a new type of SQL Server database from Microsoft and you do not need to install this.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: Roberto Randall
Date Posted: 17 December 2012 at 11:48am
Thank you very much, so I will.

-------------
https://www.lanocion.es - https://www.lanocion.games - https://www.lanocion.chat


Posted By: Roberto Randall
Date Posted: 17 December 2012 at 10:00pm

I installed SQL Server Management Studio. I run the "SQL Server Management Studio" and do not know how to connect to the database. I look within my network and the database is not in my network.

Could anyone help me connect to the SQL database?

Thanks,



-------------
https://www.lanocion.es - https://www.lanocion.games - https://www.lanocion.chat


Posted By: WebWiz-Bruce
Date Posted: 18 December 2012 at 8:42am
If you are connecting to a remote SQL Server you need to contact the server admin to ask for the host name and user login to the SQL Server.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: Roberto Randall
Date Posted: 18 December 2012 at 10:45am
Thanks, but the server administrator can not give me this information because it would give me access to all your databases.

-------------
https://www.lanocion.es - https://www.lanocion.games - https://www.lanocion.chat


Posted By: WebWiz-Bruce
Date Posted: 18 December 2012 at 12:16pm
Sorry maybe my last post was not clear. 

If you are using a shared database server you would have an SQL Server login that has access only to your own database and not all the databases on the same server.

You would connect to the database server using your login that is granted access to your own database.

For example for customers who have SQL Server Databases on our shared hosting would connect with SQL Server Studio Manager using the database server host name of the database server their database is on and the username and password of their database they wish to connect to. They would then have access only to their own database and not to any of the other databases on the same server.


-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: Roberto Randall
Date Posted: 18 December 2012 at 12:47pm

To connect three fields: server, username and password. In user password and I know with your help, but "server" I have to put?

Sorry, but I'm translating a translator.



-------------
https://www.lanocion.es - https://www.lanocion.games - https://www.lanocion.chat


Posted By: WebWiz-Bruce
Date Posted: 18 December 2012 at 12:55pm
You need to contact your database server provider and ask them for this information to connect to your forum.

If you find out I would suggest keeping it private and not posting it in a public forum.


-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.07 - https://www.webwizforums.com
Copyright ©2001-2024 Web Wiz Ltd. - https://www.webwiz.net