a connection cannot be made to redirector. Ensure that 'sql browser' service is running

Question

So Im trying this sql server 2012, and I cant open any ssis package due to this error

my Sql Browser is running for sure, I tried changing it under local service, local system and network, still no result yet, any help would be appreciated

Thanks

Have you looked at this article? Written for 2005 but basics should still apply. — billinkc
– billinkc, Commented Jun 13, 2012 at 12:55

GIREESH D A · Accepted Answer · 2012-08-28 04:49:26Z

7

This error seems to related only to named instances. The reason is SQL client is not able to resolve instance because SQL client has no access SQL Browser Service. SQL Browser Service resolves instance name

Ensure SQL browser service is running
Ensure the port on which SQL browser service runs, is not blocked from PC (default port 2382)

Alternatively, you can bypass SQL Browser Service, by mentioning "Server:Port" instead of "Server\instance name", in the client connection properties

edited Aug 28, 2012 at 4:49

answered Aug 27, 2012 at 12:08

GIREESH D A

711 silver badge4 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

a connection cannot be made to redirector. Ensure that 'sql browser' service is running

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related