SQL Server Service Manager! (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

box -> SQL Server Service Manager! (9/14/2003 5:54:41)

Hi everyone! I wanted to learn more about SQL 2000, so finally I download and ran
sql2kdesksp3a.exe file, now I have a icon that represent “SQL server service manager”
and it shows that SQL server is running! I’m confused! Can anyone please explain me how
can I use this, and how can I convert access 2000 to SQL 2000? Do I need to install something else? I want to convert a ms access to sql 2000 and use it with frontpage 2002. I did my homework and searched the net but I couldn’t find any simple article. Please help, thanks



Spooky -> RE: SQL Server Service Manager! (9/14/2003 16:40:57)

If you go start > programs > Do you have Microsoft SQL listed, or perhaps you have only installed the server part and not the client tools?



box -> RE: SQL Server Service Manager! (9/14/2003 17:48:55)

Thanks 4 reply Spooky, my O/S is winxp pro, the only listed program is MS ASP.net web metrix! and also I can see the icon for SQL Server Manager on
toolbars!



Spooky -> RE: SQL Server Service Manager! (9/14/2003 18:15:48)

Assuming you have asp.net. heres a utility that can help you administer an SQL database

http://www.microsoft.com/downloads/details.aspx?familyid=f0d03472-5e6c-459e-a6d8-6745a729c3c9&displaylang=en



Doug G -> RE: SQL Server Service Manager! (9/14/2003 18:34:00)

You got MSDE, which doesn't include client tools

You can use Access 2000+ quite effectively to manage and play with your MSDE server. Open an Access Project, choose to create a new project, new database, and when you are asked for the database server use localhost or 127.0.0.1 or your computer name (there is a dropdown which should return your local server).

Use windows authentication.

This will create a new database on your MSDE server.



box -> RE: SQL Server Service Manager! (9/14/2003 21:34:39)

Hi there, do I need client tools? I did install web data admin, but I don't see it! Also I got the upsizing wizard report! My question is now what should I do? Where is the converted database and do I import it to the front page 2002, please forgive my ignorance!
I need your help!



Spooky -> RE: SQL Server Service Manager! (9/14/2003 22:48:08)

Theres 3 options that spring to mind,
1) as Doug says to use Access 2000+
2) use a web based tool such as http://www.2enetworx.com/dev/projects/tableeditor.asp
3) Download the full SQL server eval copy and just install the client tools http://www.microsoft.com/sql/evaluation/trial/default.asp (beware its a 300mb behemoth.... broadband is a must!)



box -> RE: SQL Server Service Manager! (9/15/2003 0:31:22)

quote:

client tools

Thanks everyone specially Spooky, now I have client tools installed on my pc! Now
What would be the next step? thanks



Spooky -> RE: SQL Server Service Manager! (9/15/2003 0:35:57)

What do you plan on doing with it? :-)



box -> RE: SQL Server Service Manager! (9/15/2003 1:14:30)

I have a program based on frontpage 2002 and DWR, I want to convert the MS Access
database to sql 2000 and make sure that program will work as before.



Spooky -> RE: SQL Server Service Manager! (9/15/2003 4:27:11)

Check out the upsizing wizard in Access :
Tools > utilities > Upsizing

That will guide you through most of the steps.



rdouglass -> RE: SQL Server Service Manager! (9/15/2003 11:55:23)

quote:

Sorry I think I will give up!


Don't give up! You'll be glad you didn't!

If you installed the client tools, you should have a program called Enterprise Manager. That will allow you to see all the tables and queries that the upsizing wizard created. Open Enterprise Manager and add a new "Server Registration". You should now be able to see all your data.

To use the SQL Engine with FrontPage DRW, you build a ODBC connection (or DSN) and have the DRW access that. You can use existing DRW's by changing the connections under your database connections.

Any help there?



box -> RE: SQL Server Service Manager! (9/15/2003 15:00:02)

quote:

you build a ODBC connection (or DSN) and have the DRW access
Thanks a lot for you support, I did open a new "Server Registration", now do I need to build a connection to the new database? I’m afraid to say how can I do this! It would be very useful to have an example of that famous connection. So if understood correctly the concept is different because access lives inside of frontpage but sql Is in another location and I need to provide the link or address. To be honest with you here is more than forum is an university thank you all.



rdouglass -> RE: SQL Server Service Manager! (9/15/2003 15:07:08)

If you're using the DRW and have access to the host, setup a database connection using the server's control panel. Then change your existing DRW connection to use the SQL connection from within FrontPage.

If you let me know which server OS and FP version you're using, I can give you more details....



box -> RE: SQL Server Service Manager! (9/15/2003 16:06:43)

Thanks rdouglass, I use winxp pro with fronpage 2002 or xp,What I did I opened the fpdb folder then upsized the access database by running the wizard I left everything as default and also I got the upsizing report now the issue is How to create the new connection, and replace it I guess I need to run spooky diet too!

Thanks again



Spooky -> RE: SQL Server Service Manager! (9/15/2003 16:32:51)

In frontpage > tools > web settings > database > Add > (new connection)

Choose "Network connection to database server" > browse > enter database name and server name > ok

Click the advanced button and enter your login for that database. > ok

Then, you should be able to verify the connection and start using it in DRW pages.



box -> RE: SQL Server Service Manager! (9/16/2003 1:06:18)

Thanks a lot guys, with your help I’m getting close, my questions are:

1-What application changes do you want to make?
a-Create a new access client/server application
b-Link SQL server tables to existing application.
c-No application changes.
Next step

2-Do you want to open the resulting ADP file after the upsizing operation is completed?
-Open the new ADP file?
-Keep the MDB file open.

3- What is max size of this SQL database and what is the number of connection to it?

4- Now when I want to display result from the SQL database I get the following error:

Database Results Error
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'KELLY\IUSR_KELLY'.

I appreciate your help.



box -> RE: SQL Server Service Manager! (9/16/2003 15:51:02)

Any Idea please!



Spooky -> RE: SQL Server Service Manager! (9/16/2003 21:41:07)

Im not sure of what you mean with the first 2 questions?

3) Depends on your version and licensing.
Using MSDE, from memory you are allowed 5 connections, but its mainly designed as a testing bed, not a production server

4) How are you connecting now? if through FP, it sounds as if you have not set the login for SQL authentication and its using windows permissions.



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.078125