0

When I want to connect to my site database via the local network، This message will appear:

Cannot log in to my_server_name/AspNet

My connection string is:

<connectionStrings>
    <add name="behbahan_cementConnectionString" connectionString="Data Source=MAYA-1307F9F334\SQLEXPRESS;Initial Catalog=behbahan_cement;Integrated Security=True" providerName="System.Data.SqlClient"/>
</connectionStrings>`

I can't connect to the database?

Damon
  • 3,004
  • 7
  • 24
  • 28
user3068735
  • 1

2 Answers2

1

I'd suggest you first try and establish whether you can connect to the database from outside the web application either via SQL Server Management Studio or by using a .UDL file. I've answered a question on testing a SQL server connection here.

Based on the results of these tests it may become apparent to you what the problem may be. In your case, you are using integrated security (which you would need to be on a domain to use over the network). If you are not on a domain, a username and password may need to be supplied.

Community
  • 1
  • 1
Damon
  • 3,004
  • 7
  • 24
  • 28
-2

Standard way to connect Database as;

          <connectionStrings>
          <add 
                 name="NorthwindConnectionString" 
                 connectionString="Data Source=serverName;Initial 
                 Catalog=Northwind;Persist Security Info=True;User 
                ID=userName;Password=password"
                providerName="System.Data.SqlClient"
          />
          </connectionStrings>

What I can See here is you are messing ;

           ID=userName;Password=password"

to connect the database in connectionString. Default username and password should be "root" unless you have changed it. Try to connect with this detail. Thanks,

H. Mahida
  • 2,356
  • 1
  • 12
  • 23
  • This response is totally misleading. 1. Those attributes are not missing. They are not required with Integrated Security=True. 2. What makes you think the login is root/root? – Nick.Mc Dec 08 '13 at 09:11