ePO Database conneciton on install

[undrstr]

It has been a while since my last install.  for the last number of years, I have only had to upgrade my ePO server.  Today i am installing fresh on a test box so that I can really break things. 

Current sitation is as follows:

Downloaded ePO 5.3.1 (it is what my network is using so that is what I am testing with)
unzipped the installer
Started running the installation. 
using the SQL Express that came with the download
Get to Database Information
    --> I make sure the Database sever was correct
    --> Made sure my username and password were correct
   --> even changed the registry to make sure I could use mixed authentication.

I still come up with the messgae, when trying to connect via SQL Autnetication i receive 1434 or 1433 UDP cannot be used.  And I am unable to validate the credentials with my Admin Account.

Last piece of this puzzle. I am attempting this install on my windows 7 test system with a local SQL Express Database. 

Any help is appreciated.

Thank you

[Former Member]

undrstr,

You may have to enable the ports within the SQL server, I ran into a problem a couple of years ago where the SQL server had to have the 1433 port enabled within the SQL software.

HTH,

DocB

[cdinet]

There are a couple of things to check.  Goto sql configuration manager and validate that tcp is enabled, and that you are using the right port.  Sql express installs usually install it as an instance, such as eposerver, and a non-default port other than 1433.  Validate instance name and port.  If either one of those is incorrect, it will fail.  You can also validate sql connectivity first by using test udl (kb70929)

[undrstr]

Thank you for the help.

Here is where we are currently.  The Database information screen for the Installation still will not access the database. 

However when I use the Test.udl to check the connection via Windows NT Integrated Security. I get a successful conneciton.  I try my username and password and I still get no go.  But there is a connection.

Here is what I have in the Database connection screen.

Database Server = MKIRBY-PC\EPOSERVER
Database name = ePO_MKIRBY-PC
Domain              = MKIRBY-PC
Windows Authentication 
     Username = mkirby
     Password  = verified correct password.  (Several times,  LOL)
SQL server TCP Port:  Tried 1433; 1434; 80 and; 443.

Thanks again for all the help.

[cdinet]

in sql configuration manager, did you confirm the ports being used are what you are using?

[undrstr]

Yes I did.

however the SQL Manager only confirmed for SQL  nor SQL Express.  Wasn't sure if that was p[roper, but its what I had to go by.

[cdinet]

for windows authentication, is it local windows account or domain?  did you try domain\username if it is domain account?

If you set up an sql account with proper permissions, does that authenticate?

[cdinet]

when you used the test.udl, did you add a port or did it just find it?  Can you send a screenshot of the settings for tcp in configuration manager?  So you would go to sql configuration manager (not management studio), sql server network configuration, protocols for eposerver, then double-click tcp.  go to ip addresses tab, scroll to bottom and take screenshot of just the tcp ports at bottom of screen.  I don't want your IP info or any specific server info.

[undrstr]

I am not on a domain so using it as a local account. 

The UDL didnt use a port.  It just found it.

[cdinet]

Ok, can you get a screenshot of the ports in config mgr?