I've recently set up a Windows 2003 Server SP2 enterprise system to handle
SQL Server 2005 connections to data bases.
The Windows server is on a WorkGroup - not a domain, and I've set it up as
an application server. I installed SQL Server 2005 Enterprise, I ran the
services configuration tool and set it to allow both local and remote
connections, and to use tcp/ip.
I can see the Windows server pn the network, and can access the default
shared printer folder, but that's it.
I can't seem to access SQL Server at all, and no matter what I do keep
getting this error 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: SQL Network Interfaces, error: 28 - Server doesn't support
requested protocol) (Microsoft SQL Server, Error: -1)
It doesn't matter what I do to attempt permission on either the client
machine or the host, it always returns the same message.
I asked this question on the SQL group wich returned one response asking
whether I've openned the ports for SQL on the firewall, and yes I have.
So far, all client machines are Vista Ultimate with SQL 2005 developer
edition and Visual Studio 2005.
I could really use some hand holding with this - any takers?