question

staffan avatar image
staffan asked

SQL Server 2005 and 2008

Can I use 2005 express and 2008 on same computer with XP

sql-server-2008t-sqlsql-server-express
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Tom Staab avatar image
Tom Staab answered

Yes, you can. No, I don't recommend installing either (let alone both) on a Windows XP machine except for development, basic testing or use within a very small organization. For development and testing, you can use SQL Server Developer Edition.

Not only is Windows XP intended as a client operating system rather than for servers, but (or rather because of that) it has limits on the number of incoming connections allowed. You can read this article (KB314882) for more information, but here are the important parts:

Note For Windows XP Professional, the maximum number of other computers that are permitted to simultaneously connect over the network is ten. This limit includes all transports and resource sharing protocols combined. For Windows XP Home Edition, the maximum number of other computers that are permitted to simultaneously connect over the network is five. This limit is the number of simultaneous sessions from other computers the system is permitted to host. This limit does not apply to the use of administrative tools that attach from a remote computer.

Per development: The connection limit refers to the number of redirector-based connections and is enforced for any file, print, named pipe, or mail slot session. The TCP connection limit is not enforced, but it may be bound by legal agreement to not permit more than 10 clients.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Matt Whitfield avatar image
Matt Whitfield answered

Yes. Not sure what more I can say.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image
Grant Fritchey answered

Yes, absolutely. Outside of a sandbox or development machine, should you? Nope.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.