| Author |
Topic |
|
ZenProfit
Starting Member
11 Posts |
 Posted - 2008-01-06 : 17:49:31
|
| 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?The IT department says Novell should have not effect a Windows login, but it apparently is. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-06 : 17:51:33
|
| You should be able to connect to sql server with sql authentication. |
 |
|
|
ZenProfit
Starting Member
11 Posts |
Posted - 2008-01-06 : 18:53:18
|
| I understand how SQL authentication works.If at the Novell-enabled workstation the UserID/PW is Joe1 / PW1, is this exactly what needs to be added in the Security Area of the SQL database in SQL Studio?There are only 11 Users with whom I have this Novell issue. I believe it is because the SQL database lives in domain "SQL-1", but these 11 are not members of that domain, but only of a Workgroup which is VPN'd into "SQL-1".Asked another way, how is SQL authentication created when the users are logging into Windows via Novell from a work-grouped network outside the domain of the SQL database? Do I need to "authenticate" them by naming each user like this: "[Workgroup]\UserID in the SQL Security area? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-06 : 19:32:45
|
| You can create standard sql login for them with any id/pwd you like to use, sql authentication is nothing do with how to logon windows. |
|
|
|
ZenProfit
Starting Member
11 Posts |
Posted - 2008-01-06 : 20:05:13
|
| OK. I am stumped. What is "standard SQL login" and could you please provide an example?Thank you. |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2008-01-06 : 20:15:07
|
| you can't use windows auth from users in a workgroup to a sql server in a domain. Novell client has nothing to do with this.the only way you can authenticate in your current scenario is to use sql auth (also called a standard sql account), which is what rmiao has suggested.-ec |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-06 : 21:13:13
|
| As said, just create sql login with whatever id/pwd you like in ssms -> security -> logins. Didn't show you details since you said 'I understand how SQL authentication works'. |
|
|
|
montu
Yak Posting Veteran
60 Posts |
Posted - 2008-01-06 : 23:04:01
|
| Hi Alli may sound stupid but my question isIs SQL Login works if user is on different domain or user and SQL Server needs to be on same domain. Thanks in Advance |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-06 : 23:20:29
|
| If use windows authentication, user and sql server need be in same domain or in domains trusted. If use sql authentication, doesn't matter as long as have physical connection. |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2008-01-06 : 23:46:55
|
| for more information you need to look in books online. sql auth/windows auth is covered in great detail there.-ec |
|
|
|
ZenProfit
Starting Member
11 Posts |
Posted - 2008-01-07 : 20:03:37
|
| In the end, the problem was neither Novell nor SQL.The IT dept. had failed to activate LMH Host Lookup.Thanks all for your help. This group is #1. |
|
|
|
|
Novell Login Prevents SQL Access??