Wednesday, March 28, 2012

installing MS SQL on server with sybase ASA

I'm getting ready to install MS SQL 2005 Enterprise Ed. on a Windows 2003
server. This server already has Sybase Adaptive Server Anywhere Version 9
installed with few db running. Do you think there would be any
problems/conflicts if I install MS SQL on this machine?
My other question is what ports does MS SQL uses to connect to db?
Here are the specifications of the server:
Dell PowerEdge 2850
Dual Xeon 2.8 GHz
2 GB RAM
Thanks.Answer for your second question:
If your SQL Server is a default instance, then it'd use only static ports
(1433 by default). If it's a named instance, then it'd use dynamic ports (by
default) however you can set the ports as static after installation. UDP
1434 port is used to let clients know what the dynamic port is.
You can find more info about this from the following KB:
http://support.microsoft.com/kb/823938
--
Ekrem Ã?nsoy
"matsui" <u40159@.uwe> wrote in message news:7d44c706d1cfe@.uwe...
> I'm getting ready to install MS SQL 2005 Enterprise Ed. on a Windows 2003
> server. This server already has Sybase Adaptive Server Anywhere Version 9
> installed with few db running. Do you think there would be any
> problems/conflicts if I install MS SQL on this machine?
> My other question is what ports does MS SQL uses to connect to db?
> Here are the specifications of the server:
> Dell PowerEdge 2850
> Dual Xeon 2.8 GHz
> 2 GB RAM
> Thanks.
>|||Thankyou.
Ekrem Ã?nsoy wrote:
>Answer for your second question:
>If your SQL Server is a default instance, then it'd use only static ports
>(1433 by default). If it's a named instance, then it'd use dynamic ports (by
>default) however you can set the ports as static after installation. UDP
>1434 port is used to let clients know what the dynamic port is.
>You can find more info about this from the following KB:
>http://support.microsoft.com/kb/823938
>> I'm getting ready to install MS SQL 2005 Enterprise Ed. on a Windows 2003
>> server. This server already has Sybase Adaptive Server Anywhere Version 9
>[quoted text clipped - 9 lines]
>> Thanks.
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200712/1sql

No comments:

Post a Comment