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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
Posted - 2004-09-07 : 08:47:56
|
| Joel writes "Hi there,sorry to trouble you but I have the following problem:I have 2 PC's both with windows XP. SQL server is installed on both and I have registered the database on one (L64) using Windows NT security. I now need to register the client also using Windows NT security and I get the error 'registration error for L64/guest'. The Windows XP guest account is disabled (if it has anything to do with this)What setting in sql server will allow me to do this?It is important that both are the same (either client & server both using windows NT security or passwords) for programming purposes.Many thanks,Joel" |
|
|
Pace
Constraint Violating Yak Guru
264 Posts |
Posted - 2004-09-07 : 10:00:24
|
| It might not neccessarily be SQL... it could be the accounts in Active Directory (ie; Guest)... though I could be wrongCheck your accounts on the PDC |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-09-07 : 13:29:18
|
| So does the user not have a valid Windows account? Do you want the user to have guest inside SQL Server?Tara |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-09-07 : 22:52:49
|
| allowing the windows guest account, defeats the purpose of security.It is important that both are the same (either client & server both using windows NT security or passwords) for programming purposes.you could add a windows account in sql that you can use for programming instead of relying which account is logon to the server. |
 |
|
|
|
|
|