cancel
Showing results for 
Search instead for 
Did you mean: 

How to Install SQL Enterprise Manager ?

sukhdev_kaloor
Participant
0 Kudos

The standard installation file which sap gives sql4sap.vbs doesnt install the Enterprise manager.

How to install SQL Enterprise Manager (ECC6+Win2003).

regards,

dev

Accepted Solutions (0)

Answers (2)

Answers (2)

clas_hortien
Active Contributor
0 Kudos

Hello,

are you installing SQL 2005 or SQL 2000 ? On SQL 2005 there is no Enterprise Manager anymore, use the SQL Server Development Studio instead.

If you install SQL 2000, do you install on 32bit or 64bit ? If you install on 64bit (IA64) there will no Enterprise Manager, as there is no 32bit emulation for it. Install the tools on a 32bit maschine and manage the 64bit server remotely.

If you install on 32bit or 64bit X64 (32bit emulation) and the EM is not there, you should open an OSS case for it in the component BC-DB-MSS because we have to analyze this in more detail.

Regards

Clas

sukhdev_kaloor
Participant
0 Kudos

Thanks Clas,

Its SQL 2005 or 64bit.

Is the SQL Server Development Studio part of SAPs DVD?.

Thanks,

Sukhdev

clas_hortien
Active Contributor
0 Kudos

Hello,

yes, the SQL Server Dev. Studio is part of the DVDs. The DVDs aren't different from the DVD you can buy in a shop. They contain the same SQL Server bits. Only the SQL4SAP Script and the License is a different.

You can install the tools from the Tools DVD if necessary, but normally the SQL4SAP Script should install it. Is it X64 or IA64 ?

Regards

Clas

sukhdev_kaloor
Participant
0 Kudos

Clas,

Does the SQL Studio allow daily operatons like backup of systems.

Is there any configuration required ?.

Thanks

dev

clas_hortien
Active Contributor
0 Kudos

Hi,

yes, with the SQL Studio you can do everthing that you can do with the Enterprise Manager + Query Analyzer and even more. There is no configuration required, it works out-of-the-box like the Enterprise Manager.

Regards

Clas

sukhdev_kaloor
Participant
0 Kudos

Clas,

I am able to get the SQL Server Management Studio but not able to connect to the database.

Its asking few parameters like server type,server name etc .

How exactly to connect.?.

Regards,

dev

clas_hortien
Active Contributor
0 Kudos

Hi,

Server type is normally "Database Engine". You can use the Dev. Studio to connect to various other types (e.g. Reporting Services, Analysis Service etc.)

The Servername is the instance name you want to connect to. For a default instance it is your machinename, for a named instance it is Machinename\Instancename.

Authentication can be Windows Authentication if you are logged on as a local Admin. For an ABAP System only Windows Authentication is possible, for a JAVA System the SQL authentication is necessary, so that you can logon as 'sa' with the password you provided in the setup.

Regards

Clas

Former Member
0 Kudos

Install Enterprise SQL server from separate DVD's, and apply collation setting accordingly.