Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
RickL
Starting Member
2 Posts |
 Posted - 2007-12-21 : 14:14:26
|
| Hi,I've installed the Developer x64 Edition of SQL Server 2005 on my Windows XP Pro x64 box.Seems to work ok, but some questions:The good old SQL Server Service manager does noet "see" my 64 bit instances of SQL Server 2005. On a 32 bit install it will see the 32 bit instances ok. Same for the SQL Management Studio; it does not "see" the installed instances of SQL Server 2005 64 bit. So to connect to one of them I need to explicitly type this in the server list (it will connect ok after that...). I know that the client tools are 32 bit, even on a 64 bit install, but is this normal behaviour?When I go to the properties of my server on the memory tab I still cannot assign more than 2gb to the instance of sql server, while I have 8gb installed and both os and sql server are 64 bit. How can I assign more than 2gb as the maximum then?Thanks in advance,Rick |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-12-21 : 14:19:33
|
| The client tools should be 64-bit also, not 32-bit.Why not register your instance so you don't have to keep typing it in?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
RickL
Starting Member
2 Posts |
Posted - 2007-12-21 : 14:27:58
|
| Hi, you're right and I did register them, I was just wondering if this is normal bahaviour.But no, the client tools (or "component" they're called I think...) are 32 bit, only the engines are 64 bit. This is also mentioned on the microsoft site, so that was not a big shock....What IS a shock is that I still can't seem to assign more than 2gb to the server, even when running on a 64 bit OS. I'm assuming it's because it's Windows XP x64 and not a server OS, but on the other hand that sounds like non-sense; why else use an x64 OS..... (the sql server instance is registered as being 64 bit in the properties tab, so there's no mix-up there as well) |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-21 : 18:04:34
|
| How much memory does win xp see? |
|
|
|
|
|
|
|
|
64 Bit Developer Edtition on Windows XP x64