server via secure connection

I am trying to setup a linked server to a MySQL database over at my hosting company.
I would like the communication between the SQL server and the MySQL database to be via a secure connection. anyone know how to do this?
my DB is SQL 2000Do you just want to manage the remote MySQL from your local console, or you want your SQL Server to perform actions over the remote MySQL as part of its work?|||basically, i would like to do selects and updates to the MySQL server with data from the SQL server.|||First you need a crtificate server (could be internal) and have both machines obtain certificates from it. I know there is a Certificate Server included in the MSDN subscription but I don't know how exactly to set it up. Shouldn't be a big deal.

Then in the Client Network Utility on the SQL Server machine check the Force Protocol Encryption box.|||thanks, i will try that

server to secure Access Database

hi all,
This is my second try to get the answer..
I have created a linked server to a secure database with following query
EXEC sp_addlinkedserver
@.server = 'MYSERVER2',
@.provider = 'Microsoft.Jet.OLEDB.4.0',
@.srvproduct = 'ACCESS',
@.datasrc = 'C:\COSTING2.mdb'
GO
sp_addlinkedsrvlogin myserver2, false,sa, Admin, 'ansari'
when I run the query
SELECT * FROM Myserver2...Material
I get the following error
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. Authentication
failed.
[OLE/DB provider returned message: Not a valid account name or password.
]
any idea?
AnsariRemove the so-called "security" from the Access database. Anyone
capable of doing a google search can easily bypass Jet security,
accessing the mdb as an administrator with full priviledges. It's not
worth the trouble, and it can't be made to work reliably with linked
servers.
--Mary
On Thu, 24 Jun 2004 10:59:36 +0600, "M.M Ansari"
<mudasar_ansari@.hotmail.com> wrote:

>hi all,
>This is my second try to get the answer..
>I have created a linked server to a secure database with following query
>EXEC sp_addlinkedserver
> @.server = 'MYSERVER2',
> @.provider = 'Microsoft.Jet.OLEDB.4.0',
> @.srvproduct = 'ACCESS',
> @.datasrc = 'C:\COSTING2.mdb'
>GO
>sp_addlinkedsrvlogin myserver2, false,sa, Admin, 'ansari'
>when I run the query
> SELECT * FROM Myserver2...Material
>I get the following error
>OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. Authentication
>failed.
>[OLE/DB provider returned message: Not a valid account name or password
.]
>
>any idea?
>Ansari
>

server to secure Access Database

hi all,
This is my second try to get the answer..
I have created a linked server to a secure database with following query
EXEC sp_addlinkedserver
@.server = 'MYSERVER2',
@.provider = 'Microsoft.Jet.OLEDB.4.0',
@.srvproduct = 'ACCESS',
@.datasrc = 'C:\COSTING2.mdb'
GO
sp_addlinkedsrvlogin myserver2, false,sa, Admin, 'ansari'
when I run the query
SELECT * FROM Myserver2...Material
I get the following error
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. Authentication
failed.
[OLE/DB provider returned message: Not a valid account name or password.]
any idea?
Ansari
Remove the so-called "security" from the Access database. Anyone
capable of doing a google search can easily bypass Jet security,
accessing the mdb as an administrator with full priviledges. It's not
worth the trouble, and it can't be made to work reliably with linked
servers.
--Mary
On Thu, 24 Jun 2004 10:59:36 +0600, "M.M Ansari"
<mudasar_ansari@.hotmail.com> wrote:

>hi all,
>This is my second try to get the answer..
>I have created a linked server to a secure database with following query
>EXEC sp_addlinkedserver
> @.server = 'MYSERVER2',
> @.provider = 'Microsoft.Jet.OLEDB.4.0',
> @.srvproduct = 'ACCESS',
> @.datasrc = 'C:\COSTING2.mdb'
>GO
>sp_addlinkedsrvlogin myserver2, false,sa, Admin, 'ansari'
>when I run the query
> SELECT * FROM Myserver2...Material
>I get the following error
>OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. Authentication
>failed.
>[OLE/DB provider returned message: Not a valid account name or password.]
>
>any idea?
>Ansari
>

server to secure Access Database

hi all,
This is my second try to get the answer..
I have created a linked server to a secure database with following query
EXEC sp_addlinkedserver
@.server = 'MYSERVER2',
@.provider = 'Microsoft.Jet.OLEDB.4.0',
@.srvproduct = 'ACCESS',
@.datasrc = 'C:\COSTING2.mdb'
GO
sp_addlinkedsrvlogin myserver2, false,sa, Admin, 'ansari'
when I run the query
SELECT * FROM Myserver2...Material
I get the following error
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. Authentication
failed.
[OLE/DB provider returned message: Not a valid account name or password.]
any idea?
AnsariRemove the so-called "security" from the Access database. Anyone
capable of doing a google search can easily bypass Jet security,
accessing the mdb as an administrator with full priviledges. It's not
worth the trouble, and it can't be made to work reliably with linked
servers.
--Mary
On Thu, 24 Jun 2004 10:59:36 +0600, "M.M Ansari"
<mudasar_ansari@.hotmail.com> wrote:
>hi all,
>This is my second try to get the answer..
>I have created a linked server to a secure database with following query
>EXEC sp_addlinkedserver
> @.server = 'MYSERVER2',
> @.provider = 'Microsoft.Jet.OLEDB.4.0',
> @.srvproduct = 'ACCESS',
> @.datasrc = 'C:\COSTING2.mdb'
>GO
>sp_addlinkedsrvlogin myserver2, false,sa, Admin, 'ansari'
>when I run the query
> SELECT * FROM Myserver2...Material
>I get the following error
>OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. Authentication
>failed.
>[OLE/DB provider returned message: Not a valid account name or password.]
>
>any idea?
>Ansari
>

server to Secure Access Database

hi all,
This is my second try to get the answer..
I have created a linked server to a secure database with following query
EXEC sp_addlinkedserver
@.server = 'MYSERVER2',
@.provider = 'Microsoft.Jet.OLEDB.4.0',
@.srvproduct = 'ACCESS',
@.datasrc = 'C:\COSTING2.mdb'
GO
sp_addlinkedsrvlogin myserver2, false,sa, Admin, 'ansari'
when I run the query
SELECT * FROM Myserver2...Material
I get the following error
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. Authentication
failed.
[OLE/DB provider returned message: Not a valid account name or password.
]
any idea?I've got a very similar problem.
I can access my data perfectly without jet security but when I secure my dat
abase it won't accept any username or password.
I have ensured that I am using the correct workgroup security file by modify
ing the servers registry (HKLM/Software/Microsoft/Jet/4.0/Engines/SystemDB)
and verified that the server is in fact using that particular file by swappi
ng it with the default syst
em.mdb.
It accepts @.rmtuser='Admin', @.rmtpassword='' when I am using the default sys
tem.mdb and have reinstated admin's 'open database' permission.
TIA
****************************************
******************************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET
resources...