Database access by machines running SQL Servers 2005 32-bit and 64-bit

Hello

We have 1 machine running SQL Server 2005 x64 (64 bit). The other machine is backing this SQL Server up. It is a 32-bit machine, so it requires (?) a 32-bit version of SQL Server 2005.

Would this back-up machine work correctly on a database previously managed by a 64-bit machine and vice versa.

Thank you!

Yes, in terms of connection and administration you won′t feel any difference. But you only can install 32bit software on a 32bit system.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

If my DEV box is 32 bit and my PROD box is 64 bit:

can I deploy (or migrate) from DEV to PROD. The DEV box would have the 32bit SQL Server and the PROD would have the 64 bit SQL server. But if I deploy what I wrote and created there on 32 bit will it run on the 64 bit?

CLR stored procedures?|||No, the things that were developed on the DEv machine can be deployed without any problem on the production machine as from your description. On the Prod system the 64bit framework will take care of the assemblies.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Database Access (client) to Specific machines in LAN network.

Hi ,
We have a LAN set up in our company . I want that some specific local
machine's IP addresses to have access the live database server.
Want to restict machine's IP address from connecting to the live database
. How can I go for this ? I donot have that much idea about firewall and
router stuff . pls send me the link also which will help me in doing this.
I do have complex password for SA and have created a different login /role
and users for specific rights .But still want to do the above thing to make
the database more secured.
Pls help me in this.
Regards,
Swatiusing ipsec u can achive this. It is a filter. u can allow and disallow i.ps
.
"swati" wrote:

> Hi ,
> We have a LAN set up in our company . I want that some specific local
> machine's IP addresses to have access the live database server.
> Want to restict machine's IP address from connecting to the live databas
e
> .. How can I go for this ? I donot have that much idea about firewall and
> router stuff . pls send me the link also which will help me in doing this.
> I do have complex password for SA and have created a different login /role
> and users for specific rights .But still want to do the above thing to mak
e
> the database more secured.
> Pls help me in this.
> Regards,
> Swati
>
>
>
>|||Hi Suresh ,
Canyou pls throw some light on how to use the ipsec ? I am totally new in
this area . Waiting for your reply
Thanks & Regards,
Swati
"suresh" <suresh@.discussions.microsoft.com> wrote in message
news:35ED9BA4-EC43-4350-9CBE-81141FC72466@.microsoft.com...
> using ipsec u can achive this. It is a filter. u can allow and disallow
i.ps.[vbcol=seagreen]
>
> "swati" wrote:
>
database[vbcol=seagreen]
and[vbcol=seagreen]
this.[vbcol=seagreen]
/role[vbcol=seagreen]
make[vbcol=seagreen]|||http://www.microsoft.com/technet/it...ty/ipsecld.mspx
Using IPSec to Lock Down a Server
is a good start
Cheers
Ken
"swati" <swati.zingade@.ugamsolutions.com> wrote in message
news:O3U6tii7EHA.2608@.TK2MSFTNGP10.phx.gbl...
> Hi Suresh ,
> Canyou pls throw some light on how to use the ipsec ? I am totally new in
> this area . Waiting for your reply
> Thanks & Regards,
> Swati
>
> "suresh" <suresh@.discussions.microsoft.com> wrote in message
> news:35ED9BA4-EC43-4350-9CBE-81141FC72466@.microsoft.com...
> i.ps.
> database
> and
> this.
> /role
> make
>