August 4, 2014 at 3:52 pm
First time I've tried doing this - I have SQL Server 2012 installed on my local machine with an instance running (which was set up under an administrator account, not mine, which has no admin rights), and I'm trying to create a linked table from Access (also on the local machine) to a table on the server.
I tried creating a DSN using Windows Authentication, using the server name which is the same as my computer name, and got the error "Error 18452, Login failed. The login is from an untrusted domain and cannot be used with Windows authentication".
I then created a SQL authentication user ID and password, and tried the same thing using that instead, and got "Login failed for user <myusername>"
Is there some particular setting on the local instance I need to change to allow this kind of connection, or do I need to use something other than the server name to connect, such as an IP address? Remember that I have no admin access on this machine so any solution would have to avoid requiring that.
August 4, 2014 at 11:04 pm
Is your your Windows logon account a domain account or local Windows account? You'll need to add it (or a group you are a member of) to SQL Server (no matter if the account is a local admin as they do not have SQL access by default).
In the DSN setup, what driver are you using to connect to SQL server? If you use an IP address, you'll need to enable TCP/IP as a connection protocol in SQL Server Configuration Manager.
What is the full error message in the SQL error log for the failed SQL login? That should be working in the ODBC, as long as you have selected SQL authentication.
August 5, 2014 at 9:44 am
I think I figured it out, windows authentication isn't going to work I think due to the way SQL Server was installed under the admin user ID (getting IT to do anything out of the ordinary here is like pulling teeth), but SQL authentication worked after I changed the database to mixed mode authentication - it had defaulted to windows authentication only when it was installed.
August 6, 2014 at 2:36 am
This was removed by the editor as SPAM
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply