Installing new performance dashboard for SQL Server 2005 SP2

Hi All,
I tried to install the new performance dashboards on 2005 sp2 on
windows 2003 and received the following error messages.
Has anyone seen these before? I know it is quite new...
Thanks
Peter
Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
'object_schema_name' is not a recognized built-in function name.
Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
Incorrect syntax near the keyword 'as'.
Msg 15151, Level 16, State 1, Line 1
Cannot find the object 'usp_GetPageDetails', because it does not exist
or you do not have permission.Did you run the sql script that came with the download?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Peter Nolan" <peter@.peternolan.com> wrote in message
news:1177505070.696147.173040@.n35g2000prd.googlegroups.com...
> Hi All,
> I tried to install the new performance dashboards on 2005 sp2 on
> windows 2003 and received the following error messages.
> Has anyone seen these before? I know it is quite new...
> Thanks
> Peter
>
> Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
> 'object_schema_name' is not a recognized built-in function name.
> Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
> Incorrect syntax near the keyword 'as'.
> Msg 15151, Level 16, State 1, Line 1
> Cannot find the object 'usp_GetPageDetails', because it does not exist
> or you do not have permission.
>|||The fact that you get an error about 'object_schema_name' suggests SP2 is
not installed on the instance since this is a new function added by SP2. Try
(re)applying SP2 to the instance to see if that resolves the issue.
--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
http://sqlblogcasts.com/blogs/sqldbatips
"Peter Nolan" <peter@.peternolan.com> wrote in message
news:1177505070.696147.173040@.n35g2000prd.googlegroups.com...
> Hi All,
> I tried to install the new performance dashboards on 2005 sp2 on
> windows 2003 and received the following error messages.
> Has anyone seen these before? I know it is quite new...
> Thanks
> Peter
>
> Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
> 'object_schema_name' is not a recognized built-in function name.
> Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
> Incorrect syntax near the keyword 'as'.
> Msg 15151, Level 16, State 1, Line 1
> Cannot find the object 'usp_GetPageDetails', because it does not exist
> or you do not have permission.
>|||> GUEST wrote
> Hi All
> I tried to install the new performance dashboards on 2005 sp2 o
> windows 2003 and received the following error messages
>
> Has anyone seen these before? I know it is quite new..
>
> Thank
>
> Pete
>
>
> Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 2
> 'object_schema_name' is not a recognized built-in function name
> Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 4
> Incorrect syntax near the keyword 'as'
> Msg 15151, Level 16, State 1, Line
> Cannot find the object 'usp_GetPageDetails', because it does no
exis
> or you do not have permission
I am getting the same error
What is the fix for this if the server is on sp2|||On May 22, 6:54 pm, stacey.do...@.shawinc-dot-com.no-spam.invalid
(sdoran) wrote:
> > GUEST wrote:
> > Hi All,
> > I tried to install the new performance dashboards on 2005 sp2 on
> > windows 2003 and received the following error messages.
> >
> > Has anyone seen these before? I know it is quite new...
> >
> > Thanks
> >
> > Peter
> >
> >
> > Msg 195, Level 15, State 10, Procedureusp_GetPageDetails, Line 27
> > 'object_schema_name' is not a recognized built-in function name.
> > Msg 156, Level 15, State 1, Procedureusp_GetPageDetails, Line 42
> > Incorrect syntax near the keyword 'as'.
> > Msg 15151, Level 16, State 1, Line 1
> > Cannot find the object 'usp_GetPageDetails', because it does not
> exist
> > or you do not have permission.
> I am getting the same error.
> What is the fix for this if the server is on sp2?
Same error here - SQL 2005 SP2 Latest hotfixes, etc. Any fix for
this?

Installing MSDE200A on Windows 2003

I have done a freresh install of Windows 2003, patches and now trying to
install MSDE RelA.
I use the command line "SETUP SAPWD="Password"" and it appears to install
successfully. I restart. When I try to install an application that uses
MSDE it claims there is no database.
I do a "netstat -an" and do not see anything listening on port 1433. I've
uninstalled and reinstalled with no change. What am I doing wrong?
Hi
In Control Panel > Services, Is the MSDE service there and running?
Regards
Mike
"Brian" wrote:

> I have done a freresh install of Windows 2003, patches and now trying to
> install MSDE RelA.
> I use the command line "SETUP SAPWD="Password"" and it appears to install
> successfully. I restart. When I try to install an application that uses
> MSDE it claims there is no database.
> I do a "netstat -an" and do not see anything listening on port 1433. I've
> uninstalled and reinstalled with no change. What am I doing wrong?
|||I do "Net Start" and MSSQLSERVER is listed. It is also displayed in the gui
as automatic and running.
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> In Control Panel > Services, Is the MSDE service there and running?
> Regards
> Mike
> "Brian" wrote:
|||MSDE installs by default with Windows Security only. Setting an sa password
doesn't influence that. You also have to add SECURITYMODE=SQL to your setup
script if you want to use SQL Security.
You can change an MSDE installation to use SQL Security after it has been
installed by changing the registry key
HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\Lo ginMode to 2.
See:
http://support.microsoft.com/default...b;en-us;285097
for extensive info.
Jacco Schalkwijk
SQL Server MVP
"Brian" <Brian@.discussions.microsoft.com> wrote in message
news:7B17BA79-2F77-47D2-AAB1-99C3495885EC@.microsoft.com...
>I have done a freresh install of Windows 2003, patches and now trying to
> install MSDE RelA.
> I use the command line "SETUP SAPWD="Password"" and it appears to install
> successfully. I restart. When I try to install an application that uses
> MSDE it claims there is no database.
> I do a "netstat -an" and do not see anything listening on port 1433. I've
> uninstalled and reinstalled with no change. What am I doing wrong?
|||Brian,
By default MSDE RelA installs with TCP protocol turned off for security
reasons. Use svrnetcn.exe in the Binn folder to enable protocols and
configure ports.
Ron Allen
"Brian" <Brian@.discussions.microsoft.com> wrote in message
news:7B17BA79-2F77-47D2-AAB1-99C3495885EC@.microsoft.com...
>I have done a freresh install of Windows 2003, patches and now trying to
> install MSDE RelA.
> I use the command line "SETUP SAPWD="Password"" and it appears to install
> successfully. I restart. When I try to install an application that uses
> MSDE it claims there is no database.
> I do a "netstat -an" and do not see anything listening on port 1433. I've
> uninstalled and reinstalled with no change. What am I doing wrong?

Installing MSDE 2000 on Server with SQL 2005 Express

Can anybody help?

I have a Windows XP and 2003 server; we have installed SQL 2005 Express on it but have an application that installs MSDE 2000 to connect to an application. After the MSDE 2000 is installed we can no longer see the instance across the network. If we uninstall the SQL 2005 express version we can see the Instance in MSDE 2000.

Is there any compatibility issue with install MSDE 2000 after SQL 2005 has been installed.

Many Thanks in advance

David

In general, this should work. There are specific limitations, which I think are well spelled out in BOL. Here's a copy and paste; hopefully this will describe your issue:

In SQL Server 2000, the identification of the server connection endpoints was performed by the SQL Server service. SQL Server 2005 replaces that function with the SQL Server Browser service. If you install SQL Server on a computer that is also running SQL Server 2000 or MSDE, you must ensure that SQL Server 2000 or MSDE is upgraded to Service Pack 3 (SP3) or later. Versions prior to SP3 do not properly share port 1434 and may not make your SQL Server instances available to requesting client applications. Although you can change the services startup order so that the SQL Server Browser service starts before SQL Server 2000 or MSDE, the recommended resolution is to update all older versions of SQL Server to the latest service pack.

When an instance of SQL Server 2000 is installed on the computer, if the SQL Server Browser is not running, the SQL Server 2000 listener service starts. If SQL Server Browser starts after the listener service, it waits 5 seconds for SQL Server 2000 to give up port 1434. If that does not occur, SQL Server Browser fails to start. To resolve this problem with versions of SQL Server 2000 prior to service pack 3, stop SQL Server 2000, start SQL Server Browser, then restart SQL Server 2000. The SQL Server 2000 listener service continues to attempt to start on port 1434, so the SQL Server 2000 instance should be upgraded to service pack 3 as soon as possible.

SQL Server 7.0 had no similar capabilities and has no conflicts with SQL Server Browser.

Installing MSDE

Hi All,

I need help installing MSDE. I am using Windows XP. When I download it and try to set the password with the Command Prompt, it doesn't work. When I setup XP my username became the Admin. When I open the Command Prompt, it defaults into my documents and setting - I can't get a C:\ prompt. My login is the Admin and the old Administrator account isn't listed anywhere on my computer. Am I screwed? Do I have to reinstall XP and have the seperate Admin account? Please help.

Thanks,
TonyOK - I got it installed. When I rebooted the Icon came up but it's not connecting. It says there is no Service available. How do I set up a Service? I am running IIS5 on Windows XP Pro.

Installing MS SQL Server 2000

:p Hi,
I've MS SQL Server 6.5 installed in my Windows 2000 machine. Is it possible to install MS SQL Server 2000 personal or standard edition in the same machine without upgrading or removing the old SQL Server 6,5 ?
Thanks in advance.yes

books online {Working with Named and Multiple Instances of SQL Server 2000}|||Thanks Scott, I did it.

installing MS SQL on server with sybase ASA

I'm getting ready to install MS SQL 2005 Enterprise Ed. on a Windows 2003
server. This server already has Sybase Adaptive Server Anywhere Version 9
installed with few db running. Do you think there would be any
problems/conflicts if I install MS SQL on this machine?
My other question is what ports does MS SQL uses to connect to db?
Here are the specifications of the server:
Dell PowerEdge 2850
Dual Xeon 2.8 GHz
2 GB RAM
Thanks.
Answer for your second question:
If your SQL Server is a default instance, then it'd use only static ports
(1433 by default). If it's a named instance, then it'd use dynamic ports (by
default) however you can set the ports as static after installation. UDP
1434 port is used to let clients know what the dynamic port is.
You can find more info about this from the following KB:
http://support.microsoft.com/kb/823938
Ekrem ?nsoy
"matsui" <u40159@.uwe> wrote in message news:7d44c706d1cfe@.uwe...
> I'm getting ready to install MS SQL 2005 Enterprise Ed. on a Windows 2003
> server. This server already has Sybase Adaptive Server Anywhere Version 9
> installed with few db running. Do you think there would be any
> problems/conflicts if I install MS SQL on this machine?
> My other question is what ports does MS SQL uses to connect to db?
> Here are the specifications of the server:
> Dell PowerEdge 2850
> Dual Xeon 2.8 GHz
> 2 GB RAM
> Thanks.
>
|||Thankyou.
Ekrem ?nsoy wrote:[vbcol=seagreen]
>Answer for your second question:
>If your SQL Server is a default instance, then it'd use only static ports
>(1433 by default). If it's a named instance, then it'd use dynamic ports (by
>default) however you can set the ports as static after installation. UDP
>1434 port is used to let clients know what the dynamic port is.
>You can find more info about this from the following KB:
>http://support.microsoft.com/kb/823938
>[quoted text clipped - 9 lines]
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums.aspx/sql-server/200712/1

installing MS SQL on server with sybase ASA

I'm getting ready to install MS SQL 2005 Enterprise Ed. on a Windows 2003
server. This server already has Sybase Adaptive Server Anywhere Version 9
installed with few db running. Do you think there would be any
problems/conflicts if I install MS SQL on this machine?
My other question is what ports does MS SQL uses to connect to db?
Here are the specifications of the server:
Dell PowerEdge 2850
Dual Xeon 2.8 GHz
2 GB RAM
Thanks.Answer for your second question:
If your SQL Server is a default instance, then it'd use only static ports
(1433 by default). If it's a named instance, then it'd use dynamic ports (by
default) however you can set the ports as static after installation. UDP
1434 port is used to let clients know what the dynamic port is.
You can find more info about this from the following KB:
http://support.microsoft.com/kb/823938
--
Ekrem Ã?nsoy
"matsui" <u40159@.uwe> wrote in message news:7d44c706d1cfe@.uwe...
> I'm getting ready to install MS SQL 2005 Enterprise Ed. on a Windows 2003
> server. This server already has Sybase Adaptive Server Anywhere Version 9
> installed with few db running. Do you think there would be any
> problems/conflicts if I install MS SQL on this machine?
> My other question is what ports does MS SQL uses to connect to db?
> Here are the specifications of the server:
> Dell PowerEdge 2850
> Dual Xeon 2.8 GHz
> 2 GB RAM
> Thanks.
>|||Thankyou.
Ekrem Ã?nsoy wrote:
>Answer for your second question:
>If your SQL Server is a default instance, then it'd use only static ports
>(1433 by default). If it's a named instance, then it'd use dynamic ports (by
>default) however you can set the ports as static after installation. UDP
>1434 port is used to let clients know what the dynamic port is.
>You can find more info about this from the following KB:
>http://support.microsoft.com/kb/823938
>> I'm getting ready to install MS SQL 2005 Enterprise Ed. on a Windows 2003
>> server. This server already has Sybase Adaptive Server Anywhere Version 9
>[quoted text clipped - 9 lines]
>> Thanks.
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200712/1sql

installing MS SQL on server with sybase ASA

I'm getting ready to install MS SQL 2005 Enterprise Ed. on a Windows 2003
server. This server already has Sybase Adaptive Server Anywhere Version 9
installed with few db running. Do you think there would be any
problems/conflicts if I install MS SQL on this machine?
My other question is what ports does MS SQL uses to connect to db?
Here are the specifications of the server:
Dell PowerEdge 2850
Dual Xeon 2.8 GHz
2 GB RAM
Thanks.Answer for your second question:
If your SQL Server is a default instance, then it'd use only static ports
(1433 by default). If it's a named instance, then it'd use dynamic ports (by
default) however you can set the ports as static after installation. UDP
1434 port is used to let clients know what the dynamic port is.
You can find more info about this from the following KB:
http://support.microsoft.com/kb/823938
Ekrem ?nsoy
"matsui" <u40159@.uwe> wrote in message news:7d44c706d1cfe@.uwe...
> I'm getting ready to install MS SQL 2005 Enterprise Ed. on a Windows 2003
> server. This server already has Sybase Adaptive Server Anywhere Version 9
> installed with few db running. Do you think there would be any
> problems/conflicts if I install MS SQL on this machine?
> My other question is what ports does MS SQL uses to connect to db?
> Here are the specifications of the server:
> Dell PowerEdge 2850
> Dual Xeon 2.8 GHz
> 2 GB RAM
> Thanks.
>|||Thankyou.
Ekrem ?nsoy wrote:[vbcol=seagreen]
>Answer for your second question:
>If your SQL Server is a default instance, then it'd use only static ports
>(1433 by default). If it's a named instance, then it'd use dynamic ports (b
y
>default) however you can set the ports as static after installation. UDP
>1434 port is used to let clients know what the dynamic port is.
>You can find more info about this from the following KB:
>http://support.microsoft.com/kb/823938
>
>[quoted text clipped - 9 lines]
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200712/1

Installing MS SQL 6.5 on Win 2003 Server

Is it possible to install MS SQL 6.5 on Windows 2003?
Can you give some information if it is possible by some Patches or MDAC
? or any spesific SP?suhas wrote:
> Is it possible to install MS SQL 6.5 on Windows 2003?
> Can you give some information if it is possible by some Patches or MDAC
> ? or any spesific SP?
>
Right click the setup.exe, set the compatability to NT 4.0?
.~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org
/ v \ Simplicity is Beauty! May the Force and Farce be with you!
/( _ )\ (Ubuntu 6.06) Linux 2.6.17.6
^ ^ 21:36:01 up 10 days 4:59 0 users load average: 1.00 1.00 1.00
news://news.3home.netnews://news.hkpcug.orgnews://news.newsgroup.com.hk

Installing MS SQL 6.5 on Win 2003 Server

Is it possible to install MS SQL 6.5 on Windows 2003?
Can you give some information if it is possible by some Patches or MDAC
? or any spesific SP?suhas wrote:
> Is it possible to install MS SQL 6.5 on Windows 2003?
> Can you give some information if it is possible by some Patches or MDAC
> ? or any spesific SP?
>
Right click the setup.exe, set the compatability to NT 4.0?
--
.~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org
/ v \ Simplicity is Beauty! May the Force and Farce be with you!
/( _ )\ (Ubuntu 6.06) Linux 2.6.17.6
^ ^ 21:36:01 up 10 days 4:59 0 users load average: 1.00 1.00 1.00
news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk

Installing MS Reporting Services Probs

Hi NG
We have a problem to install the MS Reporting Services 2000 on a Windows
2003 Server Web Edition.
IIS is propertly installed, runing, and its serves many wepages.
During the installation (System prequestites check) of RS comes the
following message:
"IIS either not installed or not configured for a server component
installation"
We have no idea, how we can configure the IIS for server component
installations.
Thx for help.
Greets TomSeems you can only install Reporting Services Developer Edition on Windows
2003 server Web edition:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsinstall/htm/gs_installingrs_v1_8jom.asp
Or maybe you can try setting it up as a web farm, as your database will have
to be running on a different server anyway:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsinstall/htm/gs_installingrs_v1_8jom.asp
Kaisa M. Lindahl Lervik
"news.microsoft.com" <thomas.scholtke@.rbc-is.ch> wrote in message
news:ukqWIurPGHA.532@.TK2MSFTNGP15.phx.gbl...
> Hi NG
> We have a problem to install the MS Reporting Services 2000 on a Windows
> 2003 Server Web Edition.
> IIS is propertly installed, runing, and its serves many wepages.
> During the installation (System prequestites check) of RS comes the
> following message:
> "IIS either not installed or not configured for a server component
> installation"
> We have no idea, how we can configure the IIS for server component
> installations.
> Thx for help.
> Greets Tom
>

Installing cluster in Windows 2000 + 2003

I have a Windows 2000 that crashed and was part of a active/active SQL cluster (SQL 2000).
Instead of reinstall the box with Windows 2000, I reinstalled it with Windows 2003 Advanced.
In Cluster Administrator (on the Windows 2003 box), I am trying to add the node, and I always get the following error:
- sql1: The list of nodes to configure is empty.
- Error 0x800713ac: A cluster node is not available for this operation.
here's the content of the log:
2004-04-02 13:34:10.084 [INFO] [CConnPointEnum::HrAddConnection] punk 0x0cd808 added to the connection point enumerator. (hr=00000000)
2004-04-02 13:34:10.214 [INFO] [CConnPointEnum::HrAddConnection] punk 0x0ce2f8 added to the connection point enumerator. (hr=00000000)
2004-04-02 13:34:25.195 [INFO] [WIZ] Setting analyze page active. Setting aborted to FALSE.
2004-04-02 13:34:25.336 [INFO] [MT] [CTaskAnalyzeClusterBase] Beginning task...
2004-04-02 13:34:25.446 [INFO] CLUSTER2: Checking for an existing cluster... (hr=00000000, {FDC75680-7DBB-42CA-8003-E4CDB01FF062},
{B8453B8F-92FD-4350-A6D9-551FD018B791}, 0, 90, 0), (null)
2004-04-02 13:34:25.556 [INFO] [CTaskAnalyzeClusterBase] Setting completion cookie 4 at array index 0 into the gather cluster information
task for node CLUSTER2.shop.clic.net
2004-04-02 13:34:25.656 [INFO] [MT] The name to connect to is 'CLUSTER2'.
2004-04-02 13:34:25.736 [INFO] [MT] Requesting a remote connection to 'CLUSTER2'.
2004-04-02 13:34:25.846 [INFO] CLUSTER2: The DNS record for "CLUSTER2.shop.clic.net" is "192.168.0.233". (hr=00000000,
{B8453B8F-92FD-4350-A6D9-551FD018B791}, {D86FAAD9-2514-451E-B359-435AF35E6038}, 1, 1, 1), (null)
2004-04-02 13:34:25.937 [INFO] sql1: Requesting a remote connection to "CLUSTER2" in domain "shop.clic.net" with binding string
"192.168.0.233" (hr=00000000, {B8453B8F-92FD-4350-A6D9-551FD018B791}, {26015CA7-EAE1-43F4-AC1E-718D80629E93}, 1, 1, 1), (null)
2004-04-02 13:34:26.067 [INFO] [MT] Connection to 'CLUSTER2' with binding string '192.168.0.233' failed because one or more classes are not
registered.
2004-04-02 13:34:26.187 [INFO] CLUSTER2: The DNS record for "CLUSTER2.shop.clic.net" is "192.168.0.233". (hr=00000000,
{B8453B8F-92FD-4350-A6D9-551FD018B791}, {D86FAAD9-2514-451E-B359-435AF35E6038}, 1, 1, 1), (null)
2004-04-02 13:34:26.427 [INFO] [MT:CTaskAnalyzeClusterBase] Looking for the completion cookie 1.
2004-04-02 13:34:26.537 [INFO] [MT:CTaskAnalyzeClusterBase] Looking for the completion cookie 4.
2004-04-02 13:34:26.628 [INFO] [CTaskAnalyzeClusterBase] Clearing completion cookie 4 at array index 0
2004-04-02 13:34:26.658 [INFO] CLUSTER2: (null) (hr=00000000, {FDC75680-7DBB-42CA-8003-E4CDB01FF062},
{B8453B8F-92FD-4350-A6D9-551FD018B791}, 0, 90, 1), (null)
2004-04-02 13:34:26.718 [INFO] [MT] [CTaskGatherClusterInfo] exiting task. The task was not cancelled.
2004-04-02 13:34:26.808 [INFO] CLUSTER2: (null) (hr=00000000, {FDC75680-7DBB-42CA-8003-E4CDB01FF062},
{B8453B8F-92FD-4350-A6D9-551FD018B791}, 0, 90, 2), (null)
2004-04-02 13:34:26.988 [INFO] [MT] Adding node 'SQL1.shop.clic.net' to the list of user-added nodes.
2004-04-02 13:34:27.128 [INFO] CLUSTER2: Collecting nodes currently in the cluster... (hr=00000000, {EBC8AEFF-10C3-4D5B-AC17-FC0F4C3871B7},
{72A04E74-2D14-4AD8-8E12-4AFBA56FD0E0}, 0, 1, 0), (null)
2004-04-02 13:34:27.389 [INFO] [MT] Connecting to cluster node 'SQL2.shop.clic.net'
2004-04-02 13:34:27.519 [INFO] CLUSTER2: Collecting nodes currently in the cluster... (hr=00000000, {EBC8AEFF-10C3-4D5B-AC17-FC0F4C3871B7},
{72A04E74-2D14-4AD8-8E12-4AFBA56FD0E0}, 0, 1, 1), (null)
2004-04-02 13:34:27.649 [INFO] CLUSTER2: (null) (hr=00000000, {FDC75680-7DBB-42CA-8003-E4CDB01FF062},
{B8453B8F-92FD-4350-A6D9-551FD018B791}, 0, 90, 90), (null)
2004-04-02 13:34:27.789 [INFO] sql1: (null) (hr=00000000, {FDC75680-7DBB-42CA-8003-E4CDB01FF062}, {93C32F99-39CA-4D38-9D7F-2707CA0EAF46}, 0,
90, 0), (null)
2004-04-02 13:34:27.919 [INFO] CLUSTER2: (null) (hr=00000000, {FDC75680-7DBB-42CA-8003-E4CDB01FF062},
{CC5E57B1-4520-4672-B4BA-A288EC42946E}, 0, 90, 0), (null)
2004-04-02 13:34:28.050 [INFO] [CTaskAnalyzeClusterBase] Setting completion cookie 6 at array index 0 into the gather node information task
for node SQL1.shop.clic.net
2004-04-02 13:34:28.190 [INFO] [CTaskAnalyzeClusterBase] Setting completion cookie 7 at array index 1 into the gather node information task
for node SQL2.shop.clic.net
2004-04-02 13:34:28.190 [INFO] SQL1: Connecting to server... (hr=00000000, {93C32F99-39CA-4D38-9D7F-2707CA0EAF46},
{E88B08DD-2460-4DF1-B5C2-28587DD164EA}, 0, 1, 0), (null)
2004-04-02 13:34:28.320 [INFO] SQL2: Connecting to server... (hr=00000000, {93C32F99-39CA-4D38-9D7F-2707CA0EAF46},
{E88B08DD-2460-4DF1-B5C2-28587DD164EA}, 0, 1, 0), (null)
2004-04-02 13:34:28.460 [INFO] [MT] The name to connect to is 'SQL1'.
2004-04-02 13:34:28.590 [INFO] [MT] The name to connect to is 'SQL2'.
2004-04-02 13:34:28.721 [INFO] [MT] Requesting a local connection to 'SQL1'.
2004-04-02 13:34:28.851 [INFO] [MT] Requesting a remote connection to 'SQL2'.
2004-04-02 13:34:29.061 [WARN] sql1: This node is already a member of a cluster, but the cluster service is not running. This node will not
be configured at this time. (hr=0x000001, {93C32F99-39CA-4D38-9D7F-2707CA0EAF46}, {8028BF97-2D57-4628-845D-C4BEFFEB531A}, 1, 1, 1), The
cluster service on this node is configured but is not currently running. This node will be skipped and no further tasks will be performed on
it. If this node is not supposed to be a member of any cluster, then clean it up using the "cluster node /forcecleanup" command and try
again.
2004-04-02 13:34:29.131 [INFO] SQL2: The DNS record for "SQL2.shop.clic.net" is "192.168.0.242". (hr=00000000,
{93C32F99-39CA-4D38-9D7F-2707CA0EAF46}, {D86FAAD9-2514-451E-B359-435AF35E6038}, 1, 1, 1), (null)
2004-04-02 13:34:29.271 [WARN] sql1: This node is already a member of a cluster, but the cluster service is not running. This node will not
be configured at this time. (hr=0x000001, {93C32F99-39CA-4D38-9D7F-2707CA0EAF46}, {8028BF97-2D57-4628-845D-C4BEFFEB531A}, 1, 1, 1), The
cluster service on this node is configured but is not currently running. This node will be skipped and no further tasks will be performed on
it. If this node is not supposed to be a member of any cluster, then clean it up using the "cluster node /forcecleanup" command and try
again.
2004-04-02 13:34:29.402 [INFO] sql1: Requesting remote connections... (hr=00000000, {93C32F99-39CA-4D38-9D7F-2707CA0EAF46},
{1B606398-7193-4A48-AFBD-98AC8BACB690}, 1, 1, 1), (null)
2004-04-02 13:34:29.542 [INFO] [SRV] The cluster service is down on this node.
2004-04-02 13:34:29.672 [INFO] sql1: Requesting a remote connection to "SQL2" in domain "shop.clic.net" with binding string "192.168.0.242"
(hr=00000000, {1B606398-7193-4A48-AFBD-98AC8BACB690}, {7DCE2976-3E89-4683-8980-B41130CBABD9}, 1, 1, 1), (null)
2004-04-02 13:34:29.812 [INFO] [SRV] CClusCfgClusterInfo::Initialize() returning (hr=0x0713ba)
2004-04-02 13:34:29.962 [INFO] [MT] Connection to 'SQL2' with binding string '192.168.0.242' failed because one or more classes are not
registered.
2004-04-02 13:34:30.093 [WARN] sql1: GetClusterConfigInfo() completed. (hr=0x0713ba, {05AA0768-5F49-49CD-AFDC-96F9D51802D4},
{B460EA73-6223-44FA-84E0-DE7EC069DDD4}, 1, 1, 1), (null)
2004-04-02 13:34:30.253 [INFO] SQL2: The DNS record for "SQL2.shop.clic.net" is "192.168.0.242". (hr=00000000,
{93C32F99-39CA-4D38-9D7F-2707CA0EAF46}, {D86FAAD9-2514-451E-B359-435AF35E6038}, 1, 1, 1), (null)
2004-04-02 13:34:30.403 [WARN] sql1: The cluster configuration server has been started. (hr=0x0713ba,
{93C32F99-39CA-4D38-9D7F-2707CA0EAF46}, {39371CBA-A47B-4A4F-9042-6BECD321E9E2}, 1, 1, 1), (null)
2004-04-02 13:34:30.613 [INFO] [MT:CTaskAnalyzeClusterBase] Looking for the completion cookie 5.
2004-04-02 13:34:30.663 [WARN] sql1: The cluster configuration server has been started. (hr=0x0713ba,
{93C32F99-39CA-4D38-9D7F-2707CA0EAF46}, {39371CBA-A47B-4A4F-9042-6BECD321E9E2}, 1, 1, 1), (null)
2004-04-02 13:34:30.804 [INFO] SQL2: (null) (hr=00000000, {93C32F99-39CA-4D38-9D7F-2707CA0EAF46}, {E88B08DD-2460-4DF1-B5C2-28587DD164EA}, 0,
1, 1), (null)
2004-04-02 13:34:30.964 [INFO] [MT] The cluster service on node 'SQL1' is down.
2004-04-02 13:34:31.084 [INFO] [MT:CTaskAnalyzeClusterBase] Looking for the completion cookie 7.
2004-04-02 13:34:31.244 [WARN] SQL1: (null) (hr=0x0713ba, {93C32F99-39CA-4D38-9D7F-2707CA0EAF46}, {E88B08DD-2460-4DF1-B5C2-28587DD164EA}, 0,
1, 1), (null)
2004-04-02 13:34:31.414 [INFO] [CTaskAnalyzeClusterBase] Clearing completion cookie 7 at array index 1
2004-04-02 13:34:31.545 [INFO] [MT:CTaskAnalyzeClusterBase] Looking for the completion cookie 6.
2004-04-02 13:34:31.675 [INFO] [MT] [CTaskGatherNodeInfo] exiting task. The task was not cancelled.
2004-04-02 13:34:31.805 [INFO] [CTaskAnalyzeClusterBase] Clearing completion cookie 6 at array index 0
2004-04-02 13:34:32.075 [INFO] sql1: (null) (hr=00000000, {FDC75680-7DBB-42CA-8003-E4CDB01FF062}, {93C32F99-39CA-4D38-9D7F-2707CA0EAF46}, 0,
90, 1), (null)
2004-04-02 13:34:32.075 [INFO] [MT] [CTaskGatherNodeInfo] exiting task. The task was not cancelled.
2004-04-02 13:34:32.216 [ERR ] sql1: The list of nodes to configure is empty. (hr=0x800713ac, {93C32F99-39CA-4D38-9D7F-2707CA0EAF46},
{A678963B-9173-4393-B21B-0B4337B28EE2}, 1, 1, 1), (null)
2004-04-02 13:34:32.486 [INFO] CLUSTER2: (null) (hr=00000000, {FDC75680-7DBB-42CA-8003-E4CDB01FF062},
{CC5E57B1-4520-4672-B4BA-A288EC42946E}, 0, 90, 90), (null)
2004-04-02 13:34:32.626 [INFO] [MT] [CTaskAnalyzeClusterBase] Exiting task. The task was not cancelled.
SQL1 is the Windows 2003 box newly installed and SQL2 is the old Windows 2000 box.
Can anyone see anything wrong?
Thanks in advance.
Paul
My Cluster Service does not want to start on SQL1. Event Viewer says:
Event Type:Error
Event Source:Service Control Manager
Event Category:None
Event ID:7031
Date:4/2/2004
Time:1:39:12 PM
User:N/A
Computer:SQL1
Description:
The Cluster Service service terminated unexpectedly. It has done this 4 time(s). The following corrective action will be taken in 480000
milliseconds: Restart the service.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
What do you suggest?
Paul
|||Paul,
As the log indicates try adding the new node (SQL1) after cleaning it up
using the "cluster node /forcecleanup" command.
2004-04-02 13:34:29.061 [WARN] sql1: This node is already a member of a
cluster, but the cluster service is not running. This node will not
be configured at this time. (hr=0x000001,
{93C32F99-39CA-4D38-9D7F-2707CA0EAF46},
{8028BF97-2D57-4628-845D-C4BEFFEB531A}, 1, 1, 1), The
cluster service on this node is configured but is not currently running.
This node will be skipped and no further tasks will be performed on
it. If this node is not supposed to be a member of any cluster, then clean
it up using the "cluster node /forcecleanup" command and try
again.
Hope this helps.
Regards,
Shon Shah
Software Test Engineer
Microsoft Cluster Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples, if any, are subject to the terms specified
at http://www.microsoft.com/info/cpyright.htm
"Paul Dube" <pdube@.clic.net> wrote in message
news:4dcr6016mhj94s2cvet4hqhjvblhgf72fp@.4ax.com...
> I have a Windows 2000 that crashed and was part of a active/active SQL
cluster (SQL 2000).
> Instead of reinstall the box with Windows 2000, I reinstalled it with
Windows 2003 Advanced.
> In Cluster Administrator (on the Windows 2003 box), I am trying to add the
node, and I always get the following error:
> - sql1: The list of nodes to configure is empty.
> - Error 0x800713ac: A cluster node is not available for this operation.
> here's the content of the log:
> 2004-04-02 13:34:10.084 [INFO] [CConnPointEnum::HrAddConnection] punk
0x0cd808 added to the connection point enumerator. (hr=00000000)
> 2004-04-02 13:34:10.214 [INFO] [CConnPointEnum::HrAddConnection] punk
0x0ce2f8 added to the connection point enumerator. (hr=00000000)
> 2004-04-02 13:34:25.195 [INFO] [WIZ] Setting analyze page active. Setting
aborted to FALSE.
> 2004-04-02 13:34:25.336 [INFO] [MT] [CTaskAnalyzeClusterBase] Beginning
task...
> 2004-04-02 13:34:25.446 [INFO] CLUSTER2: Checking for an existing
cluster... (hr=00000000, {FDC75680-7DBB-42CA-8003-E4CDB01FF062},
> {B8453B8F-92FD-4350-A6D9-551FD018B791}, 0, 90, 0), (null)
> 2004-04-02 13:34:25.556 [INFO] [CTaskAnalyzeClusterBase] Setting
completion cookie 4 at array index 0 into the gather cluster information
> task for node CLUSTER2.shop.clic.net
> 2004-04-02 13:34:25.656 [INFO] [MT] The name to connect to is 'CLUSTER2'.
> 2004-04-02 13:34:25.736 [INFO] [MT] Requesting a remote connection to
'CLUSTER2'.
> 2004-04-02 13:34:25.846 [INFO] CLUSTER2: The DNS record for
"CLUSTER2.shop.clic.net" is "192.168.0.233". (hr=00000000,
> {B8453B8F-92FD-4350-A6D9-551FD018B791},
{D86FAAD9-2514-451E-B359-435AF35E6038}, 1, 1, 1), (null)
> 2004-04-02 13:34:25.937 [INFO] sql1: Requesting a remote connection to
"CLUSTER2" in domain "shop.clic.net" with binding string
> "192.168.0.233" (hr=00000000, {B8453B8F-92FD-4350-A6D9-551FD018B791},
{26015CA7-EAE1-43F4-AC1E-718D80629E93}, 1, 1, 1), (null)
> 2004-04-02 13:34:26.067 [INFO] [MT] Connection to 'CLUSTER2' with binding
string '192.168.0.233' failed because one or more classes are not
> registered.
> 2004-04-02 13:34:26.187 [INFO] CLUSTER2: The DNS record for
"CLUSTER2.shop.clic.net" is "192.168.0.233". (hr=00000000,
> {B8453B8F-92FD-4350-A6D9-551FD018B791},
{D86FAAD9-2514-451E-B359-435AF35E6038}, 1, 1, 1), (null)
> 2004-04-02 13:34:26.427 [INFO] [MT:CTaskAnalyzeClusterBase] Looking for
the completion cookie 1.
> 2004-04-02 13:34:26.537 [INFO] [MT:CTaskAnalyzeClusterBase] Looking for
the completion cookie 4.
> 2004-04-02 13:34:26.628 [INFO] [CTaskAnalyzeClusterBase] Clearing
completion cookie 4 at array index 0
> 2004-04-02 13:34:26.658 [INFO] CLUSTER2: (null) (hr=00000000,
{FDC75680-7DBB-42CA-8003-E4CDB01FF062},
> {B8453B8F-92FD-4350-A6D9-551FD018B791}, 0, 90, 1), (null)
> 2004-04-02 13:34:26.718 [INFO] [MT] [CTaskGatherClusterInfo] exiting task.
The task was not cancelled.
> 2004-04-02 13:34:26.808 [INFO] CLUSTER2: (null) (hr=00000000,
{FDC75680-7DBB-42CA-8003-E4CDB01FF062},
> {B8453B8F-92FD-4350-A6D9-551FD018B791}, 0, 90, 2), (null)
> 2004-04-02 13:34:26.988 [INFO] [MT] Adding node 'SQL1.shop.clic.net' to
the list of user-added nodes.
> 2004-04-02 13:34:27.128 [INFO] CLUSTER2: Collecting nodes currently in the
cluster... (hr=00000000, {EBC8AEFF-10C3-4D5B-AC17-FC0F4C3871B7},
> {72A04E74-2D14-4AD8-8E12-4AFBA56FD0E0}, 0, 1, 0), (null)
> 2004-04-02 13:34:27.389 [INFO] [MT] Connecting to cluster node
'SQL2.shop.clic.net'
> 2004-04-02 13:34:27.519 [INFO] CLUSTER2: Collecting nodes currently in the
cluster... (hr=00000000, {EBC8AEFF-10C3-4D5B-AC17-FC0F4C3871B7},
> {72A04E74-2D14-4AD8-8E12-4AFBA56FD0E0}, 0, 1, 1), (null)
> 2004-04-02 13:34:27.649 [INFO] CLUSTER2: (null) (hr=00000000,
{FDC75680-7DBB-42CA-8003-E4CDB01FF062},
> {B8453B8F-92FD-4350-A6D9-551FD018B791}, 0, 90, 90), (null)
> 2004-04-02 13:34:27.789 [INFO] sql1: (null) (hr=00000000,
{FDC75680-7DBB-42CA-8003-E4CDB01FF062},
{93C32F99-39CA-4D38-9D7F-2707CA0EAF46}, 0,
> 90, 0), (null)
> 2004-04-02 13:34:27.919 [INFO] CLUSTER2: (null) (hr=00000000,
{FDC75680-7DBB-42CA-8003-E4CDB01FF062},
> {CC5E57B1-4520-4672-B4BA-A288EC42946E}, 0, 90, 0), (null)
> 2004-04-02 13:34:28.050 [INFO] [CTaskAnalyzeClusterBase] Setting
completion cookie 6 at array index 0 into the gather node information task
> for node SQL1.shop.clic.net
> 2004-04-02 13:34:28.190 [INFO] [CTaskAnalyzeClusterBase] Setting
completion cookie 7 at array index 1 into the gather node information task
> for node SQL2.shop.clic.net
> 2004-04-02 13:34:28.190 [INFO] SQL1: Connecting to server... (hr=00000000,
{93C32F99-39CA-4D38-9D7F-2707CA0EAF46},
> {E88B08DD-2460-4DF1-B5C2-28587DD164EA}, 0, 1, 0), (null)
> 2004-04-02 13:34:28.320 [INFO] SQL2: Connecting to server... (hr=00000000,
{93C32F99-39CA-4D38-9D7F-2707CA0EAF46},
> {E88B08DD-2460-4DF1-B5C2-28587DD164EA}, 0, 1, 0), (null)
> 2004-04-02 13:34:28.460 [INFO] [MT] The name to connect to is 'SQL1'.
> 2004-04-02 13:34:28.590 [INFO] [MT] The name to connect to is 'SQL2'.
> 2004-04-02 13:34:28.721 [INFO] [MT] Requesting a local connection to
'SQL1'.
> 2004-04-02 13:34:28.851 [INFO] [MT] Requesting a remote connection to
'SQL2'.
> 2004-04-02 13:34:29.061 [WARN] sql1: This node is already a member of a
cluster, but the cluster service is not running. This node will not
> be configured at this time. (hr=0x000001,
{93C32F99-39CA-4D38-9D7F-2707CA0EAF46},
{8028BF97-2D57-4628-845D-C4BEFFEB531A}, 1, 1, 1), The
> cluster service on this node is configured but is not currently running.
This node will be skipped and no further tasks will be performed on
> it. If this node is not supposed to be a member of any cluster, then clean
it up using the "cluster node /forcecleanup" command and try
> again.
> 2004-04-02 13:34:29.131 [INFO] SQL2: The DNS record for
"SQL2.shop.clic.net" is "192.168.0.242". (hr=00000000,
> {93C32F99-39CA-4D38-9D7F-2707CA0EAF46},
{D86FAAD9-2514-451E-B359-435AF35E6038}, 1, 1, 1), (null)
> 2004-04-02 13:34:29.271 [WARN] sql1: This node is already a member of a
cluster, but the cluster service is not running. This node will not
> be configured at this time. (hr=0x000001,
{93C32F99-39CA-4D38-9D7F-2707CA0EAF46},
{8028BF97-2D57-4628-845D-C4BEFFEB531A}, 1, 1, 1), The
> cluster service on this node is configured but is not currently running.
This node will be skipped and no further tasks will be performed on
> it. If this node is not supposed to be a member of any cluster, then clean
it up using the "cluster node /forcecleanup" command and try
> again.
> 2004-04-02 13:34:29.402 [INFO] sql1: Requesting remote connections...
(hr=00000000, {93C32F99-39CA-4D38-9D7F-2707CA0EAF46},
> {1B606398-7193-4A48-AFBD-98AC8BACB690}, 1, 1, 1), (null)
> 2004-04-02 13:34:29.542 [INFO] [SRV] The cluster service is down on this
node.
> 2004-04-02 13:34:29.672 [INFO] sql1: Requesting a remote connection to
"SQL2" in domain "shop.clic.net" with binding string "192.168.0.242"
> (hr=00000000, {1B606398-7193-4A48-AFBD-98AC8BACB690},
{7DCE2976-3E89-4683-8980-B41130CBABD9}, 1, 1, 1), (null)
> 2004-04-02 13:34:29.812 [INFO] [SRV] CClusCfgClusterInfo::Initialize()
returning (hr=0x0713ba)
> 2004-04-02 13:34:29.962 [INFO] [MT] Connection to 'SQL2' with binding
string '192.168.0.242' failed because one or more classes are not
> registered.
> 2004-04-02 13:34:30.093 [WARN] sql1: GetClusterConfigInfo() completed.
(hr=0x0713ba, {05AA0768-5F49-49CD-AFDC-96F9D51802D4},
> {B460EA73-6223-44FA-84E0-DE7EC069DDD4}, 1, 1, 1), (null)
> 2004-04-02 13:34:30.253 [INFO] SQL2: The DNS record for
"SQL2.shop.clic.net" is "192.168.0.242". (hr=00000000,
> {93C32F99-39CA-4D38-9D7F-2707CA0EAF46},
{D86FAAD9-2514-451E-B359-435AF35E6038}, 1, 1, 1), (null)
> 2004-04-02 13:34:30.403 [WARN] sql1: The cluster configuration server has
been started. (hr=0x0713ba,
> {93C32F99-39CA-4D38-9D7F-2707CA0EAF46},
{39371CBA-A47B-4A4F-9042-6BECD321E9E2}, 1, 1, 1), (null)
> 2004-04-02 13:34:30.613 [INFO] [MT:CTaskAnalyzeClusterBase] Looking for
the completion cookie 5.
> 2004-04-02 13:34:30.663 [WARN] sql1: The cluster configuration server has
been started. (hr=0x0713ba,
> {93C32F99-39CA-4D38-9D7F-2707CA0EAF46},
{39371CBA-A47B-4A4F-9042-6BECD321E9E2}, 1, 1, 1), (null)
> 2004-04-02 13:34:30.804 [INFO] SQL2: (null) (hr=00000000,
{93C32F99-39CA-4D38-9D7F-2707CA0EAF46},
{E88B08DD-2460-4DF1-B5C2-28587DD164EA}, 0,
> 1, 1), (null)
> 2004-04-02 13:34:30.964 [INFO] [MT] The cluster service on node 'SQL1' is
down.
> 2004-04-02 13:34:31.084 [INFO] [MT:CTaskAnalyzeClusterBase] Looking for
the completion cookie 7.
> 2004-04-02 13:34:31.244 [WARN] SQL1: (null) (hr=0x0713ba,
{93C32F99-39CA-4D38-9D7F-2707CA0EAF46},
{E88B08DD-2460-4DF1-B5C2-28587DD164EA}, 0,
> 1, 1), (null)
> 2004-04-02 13:34:31.414 [INFO] [CTaskAnalyzeClusterBase] Clearing
completion cookie 7 at array index 1
> 2004-04-02 13:34:31.545 [INFO] [MT:CTaskAnalyzeClusterBase] Looking for
the completion cookie 6.
> 2004-04-02 13:34:31.675 [INFO] [MT] [CTaskGatherNodeInfo] exiting task.
The task was not cancelled.
> 2004-04-02 13:34:31.805 [INFO] [CTaskAnalyzeClusterBase] Clearing
completion cookie 6 at array index 0
> 2004-04-02 13:34:32.075 [INFO] sql1: (null) (hr=00000000,
{FDC75680-7DBB-42CA-8003-E4CDB01FF062},
{93C32F99-39CA-4D38-9D7F-2707CA0EAF46}, 0,
> 90, 1), (null)
> 2004-04-02 13:34:32.075 [INFO] [MT] [CTaskGatherNodeInfo] exiting task.
The task was not cancelled.
> 2004-04-02 13:34:32.216 [ERR ] sql1: The list of nodes to configure is
empty. (hr=0x800713ac, {93C32F99-39CA-4D38-9D7F-2707CA0EAF46},
> {A678963B-9173-4393-B21B-0B4337B28EE2}, 1, 1, 1), (null)
> 2004-04-02 13:34:32.486 [INFO] CLUSTER2: (null) (hr=00000000,
{FDC75680-7DBB-42CA-8003-E4CDB01FF062},
> {CC5E57B1-4520-4672-B4BA-A288EC42946E}, 0, 90, 90), (null)
> 2004-04-02 13:34:32.626 [INFO] [MT] [CTaskAnalyzeClusterBase] Exiting
task. The task was not cancelled.
> SQL1 is the Windows 2003 box newly installed and SQL2 is the old Windows
2000 box.
> Can anyone see anything wrong?
> Thanks in advance.
> Paul
|||Great! It works 8-).
Thanks!
Paul
On Fri, 2 Apr 2004 10:48:52 -0800, "Shon Shah [MSFT]" <shonsh@.online.microsoft.com> wrote:

>Paul,
>As the log indicates try adding the new node (SQL1) after cleaning it up
>using the "cluster node /forcecleanup" command.
>2004-04-02 13:34:29.061 [WARN] sql1: This node is already a member of a
>cluster, but the cluster service is not running. This node will not
>be configured at this time. (hr=0x000001,
>{93C32F99-39CA-4D38-9D7F-2707CA0EAF46},
>{8028BF97-2D57-4628-845D-C4BEFFEB531A}, 1, 1, 1), The
>cluster service on this node is configured but is not currently running.
>This node will be skipped and no further tasks will be performed on
>it. If this node is not supposed to be a member of any cluster, then clean
>it up using the "cluster node /forcecleanup" command and try
>again.
>Hope this helps.
|||You must evict the node from the cluster before joining it
back in.
HTH
Bjorn
>--Original Message--
>My Cluster Service does not want to start on SQL1. Event
Viewer says:
>Event Type:Error
>Event Source:Service Control Manager
>Event Category:None
>Event ID:7031
>Date:4/2/2004
>Time:1:39:12 PM
>User:N/A
>Computer:SQL1
>Description:
>The Cluster Service service terminated unexpectedly. It
has done this 4 time(s). The following corrective action
will be taken in 480000
>milliseconds: Restart the service.
>For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
>
>What do you suggest?
>Paul
>.
>

Installing CAB files using SQLCe

Im using SQLCE and SQL Server2000 to replicate to a Pocket PC running PPC MS windows 2002. What I want to know is it possible to update my cab file on the PDA remotely?
Is it possible to install the cab file trough SQLCE?I don't know but thought this MSDN http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlce/htm/_lce_deploying_from_embedded_visual_basic.asp link is any help to you.

Installing ASP.NET

I have looked all over microsofts website
to install a Virtual Web Server under Windows XP
It appears that it is installed under IIS. I can not
use ASP.NET in Visual Studio .Net to access it and
test programs. 9WinXP Pro)
What am I doing wrong '?You will probably get an answer if you post this in the .net programming
groups
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"DW" <don@.performancefiberglass.com> wrote in message
news:01d701c4939a$3e7777c0$a401280a@.phx.gbl...
> I have looked all over microsofts website
> to install a Virtual Web Server under Windows XP
> It appears that it is installed under IIS. I can not
> use ASP.NET in Visual Studio .Net to access it and
> test programs. 9WinXP Pro)
> What am I doing wrong '?sql

Installing ASP.NET

I have looked all over microsofts website
to install a Virtual Web Server under Windows XP
It appears that it is installed under IIS. I can not
use ASP.NET in Visual Studio .Net to access it and
test programs. 9WinXP Pro)
What am I doing wrong ??
You will probably get an answer if you post this in the .net programming
groups
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"DW" <don@.performancefiberglass.com> wrote in message
news:01d701c4939a$3e7777c0$a401280a@.phx.gbl...
> I have looked all over microsofts website
> to install a Virtual Web Server under Windows XP
> It appears that it is installed under IIS. I can not
> use ASP.NET in Visual Studio .Net to access it and
> test programs. 9WinXP Pro)
> What am I doing wrong ??

Installing and using Developer 2005

I am currently having problems with the SQL Server 2005 Developer.

1. I have a Windows XP SP2 Japanese version.

2. This machine is connected to a domain managed by Linux server.

3. I login with a domain account and install.

Initially, the intallations were failing with an error message that I do not have

administrator right.

We created an account on my machine with the same user name as that used

for the domain, and gave this administrator rights.

With this the installation was completed. However, there is another problem,

I cannot connect to the SQL Server.

For the installation, I chose "Local System" with Windows Authentication,

but the connection to the database still fails with the error message that remote

connection is not supported. I do not understand why I need TCP to accesss a local

installation of the SQL Server.

However, I followed the procedure outlined in a MS KB to enable TCP. But the

connection to the database still fails.

I am using the Management Studio to connect to SQL Server. I have also tried creating

a database in VS. NET 2005 and this also fails. I have checked the services and all are running.

What is wrong and what can I do? (it takes more than an hour to install this stuff and it is

really consuming my time). Any help?

Best regards,

Paul.

Actually you are missing a lot the Developer edition and Express comes locked down you have to go in and enable all you need with the Configuration Manager and Surface area configuration tool. It also helps if you use both TCP/IP and Named Pipes. I have covered all in the last posting in the thread below, the instructions are for Express and the developer edition but ignore the server registration section. I would also recommend mixed authentication mode so VS2005 will not cause you problems during development. Post again if you still need help.

http://msdn2.microsoft.com/en-us/library/ms188670.aspx

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1869763&SiteID=1

|||

Thanks for the reply.

I mentioned in my post, I followed the MS KB to enable the TCP. To be precise, it is this KB

http://support.microsoft.com/kb/914277

That never helped or solved the connection problem.

That KB starts like...

"When you try to connect to an instance of Microsoft SQL Server 2005 from a remote computer, you may receive an error message."

I installed "Local System" and do not see how this statement applies to my case when I am only trying to use the SQL Server on the same machine.

Best regards,

Paul.

|||

I have found the problem. I was connecting to the server listed and not the localhost.

Best regards,

Paul.

Installing A Failover Cluster

I have two matched servers, one will be Active and one will be Passive.
The servers have Windows 2000 Advanced Server and I have SQL Server 2000
Enterprise Edition.
My question is, do I also need a box called a Shared Disk Array, or can I
use another server I currently have that has lots of disk space on it?
Correction: I have Windows 2000 Advanced Server
"Vincel2k2" wrote:

> I have two matched servers, one will be Active and one will be Passive.
> The servers have Windows 2000 Advanced Server and I have SQL Server 2000
> Enterprise Edition.
> My question is, do I also need a box called a Shared Disk Array, or can I
> use another server I currently have that has lots of disk space on it?
>
|||You will indeed need shared storage.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog
"Vincel2k2" <Vincel2k2@.discussions.microsoft.com> wrote in message
news:FF446D59-A73C-43EA-9EC2-4B9D03CFD51B@.microsoft.com...[vbcol=seagreen]
> Correction: I have Windows 2000 Advanced Server
> "Vincel2k2" wrote:
|||Hi
You need to get your self a Storage Area Network (SAN) to store your data
on.
For clustering, make sure that your hardware is on the Windows Hardware
Compatibility List (HCL)
Read the documentation on
http://www.microsoft.com/windowsserv...g/default.mspx
to get an understanding.
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/
"Vincel2k2" <Vincel2k2@.discussions.microsoft.com> wrote in message
news:FF446D59-A73C-43EA-9EC2-4B9D03CFD51B@.microsoft.com...[vbcol=seagreen]
> Correction: I have Windows 2000 Advanced Server
> "Vincel2k2" wrote:
I[vbcol=seagreen]
|||I also have two matched servers with Win2003EntSrv that I would like to
install an active/passive failover cluster of Yukon on. Since this is a lab
environment and I don't have the $$ for a SAN, will it work with a Network
Storage HD? I realize the performance won't be great, but I'm looking for
the experience in how to build/configure the environment.
Any tips?
An alternative question for the lab environment is ... how would you do this
in two VPC? Or would you steer clear?
Thanks
Al
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> You need to get your self a Storage Area Network (SAN) to store your data
> on.
> For clustering, make sure that your hardware is on the Windows Hardware
> Compatibility List (HCL)
> Read the documentation on
> http://www.microsoft.com/windowsserv...g/default.mspx
> to get an understanding.
> 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/
> "Vincel2k2" <Vincel2k2@.discussions.microsoft.com> wrote in message
> news:FF446D59-A73C-43EA-9EC2-4B9D03CFD51B@.microsoft.com...
> I
>
>
|||Virtual Server 2005 will work nicely for this test. See
http://www.hands-on-labs.com/microsoft.asp?ID=4477 for the steps
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"al_stark_born" <al_stark_born@.discussions.microsoft.com> wrote in message
news:E579B181-45E6-4DF2-8BCA-E7F1D2DD44C7@.microsoft.com...[vbcol=seagreen]
>I also have two matched servers with Win2003EntSrv that I would like to
> install an active/passive failover cluster of Yukon on. Since this is a
> lab
> environment and I don't have the $$ for a SAN, will it work with a Network
> Storage HD? I realize the performance won't be great, but I'm looking for
> the experience in how to build/configure the environment.
> Any tips?
> An alternative question for the lab environment is ... how would you do
> this
> in two VPC? Or would you steer clear?
> Thanks
> Al
> "Mike Epprecht (SQL MVP)" wrote:
sql

Installing A Default Instance AFTER a Named Instance??

I have SQL Server 2000 Standard Edition (sp3a) running on a windows 2003 (sp4) Server.

It is a Production Server with 3 NAMED Instances and NO Default Instance.

Does anyone know if I can rerun the SQL Server Install and add a DEFAULT Instance to this box without disrupting the other Named Instances?Except for a reboot after the install, you should have no problems installing a default instance.|||Thank you : )|||Will the default instance automatically have the name of the Server - or is there a way to give it name - like you would a named instance.. sorry if the question sounds stupid.. : )|||The default instance will have the name of the server. The only way around this that I can think of off the top of my head is to give the machine a DNS alias.|||Thanks !!! I'm not so much worried about the name as I am Blowing up the Server by installing a Default Instance AFTER it has already been populated with Named Instances.

installing 64bit SQL2000 EE on 32-bit Windows 2003 Enterprise server

Will my SQL server work like 32-bit or 64-bit if I installed 64bit SQL2000 EE on 32-bit Windows 2003 Enterprise server?
Did it install ? I don't think it should.Certainly doesn't on my PC
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Dipesh" <anonymous@.discussions.microsoft.com> wrote in message
news:8C50C76F-8EF4-4B09-BB17-4A7FABEE5B1E@.microsoft.com...
> Will my SQL server work like 32-bit or 64-bit if I installed 64bit SQL2000
EE on 32-bit Windows 2003 Enterprise server?
>
|||It installed fine. I am just concerned about if 64-bit functionality will be available to me or not. Is there a way to verify.

Installing 2nd instance of MSDE

I am trying to install WSUS on a Windows 2000 server that already has MSDE
installed for Backup Exec.
Unfortunately the WSUS installation returns the following error: "- a
database server could not be detected"
I believe WSUS is looking for an instance called "WSUS".
How do I install a 2nd instance of MSDE on a Windows 2000 server (Child
Instance?) without impacting
my default instance for Backup Exec? Thanks!!!!!!
hi Ken,
Ken wrote:
> I am trying to install WSUS on a Windows 2000 server that already has
> MSDE installed for Backup Exec.
> Unfortunately the WSUS installation returns the following error: "- a
> database server could not be detected"
> I believe WSUS is looking for an instance called "WSUS".
> How do I install a 2nd instance of MSDE on a Windows 2000 server
> (Child Instance?) without impacting
> my default instance for Backup Exec? Thanks!!!!!!
you can install up to 16 (theorical) SQL Server/MSDE instance per machine...
only one of them can be the default instance, where all the others have to
be named instance..
to install a named instance you have to provide the
INSTANCENAME=WSUS
parameter to the setup.exe boostrap installer
(http://msdn.microsoft.com/library/de...stsql_84xl.asp)
, that's to say something like
c:\...\>setup.exe INSTANCENAME=WSUS SECURITYMODE=SQL SAPWD=some_pwd
DISABLENETWORKPROTOCOLS=0 /L*v "c:\msdelog.txt"
please see the referenced page for all parameter synopsis..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks for your help Andrea!!!! WSUS was installed!!!
Ken
"Andrea Montanari" wrote:

> hi Ken,
> Ken wrote:
> you can install up to 16 (theorical) SQL Server/MSDE instance per machine...
> only one of them can be the default instance, where all the others have to
> be named instance..
> to install a named instance you have to provide the
> INSTANCENAME=WSUS
> parameter to the setup.exe boostrap installer
> (http://msdn.microsoft.com/library/de...stsql_84xl.asp)
> , that's to say something like
> c:\...\>setup.exe INSTANCENAME=WSUS SECURITYMODE=SQL SAPWD=some_pwd
> DISABLENETWORKPROTOCOLS=0 /L*v "c:\msdelog.txt"
> please see the referenced page for all parameter synopsis..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
sql