Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
 Posted - 2008-03-17 : 07:32:08
|
| I was wondering if anyone could help me with this. I am currently working on a project for reporting on a new acquisition the company have made. Unfortunately, the people I have to give access to the SQL Server are using Netware for authentication.Is there any way to allow these people to log into SQL Server without having to create a SQL authenticated user for each of them?Thanks |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-17 : 09:44:56
|
| RickD,what is "Netware for authentication"? |
 |
|
|
Van
Constraint Violating Yak Guru
462 Posts |
Posted - 2008-03-17 : 10:42:40
|
| I'm pretty sure it's Novell rather than Microsoft authetication. I've worked at a place before that had a Novell network. It sucked. In order to use the SQL servers which were on Windows servers, I think they had to set up a Windows network as well just for SQL. Netware can somehow interface with the Windows network when you log in to Novell so that you are autheticated to the Windows network as well. Not sure how all that works though. |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-03-17 : 11:13:46
|
quote:
Originally posted by Van
I'm pretty sure it's Novell rather than Microsoft authetication. I've worked at a place before that had a Novell network. It sucked. In order to use the SQL servers which were on Windows servers, I think they had to set up a Windows network as well just for SQL. Netware can somehow interface with the Windows network when you log in to Novell so that you are autheticated to the Windows network as well. Not sure how all that works though.
Unfortunately it seems that it doesn't work very well. It is working for some users but not others, which is why I was wondering if anyone had another way to do this. Guess this means setting up loads of SQL users.  |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-17 : 23:07:54
|
| Did you sync Netware nds with windows ads? And need install netware client on sql server. |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-03-18 : 04:29:54
|
quote:
Originally posted by rmiao
Did you sync Netware nds with windows ads? And need install netware client on sql server.
Can you possibly explain that further?Thanks |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-21 : 20:01:01
|
| Netware comes toll to sync nds with windows domain, user you created in nds will be replicated to domain. Then user can login nds on windows machine and connect to sql with windows authentication. |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-03-25 : 03:36:42
|
| Ok, will give it a try, thanks. |
|
|
|
|
|
|
Netware Logins and how to integrate into SQL 2005?