RE: upgrade sharepoint database to SQLserver - connect error

Hello John,

Thank you for posting here.

From the post, I understand you can not make the Sharepoint connect SQL
2005 database after he move the sharepoint data from MSDE to SQL 2005.

If this is your concern, please repost your issue in WSS newsgroup for
further assistance.

This newsgroup is primarily for issues involving deployment, configuration,
consultation and troubleshooting. The reason why we recommend posting
appropriately is you will get the most qualified pool of respondents, and
other partners who read the newsgroups regularly can either share their
knowledge or learn from your interaction with us.

WSS Newsgroup: microsoft.public.sharepoint

I hope the information above is helpful.

If there is anything else I can do for you, feel free to let me know.

Thanks and have a nice day!

Best regards,

Terence Liu(MSFT)

Microsoft CSS Online Newsgroup Support

Get Secure! - www.microsoft.com/security

=====================================================
This newsgroup only focuses on SBS technical issues. If you have issues
regarding other Microsoft products, you'd better post in the corresponding
newsgroups so that they can be resolved in an efficient and timely manner.
You can locate the newsgroup here:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx

When opening a new thread via the web interface, we recommend you check the
"Notify me of replies" box to receive e-mail notifications when there are
any updates in your thread. When responding to posts via your newsreader,
please "Reply to Group" so that others may learn and benefit from your
issue.

Microsoft engineers can only focus on one issue per thread. Although we
provide other information for your reference, we recommend you post
different incidents in different threads to keep the thread clean. In doing
so, it will ensure your issues are resolved in a timely manner.

For urgent issues, you may want to contact Microsoft CSS directly. Please
check http://support.microsoft.com for regional support phone numbers.

Any input or comments in this thread are highly appreciated.
=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
| From: "John Lenz" <lenz4@xxxxxxxxxxxxxx>
| Subject: upgrade sharepoint database to SQLserver - connect error
| Date: Tue, 13 Mar 2007 16:03:23 -0500
| Lines: 33
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
| X-RFC2646: Format=Flowed; Original
| Message-ID: <eobQSMbZHHA.4872@xxxxxxxxxxxxxxxxxxxx>
| Newsgroups: microsoft.public.windows.server.sbs
| NNTP-Posting-Host: dpc674430134.direcpc.com 67.44.30.134
| Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP03.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.windows.server.sbs:22682
| X-Tomcat-NG: microsoft.public.windows.server.sbs
|
| Sorry if this has been answered before.
|
| I installed Win SBS 2003 and the SQL server 2005 addition.
|
| I am trying to move my SharePoint data bases from MSDE to the Sql Server.
|
| I am following directions contained in MS Windows SBS 2003 R2
| Administrator's Companion manual.
|
| I have backed up existing SharePoint files (minimal, just installed OS).
|
| I upgraded the SHAREPOINT instance.
|
| I have verified that the SQL configuration network listens for TCP/IP both
| local and remote.
|
| When I attempt to open SharePoint in SQL server management studio on the
| server PC, I get error 26 cannot connect to server\SHAREPOINT.
|
| I have UDP port 1434 opened on server.
|
| I can open the default SQL server data base and SBSmonitoring on the
server
| PC. Only SharePoint is not connecting.
|
| Since I followed the manual, I removed MSDE program, so now I have no
| SharePoint.
|
| What do I need to do to make the connection on the server machine so I can
| complete the movement of SharePoint data bases to SQL server 2005?
|
| Thanks
|
|
|

.

Relevant Pages

  • Re: Sharepoint URL error
    ... When we rename the file in Web UI/Explorer view, Sharepoint object model ... So we should focus on SQL server. ... Please create one new WSS site at the SBS server, ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • RE: MSDE, Access, SharePoint... I am not sure where to ask this questi
    ... Thank you for posting in the SBS newsgroup. ... Is it compatable to MSDE - SQL Server Express? ... We can upload an Access database into WSS (SharePoint). ...
    (microsoft.public.windows.server.sbs)
  • RE: Sharepoint 2.0
    ... Microsoft CSS Online Newsgroup Support ... <Thread-Topic: Sharepoint 2.0 ... > desktop engine was installed for each instance of the sql server going ...
    (microsoft.public.windows.server.sbs)
  • Re: ShapePoint database upgraded to SQL Server 2K - change sa password?
    ... is if changing the SA password will break the SharePoint. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ... ShapePoint database upgraded to SQL Server 2K - change sa ...
    (microsoft.public.windows.server.sbs)
  • Re: How to get Word using sharepoint list?
    ... Defiantly do not want Word access SQL directly even that I have the full ... see all live data from the Sharepoint list. ... do you have access to the Sharepoint SQL Server database at all (I mean, ... connection - in Word the simplest approach is probably to use a .odc file to ...
    (microsoft.public.word.mailmerge.fields)