Guest gary7 Posted December 7, 2007 Posted December 7, 2007 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?
Guest Thee Chicago Wolf Posted December 7, 2007 Posted December 7, 2007 Re: An error has occured while establishing a connection to the server >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? Hi, Service Pack 2 for SQL Server 2005 installed? http://technet.microsoft.com/en-us/sqlserver/bb426877.aspx - Thee Chicago Wolf
Guest gary7 Posted December 7, 2007 Posted December 7, 2007 Re: An error has occured while establishing a connection to the se Re: An error has occured while establishing a connection to the se > > Hi, > > Service Pack 2 for SQL Server 2005 installed? > http://technet.microsoft.com/en-us/sqlserver/bb426877.aspx > > > - Thee Chicago Wolf I just installed it, and followed the set up of adminstrative rights after the main install completed. I tried a quick connection via VS 2005 server explorer from my vista box, and while I could log onto the Windows Server, I couldn't open a connection to SQL Server, and received the same message as before. Thanks! >
Recommended Posts