View Complete Post
I am trying to create a linked server from sql server 2008 to a secure access 2003 database(database which has a password), whatever options i am trying the result is i am getting the error 7399("Cannot start your application.
The workgroup information file is missing or opened exclusively by another user.".)
or error 7303.
I am selecting 'Microsoft.Jet.Oledb.4.0' as the provider. I think the problem is somewhere in
the workgroup files
Please help me in creating this linked server.
SQL Server 2005 SP3 32bit serverConnecting to an Oracle 10g serverLoaded OracleClient 10g I'm able to ping the Oracle Server, and ODBC connect and able to run an open query with a single remote user id.Issue: When I use the security context "Be made using this security context" it connects.When I choose the "Not Be Made" WITH THE SAME USER ID & PASSWORD, I get the mapping error.
today in the morning i installed 5-6 security updates including (KB980436) on our production server. During the day we got errors when our application calls a secured web service :
An error occurred while making the HTTP request to https://[MyService]. This could be due to the fact that the server certificate is not configured properly with HTTP.SYS in the HTTPS case. This could also be caused by a mismatch of the security binding
between the client and the server.
I had nothing to do because we haven't made any change at our application. Then i remembered the security updates and walked through the update informations. I saw that KB is about :
I removed this update because its about secure channel, then everything worked fine.
So what should we do ? Who should be informed ?
I want to create linked server in SQL 2005 with Ms Access 2003 Database. I have used following commands to create linked server.EXEC sp_addlinkedserver @server = N'TestLinkServer', @provider = N'Microsoft.Jet.OLEDB.4.0', @srvproduct = N'Access', @datasrc = N'D:\Test.mdb', @provstr = Null
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'TestLinkServer', @useself=N'False', @locallogin=NULL, @rmtuser=NULL, @rmtpassword=NULLWith above command linked server successfully create and can run SQL query against linked server. But if i set Database password to MS Access 2003 Database, then it gives following error message.The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "TestLinkServer" reported an error. Authentication failed.Any ideas?Thanks,Rajesh
We have a website that was using Sql server 2005. There was a option in Website where when a user clicks a button, Some tables data will be exported to an access database. To achieve this, we have setup a linked server to Access database.
We have moved from sql server 2005 to 2008 (64bit). We did not want to use that option of having a linked server now. I am looking for different ways to achieve the task. We also donot want to use OPENROWSET
and OPENDATASOURCE .
Can someone give some insight about this?
I am trying to link SQL Server 2008 - 64 to an MS Access database on a network share. I can get the link to work from the SQL management studio but when I try to do a ODBC query (from another machine) of a view table pointing to the access db through
a linked server using the "Microsoft.ACE.OLEDB.12.0"driver. The error from the odbc trace is:
" DIAG  [Microsoft][SQL Server Native Client 10.0][SQL Server]OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "STPRD" returned message "Not a valid account name or password.". (7412) "
Yes the login to the password are good. I have tried various setting using sp_addlinkedsrvlogin function but nothing will handle the extra hop.
What if you need to convert an existing Microsoft Access 97 database application into a true client-server application that is based on a SQL Server back end? If you know a little about Visual Basic and SQL Server, it's easy to make your app take advantage of the power and scalability provided by SQL Server 7.0. Using some concrete code examples, this article takes you step by step through converting the native Jet queries in your Access application into stored procedures and pass-through queries that SQL Server can use. You'll also learn how to pass on parameters when your client-server app calls these SQL Server stored procedures and queries.
MSDN Magazine June 2000
Sharepoint server 2007 and remote sql 2000 SP4 database, after ShraPoint server crash only content databases are available and intact. Trying to restore from backup fail, stsadm -o restore says that not valid backup is available on path. How to get access
to available content database using a new installation with same server name, ip address and partitions configuration. How to recover site with content databases information.
Regards, thanks for help.
I'm tried SELECT * INTO XXX FROM OPENROWSET alongwith Microsoft.ACE.OLEDB.12.0.
Apparently the query requires the sql account to have SYSADMIN privileges.
Considering that SYSADMIN should not be provided to a database account on a Production Server, I tried using the Linked Server method.
Following is my code.
Exec sp_addlinkedserver 'AB2','Ace 12.0','Microsoft.ACE.OLEDB.12.0','\\126.96.36.199\sagarr\Test1\cpc\c2\AB2.xlsx',NULL,'Excel 12.0;IMEX=1'Exec sp_addlinkedsrvlogin 'AB2','false',NULL,NULL,NULLgoSELECT * INTO [CPCAB2.xlsx] FROM OPENQUERY([AB2] ,'SELECT * FROM [Sheet1$]')Exec sp_dropserver 'AB2','droplogins'
Now i get the following error
Error.15247-User does not have permission to perform this action
My Excel file, Database and Windows Application run on separate machines.
i have provided the following privileges
GRANT ALTER ANY LOGIN TO sqlaccountGRANT ALTER ANY LINKED SERVER TO sqlaccountEXEC sp_configure 'show advanced options', 1RECONFIGUREEXEC sp_configure 'ad hoc distributed queries', 1RECONFIGUREThe DisAllowAdHocProcess in