"Yih-Yoon Lee" <yihyoon@gmail.com> wrote in message
news:u%23VKh%23KAFHA.2600@TK2MSFTNGP09.phx.gbl...
> When you logon as MST windows user, and launch Enterprise Manager, if you
> don't see the server, you can just register the server. Right click on the
> sql server group and choose register server to do that. Assuming that MST
> has the permission setup in SQL Server, it should work fine.
>
> Yih-Yoon Lee
> My blog http://www.mssql-tools.com/blog
> E-mail: yihyoon.online@gmail.com
> /* remove .online to send me e-mail */
>
> Mike Thomas wrote:
>> Not sure whether this forum is for people new to SQL Server, or for
>> adding new users to SQL Server - either would be relevant.
>>
>> I set up a new computer, installed XP Office SP2. I was logged on as the
>> Windows XP user "Administrator". I then installed SQL Server 2000
>> Developers Edition, and got the standard databases master, northwind.
>> etc. I then attached my own database in Query Analyzer, opened Enterprise
>> Manager, and all the databases were there in the 'local(Windows NT)' node
>> right below the "SQL Server Group" node. So far so good.
>>
>> Then, I added a new user "MST" to Windows XP, and that is how I generally
>> log on. Query Anylayzer works fine when I log on to SQL Server as
>> Administrator or sa. When I open Enterprise Manager, though, the node
>> below "SQL Server Group" says "no items".
>>
>> It has always been a mystery to me how Enterprise Manager knows who is
>> logging on. I suppose it must be using the Windows XP logon.
>>
>> How can I add "MST" as a user so that I can use Enterprise Manager when
>> logged on to XP as "MST"?
>>
>> Many thanks
>> Mike Thomas