We are using an old SQL2000 server running Windows Server 2003 as a database for our Blackberry server. We don't the sa password, or even if we have one.
We have to upgrade the blackberry server, and it requires us to take off MSDE 7 and put on MSDE 2000 on our blackberry.
We took off the MSDE7 and are trying to install the MSDE2000, but it won't install because it says it needs a strong SA password.
I checked the SQL2000 and it is using Windows authentication in the Enterprise Manager (Edit SQL Server Registration Properties), so I thought maybe we didn't have an SA password.
However, when typing osql -U sa and pressing the enter on the password, I get the message: Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.
So does this mean we don't have an SA password? If we have one, how can I find out what it is, or change it using windows authentication? If we don't have one, how can I change it?