购买lunarpages的windows空间，如何设置ms sql数据库？

dragon · 发表于 2007-6-15 16:42:40

请各位高手指点，一套asp+ms sql server商城系统，如何设置数据库？感谢先！

大漠孤狼 · 发表于 2007-6-15 16:46:51

先在控制面板建立数据库

dragon · 发表于 2007-6-15 16:54:53

感谢，我先操作一下

dragon · 发表于 2007-6-15 17:29:50

Info: The database web_qybdata_Data has been created.下一步如何操作？

dragon · 发表于 2007-6-15 18:14:48

我根据这里的说明：http://bbs.idcspy.com/thread-5848-1-1.html，已经建立了数据库，但是，没有找到下面说的连接：
“说明数据库建好.
然后在Username: 填写数据库用户名 Password:填写密码,点击Create user建立一个数据库用户
最后在数据库管理界面找到Add Users To Your Databases:“

哪里有：username,password,我怎么没有找到呢，请指点，感谢！

大漠孤狼 · 发表于 2007-6-15 18:43:38

原帖由 dragon 于 2007-6-15 06:14 PM 发表
我根据这里的说明：http://bbs.idcspy.com/thread-5848-1-1.html，已经建立了数据库，但是，没有找到下面说的连接：
“说明数据库建好.
然后在Username: 填写数据库用户名 Password:填写密码,点击Create user建立一个数据 ...

那个是linux主机的说明

dragon · 发表于 2007-6-15 20:16:29

谢谢答复，我这个windows主机的数据库如何设置呢，请指教，谢谢

大漠孤狼 · 发表于 2007-6-15 21:13:32

等一下我看看，没弄过

dragon · 发表于 2007-6-15 23:02:43

我基本搞得有些眉目了，目前就是登陆：http://lesuth.lunarpages.com/mylittleadmin/Default.aspx的时候，总是出现错误错误信息如下：

.Net SqlClient Data Provider

Login failed for user 'drag35_ok'.

dragon · 发表于 2007-6-15 23:04:54

我是按照这个说明操作的:
In Plesk, if you click on DB WebAdmin after you have created a database, it will take you to ASP.Net Enterprise Manager. You can also get there by clicking on your domain name in the domains list, Databases, the name of the DB, DB WebAdmin.

We also offer a premium MSSQL Server 2005 web-based management tool for our shared Windows plans called MyLittleAdmin. This tool allows you to manage your own databases, including uploading and restoring your MSSQL databases. Additionally, you can use MyLittleAdmin to manage almost all of your database objects such as creating tables, schemas, and snapshots.

We have 2 methods you can use to log into MyLittleAdmin. First, you would be able to log into your Plesk using https://account.lunarpages.com/ area and then clicking on the Control Panel icon, then the "Go to Plesk" button.

When in Plesk, click on your domain name in the center pane, then click on the "MyLittleAdmin Tool" icon under the Custom Buttons option. Once in the MyLittleAdmin area, please do the following:

1. Keep 'SQL Server Authentication' in the Authentication dropdown.
2. In the Login field, enter your database username.
3. In the Password field, enter your database user's password.
4. Click the "Connect" button.

Please note that if you have not added a database user and password to your database yet, you would first need to click on "Databases" icon in Plesk, then click on your MSSQL database, then click "Add New Database User" and input the database username and password (write these down to use for the MyLittleAdmin tool).

The other method to log into MyLittleAdmin would be to go directly to http://lesuth.lunarpages.com/

Remote connections to manage MSSQL databases are currently not available for security reasons.