Re: Moving Sharepoint 3.0 MSDE database files

Tech-Archive recommends: Speed Up your PC by fixing your registry

Costas,

I'm thinking that I'll remove SP3 and try to install again and see
what options are available if I don't take the standard install.

Thanks
Tony


On Sep 11, 6:03 pm, "Costas" <cpstechgr...@xxxxxxxxx> wrote:
Tony,

I have seen that error before but not with the companyweb database.
Something must have gone wrong when you restored companyweb (I assume that
no other instance of SQL Server runs on the SBS box). If you can't connect
to the database there isn't much you can do.
--
Costas

"ASL" <tony.bau...@xxxxxxxxx> wrote in message

news:1189526745.033342.298860@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx



Hi Costas,
Thansk for taking the time to offer suggestions, I've now determined
that:

MSSQL$SHAREPOINT service is running
Security is set to Windows Authentification
Tried to apply SP4 but fails due to weak password on sa account but
can't update to something secure as I can't connect to the default
instance:

C:\Program Files\.....Data>osql -U sa -S TMDC01\sharepoint
Password:
Login failed for user 'sa'. Reason: Not associated with a trusted SQL
Server
connection.

C:\Program Files\.....\Data>osql -E
[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen (Connect()).

I've been through a number of the articles on the page you linked to
but most appear to be for full SQL rather than the MSDE
implementation, any further thoughts gratefully received

Tony

On Sep 11, 2:35 pm, "Costas" <cpstechgr...@xxxxxxxxx> wrote:
The default instance name for WSS 2.0 is 'SharePoint' so you are using
the
correct one. First make sure that the MSSQL$SHAREPOINT service is
running
otherwise you won't be able to establish connection. If that isn't the
problem take a look at the following KB article for some
clueshttp://support.microsoft.com/kb/328306

--
Costas

"ASL" <tony.bau...@xxxxxxxxx> wrote in message

news:1189516245.385349.246020@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

I've picked up a new site that has SBS2003 STD that has been installed
and "looked after" by some techies - it's not very pretty :(

Have removed and then installed Sharepoint2 as it was corrupted.
Installed Sharepoint 3 with all defaults as a parallel install and the
world is good.

However I need to move the database files to another drive, simple I
thought as I've done this before with v2 but this time I'm struggling.

Following KB843580 and can't get connected with osql

MSDE file are in C:\Program Files\Microsoft SQL Server\MSSQL$SHAREPOINT
\Data
10/09/2007 22:50 1,310,720 STS_Config.mdf
11/09/2007 01:30 516,096 STS_Config_log.LDF
10/09/2007 22:51 6,881,280 STS_TMDC01_1.mdf
11/09/2007 05:00 786,432 STS_TMDC01_1_log.LDF

C:\Program ....\Data>osql -E -s TMDC01\sharepoint
[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen (Connect()).

Any ideas on finding the correct instanace name?- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -


.

Relevant Pages

  • RE: How do I get back to base SQL server on my SBS 2003 server?
    ... After you uninstall SQL 2005, the instance which you upgraded will not go ... Uninstall and then reinstall ISA server. ... Uninstall and then reinstall the Monitoring component. ... Tools to Maintenance, change Monitoring component to Install, and then ...
    (microsoft.public.windows.server.sbs)
  • RE: How do I get back to base SQL server on my SBS 2003 server?
    ... What's the error message you see when installing SQL? ... the easier way is to restore the server from recent backup. ... Screen shot of the error when you install SQL 2005 Workgroup edition. ... <The server-based applications that were running fine are: McAFee EPO, ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS 2003 and Sql Server ~ Client Install
    ... I've found the client tools and have now ... A word mail merge document could access a SQL database via ... We want to install to gain an understanding. ... Once we've managed to install the SQL Server Client we can start to ...
    (microsoft.public.backoffice.smallbiz2000)
  • Re: how do I change the user install wizard to create user folder in different location?
    ... Some people read the instructions in such a way that they install both a new ... instance of sql, ... Never slight the SBS wizards. ... I reinstalled from scratch using the Dell OpenManage Server ...
    (microsoft.public.windows.server.sbs)
  • Re: Installing SBS2k3 CEICW Network Error
    ... DHCP Server 192.168.0.1-254. ... Internal NIC gets 192.168.16.2 from SBS2k3 DHCP server. ... Boot SBS2k3 from CD1 in CD-ROM and start install. ... > Leave the box talking about a single network connection unchecked, ...
    (microsoft.public.windows.server.sbs)