An error has occured while establishing a connection to the server

[Guest gary7]

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]

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]

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!

>