Re: Sharepoint Migration issues

Does anyone else have any ideas? The administration site would not work if I
changed the Identity of the application pool to a domain user....

"Todd Klindt [MVP]" wrote:

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: Permission question - another one
    ... I would have thought that Administrator ... Are you asking why is it connecting to SQL Server? ... > and I gave BUILTIN/Administrator this database as its default database. ...
    (microsoft.public.sqlserver.programming)
  • Re: Windows Vista Enterprise and SQL Server 2005 Agent
    ... This has nothing to do with SQL Server and this is an expected behaviour of Windows Vista operating systems. ... Cause of those popups and normal-user-like acting is some new security system called User Account Control. ... It all seems to be related to security things, even though I am an administrator. ...
    (microsoft.public.sqlserver.security)
  • Re: Fresh installation and no access
    ... You're not getting access because you're not an administrator when you log ... In previous OS's you had administrator permissions on the database ... You must create a login (to allow connect to SQL Server) then a user to be ...
    (microsoft.public.sqlserver.security)
  • Re: BULK Insert Problem
    ... Vyas, MVP (SQL Server) ... I Log on to my system using the Local System Administrator Account. ... And If I Try to Bulk Insert any thing from my ...
    (microsoft.public.sqlserver.programming)
  • Re: Permission question - another one
    ... SQL Server looks at when you try to connect using Windows Authentication. ... >>> Does your Windows Login TRAVAC/tfs belong to the local Administrators ... >> Are you talking about on Raptor? ... > I am assuming local administrator is in local users and groups from ...
    (microsoft.public.sqlserver.programming)
Loading