1

Topic: Error of establishment of connection with a SQL Server at object button click "Login"

Kind time of days, !
Started to try to do the web application under ASP.NET. Created 1 form added some objects, launched to check up - all is loaded, added an element "Login". There was an error - after login and password input, and button click "to Fulfil an input" (all is object elements "Login") to me instead of discovery of new page produces an error (more in detail in a picture):
"At establishment of connection with a SQL Server there was an error connected to a network or with a certain copy. The server is not found or inaccessible. Be convinced that the instance name is specified correctly and that on a SQL Server remote connections are resolved. (provider: SQL Network Interfaces, error: 26 - an error at detection of the specified server or a copy)"
Database to the project generally yet did not connect.
Prompt please in what here business and as it can be corrected.

2

Re: Error of establishment of connection with a SQL Server at object button click "Login"

Folder "App_Data" in the project included.

3

Re: Error of establishment of connection with a SQL Server at object button click "Login"

Vlad __ i __ mir;
By Russian language it is written, in what a problem: at establishment of connection with basis it appeared that there is no it in that place where it was expected that it is.
You describe that want to make and that expect is better.

4

Re: Error of establishment of connection with a SQL Server at object button click "Login"

Vlad __ i __ mir wrote:

the Database to the project generally yet did not connect.

How you consider, what should happen after "after login and password input"?

5

Re: Error of establishment of connection with a SQL Server at object button click "Login"

skyANA wrote:

Vlad __ i __ mir;
By Russian language it is written, in what a problem: at establishment of connection with basis it appeared that there is no it in that place where it was expected that it is.
You describe that want to make and that expect is better.

That that a DB is not found it it is clear. Not clearly following:
1 Why and for what application searches for the Server, thus that in the application code anywhere reversal to a DB is not present?
2 Where exactly application searches for the Server (at me it is installed MS SQL and all services like are launched)?
It would be necessary for me that the object "Login" worked correctly and did not throw out the given exception. I while wrote for it the handler who does not address to a DB, and simply compares to variables, but I will fasten further on a DB.

6

Re: Error of establishment of connection with a SQL Server at object button click "Login"

behind a board wrote:

it is passed...
How you consider, what should happen after "after login and password input"?

I while wrote the handler who does not address to a DB, and simply compares to variables, therefore I do not catch up why he demands a DB

7

Re: Error of establishment of connection with a SQL Server at object button click "Login"

Vlad __ i __ mir wrote:

it is passed...
That that a DB is not found it it is clear. Not clearly following:
1 Why and for what application searches for the Server, thus that in the application code anywhere reversal to a DB is not present?

In the code written personally by you there is no reversal to a DB, and in the element code "Login" most likely is.

Vlad __ i __ mir wrote:

2 Where exactly application searches for the Server (at me it is installed MS SQL and all services like are launched)?

Searches on those parameters that are registered in a line of connection.
In the message all is told: the local copy of SQL Server Express using layout of a database in directory App_Data of application.

Vlad __ i __ mir wrote:

it would be necessary For me that the object "Login" worked correctly and did not throw out the given exception. I while wrote for it the handler who does not address to a DB, and simply compares to variables, but I will fasten further on a DB.

That means correctly? On what DB it should be fastened?
understand with all files of the project. First of all look in a configuration file, look there at parameters of a line of connection to a DB.
Expose the correct.

8

Re: Error of establishment of connection with a SQL Server at object button click "Login"

skyANA, in file Web.config of a line of connection to a DB did not find (well I it before did not connect), now through an observer of servers connected the necessary DB. In properties of a DB a line connection is displayed:

Data Source=home-pc; Initial Catalog=DatabaseFastWater; Integrated Security=True

But in file Web.config of a line of connection to a DB did not appear and after attempt to compile produced a new error:
"HTTP Error 403.14 - Forbidden
The Web server is adjusted so that not to form the list of the contained directory."
I tried to find that directory which is underlined in section "That it is not possible to undertake", but find it on the disk I could.
I do not know what to do