Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

SPS 2003 installation problelms with SQL 2005 Enterprise

  Asked By: Keaton    Date: Aug 20    Category: Sharepoint    Views: 839

We are doing a new installation of Sharepoint with SQL 2005. SQL
2005 is installed on a dedicated SQL server and the SQL services are
running under Local system. A separate instance has been created to
hold the databases.

On the Sharepoint application server, we have installed sharepoint
2005, then applied WSS SP2. After that completed, we applied
Sharepoint SP2.

Next we set up the application account which will run the Sharepoint
services. We get stuck on the configuration screen to connect to the
We keep getting the following error.
"Error accessing database. Verify that the database server name and
the instance name (if present) are correct. Also, ensure the
configuration database administration account has sufficient
permissions on the server or instance and the service corresponding
to your SQL Server instance is running."

SQL is listening on the Database server on port 1647. we can
successfully telnet to the port from the Sharepoint application
We can also successfully connect to a test DSN from the Sharepoint
application server (using the account under which the
Sharepoint services will run).

Any ideas on where we are going wrong?



2 Answers Found

Answer #1    Answered By: Katy Patton     Answered On: Aug 20

Have you set up a login and given the application account the correct
permissions in SQL Server? It must have Database Creators and
Security Administrators roles on your SQL Server. Also make sure an
alias has been set up on your application server to point to the
correct SQL instance.

Answer #2    Answered By: Ana Payne     Answered On: Aug 20

The account was set up with the right permissions. The problem was
that the SQL browser service wasn't started.

Didn't find what you were looking for? Find more on SPS 2003 installation problelms with SQL 2005 Enterprise Or get search suggestion and latest updates.