# Help setting up SQL Server and convert SDF file to it **URL:** \ **Category:** V4 Question\ **Created:** [January 25, 2015, 12:24am UTC](https://forum.sambapos.com/t/help-setting-up-sql-server-and-convert-sdf-file-to-it/3993 "2015-01-25T00:24:26Z")\ **Posts on this page:** 16\ **Page:** 2
**Author:** ![natascafe](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/n/74df32/32.png) [@natascafe](https://forum.sambapos.com/u/natascafe)\ **Post date:** [January 25, 2015, 4:41pm UTC](https://forum.sambapos.com/t/help-setting-up-sql-server-and-convert-sdf-file-to-it/3993/21 "2015-01-25T16:41:51Z")
I wish I was more technically inclined. When I follow the second half of the tutorial and right click on Data Connections in Compact Toolbox the option to select 'Add SQL Server Compact 3.5 Connection is not available for me to select…its there but I cant select it ---
**Author:** ![natascafe](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/n/74df32/32.png) [@natascafe](https://forum.sambapos.com/u/natascafe)\ **Post date:** [January 25, 2015, 6:57pm UTC](https://forum.sambapos.com/t/help-setting-up-sql-server-and-convert-sdf-file-to-it/3993/22 "2015-01-25T18:57:59Z")
I used compact toolbox for runtime 4.0 it allowed me to browse but when I test the connection it gives me an error ---
**Author:** ![natascafe](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/n/74df32/32.png) [@natascafe](https://forum.sambapos.com/u/natascafe)\ **Post date:** [January 25, 2015, 7:09pm UTC](https://forum.sambapos.com/t/help-setting-up-sql-server-and-convert-sdf-file-to-it/3993/23 "2015-01-25T19:09:50Z")
![](https://forum.sambapos.com/uploads/default/original/3X/8/0/80b0bc996802a71e287f781de8c549e299886480.png) ---
**Author:** ![natascafe](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/n/74df32/32.png) [@natascafe](https://forum.sambapos.com/u/natascafe)\ **Post date:** [January 25, 2015, 7:31pm UTC](https://forum.sambapos.com/t/help-setting-up-sql-server-and-convert-sdf-file-to-it/3993/24 "2015-01-25T19:31:02Z")
the good thing is I don’t like to sit idle so while waiting I figured out the problem haha…disregard previous issues as I seem to be getting through them ---
**Author:** ![natascafe](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/n/74df32/32.png) [@natascafe](https://forum.sambapos.com/u/natascafe)\ **Post date:** [January 25, 2015, 7:55pm UTC](https://forum.sambapos.com/t/help-setting-up-sql-server-and-convert-sdf-file-to-it/3993/25 "2015-01-25T19:55:41Z")
ok…unable to perform the last step… Open SQL Management Studio. Create new Database, Create new Query, Copy & Paste everything that file contains inside Query editing window and execute Query. That will create tables and data. What do I do to initiate "create new database’? ---
**Author:** ![QMcKay](https://forum.sambapos.com/user_avatar/forum.sambapos.com/qmckay/32/27925_2.png) [@QMcKay](https://forum.sambapos.com/u/QMcKay)\ **Post date:** [January 25, 2015, 8:00pm UTC](https://forum.sambapos.com/t/help-setting-up-sql-server-and-convert-sdf-file-to-it/3993/26 "2015-01-25T20:00:07Z")
Right-click **Databases** folder then click **`New Database...`** ![](https://forum.sambapos.com/uploads/default/original/3X/e/d/ed08f1e153ef67284b5d5f2a632305a9047bd519.png) ---
**Author:** ![natascafe](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/n/74df32/32.png) [@natascafe](https://forum.sambapos.com/u/natascafe)\ **Post date:** [January 25, 2015, 8:08pm UTC](https://forum.sambapos.com/t/help-setting-up-sql-server-and-convert-sdf-file-to-it/3993/27 "2015-01-25T20:08:26Z")
Database name? and then? ---
**Author:** ![QMcKay](https://forum.sambapos.com/user_avatar/forum.sambapos.com/qmckay/32/27925_2.png) [@QMcKay](https://forum.sambapos.com/u/QMcKay)\ **Post date:** [January 25, 2015, 8:13pm UTC](https://forum.sambapos.com/t/help-setting-up-sql-server-and-convert-sdf-file-to-it/3993/28 "2015-01-25T20:13:31Z")
Type in a name for the DB and click Ok… ![](https://forum.sambapos.com/uploads/default/original/3X/1/2/12c725b547c06c040cc6bd823d67b69147a9a9dc.png) ---
**Author:** ![natascafe](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/n/74df32/32.png) [@natascafe](https://forum.sambapos.com/u/natascafe)\ **Post date:** [January 25, 2015, 8:17pm UTC](https://forum.sambapos.com/t/help-setting-up-sql-server-and-convert-sdf-file-to-it/3993/29 "2015-01-25T20:17:41Z")
Gives me an error indicating that database already exists…is there somewhere I’m supposed to paste the script? ---
**Author:** ![QMcKay](https://forum.sambapos.com/user_avatar/forum.sambapos.com/qmckay/32/27925_2.png) [@QMcKay](https://forum.sambapos.com/u/QMcKay)\ **Post date:** [January 25, 2015, 8:31pm UTC](https://forum.sambapos.com/t/help-setting-up-sql-server-and-convert-sdf-file-to-it/3993/30 "2015-01-25T20:31:02Z")
Click **`New Query`** Paste script in window Click **`Execute`** ![](https://forum.sambapos.com/uploads/default/original/3X/c/8/c8272603cc8e7e3d6c919822656c73a320b2b8cc.png) ---
**Author:** ![natascafe](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/n/74df32/32.png) [@natascafe](https://forum.sambapos.com/u/natascafe)\ **Post date:** [January 25, 2015, 8:42pm UTC](https://forum.sambapos.com/t/help-setting-up-sql-server-and-convert-sdf-file-to-it/3993/31 "2015-01-25T20:42:17Z")
ok… THANKS!! I changed the Database in property editor for local settings to SambaPOS4…that seems to be working now. Do I need to have SQL Server Management running all the time now? Or can I just have Samba running on its own? ---
**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\ **Post date:** [January 25, 2015, 8:42pm UTC](https://forum.sambapos.com/t/help-setting-up-sql-server-and-convert-sdf-file-to-it/3993/32 "2015-01-25T20:42:48Z")
sql server management is just a tool the server runs in background as a windows service. ---
**Author:** ![QMcKay](https://forum.sambapos.com/user_avatar/forum.sambapos.com/qmckay/32/27925_2.png) [@QMcKay](https://forum.sambapos.com/u/QMcKay)\ **Post date:** [January 25, 2015, 8:44pm UTC](https://forum.sambapos.com/t/help-setting-up-sql-server-and-convert-sdf-file-to-it/3993/33 "2015-01-25T20:44:43Z")
SSMS is just a tool to manage databases. > [@natascafe](#): > > Do I need to have SQL Server Management running all the time now? No. > [@natascafe](#): > > Or can I just have Samba running on its own? Yes. ---
**Author:** ![natascafe](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/n/74df32/32.png) [@natascafe](https://forum.sambapos.com/u/natascafe)\ **Post date:** [January 25, 2015, 8:47pm UTC](https://forum.sambapos.com/t/help-setting-up-sql-server-and-convert-sdf-file-to-it/3993/34 "2015-01-25T20:47:23Z")
Ok… This is all on a tablet I will be using in my café. For backup and fine tuning am I able to create the same image of samba on a laptop using Database backup to a thumb drive ---
**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\ **Post date:** [January 25, 2015, 8:56pm UTC](https://forum.sambapos.com/t/help-setting-up-sql-server-and-convert-sdf-file-to-it/3993/35 "2015-01-25T20:56:42Z")
yes the database can be backed up and installed on another computer. You can use the same management tool. ---
**Author:** ![natascafe](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/n/74df32/32.png) [@natascafe](https://forum.sambapos.com/u/natascafe)\ **Post date:** [January 25, 2015, 9:03pm UTC](https://forum.sambapos.com/t/help-setting-up-sql-server-and-convert-sdf-file-to-it/3993/36 "2015-01-25T21:03:36Z")
OK… Thanks to you and kendash for all your help [Previous page](https://forum.sambapos.com/t/help-setting-up-sql-server-and-convert-sdf-file-to-it/3993.md?page=1)