It worked, upgraded to MDAC 2.8 and ran the setupsql.exe in lieu of the setup.bat file.

Thanks anyways

So revoking access to the public role would not break anything.

Thanks Luke.

There is an option Use Encryption for Data on the connection properties. Do you / anyone know what that is for? Right click on SQL Server connection and click...

But isn't that the whole point of creating a client alias, that I provide the IP and port and I can use the name. While using EM or QA it...

However, when I register the server with the IP, port (same as in client config), it works

Yes sql server authentication is failing...

When you open up a connection and click on the advanced button, you have the Use Encryption option in there.

TIA

This is a db to which transaction logs from production are shipped.

I need to move it Test and so the backup. I just got the backups from Production.

Is this behaviour...

Ok, i tried the tool and it gave me a conformance level 1. The current odbc version is 3.52 and the driver version is 3.51.

I tried looking for some...

Thanks for your response, but am not sure if case sensitivity is the problem. I did a test with a foo table and that didn't work either. However, this time...

your right...

this is the script that worked for me...

CREATE TABLE #tblTableData

 (

  vchTableName VARCHAR(100) NOT NULL,

  intRows INT NOT NULL,

  vchReservedSpace VARCHAR(100) NOT NULL,

  vchData VARCHAR(100) NOT NULL,

  vchIndexSize VARCHAR(100) NOT NULL,

  vchUnusedSpace VARCHAR(100) NOT NULL

&nbsp

This does not explicitly identify the database which has a problem.

Is there a way to find out the object / database based on Page (1:3507395)??? or would I need...

I found that there are 4 tables missing in the master database

spt_datatype_info

spt_datatype_info_ext

spt_provider_types

spt_server_info

I tried to re-install sp4 but it gave me an error and stopped. The problem still exists...

Any ideas other than...

am trying to access using the client on the server...

I did a net stop / start on MS DTC and that worked for me.