Installing SQL Server Express

I have tried in vain to install the SQL Server Express on my PC. I have
follow the instructions for uninstalling old version and read the
instructions. I run the build uninstall wizard and it removes the old stuff
(including 2.0 framework) and I run the install and it requires the 2.0
framework to install. I am in a vicious cycle. In my add/remove programs
there are no 2005 programs listed period. Any help would be appreicated. I
am running 2.0.5.0215 of the framework and this is the first install of 2005
SQL server that I am aware of.
JohnSince SQL 2005 is still in beta, you'll want to post this in the Community
Newsgroups:
http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005&slcid=us
--
--Brian
(Please reply to the newsgroups only.)
"john wright" <riley_wright@.hotmail.com> wrote in message
news:eLbs9nhuFHA.908@.tk2msftngp13.phx.gbl...
>I have tried in vain to install the SQL Server Express on my PC. I have
>follow the instructions for uninstalling old version and read the
>instructions. I run the build uninstall wizard and it removes the old
>stuff (including 2.0 framework) and I run the install and it requires the
>2.0 framework to install. I am in a vicious cycle. In my add/remove
>programs there are no 2005 programs listed period. Any help would be
>appreicated. I am running 2.0.5.0215 of the framework and this is the
>first install of 2005 SQL server that I am aware of.
> John
>sql

Installing SQL Server Express

I have tried in vain to install the SQL Server Express on my PC. I have
follow the instructions for uninstalling old version and read the
instructions. I run the build uninstall wizard and it removes the old stuff
(including 2.0 framework) and I run the install and it requires the 2.0
framework to install. I am in a vicious cycle. In my add/remove programs
there are no 2005 programs listed period. Any help would be appreicated. I
am running 2.0.5.0215 of the framework and this is the first install of 2005
SQL server that I am aware of.
John
Since SQL 2005 is still in beta, you'll want to post this in the Community
Newsgroups:
http://communities.microsoft.com/new...r2005&slcid=us
--Brian
(Please reply to the newsgroups only.)
"john wright" <riley_wright@.hotmail.com> wrote in message
news:eLbs9nhuFHA.908@.tk2msftngp13.phx.gbl...
>I have tried in vain to install the SQL Server Express on my PC. I have
>follow the instructions for uninstalling old version and read the
>instructions. I run the build uninstall wizard and it removes the old
>stuff (including 2.0 framework) and I run the install and it requires the
>2.0 framework to install. I am in a vicious cycle. In my add/remove
>programs there are no 2005 programs listed period. Any help would be
>appreicated. I am running 2.0.5.0215 of the framework and this is the
>first install of 2005 SQL server that I am aware of.
> John
>

Installing SQL Server Express

I have tried in vain to install the SQL Server Express on my PC. I have
follow the instructions for uninstalling old version and read the
instructions. I run the build uninstall wizard and it removes the old stuff
(including 2.0 framework) and I run the install and it requires the 2.0
framework to install. I am in a vicious cycle. In my add/remove programs
there are no 2005 programs listed period. Any help would be appreicated. I
am running 2.0.5.0215 of the framework and this is the first install of 2005
SQL server that I am aware of.
JohnSince SQL 2005 is still in beta, you'll want to post this in the Community
Newsgroups:
http://communities.microsoft.com/ne...lcid=us

--Brian
(Please reply to the newsgroups only.)
"john wright" <riley_wright@.hotmail.com> wrote in message
news:eLbs9nhuFHA.908@.tk2msftngp13.phx.gbl...
>I have tried in vain to install the SQL Server Express on my PC. I have
>follow the instructions for uninstalling old version and read the
>instructions. I run the build uninstall wizard and it removes the old
>stuff (including 2.0 framework) and I run the install and it requires the
>2.0 framework to install. I am in a vicious cycle. In my add/remove
>programs there are no 2005 programs listed period. Any help would be
>appreicated. I am running 2.0.5.0215 of the framework and this is the
>first install of 2005 SQL server that I am aware of.
> John
>sql

Integrated Auth and SQL servers

I'm building a reporting server that will grab data off of a an old HP3000, all of that is being done in a background task (non asp.net) and uploaded to an sql server.

I'm using a web interface to allow people within the company to view the data. This will be in a single domain, behind a firewall, and will not be accessable from outside of the company.

In IIS, I have anonymous login unchecked and only Integrated Windows Auth checked. The pertinate parts of my web.config look like this:

<authenticationmode="Windows"/>

<identityimpersonate="true"/>

<authorization>

<allowusers="*"/>

<denyusers="?"/>

</authorization>

My connection string looks like this:

publicstaticstring SqlServerConnect = "Integrated Security=SSPI;Initial Catalog=[name of database];Data Source=[sqlserver IP]";

The website (for now) is on my local development computer. When I run the program everything works fine, when I attempt to view the web page on another computer, I get the following error

Server Error in '/reports' Application.

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

I'm at a loss as to how to fix this. I dont really want each user to have to enter any log in information, frankly, the permissions dont even matter in this case. My main problem is with the sql connection and trying to get adequate permissions to run queries.

Any help would be apprieciated

<deny users="?" /> denyANONYMOUS user. Ifthe permissions dont even matter and you dont really want each user to have to enter any log in information, then you can remove this <deny users="?" /> in web.config <authorization> section.

|||

Xiaohong wrote:

<deny users="?" /> denyANONYMOUS user. Ifthe permissions dont even matter and you dont really want each user to have to enter any log in information, then you can remove this <deny users="?" /> in web.config <authorization> section.

This all gets back to the security problem with the sql connection. It generates error messages when it gets to the sqlCommand.Fill(dataset) part. If I dont do some kind of authentication, the sqlconnect returns an error message. I just need enough permissions to connect to the sql server