Databases (SQL 2000)

06/17/2018 05:58 TheRealCataracts#1
Need databases backups that are compatible with SQL 2000.
The only ones I've been able to find are from later SQL versions and don't seem to work with SQL 2000, (get errors when trying to restore).

If anyone could help me out I'd appreciate it. I already searched google and all over the forum, haven't been able to find backups compatible with SQL 2000.
06/17/2018 12:23 [DEV]Dekaron#2
what error give more details
06/17/2018 20:11 TheRealCataracts#3
I've found the databases I was looking for.

However, I've now come across a new error. When I'm going to set up ODBC, I notice that my Service Manager isn't connected. The connection appears fine when I run enterprise manager, but for some reason it isn't working inside the service manager and I don't even have an option to select any server.

Is there a way I can find the server name without using service manager on SQL 2000?
06/17/2018 23:20 [DEV]Dekaron#4
if you use ODBC
there is something like server put (local) not IP and not server name then your password for mssql