InstantASP Support Center

Home Search Tags Glossary Members
Welcome Guest ( Login | Register )
Latest Additions Most Popular
Home » Documentation » InstantKB.NET » Installation » Creating the InstantKB.NET SQL Server database

Creating the InstantKB.NET SQL Server database

Expand / Collapse
 
     

Creating the InstantKB.NET SQL Server database


InstantKB.NET supports both SQL Server 2000 & 2005. We will also be ensuring support for SQL Server 2008 later this year. In this example we'll use SQL Server 2005 & the SQL Server 2005 Management Studio to create the InstantKB.NET database, tables & stored procedures.

The process is very similar for SQL Server 2000 however you'll need to use the SQL Server 2000 Query Analyzer to execute our installation script against your database.

To create the various database tables & stored procedures required by InstantKB.NET you'll need to execute a SQL script provided within the download against your database. This SQL script can be found within"InstantKB20\DatabaseScripts\InstantKB20Inhstall.sql".

Should i use an existing database or create a new one?

You can use an existing database or create a new database to host the InstantKB.NET tables and stored procedures. Ideally you would create a separate database to host the InstantKB.NET tables and stored procedures. We appreciate however this can this is not possible for some users and we've designed our tables & stored procedures to use a unique naming convention allowing you to use an existing database without any naming conflicts.

Creating the tables & stored procedures

In the example we will be connecting to a local SQL Server 2005 instance using Windows Authentication. If you wish to add the InstantKB.NET tables and stored procedures to a remote database you should enter the connection details for your database. If your not sure how to connect to your SQL Server instance please consult the Authentication Modes section of your SQL Server documentation. If your using shared or dedicated hosting your hosting company should have sent you your SQL Server connection & login details via email.
  1. Connect to your SQL Server instance. You may need to provide your server address and if your using SQL Server authentication you'll need to provide your SQL Server username & password to connect...



  2. In this example we are going to create a new database called InstantKB20 to host the InstantKB.NET tables and stored procedures. To create a new database simply right click your "Databases" node and choose "New Database" as shown below..



  3. Provide a name for your new database. In this example we'll call our database "InstantKB20" as shown below...



  4. Once you've provided a name for your database click "OK". You'll see the new database appear within your database list as shown below...



  5. Now you'll need to open the InstantKB20Install.sql file to execute against the new InstantKB20 database, Open the file as shown below and navigate to the InstantKB20 folder and open the "DatabaseScripts\InstantKB20Install.sql" file.



  6. Once you've opened InstantKB20Install.sql you'll see the script load as shown below.



  7. At this stage before executing the script against your database it's important to ensure you have selected the correct database from the database selection drop down list as shown below. The database you select within this list will determine which database the InstantKB.NET tables and stored procedures are created within.



  8. Once your sure you have selected the correct database simply click the "Execute" button as shown below. This may take a few minutes depending on your server and connection.



  9. Once the script has completed execution you'll see the results pane as shown below. You'll notice a number of warning messages with regard to "sysdepends". These can safely be ignored and won't effect your installation.



You've now populated the InstantKB20 database with all the tables, stored procedures and default data required by InstantKB.NET.

That's It!

Continue to "STEP 5. InstantKB.NET connection string & key application settings"...


Related Links



Add Your Comments


Name: *
Email Address:
Web Address:
Verification Code:
*
 

Details
Category: Installation
Product: InstantKB.NET
Version: 2.0
Type: HOWTO
Level: Intermediate
Article not rated yet.
Article has been viewed 1,469 times.
Last Modified By: Ryan Healey
Last Modified:5th June 2008
Options


Powered By InstantKB.NET 2.0.4 © 2008
Execution: 0.063. 12 queries. Compression Disabled.

Home | Products | Purchase | Support | Company | Contact Us
Privacy Statement | © 1999-2007 InstantASP Limited. All Rights Reserved.