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 |
|
rb1373
Yak Posting Veteran
93 Posts |
 Posted - 2005-03-31 : 02:13:46
|
| I created a windows authenticated login for each of our developers. Each login I created has a default DB and at least one DB assigned w/ dbo privileges. The users in the assigned DB are listed as 'domain\login'. After creating these logins, I removed the developers from the local admin group and removed the BUILTIN\Admin login. Any ideas why one developer can't logon via EM or QA while another can? The error reads something like server doesn't exist or login failed. He's restarted his machine to no avail.Thanks,Ray |
|
|
Pace
Constraint Violating Yak Guru
264 Posts |
Posted - 2005-03-31 : 02:48:19
|
Are both developers in the same group ? can you not create a new domain group for these developers? if that was the case you could then add that to your sql logins and they should all have perfect access.when life hands you lemons, ask for tequila and salt  |
 |
|
|
rb1373
Yak Posting Veteran
93 Posts |
Posted - 2005-03-31 : 09:39:57
|
| the developers have been added individually to the sql server so they can be assigned permissions individually on their development databases. |
|
|
|
rb1373
Yak Posting Veteran
93 Posts |
Posted - 2005-03-31 : 13:52:27
|
| this is fixed. we removed an alias to the sql server from the client network utility on the developers machine. |
|
|
|
|
|
|
windows authentication failure