sql server msde: The client ports are actually defined by the connection string the
client uses to connect=B4. Using SQl Server Express you should not care
about this if SQL Server browser is started and the instances uses
dynamic ports. if you are using MSDE, check the connectionstring of
your client without any port association it will use the 1433 standard
port. If you want to use another you will have to do that with the
syntax as follows:

Servername,portnumber

HTH, Jens K. Suessmeyer.

---
http://www.sqlserver2005.de
---

I am installing MSDE on a system and am using the free tool dba Mgr to
administer a few things. There's a server network utility where I can change
the port # just as with MS SQL server network utility. However, I need to
change the clients also. Since I'm not installing client tools from an MS
SQL installatoin disc I don't have the client network utility. How is this
to be done?

Thanks,

Keith

Ok I just tried that on my development system (running SQL 2k Dev) and it
can't find the server. My connection string is:

Provider=SQLOLEDB.1;Password=xxxxxx;Persist Security Info=True;User
ID=sa;Initial Catalog=TestDB;;Data Source=MyServer,1654

The above works perfectly fine without the port number tacked onto the end.
Now I do have the port set usign the client network utility. Does that make
a difference?

keith

[quoted text, click to view]
The client ports are actually defined by the connection string the
client uses to connect´. Using SQl Server Express you should not care
about this if SQL Server browser is started and the instances uses
dynamic ports. if you are using MSDE, check the connectionstring of
your client without any port association it will use the 1433 standard
port. If you want to use another you will have to do that with the
syntax as follows:

Servername,portnumber

HTH, Jens K. Suessmeyer.

---
http://www.sqlserver2005.de
---

Do you use an alias for the server ? That might have already defined to
portnumber for the server within. You will only have to define that
once then, not in both places the client utility AND the connection
string.

HTH, Jens K. Suessmeyer.

---
http://www.sqlserver2005.de
---