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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Server Registration Error

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 wrong

Check your accounts on the PDC
Go to Top of Page

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
Go to Top of Page

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.
Go to Top of Page
   

- Advertisement -