Do I need x86, x64 or IA64?

Can anyone please help me select the correct version of SQL Server 2005
to order?
I'm running Windows Server 2003 Standard Edition on an AMD Opteron. Now
as far as I've been able to work out that rules out the IA64 which is
only for Intel Itanium based machines, but as for the choice between
x86 and x64 I am still confused. Does the x64 version need to be run on
a special x64 version of Windows 2003? And if so, how can I tell if
that's what I'm running?
Many thanks, TH.
Start|Run|msinfo32.exe should sort it.
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"TH" wrote:
| Can anyone please help me select the correct version of SQL Server 2005
| to order?
|
| I'm running Windows Server 2003 Standard Edition on an AMD Opteron. Now
| as far as I've been able to work out that rules out the IA64 which is
| only for Intel Itanium based machines, but as for the choice between
| x86 and x64 I am still confused. Does the x64 version need to be run on
| a special x64 version of Windows 2003? And if so, how can I tell if
| that's what I'm running?
|
| Many thanks, TH.
|
|||Thanks Dave. Msinfo32.exe seems to be telling me my Windows is 32 bit,
so does that mean that SQL Server x86 is the only version I can use,
even though the Opteron is a 64 bit processor?
Thanks again. TH.
|||Seems you need a 64 bit OS to take full advantage.
http://www.microsoft.com/sql/editions/64bit/overview.mspx
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"TH" wrote:
| Thanks Dave. Msinfo32.exe seems to be telling me my Windows is 32 bit,
| so does that mean that SQL Server x86 is the only version I can use,
| even though the Opteron is a 64 bit processor?
|
| Thanks again. TH.
|
|||Cheers Dave.
Dave Patrick wrote:

> Seems you need a 64 bit OS to take full advantage.
> http://www.microsoft.com/sql/editions/64bit/overview.mspx
> --
> Regards,
> Dave Patrick ...Please no email replies - reply in newsgroup.
> Microsoft Certified Professional
> Microsoft MVP [Windows]
|||You're welcome.
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"TH" wrote:
| Cheers Dave.

Do I need x86, x64 or IA64?

Can anyone please help me select the correct version of SQL Server 2005
to order?
I'm running Windows Server 2003 Standard Edition on an AMD Opteron. Now
as far as I've been able to work out that rules out the IA64 which is
only for Intel Itanium based machines, but as for the choice between
x86 and x64 I am still confused. Does the x64 version need to be run on
a special x64 version of Windows 2003? And if so, how can I tell if
that's what I'm running?
Many thanks, TH.Start|Run|msinfo32.exe should sort it.
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"TH" wrote:
| Can anyone please help me select the correct version of SQL Server 2005
| to order?
|
| I'm running Windows Server 2003 Standard Edition on an AMD Opteron. Now
| as far as I've been able to work out that rules out the IA64 which is
| only for Intel Itanium based machines, but as for the choice between
| x86 and x64 I am still confused. Does the x64 version need to be run on
| a special x64 version of Windows 2003? And if so, how can I tell if
| that's what I'm running?
|
| Many thanks, TH.
||||Thanks Dave. Msinfo32.exe seems to be telling me my Windows is 32 bit,
so does that mean that SQL Server x86 is the only version I can use,
even though the Opteron is a 64 bit processor?
Thanks again. TH.|||Seems you need a 64 bit OS to take full advantage.
http://www.microsoft.com/sql/editio...t/overview.mspx
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"TH" wrote:
| Thanks Dave. Msinfo32.exe seems to be telling me my Windows is 32 bit,
| so does that mean that SQL Server x86 is the only version I can use,
| even though the Opteron is a 64 bit processor?
|
| Thanks again. TH.
||||Cheers Dave.
Dave Patrick wrote:

> Seems you need a 64 bit OS to take full advantage.
> http://www.microsoft.com/sql/editio...t/overview.mspx
> --
> Regards,
> Dave Patrick ...Please no email replies - reply in newsgroup.
> Microsoft Certified Professional
> Microsoft MVP [Windows]|||You're welcome.
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"TH" wrote:
| Cheers Dave.sql

Do I need x86, x64 or IA64?

Can anyone please help me select the correct version of SQL Server 2005
to order?
I'm running Windows Server 2003 Standard Edition on an AMD Opteron. Now
as far as I've been able to work out that rules out the IA64 which is
only for Intel Itanium based machines, but as for the choice between
x86 and x64 I am still confused. Does the x64 version need to be run on
a special x64 version of Windows 2003? And if so, how can I tell if
that's what I'm running?
Many thanks, TH.Start|Run|msinfo32.exe should sort it.
--
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"TH" wrote:
| Can anyone please help me select the correct version of SQL Server 2005
| to order?
|
| I'm running Windows Server 2003 Standard Edition on an AMD Opteron. Now
| as far as I've been able to work out that rules out the IA64 which is
| only for Intel Itanium based machines, but as for the choice between
| x86 and x64 I am still confused. Does the x64 version need to be run on
| a special x64 version of Windows 2003? And if so, how can I tell if
| that's what I'm running?
|
| Many thanks, TH.
||||Thanks Dave. Msinfo32.exe seems to be telling me my Windows is 32 bit,
so does that mean that SQL Server x86 is the only version I can use,
even though the Opteron is a 64 bit processor?
Thanks again. TH.|||Seems you need a 64 bit OS to take full advantage.
http://www.microsoft.com/sql/editions/64bit/overview.mspx
--
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"TH" wrote:
| Thanks Dave. Msinfo32.exe seems to be telling me my Windows is 32 bit,
| so does that mean that SQL Server x86 is the only version I can use,
| even though the Opteron is a 64 bit processor?
|
| Thanks again. TH.
||||Cheers Dave.
Dave Patrick wrote:
> Seems you need a 64 bit OS to take full advantage.
> http://www.microsoft.com/sql/editions/64bit/overview.mspx
> --
> Regards,
> Dave Patrick ...Please no email replies - reply in newsgroup.
> Microsoft Certified Professional
> Microsoft MVP [Windows]|||You're welcome.
--
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"TH" wrote:
| Cheers Dave.

Do I need to add users for window Authentication?

I am trying to wrap the Windows Authentication in my brain. If I use window
authentication, do I add user through enterprise manager under Security tab
and logins. I want my user on my asp.net to login and connect to sql server,
but I windows Authentication. I don't want to add every single user. I'm I
on the right track?
thanks
Nick
Nick wrote:
> I am trying to wrap the Windows Authentication in my brain. If I use
> window authentication, do I add user through enterprise manager under
> Security tab and logins. I want my user on my asp.net to login and
> connect to sql server, but I windows Authentication. I don't want
> to add every single user. I'm I on the right track?
> thanks
> Nick
You can add a Windows Group that contains all the users.
David Gugick
Quest Software
www.imceda.com
www.quest.com

Do I need to add users for window Authentication?

I am trying to wrap the Windows Authentication in my brain. If I use window
authentication, do I add user through enterprise manager under Security tab
and logins. I want my user on my asp.net to login and connect to sql server
,
but I windows Authentication. I don't want to add every single user. I'm
I
on the right track?
thanks
NickNick wrote:
> I am trying to wrap the Windows Authentication in my brain. If I use
> window authentication, do I add user through enterprise manager under
> Security tab and logins. I want my user on my asp.net to login and
> connect to sql server, but I windows Authentication. I don't want
> to add every single user. I'm I on the right track?
> thanks
> Nick
You can add a Windows Group that contains all the users.
David Gugick
Quest Software
www.imceda.com
www.quest.comsql

Do I need to add users for window Authentication?

I am trying to wrap the Windows Authentication in my brain. If I use window
authentication, do I add user through enterprise manager under Security tab
and logins. I want my user on my asp.net to login and connect to sql server,
but I windows Authentication. I don't want to add every single user. I'm I
on the right track?
thanks
NickNick wrote:
> I am trying to wrap the Windows Authentication in my brain. If I use
> window authentication, do I add user through enterprise manager under
> Security tab and logins. I want my user on my asp.net to login and
> connect to sql server, but I windows Authentication. I don't want
> to add every single user. I'm I on the right track?
> thanks
> Nick
You can add a Windows Group that contains all the users.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com

do I need a domain in order to run a cluster?

Hi, I am a complete newbie with windows clustering -
still reading the white papers etc. From what I have read
it seems that I need a Windows Domain in order to run
clustering. Is this true? Is there any way I can cluster
SQL server without having to setup a domain?
thanks
christos
Yes. You must have a domain to run a cluster. No, you can't get around
having a domain.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Christos Kritikos" <anonymous@.discussions.microsoft.com> wrote in message
news:030001c49b56$400d9060$a301280a@.phx.gbl...
> Hi, I am a complete newbie with windows clustering -
> still reading the white papers etc. From what I have read
> it seems that I need a Windows Domain in order to run
> clustering. Is this true? Is there any way I can cluster
> SQL server without having to setup a domain?
> thanks
> christos
>
|||Hi Geoff,
I too have the same doubt. What are some Technical
reasons forcing cluster to run in a domain?
Thanks
Chip.
>--Original Message--
>Yes. You must have a domain to run a cluster. No, you
can't get around
>having a domain.
>--
>Geoff N. Hiten
>Microsoft SQL Server MVP
>Senior Database Administrator
>Careerbuilder.com
>I support the Professional Association for SQL Server
>www.sqlpass.org
>"Christos Kritikos"
<anonymous@.discussions.microsoft.com> wrote in message[vbcol=seagreen]
>news:030001c49b56$400d9060$a301280a@.phx.gbl...
read[vbcol=seagreen]
cluster
>
>.
>
|||You have to have a common security context for the cluster service to manage
resources on multiple machines. Parallel usernames and paswords will not
work. You have to have a domain (NT4 or AD) to provide cluster-wide access
to resources.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Chip" <anonymous@.discussions.microsoft.com> wrote in message
news:150e01c49c9d$f0cd9560$a301280a@.phx.gbl...[vbcol=seagreen]
> Hi Geoff,
> I too have the same doubt. What are some Technical
> reasons forcing cluster to run in a domain?
> Thanks
> Chip.
> can't get around
> <anonymous@.discussions.microsoft.com> wrote in message
> read
> cluster
|||There is some good information in
281662 Windows 2000 and Windows Server 2003 Cluster Nodes As Domain Controllers
http://support.microsoft.com/?id=281662
Here is a section from the same.
To have Windows Clustering function properly (where the Cluster service starts on each node) the node that forms the cluster must be able to validate the Cluster service domain account, which is the account that you
configure during the Windows Clustering installation. To accomplish this, each node must be able to establish a secure channel with a domain controller to validate this account. If the node cannot validate the
account, the Cluster service does not start. This is also true for other clustered programs that must have account validation for services to start, such as Microsoft SQL Server and Microsoft Exchange.
If you have a cluster deployment in which there is no link with either a Windows NT 4.0 domain, a Windows 2000 domain, or a Windows Server 2003 domain, you must configure the cluster nodes as domain
controllers so that the Cluster service account can always be validated to allow for proper cluster functionality.
If the connectivity between cluster nodes and domain controllers is such that the link is either slow or unreliable, consider having a domain controller co-located with the cluster, or configuring the cluster nodes as
domain controllers.
Consider the following important points when you are deploying Windows Clustering nodes as domain controllers:
--> See the above KB (http://support.microsoft.com/?id=281662)
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||Thanks Geoff & Uttam.
Chip
>--Original Message--
>There is some good information in
>281662 Windows 2000 and Windows Server 2003 Cluster Nodes
As Domain Controllers
>http://support.microsoft.com/?id=281662
>Here is a section from the same.
>To have Windows Clustering function properly (where the
Cluster service starts on each node) the node that forms
the cluster must be able to validate the Cluster service
domain account, which is the account that you
>configure during the Windows Clustering installation. To
accomplish this, each node must be able to establish a
secure channel with a domain controller to validate this
account. If the node cannot validate the
>account, the Cluster service does not start. This is also
true for other clustered programs that must have account
validation for services to start, such as Microsoft SQL
Server and Microsoft Exchange.
>If you have a cluster deployment in which there is no
link with either a Windows NT 4.0 domain, a Windows 2000
domain, or a Windows Server 2003 domain, you must
configure the cluster nodes as domain
>controllers so that the Cluster service account can
always be validated to allow for proper cluster
functionality.
>If the connectivity between cluster nodes and domain
controllers is such that the link is either slow or
unreliable, consider having a domain controller co-located
with the cluster, or configuring the cluster nodes as
>domain controllers.
>Consider the following important points when you are
deploying Windows Clustering nodes as domain controllers:
> --> See the above KB
(http://support.microsoft.com/?id=281662)
>Best Regards,
>Uttam Parui
>Microsoft Corporation
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>Are you secure? For information about the Strategic
Technology Protection Program and to order your FREE
Security Tool Kit, please visit
http://www.microsoft.com/security.
>Microsoft highly recommends that users with Internet
access update their Microsoft software to better protect
against viruses and security vulnerabilities. The easiest
way to do this is to visit the following websites:
>http://www.microsoft.com/protect
>http://www.microsoft.com/security/guidance/default.mspx
>
>.
>

do I need a DBA for SQL Server?

We currently run an Oracle 8i db for Oracle Applications 10.7. We are
considering moving away from this whole infrastructure to Windows 2003
Server and SQL Server 2005 with a new ERP system.

Currently, we have an Oracle DBA under contract who performs all of the
maintenance required, plus does any and all fixes to the db when there
are problems.

What I have been asked, and couldn't comfortably answer, is do we need
the same sort of arrangement for SQL Server? We have plenty of Windows
server experience in house, but only minor SQL Server experience (I can
set up maintenance jobs, backups, user admin, etc.). If something bad
happens to the ERP system, and the ERP vendor determines that the
problem is not with their app but is with the db itself, how do I get
this resolved quickly? Should I have a contract with a 3rd party to
cover us should this scenario occur?

Thanks for any and all feedback.
Regards,
BrianIf you are in the UK then give me a call and we can sort out a support
contract.

Personally, I'd give a couple of your internal guys some training to bring
them up to a support level for SQL Server and then rely on experts on call
if things go wrong.

A full time DBA is probably going to be expensive if they aren't doing
anything else.

The role of a pure DBA within the SQL Server has reduced somewhat, they tend
to do development but a lot do Business Intelligence stuff now as well.

Hope that helps.

--
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials

"Brian" <barmand@.amphenolpcd.com> wrote in message
news:1138807906.362534.91700@.g49g2000cwa.googlegro ups.com...
> We currently run an Oracle 8i db for Oracle Applications 10.7. We are
> considering moving away from this whole infrastructure to Windows 2003
> Server and SQL Server 2005 with a new ERP system.
> Currently, we have an Oracle DBA under contract who performs all of the
> maintenance required, plus does any and all fixes to the db when there
> are problems.
> What I have been asked, and couldn't comfortably answer, is do we need
> the same sort of arrangement for SQL Server? We have plenty of Windows
> server experience in house, but only minor SQL Server experience (I can
> set up maintenance jobs, backups, user admin, etc.). If something bad
> happens to the ERP system, and the ERP vendor determines that the
> problem is not with their app but is with the db itself, how do I get
> this resolved quickly? Should I have a contract with a 3rd party to
> cover us should this scenario occur?
> Thanks for any and all feedback.
> Regards,
> Brian

Do I need /PAE to enable AWE memory?

Hi All
I am running Windows 2000 Advanced Server with SQL 2K
Enterprise. I now have 8 GB of RAM and am using the /3GB
switch in the BOOT.INI file. I want to enable AWE within
SQL but some documentation says that the /PAE switch is
also required within the BOOT.INI file. Is this correct?
I don't want to use the /PAE unless I have to.
Will the /3GB switch, together with enabling AWE in SQL
allow SQL to see all but 128MB of the 8GB of RAM (i.e.
no /PAE)?
Many thanks
H
Sample boot.ini for 8GB memory usage:
[boot loader]
timeout=30
default=multi(0)disk(0)rdisk(0)partition(1)\WINNT
[operating systems]
multi(0)disk(0)rdisk(0)partition(1)\WINNT="Microso ft Windows 2000 Advanced Server" /fastdetect /PAE
multi(0)disk(0)rdisk(0)partition(2)\WINNT="Microso ft W2K 2000 Advanced Server" /fastdetect /PAE
JBandi
|||No. Without PAE the server only sees up to 4GB.
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

Do I need /PAE to enable AWE memory?

Hi All
I am running Windows 2000 Advanced Server with SQL 2K
Enterprise. I now have 8 GB of RAM and am using the /3GB
switch in the BOOT.INI file. I want to enable AWE within
SQL but some documentation says that the /PAE switch is
also required within the BOOT.INI file. Is this correct?
I don't want to use the /PAE unless I have to.
Will the /3GB switch, together with enabling AWE in SQL
allow SQL to see all but 128MB of the 8GB of RAM (i.e.
no /PAE)?
Many thanks
HSample boot.ini for 8GB memory usage:
[boot loader]
timeout=30
default=multi(0)disk(0)rdisk(0)partition
(1)\WINNT
[operating systems]
multi(0)disk(0)rdisk(0)partition(1)\WINN
T="Microsoft Windows 2000 Advanced S
erver" /fastdetect /PAE
multi(0)disk(0)rdisk(0)partition(2)\WINN
T="Microsoft W2K 2000 Advanced Serve
r" /fastdetect /PAE
JBandi|||No. Without PAE the server only sees up to 4GB.
****************************************
******************************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET
resources...

Do i ned a Windows Server for MSDE with windows authentification ?

Hi
From the local PC windows authentication seems to work, but from remote pc's
te client seems to logon as guest.
Do i need to install MSDE on a windows server edition to get the windows
authentication working ?
SQL Authentication works from remote machines, but becorse the password is
sent as cleartext over the network i would like to use the Windows
authentication.
Can someone give me an answer on this ? ( i want to move some app from using
acces to sql server).
Hope someone helps me.
Johan.
Hi,
no you don=B4t need a Windows Server to use Windows Authentication. As
long as the machine is in the same domain and uses a service account
which is able to check the identity of the user on the domain
controller you are able to use Windows Authentication.
If you are using WIndows XP you have to disbale "Simple FIle and
Printer Sharing"
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
sql

Do I have to install IIS 6 for reporting Services?

Right now we have IIS 5.0 installed on Windows 2000 server. Could we use
reporting services under this configuration?Yes. I used that before I upgraded to 2003 Server. You do have to install
the 1.1 framework so if you have other apps that run with 1.0 you can do
this but you will need to jump through some hoops to have your website use
both.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Mike Moore" <MikeMoore@.discussions.microsoft.com> wrote in message
news:19079E1D-8F3F-48EF-915C-222D7E6D1A26@.microsoft.com...
> Right now we have IIS 5.0 installed on Windows 2000 server. Could we use
> reporting services under this configuration?

DNS on Windows 2000 Server & Windows 2003 Server

We are having numerous issues with disconnects after upgrading our PDC to a
Windows 2003 environment. We have several Windows 2000 Servers running SQL
Databases that users connect to. The issue as described in my post found
under client connections is that the network connection is good but we are
getting RPC errors & "The object invoked disconnected message". Our Windows
2003 Server is running DNS. It was suggested by a developer to install the
DNS windows components found under networking on all other servers.
Will this work? Or will we cause DNS issues as a result of it?Hi
Installing DNS on every server will not solve your problem.
DNS Service in Windows 2003 is reliable so there is not need to setup many
of them.
What the the exact error number and error messages you are getting? Are any
errors logged in the SQL Event Log?
Regards
Mike
"Cstewart" wrote:

> We are having numerous issues with disconnects after upgrading our PDC to
a
> Windows 2003 environment. We have several Windows 2000 Servers running SQ
L
> Databases that users connect to. The issue as described in my post found
> under client connections is that the network connection is good but we are
> getting RPC errors & "The object invoked disconnected message". Our Windo
ws
> 2003 Server is running DNS. It was suggested by a developer to install th
e
> DNS windows components found under networking on all other servers.
> Will this work? Or will we cause DNS issues as a result of it?
>|||The errors that are appearing on the client side are as follows:
"The object invoked has disconnected from its clients" and/or "RPC server
unavailable"
Here is more information that I posted previously:
We have recently upgraded our main server from NT4 to Active Directory
(Windows 2003 Server). Our SQL Database is 2000 and is running on a Windows
2000 Server Box. We use com+ components to connect to our database. Since
the change on our PDC to 2003 Server AD, we have had several errors such as
"The object invoked has disconnected from its clients" as well as RPC Server
Unavailable. This occurs even when the user is consistently active. We hav
e
applied latest Windows Service Pack to clients xp sp2 and to the windows 200
0
server box. If you reboot the server and or/stop services (Com+ and Dcom) o
n
the client end, they can get back in. You can browse to the machine no
problem through exporer - right to the database. Issue is only in SQL 2000.
Any assistance would be greatly appreciated. Note: I have also checked
using netstat -a to see if all ports were being used and that is not the
case. This is happening on more than one users connection and I am certain
it is not network based - ping 100%, can browse, two locations within
building etc.
Note: Problems occur regardless if client is at Service Pack 2 or 1.
I have checked the event log on the server and nothing reported. I have
checked the error logs in the SQL directory of Logs and nothing reported.
Any suggestion as to what other logs (if any) to look at?
Thank you for your assistance.
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> Installing DNS on every server will not solve your problem.
> DNS Service in Windows 2003 is reliable so there is not need to setup many
> of them.
> What the the exact error number and error messages you are getting? Are an
y
> errors logged in the SQL Event Log?
> Regards
> Mike
> "Cstewart" wrote:
>

DNS on Windows 2000 Server & Windows 2003 Server

We are having numerous issues with disconnects after upgrading our PDC to a
Windows 2003 environment. We have several Windows 2000 Servers running SQL
Databases that users connect to. The issue as described in my post found
under client connections is that the network connection is good but we are
getting RPC errors & "The object invoked disconnected message". Our Windows
2003 Server is running DNS. It was suggested by a developer to install the
DNS windows components found under networking on all other servers.
Will this work? Or will we cause DNS issues as a result of it?Hi
Installing DNS on every server will not solve your problem.
DNS Service in Windows 2003 is reliable so there is not need to setup many
of them.
What the the exact error number and error messages you are getting? Are any
errors logged in the SQL Event Log?
Regards
Mike
"Cstewart" wrote:
> We are having numerous issues with disconnects after upgrading our PDC to a
> Windows 2003 environment. We have several Windows 2000 Servers running SQL
> Databases that users connect to. The issue as described in my post found
> under client connections is that the network connection is good but we are
> getting RPC errors & "The object invoked disconnected message". Our Windows
> 2003 Server is running DNS. It was suggested by a developer to install the
> DNS windows components found under networking on all other servers.
> Will this work? Or will we cause DNS issues as a result of it?
>|||The errors that are appearing on the client side are as follows:
"The object invoked has disconnected from its clients" and/or "RPC server
unavailable"
Here is more information that I posted previously:
We have recently upgraded our main server from NT4 to Active Directory
(Windows 2003 Server). Our SQL Database is 2000 and is running on a Windows
2000 Server Box. We use com+ components to connect to our database. Since
the change on our PDC to 2003 Server AD, we have had several errors such as
"The object invoked has disconnected from its clients" as well as RPC Server
Unavailable. This occurs even when the user is consistently active. We have
applied latest Windows Service Pack to clients xp sp2 and to the windows 2000
server box. If you reboot the server and or/stop services (Com+ and Dcom) on
the client end, they can get back in. You can browse to the machine no
problem through exporer - right to the database. Issue is only in SQL 2000.
Any assistance would be greatly appreciated. Note: I have also checked
using netstat -a to see if all ports were being used and that is not the
case. This is happening on more than one users connection and I am certain
it is not network based - ping 100%, can browse, two locations within
building etc.
Note: Problems occur regardless if client is at Service Pack 2 or 1.
I have checked the event log on the server and nothing reported. I have
checked the error logs in the SQL directory of Logs and nothing reported.
Any suggestion as to what other logs (if any) to look at?
Thank you for your assistance.
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> Installing DNS on every server will not solve your problem.
> DNS Service in Windows 2003 is reliable so there is not need to setup many
> of them.
> What the the exact error number and error messages you are getting? Are any
> errors logged in the SQL Event Log?
> Regards
> Mike
> "Cstewart" wrote:
> > We are having numerous issues with disconnects after upgrading our PDC to a
> > Windows 2003 environment. We have several Windows 2000 Servers running SQL
> > Databases that users connect to. The issue as described in my post found
> > under client connections is that the network connection is good but we are
> > getting RPC errors & "The object invoked disconnected message". Our Windows
> > 2003 Server is running DNS. It was suggested by a developer to install the
> > DNS windows components found under networking on all other servers.
> >
> > Will this work? Or will we cause DNS issues as a result of it?
> >
> >

DNS on Windows 2000 Server & Windows 2003 Server

We are having numerous issues with disconnects after upgrading our PDC to a
Windows 2003 environment. We have several Windows 2000 Servers running SQL
Databases that users connect to. The issue as described in my post found
under client connections is that the network connection is good but we are
getting RPC errors & "The object invoked disconnected message". Our Windows
2003 Server is running DNS. It was suggested by a developer to install the
DNS windows components found under networking on all other servers.
Will this work? Or will we cause DNS issues as a result of it?
Hi
Installing DNS on every server will not solve your problem.
DNS Service in Windows 2003 is reliable so there is not need to setup many
of them.
What the the exact error number and error messages you are getting? Are any
errors logged in the SQL Event Log?
Regards
Mike
"Cstewart" wrote:

> We are having numerous issues with disconnects after upgrading our PDC to a
> Windows 2003 environment. We have several Windows 2000 Servers running SQL
> Databases that users connect to. The issue as described in my post found
> under client connections is that the network connection is good but we are
> getting RPC errors & "The object invoked disconnected message". Our Windows
> 2003 Server is running DNS. It was suggested by a developer to install the
> DNS windows components found under networking on all other servers.
> Will this work? Or will we cause DNS issues as a result of it?
>
|||The errors that are appearing on the client side are as follows:
"The object invoked has disconnected from its clients" and/or "RPC server
unavailable"
Here is more information that I posted previously:
We have recently upgraded our main server from NT4 to Active Directory
(Windows 2003 Server). Our SQL Database is 2000 and is running on a Windows
2000 Server Box. We use com+ components to connect to our database. Since
the change on our PDC to 2003 Server AD, we have had several errors such as
"The object invoked has disconnected from its clients" as well as RPC Server
Unavailable. This occurs even when the user is consistently active. We have
applied latest Windows Service Pack to clients xp sp2 and to the windows 2000
server box. If you reboot the server and or/stop services (Com+ and Dcom) on
the client end, they can get back in. You can browse to the machine no
problem through exporer - right to the database. Issue is only in SQL 2000.
Any assistance would be greatly appreciated. Note: I have also checked
using netstat -a to see if all ports were being used and that is not the
case. This is happening on more than one users connection and I am certain
it is not network based - ping 100%, can browse, two locations within
building etc.
Note: Problems occur regardless if client is at Service Pack 2 or 1.
I have checked the event log on the server and nothing reported. I have
checked the error logs in the SQL directory of Logs and nothing reported.
Any suggestion as to what other logs (if any) to look at?
Thank you for your assistance.
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> Installing DNS on every server will not solve your problem.
> DNS Service in Windows 2003 is reliable so there is not need to setup many
> of them.
> What the the exact error number and error messages you are getting? Are any
> errors logged in the SQL Event Log?
> Regards
> Mike
> "Cstewart" wrote:

DMZ, MSDTC and Windows Server 2003 SP1

Hi, did somebody know a checklist or Q-Article how to configure MSDTC
between
two SQL Server in two separate DMZ (Firewall Ports) ?
Further, I must find out which impact has Windows Server SP1 on MSDTC or
better
on a BizTalk 2004 Server.
Thanks for all Infos.
Hi
Check out "INFO: Configuring Microsoft Distributed Transaction Coordinator
(DTC) to Work Through a Firewall" http://support.microsoft.com/kb/250367/
Service Pack 1 enforces tighter security, if you can test the installation
on another system it would help but not guarantee there will not be issues.
You may want to run MBSA to see what it throws before you install the service
pack as these may be potential problem areas.
John
"MV" wrote:

> Hi, did somebody know a checklist or Q-Article how to configure MSDTC
> between
> two SQL Server in two separate DMZ (Firewall Ports) ?
> Further, I must find out which impact has Windows Server SP1 on MSDTC or
> better
> on a BizTalk 2004 Server.
> Thanks for all Infos.
>
>

DMZ, MSDTC and Windows Server 2003 SP1

Hi, did somebody know a checklist or Q-Article how to configure MSDTC
between
two SQL Server in two separate DMZ (Firewall Ports) ?
Further, I must find out which impact has Windows Server SP1 on MSDTC or
better
on a BizTalk 2004 Server.
Thanks for all Infos.Hi
Check out "INFO: Configuring Microsoft Distributed Transaction Coordinator
(DTC) to Work Through a Firewall" http://support.microsoft.com/kb/250367/
Service Pack 1 enforces tighter security, if you can test the installation
on another system it would help but not guarantee there will not be issues.
You may want to run MBSA to see what it throws before you install the service
pack as these may be potential problem areas.
John
"MV" wrote:
> Hi, did somebody know a checklist or Q-Article how to configure MSDTC
> between
> two SQL Server in two separate DMZ (Firewall Ports) ?
> Further, I must find out which impact has Windows Server SP1 on MSDTC or
> better
> on a BizTalk 2004 Server.
> Thanks for all Infos.
>
>

DMZ, MSDTC and Windows Server 2003 SP1

Hi, did somebody know a checklist or Q-Article how to configure MSDTC
between
two SQL Server in two separate DMZ (Firewall Ports) ?
Further, I must find out which impact has Windows Server SP1 on MSDTC or
better
on a BizTalk 2004 Server.
Thanks for all Infos.Hi
Check out "INFO: Configuring Microsoft Distributed Transaction Coordinator
(DTC) to Work Through a Firewall" http://support.microsoft.com/kb/250367/
Service Pack 1 enforces tighter security, if you can test the installation
on another system it would help but not guarantee there will not be issues.
You may want to run MBSA to see what it throws before you install the servic
e
pack as these may be potential problem areas.
John
"MV" wrote:

> Hi, did somebody know a checklist or Q-Article how to configure MSDTC
> between
> two SQL Server in two separate DMZ (Firewall Ports) ?
> Further, I must find out which impact has Windows Server SP1 on MSDTC or
> better
> on a BizTalk 2004 Server.
> Thanks for all Infos.
>
>

DMO and Windows Authentication

I'd like to use DMO to browse for databases on our SQL Servers using Windows Authneitication, rather than the SQL Server Authentication with login and password. Is this possible. This is the chuck of code that I've borrowed to do it so far. Can you make the Connection without the user and password?

Thanks,

Howie

Set SQLInstance = New SQLDMO.SQLServer
'Connect to the server by name (from global variable)
SQLInstance.Connect t_Server, t_User, t_Password
'Set the instance to that server ID
SQLSrvrID = SQLInstance.ConnectionID
Set SQLInstance = SQL2000.SQLServers.ItemById(SQLSrvrID)

'Display the available databases in a list box
ListDatabases.Clear
x = 1
For Each DB In SQLInstance.Databases
'Do not add system databases to the list
If Not SQLInstance.Databases(x).SystemObject Then
Me.ListDatabases.AddItem (SQLInstance.Databases(x).name)
End If
x = x + 1
Next

Just as an added question, does anyone know how you might go about exploring for data sources in VB, either with ADO or DMO? These would be the ODBC data source that you would create by:

Control Panel

Administrative Tools

Data Sources(ODBC)

Once in the Data Sources application, you pick a name for the data source, and then locate and define the server and associated database.

Thanks gain for any ideas,

Howie

|||I am using VB6 and I can easily get the username using the API

Private Declare Function GetUserName Lib "advapi32.dll" Alias "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long

|||' login using windows authentication
SQLInstance.LoginSecure = True
SQLInstance.Connect sServer

You don't need the API above.. thanks to Josh on his website for the answer!

Josh Fruits
http://www.programmers-corner.com

josh@.programmerscorner.com

DM Windows Forms Controls in November Feature Pack for SS2005

Hello,

There is a download in the Feature Pack For Microsoft SQL Server 2005 - November 2005 for the Microsoft SQL Server 2005 Datamining Viewer Controls. Unfortunately I cannot find a shred of documentation for said controls. It would be nice to know what their names are, where they are installed, how you add them to your toolbox. Sample apps would be of great benefit as well (but I don't want to ask for too much).

Here is the description for the controls which I find somewhat confusing. Are they Web Controls or Windows Forms Controls?

The Data Mining Web Controls Library is a set of Microsoft Windows Forms controls that enable software developers to display data mining models created using Microsoft SQL Server 2005 Analysis Services in their client-side applications.

Wendell G.

I agree that documentation would be useful. In the meantime, this sample that demonstrates how to embed the viewer controls (which *are* Winform controls and not web controls, as the description mistakenly indicates) might help:

http://www.sqlserverdatamining.com/DMCommunity/Downloads/Links_LinkRedirector.aspx?id=1362

|||

Wow Raman, this is incredible! Thank you so much.

It appears these controls are the controls that the Business Intelligence Developer's Studio is built with. Does anyone know if these controls are redistributable? I am especially interested in the Microsoft.AnalysisServices.Controls, Microsoft.AnalysisServices.Graphing, and Microsoft.AnalysisServices.Viewers.

Do the controls require Analysis Services to be installed on the deployed workstation?

If Microsoft does not have these documented, is anyone writing a developer's book that explains how to use them?

Thanks again!

Wendell G

|||

Yup, these are the viewer controls hosted in BI Dev Studio and SQL Mgmt Studio and they *are* redistributable. The controls don't require an AS install on the workstation - they only require a subset of client components (just the AS 9.0 OLE DB driver, I believe - the install should pop up the appropriate prerequisites if they are missing).

We are hoping to provide documentation in a web refresh but I don't have a timeframe yet.