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-07-02 : 09:13:37
|
| lionel writes "Hi,I am using SQL 2000 - currently studying for my MCAD exam and have recently become a little unstuck. What is the purpose or advantage of being able to set the server authentification method (either sql or windows) through editing the registration properties AND then also through the server properties (security tab) by selecting either:SQL and Windows or Windows Only. It seems that selections made in the server properties always overrides whatever has been selected in the registration properties. I have obviously missed the point of being able to set the authentifications modes in both places. Please help?Thank your for your time.Lionel" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-07-03 : 15:35:39
|
| Never taken an exam so excuse me if I don't know what you're talking about but:If you mean the registration properties in enterprise manager then this is just the method e-m uses to connect (it's a client app and needs to be told). If the server is windows only and you select sql then the connection will fail. It's just for the connection - it doesn't change the server.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
sql server registration