RE: Reinstall of SMS v2 - Could not get connection of type SMS ACCESS

Tech-Archive recommends: Speed Up your PC by fixing your registry

Dear David,

Thank you for posting.
This is Lee and I am glad to meet you in the newsgroup.
The error message of "Could not get connection of type SMS ACCESS" is
generated by the following code of the SMS 2.0:

CSql *pSql =
CSqlCache::GetConnection(GetSqlConnectionString(pSetupInf->SqlServer,
pSetupInf->SqlDatabaseName));
if (!pSql) {
LogMessage("Could not get connection of type SMS ACCESS\n");
return FALSE;
}

So it appears the issue is after the SMS DB had been created on the SQL
server, the setup application cannot connect to the new created DB
correctly.
This is usually caused by the SMS service account that you had used have a
permission issue.
To this issue, please provide me the following information/files to check
the issue further on the computer:
1. Please send me the whole SMSSetup.log file on the computer. (You can
send the files to leelili@xxxxxxxxxxxxx)

2. You had mentioned "You are attempting to reinstall as per recovery
expert advice"
Can you provide me the advice that you had used to do the reinstallation? I
need to check which part in the recovery expert that you are referring to.

3. Is the SMS site server also installed on the computer COTLEIGH? If you
restart the SQL server, delete the newly created DB and do an installation
again, can the installation go smoothly?

Please keep me posted on how things go. Have a nice day!

Sincerely,

Lee Li
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.

This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/

If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.

=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

.

Relevant Pages