Solved

no items under  the databases

Posted on 2009-05-06
7
183 Views
Last Modified: 2012-05-06
we have a sql server 2000 with sp4..I am currently connecting to a MSSQL 2000 db server.
However, from my enterprise manager, I kept on getting "no iteam" in the database folder..I can not see such as logins,or server rolles just not the actual databases..it says no items.
and users try to connect the database x with special application on citrix..and application it gives the following error;
3700 [4064] [Microsoft][ODBC SQL driver ] sql server
noeveryting is not working on the sql server...
0
Comment
Question by:teodor76
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24312022
It might be permission issue, the login you are using don't have permission, you can get login with SA or windows authentication and GRANT proper permission to login you are using.
0
 

Author Comment

by:teodor76
ID: 24312063
I have a full admin right on this server with windows authencitaion
0
 
LVL 31

Accepted Solution

by:
RiteshShah earned 500 total points
ID: 24312087
can you see all your services of SQL Server are running?
0
Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

 

Author Comment

by:teodor76
ID: 24312146
status of msql service,mssql server olap service and sqlagenservice is started.I did them again  stopped and then started..I opened enterprise manager and then I clicked sql group and then local windowsNT on the microsoft SQL servers  but it hangs in status " not responding"
0
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24312150
ok, just to test, can you login as SA rather than windows authentication?
0
 

Author Comment

by:teodor76
ID: 24312260
at the moment..it works..I can see all the databases I think that it worked after services is stopped and then started..thank you
0
 
LVL 31

Assisted Solution

by:RiteshShah
RiteshShah earned 500 total points
ID: 24312300
I am sure there must be some glitch from services which got repaired when you restarted it.
0

Featured Post

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question