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(198.4, 12%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEB%3C/text%3E%3C/svg%3E)
We are trying to connect to the iseries database in excel by using the import from other sources and then select odbc. We are trying to implement single sign on - and also choose in the configuration of the odbc connection the kerberos connect option. But still it is asking for userid and password. Does anyone have an idea if it is possible to connect and not have to put in user and password? These are the settings in de odbc driver:
iSeries /AS400 isn't a Microsoft product, it's from IBM, so better ask in a more related forum.
![](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)
are you sure your spn i correct setup for the database service ?
run: spn -l <computer account>
Hello,
I know- but i asked ibm and they say is a microsoft issue- so therefore i hope that someone has experience with connecting excel to an iseries database via excel. I know how that works and thats working fine with entering userid and password- but we now want to use the kerberos connection option and this should result in not having to enter a user and password for the connection.
Screenshot is from IBM data provider, so nothing related to Excel.
Hello,
that is correct, but what i do in excel is this:
I choose- gegevens- then gegevens ophalen and there i select from other sources the ODBC . and in gegevensbron i choose the option nlavcb2u- thats the system where the database is- and in this odbc connection i selected as option use kerberos. What happens next is this:
There i have to enter user and password, buth with the kerberos option on, this should not happen- itshould log in without asking for userid and password.
So what we think that using kerberos is somehow blocked by excel- or is that not possible?
The dsn is correct- because when i enter my username and password it connects to the system.
that is typical behaviour when the source is not configured for kerberos, so does the kerberos connection work from other applications?
Yes i can connect without userid and password on iseries self and also network connection without having to use userid and password. But now we were testing and something happened.
in stead of using database we chose Windows an dwithout changing something in windows i chose connect- then it did work!! Should that be the option then?
Yes, the windows option here, actually uses your windows credentials to connect to the database, the database option will try to use a local database user and password and that is like SQL Authentication..
It is correct that you need to select the windows authentification, because that is where you tell then client to use your logged in usertoken via Kerberos to authenticate to the database.
When you select the database authentification, then it tries to authenticate directly to the database without kerberos, that is why you get the login prompt when updating the data, it is like SQL Authentication.. so you are on the correct path :)