How can i check if Notification Services engine components is insalled or not?

I have installed the SQL Server 2005, including in the installation the notification serviceis, I want to check that Notification Services engine components is insalled, how can i do that?!

Do you see Notification Services in the Object Browser of SSMS? You can right click on it, select List Versions, and see more information.

HTH...

How can I be assured that I do have SP1 applied correctly in SQL 2005 Developer Edition

I installed my SQL 2005 Developer edition and applied the SP1. I didn’t have a time to wait the installation to complete (I needed to reboot) so I cancelled the SP1 which was downloaded from Windows Update.

Now, my development PC says that SQL 2005 SP1 is applied but I am not sure if it’s applied correctly. I tried to reinstall SP1 in order to be assured but I can’t get it reinstalled. I get error message saying that you already have SP1 2047 ENU applied.

I just don’t want (have a time) to troubleshoot some possible upcoming issues in development because of this. So, how can I be assured that I do have SP1 applied correctly?

At what stage you have to rebooted the box?

if this is used for a testing on production, then its better to resintall afresh to avoid any spurious errors in future.

Run SELECT @.@.VERSION and see the results.

|||

Yes. 9.00.2047 is the SQL Server 2005 SP1 version. You can verify the following items to get more confidence.

1. Add/Remove Program in control panel to check the status of SQL Server 2005.

2. Go to registry keys HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup to check the version.

3. You can check the file version of %ProgramFiles%Microsoft SQL Server\MSSQL.<instance id>\MSSQL\Binn\sqlservr.exe.

|||

I try to uninstall the SP1 but its not possible, so I guess in order to be safe I should uninstall the SQL 2005 developer edition completely and reinstall it and apply the batch again.

It looks all good in SQL site, but SQL reported the SP1 applied and Microsoft Update reported the SP1 cancelled. This is a bit wired, so I going to do the reinstallation in order avoid any spurious errors in future.

Thanks folks....You great....

Alexander

HOW CAN I ATTACH DATABASE TO MSDE ?

I am having little problem with it , I am using installshield for setup program and at the end when I finish with msde installation I try to attach a database, I would like to use SQL-DMO , but I dont have much clue how can I do it I need some examples sc
ripts
Thanks a lot
While you can use SQL DMO, it's really easier to simply use ADO or ADO.NET.
When you "open" a database connection against SQL Server and point to the
MDF file, ADO does an attach for you (unless the database is already
attached). This code is from a yet-to-be-published article on SQL Server
Express where I attach a new database to the local SQLEXPRESS named
instance.
Try
cn = New SqlConnection("Data Source=.\SQLExpress;" _
& "Integrated Security=True;Database=Biblio;" _
& "Timeout=60;" _
& "Application Name=SQLExpress Test;" _
& "AttachDBFilename=" & strFn)
da = New SqlDataAdapter("SELECT AU_ID, Author, Year_Born from
authors", cn)
ds = New DataSet
da.Fill(ds)
DataGridView1.DataSource = ds.Tables(0)
Catch ex As Exception
MsgBox(ex.ToString)
End Try
hth
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Robert" <Robert @.discussions.microsoft.com> wrote in message
news:1F642E5F-37AB-4BA7-88DF-5159C607AA0C@.microsoft.com...
> I am having little problem with it , I am using installshield for setup
program and at the end when I finish with msde installation I try to attach
a database, I would like to use SQL-DMO , but I dont have much clue how can
I do it I need some examples scripts
> Thanks a lot
>
|||Hello Robert.
U have said th@. u installed MSDE 2000 using installsheild. How did u do this. Pls help me as im unable to install MSDE itself. Also its givin me a message a strong SA id and password is required.
"Robert" wrote:

> I am having little problem with it , I am using installshield for setup program and at the end when I finish with msde installation I try to attach a database, I would like to use SQL-DMO , but I dont have much clue how can I do it I need some examples
scripts
> Thanks a lot
>

How can a client application get serial number of SQL server installation

I want to write an application, which will be validated by serial number.
This serial number has to be dependent on serial number, which
is used during SQL Server installation.
In other words - licence key for my client application has to be dependent
on server.
How can my client application get server validation key or another server
specific information (such harddisk serial number of the server, network
adapter card serial number etc)?
Message posted via http://www.sqlmonster.com
You can get the serial number of the SQL Server installation from the
registry key:
HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\80\Registration\CD_KEY.
Jacco Schalkwijk
SQL Server MVP
"Jaroslav Sedlak via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:ead3ca55b3b1403b9d1d532fad4eb192@.SQLMonster.c om...
>I want to write an application, which will be validated by serial number.
> This serial number has to be dependent on serial number, which
> is used during SQL Server installation.
> In other words - licence key for my client application has to be dependent
> on server.
> How can my client application get server validation key or another server
> specific information (such harddisk serial number of the server, network
> adapter card serial number etc)?
> --
> Message posted via http://www.sqlmonster.com
|||Yes, you are right. But this doesn't solve my problem. This registry key
can be read only by an application, which runs on the server.
I want to get licence key of SQL server in application which runs not on
the machine server but on the client machine.
Message posted via http://www.sqlmonster.com
|||You can access the registry from within SQL Server with the undocumented
extended procedure xp_regread. See
http://www.databasejournal.com/featu...le.php/1441251
for more details.
Jacco Schalkwijk
SQL Server MVP
"Jaroslav Sedlak via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:a921286e80de46b891c501f50382388a@.SQLMonster.c om...
> Yes, you are right. But this doesn't solve my problem. This registry key
> can be read only by an application, which runs on the server.
> I want to get licence key of SQL server in application which runs not on
> the machine server but on the client machine.
> --
> Message posted via http://www.sqlmonster.com

How can a client application get serial number of SQL server installation

I want to write an application, which will be validated by serial number.
This serial number has to be dependent on serial number, which
is used during SQL Server installation.
In other words - licence key for my client application has to be dependent
on server.
How can my client application get server validation key or another server
specific information (such harddisk serial number of the server, network
adapter card serial number etc)?
Message posted via http://www.droptable.comYou can get the serial number of the SQL Server installation from the
registry key:
HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\80\Registration\CD_KEY.
Jacco Schalkwijk
SQL Server MVP
"Jaroslav Sedlak via droptable.com" <forum@.droptable.com> wrote in message
news:ead3ca55b3b1403b9d1d532fad4eb192@.SQ
droptable.com...
>I want to write an application, which will be validated by serial number.
> This serial number has to be dependent on serial number, which
> is used during SQL Server installation.
> In other words - licence key for my client application has to be dependent
> on server.
> How can my client application get server validation key or another server
> specific information (such harddisk serial number of the server, network
> adapter card serial number etc)?
> --
> Message posted via http://www.droptable.com|||Yes, you are right. But this doesn't solve my problem. This registry key
can be read only by an application, which runs on the server.
I want to get licence key of SQL server in application which runs not on
the machine server but on the client machine.
Message posted via http://www.droptable.com|||You can access the registry from within SQL Server with the undocumented
extended procedure xp_regread. See
http://www.databasejournal.com/feat...cle.php/1441251
for more details.
Jacco Schalkwijk
SQL Server MVP
"Jaroslav Sedlak via droptable.com" <forum@.droptable.com> wrote in message
news:a921286e80de46b891c501f50382388a@.SQ
droptable.com...
> Yes, you are right. But this doesn't solve my problem. This registry key
> can be read only by an application, which runs on the server.
> I want to get licence key of SQL server in application which runs not on
> the machine server but on the client machine.
> --
> Message posted via http://www.droptable.com

How can a client application get serial number of SQL server installation

I want to write an application, which will be validated by serial number.
This serial number has to be dependent on serial number, which
is used during SQL Server installation.
In other words - licence key for my client application has to be dependent
on server.
How can my client application get server validation key or another server
specific information (such harddisk serial number of the server, network
adapter card serial number etc)?
--
Message posted via http://www.sqlmonster.comYou can get the serial number of the SQL Server installation from the
registry key:
HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\80\Registration\CD_KEY.
--
Jacco Schalkwijk
SQL Server MVP
"Jaroslav Sedlak via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:ead3ca55b3b1403b9d1d532fad4eb192@.SQLMonster.com...
>I want to write an application, which will be validated by serial number.
> This serial number has to be dependent on serial number, which
> is used during SQL Server installation.
> In other words - licence key for my client application has to be dependent
> on server.
> How can my client application get server validation key or another server
> specific information (such harddisk serial number of the server, network
> adapter card serial number etc)?
> --
> Message posted via http://www.sqlmonster.com|||Yes, you are right. But this doesn't solve my problem. This registry key
can be read only by an application, which runs on the server.
I want to get licence key of SQL server in application which runs not on
the machine server but on the client machine.
--
Message posted via http://www.sqlmonster.com|||You can access the registry from within SQL Server with the undocumented
extended procedure xp_regread. See
http://www.databasejournal.com/features/mssql/article.php/1441251
for more details.
--
Jacco Schalkwijk
SQL Server MVP
"Jaroslav Sedlak via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:a921286e80de46b891c501f50382388a@.SQLMonster.com...
> Yes, you are right. But this doesn't solve my problem. This registry key
> can be read only by an application, which runs on the server.
> I want to get licence key of SQL server in application which runs not on
> the machine server but on the client machine.
> --
> Message posted via http://www.sqlmonster.com

Hotfix Installation failed on named Instance on a SQL-Server-2000 Cluster

Hi all,
I have a windows 2003 cluster
with sql-server 2000 sp3
and a named instance.
I wanted to installation the hotfix ..859, but the installation failed
and I got the error:
"The logged on account does not have administrator privileges on all
possible owner nodes of the selected SQL Server configuration.
Please log on using an account that has administrator privileges on all
possible owner nodes and then run Hotfix Installer again."
I've checked different things.
My account has the correct rights, the RPC service is running, DNS
works fine ...
I have no idea what to do!
Can someone help?
Greetings
Susn
Are you running the hotfix from the controlling node? Also, you may have to
reboot each node, before the hotfix will install.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
<liebesusn@.web.de> wrote in message
news:1106919750.693602.235970@.f14g2000cwb.googlegr oups.com...
> Hi all,
> I have a windows 2003 cluster
> with sql-server 2000 sp3
> and a named instance.
> I wanted to installation the hotfix ..859, but the installation failed
> and I got the error:
> "The logged on account does not have administrator privileges on all
> possible owner nodes of the selected SQL Server configuration.
> Please log on using an account that has administrator privileges on all
> possible owner nodes and then run Hotfix Installer again."
> I've checked different things.
> My account has the correct rights, the RPC service is running, DNS
> works fine ...
> I have no idea what to do!
> Can someone help?
> Greetings
> Susn
>
|||Hi Rod,
yes, the hotfix was running from the controlling node and both nodes
was rebooted.
Any other idea?
Greetings Susn
|||No, that about does it for me, sorry!
Rod
"Susn" <liebesusn@.web.de> wrote in message
news:1107160932.634056.6880@.c13g2000cwb.googlegrou ps.com...
> Hi Rod,
> yes, the hotfix was running from the controlling node and both nodes
> was rebooted.
> Any other idea?
> Greetings Susn
>
|||Hi Susn,
Just wondering if you were able to install the hotfix. I would recommend you to log into both the nodes of the cluster with the startup account of the clustered SQL Server service (this account is a doman account and
should have all the required rights). Then start the hotfix installation on the node where SQL Server instance is currently running.
Keep up updated. If it fails, then please post the log for the hotfix failure.
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