| Author |
Topic |
|
SQLCode
Posting Yak Master
143 Posts |
 Posted - 2004-05-13 : 12:21:47
|
| Hi,We have SQL2K and NT. Recently the NT logins have changed. The jobs are set up with old logins and it is not recognizing the old logins. When I try to add new login, those new logins are not even showing up from SQLServer. Any ideas as to why SQL is not seeing new logins?Please help.TIA |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-13 : 13:19:48
|
| Are the new logins on the domain that SQL Server is on? If they are, you can just manually type them in. Sometimes, the box just can't get the list of logins. But it will recognize them if you specify DomainName\LoginName and if they are valid.Tara |
 |
|
|
SQLCode
Posting Yak Master
143 Posts |
Posted - 2004-05-13 : 13:26:49
|
| Thanks Tara, I did that and it threw out error saying login not found. And yes they are logins on the domain that SQL server is on. They just changed with additional prefix. However, I see some of the new ids in the logins. The ones that are associated with jobs, when I try those new logins after dropping the old, it says login not found.The NT admin says this is SQL problem(?).Thanks for all the help. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-13 : 13:28:17
|
| Did you add the login to SQL Server though? NT accounts don't automatically have access to SQL Server unless the BUILTIN\Administrators group exists in SQL Server AND the account is a local admin. So if those accounts aren't like that, then you need to add them to SQL Server using sp_grantlogin.Tara |
|
|
|
SQLCode
Posting Yak Master
143 Posts |
Posted - 2004-05-13 : 14:08:00
|
| I had just done it with SQL EM and it gave errorI did sp_grantlogin too and the error is:Windows NT user or group 'domain\user' not found. Check the name again. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-13 : 14:09:42
|
| SQL Server is unable to see the login. The problem is outside of SQL Server though. You need to figure out why the server can't resolve the logins. I would try adding the accounts to local groups to see if that works.Tara |
|
|
|
SQLCode
Posting Yak Master
143 Posts |
Posted - 2004-05-13 : 14:18:38
|
| When I do new login, it shows the id and when I select it and try to add it is when it gives this 15401 error.that is the reason our NT Admin claims it is SQL error.Anyways, I will try your suggestion and see how it goes.Thanks. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-13 : 14:25:33
|
| There are various reasons why you get 15401:http://support.microsoft.com/Type in sql 15401 in the search box. Ignore the first article.Tara |
|
|
|
SQLCode
Posting Yak Master
143 Posts |
Posted - 2004-05-14 : 14:02:02
|
| Thanks Tara for the right direction. It was duplicate SSID.It is all resolved. |
|
|
|
|
DTS failing, NT login changed