I have setup a server that runs Windows Server 2008, and has SQL Server 2008 Express installed.
I can connect to the machine's SQL Server Express database via the
However when we come to connecting through any software or script using an IP Address it won't allow the connection.
I have tried:
- Turning off the Firewall.
- Allowing Remote Connections for the SQL Database.
- Enabling TCP/IP within the SQL Configuration.
When we attempt to connect via the software 'SQL Server Management Studio', we get the following message:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.) (Microsoft SQL Server, Error: 10061)
A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - An established connection was aborted by the software in your host machine.) (Microsoft SQL Server, Error: 10053)
Can you please let me know when your free so we can take a look because I seem to be getting know where, I’ve amended the details as per some information UK Fast sent me but they have said "It’s not within the support remit", so they can’t help any further.
I look forward to hearing from you.