trying to connect to "MSSQL"...Fail

Dec 13, 2011 at 1:41 AM

i am using this auto install for sharepoint I found on codeplex but having trouble connecting to the SQL instance. log below:

**********************

Windows PowerShell Transcript Start

Start time: 20111213081946

Username : CIMDEV\spadmin

Machine : SP-APP (Microsoft Windows NT 6.1.7601 Service Pack 1)

**********************

Transcript started, output file is C:\Users\spadmin\Desktop\AutoSPInstaller-201

1-12-13_8-19.rtf

-----------------------------------

| Automated SP2010 install script |

| Started on: 12/13/2011 8:19:46 AM |

-----------------------------------

--------------------------------------------------------------

- Validating user accounts and passwords...

- Account "cimdev\spfarm"...Verified.

- Account "cimdev\spappsvc"...Verified.

- Account "cimdev\spcrawl"...Verified.

- Account "cimdev\spapp"...Verified.

- Account "cimdev\spmysiteapp"...Verified.

- Account "cimdev\spsearch"...Verified.

- Account "cimdev\spexcel"...Verified.

- Account "cimdev\SPSearch"...Verified.

--------------------------------------------------------------

--------------------------------------------------------------

- Creating SQL alias "MSSQL,1433"...

- Testing access to SQL server/instance/alias: MSSQL

- Trying to connect to "MSSQL"...Fail

--------------------------------------------------------------

- Script aborted!

- Connection Error. Check server name, port, firewall.

-----------------------------------

| Automated SP2010 install script |

| Started on: 12/13/2011 8:19:46 AM |

| Aborted: 12/13/2011 8:20:04 AM |

-----------------------------------

**********************

Windows PowerShell Transcript End

End time: 20111213082004

**********************

       <!-- If you are creating an alias, <DBServer> is actually the value of the SQL alias; otherwise it's the NetBIOS name of the SQL server or instance.
                 If you leave <DBServer> blank or specify localhost, script will assume the local server for SQL databases -->
            <DBServer>MSSQL</DBServer>
            <!-- The script can create a SQL alias for you. Enter the DBInstance, and if you leave <DBPort> blank, script will assume default port value of 1433 -->
            <DBAlias Create="true"
                     DBInstance="Alias_MSSQL"
                     DBPort="1433" />

I hope somone can be of assistance. thanks

Dec 13, 2011 at 6:58 PM

I solved this. The DBInstance needed to be the same as DBserver AND I needed to create an alias. It would not work without creating an alias. I am not sure why

Coordinator
Dec 17, 2011 at 4:11 PM

Hi there, in your XML the DBInstance is actually the DB instance or server name (if using the default instance), and the DBServer is actually the value you'd like to use for the alias (and the name/value that the script and SharePoint will use to address teh SQL instance).

Brian