Login failed for user sa

[msilka]

About a week ago our Visual Basic program wouldn't log into the SQL Server 2000 Database SP3. The default user was sa with a blank password. I changed the sa's password and created a new user and the Visual Basic runs fine.
I checked ports 1433 and 1434 on our router and they are blocked. We have 3 machines with 3 SQL servers. Only 2 were affected. Both had the sa with blank password.

When I go into Security through the Enterprise Manager I receive an error "xpstar.dll" not found when trying to edit or add a new user. When I click OK on the error message I then am able to add/edit the user.

Does anyone know the resolution to this issue?

I back up my databases with Veritas Backup Exec 9.0 and now I cannot select the SQL Server databases in order to back them up.

 

[JayKusch]

Ouch ... since xpstar host a number of extended stored procedures used by SQL Server, you may have other issues pop up soon.

You "may" be advised to reload the important dlls for SQL Server again. Maybe not a full re-install but a partial on that covers the system dlls SQL Server uses.

Best bet may be to reinstall SQL Server once you have detached and safely housed your current DBs.

Thanks

J. Kusch

 

[msilka]

I uploaded the SP3a service pack and installed it.
Now the server is running fine.

 

[JayKusch]

That also will correct the issue. Somewhat like a reinstall. GREAT!

Thanks

J. Kusch