Creating new web site on DAP

Discussion in 'ASP.NET 2.0' started by wisemx, Feb 25, 2007.

  1. wisemx

    wisemx

    This is a common error when using the Express SQL Server.
    Try changing your connection configuration in your web.config so you clear and remove, like this:

    <connectionStrings>
    <clear />
    <remove name="LocalSqlServer"/>
    <add name="LocalSqlServer" connectionString="Data Source=tcp:yourstring.discountasp.net;Initial Catalog=yourDBstring;User ID=your_user;Password=your_password;" providerName="System.Data.SqlClient" />
    <remove name="yourConnectionString"/>
    <add name="yourConnectionString" connectionString="Data Source=tcp:yourstring.discountasp.net;Initial Catalog=yourDBstring;User ID=your_user;Password=your_password;" providerName="System.Data.SqlClient" />
    </connectionStrings>

    ...If you specify your remote SQL Server DB properly this should resolve the error, by adding the clear and remove sections.
    Did this make sense? (Specific to ASP.NET 2.0 however...)
     
    wisemx, Feb 25, 2007
    #1
  2. MUVEKA

    MUVEKA

    Thanks.. was able to change my Connection String to connect to the remote DB at DAP account and am now able to see the site
    .
     
    MUVEKA, Feb 25, 2007
    #2
  3. MUVEKA

    MUVEKA

    Hi,
    I recently bought an account on DAP. I am now using the account to launch my ASP.NET web site written in .NET2.0 . However, I get an error when I access it online. Something like below:


    An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

    Source Error:





    Code:
    An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
    Stack Trace:





    Code:
    [SqlException (0x80131904): An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)]
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +735043

    STEPS I TOOK TO CREATE THE WEB SITE:

    1. Created a web site in MS Visual Web Developer 2005 Express Edition.
    2. Connected it to a locally hosted SQL 2005 DB
    3. Exceuted it off local host and it works
    4. Copied the web site to DAP account and then it fails.

    So, if the error is due to Connection String using a local DB, I even tried to use a Connection String to use the Database I own under my account on DAP. I can do that, however can not create the DB with a back up file from my local database. The errorI get it pasted below. Can someone help and tell me what am I doing wrong.














    TITLE: Microsoft SQL Server Management Studio Express
    ------------------------------
    Cannot show requested dialog.
    ------------------------------
    ADDITIONAL INFORMATION:
    Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum)
    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&amp;LinkId=20476
    ------------------------------
    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
    ------------------------------
    SELECT permission denied on column 'backup_set_id' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'backup_start_date' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'server_name' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'is_copy_only' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'backup_set_id' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'backup_start_date' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'server_name' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'backup_set_id' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'backup_start_date' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'server_name' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'backup_set_id' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'backup_set_uuid' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'media_set_id' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'first_family_number' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'first_media_number' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'last_family_number' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'last_media_number' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'catalog_family_number' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'catalog_media_number' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'position' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'expiration_date' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'software_vendor_id' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'name' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'description' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'user_name' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'software_major_version' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'software_minor_version' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'software_build_version' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'time_zone' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'mtf_minor_version' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'first_lsn' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'last_lsn' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'checkpoint_lsn' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'database_backup_lsn' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'database_creation_date' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'backup_start_date' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'sort_order' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'code_page' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'compatibility_level' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'database_version' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'backup_size' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'server_name' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'machine_name' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'flags' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'unicode_locale' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'unicode_compare_style' of object 'backupset', database 'msdb', schema 'dbo'.
    SELECT permission denied on column 'collation_name' of object 'backupset', database 'msdb', schema 'dbo'. (Microsoft SQL Server, Error: 230)


    Thanks!
     
    MUVEKA, Feb 25, 2007
    #3

Share This Page