Unarchiving of Repository gives an error

[Former Member]

Hi SDNers,

I am shifting my repository from Oracle dB to SQL dB on a different server, for this I have archived the repository.

While trying to unarchive it in the SQL dB server, it throws an error:

"Description: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

Source/File/Line: Microsoft OLE DB Provider for SQL Server/.\OLEDB_DBConnection.cpp/276

"

Please help me about this.

Regards,

Gautam Purohit

[former_member206107 · Accepted solution]

Hi Gautham,

Can you able to create a repository in the MDM over this SQL Sever?

Make sure the SQL server is running and you are giving the correct name of the sql server with correct username and password while creating/unarchiving the repository.

Please try and let me know.

Best regards,

Arun prabhu D

[Former Member]

Thanks for the help.

Regards,

Gautam Purohit.

[Former Member]

Hi Gautham,

First please check whether same user is available in database which you are trying to connect to DB server.

most of the cases if user is not available in database this kind of problems will occur like "Access denied".

Second thing is you are using default user "sa" then you need to use default path "Master" database. if you are using your own database please select that DB path while connecting DB server

Regards,

RDN.

Edited by: RDNPrasad on Dec 19, 2007 7:21 AM