An error has occured while establishing a connection to the server

  • Thread starter Thread starter gary7
  • Start date Start date
G

gary7

Guest
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?
 
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
 
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!

>
 
Back
Top