Showing posts with label install. Show all posts
Showing posts with label install. Show all posts

Sunday, February 19, 2012

Completely Remove SQL 2005

Hi,
Can any 1 guide me how to completely remove SQL 2005 ?

Currrently i have a problem to install SQL 2005 where before this i already install SQL 2005 and uninstall it and delete some of the file inside the SQL folder, after that i reinstall the SQL 2005 and it get many error while installing.

Can some 1 guide me how to unintall it completely?

PS: im using VistaAre you attempting to install this directly from teh CD on the machine, or from a network share?|||1) Stop all SQL Services.
2) Uninstall all Microsoft SQL services in Control Panel
3) Delete all files in %Program Files%\Microsoft SQL Server directory
4) Open REGEDIT32 and delete key "HKCU\Software\Microsoft\Microsoft SQL Server"
5) Open REGEDIT32 and delete key "HKLM\Software\Microsoft\Microsoft SQL Server"

Use REGEDIT32 on your own risk.

Compile SQL Please Help

Welcome
i am want to teach sql . how to
install compile<comedy>How do I reading manual?</comedy>

<serious>I don't think it's physically possible for anyone to understand what you've just asked.</serious>|||i think he/she wants to know how to download and install the free sql server express software|||if that's the case, it's here:

http://msdn.microsoft.com/vstudio/express/sql/download/|||I hope you want to teach .. yourself ;)

I am afraid you cannot move your experience directly from Oracle to SQL Server.
You need to install SQL Server and tools – Query Analyzer for SQL Server 2000 or Management Studio for SQL Server 2005.|||thank you very much

Tuesday, February 14, 2012

Compatibility with sql 2000

Can I Install Sql 2005 in a machine with sql 2000? Will I have problems when the final version of sql 2005 comes out?At RTM of SQL Server 2005 we will support installing it on a machine that already has SQL Server 2000 installed. We have put a lot of work in this area to insure they can install harmoniously on the same machine. We don't recommend installing SQL Server 2000 after SQL Server 2005 is already installed - but the reverse is okay.

Dan|||1. RTM is still a few months in the future, what about right now, will it break 2000?
2. If not, will it be OK if 2000 has Report Server installed?

Thanks.

Sunday, February 12, 2012

Compatibility between installation of MSDE 2000 and SQLServer 7

I want to install MSDE 2000 rel A on a Windows Server 2000 where SQLServer 7
is installed.
CAn I do it? Can MSDE and SQLServer live together?
Must I do any action before to install MSDE?
Thank you in advance
enzo giurleo
hi Enzo,
Enzo Giurleo wrote:
> I want to install MSDE 2000 rel A on a Windows Server 2000 where
> SQLServer 7 is installed.
> CAn I do it? Can MSDE and SQLServer live together?
> Must I do any action before to install MSDE?
> Thank you in advance
> enzo giurleo
you can install MSDE 2000 on a pc already hosting SQL Server 7.0..
SQL Server 7.0 will be the default instance, as it does not support multiple
instances, while MSDE will become a named instance you have to connect to
using the <computername>\<instancename> syntax but...
but...
MSDE 2000 will install and register it's own part of the shared component,
such as SQL-DMO and so on, and it does not contain the full client tools
like Enterprise Manager, Query Analyzer, Profiler and so on, so you loose
the possibility to administer your SQL Server 7.0 with your original 7.0
tools...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Compatability between MSSQL server and MSDE??

Can we install both MSSQL and MSDE in the same server? And can they operate
at the same time? Just in case when the CAL is exceeded in the SQL server I
can use MSDE as alternative for other applications.
Yes, you can run them at the same time. Only one can be a default instance, the other(s) need to be
named instances.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"AdrianY" <AdrianY@.discussions.microsoft.com> wrote in message
news:8B83C9E8-0449-4ECA-85D2-7556D5121F5E@.microsoft.com...
> Can we install both MSSQL and MSDE in the same server? And can they operate
> at the same time? Just in case when the CAL is exceeded in the SQL server I
> can use MSDE as alternative for other applications.

Compatability between MSSQL server and MSDE??

Can we install both MSSQL and MSDE in the same server? And can they operate
at the same time? Just in case when the CAL is exceeded in the SQL server I
can use MSDE as alternative for other applications.Yes, you can run them at the same time. Only one can be a default instance, the other(s) need to be
named instances.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"AdrianY" <AdrianY@.discussions.microsoft.com> wrote in message
news:8B83C9E8-0449-4ECA-85D2-7556D5121F5E@.microsoft.com...
> Can we install both MSSQL and MSDE in the same server? And can they operate
> at the same time? Just in case when the CAL is exceeded in the SQL server I
> can use MSDE as alternative for other applications.