Go 4 Sharepoint

Search:

Welcome: Guest!

Sharepoint Forum

Home » Forum » Sharepoint

Ask a question

RSS Feeds

SPS2003 Install error

Asked By: Jenny Grant Date: Mar 20, 2010 Category: Sharepoint Views: 198

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
support.microsoft.com/default.aspx

Tagged:sps2003 install error

2 Answers Found

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

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, 2010

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.