cancel
Showing results for 
Search instead for 
Did you mean: 

sql quary analyser not open

Former Member
0 Kudos

I have install SAP 4.7 Enterprise on windows 2000 advance server with SQL 2000.Now I want to resize sap data file via quary analyser. It ask sa password . but I don't know . How I open my query analyser.

Thanks & regards

jagdish kumar

jagdish3707@yahoo.com

Accepted Solutions (0)

Answers (2)

Answers (2)

clas_hortien
Active Contributor
0 Kudos

Hello,

when you have installed the SQL Server with the sql4sap script the sa password is a generated character string.

You should be able to connect via windows authentication. Log on the machine as a local or domain administrator and choose windows authentication at the query analyzer login. You do not need to put in a password then.

Regards

Clas

Former Member
0 Kudos

when I fresh install SAP with SQL . By defauly 3 data file of 4 GB and 1Log file is created . I want to increase the data base file size. How I can increase my data base file.

Regards

jagdish

Former Member
0 Kudos

Hi,

SQL Server databse file setting is autoextend by default,

use sql server enterprise manager and reset sa password, in SAP it's use windows authantication

expand your local sql server -> security

regards,

kaushal

markus_doehr2
Active Contributor
0 Kudos

Does just pressing enter (without entering a password) work?

Markus