This is noting you have a server principal, not a user. did you create a user for this login in the database?

This must be a client side item that is locking down things. You should see something like this:

Can you post your browser/version here? Do you have security settings that disable all add-ins?

You can use bbcode here, which is linked in the yellow as a reference.

Points are redeemable for smiles and hugs. Occasionally someone will get 100,000 and maybe get a drink as a reward. I think 1mm is dinner.

I don't see special characters or a time. Your description doesn't quite make sense.

It would be better to see some DDL for the table and some DML to...

Eirikur's query lets you see characters that are allowed in each. In general, if you stick with Western languages and data, varchar is fine.

The important thing is that you...

Actually here it says an admin must do this: https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/listeners-client-connectivity-application-failover?view=sql-server-2017#SPNs

There aren't global roles across databases that are used for access. All roles would be set on a database level.

What I would suggest is that you set a...

I asked a few people and they say no.

This seems to indicate you do this manually, but doesn't explicitly state that.

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/listeners-client-connectivity-application-failover?view=sql-server-2017#SPNs

You would need to perform query tuning to decide if there are structural problems with how your query is written or if the query is optimal and the workload of...

It's hard to know what else you can do without seeing some code and data. I would agree a cursor is not needed. You ought to be able to update...

This might help: https://dba.stackexchange.com/questions/171204/sql-server-informix-db-linked-server