Where are the Notification Services?

Where are the Notification Services?

Post by Juan Den » Fri, 07 Mar 2003 10:19:03



Hi,

Visual Studio magazine has an article about SQL Server
2000 Notification Services and I have a Universal
subscription to MSDN so I should have this software
available to install shouldn't I? But where is it?

My subscription is in DVDs english.

Thanks,
Juan Dent

 
 
 

Where are the Notification Services?

Post by Scot Rose [MSF » Fri, 07 Mar 2003 23:06:08


http://www.microsoft.com/sql/ns/default.asp

Want to know more? Check out the MSDN Library at http://msdn.microsoft.com  or the Microsoft Knowledge Base at http://support.microsoft.com

Scot Rose, MCSD
Microsoft Visual Basic Developer Support

This posting is provided AS IS, with no warranties, and confers no rights.

 
 
 

1. Notification Services samples

First time round I tried to build one of the Notification
Services examples with Window authentication logon setup
to my SQL Server. As I am using a machine for the
Notification services which doesn't belong to the same
domain as my SQL server I switched my server to use SQL
server authentication because it didn't work.

Now that I am using SQL server authentication I enter the
command:
'setupsamples administrator password mysqlserver sqluser
sqluserpassword sa' which was successful. However when I
go to build one of the Notifications Services examples I
still get the same errors even though I get prompted for
my SQL user password:
e.g.

H:\Program Files\Microsoft SQL Server Notification
Services\v2.0.2114.0
\Samples\Flight\AppDefinition\BuildScripts\GrantPermissions
.cmd(1,1): error 1: GrantPermissions.cmd failed. See
output window for error text.
Password:
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17>
18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31>
32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42> 43> 44> 45>
46> 47> 48> 49> 50> 51> 52> 53> 54> 55> Msg 15401, Level
11, State 1, Server MYSQLSERVER, Procedure sp_grantlogin,
Line 41
Windows NT user or group 'MYLOCALMACHINE\ASPNET' not
found. Check the name again.
Msg 15401, Level 11, State 1, Server MYSQLSERVER,
Procedure sp_grantdbaccess, Line 100
Windows NT user or group 'MYLOCALMACHINE\ASPNET' not
found. Check the name again.
Msg 15410, Level 11, State 1, Server MYSQLSERVER,
Procedure sp_addrolemember, Line 66
User or role 'MYLOCALMACHINE\ASPNET' does not exist in
this database.

Why isn't the example using the SQL authentication here?

2. Massachusetts - Senior Oracle Database Administrator

3. Failover notification Microsoft Cluster Service

4. 1 GB IDE drive on older ISA bus

5. Notification Services

6. printing problems with bbxprogression/4, win95, and novell 3.11

7. Ado Commands & Parameters & SQL

8. SQL SVR Notification Services

9. Using SQL Notification Services (SQLNS) to transfer data

10. looking for trivial Notification Services sample

11. Notification Services nscontrol unregister Problem

12. send mail attachments via SQL Server Notification Services