Able to import but not link tables

[Guest]

Hi there,

I need to create a linked db to edit some backend data held on a sql server.
I can import data via 'Get external data' but am unable to actually do a
link. I get two main errors:

Connection failed:
SQLState:'01000'
SQL Server Error: 2
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).
Connection failed:
SQLState:'08001'
SQL Server Error:17
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist
or access denied.

Then a dialogue box appears Asking me to login to the server for entry to
each table.

Now whereas our ICT dept are trying to track this down via permissions, does
anyone know if this is a simple fix issue or do we need to hire a hacker to
get into the backend in this manner?

 

[Guest]

Sounds to me that you only have read-only permissions set in SQL Server for
the SQL Server username you are connecting with. Check with your DBA or SQL
Admin (or whomever is the keeper of the SA password) to confirm that this is
indeed the problem and to have them change your userid's permissions if
necessary. The permissions may be set at the SQL Server, database or even
table level - check them all.
Maybe try setting the userid to connect using Windows Authentification
instead.


jmonty

 

[Guest]

--
Thanx in advance!

jmonty