Client Tools and express

Hi ,

I have installed the SQL 2005 Client tools in anticipation of our servers been upgraded to SQL 2005 soon. I would like to create a local instance of SQL 2005 i.e. Express so I can try out functionality while I wait for the servers to be upgraded.

Is this possible or is now installing Express going to mess up some of the currently installed tools?

Help appreciated.

No, this is sure possible.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Client alias on 64bit server

We have just upgraded a 32bit server to 64bit Windows 2003, we had client
alias working correctly before when os was 32bit but now we have gone to
64bit i can't get any aliases to work.
I've tried configuring exactly the same alias on a 32bit machine and that
works but if the server is 64bit then no joy, even if try to create an alias
to the local 64but machine.
Any help would be gratefully appreciated.
Same problem here with XP 64. I've tried both 2000 and 2005 with the same
problem. It simply ignores the port and goes for 1433. Oddly enough, ODBC
worked (setting the port on the second screen).
"Adam Shepherd" <Adam Shepherd@.discussions.microsoft.com> wrote in message
news:95F13D92-FBC9-4FD9-8C0B-AB4D3EF8370F@.microsoft.com...
> We have just upgraded a 32bit server to 64bit Windows 2003, we had client
> alias working correctly before when os was 32bit but now we have gone to
> 64bit i can't get any aliases to work.
> I've tried configuring exactly the same alias on a 32bit machine and that
> works but if the server is 64bit then no joy, even if try to create an
> alias
> to the local 64but machine.
> Any help would be gratefully appreciated.
|||I've done a bit of playing around and i think what's happening is that the
alias is being written to the 32bit registry but sql server is trying to read
from the 64bit registry. If i create an entry in the 64bit registry then
alias works ok. The registry keys are:
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\ MSSQLServer\Client\ConnectTo
and:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ Client\ConnectTo
Looks like an issue with SQL Server, but if the key is in boht locations
then aliases work.
hope that helps,
Adam
"Scott Wallace" wrote:

> Same problem here with XP 64. I've tried both 2000 and 2005 with the same
> problem. It simply ignores the port and goes for 1433. Oddly enough, ODBC
> worked (setting the port on the second screen).
>
> "Adam Shepherd" <Adam Shepherd@.discussions.microsoft.com> wrote in message
> news:95F13D92-FBC9-4FD9-8C0B-AB4D3EF8370F@.microsoft.com...
>
>