Installing SSRS Dev Ed on Vista

I cannot get RS to install on Vista. I have a clean install of Vista with
IIS 7 installed. I was not getting the option to install SSRS when I first
installed Sql Server. I installed SP2 and still cannot get the SSRS option
to show up. How do I get SSRS installed?
Thanks in advance.
Jimif nothing is possible just go to the CD and search for sql_rs.exe setup file
try installing directly. Search this file in the setup folder.
Amarnath
"Jim" wrote:
> I cannot get RS to install on Vista. I have a clean install of Vista with
> IIS 7 installed. I was not getting the option to install SSRS when I first
> installed Sql Server. I installed SP2 and still cannot get the SSRS option
> to show up. How do I get SSRS installed?
> Thanks in advance.
> Jim|||I tried running sqlrun_rs.msi and it starts, but cannot install. I get a
screen that syas "feature selection" but the box where i'd select RS is empty.
"Amarnath" wrote:
> if nothing is possible just go to the CD and search for sql_rs.exe setup file
> try installing directly. Search this file in the setup folder.
> Amarnath
> "Jim" wrote:
> > I cannot get RS to install on Vista. I have a clean install of Vista with
> > IIS 7 installed. I was not getting the option to install SSRS when I first
> > installed Sql Server. I installed SP2 and still cannot get the SSRS option
> > to show up. How do I get SSRS installed?
> > Thanks in advance.
> > Jim|||Which version of SQL Server? Since you mentioned SP2, I assume it is SQL
Server2000 (SQL Server2005's SP2 is not released formally yet).
Reporting Services for SQL Server2000 was released long after SQL
Server2000. Usually it is a seperate installation (after SQL Server2000
installed) and on a seperate CD/installation package. SO, you need to find
the dick with SSRS2000 in it.
"Jim" <Jim@.discussions.microsoft.com> wrote in message
news:30033151-995C-4754-B37D-BC8FBD346232@.microsoft.com...
>I cannot get RS to install on Vista. I have a clean install of Vista with
> IIS 7 installed. I was not getting the option to install SSRS when I
> first
> installed Sql Server. I installed SP2 and still cannot get the SSRS
> option
> to show up. How do I get SSRS installed?
> Thanks in advance.
> Jim|||I installed the ctp version of 2005 SP2. When I install the original SQL
Server 2005 I do not get RS as an option because it doesn't recognize IIS 7.
I read online that installing SP2 CTP that RS works - but I cannot figure out
how to install it.
Jim
"Norman Yuan" wrote:
> Which version of SQL Server? Since you mentioned SP2, I assume it is SQL
> Server2000 (SQL Server2005's SP2 is not released formally yet).
> Reporting Services for SQL Server2000 was released long after SQL
> Server2000. Usually it is a seperate installation (after SQL Server2000
> installed) and on a seperate CD/installation package. SO, you need to find
> the dick with SSRS2000 in it.
> "Jim" <Jim@.discussions.microsoft.com> wrote in message
> news:30033151-995C-4754-B37D-BC8FBD346232@.microsoft.com...
> >I cannot get RS to install on Vista. I have a clean install of Vista with
> > IIS 7 installed. I was not getting the option to install SSRS when I
> > first
> > installed Sql Server. I installed SP2 and still cannot get the SSRS
> > option
> > to show up. How do I get SSRS installed?
> > Thanks in advance.
> > Jim
>
>|||if its any consolation im in exactly the same position as yourself.
sp2 CTP installed but still nothing.
Its not an sp2 thing but it apppears to have got past testing ...
ColinR
"Jim" <Jim@.discussions.microsoft.com> wrote in message
news:DA6C7DE8-D3BE-47A5-A229-03F3E52AD266@.microsoft.com...
>I installed the ctp version of 2005 SP2. When I install the original SQL
> Server 2005 I do not get RS as an option because it doesn't recognize IIS
> 7.
> I read online that installing SP2 CTP that RS works - but I cannot figure
> out
> how to install it.
> Jim
> "Norman Yuan" wrote:
>> Which version of SQL Server? Since you mentioned SP2, I assume it is SQL
>> Server2000 (SQL Server2005's SP2 is not released formally yet).
>> Reporting Services for SQL Server2000 was released long after SQL
>> Server2000. Usually it is a seperate installation (after SQL Server2000
>> installed) and on a seperate CD/installation package. SO, you need to
>> find
>> the dick with SSRS2000 in it.
>> "Jim" <Jim@.discussions.microsoft.com> wrote in message
>> news:30033151-995C-4754-B37D-BC8FBD346232@.microsoft.com...
>> >I cannot get RS to install on Vista. I have a clean install of Vista
>> >with
>> > IIS 7 installed. I was not getting the option to install SSRS when I
>> > first
>> > installed Sql Server. I installed SP2 and still cannot get the SSRS
>> > option
>> > to show up. How do I get SSRS installed?
>> > Thanks in advance.
>> > Jim
>>|||apparently can be done by enabling some 11s7 components that are not
installed by default.
I searched google and found an article in french with images and a technet
workaround that gave a list of components to install.
"Jim" <Jim@.discussions.microsoft.com> wrote in message
news:DA6C7DE8-D3BE-47A5-A229-03F3E52AD266@.microsoft.com...
>I installed the ctp version of 2005 SP2. When I install the original SQL
> Server 2005 I do not get RS as an option because it doesn't recognize IIS
> 7.
> I read online that installing SP2 CTP that RS works - but I cannot figure
> out
> how to install it.
> Jim
> "Norman Yuan" wrote:
>> Which version of SQL Server? Since you mentioned SP2, I assume it is SQL
>> Server2000 (SQL Server2005's SP2 is not released formally yet).
>> Reporting Services for SQL Server2000 was released long after SQL
>> Server2000. Usually it is a seperate installation (after SQL Server2000
>> installed) and on a seperate CD/installation package. SO, you need to
>> find
>> the dick with SSRS2000 in it.
>> "Jim" <Jim@.discussions.microsoft.com> wrote in message
>> news:30033151-995C-4754-B37D-BC8FBD346232@.microsoft.com...
>> >I cannot get RS to install on Vista. I have a clean install of Vista
>> >with
>> > IIS 7 installed. I was not getting the option to install SSRS when I
>> > first
>> > installed Sql Server. I installed SP2 and still cannot get the SSRS
>> > option
>> > to show up. How do I get SSRS installed?
>> > Thanks in advance.
>> > Jim
>>

Installing SQLNCLI

I would like to install the SQLNCLI on our IIS machine, and possibly other
workstations that need to connect to SQL Server 2005. Where is the correct
location to get the most update to date version of SQLNCLI? Also need the
installation instructions and considerations.
Thanks
Greg.
Greg,
It's here in the latest Feature Pack: -
http://www.microsoft.com/downloads/details.aspx?familyid=50b97994-8453-4998-8226-fa42ec403d17&displaylang=en
As a standalone it seems it will be in the feature pack.
Chris
"Greg Larsen" <gregalarsen@.removeit.msn.com> wrote in message
news:7BB4CC6F-73EA-4416-AB4E-6EE5BB8B19D8@.microsoft.com...
>I would like to install the SQLNCLI on our IIS machine, and possibly other
> workstations that need to connect to SQL Server 2005. Where is the
> correct
> location to get the most update to date version of SQLNCLI? Also need the
> installation instructions and considerations.
> Thanks
> Greg.

Installing SQL server2000 / windows 2003 server

I am going to start installing sql server soon, do I have to have IIS installed? Is it a requirement?
Thanks.Not at all...................U can proceed without IIS.........but need to install SP3a to run sql server 2000 on windows 2003 OS|||Oh, ok. Thanks so much.

-Laura

Installing SQL Server 2005, Detecting Installed IIS

When trying to install SQL 2005, the installation halts at "Detecting Installed IIS". From a previous forum discussion I tried disabling Norton Anti-Virus and Firewall, but the install still does not get past this point.

Please help.

have you checked the sql intall log?|||No, what should I be looking for?|||

%ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\Log\Summary.txt

for more information, BOL 2005 (on a machine that you have it installed on succesfully :) ) "Setup [SQL Server], logs"

Derek

|||

Tom, if you can search the suggested logs for the text string "return value 3" and post the +/- 10 lines on each side, we may be able to debug.

Thanks,
Samuel Lester (MSFT)

|||

I cannot find the text string "return value 3"?

Would you be opposed to me emailing the log files to you?

You can email me at sql2005_help@.yahoo.com.

Thanks for any help you can give me.

|||

Since the install seems to be hanging, the logs probably won't be of much use. Go ahead and send me the zipped up log files to samles@.microsoft.com. I can take a look, but my guess is that you may need to toggle something in your anti-virus/firewall/DNS settings. This issue has appeared a few times and the solutions have been in these areas. Sorry about not having a more direct answer.

Thanks,
Samuel Lester (MSFT)

|||I did get SQL 2005 installed! After Sam looked at the log files and could not find anything out of the norm, I made sure my machine met the requirements. With that I reinstalled .Net 2.0 and removed .Net 1.1 from my machine. Whether it was the reinstall of 2.0 or the removal of .Net 1.1; the install went without a hitch. I also did disable my firewall and anti-virus for the install.sql

Integrated Security with local SQL & IIS

I have SQL RS running on a Win 2K (dev only) machine with IIS on the same local machine. I am trying to access the reports from another computer, but am getting an error

An error has occurred during report processing. (rsProcessingAborted) Get Online Help

Cannot create a connection to data source '<Shared Data Source Name>'. (rsErrorOpeningConnection) Get Online Help

Login failed for user '<DOMAINNAME>\Guest'.

IIS and the Datasource are setup for integrated security and the Datasource is aimed at the local SQL DB. Anonymous access is turned off in IIS and it prompts for the login info when trying to access it via the web. My understanding is that this should work without problems due to IIS & SQL being on the same machine, but I can't seem to get it to work. Is there a doc somewhere or anything that goes thru the settings so I can see what I'm missing? Or does anyone have any ideas?

Thanks.

Does it work if you access the reports locally? How about using stored windows credentials for hte data source instead of integrated security?|||

Yes, the reports work fine locally. I just can't access them from another machine. I need to use integrated security due to needing the windows login to lookup the correct info in the report and to know the type of user (admin, basic, etc).

Thanks for your help.

|||

Probably a kerberos configuration issue. Try forcing NTLM. See the workaround in http://support.microsoft.com/default.aspx?scid=kb;en-us;871179

Integrated Security problem

I've been going nuts over this issue:
I have three servers (THUNDERBOLT which is the SQL Server, TOMCAT which is
the IIS server and PANTHER which is a terminal server) with SQLXML 3.0
installed on TOMCAT. I have setup a virtual template directory and can
execute a template query from IE on TOMCAT with SQL XML configured to use
integrated security. However, when I use the same URL from PANTHER, I get
'The page cannot be found'. However, if I configure SQL XML to use sa
instead of integrated security then the template query works from either
machine ok. My question is why can't I use integrated security for SQL XML
and connect from a non-local machine? (I'm using the same domain login in
both cases and the user is a domain admin) Another possible factor in this
is the fact that I'm also using a host-header with the web, but I don't
think that should matter-right?
Any suggestions would be greatly appreciated. Thanks.
When you say Integrated security, do you mean that you're trying to use the
caller's credentials (i.e. impersonation/delegation) or are you using the
same Windows account for all callers (i.e. a trusted service account)? If
the former, you're hitting problems because delegation (i.e. impersonation
across 2 physical machines) is not permitted by default - you'd need to
configure the computer and users to be trusted for delegation in A.D (search
for "delegation" in TechNet for details - it's not for the faint hearted
though!). You'll also lose out an performance gains from connection pooling.
All in all, in most cases you're better using a single Windows account for
all callers.
Hope that helps!
G
--
Graeme Malcolm
Principal Technologist
Content Master Ltd.
www.contentmaster.com
"Elmer Miller" <millere@.empireco.nospam> wrote in message
news:eCeGXS7sEHA.2688@.TK2MSFTNGP14.phx.gbl...
I've been going nuts over this issue:
I have three servers (THUNDERBOLT which is the SQL Server, TOMCAT which is
the IIS server and PANTHER which is a terminal server) with SQLXML 3.0
installed on TOMCAT. I have setup a virtual template directory and can
execute a template query from IE on TOMCAT with SQL XML configured to use
integrated security. However, when I use the same URL from PANTHER, I get
'The page cannot be found'. However, if I configure SQL XML to use sa
instead of integrated security then the template query works from either
machine ok. My question is why can't I use integrated security for SQL XML
and connect from a non-local machine? (I'm using the same domain login in
both cases and the user is a domain admin) Another possible factor in this
is the fact that I'm also using a host-header with the web, but I don't
think that should matter-right?
Any suggestions would be greatly appreciated. Thanks.
|||OK, since I am faint-hearted, I gave up on trying to use the callers
credentials and went with a single SQL account. I found that this works well
enough for my purposes. Thanks.
"Graeme Malcolm" <graemem_cm@.hotmail.com> wrote in message
news:uHtW8kGtEHA.2596@.TK2MSFTNGP15.phx.gbl...
> When you say Integrated security, do you mean that you're trying to use
> the
> caller's credentials (i.e. impersonation/delegation) or are you using the
> same Windows account for all callers (i.e. a trusted service account)? If
> the former, you're hitting problems because delegation (i.e. impersonation
> across 2 physical machines) is not permitted by default - you'd need to
> configure the computer and users to be trusted for delegation in A.D
> (search
> for "delegation" in TechNet for details - it's not for the faint hearted
> though!). You'll also lose out an performance gains from connection
> pooling.
> All in all, in most cases you're better using a single Windows account for
> all callers.
> Hope that helps!
> G
> --
> --
> Graeme Malcolm
> Principal Technologist
> Content Master Ltd.
> www.contentmaster.com
>
> "Elmer Miller" <millere@.empireco.nospam> wrote in message
> news:eCeGXS7sEHA.2688@.TK2MSFTNGP14.phx.gbl...
> I've been going nuts over this issue:
> I have three servers (THUNDERBOLT which is the SQL Server, TOMCAT which is
> the IIS server and PANTHER which is a terminal server) with SQLXML 3.0
> installed on TOMCAT. I have setup a virtual template directory and can
> execute a template query from IE on TOMCAT with SQL XML configured to use
> integrated security. However, when I use the same URL from PANTHER, I get
> 'The page cannot be found'. However, if I configure SQL XML to use sa
> instead of integrated security then the template query works from either
> machine ok. My question is why can't I use integrated security for SQL XML
> and connect from a non-local machine? (I'm using the same domain login in
> both cases and the user is a domain admin) Another possible factor in this
> is the fact that I'm also using a host-header with the web, but I don't
> think that should matter-right?
> Any suggestions would be greatly appreciated. Thanks.
>
>

Integrated Security in a Workgroup?

The A\ASPNET and B\ASPNET machine accounts are created by IIS (I think) --
at least I know that I did NOT create them. These are the accounts used by
IIS when executing ASP pages. Since these accounts are not created by me I
don't know the passwords -- and I can't just change them in XP because then
IIS will likely fail due to using the old password. Perhaps I can change
the default ASP account used by IIS on both machines -- then I can create
local accounts with the same username and password.
Thanks for the suggestion.
Bill
"Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
news:uOFYrdRuDHA.3144@.tk2msftngp13.phx.gbl...

quote:

---

> I believe that you do this without specifying the A\ or B\.
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no

---

rights.

quote:

---

> Please reply to the newsgroups only, thanks.
> "Bill Cohagan" <bill@.teraXNOSPAMXquest.com> wrote in message
> news:#aPrRKOuDHA.4056@.TK2MSFTNGP11.phx.gbl...
> A\ASPNET
the[QUOTE]
> A
and[QUOTE]
> an
only.[QUOTE]
the[QUOTE]
> SQL
> rights.
>

---

Kevin
Thanks for the response. Please see my reply to dybing regarding
passwords being problematic.
Bill
"Kevin McDonnell [MSFT]" <kevmc@.online.microsoft.com> wrote in message
news:uN4DrXRuDHA.1360@.cpmsftngxa06.phx.gbl...

quote:

---

> See if you can make a Trusted Connection using SQL. If the passwords are
> the same, then this should work.
> Use ISQL.exe
> ISQL -SSQLServerNameHere -E -Q"select @.@.version"
> This should return the version of SQL 2000.
> If this works then, we know the security is working, it may be a
> configuration issue with ASP.NET.
>
> Thanks,
> Kevin McDonnell
> Microsoft Corporation
> This posting is provided AS IS with no warranties, and confers no rights.
>
>

---

|||No, sorry, what I meant was that when you set up the SQL Server permissions,
try it without including the A\ or B\.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
"Bill Cohagan" <bill@.teraXNOSPAMXquest.com> wrote in message
news:utxj$XduDHA.1596@.TK2MSFTNGP10.phx.gbl...

quote:

---

> The A\ASPNET and B\ASPNET machine accounts are created by IIS (I think) --
> at least I know that I did NOT create them. These are the accounts used by
> IIS when executing ASP pages. Since these accounts are not created by me I
> don't know the passwords -- and I can't just change them in XP because

---

then

quote:

---

> IIS will likely fail due to using the old password. Perhaps I can change
> the default ASP account used by IIS on both machines -- then I can create
> local accounts with the same username and password.
> Thanks for the suggestion.
> Bill
> "Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
> news:uOFYrdRuDHA.3144@.tk2msftngp13.phx.gbl...
> rights.
> the
> and
> only.
> the
the[QUOTE]
>

---

|||Since I'm using integrated security I must select an existing NT user; thus
I can't specify a user, ASPNET (or whatever), unless that user exists as a
local user on the machine. I can of course create such a user, but then I've
got the password problem I already mentioned. Have I misunderstood your
suggestion?
Bill
"Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
news:%23nPgnyduDHA.2148@.TK2MSFTNGP12.phx.gbl...

quote:

---

> No, sorry, what I meant was that when you set up the SQL Server

---

permissions,

quote:

---

> try it without including the A\ or B\.
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no

---

rights.

quote:

---

> Please reply to the newsgroups only, thanks.
> "Bill Cohagan" <bill@.teraXNOSPAMXquest.com> wrote in message
> news:utxj$XduDHA.1596@.TK2MSFTNGP10.phx.gbl...
think) --[QUOTE]
by[QUOTE]
I[QUOTE]
> then
change[QUOTE]
create[QUOTE]
that[QUOTE]
B[QUOTE]
message[QUOTE]
duplicate[QUOTE]
> the
>

---

|||Hmm, I had assumed, like Kevin mentioned earlier, that if you used those
workgroup users, where the only thing that changed was the name of the
workgroup, it would work. I've done similar sorts of things with accounts
crossing different domains before and figured this would work as well. If
not, then your problem is beyond what I can help with off the top of my
head, and I don't have workgroup machines here that I can test on. Sorry!
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
"Bill Cohagan" <bill@.teraXNOSPAMXquest.com> wrote in message
news:eXwPQHeuDHA.1888@.TK2MSFTNGP10.phx.gbl...

quote:

---

> Since I'm using integrated security I must select an existing NT user;

---

thus

quote:

---

> I can't specify a user, ASPNET (or whatever), unless that user exists as a
> local user on the machine. I can of course create such a user, but then

---

I've

quote:

---

> got the password problem I already mentioned. Have I misunderstood your
> suggestion?
> Bill
> "Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
> news:%23nPgnyduDHA.2148@.TK2MSFTNGP12.phx.gbl...
> permissions,
> rights.
> think) --
used[QUOTE]
> by
me[QUOTE]
> I
> change
> create
> that
machine[QUOTE]
> B
purposes[QUOTE]
> message
> duplicate
on[QUOTE]
no[QUOTE]
>

---

|||Please let me know if you're still having a problem with this and I'll
request a couple of workgroup machines from our lab this week and try it
myself. You can reach me directly by removing the "online." from my posting
address.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
"Bill Cohagan" <bill@.teraXNOSPAMXquest.com> wrote in message
news:eXwPQHeuDHA.1888@.TK2MSFTNGP10.phx.gbl...

quote:

---

> Since I'm using integrated security I must select an existing NT user;

---

thus

quote:

---

> I can't specify a user, ASPNET (or whatever), unless that user exists as a
> local user on the machine. I can of course create such a user, but then

---

I've

quote:

---

> got the password problem I already mentioned. Have I misunderstood your
> suggestion?
> Bill
> "Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
> news:%23nPgnyduDHA.2148@.TK2MSFTNGP12.phx.gbl...
> permissions,
> rights.
> think) --
used[QUOTE]
> by
me[QUOTE]
> I
> change
> create
> that
machine[QUOTE]
> B
purposes[QUOTE]
> message
> duplicate
on[QUOTE]
no[QUOTE]
>

---

|||OK, I think I've got it working. I discovered (via KB #315158) how to
set the account and password used by IIS via attributes in the
processModel element of the machine.config file. All I needed to do was
1.) Reset the password of the <machine>\ASPNET account to a common value
on both machines.
2.) Edit the machine.config file on both machines to reflect the new
common password.
I'd already added the ASPNET account as a login on the SQL server. Since
now the A\ASPNET and B\ASPNET have common login names AND passwords I
can apparently access the SQL server on machine B via the A\ASPNET
account on machine A. This solves my problem.
Bill
"Bill Cohagan" <bill@.teraXNOSPAMXquest.com> wrote in message
news:eXwPQHeuDHA.1888@.TK2MSFTNGP10.phx.gbl...

quote:

---

> Since I'm using integrated security I must select an existing NT user;

---

thus

quote:

---

> I can't specify a user, ASPNET (or whatever), unless that user exists as a
> local user on the machine. I can of course create such a user, but then

---

I've

quote:

---

> got the password problem I already mentioned. Have I misunderstood your
> suggestion?
> Bill
> "Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
> news:%23nPgnyduDHA.2148@.TK2MSFTNGP12.phx.gbl...
> permissions,
> rights.
> think) --
used[QUOTE]
> by
me[QUOTE]
> I
> change
> create
> that
machine[QUOTE]
> B
purposes[QUOTE]
> message
> duplicate
on[QUOTE]
no[QUOTE]
>

---

Integrated security for web apps

We have setup IIS and SQL Server for integrated security which works fine as
long as SQL Server is on the same box as IIS.
Is it possible to use the Windows login security credentials that IIS
captures to access SQL Server when it is on a different box?
Many Thanks.If you're using NT Challenge Response and Trusted Authentication, you're
problem is documented here.
176380 How To Use ASP with a SQL Trusted Connection with Guest Account
http://support.microsoft.com/?id=176380
307002 PRB: ASP/ODBC/SQL Server Error 0x80040E4D "Login Failed for User
http://support.microsoft.com/?id=307002
175671 PRB: 80004005 ConnectionOpen (CreateFile()) Error Accessing SQL
http://support.microsoft.com/?id=175671
Depending on the requirements and your environment, if you want to pass the
credentials from the web user to IIS to SQL, then
you'll need to be in a Windows 2000 AD environment and use Security
Delegation to make this work.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||We are able to accomplish this w/o AD, and for an Internet application I was
always under the impression that AD was not a good idea. The main issue we
found was getting the connection string right, and making sure the users are
syncronized between the machines. We created the IUSR on the SQL box with
the same password as on the IIS box. Make sure to either get or change the
IUSR password in the Meta base, Local Users/Groups and not sure if it's the
same as the meta base but changed it in the ISM as well.
Dan
"Kevin McDonnell [MSFT]" wrote:

> If you're using NT Challenge Response and Trusted Authentication, you're
> problem is documented here.
>
> 176380 How To Use ASP with a SQL Trusted Connection with Guest Account
> http://support.microsoft.com/?id=176380
> 307002 PRB: ASP/ODBC/SQL Server Error 0x80040E4D "Login Failed for User
> http://support.microsoft.com/?id=307002
> 175671 PRB: 80004005 ConnectionOpen (CreateFile()) Error Accessing SQL
> http://support.microsoft.com/?id=175671
> Depending on the requirements and your environment, if you want to pass th
e
> credentials from the web user to IIS to SQL, then
> you'll need to be in a Windows 2000 AD environment and use Security
> Delegation to make this work.
>
> Thanks,
> Kevin McDonnell
> Microsoft Corporation
> This posting is provided AS IS with no warranties, and confers no rights.
>
>

Integrated Security across machines

I have two machines called MA and MB. MA is hosting IIS and MB is hosting SQL
Server. I'd like to use integrated security to access SQL Server in my
application hosted in IIS. How should I configure the SQL Server so that it
can recognize the Network Service account in another machine?
Thanks.
Daniel
Hello Daniel,
I understand that you'd like to web application could access SQL Server by
using Network service account. If I'm off-base, please let me know.
Usually it is suggested that you use a domain account under the situation
in the application pool of IIS, and configure "impersonate" to false in
web.config of ASP.net application.
The other opiton is configure "impersonate" to true, and grant each client
domain user proper permission on remote SQL Server. Please note under this
situation, IIS has to be use Kerberos authentication and it shall be
enabled to "delegate" the user credential to remote SQL server.
891031Common security issues when you access remote resources from ASP.NET
applications
http://support.microsoft.com/default.aspx?scid=kb;EN-US;891031
Building Secure ASP.NET Applications: Authentication, Authorization, and
Secure Communication
http://msdn2.microsoft.com/en-us/library/aa302387.aspx
How to configure an ASP.NET application for a delegation scenario
http://support.microsoft.com/default.aspx?scid=kb;EN-US;810572
It is not recommended to use Network Service account under the situation.
Since Network service account actually use machine account to access remote
server, you may try to add the "domain\server$" to SQL Server login and
grant it some permission. However, this may not work as expected and may
bring security hole.
If you have any comments or feedback, please feel free to let me know.
Thank you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Using a domain account is a nice way I think. But we have one problem that is
the company IT policy states that each AD account must bind to an actual
human user. So up to now, we can't create AD accounts for our system. And AD
account for user has a policy of changing password every 45 days. I think
there must be a good reason for the company to establish this policy, may be
for the sake of SOX. Do you know the reason for such policy? How do other
people work around such problems?
Thanks.
Daniel
|||Many companies will also have policies for service accounts
with service accounts being in a different OU from user
accounts. They should have some requirements for service
accounts and what accounts services will use.
-Sue
On Wed, 28 Feb 2007 01:13:13 -0800, Daniel
<daniel.shen@.newsgroup.nospam> wrote:

>Using a domain account is a nice way I think. But we have one problem that is
>the company IT policy states that each AD account must bind to an actual
>human user. So up to now, we can't create AD accounts for our system. And AD
>account for user has a policy of changing password every 45 days. I think
>there must be a good reason for the company to establish this policy, may be
>for the sake of SOX. Do you know the reason for such policy? How do other
>people work around such problems?
>Thanks.
>Daniel
|||Hello Daniel,
I agree that this policy is for security purpose. However, as Sue
mentioned, it makes sense to have different policy to have service
accounts. Or you have to change the password of service account accordingly
and restart services when necessary. This could be done by a script or
manually.
Please let's know if you have further questions or concerns, please feel
free to let's know. Thank you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====
|||Hello Daniel,
Just want to check in if you have further questions on the issue. Please
feel free to post back if you need any help.
Thanks & Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

Integrated Security across machines

I have two machines called MA and MB. MA is hosting IIS and MB is hosting SQ
L
Server. I'd like to use integrated security to access SQL Server in my
application hosted in IIS. How should I configure the SQL Server so that it
can recognize the Network Service account in another machine?
Thanks.
DanielHello Daniel,
I understand that you'd like to web application could access SQL Server by
using Network service account. If I'm off-base, please let me know.
Usually it is suggested that you use a domain account under the situation
in the application pool of IIS, and configure "impersonate" to false in
web.config of ASP.net application.
The other opiton is configure "impersonate" to true, and grant each client
domain user proper permission on remote SQL Server. Please note under this
situation, IIS has to be use Kerberos authentication and it shall be
enabled to "delegate" the user credential to remote SQL server.
891031 Common security issues when you access remote resources from ASP.NET
applications
http://support.microsoft.com/defaul...kb;EN-US;891031
Building Secure ASP.NET Applications: Authentication, Authorization, and
Secure Communication
http://msdn2.microsoft.com/en-us/library/aa302387.aspx
How to configure an ASP.NET application for a delegation scenario
http://support.microsoft.com/defaul...kb;EN-US;810572
It is not recommended to use Network Service account under the situation.
Since Network service account actually use machine account to access remote
server, you may try to add the "domain\server$" to SQL Server login and
grant it some permission. However, this may not work as expected and may
bring security hole.
If you have any comments or feedback, please feel free to let me know.
Thank you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
========================================
==========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications
<http://msdn.microsoft.com/subscript...ps/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscript...rt/default.aspx>.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.|||Using a domain account is a nice way I think. But we have one problem that i
s
the company IT policy states that each AD account must bind to an actual
human user. So up to now, we can't create AD accounts for our system. And AD
account for user has a policy of changing password every 45 days. I think
there must be a good reason for the company to establish this policy, may be
for the sake of SOX. Do you know the reason for such policy? How do other
people work around such problems?
Thanks.
Daniel|||Many companies will also have policies for service accounts
with service accounts being in a different OU from user
accounts. They should have some requirements for service
accounts and what accounts services will use.
-Sue
On Wed, 28 Feb 2007 01:13:13 -0800, Daniel
<daniel.shen@.newsgroup.nospam> wrote:

>Using a domain account is a nice way I think. But we have one problem that
is
>the company IT policy states that each AD account must bind to an actual
>human user. So up to now, we can't create AD accounts for our system. And A
D
>account for user has a policy of changing password every 45 days. I think
>there must be a good reason for the company to establish this policy, may b
e
>for the sake of SOX. Do you know the reason for such policy? How do other
>people work around such problems?
>Thanks.
>Daniel|||Hello Daniel,
I agree that this policy is for security purpose. However, as Sue
mentioned, it makes sense to have different policy to have service
accounts. Or you have to change the password of service account accordingly
and restart services when necessary. This could be done by a script or
manually.
Please let's know if you have further questions or concerns, please feel
free to let's know. Thank you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
========================================
==============|||Hello Daniel,
Just want to check in if you have further questions on the issue. Please
feel free to post back if you need any help.
Thanks & Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.

Installing Sql Reporting services on a seperate website

Hi
I am installing SQL reporting services. By Default the SQL reporting
services gets installed on the Default Website.
My IIS 6.0 website is running as a seperate website and not on Default Web
Site.
Is it possible to install SQL reporting services on a separate website other
than the Default Website?
Any help is appreciated.
Regards
-RizI don't know the answer to your question however, if it does install the
Reporting services to the default website, can't you just create a new
virtual directory on your seperate website pointing at the same directory and
with the same setup?
"Riz" wrote:
> Hi
> I am installing SQL reporting services. By Default the SQL reporting
> services gets installed on the Default Website.
> My IIS 6.0 website is running as a seperate website and not on Default Web
> Site.
> Is it possible to install SQL reporting services on a separate website other
> than the Default Website?
> Any help is appreciated.
> Regards
> -Riz|||Setup does not allow you to install to anything but the default website.
Once installed you can move it to another website. You should follow these
directions to move the vdir:
http://www.sqljunkies.com/HowTo/525B575A-7F61-483A-AC8F-FEC700C34674.scuk
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Riz" <Riz@.discussions.microsoft.com> wrote in message
news:B4B60697-70F8-42E2-BC59-E8C24BA3BD21@.microsoft.com...
> Hi
> I am installing SQL reporting services. By Default the SQL reporting
> services gets installed on the Default Website.
> My IIS 6.0 website is running as a seperate website and not on Default Web
> Site.
> Is it possible to install SQL reporting services on a separate website
> other
> than the Default Website?
> Any help is appreciated.
> Regards
> -Riz

installing sql 2005 standard on vista home premium

I have not been able to get iis to be seen correctly. I have turned on every service with IIS7 available and still get warning IIS in not running. I have changed computer name to all caps and I am running on admin account. I see IIS7 when I run localhost. What is wrong here. When I go on to install system I get stuck at detecting installed IIS. As I move forward with install owc, DB services,Notification, Intagrated, and workstation components all fail. I cant move onto sp2 because nothing is installed. I have worked on this for months off and on and now I have to have it running for deadline. Any help would be appreciated. I also have VS2005 and office 2007 on this system. I have worked on this the past two days solid and I have to have it now.

Jeff

when the install fails, what do you see in the files under the log folder under setup bootstrap?|||

Thanks Meher,

I had to uninstall all of the office components and then I was able to get past OWC11. Then I still failed with all the others. I then installed sp2. I then went back and did a mimimal install and it worked. Then I went back and reran sp2. Then I went back and did a complete reinstall and reran sp2. I now have DB on vista. On troublesome problem still is IIS7 I enabled everything I could restarted it and still system did not see it. Different forum and different issue I suspect.

Again Thanks for the williness to help.

Jeff

It would be nice put out updated install directions for sql 2005 standard(different flavors) on VISTA(different flavors). Maybe they did but hours of searching did not produce them.

Installing SQL 2005 Express w/ Advance feature

I am trying to install SQL 2005 Express w/ Advance feature. I
installed IIS with ASP.NET but the installation still complain I don't
have IIS installed or enabled. Do I miss anything else?
Your installation sequence should be as follows:
1) IIS
2) .NET Framework 2.0
3) SQL Server 2005 Express
If you were not able to do this in sequence, I would recommend running
aspnet_regiis.exe -i to install ASP.NET 2.0 in IIS. Make sure you are
running the correct version which is v2.0
"melon" <elty123@.gmail.com> wrote in message
news:1184014812.202660.102940@.57g2000hsv.googlegro ups.com...
>I am trying to install SQL 2005 Express w/ Advance feature. I
> installed IIS with ASP.NET but the installation still complain I don't
> have IIS installed or enabled. Do I miss anything else?
>
|||I am using Vistaand using .NET framework 3.0. Does it matter?
I also verfied that my IIS is running with ASP.NET enabled.
On Jul 10, 1:10 am, "bass_player [SBS-MVP]" <bass_pla...@.mvps.org>
wrote:
> Your installation sequence should be as follows:
> 1) IIS
> 2) .NET Framework 2.0
> 3) SQL Server 2005 Express
> If you were not able to do this in sequence, I would recommend running
> aspnet_regiis.exe -i to install ASP.NET 2.0 in IIS. Make sure you are
> running the correct version which is v2.0
> "melon" <elty...@.gmail.com> wrote in message
> news:1184014812.202660.102940@.57g2000hsv.googlegro ups.com...
>
>
> - Show quoted text -

Installing SQL 2005 Express w/ Advance feature

I am trying to install SQL 2005 Express w/ Advance feature. I
installed IIS with ASP.NET but the installation still complain I don't
have IIS installed or enabled. Do I miss anything else?Your installation sequence should be as follows:
1) IIS
2) .NET Framework 2.0
3) SQL Server 2005 Express
If you were not able to do this in sequence, I would recommend running
aspnet_regiis.exe -i to install ASP.NET 2.0 in IIS. Make sure you are
running the correct version which is v2.0
"melon" <elty123@.gmail.com> wrote in message
news:1184014812.202660.102940@.57g2000hsv.googlegroups.com...
>I am trying to install SQL 2005 Express w/ Advance feature. I
> installed IIS with ASP.NET but the installation still complain I don't
> have IIS installed or enabled. Do I miss anything else?
>|||I am using Vistaand using .NET framework 3.0. Does it matter?
I also verfied that my IIS is running with ASP.NET enabled.
On Jul 10, 1:10 am, "bass_player [SBS-MVP]" <bass_pla...@.mvps.org>
wrote:
> Your installation sequence should be as follows:
> 1) IIS
> 2) .NET Framework 2.0
> 3) SQL Server 2005 Express
> If you were not able to do this in sequence, I would recommend running
> aspnet_regiis.exe -i to install ASP.NET 2.0 in IIS. Make sure you are
> running the correct version which is v2.0
> "melon" <elty...@.gmail.com> wrote in message
> news:1184014812.202660.102940@.57g2000hsv.googlegroups.com...
>
> >I am trying to install SQL 2005 Express w/ Advance feature. I
> > installed IIS with ASP.NET but the installation still complain I don't
> > have IIS installed or enabled. Do I miss anything else... Hide quoted text -
> - Show quoted text -

Installing SQL 2005 Express w/ Advance feature

I am trying to install SQL 2005 Express w/ Advance feature. I
installed IIS with ASP.NET but the installation still complain I don't
have IIS installed or enabled. Do I miss anything else?Your installation sequence should be as follows:
1) IIS
2) .NET Framework 2.0
3) SQL Server 2005 Express
If you were not able to do this in sequence, I would recommend running
aspnet_regiis.exe -i to install ASP.NET 2.0 in IIS. Make sure you are
running the correct version which is v2.0
"melon" <elty123@.gmail.com> wrote in message
news:1184014812.202660.102940@.57g2000hsv.googlegroups.com...
>I am trying to install SQL 2005 Express w/ Advance feature. I
> installed IIS with ASP.NET but the installation still complain I don't
> have IIS installed or enabled. Do I miss anything else?
>|||I am using Vistaand using .NET framework 3.0. Does it matter?
I also verfied that my IIS is running with ASP.NET enabled.
On Jul 10, 1:10 am, "bass_player [SBS-MVP]" <bass_pla...@.mvps.org>
wrote:
> Your installation sequence should be as follows:
> 1) IIS
> 2) .NET Framework 2.0
> 3) SQL Server 2005 Express
> If you were not able to do this in sequence, I would recommend running
> aspnet_regiis.exe -i to install ASP.NET 2.0 in IIS. Make sure you are
> running the correct version which is v2.0
> "melon" <elty...@.gmail.com> wrote in message
> news:1184014812.202660.102940@.57g2000hsv.googlegroups.com...
>
>
> - Show quoted text -

Installing SQL 2005 Beta

I am having a problem install the software, it tells me the install is
already running, or it gets hung on checking IIS.
Any help available.
Thanks
DeeWhy do you want to install the BETA ? This is not recommended, though
there is a RTM available ?!
HTH, jens Suessmeyer.|||I think installing the beta once RTM is available violates the EULA. Why on
earth would you want the beta software?
"Dee" <Dee@.discussions.microsoft.com> wrote in message
news:D620670E-DF08-433D-91D7-26F34B9E70C7@.microsoft.com...
>I am having a problem install the software, it tells me the install is
> already running, or it gets hung on checking IIS.
> Any help available.
> Thanks
> Dee|||Where can I get the RTM, I got the beta CD from the web because I have the
Beta Visual Studio 2005.
Help.
Dee
"Jens" wrote:

> Why do you want to install the BETA ? This is not recommended, though
> there is a RTM available ?!
> HTH, jens Suessmeyer.
>|||http://www.programmersparadise.com/...ductID=M47+304Z
"Dee" <Dee@.discussions.microsoft.com> wrote in message
news:91FBC6F2-99C2-4BC3-9351-209BD44F1814@.microsoft.com...
> Where can I get the RTM, I got the beta CD from the web because I have
> the
> Beta Visual Studio 2005.
> Help.
> Dee
> "Jens" wrote:
>