Posted: 10/22/2002 2:55:25 PM EDT
|
I'm trying to find the SQL Server tools to use SQL Enterprise Manager. Do I need to purchase the full version of Enterprise Manager or is it possible to get the tools only? My host has web based admin tools for my SQL server but I can't seem to get the job done with them. I'm using Comersus cart and these are the directions they've provided for me to set up an SQL database using there script. If any of you are familiar with Enterprise Manager does it look like this is something that can easily be done using their tools? I'm assuming that these directions are for Enterprise Manager but since I've never used it before I don't know for sure. Here is what they say: 1. Open SQL Enterprise Manager and Create a new database called "Comersus". 2. In SQL Enterprise Manager go to Tools>SQL Server Query Analyzer. On the drop down box at the top right make sure your database "Comersus" is selected. Then copy and paste the contents of comersus_4XX_structure.sql into the Query Analyzer. Click the green play button at the top. Some errors may appear but this is normal. If you get some error like "Specified owner name 'dbo' either does not exist or you do not have permission to use it." then maybe you are not logged in as administrator. Just open comersus_4XX_structure.sql with some text editor and replace all "dbo" by "yourLoginName". Then copy & paste and try again. 3. Go to Security, Login Sessions, add a user name "Comersus" using database "Comersus". Put SQL Server authentication 4. Select Users in tree view, New Database User name "Comersus". With public and db_owner checked. 5. Open comersus/includes/settings.asp and change the connection to SQL method. Change the IP of the server and change the password by the one you selected on item 4. 6. Now you can open the store with BackOffice Gold and add categories, define payments, etc. I'm not sure if my host will allow me to change the database name to "Comersus", they've set it up to a specific name on the site so if that's the case I should just need to modify the files in my software that define the database name. I've got the DSN and the IP address for the SQL server so I guess I've got everything I need except for the tools to create the database. Thanks, John |
|
Ire, Thanks for the information. Since I've never used Enterprise Manager I wasn't certain that those directions were for it but I assumed that they were. I'm not sure what version of SQL by database is using. My site is hosted by http://www.ihost.biz , run by Greg from the AR15 board here. The site says "MS SQL Server 2000". I don't have the Enterprise Manager CD. Greg told me that most people can get by with using the online tools he provides and if not they have to come up with the Enterprise CD. I can't seem to get it to work using his tools, possibly because they won't do what I need and also more than likely due to my lack of SQL knowledge. Do you know if it's possible to get just the tools? I hate to have to buy Enterprise Manager to use it one time to create the database. If I can't get them then maybe I can find someone to create the database for me. John |