SQL Network Interface error 28

Question

SQL Network Interface error 28

Ed7

SSCrazy Eights

Points: 8519
More actions
February 28, 2008 at 6:10 pm

#120048

Hello room,
I have 3 window servers 2003 running in window virtual server 2005.
Server1 has 3 instances of sql 2005
-- SQLDev01
-- SQLDev02
-- SQLDev03
Server2 has 3 instance of sql 2005
-- SQLDev01
-- SQLDev02
-- SQLDev03
Serve3 has 3 instance of sql 2005
-- SQLDev01
-- SQLDev02
-- SQLDev03
The servers are running in DC.
The sql server was setup with Window authentication mode only.
I was unable to add the server 2 or 3 sql instances into my register server1\sqldev01.
steps:
1. Right click the database engine
2. Select New and Server Registration
3 Select the sql server name. eg: Server2\sqldev01.
Error msg: An error has occurred while establishing a connection to the server.
When connection to SQL Server 2005, this failure may be caused by the fact that under
the default setting SQL Server does not allow remote connections. (provider: SQL Network
Interfaces, error: 28 - Server doesn't support request protocol)
All the sql instances'services are running under domain user name.
e.g: sqladmin.
Thanks for the help.

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

thecosmictrickster@gmail.com SSChampion Points: 10386 More actions · Answer 1

Can your virtual machines actually see each other at all? Simple ping test will verify that in short order.

What ports are the various instances listening on? You will probably need to specify the port in the connection details or ensure that SQL Browser is running on the server you are trying to connect to.

Scott Duncan

MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare

Vivien Xing SSChampion Points: 12297 More actions · Answer 2

check this link, search "error: 28".

http://blogs.msdn.com/sql_protocols/archive/2005/12/22/506607.aspx

Ed7 SSCrazy Eights Points: 8519 More actions · Answer 3

The 3 servers can ping each other via ip address and computer names.

Ed7 SSCrazy Eights Points: 8519 More actions · Answer 4

I was trying to setup database mirroring and run into this issue 🙂

Sugesh Kumar One Orange Chip Points: 27311 More actions · Answer 5

Do you have remote connection set to on on your server?

Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com

Big Data Man SSCrazy Eights Points: 8536 More actions · Answer 6

Hi,

Have you enabled remote connections using the Surface Area Configuration tool? Also, check what ports your named instances are listening on using SQL Server Configuration Manager tool.

Thanks,

Phillip Cox

MCITP - DB Admin

Ed7 SSCrazy Eights Points: 8519 More actions · Answer 7

Sugesh,

Can you more specifics and give the steps on setup remote connection.?

Thank you.

TJ

Adam Bean One Orange Chip Points: 26631 More actions · Answer 8

Is TCP/IP enabled in SQL Server Configuration Manager per instance?

Ed7 SSCrazy Eights Points: 8519 More actions · Answer 9

Phillip,

Ops!! I have not enabled the remote connection on Surface Area Configuration tool.

Thank you for your valuable advice.

Regards,

TJ 🙂

Big Data Man SSCrazy Eights Points: 8536 More actions · Answer 10

Hi Edwin,

Excellent result and appreciate update!

Thanks,

Phillip Cox

MCITP - DBAdmin