Anonymous Logon for a SQL Server 2008 Express Database

Question

Hi Y'all,

I'm creating a web-based tool that uses SQL Server 2008 Express as a backend database.  We're also hosting the website.  The production server is in a DMZ.  Is it possible to allow Anonymous Logon for SQL Server for anyone who'd use the tool in the website?  The database is strictly read-only.

Appreciate any suggestion.

---

Marilyn Gambone

Answer 1

http://support.microsoft.com/kb/839569

Answer 2

Hello Marilyn,

You should create one SQL login with less previlege for your web tool and us this in your connection string to connect to, instead of using "Windows Authentifications" and/or allowing anonymous logon (via the "Guest" account).

---

Olaf Helper

Blog Xing

Answer 3

Hi,

This is a very simple thing I'm trying to do:  Fill a dropdownlist with data stored in SQL Server 2008 Express.  The Web Server is in a DMZ.

I created the following connection string:

<add name="SnapConnectionString" providerName="System.Data.SqlClient"
    connectionString="Data Source=RESEARCH\SQLEXPRESS;Initial Catalog=Snap;Integrated Security=False;User Id='SnapWebUser';MultipleActiveResultSets=True" />

Then I created a web user "SnapWebUser" with Login Name = "NT AUTHORITY\ANONYMOUS LOGON" and with read-only access.

When the page loads on the website, I don't get the SQL Server Login page anymore; but at the same time, the dropdownlist is blank.  It's still not populating the dropdownlist with data from the SQL Server database.

Appreciate further help/assistance.

---

Marilyn Gambone

Answer 4

Please set up.

Integrated Security=True

Answer 5

Hi,

I changed Integrated Security=True; but it's still not populating the dropdownlist.

---

Marilyn Gambone

Answer 6

Hi,

Thanks.  This worked for me.  I used SQL Server Authentication, created a Login name and associated that with a database user with lesser privileges.  Had to open necessary ports in IIS, handled Windows Firewall to exempt SQL Server program and I'm in business.

Again, thanks for the tip.

---

Marilyn Gambone