Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

SPS2003 Install error

  Asked By: Jenny    Date: Mar 20    Category: Sharepoint    Views: 786

I have tried installing SPS2003 on both my test network and my
production network for the second time. In production I didn't not
attempt to delete any old databases and I got the 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.

And I tried this again in test, and got the same error. So I delete
4 databases that appeared to be created by SPS install being STS???
NationOn1_Site, NationOn1_Prof, NationOn1_???? and I still get the
same error.

There is a KB article on the error but it didn't fix my problem, nor
does it seem to relate to my problem as my MDAC version was correct
so my problem contradicts the KB article.

You can read the article at



2 Answers Found

Answer #1    Answered By: Marianne Vance     Answered On: Mar 20

Your error  message implies you are running  SQL on a server  other than the
one on which you are installing  SPS2003 (good).
1) From the SPS server, check your connectivity (PING the SQL Server using
the DNS name) - this is just to make sure your DNS server is correct.

2) Ensure (in SPS config parameters) you are referencing the SQL server
correctly: \\serverName\instanceName
3) and that the SPS administrator account  has administrative rights to the
SQL "Master" data base.

Answer #2    Answered By: Aayushman Kanvinde     Answered On: Mar 20

Yes I can ping the SQL server, and the SQL server  is working fine
with other applications, both in our test  lab and in production.
Btw I'm having the SAME EXACT ERROR both in production  & test lab.

I'm is the FormDatabase.aspx setup page, techincally I'm still in
the late stages of installing  SPS. Here you must define the
server's name, no \\.

I added the domain accound to the SQL server and gave it full access
over Master and the server in general, still the same problem.

Didn't find what you were looking for? Find more on SPS2003 Install error Or get search suggestion and latest updates.