Error processing events

Let me start by saying this is my first crack at NotificationServices. I installed a sample from "Microsoft SQL Server 2000 Notification Services" that processes stock events (I think it may be a copy of the one in the help file). I get the following error when I place a file in the EventsWatchDirectory. I have uninstalled and reinstalled SQLXML and MSXML3 (I already had MSXML4 sp2). Any help is appreciated.

<NotificationServicesEvent>

<Description>

The FileSystemWatcher event provider failed to submit events.

</Description>

<Context>

<EventParameters>

<ProviderName>StockEventProvider</ProviderName>

<EventFileName>C:\SQL-NS\Chapter03\Stock\EventsWatchDirectory\EventData.xml</EventFileName>

<EventClassName>StockPriceChange</EventClassName>

</EventParameters>

</Context>

<Description>

Unable to cast COM object of type 'SqlXmlBulkLoad.SQLXMLBulkLoadClass' to interface type 'SqlXmlBulkLoad.ISQLXMLBulkLoad'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{1380DD8D-DCB9-4A6E-9D53-EECDDF18DA85}' failed with HRESULT: 0x80004002 (No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE))).

</Description>

<Instance>Chapter03</Instance>

<ApplicationName>Stock</ApplicationName>

<Component>Event collection</Component>

<Thread>15</Thread>

</NotificationServicesEvent>

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Also of note:

I can instantiate SQLXMLBulkLoad.SQLXMLBulkLoad but not SQLXMLBulkLoad.SQLXMLBulkLoadClass. The first sample VB Script from the SQLXML works fine to insert data into a table.|||Answer was in the old forums. I had .Net 2.0 Beta 2 installed. Uninstalled it and repaired XML4.0 and SQLXML3.0 and all was good. Thanks Shyam|||Larry,
What version of the .NET frameworks do you have on the machine. Notification Services in SQL 2000 requires the .NET Framework 1.1. If you have version 2.0 (only - without a side-by-side copy of version 1.1), you will see this problem. The reason is that one of the methods we call when loading the XML event loading components has been made obsolete in the 2.0 .NET Frameworks.

If you want to go with the .NET Frameworks 2.0, you should use the version of Notification SErvices in SQL Server 2005 - that version is designed to work on .NET 2.0.

THanks
-shyam
Learn more about SQL-NS:
http://www.amazon.com/exec/obidos/tg/detail/-/0672326647/

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.|||

Hello Shyam,

I have the exact same problem (I am also using your book code samples) the SQL-NS applications are compiling OK, and the service starts nicely, but when I try to trigger an event, I get the following error:

Unable to cast COM object of type 'SqlXmlBulkLoad.SQLXMLBulkLoadClass' to interface type 'SqlXmlBulkLoad.ISQLXMLBulkLoad'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{1380DD8D-DCB9-4A6E-9D53-EECDDF18DA85}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).

the configuration of my development machine is the following:

Windows XP Pro SP2

SQL Server 2000 SP4

SQL Server 2000 Notification Services SP1

SQLXML 3.0 SP3

.NET Framework 1.1 (VS 2003)

.NET Framework 2.0 (VS 2005)

SQL Server 2005 Express (the edition that is installed with VS 2005)

Unfortunately I am developping with both versions of visual studio (2003 & 2005) so I need both frameworks.

We are using SQL server 2000 and are not ready to upgrade to SQL server 2005.

Is there any fix I could use?

Thanks for your help.

Henri PIQUET

Error processing events

Let me start by saying this is my first crack at NotificationServices. I installed a sample from "Microsoft SQL Server 2000 Notification Services" that processes stock events (I think it may be a copy of the one in the help file). I get the following error when I place a file in the EventsWatchDirectory. I have uninstalled and reinstalled SQLXML and MSXML3 (I already had MSXML4 sp2). Any help is appreciated.

<NotificationServicesEvent>

<Description>

The FileSystemWatcher event provider failed to submit events.

</Description>

<Context>

<EventParameters>

<ProviderName>StockEventProvider</ProviderName>

<EventFileName>C:\SQL-NS\Chapter03\Stock\EventsWatchDirectory\EventData.xml</EventFileName>

<EventClassName>StockPriceChange</EventClassName>

</EventParameters>

</Context>

<Description>

Unable to cast COM object of type 'SqlXmlBulkLoad.SQLXMLBulkLoadClass' to interface type 'SqlXmlBulkLoad.ISQLXMLBulkLoad'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{1380DD8D-DCB9-4A6E-9D53-EECDDF18DA85}' failed with HRESULT: 0x80004002 (No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE))).

</Description>

<Instance>Chapter03</Instance>

<ApplicationName>Stock</ApplicationName>

<Component>Event collection</Component>

<Thread>15</Thread>

</NotificationServicesEvent>

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Also of note:

I can instantiate SQLXMLBulkLoad.SQLXMLBulkLoad but not SQLXMLBulkLoad.SQLXMLBulkLoadClass. The first sample VB Script from the SQLXML works fine to insert data into a table.|||Answer was in the old forums. I had .Net 2.0 Beta 2 installed. Uninstalled it and repaired XML4.0 and SQLXML3.0 and all was good. Thanks Shyam|||Larry,
What version of the .NET frameworks do you have on the machine. Notification Services in SQL 2000 requires the .NET Framework 1.1. If you have version 2.0 (only - without a side-by-side copy of version 1.1), you will see this problem. The reason is that one of the methods we call when loading the XML event loading components has been made obsolete in the 2.0 .NET Frameworks.

If you want to go with the .NET Frameworks 2.0, you should use the version of Notification SErvices in SQL Server 2005 - that version is designed to work on .NET 2.0.

THanks
-shyam
Learn more about SQL-NS:
http://www.amazon.com/exec/obidos/tg/detail/-/0672326647/

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.|||

Hello Shyam,

I have the exact same problem (I am also using your book code samples) the SQL-NS applications are compiling OK, and the service starts nicely, but when I try to trigger an event, I get the following error:

Unable to cast COM object of type 'SqlXmlBulkLoad.SQLXMLBulkLoadClass' to interface type 'SqlXmlBulkLoad.ISQLXMLBulkLoad'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{1380DD8D-DCB9-4A6E-9D53-EECDDF18DA85}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).

the configuration of my development machine is the following:

Windows XP Pro SP2

SQL Server 2000 SP4

SQL Server 2000 Notification Services SP1

SQLXML 3.0 SP3

.NET Framework 1.1 (VS 2003)

.NET Framework 2.0 (VS 2005)

SQL Server 2005 Express (the edition that is installed with VS 2005)

Unfortunately I am developping with both versions of visual studio (2003 & 2005) so I need both frameworks.

We are using SQL server 2000 and are not ready to upgrade to SQL server 2005.

Is there any fix I could use?

Thanks for your help.

Henri PIQUET

Error on setting ip partners : servers not found

Hello,

I have un problem with the mirroring, when I set the IP of the partners, I get an error saying that the server will not exists or it's impossible to join it. I try to make a mirroring without witness between two servers.

request on first :
ALTER DATABASE [panorama2]
SET PARTNER = N'TCP://192.168.1.71:5050'

I get :

Msg1418, Niveau16, tat1, Ligne1
L'adresse reseau du serveur "TCP://192.168.1.71:5050" est impossible à atteindre ou elle n'existe pas. Verifiez le nom de l'adresse reseau et executez la commande de nouveau.

And it's the same problem with the second server.

I work with the sql server evaluation (I put the parameter T 1400 for). Endpoints are created (I get them with a select on systcp_endpoints) :
Mirroring 65541 1 2 TCP 4 DATABASE_MIRRORING 0 STARTED 0 5050 0 NULL

Thanks for helping.

ps : Excuse my english ^^

The problem might be Fully Qualified Domain Name (FQDN).........try specifying as shown below,

To start database mirroring, you next specify the partners and witness. You need database owner permissions to start and administer a given database mirroring session. On server A, the intended principal server, you tell SQL Server to give a particular database the principal role and what its partner (mirror) server is :

ALTER DATABASE [AdventureWorks] SET PARTNER =
N'TCP://B.corp.mycompany.com:5022'

The partner name must be the fully qualified computer name of the partner. Finding fully qualified names can be a challenge, but the Configure Database Mirroring Security Wizard will find them automatically when establishing endpoints.
The fully qualified computer name of each server can also be found running the following from the command prompt :

IPCONFIG /ALL
Concatenate the "Host Name" and "Primary DNS Suffix". If you see something like:
Host Name . . . . . . . . . . . . : A
Primary Dns Suffix . . . . . . . : corp.mycompany.com

Then the computer name is just A.corp.mycompany.com. Prefix 'TCP://' and append ':' and you then have the partner name.
On the mirror server, you would just repeat the same command, but with the principal server named :

ALTER DATABASE [AdventureWorks] SET PARTNER =
N'TCP://A.corp.mycompany.com:5022'

On the principal server, you next specify the witness server:

ALTER DATABASE [AdventureWorks] SET WITNESS =
N'TCP://W.corp.mycompany.com:5026'
|||Thanks for you answer.

So we can't use IP to connect servers ? I thought the contrary...

I start to work with domain, I set same domain for each server, but I have another problem, the mirror server is OK (It takes the ALTER TABLE), but I can't set the PARTNER to master, I get the same error as before, and I don't understand why.

Thanks for help |||Arnard can you pls explain it a little more ? is database mirroring configured and workiong well ? do you mean to say that you can't set the "alter database set partner" for principal ?
|||Yes, when i do the command :

ALTER DATABASE [panorama2]
SET PARTNER = N'TCP://srv-bat2.technet:5050'

on "master" and "slave", slave accept the command (with srv-bat instead of srv-bat2), but master not, he says that srv-bat2 is not found or not exists.

And I don't understand why master does't find slave, in contrary of slave that find master.
|||May be can you try giving someother end point listening port instead of 5050 you've mentioned above !
|||Result of sys.tcp_endpoints on srv-bat2 :

Mirroring 65540 1 2 TCP 4 DATABASE_MIRRORING 0 STARTED 0 5050 0 NULL

So I have the good port :/
netstat says port 5050 is open.

I don't understand why I can't make the mirroring -_-
|||Arnard,
I have configured mirroring in sql 2005 evaluation edition pls refer the link,
http://sql-articles.com/articles/dbmrr.htm
i don't know if it will solve your problem but just have a glance through it

Thanxx
Deepak
|||Thanks for your link, but I already saw this website.

Howewer, when I used the GUI to create the mirror, on the master server the path selected by sql server is <host>.<domain>:<port>, but on the slave server, I have <host>:<port>. And when I tried to start mirroring, I get the same error saying that the second server is not found

I have switch between the two servers and I get the same result. Do I need to configure another thing anywhere ? the fact that the slave server's path is <host>:<port> instead of <host>.<domain>:<port> means that there is a bug on configuration, but I can't say what and where.

Thanks fr your help ^^
|||Must I create a new login such this pattern : CREATE LOGIN <domain\\login> FROM WINDOWS ?
When You create your instance of SQL Server, what do you set for account to run service ? Local System ? Network System ? domain ? Is this element important or interessant in my problem ? thx
|||Actually in the link i gave above i've created 3 instances of sql server in my local PC and all 3 run under local system account but in real time environment you need to make use of a domain id (preferably) for the sql service account in all 3 principal,mirror and witness servers

Thanxx
Deepak

|||I've tried with the elment domain, I set the login of my administrator account, the password and . for domain (. give the real domain), and I get the same problem, server not found. So the problem is not here

Somebody speaks me of sp_configure and surface area configuration, what do I search with this tools, an idea ?

Another question, how can I get the sql sever developer edition ?

|||refer the link for developer edition,
http://www.microsoft.com/sql/editions/developer/howtobuy.mspx

Thanxx
Deepak


|||Do I need to create login on each server for the connection, and give access to connect endpoint, or sa is ok ?
|||I believe you need to create same login in each server for the connection and configure endpoint ! !

Error on setting ip partners : servers not found

Hello,

I have un problem with the mirroring, when I set the IP of the partners, I get an error saying that the server will not exists or it's impossible to join it. I try to make a mirroring without witness between two servers.

request on first :
ALTER DATABASE [panorama2]
SET PARTNER = N'TCP://192.168.1.71:5050'

I get :

Msg1418, Niveau16, tat1, Ligne1
L'adresse reseau du serveur "TCP://192.168.1.71:5050" est impossible à atteindre ou elle n'existe pas. Verifiez le nom de l'adresse reseau et executez la commande de nouveau.

And it's the same problem with the second server.

I work with the sql server evaluation (I put the parameter T 1400 for). Endpoints are created (I get them with a select on systcp_endpoints) :
Mirroring 65541 1 2 TCP 4 DATABASE_MIRRORING 0 STARTED 0 5050 0 NULL

Thanks for helping.

ps : Excuse my english ^^

The problem might be Fully Qualified Domain Name (FQDN).........try specifying as shown below,

To start database mirroring, you next specify the partners and witness. You need database owner permissions to start and administer a given database mirroring session. On server A, the intended principal server, you tell SQL Server to give a particular database the principal role and what its partner (mirror) server is :

ALTER DATABASE [AdventureWorks] SET PARTNER =
N'TCP://B.corp.mycompany.com:5022'

The partner name must be the fully qualified computer name of the partner. Finding fully qualified names can be a challenge, but the Configure Database Mirroring Security Wizard will find them automatically when establishing endpoints.
The fully qualified computer name of each server can also be found running the following from the command prompt :

IPCONFIG /ALL
Concatenate the "Host Name" and "Primary DNS Suffix". If you see something like:
Host Name . . . . . . . . . . . . : A
Primary Dns Suffix . . . . . . . : corp.mycompany.com

Then the computer name is just A.corp.mycompany.com. Prefix 'TCP://' and append ':' and you then have the partner name.
On the mirror server, you would just repeat the same command, but with the principal server named :

ALTER DATABASE [AdventureWorks] SET PARTNER =
N'TCP://A.corp.mycompany.com:5022'

On the principal server, you next specify the witness server:

ALTER DATABASE [AdventureWorks] SET WITNESS =
N'TCP://W.corp.mycompany.com:5026'
|||Thanks for you answer.

So we can't use IP to connect servers ? I thought the contrary...

I start to work with domain, I set same domain for each server, but I have another problem, the mirror server is OK (It takes the ALTER TABLE), but I can't set the PARTNER to master, I get the same error as before, and I don't understand why.

Thanks for help |||Arnard can you pls explain it a little more ? is database mirroring configured and workiong well ? do you mean to say that you can't set the "alter database set partner" for principal ?
|||Yes, when i do the command :

ALTER DATABASE [panorama2]
SET PARTNER = N'TCP://srv-bat2.technet:5050'

on "master" and "slave", slave accept the command (with srv-bat instead of srv-bat2), but master not, he says that srv-bat2 is not found or not exists.

And I don't understand why master does't find slave, in contrary of slave that find master.
|||May be can you try giving someother end point listening port instead of 5050 you've mentioned above !
|||Result of sys.tcp_endpoints on srv-bat2 :

Mirroring 65540 1 2 TCP 4 DATABASE_MIRRORING 0 STARTED 0 5050 0 NULL

So I have the good port :/
netstat says port 5050 is open.

I don't understand why I can't make the mirroring -_-
|||Arnard,
I have configured mirroring in sql 2005 evaluation edition pls refer the link,
http://sql-articles.com/articles/dbmrr.htm
i don't know if it will solve your problem but just have a glance through it

Thanxx
Deepak
|||Thanks for your link, but I already saw this website.

Howewer, when I used the GUI to create the mirror, on the master server the path selected by sql server is <host>.<domain>:<port>, but on the slave server, I have <host>:<port>. And when I tried to start mirroring, I get the same error saying that the second server is not found

I have switch between the two servers and I get the same result. Do I need to configure another thing anywhere ? the fact that the slave server's path is <host>:<port> instead of <host>.<domain>:<port> means that there is a bug on configuration, but I can't say what and where.

Thanks fr your help ^^
|||Must I create a new login such this pattern : CREATE LOGIN <domain\\login> FROM WINDOWS ?
When You create your instance of SQL Server, what do you set for account to run service ? Local System ? Network System ? domain ? Is this element important or interessant in my problem ? thx
|||Actually in the link i gave above i've created 3 instances of sql server in my local PC and all 3 run under local system account but in real time environment you need to make use of a domain id (preferably) for the sql service account in all 3 principal,mirror and witness servers

Thanxx
Deepak

|||I've tried with the elment domain, I set the login of my administrator account, the password and . for domain (. give the real domain), and I get the same problem, server not found. So the problem is not here

Somebody speaks me of sp_configure and surface area configuration, what do I search with this tools, an idea ?

Another question, how can I get the sql sever developer edition ?

|||refer the link for developer edition,
http://www.microsoft.com/sql/editions/developer/howtobuy.mspx

Thanxx
Deepak


|||Do I need to create login on each server for the connection, and give access to connect endpoint, or sa is ok ?
|||I believe you need to create same login in each server for the connection and configure endpoint ! !

Error on setting ip partners : servers not found

Hello,

I have un problem with the mirroring, when I set the IP of the partners, I get an error saying that the server will not exists or it's impossible to join it. I try to make a mirroring without witness between two servers.

request on first :
ALTER DATABASE [panorama2]
SET PARTNER = N'TCP://192.168.1.71:5050'

I get :

Msg1418, Niveau16, tat1, Ligne1
L'adresse reseau du serveur "TCP://192.168.1.71:5050" est impossible à atteindre ou elle n'existe pas. Verifiez le nom de l'adresse reseau et executez la commande de nouveau.

And it's the same problem with the second server.

I work with the sql server evaluation (I put the parameter T 1400 for). Endpoints are created (I get them with a select on systcp_endpoints) :
Mirroring 65541 1 2 TCP 4 DATABASE_MIRRORING 0 STARTED 0 5050 0 NULL

Thanks for helping.

ps : Excuse my english ^^

The problem might be Fully Qualified Domain Name (FQDN).........try specifying as shown below,

To start database mirroring, you next specify the partners and witness. You need database owner permissions to start and administer a given database mirroring session. On server A, the intended principal server, you tell SQL Server to give a particular database the principal role and what its partner (mirror) server is :

ALTER DATABASE [AdventureWorks] SET PARTNER =
N'TCP://B.corp.mycompany.com:5022'

The partner name must be the fully qualified computer name of the partner. Finding fully qualified names can be a challenge, but the Configure Database Mirroring Security Wizard will find them automatically when establishing endpoints.
The fully qualified computer name of each server can also be found running the following from the command prompt :

IPCONFIG /ALL
Concatenate the "Host Name" and "Primary DNS Suffix". If you see something like:
Host Name . . . . . . . . . . . . : A
Primary Dns Suffix . . . . . . . : corp.mycompany.com

Then the computer name is just A.corp.mycompany.com. Prefix 'TCP://' and append ':' and you then have the partner name.
On the mirror server, you would just repeat the same command, but with the principal server named :

ALTER DATABASE [AdventureWorks] SET PARTNER =
N'TCP://A.corp.mycompany.com:5022'

On the principal server, you next specify the witness server:

ALTER DATABASE [AdventureWorks] SET WITNESS =
N'TCP://W.corp.mycompany.com:5026'
|||Thanks for you answer.

So we can't use IP to connect servers ? I thought the contrary...

I start to work with domain, I set same domain for each server, but I have another problem, the mirror server is OK (It takes the ALTER TABLE), but I can't set the PARTNER to master, I get the same error as before, and I don't understand why.

Thanks for help |||Arnard can you pls explain it a little more ? is database mirroring configured and workiong well ? do you mean to say that you can't set the "alter database set partner" for principal ?
|||Yes, when i do the command :

ALTER DATABASE [panorama2]
SET PARTNER = N'TCP://srv-bat2.technet:5050'

on "master" and "slave", slave accept the command (with srv-bat instead of srv-bat2), but master not, he says that srv-bat2 is not found or not exists.

And I don't understand why master does't find slave, in contrary of slave that find master.
|||May be can you try giving someother end point listening port instead of 5050 you've mentioned above !
|||Result of sys.tcp_endpoints on srv-bat2 :

Mirroring 65540 1 2 TCP 4 DATABASE_MIRRORING 0 STARTED 0 5050 0 NULL

So I have the good port :/
netstat says port 5050 is open.

I don't understand why I can't make the mirroring -_-
|||Arnard,
I have configured mirroring in sql 2005 evaluation edition pls refer the link,
http://sql-articles.com/articles/dbmrr.htm
i don't know if it will solve your problem but just have a glance through it

Thanxx
Deepak
|||Thanks for your link, but I already saw this website.

Howewer, when I used the GUI to create the mirror, on the master server the path selected by sql server is <host>.<domain>:<port>, but on the slave server, I have <host>:<port>. And when I tried to start mirroring, I get the same error saying that the second server is not found

I have switch between the two servers and I get the same result. Do I need to configure another thing anywhere ? the fact that the slave server's path is <host>:<port> instead of <host>.<domain>:<port> means that there is a bug on configuration, but I can't say what and where.

Thanks fr your help ^^
|||Must I create a new login such this pattern : CREATE LOGIN <domain\\login> FROM WINDOWS ?
When You create your instance of SQL Server, what do you set for account to run service ? Local System ? Network System ? domain ? Is this element important or interessant in my problem ? thx
|||Actually in the link i gave above i've created 3 instances of sql server in my local PC and all 3 run under local system account but in real time environment you need to make use of a domain id (preferably) for the sql service account in all 3 principal,mirror and witness servers

Thanxx
Deepak

|||I've tried with the elment domain, I set the login of my administrator account, the password and . for domain (. give the real domain), and I get the same problem, server not found. So the problem is not here

Somebody speaks me of sp_configure and surface area configuration, what do I search with this tools, an idea ?

Another question, how can I get the sql sever developer edition ?

|||refer the link for developer edition,
http://www.microsoft.com/sql/editions/developer/howtobuy.mspx

Thanxx
Deepak


|||Do I need to create login on each server for the connection, and give access to connect endpoint, or sa is ok ?
|||I believe you need to create same login in each server for the connection and configure endpoint ! !

Error on setting ip partners : servers not found

Hello,

I have un problem with the mirroring, when I set the IP of the partners, I get an error saying that the server will not exists or it's impossible to join it. I try to make a mirroring without witness between two servers.

request on first :
ALTER DATABASE [panorama2]
SET PARTNER = N'TCP://192.168.1.71:5050'

I get :

Msg1418, Niveau16, tat1, Ligne1
L'adresse reseau du serveur "TCP://192.168.1.71:5050" est impossible à atteindre ou elle n'existe pas. Verifiez le nom de l'adresse reseau et executez la commande de nouveau.

And it's the same problem with the second server.

I work with the sql server evaluation (I put the parameter T 1400 for). Endpoints are created (I get them with a select on systcp_endpoints) :
Mirroring 65541 1 2 TCP 4 DATABASE_MIRRORING 0 STARTED 0 5050 0 NULL

Thanks for helping.

ps : Excuse my english ^^

The problem might be Fully Qualified Domain Name (FQDN).........try specifying as shown below,

To start database mirroring, you next specify the partners and witness. You need database owner permissions to start and administer a given database mirroring session. On server A, the intended principal server, you tell SQL Server to give a particular database the principal role and what its partner (mirror) server is :

ALTER DATABASE [AdventureWorks] SET PARTNER =
N'TCP://B.corp.mycompany.com:5022'

The partner name must be the fully qualified computer name of the partner. Finding fully qualified names can be a challenge, but the Configure Database Mirroring Security Wizard will find them automatically when establishing endpoints.
The fully qualified computer name of each server can also be found running the following from the command prompt :

IPCONFIG /ALL
Concatenate the "Host Name" and "Primary DNS Suffix". If you see something like:
Host Name . . . . . . . . . . . . : A
Primary Dns Suffix . . . . . . . : corp.mycompany.com

Then the computer name is just A.corp.mycompany.com. Prefix 'TCP://' and append ':' and you then have the partner name.
On the mirror server, you would just repeat the same command, but with the principal server named :

ALTER DATABASE [AdventureWorks] SET PARTNER =
N'TCP://A.corp.mycompany.com:5022'

On the principal server, you next specify the witness server:

ALTER DATABASE [AdventureWorks] SET WITNESS =
N'TCP://W.corp.mycompany.com:5026'
|||Thanks for you answer.

So we can't use IP to connect servers ? I thought the contrary...

I start to work with domain, I set same domain for each server, but I have another problem, the mirror server is OK (It takes the ALTER TABLE), but I can't set the PARTNER to master, I get the same error as before, and I don't understand why.

Thanks for help |||Arnard can you pls explain it a little more ? is database mirroring configured and workiong well ? do you mean to say that you can't set the "alter database set partner" for principal ?
|||Yes, when i do the command :

ALTER DATABASE [panorama2]
SET PARTNER = N'TCP://srv-bat2.technet:5050'

on "master" and "slave", slave accept the command (with srv-bat instead of srv-bat2), but master not, he says that srv-bat2 is not found or not exists.

And I don't understand why master does't find slave, in contrary of slave that find master.
|||May be can you try giving someother end point listening port instead of 5050 you've mentioned above !
|||Result of sys.tcp_endpoints on srv-bat2 :

Mirroring 65540 1 2 TCP 4 DATABASE_MIRRORING 0 STARTED 0 5050 0 NULL

So I have the good port :/
netstat says port 5050 is open.

I don't understand why I can't make the mirroring -_-
|||Arnard,
I have configured mirroring in sql 2005 evaluation edition pls refer the link,
http://sql-articles.com/articles/dbmrr.htm
i don't know if it will solve your problem but just have a glance through it

Thanxx
Deepak
|||Thanks for your link, but I already saw this website.

Howewer, when I used the GUI to create the mirror, on the master server the path selected by sql server is <host>.<domain>:<port>, but on the slave server, I have <host>:<port>. And when I tried to start mirroring, I get the same error saying that the second server is not found

I have switch between the two servers and I get the same result. Do I need to configure another thing anywhere ? the fact that the slave server's path is <host>:<port> instead of <host>.<domain>:<port> means that there is a bug on configuration, but I can't say what and where.

Thanks fr your help ^^
|||Must I create a new login such this pattern : CREATE LOGIN <domain\\login> FROM WINDOWS ?
When You create your instance of SQL Server, what do you set for account to run service ? Local System ? Network System ? domain ? Is this element important or interessant in my problem ? thx
|||Actually in the link i gave above i've created 3 instances of sql server in my local PC and all 3 run under local system account but in real time environment you need to make use of a domain id (preferably) for the sql service account in all 3 principal,mirror and witness servers

Thanxx
Deepak

|||I've tried with the elment domain, I set the login of my administrator account, the password and . for domain (. give the real domain), and I get the same problem, server not found. So the problem is not here

Somebody speaks me of sp_configure and surface area configuration, what do I search with this tools, an idea ?

Another question, how can I get the sql sever developer edition ?

|||refer the link for developer edition,
http://www.microsoft.com/sql/editions/developer/howtobuy.mspx

Thanxx
Deepak


|||Do I need to create login on each server for the connection, and give access to connect endpoint, or sa is ok ?
|||I believe you need to create same login in each server for the connection and configure endpoint ! !
sql

Error on setting ip partners : servers not found

Hello,

I have un problem with the mirroring, when I set the IP of the partners, I get an error saying that the server will not exists or it's impossible to join it. I try to make a mirroring without witness between two servers.

request on first :
ALTER DATABASE [panorama2]
SET PARTNER = N'TCP://192.168.1.71:5050'

I get :

Msg1418, Niveau16, tat1, Ligne1
L'adresse reseau du serveur "TCP://192.168.1.71:5050" est impossible à atteindre ou elle n'existe pas. Verifiez le nom de l'adresse reseau et executez la commande de nouveau.

And it's the same problem with the second server.

I work with the sql server evaluation (I put the parameter T 1400 for). Endpoints are created (I get them with a select on systcp_endpoints) :
Mirroring 65541 1 2 TCP 4 DATABASE_MIRRORING 0 STARTED 0 5050 0 NULL

Thanks for helping.

ps : Excuse my english ^^

The problem might be Fully Qualified Domain Name (FQDN).........try specifying as shown below,

To start database mirroring, you next specify the partners and witness. You need database owner permissions to start and administer a given database mirroring session. On server A, the intended principal server, you tell SQL Server to give a particular database the principal role and what its partner (mirror) server is :

ALTER DATABASE [AdventureWorks] SET PARTNER =
N'TCP://B.corp.mycompany.com:5022'

The partner name must be the fully qualified computer name of the partner. Finding fully qualified names can be a challenge, but the Configure Database Mirroring Security Wizard will find them automatically when establishing endpoints.
The fully qualified computer name of each server can also be found running the following from the command prompt :

IPCONFIG /ALL
Concatenate the "Host Name" and "Primary DNS Suffix". If you see something like:
Host Name . . . . . . . . . . . . : A
Primary Dns Suffix . . . . . . . : corp.mycompany.com

Then the computer name is just A.corp.mycompany.com. Prefix 'TCP://' and append ':' and you then have the partner name.
On the mirror server, you would just repeat the same command, but with the principal server named :

ALTER DATABASE [AdventureWorks] SET PARTNER =
N'TCP://A.corp.mycompany.com:5022'

On the principal server, you next specify the witness server:

ALTER DATABASE [AdventureWorks] SET WITNESS =
N'TCP://W.corp.mycompany.com:5026'
|||Thanks for you answer.

So we can't use IP to connect servers ? I thought the contrary...

I start to work with domain, I set same domain for each server, but I have another problem, the mirror server is OK (It takes the ALTER TABLE), but I can't set the PARTNER to master, I get the same error as before, and I don't understand why.

Thanks for help |||Arnard can you pls explain it a little more ? is database mirroring configured and workiong well ? do you mean to say that you can't set the "alter database set partner" for principal ?
|||Yes, when i do the command :

ALTER DATABASE [panorama2]
SET PARTNER = N'TCP://srv-bat2.technet:5050'

on "master" and "slave", slave accept the command (with srv-bat instead of srv-bat2), but master not, he says that srv-bat2 is not found or not exists.

And I don't understand why master does't find slave, in contrary of slave that find master.
|||May be can you try giving someother end point listening port instead of 5050 you've mentioned above !
|||Result of sys.tcp_endpoints on srv-bat2 :

Mirroring 65540 1 2 TCP 4 DATABASE_MIRRORING 0 STARTED 0 5050 0 NULL

So I have the good port :/
netstat says port 5050 is open.

I don't understand why I can't make the mirroring -_-
|||Arnard,
I have configured mirroring in sql 2005 evaluation edition pls refer the link,
http://sql-articles.com/articles/dbmrr.htm
i don't know if it will solve your problem but just have a glance through it

Thanxx
Deepak
|||Thanks for your link, but I already saw this website.

Howewer, when I used the GUI to create the mirror, on the master server the path selected by sql server is <host>.<domain>:<port>, but on the slave server, I have <host>:<port>. And when I tried to start mirroring, I get the same error saying that the second server is not found

I have switch between the two servers and I get the same result. Do I need to configure another thing anywhere ? the fact that the slave server's path is <host>:<port> instead of <host>.<domain>:<port> means that there is a bug on configuration, but I can't say what and where.

Thanks fr your help ^^
|||Must I create a new login such this pattern : CREATE LOGIN <domain\\login> FROM WINDOWS ?
When You create your instance of SQL Server, what do you set for account to run service ? Local System ? Network System ? domain ? Is this element important or interessant in my problem ? thx
|||Actually in the link i gave above i've created 3 instances of sql server in my local PC and all 3 run under local system account but in real time environment you need to make use of a domain id (preferably) for the sql service account in all 3 principal,mirror and witness servers

Thanxx
Deepak

|||I've tried with the elment domain, I set the login of my administrator account, the password and . for domain (. give the real domain), and I get the same problem, server not found. So the problem is not here

Somebody speaks me of sp_configure and surface area configuration, what do I search with this tools, an idea ?

Another question, how can I get the sql sever developer edition ?

|||refer the link for developer edition,
http://www.microsoft.com/sql/editions/developer/howtobuy.mspx

Thanxx
Deepak


|||Do I need to create login on each server for the connection, and give access to connect endpoint, or sa is ok ?
|||I believe you need to create same login in each server for the connection and configure endpoint ! !

Error on Passing parameter to stored procedure

Hi,

I have a procedure that will save to table in sql server 200 via stored procedure. When I hit the save button it alwasy give me an error saying "Procedure 'sp_AddBoard' expects parameter '@.dtmWarrantyStart', which was not supplied" even though I supplied it in the code

which is

Dim ParamdtmWarrantyStart As SqlParameter = New SqlParameter("@.dtmWarrantyStart", SqlDbType.datetime, 8)
ParamdtmWarrantyStart.Value = dtmWarrantyStart
myCommand.Parameters.Add(ParamdtmWarrantyStart)

below is the stored procedure.

create Proc sp_AddBoard(@.BrandID int,
@.strPcName varchar(50),
@.bitAccounted bit,
@.dtmAccounted datetime,
@.dtmWarrantyStart datetime,
@.dtmWarrantyEnd datetime,
-- @.strDescription varchar(500),
@.intStatus int,
@.ModelNo varchar(50),
@.intMemorySlots int,
@.intMemSlotTaken int,
@.intAgpSlots int,
@.intPCI int,
@.bitWSound bit,
@.bitWLan bit,
@.bitWVideo bit,
@.dtmAcquired datetime,
@.stat bit output,
@.intFSB int) as
if not exists(select strPcName from tblBoards where strPcName=@.strPcName)
begin
insert into tblBoards
(BrandID, strPcName, bitAccounted,
dtmAccounted, dtmWarrantyStart,
dtmWarrantyEnd, --strDescription,
intStatus,
ModelNo, intMemorySlots, intMemSlotTaken,
intAgpSlots, intPCI, bitWLan,
bitWVideo, dtmAcquired,intFSB,bitWSound)

values

(@.BrandID,@.strPcName,@.bitAccounted,
@.dtmAccounted,@.dtmWarrantyStart,
@.dtmWarrantyEnd,--@.strDescription,
@.intStatus,
@.ModelNo,@.intMemorySlots,@.intMemSlotTaken,
@.intAgpSlots,@.intPCI,@.bitWLan,
@.bitWVideo,@.dtmAcquired,@.intFSB,@.bitWSound)
end
else
begin
set @.stat=1
end

The table is also designed to accept nulls on that field but still same error occured.

Please helpjust check if there is any value in the parameter value. the way i normally do is :

myCommand.Parameters.Add(New SqlParameter("@.cusbday",SqlDbType.datetime))
If len(trim(bday.Text)) = 0 Then
myCommand.Parameters("@.cusbday").Value = SqlDateTime.null
Else
myCommand.Parameters("@.cusbday").Value = DateTime.Parse(bday.Text)
End If

also you need to import the namespace System.Data.SqlTypes to use sqldatetime.null

<%@. import Namespace="System.Data.SqlTypes" %>

hthsql

Error message using "Copy Database Wizard"

Any advice from the crowd? Every time I try to run "Copy Database
Wizard" I get an error message saying I must be a member of the
sysadmin group and have permission to copy files over the network. I'm
a local admin on both boxes and a member of the sysadmin group on both
SQL servers and an admin on the network. What am I missing here?

Thanks,

Ralph Noble
ralph_noble@.hotmail.comIs the target server running under a domain account? Check out:

http://support.microsoft.com/defaul...463&Product=sql

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Ralph Noble" <ralph_noble@.hotmail.com> wrote in message
news:ed6de1e7.0411110741.15429731@.posting.google.c om...
> Any advice from the crowd? Every time I try to run "Copy Database
> Wizard" I get an error message saying I must be a member of the
> sysadmin group and have permission to copy files over the network. I'm
> a local admin on both boxes and a member of the sysadmin group on both
> SQL servers and an admin on the network. What am I missing here?
> Thanks,
> Ralph Noble
> ralph_noble@.hotmail.com

error message saying I do not meet minimum hardware requirements

Hi

trying to install sql server 2005, but I get an error message that I do not meet minimum hardware requirements. But this is not right. I've a 32-bit system...............Windows XP professional and SP2. I have enough disk space and just don't know what the problem is. Please help anyone

Which edition are you trying to install? Enterprise edition is not suppoted and will not install on Windows XP. Also, is the install blocking you or just warning you?|||trying to install the standard ed. Its actually just a warning, but if I do carry on, it says something about not finding asp.net|||You'll get the warning if the processor speed is under 1 GHz or memory is under 1 GB. This is spelled out on the readme on the CD/DVD. I would bet you're under one of these numbers.