EM can't connect to server

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.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|||I can't connect using QA either.
Thanks,
Shimon.
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:u6P6UNmYFHA.2264@.TK2MSFTNGP10.phx.gbl...
> Shimon Sim wrote:
> 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|||Shimon Sim wrote:
> I can't connect using QA either.
> Thanks,
> Shimon.
Log in as a different user in QA... one with admin rights. Then change
the default database.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Thanks
I connected using Visial Studio
Shimon.
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:u6P6UNmYFHA.2264@.TK2MSFTNGP10.phx.gbl...
> Shimon Sim wrote:
> 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|||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/defaul...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 w 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/te...erview/40010469
Others: https://partner.microsoft.com/US/te...upportoverview/
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.|||Michael
Thanks for your response.
I resolved the issue.
What happen I deleted my default database. And all the users for the SQL
Server had that database as default. So every program (EM,QA) that uses
default database in order to operate was throwing errors that they can't
login to the server.
So I decided to create database project in VS that uses specifies database
for login and not default and changed default database for all the users.
Thanks again.
Shimon.
"Michael Cheng [MSFT]" <v-mingqc@.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/defaul...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 w 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/te...erview/40010469
> Others: https://partner.microsoft.com/US/te...upportoverview/
> 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.
>|||Hi Shimon,
You are welcome and it's great to hear you have resolved this!
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 w 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/te...erview/40010469
Others: https://partner.microsoft.com/US/te...upportoverview/
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.