How to connect SQL Server 2008 with IIS 7 on Windows Server 2008

amazon ec2iis-7sql-server-expresswindows-server-2008

I am using Amazon EC2 server, with Windows Server. It has installed SQL Server 2008 R2 Express and IIS7. I have made a web site, and want to test this web app. But it is not connecting to the SQL Server. I have tried different connection strings. But it is giving this error:

Server Error in '/' Application.
Cannot open database "Avon" requested
by the login. The login failed. Login
failed for user 'NT AUTHORITY\NETWORK
SERVICE'.

I have tried to change it from windows authentication to SQL Server authentication and vice versa. But same error.

My connection string is

connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|Avon.mdf;Integrated Security=True;User Instance=true;"

I have copied Avon.mdf and Avon.ldf file into App_data. I want it to connect either by local server, or by IP address.

I appreciate your answers.
Thanks

Best Answer

If the identity under which the application is running does not have access to the database, you will need to provide user name and password in the connection string.

Example:
Password=somepassword;Persist Security Info=True;User ID=someuserid;Initial Catalog=DatabaseName;Data Source=.\SQLEXPRESS

Related Solutions

Sql-server – Classic ASP problem connecting to remote SQL Server database

For a site to use the application pool identity for classic ASP, you need to change the credentials used for Anonymous Authentication. By default, the site will be set to use a specific user, namely IUSR.

Select Authentication from the IIS area of your site, then select Anonymous Authentication followed by Edit. Change from Specific user to Application pool identity.

It's advisable to use Windows authentication (integrated security) over SQL authentication so that you don't have credentials in your config files so that if those files are compromised, you don't lose control of the credentials.

Linux – Blocking FTP with iptables

Write a rule which blocks all the incoming traffic for FTP, assuming the FTP port is 21:

iptables -A INPUT -p tcp --destination-port 21 -j DROP

Then write the following rule to exclude your IP from being blocked:

iptables -I INPUT -s 123.123.123.123 -p tcp --destination-port 21 -j ACCEPT

The -I parameter will insert the rule at the top of the stack. Since we didn't provide any rule number, it will be inserted at the top by default.

Best Answer

Related Solutions

Sql-server – Classic ASP problem connecting to remote SQL Server database

Linux – Blocking FTP with iptables

Related Topic