I'm creating my first Report Model and I've managed to get through it, but if I select the "Update model statistics before generating" in the "Report Model Wizard", I get this error:
"Specified method is not supported"
(It would be a little less frustrating if it actually HAD specified the method <s>)
Anyone know what this is or how to fix it?
Thanks in advance,
Mike
Hi Mike,
Did you get a solution to this issue as we are experiencing it here. Thanks.
|||No, never did...
I'm creating my first Report Model and I've managed to get through it, but if I select the "Update model statistics before generating" in the "Report Model Wizard", I get this error:
"Specified method is not supported"
(It would be a little less frustrating if it actually HAD specified the method <s>)
Anyone know what this is or how to fix it?
Thanks in advance,
Mike
Hi Mike,
Did you get a solution to this issue as we are experiencing it here. Thanks.
|||No, never did...I'm creating a new SQL CE database on a desktop computer via merge replication with an existing SQL 2005 database. The original database is appx. 270MB, so I set the "max database size" parameter in my connection string to 1024 (which should indicate a max SQL CE database size of 1GB). The initial replication works fine. However, when I open the database from my custom application (which does NOT specify a max database size in its connection string), I get an exception telling me that the database has grown beyond its maximum size.
The documentation for SQL CE seems to indicate that the "max database size" connection string parameter is only examined when the database is originally created or compacted. Is this true, or do I need to specify max database size in the connection string even when opening an existing database?
Thanks in advance for any help or direction anyone can offer!
For the final word on Max database size, see http://blogs.msdn.com/sqlservercompact/archive/2007/06/13/the-story-of-max-database-size-connection-string-parameter.aspx
In Dts you can loop a package by creating an Active-X script with something like this ...
"oPackage.Steps("DTSStep_1").ExecutionStatus = DTSStepExecStat_Waiting"
"oPackage.Steps("DTSStep_2").ExecutionStatus = DTSStepScriptResult_DontExecuteTask"
What is the way to do in SSIS? Depending on a condition i want to rerun my package but have not found a smooth way to do it. I guess you can do it in a better way than using the ActiveX Script Task
have a nice day
/Erik
I think the For loop container can help on that (you can place a Execution package task inside to call another package).
http://msdn2.microsoft.com/en-us/library/ms139956.aspx
I know there is a lot of info in the web, so do a litle research and post back if you need more help.
|||Well, the thing is that I use a foreach loop for all rows in a table.. but when all rows are processed there might be a row that have been inserted during the process of the rows that existed at the time the package started..
So after my foreach container i want to to check if there are new rows to process before ending the package... if there are any, I want to start trigger the first task in my package....
I still see this doable. My suggestion was to create an additional package that acts as parent package; it would have a for loop (different than a foreach loop) with an execution package task inside. The For Loop container would have evaluation expression that is modified by the child package in case one of those special rows is inserted. The child package needs to know when a row of the type that requires a new iteration is inserted; so it can change the evaluation expression of the parent package to make it to continue.
This is just an idea; I have not done something simila before.
|||OK, I understand what you mean.. I′ll check it out, cheers for the help!
I am attempting to go through the "Creating a Mobile Application with SQL Server" walkthrough found in the SQL Mobile Books Online help file. Towards the end of this document (under SQL Server Mobile Tasks), they show how to create a new subscription. Unfortunately, after step 10--when you are asked to click finish--I get the following error:
TITLE: Microsoft SQL Server Management Studio
Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect.
HRESULT 0x80004005 (29061)
One potential area of concern is in setting up the windows authentication login. Step two of "Secure the publication" states "type computername\iusr_computername, where computername is the name of your computer." I was not sure what iusr_computername stood for--should I just type in my windows account for this machine? Or am I to make an account called "isur_computername?"
I just restarted my system and now receive a different error (at the same place):
TITLE: Microsoft SQL Server Management Studio
Authentication failed on the computer running IIS.
HRESULT 0x80070057 (28011)
Hi,
IUSR_<IISMachineName> is an account automatically built-in and would be created automatically when IIS is installed. This is the login account that would be used when you chose the authentication as anonymous. Simply to say, this is anonymous user account. Ofcourse, you can change IIS to use a different account as anonymous account. Now, please replace the 'IISMachineName' with IIS Machine name in your environment and assign permissions to this IUSR account on Virtual Directory (read & write, create and delete files).
Hope this helps!
Thanks,
Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation
|||I'm having the same problem when I try to use a subscription for MS SQL 2005 I get the same error message. I have tried to use different account including the IUSR_<machinename> but have the same problem.|||Hi keyboardape. Did you solve your problem?
I met the same issue like your and I solved it today.
Let me know
|||I am getting this same message! I'm trying to get the AdventureWorks merge replication sample using a mobile device to work.
I have tried both anonymous and authenticated and used various users. Any help? Thanks!
|||Hi Nick, what was the solution?
initially I had the exactly same error as jonfroehlich ...
the walkthrough goes fine until step 10 of 'create a new subscripition' then it just fails and gives the following error:
--
Failure to connect to SQL Server with provided connection information.
SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect.
HRESULT 0x80004005 (29061)
The operation could not be completed.
--
but after running it again the error msg has changed to ...
--
Initializing SQL Server Reconciler has failed.
HRESULT 0x80045901 (29045)
The process could not connect to Distributor '<mycomputername>.
HRESULT 0x00004E74 (0)The operation could not be completed.
--
I created a new iusr_<computername> account as directed in the walkthrough and have assigned it accordingly...
can you help?
Thanks
|||Hi there7. execute the web synchronisation wizard (conwizz30.exe) before the subscription wizard!!
this wizard creates the virtual directory for the webaccess, choose annonymous access
8. execute the subscription wizard and use windowsauthentication
the following link helps a lot:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnppcgen/html/med302_msdn_sql_mobile.asp?frame=true
by the way, check the port (settigns-Controlpanel-administrativetool-iis) of your IIS (default is 80) but it might be possible that it's not (if you use skype or such appilations)
if it's not 80 you have to add the port to the url in the WebServer Authentication Step of the Subscription Wizard like 192.168.0.111:81/myVirtDir
Hop it helps
Greets Florian
|||
In my case, I got a very similar error message while trying to use SQL server authentication with the 'sa' account.
- Synchronizing Data (100%) (Error)
Messages
* Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the SQL user is not a valid user on the SQL Server, or the password is incorrect.
HRESULT 0x80004005 (29060)
It turned out sa account was disabled by default.
|||I have the same problem. The fix of Florian did not help me.
Any suggestion?
Thanks
GIo
|||It is Correct.
Thanks. I got the solution. I have created a Word Document to configure step by step.
But, I dont know how to upload it here to help others.
|||Hi,
Previously I was using Sql mobile in device, that was worked fine with SQL Server 2005. Now as per client's requirement they want the Database in sql ce and sql server 2000.
First of all I would like to know that which are the required cab files for sql ce environment in the device and from where i can get those?
When i see the merge agent, it is connecting Sql server 2000 from sql mobile and it is able to connect the sql server 2000 publisher, but after connecting to publisher when it tries to connect the subscriber it stops with message "Connecting to subscriber WM_Dhaval1". after waiting for 10 minutes the message changes to "The agent is suspect, no response within last 10 minutes" with failed satus. I am sure the problem is with subscriber.
Is sql mobile compatible with sql server 2000? or i have to use sql ce for mobile device explicitely?
|||Was having the same issue. I believe it is caused because I have multiple network cards.I got this tutorial working, when in the wizard to create a new subscription on the page "choose publication" I selected the aktual server name (my pc name) rather than (local). Then it worked for me.
good luck
|||I have the same problem, each time to subscribe the subscription said that the IIS user is not valid SQL Server user. When I create publication on Windows XP the problem is solved, but when I try on Vista the problem go back again. I have create SQL Server login for IUSR and put it into Publication Access List (PAL) of my publication. Is there any user that I must include for IIS 7 or only IUSR.
Sorry I'm really new on discovering IIS 7, for IIS 6 just fine for me.
Thanks,
I am attempting to go through the "Creating a Mobile Application with SQL Server" walkthrough found in the SQL Mobile Books Online help file. Towards the end of this document (under SQL Server Mobile Tasks), they show how to create a new subscription. Unfortunately, after step 10--when you are asked to click finish--I get the following error:
TITLE: Microsoft SQL Server Management Studio
Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect.
HRESULT 0x80004005 (29061)
One potential area of concern is in setting up the windows authentication login. Step two of "Secure the publication" states "type computername\iusr_computername, where computername is the name of your computer." I was not sure what iusr_computername stood for--should I just type in my windows account for this machine? Or am I to make an account called "isur_computername?"
I just restarted my system and now receive a different error (at the same place):
TITLE: Microsoft SQL Server Management Studio
Authentication failed on the computer running IIS.
HRESULT 0x80070057 (28011)
Hi,
IUSR_<IISMachineName> is an account automatically built-in and would be created automatically when IIS is installed. This is the login account that would be used when you chose the authentication as anonymous. Simply to say, this is anonymous user account. Ofcourse, you can change IIS to use a different account as anonymous account. Now, please replace the 'IISMachineName' with IIS Machine name in your environment and assign permissions to this IUSR account on Virtual Directory (read & write, create and delete files).
Hope this helps!
Thanks,
Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation
|||I'm having the same problem when I try to use a subscription for MS SQL 2005 I get the same error message. I have tried to use different account including the IUSR_<machinename> but have the same problem.|||Hi keyboardape. Did you solve your problem?
I met the same issue like your and I solved it today.
Let me know
|||I am getting this same message! I'm trying to get the AdventureWorks merge replication sample using a mobile device to work.
I have tried both anonymous and authenticated and used various users. Any help? Thanks!
|||Hi Nick, what was the solution?
initially I had the exactly same error as jonfroehlich ...
the walkthrough goes fine until step 10 of 'create a new subscripition' then it just fails and gives the following error:
--
Failure to connect to SQL Server with provided connection information.
SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect.
HRESULT 0x80004005 (29061)
The operation could not be completed.
--
but after running it again the error msg has changed to ...
--
Initializing SQL Server Reconciler has failed.
HRESULT 0x80045901 (29045)
The process could not connect to Distributor '<mycomputername>.
HRESULT 0x00004E74 (0)The operation could not be completed.
--
I created a new iusr_<computername> account as directed in the walkthrough and have assigned it accordingly...
can you help?
Thanks
|||Hi there7. execute the web synchronisation wizard (conwizz30.exe) before the subscription wizard!!
this wizard creates the virtual directory for the webaccess, choose annonymous access
8. execute the subscription wizard and use windowsauthentication
the following link helps a lot:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnppcgen/html/med302_msdn_sql_mobile.asp?frame=true
by the way, check the port (settigns-Controlpanel-administrativetool-iis) of your IIS (default is 80) but it might be possible that it's not (if you use skype or such appilations)
if it's not 80 you have to add the port to the url in the WebServer Authentication Step of the Subscription Wizard like 192.168.0.111:81/myVirtDir
Hop it helps
Greets Florian
|||
In my case, I got a very similar error message while trying to use SQL server authentication with the 'sa' account.
- Synchronizing Data (100%) (Error)
Messages
* Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the SQL user is not a valid user on the SQL Server, or the password is incorrect.
HRESULT 0x80004005 (29060)
It turned out sa account was disabled by default.
|||I have the same problem. The fix of Florian did not help me.
Any suggestion?
Thanks
GIo
|||It is Correct.
Thanks. I got the solution. I have created a Word Document to configure step by step.
But, I dont know how to upload it here to help others.
|||Hi,
Previously I was using Sql mobile in device, that was worked fine with SQL Server 2005. Now as per client's requirement they want the Database in sql ce and sql server 2000.
First of all I would like to know that which are the required cab files for sql ce environment in the device and from where i can get those?
When i see the merge agent, it is connecting Sql server 2000 from sql mobile and it is able to connect the sql server 2000 publisher, but after connecting to publisher when it tries to connect the subscriber it stops with message "Connecting to subscriber WM_Dhaval1". after waiting for 10 minutes the message changes to "The agent is suspect, no response within last 10 minutes" with failed satus. I am sure the problem is with subscriber.
Is sql mobile compatible with sql server 2000? or i have to use sql ce for mobile device explicitely?
|||Was having the same issue. I believe it is caused because I have multiple network cards.I got this tutorial working, when in the wizard to create a new subscription on the page "choose publication" I selected the aktual server name (my pc name) rather than (local). Then it worked for me.
good luck
|||I have the same problem, each time to subscribe the subscription said that the IIS user is not valid SQL Server user. When I create publication on Windows XP the problem is solved, but when I try on Vista the problem go back again. I have create SQL Server login for IUSR and put it into Publication Access List (PAL) of my publication. Is there any user that I must include for IIS 7 or only IUSR.
Sorry I'm really new on discovering IIS 7, for IIS 6 just fine for me.
Thanks,
I am attempting to go through the "Creating a Mobile Application with SQL Server" walkthrough found in the SQL Mobile Books Online help file. Towards the end of this document (under SQL Server Mobile Tasks), they show how to create a new subscription. Unfortunately, after step 10--when you are asked to click finish--I get the following error:
TITLE: Microsoft SQL Server Management Studio
Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect.
HRESULT 0x80004005 (29061)
One potential area of concern is in setting up the windows authentication login. Step two of "Secure the publication" states "type computername\iusr_computername, where computername is the name of your computer." I was not sure what iusr_computername stood for--should I just type in my windows account for this machine? Or am I to make an account called "isur_computername?"
I just restarted my system and now receive a different error (at the same place):
TITLE: Microsoft SQL Server Management Studio
Authentication failed on the computer running IIS.
HRESULT 0x80070057 (28011)
Hi,
IUSR_<IISMachineName> is an account automatically built-in and would be created automatically when IIS is installed. This is the login account that would be used when you chose the authentication as anonymous. Simply to say, this is anonymous user account. Ofcourse, you can change IIS to use a different account as anonymous account. Now, please replace the 'IISMachineName' with IIS Machine name in your environment and assign permissions to this IUSR account on Virtual Directory (read & write, create and delete files).
Hope this helps!
Thanks,
Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation
|||I'm having the same problem when I try to use a subscription for MS SQL 2005 I get the same error message. I have tried to use different account including the IUSR_<machinename> but have the same problem.|||
Hi keyboardape. Did you solve your problem?
I met the same issue like your and I solved it today.
Let me know
|||I am getting this same message! I'm trying to get the AdventureWorks merge replication sample using a mobile device to work.
I have tried both anonymous and authenticated and used various users. Any help? Thanks!
|||Hi Nick, what was the solution?
initially I had the exactly same error as jonfroehlich ...
the walkthrough goes fine until step 10 of 'create a new subscripition' then it just fails and gives the following error:
--
Failure to connect to SQL Server with provided connection information.
SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect.
HRESULT 0x80004005 (29061)
The operation could not be completed.
--
but after running it again the error msg has changed to ...
--
Initializing SQL Server Reconciler has failed.
HRESULT 0x80045901 (29045)
The process could not connect to Distributor '<mycomputername>.
HRESULT 0x00004E74 (0)The operation could not be completed.
--
I created a new iusr_<computername> account as directed in the walkthrough and have assigned it accordingly...
can you help?
Thanks
|||Hi there7. execute the web synchronisation wizard (conwizz30.exe) before the subscription wizard!!
this wizard creates the virtual directory for the webaccess, choose annonymous access
8. execute the subscription wizard and use windowsauthentication
the following link helps a lot:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnppcgen/html/med302_msdn_sql_mobile.asp?frame=true
by the way, check the port (settigns-Controlpanel-administrativetool-iis) of your IIS (default is 80) but it might be possible that it's not (if you use skype or such appilations)
if it's not 80 you have to add the port to the url in the WebServer Authentication Step of the Subscription Wizard like 192.168.0.111:81/myVirtDir
Hop it helps
Greets Florian|||
In my case, I got a very similar error message while trying to use SQL server authentication with the 'sa' account.
- Synchronizing Data (100%) (Error)
Messages
* Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the SQL user is not a valid user on the SQL Server, or the password is incorrect.
HRESULT 0x80004005 (29060)
It turned out sa account was disabled by default.
|||I have the same problem. The fix of Florian did not help me.
Any suggestion?
Thanks
GIo
|||It is Correct.
Thanks. I got the solution. I have created a Word Document to configure step by step.
But, I dont know how to upload it here to help others.
|||Hi,
Previously I was using Sql mobile in device, that was worked fine with SQL Server 2005. Now as per client's requirement they want the Database in sql ce and sql server 2000.
First of all I would like to know that which are the required cab files for sql ce environment in the device and from where i can get those?
When i see the merge agent, it is connecting Sql server 2000 from sql mobile and it is able to connect the sql server 2000 publisher, but after connecting to publisher when it tries to connect the subscriber it stops with message "Connecting to subscriber WM_Dhaval1". after waiting for 10 minutes the message changes to "The agent is suspect, no response within last 10 minutes" with failed satus. I am sure the problem is with subscriber.
Is sql mobile compatible with sql server 2000? or i have to use sql ce for mobile device explicitely?
|||Was having the same issue. I believe it is caused because I have multiple network cards.I got this tutorial working, when in the wizard to create a new subscription on the page "choose publication" I selected the aktual server name (my pc name) rather than (local). Then it worked for me.
good luck|||I have the same problem, each time to subscribe the subscription said that the IIS user is not valid SQL Server user. When I create publication on Windows XP the problem is solved, but when I try on Vista the problem go back again. I have create SQL Server login for IUSR and put it into Publication Access List (PAL) of my publication. Is there any user that I must include for IIS 7 or only IUSR.
Sorry I'm really new on discovering IIS 7, for IIS 6 just fine for me.
Thanks,
I am attempting to go through the "Creating a Mobile Application with SQL Server" walkthrough found in the SQL Mobile Books Online help file. Towards the end of this document (under SQL Server Mobile Tasks), they show how to create a new subscription. Unfortunately, after step 10--when you are asked to click finish--I get the following error:
TITLE: Microsoft SQL Server Management Studio
Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect.
HRESULT 0x80004005 (29061)
One potential area of concern is in setting up the windows authentication login. Step two of "Secure the publication" states "type computername\iusr_computername, where computername is the name of your computer." I was not sure what iusr_computername stood for--should I just type in my windows account for this machine? Or am I to make an account called "isur_computername?"
I just restarted my system and now receive a different error (at the same place):
TITLE: Microsoft SQL Server Management Studio
Authentication failed on the computer running IIS.
HRESULT 0x80070057 (28011)
Hi,
IUSR_<IISMachineName> is an account automatically built-in and would be created automatically when IIS is installed. This is the login account that would be used when you chose the authentication as anonymous. Simply to say, this is anonymous user account. Ofcourse, you can change IIS to use a different account as anonymous account. Now, please replace the 'IISMachineName' with IIS Machine name in your environment and assign permissions to this IUSR account on Virtual Directory (read & write, create and delete files).
Hope this helps!
Thanks,
Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation
|||I'm having the same problem when I try to use a subscription for MS SQL 2005 I get the same error message. I have tried to use different account including the IUSR_<machinename> but have the same problem.|||
Hi keyboardape. Did you solve your problem?
I met the same issue like your and I solved it today.
Let me know
|||I am getting this same message! I'm trying to get the AdventureWorks merge replication sample using a mobile device to work.
I have tried both anonymous and authenticated and used various users. Any help? Thanks!
|||Hi Nick, what was the solution?
initially I had the exactly same error as jonfroehlich ...
the walkthrough goes fine until step 10 of 'create a new subscripition' then it just fails and gives the following error:
--
Failure to connect to SQL Server with provided connection information.
SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect.
HRESULT 0x80004005 (29061)
The operation could not be completed.
--
but after running it again the error msg has changed to ...
--
Initializing SQL Server Reconciler has failed.
HRESULT 0x80045901 (29045)
The process could not connect to Distributor '<mycomputername>.
HRESULT 0x00004E74 (0)The operation could not be completed.
--
I created a new iusr_<computername> account as directed in the walkthrough and have assigned it accordingly...
can you help?
Thanks
|||Hi there7. execute the web synchronisation wizard (conwizz30.exe) before the subscription wizard!!
this wizard creates the virtual directory for the webaccess, choose annonymous access
8. execute the subscription wizard and use windowsauthentication
the following link helps a lot:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnppcgen/html/med302_msdn_sql_mobile.asp?frame=true
by the way, check the port (settigns-Controlpanel-administrativetool-iis) of your IIS (default is 80) but it might be possible that it's not (if you use skype or such appilations)
if it's not 80 you have to add the port to the url in the WebServer Authentication Step of the Subscription Wizard like 192.168.0.111:81/myVirtDir
Hop it helps
Greets Florian|||
In my case, I got a very similar error message while trying to use SQL server authentication with the 'sa' account.
- Synchronizing Data (100%) (Error)
Messages
* Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the SQL user is not a valid user on the SQL Server, or the password is incorrect.
HRESULT 0x80004005 (29060)
It turned out sa account was disabled by default.
|||I have the same problem. The fix of Florian did not help me.
Any suggestion?
Thanks
GIo
|||It is Correct.
Thanks. I got the solution. I have created a Word Document to configure step by step.
But, I dont know how to upload it here to help others.
|||Hi,
Previously I was using Sql mobile in device, that was worked fine with SQL Server 2005. Now as per client's requirement they want the Database in sql ce and sql server 2000.
First of all I would like to know that which are the required cab files for sql ce environment in the device and from where i can get those?
When i see the merge agent, it is connecting Sql server 2000 from sql mobile and it is able to connect the sql server 2000 publisher, but after connecting to publisher when it tries to connect the subscriber it stops with message "Connecting to subscriber WM_Dhaval1". after waiting for 10 minutes the message changes to "The agent is suspect, no response within last 10 minutes" with failed satus. I am sure the problem is with subscriber.
Is sql mobile compatible with sql server 2000? or i have to use sql ce for mobile device explicitely?
|||Was having the same issue. I believe it is caused because I have multiple network cards.I got this tutorial working, when in the wizard to create a new subscription on the page "choose publication" I selected the aktual server name (my pc name) rather than (local). Then it worked for me.
good luck|||I have the same problem, each time to subscribe the subscription said that the IIS user is not valid SQL Server user. When I create publication on Windows XP the problem is solved, but when I try on Vista the problem go back again. I have create SQL Server login for IUSR and put it into Publication Access List (PAL) of my publication. Is there any user that I must include for IIS 7 or only IUSR.
Sorry I'm really new on discovering IIS 7, for IIS 6 just fine for me.
Thanks,
I am attempting to go through the "Creating a Mobile Application with SQL Server" walkthrough found in the SQL Mobile Books Online help file. Towards the end of this document (under SQL Server Mobile Tasks), they show how to create a new subscription. Unfortunately, after step 10--when you are asked to click finish--I get the following error:
TITLE: Microsoft SQL Server Management Studio
Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect.
HRESULT 0x80004005 (29061)
One potential area of concern is in setting up the windows authentication login. Step two of "Secure the publication" states "type computername\iusr_computername, where computername is the name of your computer." I was not sure what iusr_computername stood for--should I just type in my windows account for this machine? Or am I to make an account called "isur_computername?"
I just restarted my system and now receive a different error (at the same place):
TITLE: Microsoft SQL Server Management Studio
Authentication failed on the computer running IIS.
HRESULT 0x80070057 (28011)
Hi,
IUSR_<IISMachineName> is an account automatically built-in and would be created automatically when IIS is installed. This is the login account that would be used when you chose the authentication as anonymous. Simply to say, this is anonymous user account. Ofcourse, you can change IIS to use a different account as anonymous account. Now, please replace the 'IISMachineName' with IIS Machine name in your environment and assign permissions to this IUSR account on Virtual Directory (read & write, create and delete files).
Hope this helps!
Thanks,
Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation
|||I'm having the same problem when I try to use a subscription for MS SQL 2005 I get the same error message. I have tried to use different account including the IUSR_<machinename> but have the same problem.|||Hi keyboardape. Did you solve your problem?
I met the same issue like your and I solved it today.
Let me know
|||I am getting this same message! I'm trying to get the AdventureWorks merge replication sample using a mobile device to work.
I have tried both anonymous and authenticated and used various users. Any help? Thanks!
|||Hi Nick, what was the solution?
initially I had the exactly same error as jonfroehlich ...
the walkthrough goes fine until step 10 of 'create a new subscripition' then it just fails and gives the following error:
--
Failure to connect to SQL Server with provided connection information.
SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect.
HRESULT 0x80004005 (29061)
The operation could not be completed.
--
but after running it again the error msg has changed to ...
--
Initializing SQL Server Reconciler has failed.
HRESULT 0x80045901 (29045)
The process could not connect to Distributor '<mycomputername>.
HRESULT 0x00004E74 (0)The operation could not be completed.
--
I created a new iusr_<computername> account as directed in the walkthrough and have assigned it accordingly...
can you help?
Thanks
|||Hi there7. execute the web synchronisation wizard (conwizz30.exe) before the subscription wizard!!
this wizard creates the virtual directory for the webaccess, choose annonymous access
8. execute the subscription wizard and use windowsauthentication
the following link helps a lot:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnppcgen/html/med302_msdn_sql_mobile.asp?frame=true
by the way, check the port (settigns-Controlpanel-administrativetool-iis) of your IIS (default is 80) but it might be possible that it's not (if you use skype or such appilations)
if it's not 80 you have to add the port to the url in the WebServer Authentication Step of the Subscription Wizard like 192.168.0.111:81/myVirtDir
Hop it helps
Greets Florian
|||
In my case, I got a very similar error message while trying to use SQL server authentication with the 'sa' account.
- Synchronizing Data (100%) (Error)
Messages
* Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the SQL user is not a valid user on the SQL Server, or the password is incorrect.
HRESULT 0x80004005 (29060)
It turned out sa account was disabled by default.
|||I have the same problem. The fix of Florian did not help me.
Any suggestion?
Thanks
GIo
|||It is Correct.
Thanks. I got the solution. I have created a Word Document to configure step by step.
But, I dont know how to upload it here to help others.
|||Hi,
Previously I was using Sql mobile in device, that was worked fine with SQL Server 2005. Now as per client's requirement they want the Database in sql ce and sql server 2000.
First of all I would like to know that which are the required cab files for sql ce environment in the device and from where i can get those?
When i see the merge agent, it is connecting Sql server 2000 from sql mobile and it is able to connect the sql server 2000 publisher, but after connecting to publisher when it tries to connect the subscriber it stops with message "Connecting to subscriber WM_Dhaval1". after waiting for 10 minutes the message changes to "The agent is suspect, no response within last 10 minutes" with failed satus. I am sure the problem is with subscriber.
Is sql mobile compatible with sql server 2000? or i have to use sql ce for mobile device explicitely?
|||Was having the same issue. I believe it is caused because I have multiple network cards.I got this tutorial working, when in the wizard to create a new subscription on the page "choose publication" I selected the aktual server name (my pc name) rather than (local). Then it worked for me.
good luck
|||I have the same problem, each time to subscribe the subscription said that the IIS user is not valid SQL Server user. When I create publication on Windows XP the problem is solved, but when I try on Vista the problem go back again. I have create SQL Server login for IUSR and put it into Publication Access List (PAL) of my publication. Is there any user that I must include for IIS 7 or only IUSR.
Sorry I'm really new on discovering IIS 7, for IIS 6 just fine for me.
Thanks,
Hi...
Need some help with creating reports in MS SQL Server Report Server and column name "Profit / Loss (%)".
Got an error when I try to run the code below.
The purpose is to avoid a division by zero... or do anyone know a better way solve this?
=IIF(SUM(Fields!RECOGNITION_REVENUE_RECOGNIZED.Value)=0 AND SUM(Fields!PROFIT_AND_LOSS_AMOUNT.Value)=0, 0, IIF(SUM(Fields!RECOGNITION_REVENUE_RECOGNIZED.Value)=0 AND SUM(Fields!PROFIT_AND_LOSS_AMOUNT.Value)<>0, -1, SUM(Fields!PROFIT_AND_LOSS_AMOUNT.Value)))
/
IIF(SUM(Fields!RECOGNITION_REVENUE_RECOGNIZED.Value)=0 AND SUM(Fields!PROFIT_AND_LOSS_AMOUNT.Value)=0, 1, IIF(SUM(Fields!RECOGNITION_REVENUE_RECOGNIZED.Value)=0 AND SUM(Fields!PROFIT_AND_LOSS_AMOUNT.Value)<>0, 1, SUM(Fields!RECOGNITION_REVENUE_RECOGNIZED.Value)))
Error message:
The value expression for the textbox ‘textbox86’ refers to the field ‘PROFIT_AND_LOSS_AMOUNT’. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope.
//chwa
This error message is referring to the scope of the field ‘PROFIT_AND_LOSS_AMOUNT’. It cannot find it in the dataset. Try doing
SUM(Fields!PROFIT_AND_LOSS_AMOUNT.Value, "dataset name here")
for all those things above.
