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 |
|
commoz
Starting Member
2 Posts |
 Posted - 2006-04-29 : 00:14:11
|
| I have two pc's configured in a workgroup network (no domain controller)pc1: windows xp pro (server for msde) msde instance running windows authentication listening on port 1433pc2: windows xp pro app program to connect to the pc1 msde instanceI'm trying to create a new sql server login using enterprise managerbut in using windows authentication the combobox for domain only list the pc1 as the available domain. How can I add a new sql server login from pc2?ex. pc2 has user2 as the local account name how can I add user2 from pc2 to have a windows authentication login in the msde instance? |
|
|
KenW
Constraint Violating Yak Guru
391 Posts |
Posted - 2006-05-01 : 12:39:41
|
| You have to add user2 as a User on PC1. (Do this from Control Panel|Administrative Tools|Users and Groups.)Make sure that you create user2 as PC2\User2 (Domain\UserName).Ken |
 |
|
|
|
|
|
How to create new sql server login in workgroup