I have a customer who has a SQL Server 2000 DB and we are needing to
get to this DB through ODBC. I had setup a DSN last week that
connected fine to this DB, and was preparing to build a script to
manage transfers of data to and from one table to another.
The then began to have troubles with their DB Backup (this is not at
all related to the issue at hand). The problem they claim was that the
"sa" was needing to have certain roles applied to it that were not part
of it's default properties. My understanding is that the "sa" is the
King of the Kingdom sotospeak, and has all rights, permissions, role
capabilities, etc...
To make a long story short she tried to apply the write and read roles
to the "sa" and it would not allow for this to be applied. She then
applied a password to the "sa" account (previous it did not have one
and was set to blank) and upon doing this she then removed the password
and set it back to blank.
Since she made these changes we have not been able to connect to her DB
via our DSN. When we get to the point of telling the DSN to use SQL
Authentication, and apply the sa account for use with a blank password
- it comes back with an error similar to "database is not available or
password is incorrect".
Has anyone had this problem before, and if so is there any simple
resolve? Something other than the customer having to restore a previous
backup of the DB?
Much thanks in advance...