Friday, March 30, 2012

MS SQL Standaolne

Hi,

i'm doing a project now in office , my question is how can I set up a MS SQL without connecting to our company server. Just making my pc a client/server Standalone

Mae

Just install the appropiate components on your machine. Depending on which version you are using SQL 2k /2k5 and Windows version you have the choice of using the edition you want and where you have licenses for. Which OS and edition of SQL Server do you have ?

HTH, Jens K. Suessmeyer.

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

Hi Mae:

How do you normally connect to your company's server?

There are numerous way to connect to a database, but to speaking in general, you can:

1. create a backup database from your company's db server.

2. Install MS SQL server to your machine, or any other machine that you want to use as test machine.

3. Restore the backup database from #1 to machine in #2.

Now you have a replicate of your company's database that you can connect to to test your project on.

Hope this helps.

Thanks.

sql

No comments:

Post a Comment