Does SQL 7 server run well in Win Server 2k3 or do I have to upgra

I currently have one machine running windows 2000 server that I promoted to a
PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server 20003,
and I want to migrate the win2k pdc to win server 2k3, that I will promote to
a high-end domain controller. I wonder if someone with expertise in this
matter could tell me the steps I should follow to accomplish this with the
least headache. Also, does SQL 7 still run well on win2k3 server or am I
required to upgrade SQL? Prior experience showed me that sometimes web sites
running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in IIS
6.0. Do you have any advice here?
Please help, and thank you.
Db
Db
SQL Server 7 is not supported on Windows 2003. So while it might work its
not a good idea to try it. If you do gey any issues you will have trouble
getting help. If you want to use the server you should upgrade to SQL Server
2000.
Regards
John
"kwizyu" wrote:

> I currently have one machine running windows 2000 server that I promoted to a
> PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server 20003,
> and I want to migrate the win2k pdc to win server 2k3, that I will promote to
> a high-end domain controller. I wonder if someone with expertise in this
> matter could tell me the steps I should follow to accomplish this with the
> least headache. Also, does SQL 7 still run well on win2k3 server or am I
> required to upgrade SQL? Prior experience showed me that sometimes web sites
> running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in IIS
> 6.0. Do you have any advice here?
> Please help, and thank you.
> Db
>
|||kwizyu wrote:
> I currently have one machine running windows 2000 server that I
> promoted to a PDC. It also runs SQL 7 server and IIS 5.0. I acquired
> windows server 20003, and I want to migrate the win2k pdc to win
> server 2k3, that I will promote to a high-end domain controller. I
> wonder if someone with expertise in this matter could tell me the
> steps I should follow to accomplish this with the least headache.
> Also, does SQL 7 still run well on win2k3 server or am I required to
> upgrade SQL? Prior experience showed me that sometimes web sites
> running in IIS 5.0 will not run in IIS 6.0 even after "unlocking"
> them in IIS
> 6.0. Do you have any advice here?
> Please help, and thank you.
> Db
SQL 7 is not certified to run on Windows Server 2003. Personally, I use
SQL 7 on a Virtual PC running Windows Server 2003. But this is just for
development when a real SQL 7 server is unavailable.
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||Ugh, not to mention that you don't want to be running SQL Server of any
version or edition on a Domain Controller. You like cheap thrills, huh?
I know; I know. It's not your fault; however, the whole point of
distributed computing is to segment and isolate functionality on seperate
and distributed platforms. If you're going to lump everyting into a single
installation, you might as well be running on a mainframe or mini-computer.
Can anyone say stone age?
Sincerely,
Anthony Thomas

"kwizyu" <kwizyu@.discussions.microsoft.com> wrote in message
news:9191D846-1696-4CE2-A2EF-5BC2FCE3161E@.microsoft.com...
I currently have one machine running windows 2000 server that I promoted to
a
PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server
20003,
and I want to migrate the win2k pdc to win server 2k3, that I will promote
to
a high-end domain controller. I wonder if someone with expertise in this
matter could tell me the steps I should follow to accomplish this with the
least headache. Also, does SQL 7 still run well on win2k3 server or am I
required to upgrade SQL? Prior experience showed me that sometimes web sites
running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in
IIS
6.0. Do you have any advice here?
Please help, and thank you.
Db

Does SQL 7 server run well in Win Server 2k3 or do I have to upgra

I currently have one machine running Windows 2000 server that I promoted to
a
PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server 20003
,
and I want to migrate the win2k pdc to win server 2k3, that I will promote t
o
a high-end domain controller. I wonder if someone with expertise in this
matter could tell me the steps I should follow to accomplish this with the
least headache. Also, does SQL 7 still run well on win2k3 server or am I
required to upgrade SQL? Prior experience showed me that sometimes web sites
running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in II
S
6.0. Do you have any advice here?
Please help, and thank you.
DbDb
SQL Server 7 is not supported on Windows 2003. So while it might work its
not a good idea to try it. If you do gey any issues you will have trouble
getting help. If you want to use the server you should upgrade to SQL Server
2000.
Regards
John
"kwizyu" wrote:

> I currently have one machine running Windows 2000 server that I promoted t
o a
> PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server 200
03,
> and I want to migrate the win2k pdc to win server 2k3, that I will promote
to
> a high-end domain controller. I wonder if someone with expertise in this
> matter could tell me the steps I should follow to accomplish this with the
> least headache. Also, does SQL 7 still run well on win2k3 server or am I
> required to upgrade SQL? Prior experience showed me that sometimes web sit
es
> running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in
IIS
> 6.0. Do you have any advice here?
> Please help, and thank you.
> Db
>|||kwizyu wrote:
> I currently have one machine running Windows 2000 server that I
> promoted to a PDC. It also runs SQL 7 server and IIS 5.0. I acquired
> windows server 20003, and I want to migrate the win2k pdc to win
> server 2k3, that I will promote to a high-end domain controller. I
> wonder if someone with expertise in this matter could tell me the
> steps I should follow to accomplish this with the least headache.
> Also, does SQL 7 still run well on win2k3 server or am I required to
> upgrade SQL? Prior experience showed me that sometimes web sites
> running in IIS 5.0 will not run in IIS 6.0 even after "unlocking"
> them in IIS
> 6.0. Do you have any advice here?
> Please help, and thank you.
> Db
SQL 7 is not certified to run on Windows Server 2003. Personally, I use
SQL 7 on a Virtual PC running Windows Server 2003. But this is just for
development when a real SQL 7 server is unavailable.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Ugh, not to mention that you don't want to be running SQL Server of any
version or edition on a Domain Controller. You like cheap thrills, huh?
I know; I know. It's not your fault; however, the whole point of
distributed computing is to segment and isolate functionality on seperate
and distributed platforms. If you're going to lump everyting into a single
installation, you might as well be running on a mainframe or mini-computer.
Can anyone say stone age?
Sincerely,
Anthony Thomas
"kwizyu" <kwizyu@.discussions.microsoft.com> wrote in message
news:9191D846-1696-4CE2-A2EF-5BC2FCE3161E@.microsoft.com...
I currently have one machine running Windows 2000 server that I promoted to
a
PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server
20003,
and I want to migrate the win2k pdc to win server 2k3, that I will promote
to
a high-end domain controller. I wonder if someone with expertise in this
matter could tell me the steps I should follow to accomplish this with the
least headache. Also, does SQL 7 still run well on win2k3 server or am I
required to upgrade SQL? Prior experience showed me that sometimes web sites
running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in
IIS
6.0. Do you have any advice here?
Please help, and thank you.
Dbsql

Does SQL 7 server run well in Win Server 2k3 or do I have to upgra

I currently have one machine running windows 2000 server that I promoted to a
PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server 20003,
and I want to migrate the win2k pdc to win server 2k3, that I will promote to
a high-end domain controller. I wonder if someone with expertise in this
matter could tell me the steps I should follow to accomplish this with the
least headache. Also, does SQL 7 still run well on win2k3 server or am I
required to upgrade SQL? Prior experience showed me that sometimes web sites
running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in IIS
6.0. Do you have any advice here?
Please help, and thank you.
DbDb
SQL Server 7 is not supported on Windows 2003. So while it might work its
not a good idea to try it. If you do gey any issues you will have trouble
getting help. If you want to use the server you should upgrade to SQL Server
2000.
Regards
John
"kwizyu" wrote:
> I currently have one machine running windows 2000 server that I promoted to a
> PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server 20003,
> and I want to migrate the win2k pdc to win server 2k3, that I will promote to
> a high-end domain controller. I wonder if someone with expertise in this
> matter could tell me the steps I should follow to accomplish this with the
> least headache. Also, does SQL 7 still run well on win2k3 server or am I
> required to upgrade SQL? Prior experience showed me that sometimes web sites
> running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in IIS
> 6.0. Do you have any advice here?
> Please help, and thank you.
> Db
>|||kwizyu wrote:
> I currently have one machine running windows 2000 server that I
> promoted to a PDC. It also runs SQL 7 server and IIS 5.0. I acquired
> windows server 20003, and I want to migrate the win2k pdc to win
> server 2k3, that I will promote to a high-end domain controller. I
> wonder if someone with expertise in this matter could tell me the
> steps I should follow to accomplish this with the least headache.
> Also, does SQL 7 still run well on win2k3 server or am I required to
> upgrade SQL? Prior experience showed me that sometimes web sites
> running in IIS 5.0 will not run in IIS 6.0 even after "unlocking"
> them in IIS
> 6.0. Do you have any advice here?
> Please help, and thank you.
> Db
SQL 7 is not certified to run on Windows Server 2003. Personally, I use
SQL 7 on a Virtual PC running Windows Server 2003. But this is just for
development when a real SQL 7 server is unavailable.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Ugh, not to mention that you don't want to be running SQL Server of any
version or edition on a Domain Controller. You like cheap thrills, huh?
I know; I know. It's not your fault; however, the whole point of
distributed computing is to segment and isolate functionality on seperate
and distributed platforms. If you're going to lump everyting into a single
installation, you might as well be running on a mainframe or mini-computer.
Can anyone say stone age?
Sincerely,
Anthony Thomas
"kwizyu" <kwizyu@.discussions.microsoft.com> wrote in message
news:9191D846-1696-4CE2-A2EF-5BC2FCE3161E@.microsoft.com...
I currently have one machine running windows 2000 server that I promoted to
a
PDC. It also runs SQL 7 server and IIS 5.0. I acquired windows server
20003,
and I want to migrate the win2k pdc to win server 2k3, that I will promote
to
a high-end domain controller. I wonder if someone with expertise in this
matter could tell me the steps I should follow to accomplish this with the
least headache. Also, does SQL 7 still run well on win2k3 server or am I
required to upgrade SQL? Prior experience showed me that sometimes web sites
running in IIS 5.0 will not run in IIS 6.0 even after "unlocking" them in
IIS
6.0. Do you have any advice here?
Please help, and thank you.
Db

Does IIS need to be installed on the SQL Server machine?

If I have Reporting Service installed on one server and the ReportServer
database on another server, do I need IIS installed on the server that houses
the ReportServer database? I'd rather not have IIS and SQL Server on the
same machine.No you do not. IIS has to be only on the server that has RS installed. RS is
an asp.net application.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dave Munter" <Dave Munter@.discussions.microsoft.com> wrote in message
news:B0E4CDDD-F2B6-42C1-976B-03315BC1AF85@.microsoft.com...
> If I have Reporting Service installed on one server and the ReportServer
> database on another server, do I need IIS installed on the server that
houses
> the ReportServer database? I'd rather not have IIS and SQL Server on the
> same machine.
>

Does anonymous access have to be disabled in IIS?

I want anonymous users to be able to see my reports. But it says here it
has to be disabled.
http://www.microsoft.com/products/ee/transform.aspx?EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsAccessDenied&ProdName=Microsoft+SQL+Server+Reporting+Services&ProdVer=8.00
I'm getting an rsAccessDenied if I give it anon access.Ok, I got a solution, but is this ok?
I got anonymous access to work on the report server. I hope there's no
security issues with it. Reporting services won't allow anonymous access,
so I set in IIS ReportServices Properties->Directory Security-> anonymous
access->edit-> anonymous access->edit
And Used my username Domain/CLee and my password. Also Integrated Windows
Security needs to be checked too.
Then, anyone can access the report server.
"Cindy Lee" <cindylee@.hotmail.com> wrote in message
news:e3PvN3vfEHA.644@.tk2msftngp13.phx.gbl...
> I want anonymous users to be able to see my reports. But it says here it
> has to be disabled.
>
http://www.microsoft.com/products/ee/transform.aspx?EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsAccessDenied&ProdName=Microsoft+SQL+Server+Reporting+Services&ProdVer=8.00
> I'm getting an rsAccessDenied if I give it anon access.
>|||If you wanted to set up a totally open site, running as your domain account,
then you have succeeded.
A better way of allowing anonymous access is to
1. give the IUSR_computername the required permissions (for ex. browser, or
content manager) in the report server - use Home | Properties | Security and
Site Settings | Security
2. enable anonymous access, and leave the account as IUSR_machine... or some
equally unpermissioned account.
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Cindy Lee" <cindylee@.hotmail.com> wrote in message
news:Osp9VLwfEHA.636@.TK2MSFTNGP12.phx.gbl...
> Ok, I got a solution, but is this ok?
>
> I got anonymous access to work on the report server. I hope there's no
> security issues with it. Reporting services won't allow anonymous access,
> so I set in IIS ReportServices Properties->Directory Security-> anonymous
> access->edit-> anonymous access->edit
> And Used my username Domain/CLee and my password. Also Integrated Windows
> Security needs to be checked too.
> Then, anyone can access the report server.
>
>
> "Cindy Lee" <cindylee@.hotmail.com> wrote in message
> news:e3PvN3vfEHA.644@.tk2msftngp13.phx.gbl...
> > I want anonymous users to be able to see my reports. But it says here
it
> > has to be disabled.
> >
>
http://www.microsoft.com/products/ee/transform.aspx?EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsAccessDenied&ProdName=Microsoft+SQL+Server+Reporting+Services&ProdVer=8.00
> >
> > I'm getting an rsAccessDenied if I give it anon access.
> >
> >
>

Does 2k5 Reporting Services need IIS?

I'd like to produce dynamic reports via SQL Server 2k5 Reporting
Services that can be rendered in a web browser. However, I don't want
anything to do with IIS or a web server. From what I've heard,
previous version of SQL Server Reporting Services needed IIS. Is this
true for 2k5?
Thanks,
BrettRS 2005 comes with WebForm and WinForm controls for showing reports. Also, t
hese can be client side
only (where the reporting engine is essentially built into the controls). Bu
t this is about as much
as I know. I suggest you post this to an RS forum, where you are more likely
to get a precise
response.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"brett" <account@.cygen.com> wrote in message
news:1142924193.608686.191110@.z34g2000cwc.googlegroups.com...
> I'd like to produce dynamic reports via SQL Server 2k5 Reporting
> Services that can be rendered in a web browser. However, I don't want
> anything to do with IIS or a web server. From what I've heard,
> previous version of SQL Server Reporting Services needed IIS. Is this
> true for 2k5?
> Thanks,
> Brett
>|||Yes, Reporting Services runs inside IIS.
"brett" <account@.cygen.com> wrote in message
news:1142924193.608686.191110@.z34g2000cwc.googlegroups.com...
> I'd like to produce dynamic reports via SQL Server 2k5 Reporting
> Services that can be rendered in a web browser. However, I don't want
> anything to do with IIS or a web server. From what I've heard,
> previous version of SQL Server Reporting Services needed IIS. Is this
> true for 2k5?
> Thanks,
> Brett
>

Does 2k5 Reporting Services need IIS?

I'd like to produce dynamic reports via SQL Server 2k5 Reporting
Services that can be rendered in a web browser. However, I don't want
anything to do with IIS or a web server. From what I've heard,
previous version of SQL Server Reporting Services needed IIS. Is this
true for 2k5?
Thanks,
BrettYes
"brett" <account@.cygen.com> schrieb im Newsbeitrag
news:1142925712.659616.140540@.t31g2000cwb.googlegroups.com...
> I'd like to produce dynamic reports via SQL Server 2k5 Reporting
> Services that can be rendered in a web browser. However, I don't want
> anything to do with IIS or a web server. From what I've heard,
> previous version of SQL Server Reporting Services needed IIS. Is this
> true for 2k5?
> Thanks,
> Brett
>|||Also, VS 2005 comes with two controls. A winform and a webform control.
These controls can either work with RS or can run in local mode where no
server is required. It takes some more work, especially for subreports, jump
to report etc but it works quite well. In local mode you give it the report
and the data and then it renders it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"brett" <account@.cygen.com> wrote in message
news:1142925712.659616.140540@.t31g2000cwb.googlegroups.com...
> I'd like to produce dynamic reports via SQL Server 2k5 Reporting
> Services that can be rendered in a web browser. However, I don't want
> anything to do with IIS or a web server. From what I've heard,
> previous version of SQL Server Reporting Services needed IIS. Is this
> true for 2k5?
> Thanks,
> Brett
>

documentation to install sql 2005 express remotely

Hi all,

I'm just wondering if there is documentation anywhere to help me with installation of SQL 2005 Express on a remote computer. I've set up IIS 6.0 and Windows Server 2003 Web Edition on another computer and am planning to use that for a development server.

Currently I've already installed VWD Express (local computer) and SQL 2005 Express, as well as SQL Query Manager (remote computer). But I seem to be having problems with VWD being able to create databases when i edit the code remotely.

For example when I right-click on "Data Connections" in the "Database Explorer" to create a new database it won't let me. The only way I can do this is to add a connection to a database which I have previously created. And even then there are still problems.

If I set up the database by adding a connection I cannot seem to create stored procedures. The error message I keep getting is "This feature is not supported in Visual Developer".

Is this due to wrong settings whilst installing SQL Express? Or am I just not configuring it right?

Any help on this issue would be greatly appreciated.

Thanks.

I'm not totally up on the capabilities of VWD with regards to database management. There is also the issue of User Instances, which is the default when creating database in VS for many cases. User Instances do not support remote connections, so that would cause problems.

In order to troubleshoot this one, you should simply the scenario by taking VS out of the picture. Use either Managment Studio Express of SQLCmd from your local computer to connect to the remote instance of SQL Express and try to create a database. If that works, try to perfrom some other task against that database. If that works, then the issue is in VS. If you have problems with SSMSE or SQLCmd, then we can look more closely at the SQL issue.

Regards,

Mike Wachal
SQL Express team

-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1

|||

Hi Mike,

As you were saying using Management Studio Express is fine. I can connect to the database remotely and am able to create databases and all that.

The only problem is that I'm currently learning ASP.NET and most of the books utilise VWD Express Edition interface to create, manage and run databases including using the inbuilt (Database Explorer) stored procedures capabilities in VWD. And what they are teaching is to use these locally and not in a remote situation.

I'm just wondering, is there a way to create a stored procedures folder or something similar in SQL Management Express?

I haven't had much experience with MS SQL so please bear with me :)

Thanks for your prompt reply and help.

|||

Stored Procedures are a built-in part of SQL Server, you don't need to create a folder for them. In Management Studio, you should see a folder icon that says Programmability. If you expand that, you will find a place already there for Stored Procedures. When you create a Stored Procedure, they automatically appear in that list, there is no need to specifically put them there.

In order to create a new Stored Procedure in Management Studio you can either right-click on the Stored Procedure "folder" and click the New command, or you can simply open a new query windows against your target database and write a CREATE PROCEDURE script in T-SQL.

Like I mentioned, I think the problem you are facing is related to the default settings of VWD that result in using a User Instance, which only supports a local connection. All of the VS Express products are designed to be used for local development by default. I don't know any specifics about using them to develop against a remote server, other than the fact that you can't use User Instances. As far as I know, there is no way to turn off the default use of User Instances in VS Express products, but you can modify the connection strings manually once they've been created to remove the keyword. This would likely require you to move the database from your local system to the remote server and attach the database there as well.

I would suggest you check out http://forums.asp.net/ to ask more specific question about VWD functionaltiy. I'm out of my element when it comes to web development and VWD.

Regards,

Mike Wachal
SQL Express team

|||

Hi Mike,

Thanks for that. I'll try and post up some questions on the asp.net forums.

documentation to install sql 2005 express remotely

Hi all,

I'm just wondering if there is documentation anywhere to help me with installation of SQL 2005 Express on a remote computer. I've set up IIS 6.0 and Windows Server 2003 Web Edition on another computer and am planning to use that for a development server.

Currently I've already installed VWD Express (local computer) and SQL 2005 Express, as well as SQL Query Manager (remote computer). But I seem to be having problems with VWD being able to create databases when i edit the code remotely.

For example when I right-click on "Data Connections" in the "Database Explorer" to create a new database it won't let me. The only way I can do this is to add a connection to a database which I have previously created. And even then there are still problems.

If I set up the database by adding a connection I cannot seem to create stored procedures. The error message I keep getting is "This feature is not supported in Visual Developer".

Is this due to wrong settings whilst installing SQL Express? Or am I just not configuring it right?

Any help on this issue would be greatly appreciated.

Thanks.

I'm not totally up on the capabilities of VWD with regards to database management. There is also the issue of User Instances, which is the default when creating database in VS for many cases. User Instances do not support remote connections, so that would cause problems.

In order to troubleshoot this one, you should simply the scenario by taking VS out of the picture. Use either Managment Studio Express of SQLCmd from your local computer to connect to the remote instance of SQL Express and try to create a database. If that works, try to perfrom some other task against that database. If that works, then the issue is in VS. If you have problems with SSMSE or SQLCmd, then we can look more closely at the SQL issue.

Regards,

Mike Wachal
SQL Express team

-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1

|||

Hi Mike,

As you were saying using Management Studio Express is fine. I can connect to the database remotely and am able to create databases and all that.

The only problem is that I'm currently learning ASP.NET and most of the books utilise VWD Express Edition interface to create, manage and run databases including using the inbuilt (Database Explorer) stored procedures capabilities in VWD. And what they are teaching is to use these locally and not in a remote situation.

I'm just wondering, is there a way to create a stored procedures folder or something similar in SQL Management Express?

I haven't had much experience with MS SQL so please bear with me :)

Thanks for your prompt reply and help.

|||

Stored Procedures are a built-in part of SQL Server, you don't need to create a folder for them. In Management Studio, you should see a folder icon that says Programmability. If you expand that, you will find a place already there for Stored Procedures. When you create a Stored Procedure, they automatically appear in that list, there is no need to specifically put them there.

In order to create a new Stored Procedure in Management Studio you can either right-click on the Stored Procedure "folder" and click the New command, or you can simply open a new query windows against your target database and write a CREATE PROCEDURE script in T-SQL.

Like I mentioned, I think the problem you are facing is related to the default settings of VWD that result in using a User Instance, which only supports a local connection. All of the VS Express products are designed to be used for local development by default. I don't know any specifics about using them to develop against a remote server, other than the fact that you can't use User Instances. As far as I know, there is no way to turn off the default use of User Instances in VS Express products, but you can modify the connection strings manually once they've been created to remove the keyword. This would likely require you to move the database from your local system to the remote server and attach the database there as well.

I would suggest you check out http://forums.asp.net/ to ask more specific question about VWD functionaltiy. I'm out of my element when it comes to web development and VWD.

Regards,

Mike Wachal
SQL Express team

|||

Hi Mike,

Thanks for that. I'll try and post up some questions on the asp.net forums.