InstantForum 2017-1 FinalStrataFrame Forumhttp://forum.strataframe.net/StrataFrame ForumTue, 09 Jun 2026 03:38:57 GMT20http://forum.strataframe.net/FindPost26350.aspxFor some reason, even though I specify the correct DB credentials/server name, SF fails to setup the DB on installation. It acts as though there's a problem connecting to the DB server, even though the DB server is accessible from the same machine via other applications (no problems whatsoever). I've attached a print screen of the error.<br> <br> I'm evaluating this software and am not able to get too far because of this.<br>Wed, 10 Mar 2010 08:55:08 GMTMichael Gonzalezhttp://forum.strataframe.net/FindPost26403.aspxAs I have mentioned on the other thread, this has nothing to do with the connection. It has to do with the enumeration of the SQL Servers on the network. We will be publishing a new build soon (hopefully later in the week) that will prevent this error from happening. This is being cause by the installation tool that we use in conjunction with the MSI.Wed, 10 Mar 2010 08:55:08 GMTTrent L. Taylorhttp://forum.strataframe.net/FindPost26386.aspx[quote]Could it be that you don't have enough rights to create database and tables?[/quote]<br> <br> No. I'm a member of the SysAdmin server role on the server.<br> <br> [quote]Have you tried to manually create a database or table on this server with your credentials?[/quote]<br> <br> Yup, do it weekly (I'm a developer and a DBA where I work).<br>Tue, 09 Mar 2010 16:23:25 GMTMichael Gonzalezhttp://forum.strataframe.net/FindPost26385.aspx[quote][b]Michael Gonzalez (03/09/2010)[/b][hr]... but when it reaches the part where it actually creates the SF database, it fails, so something's amiss.[/quote]<br> <br> Could it be that you don't have enough rights to create database and tables?<br> <br> Have you tried to manually create a database or table on this server with your credentials?Tue, 09 Mar 2010 16:09:39 GMTEdhy Rijohttp://forum.strataframe.net/FindPost26382.aspxBut I'm assuming specifying the host name [i]alone[/i] should suffice, since the server uses the standard SQL Server port (1433). The installer verifies and passes the SQL Server connection validation phase, but when it reaches the part where it actually creates the SF database, it fails, so something's amiss.Tue, 09 Mar 2010 14:27:32 GMTMichael Gonzalezhttp://forum.strataframe.net/FindPost26380.aspx[quote]Also, there is no option in the installer to provide a port[/quote]</P><P>Yep, there isn't... you do that when you type the SQL Server Instance. Since I create a port for IP All, I put it in the line when I type the instance name, as in:<STRONG> tcp:MySLQServerInstance,1500</STRONG> , where 1500 is what I would have put as a port fot the IP All.Tue, 09 Mar 2010 13:59:57 GMTIvan George Borgeshttp://forum.strataframe.net/FindPost26379.aspxAdditionally, I have no firewall enabled.<br>Tue, 09 Mar 2010 12:31:52 GMTMichael Gonzalezhttp://forum.strataframe.net/FindPost26378.aspxAs you can see in the following picture, I'm able to connect to this server via SSMS on the same workstation.<br>Tue, 09 Mar 2010 12:29:31 GMTMichael Gonzalezhttp://forum.strataframe.net/FindPost26377.aspxStandard host name:<br>Tue, 09 Mar 2010 12:21:25 GMTMichael Gonzalezhttp://forum.strataframe.net/FindPost26376.aspxYou mentioned before that this was a remote server if so, are you using and IP or UNC name for the server?Tue, 09 Mar 2010 12:15:01 GMTEdhy Rijohttp://forum.strataframe.net/FindPost26375.aspxNop--I'm using the standard SQL Server port (1433).Tue, 09 Mar 2010 12:13:21 GMTMichael Gonzalezhttp://forum.strataframe.net/FindPost26374.aspx[quote][b]Michael Gonzalez (03/09/2010)[/b][hr]...Also, there is no option in the installer to provide a port[/quote]<br> <br> Hi Michael, <br> <br> If you are using a port other than the default for MS-SQL just add a comma and the port number next to the server name. Ex if you are using port 1234 the server name should look like this:<br> [quote]GSNSQL001,1234[/quote]Tue, 09 Mar 2010 12:12:12 GMTEdhy Rijohttp://forum.strataframe.net/FindPost26373.aspxAnd I've tried 3 different SQL Server 2005 servers--all of them produce the same error.Tue, 09 Mar 2010 11:56:39 GMTMichael Gonzalezhttp://forum.strataframe.net/FindPost26372.aspxThe error occurs on this step:<br>Tue, 09 Mar 2010 11:55:56 GMTMichael Gonzalezhttp://forum.strataframe.net/FindPost26371.aspxIvan, I'm using a remote server, and I can get to that server via my other DB tools on the same PC. Also, there is no option in the installer to provide a port, although the default server name and credentials seem to pass validation in the installer, as it doesn't state an error was encountered during that phase of the installer process/workflow, [b]only after, once it gets to the part where SF needs to install the SF database--that's where it fails.[/b]<br> <br> I've attached a few print screens.Tue, 09 Mar 2010 11:50:36 GMTMichael Gonzalezhttp://forum.strataframe.net/FindPost26369.aspxHi Michael.</P><P>Things that I have tried before when I faced this situation were:</P><OL><LI>supply a TCP port on the SQL connection. I usually go to the SQL Connection Configuration Manager, on the SQL Server Network Configuration, I get the properties of the TCP/IP protocol (which should be "Enabled", of course). On the Properties, I go to IP Addresses and for the "IP All" I enter a TCP Port, like 1500. Then, on connection I type "tcp:MyServer\SQLExpress,1500". On this example, I am connecting to an Express version.</LI><LI>Other thing it has worked for me, was to add the SQL.EXE application as an exception into the server Firewall.</LI></OL><P>So, just some ideas to try.</P><P>Cheers.</P><P>sql.exeTue, 09 Mar 2010 11:36:33 GMTIvan George Borgeshttp://forum.strataframe.net/FindPost26368.aspxBoth when I first install the S/W and after, via VS.NET. It's very strange. I've verified the correct server name and credentials were provided--no luck. It timeouts during the install, and via VS.NET, it gives a login failure, or some other error (most likely due to the fact that the installer never had the chance of creating the SF database). I use SSMS and Aqua Data studio on the same PC on which I installed SF, and those DB connections work fine.Tue, 09 Mar 2010 10:40:16 GMTMichael Gonzalezhttp://forum.strataframe.net/FindPost26357.aspxMichael,</P><P>When are you getting this error?&nbsp; During the installation or when you go into Visual Studio?Mon, 08 Mar 2010 20:58:11 GMTTrent L. Taylor