Wednesday, September 15, 2010

Creating your SQL Server Database

 

If you are an AccuSQL user, your first step after installing the software is to either create a new AccuSQL database in your Microsoft SQL Server or transfer an existing AccuTrack database to the SQL Server.  Either way, the procedure is the same with the only difference is that with the former you would transfer a blank AccuTrack database instead of one with your data.

The following are the steps to transfer an AccuTrack database to MSSQL Server using AccuSQL. These steps assume that:

1. You already setup MS SQL Server 2005/2008 (standard, enterprise, or Express) with TCP and/or Named Pipes and you allow for remote connections to this server.

2. You have an "sa" or equivalent account that you can use for the data transfer process (you can use the preferred Windows Authentication as well).

3. You have the SQL Server 2005 OLE DB Provider installed (check tips section for more information).

Database Creation Steps

1) Launch AccuSQL and log in as a root administrator.

2) In the bottom left area of AccuSQL, click on the Expanded View radio button.

3) Click the Database --> Transfer database to SQL server option.

4) In the Native data path to transfer area, click the Select Path button.

5) In the Data Folder Path pop-up screen, navigate to the database you would like to transfer and press OK. NOTE: You can either transfer an existing AccuTrack version 7,8, 9, 10 or 11 database or you can transfer a blank database (e.g. C:\Program Files\AccuSQL11\AccuData).

6) In the SQL server connection info area, enter the SQL Server name and authentication mode (Windows Authentication or SQL server authentication with username and password). NOTE: The account needs to have ‘Create’ and ‘Alter’ permissions. Preferably use windows authentication. If you are using SQL Server Authentication then built-in “sa” account is the preferred account (in SQL Express installations please note that “sa” account is disabled by default, you may need to enable it).

7) In the Database field, type the name for the database you are creating. The Owner field is optional, but typically would be dbo.

8) Now press the Test Connection button. If all is well, you will get a "Test connection succeeded" message. If not, you will get an error message. Verify all the information is correct and retest until you get a success message.

9) Optionally check the “Create a public account for this database” and fill in public account username and password. The privileged account would be used during creating and transferring the database while the limited public account would be used to access data during daily operations of the software.

10) Press the Transfer Data button. You will get a "Transferring data to SQL Server" message and AccuSQL will initiate the database creation in SQL Server. Depending on your existing version, AccuSQL may first initiate a data conversion routine and then do the transferring to SQL server. In that case, AccuSQL does its work in a temporary location that it creates and doesn’t directly modify the data in the location you pointed to – in other words your data is left intact even if something goes wrong during conversion and transfer.

11) After the process completes, press Close Form in the Transfer database to SQL Server window.

12) You can transfer as many databases as you want but each database should have new unique name. Transfer operation doesn’t support transferring into an already existing database.

Congratulations, you have finished creating the AccuSQL database in the SQL Server!

Next you need to point AccuSQL installations to use the SQL Server database.  We will start with the installation you just used to create the AccuSQL database.

Setting AccuSQL to Use the MS SQL Database

1. Access the Database --> Database Location screen and click the SQL Server radio button and then click the Next button.

2. In the Application Share Path area specify a shared network folder that everyone have full access rights (Full control, read, write, modify). AccuSQL will use this path to create shared folders that all AccuSQL installations sharing the same database needs.  For example, if you set up the software with student or tutor photos, AccuSQL will save a copy of the photos there. 

NOTE: Each AccuSQL database you create in your MS SQL Server needs its own Share Path Area.  However, you can put all shared path folders on the same server.  For example:

  • Center 1 Application Shared path: Y:\SharedFiles\AccuSQL_Shared\Center1
  • Center 2 Application Shared path: Y:\SharedFiles\AccuSQL_Shared\Center2
  • Center 3 Application Shared path: Y:\SharedFiles\AccuSQL_Shared\Center3

3. In the SQL server connection info area, enter your server’s name, authentication mode (Windows authentication is preferred but SQL server authentication needs less expertise), and if authentication is SQL server mode your username and password – limited account’s username and password if you opted to create it.

4. In the Database drop-down menu, select the database you created during transfer. Tip: After entering server, username, password information click on Database drop down’s ‘down arrow’. If it comes up with a list populated with your database in it then it verifies that you have a valid connection.

5. Now press the Test Connection button. If all is well, you will get a "Test connection succeeded" message. If not, you will get an error message. Verify all the information is correct and retest until you get a success message.

6. Press the Save button and then press Close Form.

7. Now press the main “Exit AccuSQL” button to shutdown the application.

8. When you relaunch AccuSQL, you will be connected to the SQL Server database. Congratulations!

Troubleshooting Tips

If you are sure you have the correct credentials but are having trouble with the transfer, there are a few things you should check.

  • You may need to install the SQL Server native connectivity client. To do so, double-click the sqlncli.msi (or sqlncli64.msi if your OS is 64 bits) installer in the <ROOT>\program files\Accu11Sql\ directory of your installation CD (the exact location on CD might be different due to rearranging the distribution files after writing of this document). You can use the default installation options.
  • Make sure you have SQL Server correctly setup with TCP and Named Pipes and that you allow for remote connections. You can access the ConfiguringAccuTrackSQL.doc document in the <ROOT>\program files\Accu10Sql\Manuals directory of your installation CD for detailed information. Also for troubleshooting the connection you may refer to this information from Microsoft:

        http://support.microsoft.com/kb/914277

  • You may have an outdated native file set. These files are created automatically when AccuSQL is first opened. To recreate the native files, exit AccuSQL then in Windows Explorer, navigate to the C:\Documents and Settings\All Users\Documents\accutrack directory and delete any files and/or directories located under it. Typically the temp directories start with an "i3" folder name. After deleting, restart AccuSQL and the temp files will be regenerated and you can proceed with the transfer steps above.
  • Finally, if you still are having trouble, just contact AccuSQL support and they will be happy to assist.

clip_image002

30 comments:

  1. Share great information about your blog , Blog really helpful for us . We read your blog , share most useful information in blog . Thanks for share your blog here .
    Exchange Standard CAL

    ReplyDelete
  2. An easily understood input screen goes a long way to explaining what data needs to be entered.create dashboard for oracle

    ReplyDelete
  3. Awesome article. I enjoyed reading your articles. this can be really a good scan for me. wanting forward to reading new articles. maintain the nice work!
    Data Science Courses in Bangalore

    ReplyDelete
  4. What an incredible message this is. Truly one of the best posts I have ever seen in my life. Wow, keep it up.
    AI Courses in Bangalore

    ReplyDelete
  5. Excellent Blog! I would like to thank you for the efforts you have made in writing this post. Gained lots of knowledge.
    Data Analytics Course

    ReplyDelete
  6. I am sure it will help many people. Keep up the good work. It's very compelling and I enjoyed browsing the entire blog.
    Business Analytics Course in Bangalore

    ReplyDelete
  7. This is an informative and knowledgeable article. therefore, I would like to thank you for your effort in writing this article.
    Best Digital Marketing Courses in Bangalore

    ReplyDelete
  8. A good blog always contains new and exciting information and as I read it I felt that this blog really has all of these qualities that make a blog.
    Data Science Institutes in Bangalore

    ReplyDelete
  9. Very informative blog! There is so much information here that can help thank you for sharing.
    Data Science Syllabus

    ReplyDelete
  10. Excellent effort to make this blog more wonderful and attractive. Information shared was useful thankyou.
    Data Science Institutes in Bangalore

    ReplyDelete
  11. Thank you for sharing this wonderful blog, I read that Post and got it fine and informative. Please share more like that...
    Ethical Hacking Institute in Bangalore

    ReplyDelete
  12. Next, you should start writing the term paper. The first step is to write the abstract. It will tell
    write my essay for me
    what you plan to write about. It should briefly explain the topic you're going to write about. In the next step, discuss the results of the study and how the results relate to prior research. In addition, it should discuss any limitations that your study may have and how they are relevant to the topic. The introduction should discuss the significance of the findings.

    The introduction should give the reader a general overview of the topic and the main idea of the paper. The body should
    Write My Essay Pro
    the context of the topic, and the author's position on the issue. They should also discuss the background of the topic. An introduction is not an introduction, but rather an outline. A term paper is a piece of writing that should be formatted like an essay. However, it should be well written and well organized.

    The next step is writing the paper. It is important to follow all the requirements of the professor and the instructions of the assignment carefully. The instructions should be
    Write EssayWriterOnline
    spelled out and highlighted. Don't skim the paper, as this may lead to missing important points. If your instructor or professor asks you to write an essay or a term-paper, make sure you're familiar with the format and style of the assignment. You should never be afraid to ask your professor what kind of topic you're required to cover.

    ReplyDelete
  13. This is really nice which is really cool blog and you have really helped a lot of people who visit the blog and give them useful information.
    Data Science Training in Noida

    ReplyDelete
  14. Nice post. This is a great article and am pretty much pleased with your good work. Very helpful information. Thank you.
    Best Data Science Courses

    ReplyDelete
  15. Well done for this excellent article. and really enjoyed reading this article today it might be one of the best articles I have read so far and please keep this work of the same quality.
    Data Analytics Course in Noida

    ReplyDelete
  16. Interesting post. which i wondered about this issue so thanks for posting and very good article which is a really very nice and useful article. Thank you
    Data Science Course in Noida

    ReplyDelete
  17. I like to view your web site which is very useful and excellent resource and truly adored reading your posting. Thank you!
    Data Science Course in Gurgaon

    ReplyDelete
  18. Informative Post. The information you have posted is very useful and sites you have referred was good. Thanks for sharing.
    Data Science Course with Placement

    ReplyDelete
  19. I would like to say that this blog really convinced me to do it and thanks for informative post and bookmarked to check out new things of your post…
    Data Science Institute in Noida

    ReplyDelete
  20. Excellently written article and information was helpful. Please keep it up thank for sharing.
    Business Analytics Course in Lucknow

    ReplyDelete
  21. I am sure it will help many people. Keep up the good work. It's very compelling and I enjoyed browsing the entire blog.
    Business Analytics Course in Bangalore

    ReplyDelete
  22. A good blog always contains new and exciting information and as I read it I felt that this blog really has all of these qualities that make a blog.
    Data Science Institutes in Bangalore

    ReplyDelete
  23. Very educating blog, got lot of information thank you.
    Data Scientist Course in Jaipur

    ReplyDelete
  24. This is an excellent article. I like this topic. I have found a lot of interesting things on this site.Thanks for posting this again.
    Business Analytics Course in Jaipur

    ReplyDelete
  25. This is an informative and knowledgeable article. therefore, I would like to thank you for your effort in writing this article.
    Data Science Course in Bangalore

    ReplyDelete

  26. We are really grateful for your blog post. You will find a lot of approaches after visiting your post. Great work thank you.
    Data Analytics Course in Chandigarh

    ReplyDelete
  27. Excellent effort to make this blog more wonderful and informative. The information shared was very useful.
    Data Analytics Course in Chandigarh

    ReplyDelete
  28. Really, this article is truly one of the best in the article. And this one that I found quite fascinating and should be part of my collection. Very good work!.
    Data Science Training in Amritsar

    ReplyDelete
  29. This is a great inspiring blog.You have shared really very helpful information thank you.
    Data Scientist Course in Amritsar

    ReplyDelete
  30. Are you spinning the reels of a particular slot and barely getting any winnings at https://qyto.com/casino/? Chances are high that you are playing a slot with a high variance. Dispersion is a measure of the risk associated with a game, which also affects the rewards you can get from a single win. Most games with high variance are progressive slots, which offer huge payouts to incredibly lucky risk-takers.

    ReplyDelete