Tuesday, October 11, 2011

Installing Symantec Backup Exec 10d Windows Server 2003 & Symantec Error Technote 261927

Does your install fail?

First off launch the CD and run the Environment Check.  This will tell you if your going to have trouble.

Here's how to fix it.

Download Microsoft SQL Server 2000 SP4 here

Open command prompt and type osql -U sa, hit enter when prompted for password.

I was prompted with "[Shared Memory]SQL Server does not exist or access denied.

[Shared Memory]ConnectionOpen (Connect())."

That means I need to define an instance.  New command:  osql -U sa -S server\BKUPEXEC

Next message I got was "Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection."

That means i'm running in Windows Authentication only mode.  New command:  osql -E -S server\BKUPEXEC

I finally got logged in.  Now to change the password type the following:

1> sp_password @old = null, @new = 'complexpwd',  @loginame ='sa'
2> go

Obviously change complexpwd to a password you want.

MSDE needs to be run from a command line. Navigate to the folder where it was extracted

and run setup SAPWD="complexpassword" and hit enter. This should upgrade all your instances.


osql -E -S DC\BKUPEXEC -Q "USE master SELECT @@version" -p

Sources: Link

Never did get this working... anyone have any suggestions?