Friday, March 23, 2012

How to create Database and tables in MSDE

I have install the MSDE from Ofiice 2000 cd and my MSDE sql server is running fine that I can see from my tray bar with green arrow button. Now i want to create the database so can any body tell me how do i create database. Is there ne query analyser or enterprise manager by which I can create database. Also when i try to install starterkit it doen not allow me to install it. It ask me to select database from the dropdown list and when I select Localhost (only option available) and click on test connection it gives me error Unsuccessfull

I am new at MSDN so please help me.

Yoiu have a couple of options.
1) You can rul SQL scripts directly against MSDE using the command line interface that comes with it.
2) If you have Access 2000, XP, or 2003, youcan create a new "Access Project" and connect to your MSDE instancegraphically.
3) For ~$50 U.S, you can purchase a copy ofSQL Server 2000 Developer Edition, and connect to MSDE via EnterpriseManager.
4) You can download and install a copy of SQLServer 2000 Evaluation Edition, and use Enterprise Manager fromthat. Attempt to decipher its licensing limitations at your ownrisk.
|||Could u tell me where to find command line b'se i tried to find it but coudn't. Sorry i m new at MSDE. pls tell me how can I connect through access project. Also I am unable to install Starter kit too.
Pls help me|||The command line tool is called osql.exe. Here's an article that'll help you use it: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q325003
For connecting though an Access Project, either follow the wizard, or look it up in Access help.

|||Thank you very much for your answer. I was able to find out the osql.exe utility.
I am having one problem when I try to execute the command osql -e it ask me password and when i type 'sa' as password it gives me error that the username is not associated with trusted sql server. I think when I installed the MSDE I did not give it any strong user name and password so I wil try again by giving strong [password t the time of installing it.
Once again thanx very much for your time.sql

No comments:

Post a Comment