|
| | | StrataFrame Beginner
 
Group: Forum Members
Last Login: 03/12/2010 11:38:02 AM
Posts: 20, Visits: 40 |
| | |
| | | StrataFrame Beginner
Group: Forum Members
Last Login: 03/12/2010 11:38:02 AM
Posts: 20, Visits: 40 |
| As you can see in the following picture, I'm able to connect to this server via SSMS on the same workstation.
|
| |
| | | StrataFrame Beginner
Group: Forum Members
Last Login: 03/12/2010 11:38:02 AM
Posts: 20, Visits: 40 |
| Additionally, I have no firewall enabled.
|
| |
| | | 
Strategic Support Team Member
Group: StrataFrame Users
Last Login: Today @ 11:07:38 AM
Posts: 1,044, Visits: 13,058 |
| Also, there is no option in the installer to provide a port 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: tcp:MySLQServerInstance,1500 , where 1500 is what I would have put as a port fot the IP All. |
| |
| | | StrataFrame Beginner
Group: Forum Members
Last Login: 03/12/2010 11:38:02 AM
Posts: 20, Visits: 40 |
| | But I'm assuming specifying the host name alone 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. |
| |
| | | 
StrataFrame VIP
Group: StrataFrame Users
Last Login: Today @ 10:39:38 AM
Posts: 1,590, Visits: 9,189 |
| Michael Gonzalez (03/09/2010)
... but when it reaches the part where it actually creates the SF database, it fails, so something's amiss.
Could it be that you don't have enough rights to create database and tables?
Have you tried to manually create a database or table on this server with your credentials?
Edhy Rijo
(Using VB.Net 2010/SQL Server 2008) |
| |
| | | StrataFrame Beginner
Group: Forum Members
Last Login: 03/12/2010 11:38:02 AM
Posts: 20, Visits: 40 |
| Could it be that you don't have enough rights to create database and tables?
No. I'm a member of the SysAdmin server role on the server.
Have you tried to manually create a database or table on this server with your credentials?
Yup, do it weekly (I'm a developer and a DBA where I work).
|
| |
| | | 
StrataFrame Developer
Group: StrataFrame Developers
Last Login: 07/06/2010 6:04:33 PM
Posts: 6,275, Visits: 6,165 |
| | As 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. |
| |
|
|