Endpoint Protection

hi, we have 10.1.5.5002 installed of symantec system center and an installed reporting server. I can't seem to login to the reporting server though. Its a MSDE database. Any instructions I've found involve using the sa password and that seems to be not blank but I don't know what that is. Is there any way to recover the situation ?

Elaine

Excerpted from: http://nsit.uchicago.edu/services/technicaltools/windows/mssql/

 

To change the password from the command line on MSSQL Server or MSDE:

1. Open a command shell by selecting "Start"-->"Run...", and typing "cmd.exe" in the "Run" dialog box.
2. Change to the directory in which the MSSQL or MSDE utilities are stored (this is ususally C:\MSDE\binn, C:\MSSQL7\binn, etc., but YMMV).
3. Issue the following command where <newpassword> is the password you have chosen:
   osql -U sa -P "" -Q "sp_password NULL,<newpassword>,sa"

I've had several instances where I needed to reset the sa password and this has saved the day every time.

I get a shared memory Server error - does not exist or access denied.

I've looked at some web info on it - its installed, its running, its not clustered, tcp/ip, default port 1433, its on the host I'm at the command prompt on, not sure what I'm missing ? Not sure if I need to specify instance or how to with that command ?

"For a default instance, use the following pipe in the Server Network Utility:

For a named instance, use:

 

Elaine

Ok, well make sure you are admin on the box.

Open the SQL command promt then do the following (excerpted from: (http://thebackroomtech.com/2008/03/26/how-to-change-the-sql-sa-password-from-a-command-prompt/)

 

Start a command prompt by typing Start - Run - cmd

Enter the following commands, pressing Enter after each line

OSQL -S yourservername -E
    1> EXEC sp_password NULL, ‘yourpassword’, ’sa’
    2> GO

 

Where yourservername is the name of your server and yourpassword is the new sa account password.  Type exit twice to return to the server desktop.

 

 

I just tested this on my SQL server and it worked.  However, I do not have a MSDE to test on so I'm not 100% that it will work for you.

hi

I tried that but still connection denied.

Elaine