sql server login problem
-
i am using sql server 2005 express and i have one web site which is i have published and installed on machine but when connecting to sql server 2005 express getting error login failed mycomname/ASPNet user why not taking user name insted of aspnet how do i login my con string is as follws <add name="EMSConnectionString" connectionString="Data Source=.\sqlexpress ;Initial Catalog=EMS;intigrated security=true" providerName="System.Data.SqlClient"/>
-
i am using sql server 2005 express and i have one web site which is i have published and installed on machine but when connecting to sql server 2005 express getting error login failed mycomname/ASPNet user why not taking user name insted of aspnet how do i login my con string is as follws <add name="EMSConnectionString" connectionString="Data Source=.\sqlexpress ;Initial Catalog=EMS;intigrated security=true" providerName="System.Data.SqlClient"/>
nikhil1234 wrote:
why not taking user name insted of aspnet how do i login my con string is as follws
Your web application is running in the context of the ASPNET user. Therefore, when you use integrated security you will log in with the credentials of the user that your process is running as. This is the correct functionality. You must grant the appropriate access to the ASPNET user to the database. Possibly the reason you did not see this when you were developing the web site is that Visual Studio has its own built in Web Server that uses your credentials. When you deploy to IIS you use the credentials IIS uses.
*Developer Day Scotland - Free community conference Delegate Registration Open
-
i am using sql server 2005 express and i have one web site which is i have published and installed on machine but when connecting to sql server 2005 express getting error login failed mycomname/ASPNet user why not taking user name insted of aspnet how do i login my con string is as follws <add name="EMSConnectionString" connectionString="Data Source=.\sqlexpress ;Initial Catalog=EMS;intigrated security=true" providerName="System.Data.SqlClient"/>
intigrated security=true integrated security=true Try that.
var question = (_2b || !(_2b));
-
intigrated security=true integrated security=true Try that.
var question = (_2b || !(_2b));
It is true by default, so that typo would likely have been ignored.
*Developer Day Scotland - Free community conference Delegate Registration Open
-
It is true by default, so that typo would likely have been ignored.
*Developer Day Scotland - Free community conference Delegate Registration Open
Fair enough, I probably should have read the question first, but that typo kinda blinded me straight on. And thanks, I didn't know Integrated security was true by default.
var question = (_2b || !(_2b));