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 |
|
badboy
Starting Member
1 Post |
 Posted - 2010-02-07 : 14:17:07
|
| I'm studying to pass the MCTS, and I'm a beginner, so this may be a moronically simple question, but I can't seem to get the correct domain name for a CREATE LOGIN command, i.e.CREATE LOGIN [domain/user]FROM WINDOWSI created the user name in the Local User and Groups File in Computer Management. Then I used the server name which is clearly listed in the Object Explorer. When I tried to complete the CREATE LOGIN command, I got and error message that the server name was not the correct domain name. I double checked with the @@SERVERNAME function, and got the same server name.I originally thought that the sever name and domain name were one in the same, but assume now that's not the case. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-02-08 : 12:29:43
|
| right-click My Computer, click Properties, Computer Name. Does it show a domain name? If not, you can click the network id button to join domain.Also, it's Domain\user not Domain/user |
 |
|
|
|
|
|
Domain name delema