Re: SQL Error?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Roger Crawford (rcrawford_at_nospam.scci.com)
Date: 03/07/04


Date: Sat, 6 Mar 2004 20:32:24 -0600

John can you open Enterprise Manger for SQL and do you see the databases OK?
In services is MSSQL$SHAREPOINT running? If you can go into your Sharpoint
Database in SQL Enterprise Manger and then drill down to Tables and then on
the DOC's table right click and then return all rows and see data or
documents you might have uploaded it is working.

Roger Crawford
HTS

"John A. Ross" <anonymous@discussions.microsoft.com> wrote in message
news:83f101c403d4$5e07dc20$a501280a@phx.gbl...
>I have just completed a new installation of SBS2003, all
> went fine using the new CD3. ISA200 install went fine,
> then I upgraded the MSDE instance of sharepoint to SQL2000
> then added Sp3. I got no errors at any time and followed
> the instructions to the letter
> (I note the instructions neglect to mention the wizard
> when registering new server!)
> Anyhow all seemed fine, but when I restarted the server
> the system tray icon for the SQL Server System Manager did
> not show the green arrow, it was blank and just
> displays "Not Connected - \\" and both services and server
> drop down boxes are empty.
>
> Any ideas what I have done wrong?
>
> Thanks for any help
>
> John



Relevant Pages

  • Re: SQL Error?
    ... see the databases OK? ... >Database in SQL Enterprise Manger and then drill down to ... installer puts in the startup group (SQL Server System ...
    (microsoft.public.windows.server.sbs)
  • RE: Database Maintenance Plan
    ... Do you have any anti-virus application running on SQL which may violating this step for Maint.plan. ... "John" wrote: ... > Maintenance Plan that backs up our databases nightly. ... it is not conducting this deletion. ...
    (microsoft.public.sqlserver.setup)
  • Re: BizTalk eating up SQL Server (Virii Behaviour)
    ... Yes, one gig is the least to run sql & bts in the same box, ... uninstall procedure, i manually deleted all databases, and run the ... and it was leaving like 20 mbs free memory, ... BizTalk Solution Developer ...
    (microsoft.public.biztalk.general)
  • Re: Dont understand what version of SQL to install
    ... I'm talking about developing and testing databases for my client and ... To my XP, I can add SQL Developer 2008 to develop (I guess I should say, ... So I can use SQL Developer 2008 to create a database in standard 2005, ... installed on Client OSs such as Windows Vista. ...
    (microsoft.public.sqlserver.setup)