Connect to SQL Server

Magic_Sponge

New Member
Joined
Oct 28, 2021
Messages
11
Office Version
  1. 365
Platform
  1. Windows
Hi - I am sure I must be missing something very simple here as I can't believe the trouble I'm having.

I have a SQL Server database with a load of tables and data, pretty standard stuff. I have had no problem connecting to this data and pulling it into the PowerPivot data model. Now I have the problem that apparently PowerPivot does not work on Macs, so I need to find an alternative solution.

I was going to use Power Query / Microsoft Query to bring the data in, but I just can't seem to connect to the SQL server. I have managed it once by Get Data --> Other Sources --> OLEDB and using the "Microsoft OLE DB Provider for SQL Server" driver, but then that creates a different problem. I want each user to be able to refresh the data by entering their username and password for the SQL Server, but if I use approach to bring the data in, it seems to 'remember' the username and password, even though I haven't asked it to.

I've tried Get Data --> From Database --> SQL server but I get an error message "We encountered an error while trying to connect. Details: Microsoft SQL: The target principal name is incorrect. Cannot generate SSPI context". But these are the exact same credentials I've used to create the connection elsewhere.

Long and short of it is, I need a way to simply bring data in from tables stored in a SQL Server Database that does not use PowerPivot, and allows me to set it so that a user needs to enter their SQL Server Credentials to refresh the data.

Can anyone put me out of my misery?
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Forum statistics

Threads
1,223,893
Messages
6,175,246
Members
452,623
Latest member
cliftonhandyman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top