How to connect?

Hi All,
I'd like to connect to a SQL Server 2000 instance which listens to not the
default 1433 port. Can anyone help me with how to register the server in EM
and how to connect to the server with QA?
Thanks.
Kolos
Hello,
1 option:- Create a client Alias using Client Network Utility defining the
correct PORT and then use the Alias to register and use in Query Analyzer
2 option: While connecting give IPADDRESS,Port number in the server window.
(Eg: 10.222.1.100,1522)
Thanks
Hari
"Kolos" <Kolos@.discussions.microsoft.com> wrote in message
news:0AE8AA45-09F8-43F3-9CE7-ADCD224DB393@.microsoft.com...
> Hi All,
> I'd like to connect to a SQL Server 2000 instance which listens to not the
> default 1433 port. Can anyone help me with how to register the server in
> EM
> and how to connect to the server with QA?
> Thanks.
> Kolos

How to connect?

Hi All,
I'd like to connect to a SQL Server 2000 instance which listens to not the
default 1433 port. Can anyone help me with how to register the server in EM
and how to connect to the server with QA?
Thanks.
KolosHello,
1 option:- Create a client Alias using Client Network Utility defining the
correct PORT and then use the Alias to register and use in Query Analyzer
2 option: While connecting give IPADDRESS,Port number in the server window.
(Eg: 10.222.1.100,1522)
Thanks
Hari
"Kolos" <Kolos@.discussions.microsoft.com> wrote in message
news:0AE8AA45-09F8-43F3-9CE7-ADCD224DB393@.microsoft.com...
> Hi All,
> I'd like to connect to a SQL Server 2000 instance which listens to not the
> default 1433 port. Can anyone help me with how to register the server in
> EM
> and how to connect to the server with QA?
> Thanks.
> Kolos

How to configure udp port in sql ?

Hi friends,
I want to open/publish my sql server 2000 into internet,
for security reason, many articles said that I must close
TCP port 1433 and UDP 1434.
My questions are :
I can change TCP port with others port, how can I change
udp port ?
Thanks.You can't , however if you just have a default instance, it won't make any
difference to block it. If using named instances then you would have to
supply the port when connecting or use an alias set up in the client network
utility (on the client attempting to connect)
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Kresna Rudy Kurniawan" <anonymous@.discussions.microsoft.com> wrote in
message news:071701c3bdfa$abdd8140$a101280a@.phx.gbl...

quote:

---

> Hi friends,
> I want to open/publish my sql server 2000 into internet,
> for security reason, many articles said that I must close
> TCP port 1433 and UDP 1434.
> My questions are :
> I can change TCP port with others port, how can I change
> udp port ?
> Thanks.

---

|||You don't want to open UDP 1434. If the server is behind ISA, set the
server to use a Fixed port. The clients will have to know the port in
order to connect.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Also, you can't change the UDP port. It is fixed at UDP 1434. You should
only use this for domain level applications to enumerate what ports SQL
Named Instances are listening on. The server listen-on port can be changed
using the Server Network Utility.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

how to configure TCP port for unattended install

I've looked through every source of material on SQL Server Express unattended installs that I could get my hands on, but so far, I've come up with nothing that shows how to set the server engine's TCP port to 1433.

Since the SQL Server setup is part of a (considerably) larger install, requiring the customer to set this by hand is not really acceptable.

Is there a way to do this with a command-line parameter (etc)?

Thanks in advance

Josh

i assume you mean to set the port to not 1433 as this is the default behavior|||

No, I meant exactly what I said.

For SQL Server 2005 Express Edition, static port 1433 is *not* the default. Its default is to use port numbers randomly assigned at run-time.

Josh

|||my bad dude, forgot express has that behavior :)|||

Sorry for not getting here sooner, there is no way to configure the TCP port during installation that is built in. You should be able to write a script that does it, and that script can be called once SQL Express has been installed.

Check out the options available in SMO or the WMI providers, I believe either will give you the ability to configure this.

Regards,

Mike Wachal
SQL Express team

|||I am a newbe and do not know what "SMO" or "VMI" providers are. You eluded to a "Script" that can set the IP port for SQL Express. Any chance I can get a url or exanmple of this "script"?

how to configure TCP port for unattended install

I've looked through every source of material on SQL Server Express unattended installs that I could get my hands on, but so far, I've come up with nothing that shows how to set the server engine's TCP port to 1433.

Since the SQL Server setup is part of a (considerably) larger install, requiring the customer to set this by hand is not really acceptable.

Is there a way to do this with a command-line parameter (etc)?

Thanks in advance

Josh

i assume you mean to set the port to not 1433 as this is the default behavior|||

No, I meant exactly what I said.

For SQL Server 2005 Express Edition, static port 1433 is *not* the default. Its default is to use port numbers randomly assigned at run-time.

Josh

|||my bad dude, forgot express has that behavior :)|||

Sorry for not getting here sooner, there is no way to configure the TCP port during installation that is built in. You should be able to write a script that does it, and that script can be called once SQL Express has been installed.

Check out the options available in SMO or the WMI providers, I believe either will give you the ability to configure this.

Regards,

Mike Wachal
SQL Express team

|||I am a newbe and do not know what "SMO" or "VMI" providers are. You eluded to a "Script" that can set the IP port for SQL Express. Any chance I can get a url or exanmple of this "script"?

how to configure TCP port for unattended install

I've looked through every source of material on SQL Server Express unattended installs that I could get my hands on, but so far, I've come up with nothing that shows how to set the server engine's TCP port to 1433.

Since the SQL Server setup is part of a (considerably) larger install, requiring the customer to set this by hand is not really acceptable.

Is there a way to do this with a command-line parameter (etc)?

Thanks in advance

Josh

i assume you mean to set the port to not 1433 as this is the default behavior|||

No, I meant exactly what I said.

For SQL Server 2005 Express Edition, static port 1433 is *not* the default. Its default is to use port numbers randomly assigned at run-time.

Josh

|||my bad dude, forgot express has that behavior :)|||

Sorry for not getting here sooner, there is no way to configure the TCP port during installation that is built in. You should be able to write a script that does it, and that script can be called once SQL Express has been installed.

Check out the options available in SMO or the WMI providers, I believe either will give you the ability to configure this.

Regards,

Mike Wachal
SQL Express team

|||I am a newbe and do not know what "SMO" or "VMI" providers are. You eluded to a "Script" that can set the IP port for SQL Express. Any chance I can get a url or exanmple of this "script"?

How to config a linked server from SQL to DB2

I have a DB2 database 7.2.
(
Server Host Name = SVR1,
Database name = PROD,
schema name = db2admin,
Port number = 50000)
How can I config a linked server to this DB2 database from
SQL. I check the doc find the sample like this:
EXEC sp_addlinkedserver
@.server='DB2',
@.srvproduct='Microsoft OLE DB Provider for DB2',
@.catalog='DB2',
@.provider='DB2OLEDB',
@.provstr='Initial Catalog=PUBS;Data
Source=DB2;HostCCSID=1252;Network Address=XYZ;Network
Port=50000;Package Collection=admin;Default Schema=admin;'
I have a little bit confuse with the connect string
@.provstr, anybody can tell me how to mapping my DB2
information to this @.provstr?
I try this wouldn't work
@.provstr='Initial
Catalog=PROD;DataSource=DB2;HostCCSID=1252;Network
Address=SVR1;Network Port=50000;Package
Collection=db2admin;Default Schema=db2admin;'
I got error message: Error 7403: Could not locate registry
entry for OLE DB provider 'DB2OLEDB' OLE DB error trace
[Non-interface error: Provider not registered]
Thanks,
HGDo u have DB2 client installed in your machine,
Thanks
Hari
MCDBA
"HG" <Hansen.gu@.aegoncanada.ca> wrote in message
news:008401c3ae0b$069335d0$a101280a@.phx.gbl...
> I have a DB2 database 7.2.
>
> Server Host Name = SVR1,
> Database name = PROD,
> schema name = db2admin,
> Port number = 50000)
> How can I config a linked server to this DB2 database from
> SQL. I check the doc find the sample like this:
> EXEC sp_addlinkedserver
> @.server='DB2',
> @.srvproduct='Microsoft OLE DB Provider for DB2',
> @.catalog='DB2',
> @.provider='DB2OLEDB',
> @.provstr='Initial Catalog=PUBS;Data
> Source=DB2;HostCCSID=1252;Network Address=XYZ;Network
> Port=50000;Package Collection=admin;Default Schema=admin;'
>
> I have a little bit confuse with the connect string
> @.provstr, anybody can tell me how to mapping my DB2
> information to this @.provstr?
> I try this wouldn't work
> @.provstr='Initial
> Catalog=PROD;DataSource=DB2;HostCCSID=1252;Network
> Address=SVR1;Network Port=50000;Package
> Collection=db2admin;Default Schema=db2admin;'
> I got error message: Error 7403: Could not locate registry
> entry for OLE DB provider 'DB2OLEDB' OLE DB error trace
> [Non-interface error: Provider not registered]
> Thanks,
> HG|||Yes, I do have DB2 client installed locally.
>--Original Message--
>Do u have DB2 client installed in your machine,
>Thanks
>Hari
>MCDBA
>"HG" <Hansen.gu@.aegoncanada.ca> wrote in message
>news:008401c3ae0b$069335d0$a101280a@.phx.gbl...
>> I have a DB2 database 7.2.
>> Server Host Name = SVR1,
>> Database name = PROD,
>> schema name = db2admin,
>> Port number = 50000)
>> How can I config a linked server to this DB2 database
from
>> SQL. I check the doc find the sample like this:
>> EXEC sp_addlinkedserver
>> @.server='DB2',
>> @.srvproduct='Microsoft OLE DB Provider for DB2',
>> @.catalog='DB2',
>> @.provider='DB2OLEDB',
>> @.provstr='Initial Catalog=PUBS;Data
>> Source=DB2;HostCCSID=1252;Network Address=XYZ;Network
>> Port=50000;Package Collection=admin;Default
Schema=admin;'
>>
>> I have a little bit confuse with the connect string
>> @.provstr, anybody can tell me how to mapping my DB2
>> information to this @.provstr?
>> I try this wouldn't work
>> @.provstr='Initial
>> Catalog=PROD;DataSource=DB2;HostCCSID=1252;Network
>> Address=SVR1;Network Port=50000;Package
>> Collection=db2admin;Default Schema=db2admin;'
>> I got error message: Error 7403: Could not locate
registry
>> entry for OLE DB provider 'DB2OLEDB' OLE DB error trace
>> [Non-interface error: Provider not registered]
>> Thanks,
>> HG
>
>.
>

How to check which port that SQL Server currently using?

Hi, I'm trying to connect to MS SQL server using PHP Pear DB package. I
have 2 SQL server running on different machine. 1 is using SQL Server
2000 Standard Edition and the other is SQL server from .NET SDK.
I can connect to the standard edition but not to SQL Server from .net
SDK. Did they use different port? if it is, what is default port for SQL
server from .net sdk? or how to check which port did my sql server is
using right now.
thanks
To view or even specify the port an instance is usin use Server Network
Utility -
http://msdn.microsoft.com/library/de...rver_2epl.asp.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"ricard" <ricard_notrealmail@.example.com> wrote in message
news:uv3x7rhlEHA.2340@.TK2MSFTNGP11.phx.gbl...
> Hi, I'm trying to connect to MS SQL server using PHP Pear DB package. I
> have 2 SQL server running on different machine. 1 is using SQL Server
> 2000 Standard Edition and the other is SQL server from .NET SDK.
> I can connect to the standard edition but not to SQL Server from .net
> SDK. Did they use different port? if it is, what is default port for SQL
> server from .net sdk? or how to check which port did my sql server is
> using right now.
> thanks