RE: Sharepoint Services problems

I'm not familiar with the term WSS, but in the sharepoint administration
there's a page to change database connection information. Initially I had
the database on a different server, but I couldn't get the site to see it, so
for testing purposes, I put the database on the local MSDE (that setting
seems to be the only one I can get to work). I put in the database admin
user as sa with the password and submit.

Are there settings somewhere else? Also is there a support number or
something I can call? This is becomming mission critical as the server my
current intranet site is on is on it's last legs.

"Cornelius J. van Dyk" wrote:

> Penny,
>
> Not knowing the details of your migration, I will make an educated guess.
> It sounds like a permissions issue to me. It could be that WSS is
> attempting to connect to the SQL database under the credentials it was setup
> with, but these credentials are not valid in SQL. You would be able to
> manipulate the database in Enterprise Manager because it runs under your
> logged in credentials.
>
> I would start by verifying the credentials under which WSS runs has
> permissions to the database.
>
> Hope this helps.
>
> Thanks
> C
>
>
>
> "Penny" wrote:
>
> > I'm in HIGH hopes someone can help me here. I'm working with MS Sharepoint
> > Services and have our intranet site migrated to a new server. I haven't been
> > able to post anything to this site I keep getting this error:
> >
> > SQL Server Error
> >
> > The SQL Server might not be started.
> >
> > If this problem persists, please contact your administrator.
> >
> >
> > I found an article in the MS KB and looked at everything like Registry
> > settings and SQL server itself and the database is in fact up and running,
> > NOT in read only or restricted mode.
> >
> > There is a level of connectivity to the database because I am able to edit
> > entries that already exist.
> >
> > I'm at wits end as to what to look at next.
.

Relevant Pages

  • RE: WSS install locked into MSDE DB - Can not install for SQL Serv
    ... We have been using the WSS Web Admin interface. ... directing WSS to use SQL server. ... > Extend And Create A Content Database. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: SharePoint Services 3.0 unable to display content
    ... When connecting to the original configuration database, ... You are correct about the SQL Server. ... I am 100% about the WSS. ... Microsoft Windows SharePoint Services 2.0 ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: MOSS2007 and SQL2005 on Single Server
    ... I concur with Mike's response referencing deployment of a low cost ... The version for WSS 3.0 isn't because a single server setup is quite ... database size will require you to upgrade to SQL Server ...
    (microsoft.public.sharepoint.portalserver)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Sharepoint Services problems
    ... attempting to connect to the SQL database under the credentials it was setup ... but these credentials are not valid in SQL. ... I would start by verifying the credentials under which WSS runs has ... > The SQL Server might not be started. ...
    (microsoft.public.sharepoint.windowsservices)