Choose a named instance port(firewall).

Hi all,
i am installing a named instance in a DMZ.
Now i can choose for udp 1434 for the sqlbrowser srevice but the
Firwall/secutiry boys aren't happy about that.
So now i think i will configure it with a fixed tcp/ip port.
Wat port can i choose?
Eg. 1500 or 50000?
anyone?!
What port did you use?!
Thx!Hello Hate_orphaned_users,

> Hi all,
> i am installing a named instance in a DMZ.
> Now i can choose for udp 1434 for the sqlbrowser srevice but the
> Firwall/secutiry boys aren't happy about that.
> So now i think i will configure it with a fixed tcp/ip port.
> Wat port can i choose?
> Eg. 1500 or 50000?
> anyone?!
> What port did you use?!
> Thx!
>
See:
http://support.microsoft.com/kb/287932
I'd just configure it to use TCP 1434. a different port is just security
by obscurity. Poeple who want in will be able to find the port regardless
of the fact that you changed the number. And if anyone comes knocking, SQL
will happily tell them what it actually is.
Jesse|||Yes, i now.
But if i should configure a static tcp/ip port for the named instance which
one should i choose?Or what port is recommended.?
Cheers,
Harry|||> But if i should configure a static tcp/ip port for the named instance
> which
> one should i choose?Or what port is recommended.?
Any port not already in use?
Aaron Bertrand
SQL Server MVP|||Lol. That simple.Yup yup.
Thx. That answered my question.

Choose a named instance port(firewall).

Hi all,
i am installing a named instance in a DMZ.
Now i can choose for udp 1434 for the sqlbrowser srevice but the
Firwall/secutiry boys aren't happy about that.
So now i think i will configure it with a fixed tcp/ip port.
Wat port can i choose?
Eg. 1500 or 50000?
anyone?!
What port did you use?!
Thx!Hello Hate_orphaned_users,
> Hi all,
> i am installing a named instance in a DMZ.
> Now i can choose for udp 1434 for the sqlbrowser srevice but the
> Firwall/secutiry boys aren't happy about that.
> So now i think i will configure it with a fixed tcp/ip port.
> Wat port can i choose?
> Eg. 1500 or 50000?
> anyone?!
> What port did you use?!
> Thx!
>
See:
http://support.microsoft.com/kb/287932
I'd just configure it to use TCP 1434. a different port is just security
by obscurity. Poeple who want in will be able to find the port regardless
of the fact that you changed the number. And if anyone comes knocking, SQL
will happily tell them what it actually is.
Jesse|||Yes, i now.
But if i should configure a static tcp/ip port for the named instance which
one should i choose?Or what port is recommended.?
Cheers,
Harry|||> But if i should configure a static tcp/ip port for the named instance
> which
> one should i choose?Or what port is recommended.?
Any port not already in use?
--
Aaron Bertrand
SQL Server MVP|||Lol. That simple.Yup yup.
Thx. That answered my question.

Choose a named instance port(firewall).

Hi all,
i am installing a named instance in a DMZ.
Now i can choose for udp 1434 for the sqlbrowser srevice but the
Firwall/secutiry boys aren't happy about that.
So now i think i will configure it with a fixed tcp/ip port.
Wat port can i choose?
Eg. 1500 or 50000?
anyone?!
What port did you use?!
Thx!
Hello Hate_orphaned_users,

> Hi all,
> i am installing a named instance in a DMZ.
> Now i can choose for udp 1434 for the sqlbrowser srevice but the
> Firwall/secutiry boys aren't happy about that.
> So now i think i will configure it with a fixed tcp/ip port.
> Wat port can i choose?
> Eg. 1500 or 50000?
> anyone?!
> What port did you use?!
> Thx!
>
See:
http://support.microsoft.com/kb/287932
I'd just configure it to use TCP 1434. a different port is just security
by obscurity. Poeple who want in will be able to find the port regardless
of the fact that you changed the number. And if anyone comes knocking, SQL
will happily tell them what it actually is.
Jesse
|||Yes, i now.
But if i should configure a static tcp/ip port for the named instance which
one should i choose?Or what port is recommended.?
Cheers,
Harry
|||> But if i should configure a static tcp/ip port for the named instance
> which
> one should i choose?Or what port is recommended.?
Any port not already in use?
Aaron Bertrand
SQL Server MVP
|||Lol. That simple.Yup yup.
Thx. That answered my question.

Chinese charecterers not displaying in Query Analyser

Hello,
Could i get information on how chinese charecters can me made to display in
SQL QueryAnalyser.I have tried installing language packages.
Thanks in Advance
Sowmya
Message posted via http://www.sqlmonster.com
what is the collation of the columns and how are you loading your data?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Sowmya E via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:19ad95e28ba54de3aeb1cf0bc6dea269@.SQLMonster.c om...
> Hello,
> Could i get information on how chinese charecters can me made to display
in
> SQL QueryAnalyser.I have tried installing language packages.
> Thanks in Advance
> Sowmya
> --
> Message posted via http://www.sqlmonster.com
|||Sowmya,
What is the data type of the column where you are storing the Chinese
characters?
You might want to review the MSDN white paper "International Features in
Microsoft SQL Server 2000" at:
http://msdn.microsoft.com/library/de...Server2000.htm
and the following KB article may be helpful too:
239530 (Q239530) INF: Unicode String Constants in SQL Server Require N
Prefix
http://support.microsoft.com/default...b;en-us;239530
as both provide useful information when dealing with double-byte / Unicode
languages.
Hope that helps!
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Sowmya E via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:19ad95e28ba54de3aeb1cf0bc6dea269@.SQLMonster.c om...
> Hello,
> Could i get information on how chinese charecters can me made to display
in
> SQL QueryAnalyser.I have tried installing language packages.
> Thanks in Advance
> Sowmya
> --
> Message posted via http://www.sqlmonster.com