"David Gugick" <david.gugick-nospam@quest.com> wrote in message
news:u6P6UNmYFHA.2264@TK2MSFTNGP10.phx.gbl...
> Shimon Sim wrote:
>> I suddenly can't work with my Enterprise Manager.
>> It tells me that log in failed  - Can't access user's default
>> database.
>> What can I do about it?
>> I really need to fix it fast.
>> Thanks a lot
>> Shimon.
>
> Connect from Query Analyzer and change the default database for the user
> you are using to login from SQL EM.
>
> sp_defaultdb 'user', 'db'
>
>
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com

"David Gugick" <david.gugick-nospam@quest.com> wrote in message
news:u6P6UNmYFHA.2264@TK2MSFTNGP10.phx.gbl...
> Shimon Sim wrote:
>> I suddenly can't work with my Enterprise Manager.
>> It tells me that log in failed  - Can't access user's default
>> database.
>> What can I do about it?
>> I really need to fix it fast.
>> Thanks a lot
>> Shimon.
>
> Connect from Query Analyzer and change the default database for the user
> you are using to login from SQL EM.
>
> sp_defaultdb 'user', 'db'
>
>
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com

"Michael Cheng [MSFT]" <v-min***@online.microsoft.com> wrote in message
news:NIh58$oYFHA.2476@TK2MSFTNGXA01.phx.gbl...
> Hi Shimon,
>
> Thanks for your posting!
>
> From your descriptions, I understood you are not able to connect SQL
> Server
> via SQL Server Enterprise Manager. Have I understood you? If I have
> misunderstood your concern, please feel free to point it out.
>
> First of all, would you please help me clarify the words "I connected
> using
> Visial Studio"? You have said you are working wiht your Enterprise
> Manager?
> When do you meet the error message "Can't access user's default database"?
> More detailed informaiton, I believe, will make us closer to the
> resolution. Please help me collecting the information by answering the
> questions below
>
> What account you are using to connect this SQL Server?
> The SQL Server machine is in LAN or Internet?
>
> You may refer the Knowledge Base article below
>
> How to troubleshoot connectivity issues in SQL Server 2000
> http://support.microsoft.com/kb/827422
>
> BTW, if this issue is urgent, I would like to recommand you opening an
> incident with PSS team direcly and there will be a dedicated Support
> Professional working for you. Please be advised that contacting phone
> support will be a charged call.
>
> To obtain the phone numbers for specific technology request please take a
> look at the web site listed below.
> http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS
>
> If you are outside the US please see http://support.microsoft.com for
> regional support phone numbers.
>
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
>
> Sincerely yours,
>
> Michael Cheng
> Microsoft Online Partner Support
>
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================
> Business-Critical Phone Support (BCPS) provides you with technical phone
> support at no charge during critical LAN outages or "business down"
> situations. This benefit is available 24 hours a day, 7 days a week to all
> Microsoft technology partners in the United States and Canada.
>
> This and other support options are available here:
> BCPS:
> https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
> Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
>
> If you are outside the United States, please visit our International
> Support page: http://support.microsoft.com/common/international.aspx
> =====================================================
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>