SQL Server 2008 via Database Manager

[bdgross]

Hello,
I enabledmy betaSQL Server 2008 account and enabled Database Managerunder IIS tools in the control panel. In IIS Manager, I installed Database Manager, restarted IIS Manager, and started Database Manager. I then created a new connection with the following settings:

Connection name: SQL2008conn
Database provider type: System.Data.SqlClient
Server: sql2k8-beta.discountasp.net
Database: SQL2008_482384_beta
User ID: SQL2008_482384_beta_user
Password: ******

These were the settings displayed on the control panel when I added the beta SQL Server 2008 account. However, when executing a query against the connection in Database Manager, I get a "Failed to connect to server error".

Is there something wrong with the settings that I entered in Database Manager? Any help would be appreciated.

Thanks,
Ben

[wisemx]

Hi,
Are you talking about the IIS7 DB manager?
Please be a little more specific about which tool/version.

Connecting to SQL Server 2008 can be done via both the full and express versions of SQL Server 2008.
There is also an update to allow SQL Server 2005 to connect.
And of course the DB manager in IIS7 from the IIS7 Manager.
Salute,
Mark

[bdgross]

Yes, I am using IIS Manager 7.0. I try to configure the SQL connection using the settings given in a previous post. When I click the connection icon in Database Manager, it prompts me for a password; I enter the password, and it appears to connect, and Tables and Stored Procedures menu items appear under the connection (databaseManager1.jpg). However, when I attempt to execute a simple SQL query against the database, I get a connection error (databaseManagerError1.jpg) .
Thanks for your help.
-Ben

[wisemx]

Hi,
I just checked and couldn't find anyone who had this problem with the IIS7 DB manager yet.
(Including me.)
Open a Support Ticket and see if any of the DASP DB guys have any ideas what might be going on.
Salute,
Mark

[junior]

Hi guys,

Currently you are not able to use the DB Manager (IIS7 Manager) against SQL 2008.


junior

DiscountASP.NET

www.DiscountASP.NET (http://www.DiscountASP.NET)