install SQL on WinXP: iis

Showing posts with label iis. Show all posts

Tuesday, March 20, 2012

Can not access SQL Server

Hi,
In this case, the environment is:
Machine A: SQL Server 2000 SP3 on Windows 2003 SP1. (IP Address: 10.35.3.43)
Machine B: IIS Server on Windows XP SP2, an ASP.Net application, a WinForms
application. (In the same subnet)
In the WinForms application, I can connect to the SQL server sucessfully,
but in the ASP.Net application, I can not, the error message say that "SQL
Server does not exist, or access deny".
The code is the same in ASP.Net application and WinForms application:
==>>
string cnstring = "user id=sa;data source='10.35.3.43';persist security
info=True;initial catalog=MyDB;password='MyPassword'";
string cmdstring = "SELECT Count(*) FROM FunctionCode";
System.Data.SqlClient.SqlConnection cn = new
System.Data.SqlClient.SqlConnection(cnstring);
System.Data.SqlClient.SqlCommand cmd = new
System.Data.SqlClient.SqlCommand(cmdstring, cn);
cn.Open(); //Suceeds in WinForm, but fails in ASP.Net
int count = (int)cmd.ExecuteScalar();
cn.Close();
Response.Write(count.ToString());
<<==
How to fix this problem?
Thanks in advance
KevinRun a profiler trace on the SQL server to see if the login attempt is making
it the the SQL server. This will give you insight in to where to look next
for the problem, network or program.
--
Nik Marshall-Blank MCSD/MCDBA
"Kevin Dai" <Kevin_Dzy@.Hotmail.com> wrote in message
news:%23g6oPUDtFHA.1252@.TK2MSFTNGP09.phx.gbl...
> Hi,
> In this case, the environment is:
> Machine A: SQL Server 2000 SP3 on Windows 2003 SP1. (IP Address:
> 10.35.3.43)
> Machine B: IIS Server on Windows XP SP2, an ASP.Net application, a
> WinForms application. (In the same subnet)
> In the WinForms application, I can connect to the SQL server sucessfully,
> but in the ASP.Net application, I can not, the error message say that "SQL
> Server does not exist, or access deny".
> The code is the same in ASP.Net application and WinForms application:
> ==>>
> string cnstring = "user id=sa;data source='10.35.3.43';persist security
> info=True;initial catalog=MyDB;password='MyPassword'";
> string cmdstring = "SELECT Count(*) FROM FunctionCode";
> System.Data.SqlClient.SqlConnection cn = new
> System.Data.SqlClient.SqlConnection(cnstring);
> System.Data.SqlClient.SqlCommand cmd = new
> System.Data.SqlClient.SqlCommand(cmdstring, cn);
> cn.Open(); //Suceeds in WinForm, but fails in ASP.Net
> int count = (int)cmd.ExecuteScalar();
> cn.Close();
> Response.Write(count.ToString());
> <<==> How to fix this problem?
> Thanks in advance
> Kevin
>|||It's not network problem, I can connect through a WinForm application. I
found something in the following article, I try but still doesn't work.
http://support.microsoft.com/default.aspx?scid=kb;en-us;888228
By the way, the two machines are in different domain.
Regars
Kevin
"Nik Marshall-Blank" <Nik@.Operatelecom.com> Ð´ÈëÏûÏ¢ÐÂÎÅ:4iSTe.305886$WN5.7191@.fe02.news.easynews.com...
> Run a profiler trace on the SQL server to see if the login attempt is
> making it the the SQL server. This will give you insight in to where to
> look next for the problem, network or program.
> --
> Nik Marshall-Blank MCSD/MCDBA
> "Kevin Dai" <Kevin_Dzy@.Hotmail.com> wrote in message
> news:%23g6oPUDtFHA.1252@.TK2MSFTNGP09.phx.gbl...
>> Hi,
>> In this case, the environment is:
>> Machine A: SQL Server 2000 SP3 on Windows 2003 SP1. (IP Address:
>> 10.35.3.43)
>> Machine B: IIS Server on Windows XP SP2, an ASP.Net application, a
>> WinForms application. (In the same subnet)
>> In the WinForms application, I can connect to the SQL server sucessfully,
>> but in the ASP.Net application, I can not, the error message say that
>> "SQL Server does not exist, or access deny".
>> The code is the same in ASP.Net application and WinForms application:
>> ==>>
>> string cnstring = "user id=sa;data source='10.35.3.43';persist security
>> info=True;initial catalog=MyDB;password='MyPassword'";
>> string cmdstring = "SELECT Count(*) FROM FunctionCode";
>> System.Data.SqlClient.SqlConnection cn = new
>> System.Data.SqlClient.SqlConnection(cnstring);
>> System.Data.SqlClient.SqlCommand cmd = new
>> System.Data.SqlClient.SqlCommand(cmdstring, cn);
>> cn.Open(); //Suceeds in WinForm, but fails in ASP.Net
>> int count = (int)cmd.ExecuteScalar();
>> cn.Close();
>> Response.Write(count.ToString());
>> <<==>> How to fix this problem?
>> Thanks in advance
>> Kevin
>>
>|||I would expect that to apply to both connections from Winform and ASP.NET.
Can you perform a profile trace on to see what credentials are being used
for the failing connection.
--
Nik Marshall-Blank MCSD/MCDBA
"Kevin Dai" <Kevin_Dzy@.Hotmail.com> wrote in message
news:%237j8zSFtFHA.2792@.tk2msftngp13.phx.gbl...
> It's not network problem, I can connect through a WinForm application. I
> found something in the following article, I try but still doesn't work.
> http://support.microsoft.com/default.aspx?scid=kb;en-us;888228
> By the way, the two machines are in different domain.
> Regars
> Kevin
>
>
> "Nik Marshall-Blank" <Nik@.Operatelecom.com>
> Ð´ÈëÏûÏ¢ÐÂÎÅ:4iSTe.305886$WN5.7191@.fe02.news.easynews.com...
>> Run a profiler trace on the SQL server to see if the login attempt is
>> making it the the SQL server. This will give you insight in to where to
>> look next for the problem, network or program.
>> --
>> Nik Marshall-Blank MCSD/MCDBA
>> "Kevin Dai" <Kevin_Dzy@.Hotmail.com> wrote in message
>> news:%23g6oPUDtFHA.1252@.TK2MSFTNGP09.phx.gbl...
>> Hi,
>> In this case, the environment is:
>> Machine A: SQL Server 2000 SP3 on Windows 2003 SP1. (IP Address:
>> 10.35.3.43)
>> Machine B: IIS Server on Windows XP SP2, an ASP.Net application, a
>> WinForms application. (In the same subnet)
>> In the WinForms application, I can connect to the SQL server
>> sucessfully, but in the ASP.Net application, I can not, the error
>> message say that "SQL Server does not exist, or access deny".
>> The code is the same in ASP.Net application and WinForms application:
>> ==>>
>> string cnstring = "user id=sa;data source='10.35.3.43';persist
>> security info=True;initial catalog=MyDB;password='MyPassword'";
>> string cmdstring = "SELECT Count(*) FROM FunctionCode";
>> System.Data.SqlClient.SqlConnection cn = new
>> System.Data.SqlClient.SqlConnection(cnstring);
>> System.Data.SqlClient.SqlCommand cmd = new
>> System.Data.SqlClient.SqlCommand(cmdstring, cn);
>> cn.Open(); //Suceeds in WinForm, but fails in ASP.Net
>> int count = (int)cmd.ExecuteScalar();
>> cn.Close();
>> Response.Write(count.ToString());
>> <<==>> How to fix this problem?
>> Thanks in advance
>> Kevin
>>
>>
>|||Hi, Nik,
I use profile trace, but there is no login or login fail events when using
ASP.Net. There is login even when using WinForm.
The source code and connection string are the same in WinForm and ASP.Net.
"Nik Marshall-Blank" <Nik@.Operatelecom.com> Ð´ÈëÏûÏ¢ÐÂÎÅ:XrTTe.308487$kM5.134787@.fe01.news.easynews.com...
>I would expect that to apply to both connections from Winform and ASP.NET.
>Can you perform a profile trace on to see what credentials are being used
>for the failing connection.
> --
> Nik Marshall-Blank MCSD/MCDBA
> "Kevin Dai" <Kevin_Dzy@.Hotmail.com> wrote in message
> news:%237j8zSFtFHA.2792@.tk2msftngp13.phx.gbl...
>> It's not network problem, I can connect through a WinForm application. I
>> found something in the following article, I try but still doesn't work.
>> http://support.microsoft.com/default.aspx?scid=kb;en-us;888228
>> By the way, the two machines are in different domain.
>> Regars
>> Kevin
>>
>>
>> "Nik Marshall-Blank" <Nik@.Operatelecom.com> Ð´ÈëÏûÏ¢ÐÂÎÅ:4iSTe.305886$WN5.7191@.fe02.news.easynews.com...
>> Run a profiler trace on the SQL server to see if the login attempt is
>> making it the the SQL server. This will give you insight in to where to
>> look next for the problem, network or program.
>> --
>> Nik Marshall-Blank MCSD/MCDBA
>> "Kevin Dai" <Kevin_Dzy@.Hotmail.com> wrote in message
>> news:%23g6oPUDtFHA.1252@.TK2MSFTNGP09.phx.gbl...
>> Hi,
>> In this case, the environment is:
>> Machine A: SQL Server 2000 SP3 on Windows 2003 SP1. (IP Address:
>> 10.35.3.43)
>> Machine B: IIS Server on Windows XP SP2, an ASP.Net application, a
>> WinForms application. (In the same subnet)
>> In the WinForms application, I can connect to the SQL server
>> sucessfully, but in the ASP.Net application, I can not, the error
>> message say that "SQL Server does not exist, or access deny".
>> The code is the same in ASP.Net application and WinForms application:
>> ==>>
>> string cnstring = "user id=sa;data source='10.35.3.43';persist
>> security info=True;initial catalog=MyDB;password='MyPassword'";
>> string cmdstring = "SELECT Count(*) FROM FunctionCode";
>> System.Data.SqlClient.SqlConnection cn = new
>> System.Data.SqlClient.SqlConnection(cnstring);
>> System.Data.SqlClient.SqlCommand cmd = new
>> System.Data.SqlClient.SqlCommand(cmdstring, cn);
>> cn.Open(); //Suceeds in WinForm, but fails in ASP.Net
>> int count = (int)cmd.ExecuteScalar();
>> cn.Close();
>> Response.Write(count.ToString());
>> <<==>> How to fix this problem?
>> Thanks in advance
>> Kevin
>>
>>
>>
>|||Ok now we're getting somewhere, not sure where yet but we now going to look
at the ASP.Net server more closely.
But first just try adding the account under which ASP.Net runs as a login on
the SQL Server and see if it connects.
--
Nik Marshall-Blank MCSD/MCDBA
"Kevin Dai" <Kevin_Dzy@.Hotmail.com> wrote in message
news:eYSsLGGtFHA.3908@.tk2msftngp13.phx.gbl...
> Hi, Nik,
> I use profile trace, but there is no login or login fail events when using
> ASP.Net. There is login even when using WinForm.
> The source code and connection string are the same in WinForm and ASP.Net.
>
>
> "Nik Marshall-Blank" <Nik@.Operatelecom.com>
> Ð´ÈëÏûÏ¢ÐÂÎÅ:XrTTe.308487$kM5.134787@.fe01.news.easynews.com...
>>I would expect that to apply to both connections from Winform and ASP.NET.
>>Can you perform a profile trace on to see what credentials are being used
>>for the failing connection.
>> --
>> Nik Marshall-Blank MCSD/MCDBA
>> "Kevin Dai" <Kevin_Dzy@.Hotmail.com> wrote in message
>> news:%237j8zSFtFHA.2792@.tk2msftngp13.phx.gbl...
>> It's not network problem, I can connect through a WinForm application. I
>> found something in the following article, I try but still doesn't work.
>> http://support.microsoft.com/default.aspx?scid=kb;en-us;888228
>> By the way, the two machines are in different domain.
>> Regars
>> Kevin
>>
>>
>> "Nik Marshall-Blank" <Nik@.Operatelecom.com>
>> Ð´ÈëÏûÏ¢ÐÂÎÅ:4iSTe.305886$WN5.7191@.fe02.news.easynews.com...
>> Run a profiler trace on the SQL server to see if the login attempt is
>> making it the the SQL server. This will give you insight in to where to
>> look next for the problem, network or program.
>> --
>> Nik Marshall-Blank MCSD/MCDBA
>> "Kevin Dai" <Kevin_Dzy@.Hotmail.com> wrote in message
>> news:%23g6oPUDtFHA.1252@.TK2MSFTNGP09.phx.gbl...
>> Hi,
>> In this case, the environment is:
>> Machine A: SQL Server 2000 SP3 on Windows 2003 SP1. (IP Address:
>> 10.35.3.43)
>> Machine B: IIS Server on Windows XP SP2, an ASP.Net application, a
>> WinForms application. (In the same subnet)
>> In the WinForms application, I can connect to the SQL server
>> sucessfully, but in the ASP.Net application, I can not, the error
>> message say that "SQL Server does not exist, or access deny".
>> The code is the same in ASP.Net application and WinForms application:
>> ==>>
>> string cnstring = "user id=sa;data source='10.35.3.43';persist
>> security info=True;initial catalog=MyDB;password='MyPassword'";
>> string cmdstring = "SELECT Count(*) FROM FunctionCode";
>> System.Data.SqlClient.SqlConnection cn = new
>> System.Data.SqlClient.SqlConnection(cnstring);
>> System.Data.SqlClient.SqlCommand cmd = new
>> System.Data.SqlClient.SqlCommand(cmdstring, cn);
>> cn.Open(); //Suceeds in WinForm, but fails in ASP.Net
>> int count = (int)cmd.ExecuteScalar();
>> cn.Close();
>> Response.Write(count.ToString());
>> <<==>> How to fix this problem?
>> Thanks in advance
>> Kevin
>>
>>
>>
>>
>|||I now found the root cause. It's because the Machine A and Machine B are in
different domain, two domains are not trusted. If both machines in the same
domain, it works.
The reason why WinForm app succeeds is because Machine B have stored a use
account and password on Domain A, I could see the NT user name from sql
profiler, it's Domain A's user account.
"Nik Marshall-Blank" <Nik@.Operatelecom.com> Ð´ÈëÏûÏ¢ÐÂÎÅ:DEUTe.127980$Lg2.47868@.fe12.news.easynews.com...
> Ok now we're getting somewhere, not sure where yet but we now going to
> look at the ASP.Net server more closely.
> But first just try adding the account under which ASP.Net runs as a login
> on the SQL Server and see if it connects.
> --
> Nik Marshall-Blank MCSD/MCDBA
> "Kevin Dai" <Kevin_Dzy@.Hotmail.com> wrote in message
> news:eYSsLGGtFHA.3908@.tk2msftngp13.phx.gbl...
>> Hi, Nik,
>> I use profile trace, but there is no login or login fail events when
>> using ASP.Net. There is login even when using WinForm.
>> The source code and connection string are the same in WinForm and
>> ASP.Net.
>>
>>
>> "Nik Marshall-Blank" <Nik@.Operatelecom.com> Ð´ÈëÏûÏ¢ÐÂÎÅ:XrTTe.308487$kM5.134787@.fe01.news.easynews.com...
>>I would expect that to apply to both connections from Winform and
>>ASP.NET. Can you perform a profile trace on to see what credentials are
>>being used for the failing connection.
>> --
>> Nik Marshall-Blank MCSD/MCDBA
>> "Kevin Dai" <Kevin_Dzy@.Hotmail.com> wrote in message
>> news:%237j8zSFtFHA.2792@.tk2msftngp13.phx.gbl...
>> It's not network problem, I can connect through a WinForm application.
>> I found something in the following article, I try but still doesn't
>> work.
>> http://support.microsoft.com/default.aspx?scid=kb;en-us;888228
>> By the way, the two machines are in different domain.
>> Regars
>> Kevin
>>
>>
>> "Nik Marshall-Blank" <Nik@.Operatelecom.com> Ð´ÈëÏûÏ¢ÐÂÎÅ:4iSTe.305886$WN5.7191@.fe02.news.easynews.com...
>> Run a profiler trace on the SQL server to see if the login attempt is
>> making it the the SQL server. This will give you insight in to where
>> to look next for the problem, network or program.
>> --
>> Nik Marshall-Blank MCSD/MCDBA
>> "Kevin Dai" <Kevin_Dzy@.Hotmail.com> wrote in message
>> news:%23g6oPUDtFHA.1252@.TK2MSFTNGP09.phx.gbl...
>> Hi,
>> In this case, the environment is:
>> Machine A: SQL Server 2000 SP3 on Windows 2003 SP1. (IP Address:
>> 10.35.3.43)
>> Machine B: IIS Server on Windows XP SP2, an ASP.Net application, a
>> WinForms application. (In the same subnet)
>> In the WinForms application, I can connect to the SQL server
>> sucessfully, but in the ASP.Net application, I can not, the error
>> message say that "SQL Server does not exist, or access deny".
>> The code is the same in ASP.Net application and WinForms application:
>> ==>>
>> string cnstring = "user id=sa;data source='10.35.3.43';persist
>> security info=True;initial catalog=MyDB;password='MyPassword'";
>> string cmdstring = "SELECT Count(*) FROM FunctionCode";
>> System.Data.SqlClient.SqlConnection cn = new
>> System.Data.SqlClient.SqlConnection(cnstring);
>> System.Data.SqlClient.SqlCommand cmd = new
>> System.Data.SqlClient.SqlCommand(cmdstring, cn);
>> cn.Open(); //Suceeds in WinForm, but fails in ASP.Net
>> int count = (int)cmd.ExecuteScalar();
>> cn.Close();
>> Response.Write(count.ToString());
>> <<==>> How to fix this problem?
>> Thanks in advance
>> Kevin
>>
>>
>>
>>
>>
>

Can not access SQL Server

Sunday, February 19, 2012

Can I separate IIS and Sql server 2005 in different PCs?

Hi, everyone

Can I separate IIS and Sql server 2005 in different PCs? One is Web server and another one sql server 2005. How to set up report services running well under this condition?

thanks

Hi Blueskly168,

You install Reporting Services 2005 on the IIS machine, and have MSSQL 2005 on a standalone machine (i.e not with IIS) you then simply configure RS to point to the MSSQL db server to host its repository (ReportServer, ReportServerTempDB).

Cheers

Rob

Thursday, February 16, 2012

Can I run SQL db, RS 2000, and Analysis server all on 1 box?

We currently have SERVER A which is just IIS for VS2002 applications(and some
file shares). And SERVER B that has SQL 2000-Enterprise Edition. I would
like to use RS 2000 and Analysis server/BI? Can I have all 3(db, rs, as)
running on one box? If so, what are the requirements? But doesn't RS 2000,
need IIS? Then I would need to install RS on SERVER A. But then SERVER A
would need a SQL Enterprise licenses? So really, RS 2000 is not free?!?!?There is nothing preventing you from having IIS on your SQL Server box. If
you run it all on the same box it is free. Otherwise you are correct, you
have to have another license. One alternative would be to license for
Standard on the IIS box instead of Enterprise if you don't need Enterprise
features.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"fjahnke" <fjahnke@.discussions.microsoft.com> wrote in message
news:935BF15C-10C0-451C-AD14-B7CC8B0BF651@.microsoft.com...
> We currently have SERVER A which is just IIS for VS2002 applications(and
> some
> file shares). And SERVER B that has SQL 2000-Enterprise Edition. I would
> like to use RS 2000 and Analysis server/BI? Can I have all 3(db, rs, as)
> running on one box? If so, what are the requirements? But doesn't RS
> 2000,
> need IIS? Then I would need to install RS on SERVER A. But then SERVER A
> would need a SQL Enterprise licenses? So really, RS 2000 is not free?!?!?|||Thanks Bruce,
This helps! So Standard has RS and AS?
I have always heard that SQL db on IIS is not good. Is that a horsepower
issue?
Speaking of horse power, how would I find out what kind of power I would
need to have everything on one box(IIS, SQL DB, RS and AS)?
With a very limited budget, what configuration/distribution of apps would
you recommend(be it multi-server or big honkin' server)?
thanks,
Fred
"Bruce L-C [MVP]" wrote:
> There is nothing preventing you from having IIS on your SQL Server box. If
> you run it all on the same box it is free. Otherwise you are correct, you
> have to have another license. One alternative would be to license for
> Standard on the IIS box instead of Enterprise if you don't need Enterprise
> features.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "fjahnke" <fjahnke@.discussions.microsoft.com> wrote in message
> news:935BF15C-10C0-451C-AD14-B7CC8B0BF651@.microsoft.com...
> > We currently have SERVER A which is just IIS for VS2002 applications(and
> > some
> > file shares). And SERVER B that has SQL 2000-Enterprise Edition. I would
> > like to use RS 2000 and Analysis server/BI? Can I have all 3(db, rs, as)
> > running on one box? If so, what are the requirements? But doesn't RS
> > 2000,
> > need IIS? Then I would need to install RS on SERVER A. But then SERVER A
> > would need a SQL Enterprise licenses? So really, RS 2000 is not free?!?!?
>
>|||No, I was not talking about AS. I am just talking about whether you put RS
on the same box as your SQL Server. If your box is at least a
multi-processor box with a decent amount of RAM. I have a two processor, 2
Gigs RAM box with SQL Server datamart, IIS and RS running on it. It has no
problem. The datamart is currently about 10 Gig (not that big although one
table in it is up to 80 million rows). How to size a server is a bit of an
art. It really depends on the amount of data, the amount of users, how is it
being used (oltp, datamart, etc). My own experience with SQL Server is it is
a pretty good citizen with how it uses RAM. It will take and give up RAM
depending on the load on the server. I don't have any experience with AS.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"fjahnke" <fjahnke@.discussions.microsoft.com> wrote in message
news:540D6453-3DC4-4C0B-A784-926B44AF43CB@.microsoft.com...
> Thanks Bruce,
> This helps! So Standard has RS and AS?
> I have always heard that SQL db on IIS is not good. Is that a horsepower
> issue?
> Speaking of horse power, how would I find out what kind of power I would
> need to have everything on one box(IIS, SQL DB, RS and AS)?
> With a very limited budget, what configuration/distribution of apps
> would
> you recommend(be it multi-server or big honkin' server)?
> thanks,
> Fred
> "Bruce L-C [MVP]" wrote:
>> There is nothing preventing you from having IIS on your SQL Server box.
>> If
>> you run it all on the same box it is free. Otherwise you are correct, you
>> have to have another license. One alternative would be to license for
>> Standard on the IIS box instead of Enterprise if you don't need
>> Enterprise
>> features.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "fjahnke" <fjahnke@.discussions.microsoft.com> wrote in message
>> news:935BF15C-10C0-451C-AD14-B7CC8B0BF651@.microsoft.com...
>> > We currently have SERVER A which is just IIS for VS2002
>> > applications(and
>> > some
>> > file shares). And SERVER B that has SQL 2000-Enterprise Edition. I
>> > would
>> > like to use RS 2000 and Analysis server/BI? Can I have all 3(db, rs,
>> > as)
>> > running on one box? If so, what are the requirements? But doesn't RS
>> > 2000,
>> > need IIS? Then I would need to install RS on SERVER A. But then
>> > SERVER A
>> > would need a SQL Enterprise licenses? So really, RS 2000 is not
>> > free?!?!?
>>|||Thanks again Bruce. This is very helpful. I will search the technet on SQL
OLAP for answers on AS.
Thanks,
Fred
"Bruce L-C [MVP]" wrote:
> No, I was not talking about AS. I am just talking about whether you put RS
> on the same box as your SQL Server. If your box is at least a
> multi-processor box with a decent amount of RAM. I have a two processor, 2
> Gigs RAM box with SQL Server datamart, IIS and RS running on it. It has no
> problem. The datamart is currently about 10 Gig (not that big although one
> table in it is up to 80 million rows). How to size a server is a bit of an
> art. It really depends on the amount of data, the amount of users, how is it
> being used (oltp, datamart, etc). My own experience with SQL Server is it is
> a pretty good citizen with how it uses RAM. It will take and give up RAM
> depending on the load on the server. I don't have any experience with AS.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "fjahnke" <fjahnke@.discussions.microsoft.com> wrote in message
> news:540D6453-3DC4-4C0B-A784-926B44AF43CB@.microsoft.com...
> > Thanks Bruce,
> > This helps! So Standard has RS and AS?
> >
> > I have always heard that SQL db on IIS is not good. Is that a horsepower
> > issue?
> >
> > Speaking of horse power, how would I find out what kind of power I would
> > need to have everything on one box(IIS, SQL DB, RS and AS)?
> >
> > With a very limited budget, what configuration/distribution of apps
> > would
> > you recommend(be it multi-server or big honkin' server)?
> >
> > thanks,
> > Fred
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> There is nothing preventing you from having IIS on your SQL Server box.
> >> If
> >> you run it all on the same box it is free. Otherwise you are correct, you
> >> have to have another license. One alternative would be to license for
> >> Standard on the IIS box instead of Enterprise if you don't need
> >> Enterprise
> >> features.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "fjahnke" <fjahnke@.discussions.microsoft.com> wrote in message
> >> news:935BF15C-10C0-451C-AD14-B7CC8B0BF651@.microsoft.com...
> >> > We currently have SERVER A which is just IIS for VS2002
> >> > applications(and
> >> > some
> >> > file shares). And SERVER B that has SQL 2000-Enterprise Edition. I
> >> > would
> >> > like to use RS 2000 and Analysis server/BI? Can I have all 3(db, rs,
> >> > as)
> >> > running on one box? If so, what are the requirements? But doesn't RS
> >> > 2000,
> >> > need IIS? Then I would need to install RS on SERVER A. But then
> >> > SERVER A
> >> > would need a SQL Enterprise licenses? So really, RS 2000 is not
> >> > free?!?!?
> >>
> >>
> >>
>
>

Tuesday, March 20, 2012

Can not access SQL Server

Can not access SQL Server

Can not access SQL Server

Sunday, February 19, 2012

Can I separate IIS and Sql server 2005 in different PCs?

Thursday, February 16, 2012

Can I run SQL db, RS 2000, and Analysis server all on 1 box?

install SQL on WinXP

Blog Archive

About Me