New to SQL and Web development

I have been in systems for many years on the admin side, and have had experience working with developers, however I am attempting to start the learning process for creating a data store with a web based UI. I have an understanding of the theories of what
is possible, but I don't know where to start. I have experience with HTML coding and static pages, but nothing that interfaces with a back end.
What are your suggestions of where to start.
This is a great site with lots of good answers to many questions:
http://www.aspfaq.com/
You will find good examples and information out on =
http://www.asp101.com/
--=20
Keith
"Otts73" <sh_tmail@.charter.net> wrote in message =
news:EFF6B423-F1FA-41D1-9139-3929979CCB3F@.microsoft.com...
> I have been in systems for many years on the admin side, and have had =
experience working with developers, however I am attempting to start the =
learning process for creating a data store with a web based UI. I have =
an understanding of the theories of what is possible, but I don't know =
where to start. I have experience with HTML coding and static pages, =
but nothing that interfaces with a back end.
>=20
> What are your suggestions of where to start.
|||As well as Keith's references, you might like to look at
http://www.w3schools.com/ado/default.asp
Regards,
Paul Ibison

New to SQL and Web development

I have been in systems for many years on the admin side, and have had experi
ence working with developers, however I am attempting to start the learning
process for creating a data store with a web based UI. I have an understand
ing of the theories of what
is possible, but I don't know where to start. I have experience with HTML c
oding and static pages, but nothing that interfaces with a back end.
What are your suggestions of where to start.This is a great site with lots of good answers to many questions:
http://www.aspfaq.com/
You will find good examples and information out on =
http://www.asp101.com/
--=20
Keith
"Otts73" <sh_tmail@.charter.net> wrote in message =
news:EFF6B423-F1FA-41D1-9139-3929979CCB3F@.microsoft.com...
> I have been in systems for many years on the admin side, and have had =
experience working with developers, however I am attempting to start the =
learning process for creating a data store with a web based UI. I have =
an understanding of the theories of what is possible, but I don't know =
where to start. I have experience with HTML coding and static pages, =
but nothing that interfaces with a back end.
>=20
> What are your suggestions of where to start.|||As well as Keith's references, you might like to look at
http://www.w3schools.com/ado/default.asp
Regards,
Paul Ibison

New to SQL and Web development

I have been in systems for many years on the admin side, and have had experience working with developers, however I am attempting to start the learning process for creating a data store with a web based UI. I have an understanding of the theories of what is possible, but I don't know where to start. I have experience with HTML coding and static pages, but nothing that interfaces with a back end
What are your suggestions of where to start.This is a great site with lots of good answers to many questions:
http://www.aspfaq.com/
You will find good examples and information out on =http://www.asp101.com/
-- Keith
"Otts73" <sh_tmail@.charter.net> wrote in message =news:EFF6B423-F1FA-41D1-9139-3929979CCB3F@.microsoft.com...
> I have been in systems for many years on the admin side, and have had =experience working with developers, however I am attempting to start the =learning process for creating a data store with a web based UI. I have =an understanding of the theories of what is possible, but I don't know =where to start. I have experience with HTML coding and static pages, =but nothing that interfaces with a back end.
> > What are your suggestions of where to start.|||As well as Keith's references, you might like to look at
http://www.w3schools.com/ado/default.asp
Regards,
Paul Ibisonsql

New to replication, advice needed

hi,
our app works in a multi tier model to provide inet connectivity
now a customer wants to be able to keep working even if the inet is down or
the main server is down
so the obvious solution is to use replication
so:
1) what is the best place to start understanding what is involved
2) all relations are now by the use of integer PK's, some of them are auto
generated, does this has to change?
3) can i have only selected tables replicated?
4) can i have only a subset of rows of a table replicated?
tia!
Marc
1. BOL, www.replicationanswers.com, go for merge replication
2. N
3. Y
4. Y
Hope this will help
-Ravi Lobo
"Marc Antheunis" wrote:

> hi,
> our app works in a multi tier model to provide inet connectivity
> now a customer wants to be able to keep working even if the inet is down or
> the main server is down
> so the obvious solution is to use replication
> so:
> 1) what is the best place to start understanding what is involved
> 2) all relations are now by the use of integer PK's, some of them are auto
> generated, does this has to change?
> 3) can i have only selected tables replicated?
> 4) can i have only a subset of rows of a table replicated?
> tia!
> Marc
>
>
|||1) Well there's my book. Query Replication Tutorials on the web
2) No, not for one way transactional replication. With merge replication DRI
is maintained but another tracking column is added - a guid column.
3) Yes, for transactional replication all tables must have a pk, with merge
they don't require a pk.
4) Yes, as long as there is a criteria to filter it by you can replicate a
subset of rows - this is called horizontal partitioning or horizontal
filtering.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Marc Antheunis" <ask_me@.ask.me> wrote in message
news:uCKSLCKJFHA.2956@.TK2MSFTNGP12.phx.gbl...
> hi,
> our app works in a multi tier model to provide inet connectivity
> now a customer wants to be able to keep working even if the inet is down
or
> the main server is down
> so the obvious solution is to use replication
> so:
> 1) what is the best place to start understanding what is involved
> 2) all relations are now by the use of integer PK's, some of them are auto
> generated, does this has to change?
> 3) can i have only selected tables replicated?
> 4) can i have only a subset of rows of a table replicated?
> tia!
> Marc
>
|||Hi Hilary!
i just phoned the biggest IT related book store in belgium but they don't
sell your book
awaiting an answer from them if it is availabel in belgium
i'll try to collect some ideas and post some to the point questions
thx
marc
"Hilary Cotter" <hilary.cotter@.gmail.com> schreef in bericht
news:eXyQEfLJFHA.3928@.TK2MSFTNGP09.phx.gbl...
> 1) Well there's my book. Query Replication Tutorials on the web
> 2) No, not for one way transactional replication. With merge replication
> DRI
> is maintained but another tracking column is added - a guid column.
> 3) Yes, for transactional replication all tables must have a pk, with
> merge
> they don't require a pk.
> 4) Yes, as long as there is a criteria to filter it by you can replicate a
> subset of rows - this is called horizontal partitioning or horizontal
> filtering.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Marc Antheunis" <ask_me@.ask.me> wrote in message
> news:uCKSLCKJFHA.2956@.TK2MSFTNGP12.phx.gbl...
> or
>
|||You can get it from Amazon.com or you can order it by following this link:
http://www.nwsu.com/0974973602.html
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Marc Antheunis" <ask_me@.ask.me> wrote in message
news:uCCa01LJFHA.1860@.TK2MSFTNGP15.phx.gbl...[vbcol=seagreen]
> Hi Hilary!
> i just phoned the biggest IT related book store in belgium but they don't
> sell your book
> awaiting an answer from them if it is availabel in belgium
> i'll try to collect some ideas and post some to the point questions
> thx
> marc
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> schreef in bericht
> news:eXyQEfLJFHA.3928@.TK2MSFTNGP09.phx.gbl...
a[vbcol=seagreen]
down
>

New To Replication

I am a software developer who has been tasked with setting up replication for one of our clients. I have about 1 week of experience working with replication, so any help would be appreciated.
My situation:
5 databases:
Production - All sales transactions go into here
Corporate - Used to report on everything in the Production DB
Site A - Filtered for Site A data
Site B - Filtered for Site B data
Site C - Filtered for Site C data
All connections must be two-way (Data changed at Site A most propagate back through Corporate to Production, data entered at Production -> Corporate -> Site A\B\C)
I want the Corporate DB to be the publisher and Production, Site A\B\C to be subscribers to keep the load off Production.
The issues I have are:
Filtering the data to Sites A\B\C
Default values are being stripped off columns during replication
Data is not being propagated accuratly (Data entered at production replicated to Corporate, then the data is deleted at Corporate and at Production).
I have tried several combinations of Merge and Transactional Replication and nothing works as needed.
Thanks,
David
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
David,
one topology that should solve your issues:
Production publishes everything to Corporate using merge.
Corporate publishes to SitesA-C (3 subscribers) using merge with dynamic
filters.
This setup is known as republishing, as Corporate is both a publisher and a
subscriber.
HTH,
Paul Ibison

New to MS SQL

We just installed sql server 2005 on our server, how do I log into SQL server 2005 as an administrator from my workstation as opposed to working from the server console

Thanks,

Mike

Quote:

Originally Posted by Michaelrc0

We just installed sql server 2005 on our server, how do I log into SQL server 2005 as an administrator from my workstation as opposed to working from the server console

Thanks,

Mike

Install the management studio on your desktop.

New SQL Express

I am working with Microsoft Office Access 2003 on MSWXP Professional SP2. In attempting to open one of the sample database projects that come with Access 2003, NorthwindCS.adp, I get the following message: "Microsoft Access could not find either Microsoft SQL Server 2000 Desktop Engine or Microsoft SQL Server installed on your computer. Click OK to display the Data Link Properties dialog box and log on to a remote server. If you want to install SQL Server 2000 Desktop Engine on this computer first, click Cancel, install it from the MSDE2000 folder on the Office CD-ROM, and then reopen this Access project". Instead of downloading & installing the Microsoft SQL Server 2000 Desktop Engine, I downloaded & installed the SQL Server 2005 Express Edition SP1 instead. After having restarted the computer and relaunching Access 2003 & opening the NorthwindCS.adp I still get the same message as mentioned previously above. My question is can the SQL Server 2005 Express Edition SP1 be used or must the SQL Server 2000 Desktop Engine be used instead. I understand that running Microsoft Windows Vista must use the SQL Server 2005 Express Edition SP1 but I am running MSWXP Professional SP2 instead. Advise?

Hi,

AFAIC remember 2003 ADP projects are not fully supported / working in conjunction with SQL Server Express even with t the compt. settings changed.

HTH; Jens K. Suessmeyer.

http://www.sqlserver2005.de

new server to install, Win 2003 x64 will be used... which SQL Version?

Hi,
I have to install a new server and I am a little confused about working
combinations between 30bits, x64 and IA64...
My server use intel Xeon processors with EMT64.
So I want to install Windows 2003 x64 Ent.
but which version of SQL Server can I install?
the 64bits?
32bits + SP4 (Sql2k64sp4.exe)?
Also I have to install Reporting Services, Analysis Services & Sharepoint.
Does everything works on Win x64?
I'm using SQL Server 2000 enterprise edition.
thanks for your answer.
Jerome.You need the SQL Server 2000 (64-bit) edition.
http://www.microsoft.com/sql/64bit/default.mspx
--
--Brian
(Please reply to the newsgroups only.)
"Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
news:e%2313sduuFHA.3764@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I have to install a new server and I am a little confused about working
> combinations between 30bits, x64 and IA64...
> My server use intel Xeon processors with EMT64.
> So I want to install Windows 2003 x64 Ent.
> but which version of SQL Server can I install?
> the 64bits?
> 32bits + SP4 (Sql2k64sp4.exe)?
> Also I have to install Reporting Services, Analysis Services & Sharepoint.
> Does everything works on Win x64?
> I'm using SQL Server 2000 enterprise edition.
> thanks for your answer.
> Jerome.
>|||what you really need; you need to wait for sql 2005 and it'll be a LOT
better|||unfortunatly its an hardware migration process.
we change an old server to a new one
so we can't deploy 2005.
but I have to insure that the 64bits edition (of SQL, RS, AS) works
correctly on Win 2003 x64.
if there is any issue or compatibility problem, I'll use the 32bit edition.
<dbahooker@.hotmail.com> wrote in message
news:1126900439.484602.107740@.g44g2000cwa.googlegroups.com...
> what you really need; you need to wait for sql 2005 and it'll be a LOT
> better
>|||Hi
No, 32 Bit plus SP4.
SQL Server 2000 64 Bit is complied for the Intel Itanium Processor and will
not run on Xeons.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Brian Lawton" <brian.k.lawton@.redtailcreek.com> wrote in message
news:%23QD6nsuuFHA.1472@.TK2MSFTNGP15.phx.gbl...
> You need the SQL Server 2000 (64-bit) edition.
> http://www.microsoft.com/sql/64bit/default.mspx
> --
> --Brian
> (Please reply to the newsgroups only.)
>
> "Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
> news:e%2313sduuFHA.3764@.TK2MSFTNGP09.phx.gbl...
>> Hi,
>> I have to install a new server and I am a little confused about working
>> combinations between 30bits, x64 and IA64...
>> My server use intel Xeon processors with EMT64.
>> So I want to install Windows 2003 x64 Ent.
>> but which version of SQL Server can I install?
>> the 64bits?
>> 32bits + SP4 (Sql2k64sp4.exe)?
>> Also I have to install Reporting Services, Analysis Services &
>> Sharepoint.
>> Does everything works on Win x64?
>> I'm using SQL Server 2000 enterprise edition.
>> thanks for your answer.
>> Jerome.
>>
>|||If you are going to install the 64-bit version of the Win2K3 make sure:
1) you install SP1 of Win2K3 x64 -- and
2) you use SP4
Both are required to run AS2K on x64 hardware with a 64-bit OS.
--
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
news:ONOy27vuFHA.2072@.TK2MSFTNGP14.phx.gbl...
> unfortunatly its an hardware migration process.
> we change an old server to a new one
> so we can't deploy 2005.
> but I have to insure that the 64bits edition (of SQL, RS, AS) works
> correctly on Win 2003 x64.
> if there is any issue or compatibility problem, I'll use the 32bit
> edition.
>
> <dbahooker@.hotmail.com> wrote in message
> news:1126900439.484602.107740@.g44g2000cwa.googlegroups.com...
>> what you really need; you need to wait for sql 2005 and it'll be a LOT
>> better
>|||Thankls.
I have all of this on my CD Roms...
so finally, there is no issue in mind(?)
"Dave Wickert [MSFT]" <dwickert@.online.microsoft.com> wrote in message
news:%23ultf2XvFHA.4032@.TK2MSFTNGP15.phx.gbl...
> If you are going to install the 64-bit version of the Win2K3 make sure:
> 1) you install SP1 of Win2K3 x64 -- and
> 2) you use SP4
> Both are required to run AS2K on x64 hardware with a 64-bit OS.
> --
> Dave Wickert [MSFT]
> dwickert@.online.microsoft.com
> Program Manager
> BI Systems Team
> SQL BI Product Unit (Analysis Services)
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
> news:ONOy27vuFHA.2072@.TK2MSFTNGP14.phx.gbl...
>> unfortunatly its an hardware migration process.
>> we change an old server to a new one
>> so we can't deploy 2005.
>> but I have to insure that the 64bits edition (of SQL, RS, AS) works
>> correctly on Win 2003 x64.
>> if there is any issue or compatibility problem, I'll use the 32bit
>> edition.
>>
>> <dbahooker@.hotmail.com> wrote in message
>> news:1126900439.484602.107740@.g44g2000cwa.googlegroups.com...
>> what you really need; you need to wait for sql 2005 and it'll be a LOT
>> better
>>
>|||I will be deploying this same setup... Windows 2003 Standard x64
Edition running SQL Server 2000 Enterprise Edition SP4. The server I'm
running on has 8GB of RAM. Does anyone know how much RAM SQL Server
will use? My understanding is that this is not an AWE situtation
because the OS can natively address all 8GB of RAM.
Any advice on maximizing this setup would be greatly appreciated.
Thanks.
--
george sarlas
gsarlas@.yahoo.com|||> My understanding is that this is not an AWE situtation
> because the OS can natively address all 8GB of RAM.
You are right, SQL Server can access up to 512Gb of RAM, which is the
maximum currently supported by Win2K3 Server.
--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell|||I've deployed the 1st of my 2 new 64-bit servers. I did have to enable
AWE in SQL Server. But to support more than 4GB of RAM, I needed to
install SQL 2000 SP4 and the SP4 AWE Hotfix
(http://support.microsoft.com/default.aspx?kbid=899761).
-george|||If you have 64bit SQL 2k you do not need to enable AWE. The knowledge
base article you quote only applies to 32bit SQL 2k. 64bit SQL 2k can
address the maximum amount of memory that Win2k3 can support (which is
512Gb) without turning on any special settings.
--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell
In article <1130256929.245741.68610@.g44g2000cwa.googlegroups.com>,
gsarlas@.yahoo.com says...
> I've deployed the 1st of my 2 new 64-bit servers. I did have to enable
> AWE in SQL Server. But to support more than 4GB of RAM, I needed to
> install SQL 2000 SP4 and the SP4 AWE Hotfix
> (http://support.microsoft.com/default.aspx?kbid=899761).
> -george
>|||Just for clarification...
Unfortunately, SQL Server 2000 64-bit Edition does not work with x64
processors. It only works with the Itanium processor. I am running
32-bit SQL Server 2000 on 64-bit Windows 2003, thus I had to enable
AWE.
-george
Darren Gosbell wrote:
> If you have 64bit SQL 2k you do not need to enable AWE. The knowledge
> base article you quote only applies to 32bit SQL 2k. 64bit SQL 2k can
> address the maximum amount of memory that Win2k3 can support (which is
> 512Gb) without turning on any special settings.
> --
> Regards
> Darren Gosbell [MCSD]
> <dgosbell_at_yahoo_dot_com>
> Blog: http://www.geekswithblogs.net/darrengosbell
> In article <1130256929.245741.68610@.g44g2000cwa.googlegroups.com>,
> gsarlas@.yahoo.com says...
> > I've deployed the 1st of my 2 new 64-bit servers. I did have to enable
> > AWE in SQL Server. But to support more than 4GB of RAM, I needed to
> > install SQL 2000 SP4 and the SP4 AWE Hotfix
> > (http://support.microsoft.com/default.aspx?kbid=899761).
> >
> > -george
> >
> >

new server to install, Win 2003 x64 will be used... which SQL Version?

Hi,
I have to install a new server and I am a little confused about working
combinations between 30bits, x64 and IA64...
My server use intel Xeon processors with EMT64.
So I want to install Windows 2003 x64 Ent.
but which version of SQL Server can I install?
the 64bits?
32bits + SP4 (Sql2k64sp4.exe)?
Also I have to install Reporting Services, Analysis Services & Sharepoint.
Does everything works on Win x64?
I'm using SQL Server 2000 enterprise edition.
thanks for your answer.
Jerome.You need the SQL Server 2000 (64-bit) edition.
http://www.microsoft.com/sql/64bit/default.mspx
--
--Brian
(Please reply to the newsgroups only.)
"Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
news:e%2313sduuFHA.3764@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I have to install a new server and I am a little confused about working
> combinations between 30bits, x64 and IA64...
> My server use intel Xeon processors with EMT64.
> So I want to install Windows 2003 x64 Ent.
> but which version of SQL Server can I install?
> the 64bits?
> 32bits + SP4 (Sql2k64sp4.exe)?
> Also I have to install Reporting Services, Analysis Services & Sharepoint.
> Does everything works on Win x64?
> I'm using SQL Server 2000 enterprise edition.
> thanks for your answer.
> Jerome.
>|||what you really need; you need to wait for sql 2005 and it'll be a LOT
better|||unfortunatly its an hardware migration process.
we change an old server to a new one
so we can't deploy 2005.
but I have to insure that the 64bits edition (of SQL, RS, AS) works
correctly on Win 2003 x64.
if there is any issue or compatibility problem, I'll use the 32bit edition.
<dbahooker@.hotmail.com> wrote in message
news:1126900439.484602.107740@.g44g2000cwa.googlegroups.com...
> what you really need; you need to wait for sql 2005 and it'll be a LOT
> better
>|||Hi
No, 32 Bit plus SP4.
SQL Server 2000 64 Bit is complied for the Intel Itanium Processor and will
not run on Xeons.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Brian Lawton" <brian.k.lawton@.redtailcreek.com> wrote in message
news:%23QD6nsuuFHA.1472@.TK2MSFTNGP15.phx.gbl...
> You need the SQL Server 2000 (64-bit) edition.
> http://www.microsoft.com/sql/64bit/default.mspx
> --
> --Brian
> (Please reply to the newsgroups only.)
>
> "Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
> news:e%2313sduuFHA.3764@.TK2MSFTNGP09.phx.gbl...
>> Hi,
>> I have to install a new server and I am a little confused about working
>> combinations between 30bits, x64 and IA64...
>> My server use intel Xeon processors with EMT64.
>> So I want to install Windows 2003 x64 Ent.
>> but which version of SQL Server can I install?
>> the 64bits?
>> 32bits + SP4 (Sql2k64sp4.exe)?
>> Also I have to install Reporting Services, Analysis Services &
>> Sharepoint.
>> Does everything works on Win x64?
>> I'm using SQL Server 2000 enterprise edition.
>> thanks for your answer.
>> Jerome.
>>
>|||If you are going to install the 64-bit version of the Win2K3 make sure:
1) you install SP1 of Win2K3 x64 -- and
2) you use SP4
Both are required to run AS2K on x64 hardware with a 64-bit OS.
--
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
news:ONOy27vuFHA.2072@.TK2MSFTNGP14.phx.gbl...
> unfortunatly its an hardware migration process.
> we change an old server to a new one
> so we can't deploy 2005.
> but I have to insure that the 64bits edition (of SQL, RS, AS) works
> correctly on Win 2003 x64.
> if there is any issue or compatibility problem, I'll use the 32bit
> edition.
>
> <dbahooker@.hotmail.com> wrote in message
> news:1126900439.484602.107740@.g44g2000cwa.googlegroups.com...
>> what you really need; you need to wait for sql 2005 and it'll be a LOT
>> better
>|||Thankls.
I have all of this on my CD Roms...
so finally, there is no issue in mind(?)
"Dave Wickert [MSFT]" <dwickert@.online.microsoft.com> wrote in message
news:%23ultf2XvFHA.4032@.TK2MSFTNGP15.phx.gbl...
> If you are going to install the 64-bit version of the Win2K3 make sure:
> 1) you install SP1 of Win2K3 x64 -- and
> 2) you use SP4
> Both are required to run AS2K on x64 hardware with a 64-bit OS.
> --
> Dave Wickert [MSFT]
> dwickert@.online.microsoft.com
> Program Manager
> BI Systems Team
> SQL BI Product Unit (Analysis Services)
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
> news:ONOy27vuFHA.2072@.TK2MSFTNGP14.phx.gbl...
>> unfortunatly its an hardware migration process.
>> we change an old server to a new one
>> so we can't deploy 2005.
>> but I have to insure that the 64bits edition (of SQL, RS, AS) works
>> correctly on Win 2003 x64.
>> if there is any issue or compatibility problem, I'll use the 32bit
>> edition.
>>
>> <dbahooker@.hotmail.com> wrote in message
>> news:1126900439.484602.107740@.g44g2000cwa.googlegroups.com...
>> what you really need; you need to wait for sql 2005 and it'll be a LOT
>> better
>>
>|||I will be deploying this same setup... Windows 2003 Standard x64
Edition running SQL Server 2000 Enterprise Edition SP4. The server I'm
running on has 8GB of RAM. Does anyone know how much RAM SQL Server
will use? My understanding is that this is not an AWE situtation
because the OS can natively address all 8GB of RAM.
Any advice on maximizing this setup would be greatly appreciated.
Thanks.
--
george sarlas
gsarlas@.yahoo.com|||> My understanding is that this is not an AWE situtation
> because the OS can natively address all 8GB of RAM.
You are right, SQL Server can access up to 512Gb of RAM, which is the
maximum currently supported by Win2K3 Server.
--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell|||I've deployed the 1st of my 2 new 64-bit servers. I did have to enable
AWE in SQL Server. But to support more than 4GB of RAM, I needed to
install SQL 2000 SP4 and the SP4 AWE Hotfix
(http://support.microsoft.com/default.aspx?kbid=899761).
-george|||If you have 64bit SQL 2k you do not need to enable AWE. The knowledge
base article you quote only applies to 32bit SQL 2k. 64bit SQL 2k can
address the maximum amount of memory that Win2k3 can support (which is
512Gb) without turning on any special settings.
--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell
In article <1130256929.245741.68610@.g44g2000cwa.googlegroups.com>,
gsarlas@.yahoo.com says...
> I've deployed the 1st of my 2 new 64-bit servers. I did have to enable
> AWE in SQL Server. But to support more than 4GB of RAM, I needed to
> install SQL 2000 SP4 and the SP4 AWE Hotfix
> (http://support.microsoft.com/default.aspx?kbid=899761).
> -george
>|||Just for clarification...
Unfortunately, SQL Server 2000 64-bit Edition does not work with x64
processors. It only works with the Itanium processor. I am running
32-bit SQL Server 2000 on 64-bit Windows 2003, thus I had to enable
AWE.
-george
Darren Gosbell wrote:
> If you have 64bit SQL 2k you do not need to enable AWE. The knowledge
> base article you quote only applies to 32bit SQL 2k. 64bit SQL 2k can
> address the maximum amount of memory that Win2k3 can support (which is
> 512Gb) without turning on any special settings.
> --
> Regards
> Darren Gosbell [MCSD]
> <dgosbell_at_yahoo_dot_com>
> Blog: http://www.geekswithblogs.net/darrengosbell
> In article <1130256929.245741.68610@.g44g2000cwa.googlegroups.com>,
> gsarlas@.yahoo.com says...
> > I've deployed the 1st of my 2 new 64-bit servers. I did have to enable
> > AWE in SQL Server. But to support more than 4GB of RAM, I needed to
> > install SQL 2000 SP4 and the SP4 AWE Hotfix
> > (http://support.microsoft.com/default.aspx?kbid=899761).
> >
> > -george
> >
> >

New Install Problem

Got past other issues.. now getting bad request...
I have this working wonderfully on my local machine... can't get it to work
on a Win2k3 server..
Anyone have any links?
w3wp!ui!690!10/7/2004-15:49:04:: e ERROR: The request failed with HTTP
status 400: Bad Request.
w3wp!ui!690!10/7/2004-15:49:04:: e ERROR: HTTP status code --> 500
--Details--
System.Net.WebException: The request failed with HTTP status 400: Bad
Request.
at
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClient
Message message, WebResponse response, Stream responseStream, Boolean
asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters)
at
Microsoft.SqlServer.ReportingServices.ReportingService.ListSecureMethods()
at Microsoft.SqlServer.ReportingServices.RSConnection.GetSecureMethods()
at Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()
at
Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String
methodname)
at Microsoft.ReportingServices.UI.Global.SecureAllAPI()
at
Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
level)
at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
sender, EventArgs args)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain()
w3wp!ui!690!10/7/2004-15:49:04:: e ERROR: Exception in ShowErrorPage:
System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean
preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean
preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg)One difference between Win2k3 server and 2000 pro (I've had it on both) is
that for Win2K3 for the service account you get the option of network
service or system. I picked system. Not sure if it makes a difference but I
have successfully installed on two Win2K3 machines this way. I haven't seen
the exact error but this is what worked for me.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
Service Account - use built-in account. Have two choices. Pick system, Not
network service
"CJ Taylor" <[cege] at [tavayn] dit commmmm> wrote in message
news:OBh%23$%23KrEHA.756@.TK2MSFTNGP11.phx.gbl...
> Got past other issues.. now getting bad request...
>
> I have this working wonderfully on my local machine... can't get it to
work
> on a Win2k3 server..
> Anyone have any links?
>
> w3wp!ui!690!10/7/2004-15:49:04:: e ERROR: The request failed with HTTP
> status 400: Bad Request.
> w3wp!ui!690!10/7/2004-15:49:04:: e ERROR: HTTP status code --> 500
> --Details--
> System.Net.WebException: The request failed with HTTP status 400: Bad
> Request.
> at
>
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClient
> Message message, WebResponse response, Stream responseStream, Boolean
> asyncCall)
> at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> methodName, Object[] parameters)
> at
> Microsoft.SqlServer.ReportingServices.ReportingService.ListSecureMethods()
> at
Microsoft.SqlServer.ReportingServices.RSConnection.GetSecureMethods()
> at
Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()
> at
> Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String
> methodname)
> at Microsoft.ReportingServices.UI.Global.SecureAllAPI()
> at
> Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
> level)
> at
Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
> sender, EventArgs args)
> at System.EventHandler.Invoke(Object sender, EventArgs e)
> at System.Web.UI.Control.OnInit(EventArgs e)
> at System.Web.UI.Control.InitRecursive(Control namingContainer)
> at System.Web.UI.Page.ProcessRequestMain()
> w3wp!ui!690!10/7/2004-15:49:04:: e ERROR: Exception in ShowErrorPage:
> System.Threading.ThreadAbortException: Thread was being aborted.
> at System.Threading.Thread.AbortInternal()
> at System.Threading.Thread.Abort(Object stateInfo)
> at System.Web.HttpResponse.End()
> at System.Web.HttpServerUtility.Transfer(String path, Boolean
> preserveForm)
> at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> errMsg) at at System.Threading.Thread.AbortInternal()
> at System.Threading.Thread.Abort(Object stateInfo)
> at System.Web.HttpResponse.End()
> at System.Web.HttpServerUtility.Transfer(String path, Boolean
> preserveForm)
> at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> errMsg)
>|||No dice... still getting bad request.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%236HPxGLrEHA.192@.tk2msftngp13.phx.gbl...
> One difference between Win2k3 server and 2000 pro (I've had it on both) is
> that for Win2K3 for the service account you get the option of network
> service or system. I picked system. Not sure if it makes a difference but
I
> have successfully installed on two Win2K3 machines this way. I haven't
seen
> the exact error but this is what worked for me.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> Service Account - use built-in account. Have two choices. Pick system, Not
> network service
> "CJ Taylor" <[cege] at [tavayn] dit commmmm> wrote in message
> news:OBh%23$%23KrEHA.756@.TK2MSFTNGP11.phx.gbl...
> > Got past other issues.. now getting bad request...
> >
> >
> > I have this working wonderfully on my local machine... can't get it to
> work
> > on a Win2k3 server..
> >
> > Anyone have any links?
> >
> >
> >
> > w3wp!ui!690!10/7/2004-15:49:04:: e ERROR: The request failed with HTTP
> > status 400: Bad Request.
> > w3wp!ui!690!10/7/2004-15:49:04:: e ERROR: HTTP status code --> 500
> > --Details--
> > System.Net.WebException: The request failed with HTTP status 400: Bad
> > Request.
> >
> > at
> >
>
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClient
> > Message message, WebResponse response, Stream responseStream, Boolean
> > asyncCall)
> >
> > at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> > methodName, Object[] parameters)
> >
> > at
> >
Microsoft.SqlServer.ReportingServices.ReportingService.ListSecureMethods()
> >
> > at
> Microsoft.SqlServer.ReportingServices.RSConnection.GetSecureMethods()
> >
> > at
> Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()
> >
> > at
> > Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String
> > methodname)
> >
> > at Microsoft.ReportingServices.UI.Global.SecureAllAPI()
> >
> > at
> > Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
> > level)
> >
> > at
> Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
> > sender, EventArgs args)
> >
> > at System.EventHandler.Invoke(Object sender, EventArgs e)
> >
> > at System.Web.UI.Control.OnInit(EventArgs e)
> >
> > at System.Web.UI.Control.InitRecursive(Control namingContainer)
> >
> > at System.Web.UI.Page.ProcessRequestMain()
> > w3wp!ui!690!10/7/2004-15:49:04:: e ERROR: Exception in ShowErrorPage:
> > System.Threading.ThreadAbortException: Thread was being aborted.
> > at System.Threading.Thread.AbortInternal()
> > at System.Threading.Thread.Abort(Object stateInfo)
> > at System.Web.HttpResponse.End()
> > at System.Web.HttpServerUtility.Transfer(String path, Boolean
> > preserveForm)
> > at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> > errMsg) at at System.Threading.Thread.AbortInternal()
> > at System.Threading.Thread.Abort(Object stateInfo)
> > at System.Web.HttpResponse.End()
> > at System.Web.HttpServerUtility.Transfer(String path, Boolean
> > preserveForm)
> > at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> > errMsg)
> >
> >
>|||I'm having the same issue. Could you advise on the fix?
Thanks,
John
"CJ Taylor" wrote:
> No dice... still getting bad request.
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:%236HPxGLrEHA.192@.tk2msftngp13.phx.gbl...
> > One difference between Win2k3 server and 2000 pro (I've had it on both) is
> > that for Win2K3 for the service account you get the option of network
> > service or system. I picked system. Not sure if it makes a difference but
> I
> > have successfully installed on two Win2K3 machines this way. I haven't
> seen
> > the exact error but this is what worked for me.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > Service Account - use built-in account. Have two choices. Pick system, Not
> > network service
> > "CJ Taylor" <[cege] at [tavayn] dit commmmm> wrote in message
> > news:OBh%23$%23KrEHA.756@.TK2MSFTNGP11.phx.gbl...
> > > Got past other issues.. now getting bad request...
> > >
> > >
> > > I have this working wonderfully on my local machine... can't get it to
> > work
> > > on a Win2k3 server..
> > >
> > > Anyone have any links?
> > >
> > >
> > >
> > > w3wp!ui!690!10/7/2004-15:49:04:: e ERROR: The request failed with HTTP
> > > status 400: Bad Request.
> > > w3wp!ui!690!10/7/2004-15:49:04:: e ERROR: HTTP status code --> 500
> > > --Details--
> > > System.Net.WebException: The request failed with HTTP status 400: Bad
> > > Request.
> > >
> > > at
> > >
> >
> System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClient
> > > Message message, WebResponse response, Stream responseStream, Boolean
> > > asyncCall)
> > >
> > > at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> > > methodName, Object[] parameters)
> > >
> > > at
> > >
> Microsoft.SqlServer.ReportingServices.ReportingService.ListSecureMethods()
> > >
> > > at
> > Microsoft.SqlServer.ReportingServices.RSConnection.GetSecureMethods()
> > >
> > > at
> > Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()
> > >
> > > at
> > > Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String
> > > methodname)
> > >
> > > at Microsoft.ReportingServices.UI.Global.SecureAllAPI()
> > >
> > > at
> > > Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
> > > level)
> > >
> > > at
> > Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
> > > sender, EventArgs args)
> > >
> > > at System.EventHandler.Invoke(Object sender, EventArgs e)
> > >
> > > at System.Web.UI.Control.OnInit(EventArgs e)
> > >
> > > at System.Web.UI.Control.InitRecursive(Control namingContainer)
> > >
> > > at System.Web.UI.Page.ProcessRequestMain()
> > > w3wp!ui!690!10/7/2004-15:49:04:: e ERROR: Exception in ShowErrorPage:
> > > System.Threading.ThreadAbortException: Thread was being aborted.
> > > at System.Threading.Thread.AbortInternal()
> > > at System.Threading.Thread.Abort(Object stateInfo)
> > > at System.Web.HttpResponse.End()
> > > at System.Web.HttpServerUtility.Transfer(String path, Boolean
> > > preserveForm)
> > > at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> > > errMsg) at at System.Threading.Thread.AbortInternal()
> > > at System.Threading.Thread.Abort(Object stateInfo)
> > > at System.Web.HttpResponse.End()
> > > at System.Web.HttpServerUtility.Transfer(String path, Boolean
> > > preserveForm)
> > > at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> > > errMsg)
> > >
> > >
> >
> >
>
>

New features of Broker?

Dear all,

I just got Katmai installed with BOL. But can't find anything useful for SB, i.e. What's New. I understand the doc team must be working on it now. Could anyone tell me:

1. Is Katmai SB still the ver. 1 of SB, or ver. 2?

2. Does Management Studio do more UI support for SB?

3. Will Katmai SB support the B2C scenario, i.e. Laptop behind NATs?

Best regards,

dong

1. Is Katmai SB still the ver. 1 of SB, or ver. 2?

I am not sure exactly what you mean by this question but Katmai is the second version of Sql Server that contains Service Broker. Sql 2005 was the first version that contained support for Service Broker.

2. Does Management Studio do more UI support for SB?

We do have plans to do more for Service Broker in the Management Studio UI in Katmai but that won't be coming until a later CTP.

3. Will Katmai SB support the B2C scenario, i.e. Laptop behind NATs?

Katmai will not have any new features to support Broker behind firewalls. I will send another post on the Service Broker Katmai features

|||

Hi Rick!

Nice to meet you here :-)

Here are some features, which might be very useful for the next release of Service Broker:

GUI support in SQL Server Management Studio Service Listing Manager inside SQL Management Studio :-) Multiple Service Broker endpoints per SQL Server Instance Don't deactivate the queue when a poison message occurs, only the service