RE: Network Configuration...
anonymous_at_discussions.microsoft.com
Date: 01/16/04
- Next message: Dan Guzman: "Re: Database Ownership"
- Previous message: John: "Linked Server to Access DB - ERROR"
- In reply to: Kevin McDonnell [MSFT]: "RE: Network Configuration..."
- Next in thread: Kevin McDonnell [MSFT]: "RE: Network Configuration..."
- Reply: Kevin McDonnell [MSFT]: "RE: Network Configuration..."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Fri, 16 Jan 2004 05:36:41 -0800
Thank you!
>-----Original Message-----
>Question:
>Do you know if there is a way to
>change the port to the default port 1433? Do you see
any
>problems with doing this?
>
>Answer:
>You can use the Server Network Utility to change the
port. The only
>problem with doing this is that then you also would need
to modify each
>client to connect to the new port. All clients will by
default send
>traffic to 1433. If you change this, then each client
would need an alias
>created to reflect the change, or you would need to
modify the connection
>string. Ex.
>
>Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist
Security
>Info=False;User ID=myuser;Initial Catalog=Northwind;Data
>Source=MySQLServerName,4500;Network Library=DBMSSOCN
>
> (Where 4500 is the new port)
>
>Thanks,
>
>Kevin McDonnell
>Microsoft Corporation
>
>This posting is provided AS IS with no warranties, and
confers no rights.
>
>
>
>.
>
- Next message: Dan Guzman: "Re: Database Ownership"
- Previous message: John: "Linked Server to Access DB - ERROR"
- In reply to: Kevin McDonnell [MSFT]: "RE: Network Configuration..."
- Next in thread: Kevin McDonnell [MSFT]: "RE: Network Configuration..."
- Reply: Kevin McDonnell [MSFT]: "RE: Network Configuration..."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|