SCS Conf Wizard 2009 - the database specified does not have a valid commerce server database

Question

Hello,

We have followed the installation and template pack guide to the Sharepoint commerce server configuragtion wizard, it creates the web app etc, but when he starts unpacking the pup we get an error in the log of access denied, sql server does not exist or access denied, in sql profiler there are no login failures.

We are using an alias (sql is not on standard port). Its the same sql of moss.

When we give the name of the machine (we open the standard ports for testing) it gave an error right on the (Next) buttn, before the unpacking screen...

It seems that with the alias he doest 'test' the sql, only after unpacking...

Is there a problem with the wizard using alias or non standard sql ports??

In odbc we can connect to sql and test a connection, the user running wizard is has sql access, runtimeuser has sql access..

We dont know what else to try. any ideas? tks

---

http://pontodepartilha.blogspot.com

Answer 1

[15:18:31] Initializing...

[15:18:31] The cmdline used to launch the packager: /u /f:MicrosoftCommerceDefaultSiteNoData.pup /i:f:\Program Files\Microsoft Commerce Server 2007\Microsoft Commerce Server 2009\Site\ContemporarySite_settings.ini

[15:18:49] An error has occurred (80004005): [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

[15:18:49] Exit status code for this session: -1

Using the alias or the <ip, port> gives this error.

Permissions in sql? the wizard uses the cred. of the running user right? the user is dbo. where does the wwizard go after the unpacking in sql? to the wss content db? CA DB? Commerce Admin DB?

************UPDATE:

It seems the problem is with PUP.EXE since i get the same error when executing Site Packager, or opening ANY pup file.

I opened procmon and i get this error when running pup or commerce services wizard:

18:09:34,1565507 PuP.exe 3612 CreateFile \\<MY_TCP_ALIAS>\pipe\sql\query BAD NETWORK PATH Desired Access: Generic Read/Write, Disposition: Open, Options: Non-Directory File, Attributes: N, ShareMode: None, AllocationSize: n/a

Another strange thing is that i have created a named pipe alias, test it with odbc and then in the wizard @ "Database:" i used this second alias, but still in the procmon i get: <MY_TCP_ALIAS> instead of my: <MY_2ND_TCP_ALIAS>

---

http://pontodepartilha.blogspot.com

Answer 2

If you are using alias for sql, please make sure the alias is on the hosts file... go figure

It solved the situation, then we had an error:

Unable to access IIS.  Either it is not installed, not running, or the user does not have sufficient priviledges. 9:Subscript out of range

the problem was the default site, so we tried to move the site under w3svc but didnt work so we had to remove the default site...

---

http://pontodepartilha.blogspot.com

Answer 3

I have encountered the '9:subscript out of range' error.  It turned out to be as issue with the way IIS7 deleted a web site, but didn't fully delete it.  The workaround was to use MetaBaseExplorer from here:
http://www.microsoft.com/downloads/thankyou.aspx?familyId=56fc92ee-a71a-4c73-b628-ade629c89499&displayLang=en ii6 resource kit

metabase explorer.  look at pup.log -- it lists the apps it found.  Delete the one it didn't find.

Answer 4

Thanks, i didn't knew metabase explorer. Actually by deleting it we did solve that situation..the problem was that the wizard run without problems but at the end the site wasnt working and we did every post-deploy step in the guide... we are jumping to a clean machine in order to get over this problems...

I think the biggest tip here would be for people using alias for sql, adding it to the hosts file.

---

http://pontodepartilha.blogspot.com