SQL DB Access Denied Using Novell User/PW

Question

SQL DB Access Denied Using Novell User/PW

zenprofit

SSC Enthusiast

Points: 128
More actions
January 5, 2008 at 9:50 am

#127379

I found this on the SQL Help page on the Data Link Connection Properties Tab (created by opening a 'test.udl' file on the workstation):
"The SQL Server system administrator must have associated your Microsoft Windows network ID with a SQL Server login ID."
While I can log into the SQL Server from a different workstation NOT using Novell, and using my Windows Authenticated UserID and PW, trying the same from a Novell networked workstation using the UserID and Password which is good ONLY at that one workstation, I cannot access the same SQL Server.
How does one "associate a Microsoft Windows network ID" when Novell is being used to access the Windows network?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

thecosmictrickster@gmail.com SSChampion Points: 10386 More actions · Answer 1

It sounds like the computer you are logging in to with Novell credentials is not connected to a Windows network (correct me if I'm wrong).

That being the case, you will have to use SQL Server authentication. Windows Authentication will only work with a domain/Active Directory account or a local account on the SQL Server (and to use that, you would have to be logging on to the server console rather than a workstation).

Scott Duncan

MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare

bnordberg SSCertifiable Points: 5379 More actions · Answer 2

The Novell client actualy "proxies" you through the windows authentication - so you many not actually be authenticated. If the A DLU Policy ( Dynamic Local User ) is setup, it simply dynamically creates a local account and logs you in using that, instead of going to the domain. I no longer have Novell installed, but I believe if you look at protocols installed (right click on the connection and do properties) for you network you will see one called Novell workstation manager (I think). If you remove this, then reboot, you will no longer be proxied. But you will also need to give windows users access to the computer. Good luck

zenprofit SSC Enthusiast Points: 128 More actions · Answer 3

Thank you all. I have forwarded this info to the IT dept.

floyd99 Mr or Mrs. 500 Points: 571 More actions · Answer 4

bnordberg is on the right track, but you can't just remove the workstation manager, as that will cause other zenworks delivered stuff to fail, such as workstation import and other policies apart from the DLU. so that's not the solution.

the PC is most certainly not a member of the domain at present, so windows authentication will never work. have a chat to your IT guys. if you can join the PC into the domain, the novell client can be made to log into a windows domain ASWELL as logging into the eDirectory tree within the one GINA (login screen). this is distinct from the DLU which just takes care of managing your local windows account. I have done this before but it was a while ago.. from memory it wasn't too difficult. once that happens, then your windows authentication to SQL should work. but, if this isn't possible in your environment, SQL authentication is the only way to go.

zenprofit SSC Enthusiast Points: 128 More actions · Answer 5

Thanks again. I have forwarded this too to the IT dept.