how to deploy asp .net website alongwith database in IIS?

Question

When I run website in browser, following server error occured -

Server Error in '/FinalHVA' Application.
--------------------------------------------------------------------------------

Cannot open database "HVAdb" requested by the login. The login failed.
Login failed for user 'COMP1\ASPNET'.

Oded · Accepted Answer · 2009-12-10 20:15:45Z

1

Looks like the comp1\aspnet user doesn't have permissions to login to the HVAdb database.

answered Dec 10, 2009 at 20:15

Oded

501k102 gold badges900 silver badges1k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ta01 · Accepted Answer · 2009-12-10 20:16:08Z

1

Can you post your web.config file , specifically the Database Connections, it looks like the login credentials being passed to the database is the Machine\ASPNET account

A Standard Connection String will look like this:

Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

If you want to use the credentials of the user accessing the web application, you should use:

Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;

Note - you should disable anonymous access on the virtual directory if you would like to use a trusted connection i.e. the second one.

answered Dec 10, 2009 at 20:16

Ta01

31.7k13 gold badges74 silver badges100 bronze badges

1 Comment

Sneha Joshi Over a year ago

<connectionStrings> <add name="HVAdbConnectionString" connectionString="DataSource=COMP1;Initial Catalog=HVAdb;Integrated Security=True" providerName="System.Data.SqlClient"/> </connectionStrings> This is connection string

Collectives™ on Stack Overflow

how to deploy asp .net website alongwith database in IIS?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related