06-29-2011 04:58 AM
Hello all,
strange issue. I've succesfully installed DA in a site. I am now trying to create a customer. The EV server and the SQL server are seperate.
I enter as SQLserver SERVERNAME\INSTANCE
Add appropriate logfile and databasefile directory. I get an error that the instance cannot be found.
Error in EV-eventlog is: APP ATM - Error installing a Customer.
Install Thread - worker thread (1)
Customer ID: 3
Number of tries: 1
Cause: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Is the format I use correct? Additionally, the instance listens to a different port. Should I add the port?
Solved! Go to Solution.
06-30-2011 12:58 AM
In SQL-server under Database Details, enter the IP-address of the SQL server, with the instancename...
10.10.0.10\INSTANCE
Then it works. Issue due to Named Pipes being disabled. When disabled, apparently creating a customer uses Named Pipes?
06-29-2011 11:10 AM
Try a \\ before the server name
Regarding the port i have not had to deal with that before but my gues is that if a non standard port is used you should specify the port otherwise it has no way to communocate with it
06-29-2011 11:22 AM
Correction put a / in the server/instance as specified in "SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"
06-30-2011 12:22 AM
Helo Liam,
I've tried:
servername\instance (fails)
servername\instance,port (fails)
servername/instance (fails)
servername/instance,port (fails)
servername/instance:port (fails)
servername\instance:port (fails)
The exact message is:
APP ATM - Error installing a Customer.
Install Thread - worker thread (0)
Customer ID: 4
Number of tries: 1
Cause: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Note that it reads Named Pipes Provider! I believe our SQL server only allows TCP/IP. I'm checking with SQL-team to enable NamedPipes, then will try again
06-30-2011 12:58 AM
In SQL-server under Database Details, enter the IP-address of the SQL server, with the instancename...
10.10.0.10\INSTANCE
Then it works. Issue due to Named Pipes being disabled. When disabled, apparently creating a customer uses Named Pipes?
06-30-2011 05:12 AM
Yes it does use names pipes during the creation
If i remember correctly having this turned on is a requirement. You should consider enabeling it
06-30-2011 05:45 AM
Hello Liam,
I checked the installing and configuring and the Admin guides from 8 and 9, there is no mention that named pipes is required.
It would be handy to have this listed somewhere.
07-05-2011 10:24 AM
I will pass the suggestion to the PM on having it added to the Doc's