Re: Sharepoint Migration issues

Good tips, Ada.

tk
"Ada Pan [MSFT]" <v-adapan@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:fh%23C53JsGHA.4424@xxxxxxxxxxxxxxxxxxxxxxxx
Hello Customer,

From your test result, we need to first check if there is any
communication
problem between the SQL Server and the new WSS server to narrow down this
issue. To do this, please refer to the following steps:

Note: Please perform the following steps on the new WSS server.

Step 1. Ping the SQL Server on the new WSS Server
====================================
If the destination (the SQL Server box) is unreachable, this should be a
networking issue.
If the destination (the SQL Server box) is reachable, please try the
following steps.

Step 2. Test in the Excel application
=========================
1. Start Excel 2003.
2. On the Data menu, point to Import External Data, and then click Import
Data.
3. In the Select Data Source dialog box, click New Source.
4. In the Data Connection Wizard, choose <Microsoft SQL Server> to connect
to, and then click Next.
5. Input the SQL Server name, choose Use Windows Authentication and click
Next
Now, can you successfully move on to the next step or do you receive any
error message?
If you receive any error message like "SQL Server does not exist or access
denied", it indicates that the new WSS Server cannot successfully connect
to the computer running SQL Server 2000. If this is the case on your
side,
you need to submit the question into the SQL Server queue to get more
qualified assistance.
If you can successfully set up a connection in Excel, I would like to
reconfirm with you the following information:

1. Make sure you use the Domain Account name for SharePoint Services, App
Pools in IIS

2. Make sure you assign the Domain Account name with System Administrator,
Security Administrator and Database Creator Role in the SQL Enterprise
manager.

Hope this helps.

Regards,

Ada Pan

Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
====================================================
This posting is provided "AS IS" with no warranties, and confers no
rights.


.

Relevant Pages

  • Re: Sharepoint Migration issues
    ... we need to first check if there is any communication problem between the SQL Server and the new WSS server to narrow down this issue. ... Ping the SQL Server on the new WSS Server ... Test in the Excel application ... Make sure you assign the Domain Account name with System Administrator, Security Administrator and Database Creator Role in the SQL Enterprise manager. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Sharepoint Migration issues
    ... changed the Identity of the application pool to a domain user.... ... Please perform the following steps on the new WSS server. ... Ping the SQL Server on the new WSS Server ... Make sure you assign the Domain Account name with System Administrator, ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Security and Extranets
    ... Have you tried to use sql server authentication instead of using windows ... > They are putting the WSS Server in the DMZ (so their employees can ... > inside the secure part of the network. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Sharepoint Migration issues
    ... I was able to ping the SQL server ... I verified the domain account has the proper roles in the SQL enterprise ... Please perform the following steps on the new WSS server. ... Ping the SQL Server on the new WSS Server ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: WSS and remote SQL server
    ... Your IIS Application Pools on the WSS server must be running under Domain ... Accounts that have permissions to create DB's on the SQL Server. ...
    (microsoft.public.sharepoint.windowsservices)
Loading