Posted by Nick Chan on 10/09/07 06:06

try this from client computer

telnet mydatabaseIP 1433

if u dun see blank screen, open port 1433 at database server

On Oct 8, 3:08 am, aCe <acerah...@gmail.com> wrote:
> Hi all,
> i'm using MSSQL Server 2005 Standart Edition.
> i created ASP.NET application without MSSQL Server 2005 Express.
> every time i Run my app always show these errors :
>
> 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.
>
> SQLExpress database file auto-creation error:
>
> The connection string specifies a local Sql Server Express instance
> using a database location within the applications App_Data directory.
> The provider attempted to automatically create the application
> services database because the provider determined that the database
> does not exist. The following configuration requirements are necessary
> to successfully check for existence of the application services
> database and automatically create the application services database:
>
> 1. If the applications App_Data directory does not already exist, the
> web server account must have read and write access to the applications
> directory. This is necessary because the web server account will
> automatically create the App_Data directory if it does not already
> exist.
>
> 2. If the applications App_Data directory already exists, the web
> server account only requires read and write access to the applications
> App_Data directory. This is necessary because the web server account
> will attempt to verify that the Sql Server Express database already
> exists within the applications App_Data directory. Revoking read
> access on the App_Data directory from the web server account will
> prevent the provider from correctly determining if the Sql Server
> Express database already exists. This will cause an error when the
> provider attempts to create a duplicate of an already existing
> database. Write access is required because the web server accounts
> credentials are used when creating the new database.
>
> 3. Sql Server Express must be installed on the machine.
>
> 4. The process identity for the web server account must have a local
> user profile. See the readme document for details on how to create a
> local user profile for both machine and domain accounts.
>
> My questions is :
> - if already installed MSSQL Server 2005 Std, should i installed MSSQL
> Server 2005 Express too?
> - i already changed my remote connections settings in SQL Server 2005
> Surface Area Configuration to Local and Remote Connections and Using
> Both TCP/IP and named pipes. What should i do??
>
> Thx,
> aCe

[Back to original message]