Solved

no items under  the databases

Posted on 2009-05-06
7
177 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
  • 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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQl server restarts itself 6 33
Sql Permission 6 53
SQL Agent Timeout 5 48
How can I exclude some wording in a like statement? 39 67
This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

867 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now