Any input would be appreciated. Thanks.Hello, SQL server is more relaible database enviroment. It allows for more concurrent number of users trying to access the database. Offcourse, it needs a license to use and it costs more while hosting than access database. But if your application needs a lot of interaction with the database, then you must go for SQL server. After all it depends on your application, this will decide on what to use.
Regards.|||
Keep in mind there is a free version of SQL Server 2000 known as MSDE. This version is limited in some ways in comparison with the full server version, but it sure beats MS Access in terms of scalability and performance. Unfortunately, you don't get Enterprise Manager with the MSDE version.
Another nice thing about using MSDE is that it makes easier to upgrade to SQL 2000 in the future if the need arises and you can afford a license. MSDE can be downloaded right from this site:http://asp.net/webmatrix/download.aspx?tabindex=4
For more details about MSDE, please visit the following:http://msdn.microsoft.com/library/en-us/architec/8_ar_ts_67ax.asp?frame=true
|||Right now I'm just playing with the Northwind Database while I'm learning VS.Net. Northwind is in Access. If I stay with Access for now is it any easier than SQL. What is the cost for the license and software?|||Can I upload a website I created with MSDE and run it off a server or will it only work locally off your PC? What is Enterprise Manager?|||
Yes, you can upload your website to work with SQL server if your web hosting provider provides a package with SQL Server.
Enterprise Manager is a GUI tool for managing the database that makes the job much easier. Without this, you need to know SQL syntax as well as learn certain system stored procedures. There is however, lots of documentation available to help with this.
Yes, MS Access will be easier overall from a development perspective, but if your serious about web development, you will need to learn an enterprise class database sooner than later. MSDE provides you with this opportunity without the licensing fees.
Also, there are some admin tools available for free. One is from Microsoft:http://www.microsoft.com/downloads/details.aspx?FamilyID=f0d03472-5e6c-459e-a6d8-6745a729c3c9&displaylang=en
|||OK, so it's up to the hosting provider if they provide support for MSDE. So even through they host SQL Databases they may not support MSDE. I just want to get that straight.
Can you suggest where I can get the best price for Enterprise mananger?
One more question...
It's mentioned in a above reply that I need a licence. Is it one licence for Enterprise Manager Software or do I have to purchase a licence every time I create a web application?
Thanks.|||Hello NetProfit:
I was a bit curious and downloaded that admin tool, it seems pretty cool. Only one question @. home, I don't have SQL server, I do have MSDE, the ligth version of SQL server. When I open the admin tool, it asks for username and password: "Please enter your SQL Server credentials:"
When I installed MSDE I didn't have to create any username/password. Is there anything mising ? I used to work with Access and MySQL. so appreciate your reply.
Regards.|||Hi this is just a thread for me as I am just trying to work out what to do with MSDE.
Regarding a password I actually did give MSDE a password and entered here the same otherwise I think you can go by Windows authentication option I guess(??)(anyway what is the difference - in Matrix book they tell me to go via SQL server authentication and in ASP Matrix tutorial via Windows one?)
Anyway I have rather questions than answers. As MSDE is considered to be better than Access (and it is free) I opted for MSDE. Now I do not know how to use it. I found out in the old thread that you can
1 use command line tool
2 use Access project
3 use SQL Web Data Administrator (I think the one Haidar just downloaded)
Also I think you can do a lot with MSDE directly from Matrix.
Well,. the thing is that I do not know how to use it via Matrix or Data Administrator ie I can create tables columns data types and so on but I have no clue what stored procedure are.
I know SQL (used it on the course for querries mainly) I also used Access some time ago in which there is just a tab: relationships under which you can edit them.
But how do I implement relationships between tables (one to many and so on) via sql web data administrator or matrix? Does it have anything to do with stored procedure?
That is my main question.
And another question is: if I am familiar with Access would it be good idea to use Access Project to build/use MSDE database? I understand it accesses MSDE from Access and creates all database structure in MSDE and querries in Access.
Any help would be greatly apreciated
Anqa|||
sloppyjoe,
The hosting provider will likely support SQL Server. If you build your app locally using MSDE, it will port seemlessly to your hosting provider and run on SQL Server no problem; because it is the same underlying database engine.
In other words, your hosting provider need only support one or the other. Licensing should really prohibit them from using the MSDE version I would think.
|||
Bilal,
Your MSDE was probably installed with only Windows Authentication enabled. You need to enable Mixed Mode (or Windows & SQL Authentication).
Please check out the following knowledge base, which shows how to determine if your sa has a blank password, and how to determine and/or change authentication modes.
http://support.microsoft.com/default.aspx?scid=kb;en-us;322336
Please be careful when editing the registry - it is a zero-beer tool! ;)
|||Hello Net, Thanks for the response. Is there any reference on how to create a new database, new tables, ... with MSDE ? Do you think the admib tool you gave can help in this ? Or is there any reference to how to do so from command prompt, I prefer to do it like that rather than GUIs, Thanks a lot.
Regards.|||I hate to admit it, but I'm feeling stumped here by a painfully simplistic bit of missing data when trying to get an initial ASP.Net development environment running here, building off the Communities Starter Kit.
What's the name of my LocalHost's MSDE "Sql Server' ? ?
I have the retail Visual Studio .Net Visual Basic installed, and the .Net Framework 1.1, both of which seem to have gone into place just fine (I think).
The problem seems to be in invoking the MSDE, or more accurately I think. possibly just in knowing how to reference the already invoked MSDE {BLUSH}
After downloading the MSDE, when I first went to the installed location of my downloaded
sql2ksp3(a)
and I attempt to
setup sapwd=XxXxX SecurityMode=SQL
My system instructs me to
Please go to the Control Panel to install and configure system components.
when I then did a
CD MSDE
and reattempted the
setup sapwd=XxXxX SecurityMode=SQL
the action SEEMED successful.
However, when I later attempt to run the community tarter kit setup it does not seem to recognize any thus far tried variant of \\LocalHost as the SQL Server name, nor any of the following as:
http://localhost/
http://localhost
//localhost/
//localhost
localhost/
localhost
in each case using the SQL Server Authentication radio button, a Login Name of: Admin and the password entered above
Equally curious, when I then, under the guidance of KB 322336 HOW TO: Verify and Change the MSDE System Administrator Password, attempt to issue the
osql -U sa
command ( even when located at C:\sql2ksp3(a)\MSDE> ) I get told
'osql' is not recognized as an internal or external command, operable program or batch file.
suggesting that the MSDE is not ready to roll.
Any tips you all might be able to offer would be greatly appreciated...|||
Bilal,
Sure, the SQL Web Admin tool will do the job for you. It also allows you to write and execute queries against the database. You will need to write queries to manage security because the web UI does not do that.
If you prefer using the command line,osql will do the job for you. Once you've connected to your database instance, you can run any SQL statement or Stored Procedure. Here is a link to get started on that.
http://support.microsoft.com/default.aspx?scid=kb;en-us;325003
|||
Empowered,
If your database is installed, you should be able to connect to it by specifying any one of the following for a server name, assuming it is the default instance:
- ComputerName
- (local)
- 127.0.0.1
If that doesn't work, check the Program Files directory to see if you installed a named instance. If you installed a default instance, you should see the following directory structure on your local drive:
C:\Program Files\Microsoft SQL Server\MSSQL
If you installed a named instance, it might look like this:
C:\Program Files\Microsoft SQL Server\MSSQL$INSTANCE_NAME
In this case, the instance name is identified immediately following the $ symbol (see above). If you have installed a named instance, your server name in your connection string will need to reflect that. The format looks like this:
MACHINE_NAME\INSTANCE_NAME
If you don't see either of these directory structures on your local drive, it means that SQL Server (or MSDE) was not installed successfully.
If you can verify that the MSDE is installed, but you still cannot connect to it, verify that the service is running by opening the Services snap in from Administrative Tools. The service name should be one of the following:
MSSQLSERVER
MSSQL$INSTANCE_NAME
Please let me know if this helps, or if you need any further assistance.
Thanks,
No comments:
Post a Comment