This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 42%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJC%3C/text%3E%3C/svg%3E)
I am trying to do SQL report queries in excel. I can't connect our remote SQL database through my computer due to this error. I am on a local account on a laptop that I use to travel/work offline so I cannot utilize an active directory account for this pc. With the active directory restrictions on our server - is there a way for me to do this without a directory account?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Additional SQL Server features and topics not covered by specific categories
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi @John Calhoun
Did the answer help you? If the answer is useful, please click Accept Answer to let others with similar questions quickly find answers. If you have any questions, please feel free to let me know.
Best regards,
Aniya
One way out is persuade your DBA to enable SQL authentication and create an SQL login for you. Then you can login with username and password.
Then again, I don't see why you cannot use an AD account even if you are travelling. You can log in with cached credentials and have an VPN connection to the corporate network.