Help : I Can't Re-installed RS !

I uninstalled Reporting Services SP1 from the development environment.
My Database is on a distant Server.
I want to re-install Reporting Service and I have this message when I select
my Report Server Database (the same as before the uninstal) : "The Report
Server Database is a different version and cannot be used for this
installation."
Can you help me ?First you need to install RS and point to an new DB. After the install
upgrade RS to SP1. Once this is done you will need to run RSConfig to point
to the old DB. If you saved off your Symmetric key you will want to reapply
it using rskeymgmt.exe. If you did not you will need to run
rskeymgmt.exe -d. Doing this will delete all the encrypted content, meaning
you will have to reenter all of your report credentials.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Karine" <Karine@.discussions.microsoft.com> wrote in message
news:074B3037-396E-45D3-B245-1E6798FA1ED1@.microsoft.com...
> I uninstalled Reporting Services SP1 from the development environment.
> My Database is on a distant Server.
> I want to re-install Reporting Service and I have this message when I
select
> my Report Server Database (the same as before the uninstal) : "The Report
> Server Database is a different version and cannot be used for this
> installation."
> Can you help me ?
>
>|||Karine,
I have a step-by-step document that you may find useful:
http://prologika.com/blog/archive/2004/08/20/161.aspx
--
Hope this helps.
----
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com : http://tinyurl.com/3l49j
Home page and blog: http://www.prologika.com/
----
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:%23ymuy74iEHA.1040@.TK2MSFTNGP09.phx.gbl...
> First you need to install RS and point to an new DB. After the install
> upgrade RS to SP1. Once this is done you will need to run RSConfig to
point
> to the old DB. If you saved off your Symmetric key you will want to
reapply
> it using rskeymgmt.exe. If you did not you will need to run
> rskeymgmt.exe -d. Doing this will delete all the encrypted content,
meaning
> you will have to reenter all of your report credentials.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Karine" <Karine@.discussions.microsoft.com> wrote in message
> news:074B3037-396E-45D3-B245-1E6798FA1ED1@.microsoft.com...
> > I uninstalled Reporting Services SP1 from the development environment.
> > My Database is on a distant Server.
> > I want to re-install Reporting Service and I have this message when I
> select
> > my Report Server Database (the same as before the uninstal) : "The
Report
> > Server Database is a different version and cannot be used for this
> > installation."
> >
> > Can you help me ?
> >
> >
> >
>|||Thanks.
I don't use your method because RS has allready uninstalled and so I can't
save my key.
I delete from my SQL Server the DataBase Report and the database
ReportserverTempDB. I run RS install, I select my SQL Server and I can
continu running the install.
I can deploy my reports so now ... all is good ...
"Teo Lachev" wrote:
> Karine,
> I have a step-by-step document that you may find useful:
> http://prologika.com/blog/archive/2004/08/20/161.aspx
> --
> Hope this helps.
> ----
> Teo Lachev, MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> Publisher website: http://www.manning.com/lachev
> Buy it from Amazon.com : http://tinyurl.com/3l49j
> Home page and blog: http://www.prologika.com/
> ----
> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
> news:%23ymuy74iEHA.1040@.TK2MSFTNGP09.phx.gbl...
> > First you need to install RS and point to an new DB. After the install
> > upgrade RS to SP1. Once this is done you will need to run RSConfig to
> point
> > to the old DB. If you saved off your Symmetric key you will want to
> reapply
> > it using rskeymgmt.exe. If you did not you will need to run
> > rskeymgmt.exe -d. Doing this will delete all the encrypted content,
> meaning
> > you will have to reenter all of your report credentials.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> > "Karine" <Karine@.discussions.microsoft.com> wrote in message
> > news:074B3037-396E-45D3-B245-1E6798FA1ED1@.microsoft.com...
> > > I uninstalled Reporting Services SP1 from the development environment.
> > > My Database is on a distant Server.
> > > I want to re-install Reporting Service and I have this message when I
> > select
> > > my Report Server Database (the same as before the uninstal) : "The
> Report
> > > Server Database is a different version and cannot be used for this
> > > installation."
> > >
> > > Can you help me ?
> > >
> > >
> > >
> >
> >
>
>

Help & Support service..?

Hi all,
I can't find my 'Help & Support service' on my Win2003 server.
How can I find it?
Kent J.Control Panel / Administrative Tools / Services
"Kent J" <kent.johnson@.telia.com> wrote in message
news:ZcvOi.10697$ZA.7080@.newsb.telia.net...
> Hi all,
> I can't find my 'Help & Support service' on my Win2003 server.
> How can I find it?
> Kent J.

Help ! Database Still says loading after restore

SQL 2000 SP3

My database is still showing Loading ... after doing a restore and the
restore showing it to be successfull.

I have restarted the service as well.

Help !<csomberg@.dwr.com> wrote in message
news:1115393466.540070.214530@.z14g2000cwz.googlegr oups.com...
> SQL 2000 SP3
> My database is still showing Loading ... after doing a restore and the
> restore showing it to be successfull.
> I have restarted the service as well.
> Help !

You don't say what type of RESTORE it was, but if you were restoring a log,
you may have left the database expecting more log restores. If so, you can
try RESTORE MyDB WITH RECOVERY to get it back online.

If that doesn't help, I suggest you give some more information - which MSSQL
version, what type of restore, exactly how you restored it, etc.

Simon

Help -- Service 'ReportServer' (ReportServer) failed to start.

I'm getting this error which is ruining my life!! :(
"Service 'ReportServer' (ReportServer) failed to start. Verify that
you have
sufficient privileges to start system services."
Its on a win 2k3 box which is set up as a domain controller + with
active directory .. sql2k server is enterprise sp3a
I've downloaded hotfix 859, but no effect
I've tried selecting different users for the service during install
(NETWORK, SYSTEM, MYDOMAIN\ADMINISTRATOR) and none work ..
I've looked for a reportingservices<data>.log file but dont have it
This is on the production test machine .. it installed fine on the
development machine
I need to put it on this box to show the client what he's getting for
his $$$ ..
Google search has not shown any answers for this
Someone please help if you know anything
Regards,
KWIs your DTC service actually running?
http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/c96b2674f52ee5c4/db73487bcc99bd4e
It might say "started" in your services-list, but you might want to check it
out.
Kaisa M. Lindahl
"WildChild" <kiwi_wildchild@.yahoo.com> wrote in message
news:4bc5b196.0412052123.6e881553@.posting.google.com...
> I'm getting this error which is ruining my life!! :(
> "Service 'ReportServer' (ReportServer) failed to start. Verify that
> you have
> sufficient privileges to start system services."
> Its on a win 2k3 box which is set up as a domain controller + with
> active directory .. sql2k server is enterprise sp3a
> I've downloaded hotfix 859, but no effect
> I've tried selecting different users for the service during install
> (NETWORK, SYSTEM, MYDOMAIN\ADMINISTRATOR) and none work ..
> I've looked for a reportingservices<data>.log file but dont have it
> This is on the production test machine .. it installed fine on the
> development machine
> I need to put it on this box to show the client what he's getting for
> his $$$ ..
> Google search has not shown any answers for this
> Someone please help if you know anything
> Regards,
> KW

Help - Loosing my Sanity

We are having a problem with our services (mainly SQL server) in that they loose/forget their passwords. So, even though the service is set to start automatically, it can't do to a logon failure. We must type over the password and then are able to start
the service. This is happening on multiple configurations.
Windows 2000 Advanced, SP2 & 3, SQL Server 2000
Windows 2000 Standard, SP4, SQL Server 2000
SQL Server 2000 is at SP3 with all the latest patches and fixes.
Any help would be greatly appreciated.
Have you checked the settings for the account itself? Make
sure the account is set up so that Password never expires is
selected and Must change password at next login is not
selected.
-Sue
On Tue, 25 May 2004 05:11:12 -0700, "Jenn"
<anonymous@.discussions.microsoft.com> wrote:

>We are having a problem with our services (mainly SQL server) in that they loose/forget their passwords. So, even though the service is set to start automatically, it can't do to a logon failure. We must type over the password and then are able to star
t the service. This is happening on multiple configurations.
>Windows 2000 Advanced, SP2 & 3, SQL Server 2000
>Windows 2000 Standard, SP4, SQL Server 2000
>SQL Server 2000 is at SP3 with all the latest patches and fixes.
>Any help would be greatly appreciated.
|||This is a known problem with version 818. Download the fix if you're
getting prompted for passwords.
826161 FIX: You Are Prompted for Password Confirmation After You Change a
http://support.microsoft.com/?id=826161
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Help - Loosing my Sanity

We are having a problem with our services (mainly SQL server) in that they l
oose/forget their passwords. So, even though the service is set to start au
tomatically, it can't do to a logon failure. We must type over the password
and then are able to start
the service. This is happening on multiple configurations.
Windows 2000 Advanced, SP2 & 3, SQL Server 2000
Windows 2000 Standard, SP4, SQL Server 2000
SQL Server 2000 is at SP3 with all the latest patches and fixes.
Any help would be greatly appreciated.Have you checked the settings for the account itself? Make
sure the account is set up so that Password never expires is
selected and Must change password at next login is not
selected.
-Sue
On Tue, 25 May 2004 05:11:12 -0700, "Jenn"
<anonymous@.discussions.microsoft.com> wrote:

>We are having a problem with our services (mainly SQL server) in that they loose/fo
rget their passwords. So, even though the service is set to start automatically, it
can't do to a logon failure. We must type over the password and then are able to s
tar
t the service. This is happening on multiple configurations.
>Windows 2000 Advanced, SP2 & 3, SQL Server 2000
>Windows 2000 Standard, SP4, SQL Server 2000
>SQL Server 2000 is at SP3 with all the latest patches and fixes.
>Any help would be greatly appreciated.|||This is a known problem with version 818. Download the fix if you're
getting prompted for passwords.
826161 FIX: You Are Prompted for Password Confirmation After You Change a
http://support.microsoft.com/?id=826161
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Help - how to open Report in new browser window?

Hello...
I am struggling with this...but I am getting close.
I am trying to use the Web Service programming interface from my ASP.Net
application. What I am trying to accomplish...is to allow the user to set
some report parameters (date ranges, zip codes, etc). When the user presses
the Run button on my ASP.Net page, I would like to render the report in a new
browser window/page, and with the Toolbar so the user could export to
whatever format that they want. Is this possible?
Thanks for any help...
- DW
The code I am using now is the following..
Dim rptIRIS As Byte() = Nothing
Dim rsIRIS As Secure_SQLRS.ReportingService = New
Secure_SQLRS.ReportingService
rsIRIS.Credentials = New System.Net.NetworkCredential("ME", "Pwd",
"Domain")
rsIRIS.PreAuthenticate = True
Dim rptPath As String = "/WebReports/UserLabels"
Dim rptFormat As String = "HTML4.0"
Dim rptViewerInfo As String = "<DeviceInfo>" & _
"<Toolbar>true</Toolbar>" & _
"<Parameters>false</Parameters>" & _
"<DocMap>true</DocMap>" & _
"<Zoom>100</Zoom>" & _
"</DeviceInfo>"
Dim rptParams(1) As Secure_SQLRS.ParameterValue
Dim paramValue As Secure_SQLRS.ParameterValue = New
Secure_SQLRS.ParameterValue
paramValue.Name = "ProductID"
paramValue.Value = "102"
rptParams(0) = paramValue
paramValue = New Secure_SQLRS.ParameterValue
paramValue.Name = "ZipCode"
paramValue.Value = "12345"
rptParams(1) = paramValue
Dim rptHistoryID As String = Nothing
Dim credentials() As Secure_SQLRS.DataSourceCredentials = Nothing
Dim showHideToggle As String = Nothing
Dim encoding As String
Dim mimeType As String
Dim warnings() As Secure_SQLRS.Warning = Nothing
Dim rptHistoryParams() As Secure_SQLRS.ParameterValue = Nothing
Dim streamIDs() As String = Nothing
Dim rptSessionHdr As Secure_SQLRS.SessionHeader = New
Secure_SQLRS.SessionHeader
rsIRIS.SessionHeaderValue = rptSessionHdr
Try
' execute the report
rptIRIS = rsIRIS.Render(rptPath, rptFormat, rptHistoryID,
rptViewerInfo, rptParams, credentials, _
showHideToggle, encoding, mimeType, rptHistoryParams,
warnings, streamIDs)
rptSessionHdr.SessionId = rsIRIS.SessionHeaderValue.SessionId
Response.Clear()
' set the http headers for the PDF response
HttpContext.Current.Response.ClearHeaders()
HttpContext.Current.Response.ClearContent()
HttpContext.Current.Response.ContentType = "text/html"
HttpContext.Current.Response.AppendHeader("Content-Disposition", _
"filename=""AddressLabels.HTM""")
' send the byte array containing the report as a binary response
HttpContext.Current.Response.BinaryWrite(rptIRIS)
HttpContext.Current.Response.End()
Catch ex As Exception
Finally
End TryYou won't be able to accomplish this with straight SOAP interfaces. You will
have to use a combination of Web service calls to list the reports in the
namespace and then a URL request to the server that includes the
parameterized URL for the report. You can certainly open it in a new browser
window under those conditions.
--
Bryan Keller
Developer Documentation
SQL Server Reporting Services
A friendly reminder that this posting is provided "AS IS" with no
warranties, and confers no rights.
"dw" <dw@.discussions.microsoft.com> wrote in message
news:08CC0691-B2A2-4F4C-A1DA-7DAB23E67F20@.microsoft.com...
> Hello...
> I am struggling with this...but I am getting close.
> I am trying to use the Web Service programming interface from my ASP.Net
> application. What I am trying to accomplish...is to allow the user to set
> some report parameters (date ranges, zip codes, etc). When the user
presses
> the Run button on my ASP.Net page, I would like to render the report in a
new
> browser window/page, and with the Toolbar so the user could export to
> whatever format that they want. Is this possible?
> Thanks for any help...
> - DW
> The code I am using now is the following..
> Dim rptIRIS As Byte() = Nothing
> Dim rsIRIS As Secure_SQLRS.ReportingService = New
> Secure_SQLRS.ReportingService
> rsIRIS.Credentials = New System.Net.NetworkCredential("ME", "Pwd",
> "Domain")
> rsIRIS.PreAuthenticate = True
> Dim rptPath As String = "/WebReports/UserLabels"
> Dim rptFormat As String = "HTML4.0"
> Dim rptViewerInfo As String = "<DeviceInfo>" & _
> "<Toolbar>true</Toolbar>" & _
> "<Parameters>false</Parameters>" & _
> "<DocMap>true</DocMap>" & _
> "<Zoom>100</Zoom>" & _
> "</DeviceInfo>"
>
> Dim rptParams(1) As Secure_SQLRS.ParameterValue
> Dim paramValue As Secure_SQLRS.ParameterValue = New
> Secure_SQLRS.ParameterValue
> paramValue.Name = "ProductID"
> paramValue.Value = "102"
> rptParams(0) = paramValue
> paramValue = New Secure_SQLRS.ParameterValue
> paramValue.Name = "ZipCode"
> paramValue.Value = "12345"
> rptParams(1) = paramValue
> Dim rptHistoryID As String = Nothing
> Dim credentials() As Secure_SQLRS.DataSourceCredentials = Nothing
> Dim showHideToggle As String = Nothing
> Dim encoding As String
> Dim mimeType As String
> Dim warnings() As Secure_SQLRS.Warning = Nothing
> Dim rptHistoryParams() As Secure_SQLRS.ParameterValue = Nothing
> Dim streamIDs() As String = Nothing
> Dim rptSessionHdr As Secure_SQLRS.SessionHeader = New
> Secure_SQLRS.SessionHeader
> rsIRIS.SessionHeaderValue = rptSessionHdr
> Try
> ' execute the report
> rptIRIS = rsIRIS.Render(rptPath, rptFormat, rptHistoryID,
> rptViewerInfo, rptParams, credentials, _
> showHideToggle, encoding, mimeType, rptHistoryParams,
> warnings, streamIDs)
> rptSessionHdr.SessionId = rsIRIS.SessionHeaderValue.SessionId
> Response.Clear()
> ' set the http headers for the PDF response
> HttpContext.Current.Response.ClearHeaders()
> HttpContext.Current.Response.ClearContent()
> HttpContext.Current.Response.ContentType = "text/html"
> HttpContext.Current.Response.AppendHeader("Content-Disposition", _
> "filename=""AddressLabels.HTM""")
> ' send the byte array containing the report as a binary response
> HttpContext.Current.Response.BinaryWrite(rptIRIS)
> HttpContext.Current.Response.End()
> Catch ex As Exception
> Finally
> End Try

Help - can't create or edit a Maintenance Plan

I noticed the following after changing the password for the SQL 2005 Service
Accounts.
- I could not longer edit or create Maintenance Plans.
- error returned 0x80004005 (Client unable to establish connection)
In the SQL error log I found
Server Microsoft SQL Server 2005 - 9.00.1399.06 (X64)
Oct 14 2005 00:35:21
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)
.
.
Server FallBack certificate initialization failed with error code: 1.
Server Warning:Encryption is not available, could not find a valid
certificate to load.
.
.
Logon The prelogin packet used to open the connection is structurally
invalid; the connection has been closed. Please contact the vendor of the
client library. [CLIENT: <local machine>]
Logon Error: 17828, Severity: 20, State: 3.
*** Note that SQL is running on
Windows Server 2003 R2 Standard x64 edition Service Pack 1
It is also a domain controller.
Any ideas?
ThanksHi,
I was having this exact same problem, here is what resolved this issue
for me:
1. Go to C:\Documents and Settings\"sql startup account"\Application
Data\Microsoft\Crypto\RSA\S-1-5-21.....
(where "sql startup account" should be the name of your startup account
for sql server")
2 Backup and then delete any files in the S-1-5-21etcetc folder. (but
don't delete the folder)
3. Restart SQL Server.
HTH.
BobT732 wrote:
> I noticed the following after changing the password for the SQL 2005 Service
> Accounts.
> - I could not longer edit or create Maintenance Plans.
> - error returned 0x80004005 (Client unable to establish connection)
> In the SQL error log I found
> Server Microsoft SQL Server 2005 - 9.00.1399.06 (X64)
> Oct 14 2005 00:35:21
> Copyright (c) 1988-2005 Microsoft Corporation
> Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)
> .
> .
> Server FallBack certificate initialization failed with error code: 1.
> Server Warning:Encryption is not available, could not find a valid
> certificate to load.
> .
> .
> Logon The prelogin packet used to open the connection is structurally
> invalid; the connection has been closed. Please contact the vendor of the
> client library. [CLIENT: <local machine>]
> Logon Error: 17828, Severity: 20, State: 3.
>
> *** Note that SQL is running on
> Windows Server 2003 R2 Standard x64 edition Service Pack 1
> It is also a domain controller.
> Any ideas?
> Thanks|||Yes that did it!
Thank You Very Much
"teefer22@.hotmail.com" wrote:
> Hi,
> I was having this exact same problem, here is what resolved this issue
> for me:
> 1. Go to C:\Documents and Settings\"sql startup account"\Application
> Data\Microsoft\Crypto\RSA\S-1-5-21.....
> (where "sql startup account" should be the name of your startup account
> for sql server")
> 2 Backup and then delete any files in the S-1-5-21etcetc folder. (but
> don't delete the folder)
> 3. Restart SQL Server.
> HTH.
>
> BobT732 wrote:
> > I noticed the following after changing the password for the SQL 2005 Service
> > Accounts.
> >
> > - I could not longer edit or create Maintenance Plans.
> > - error returned 0x80004005 (Client unable to establish connection)
> > In the SQL error log I found
> > Server Microsoft SQL Server 2005 - 9.00.1399.06 (X64)
> > Oct 14 2005 00:35:21
> > Copyright (c) 1988-2005 Microsoft Corporation
> > Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)
> > .
> > .
> > Server FallBack certificate initialization failed with error code: 1.
> > Server Warning:Encryption is not available, could not find a valid
> > certificate to load.
> > .
> > .
> > Logon The prelogin packet used to open the connection is structurally
> > invalid; the connection has been closed. Please contact the vendor of the
> > client library. [CLIENT: <local machine>]
> > Logon Error: 17828, Severity: 20, State: 3.
> >
> >
> > *** Note that SQL is running on
> > Windows Server 2003 R2 Standard x64 edition Service Pack 1
> >
> > It is also a domain controller.
> >
> > Any ideas?
> >
> > Thanks
>

Help

Hi
I am using Visual studio 2005 to write a web service. I am not able to
connect to database. I get the usual Named pipes provider error:could
not open a connection to the server. So I read up some material and
found out that I have to start the sqlbrowser service(using surface
area configuration manager) and create exceptions for the firewall for
the sqlexpress and sqlbrowser. I did all the things, still I get the
same error. However , when I add the datasource from the datasource
configuration wizard and test the connection, the test was succesfull.
Thanks in advance for the helpIt's best not to hijack a thread with a new topic -there is no certainty
anyone will see your post since they may think that the thread is complete.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"sunil" <sairaj.sunil@.gmail.com> wrote in message
news:1154953948.775714.18740@.p79g2000cwp.googlegroups.com...
> Hi
> I am using Visual studio 2005 to write a web service. I am not able to
> connect to database. I get the usual Named pipes provider error:could
> not open a connection to the server. So I read up some material and
> found out that I have to start the sqlbrowser service(using surface
> area configuration manager) and create exceptions for the firewall for
> the sqlexpress and sqlbrowser. I did all the things, still I get the
> same error. However , when I add the datasource from the datasource
> configuration wizard and test the connection, the test was succesfull.
> Thanks in advance for the help
>|||This may not actually be a case of hijacking. It may just be a case of using
a totally meaningless subject that the newsreader assumes is part of the
same thread with the same less-than-useful subject.
HTH
Kalen Delaney, SQL Server MVP
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:uKT6kAmuGHA.4748@.TK2MSFTNGP03.phx.gbl...
> It's best not to hijack a thread with a new topic -there is no certainty
> anyone will see your post since they may think that the thread is
> complete.
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> "sunil" <sairaj.sunil@.gmail.com> wrote in message
> news:1154953948.775714.18740@.p79g2000cwp.googlegroups.com...
>

Help

Hi
I am using Visual studio 2005 to write a web service. I am not able to
connect to database. I get the usual Named pipes provider error:could
not open a connection to the server. So I read up some material and
found out that I have to start the sqlbrowser service(using surface
area configuration manager) and create exceptions for the firewall for
the sqlexpress and sqlbrowser. I did all the things, still I get the
same error. However , when I add the datasource from the datasource
configuration wizard and test the connection, the test was succesfull.
Thanks in advance for the helpIt's best not to hijack a thread with a new topic -there is no certainty
anyone will see your post since they may think that the thread is complete.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"sunil" <sairaj.sunil@.gmail.com> wrote in message
news:1154953948.775714.18740@.p79g2000cwp.googlegroups.com...
> Hi
> I am using Visual studio 2005 to write a web service. I am not able to
> connect to database. I get the usual Named pipes provider error:could
> not open a connection to the server. So I read up some material and
> found out that I have to start the sqlbrowser service(using surface
> area configuration manager) and create exceptions for the firewall for
> the sqlexpress and sqlbrowser. I did all the things, still I get the
> same error. However , when I add the datasource from the datasource
> configuration wizard and test the connection, the test was succesfull.
> Thanks in advance for the help
>|||This may not actually be a case of hijacking. It may just be a case of using
a totally meaningless subject that the newsreader assumes is part of the
same thread with the same less-than-useful subject.
--
HTH
Kalen Delaney, SQL Server MVP
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:uKT6kAmuGHA.4748@.TK2MSFTNGP03.phx.gbl...
> It's best not to hijack a thread with a new topic -there is no certainty
> anyone will see your post since they may think that the thread is
> complete.
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> "sunil" <sairaj.sunil@.gmail.com> wrote in message
> news:1154953948.775714.18740@.p79g2000cwp.googlegroups.com...
>> Hi
>> I am using Visual studio 2005 to write a web service. I am not able to
>> connect to database. I get the usual Named pipes provider error:could
>> not open a connection to the server. So I read up some material and
>> found out that I have to start the sqlbrowser service(using surface
>> area configuration manager) and create exceptions for the firewall for
>> the sqlexpress and sqlbrowser. I did all the things, still I get the
>> same error. However , when I add the datasource from the datasource
>> configuration wizard and test the connection, the test was succesfull.
>> Thanks in advance for the help
>

HelloWorld_CLR not sending messages anymore...........

Hello,

Yesterday I made the HelloWorld_CLR sample work and figured today I would create a simple windows service to immulate its functionality. When this was not working I tried the sample again and it stopped working. I have tried several things and nothing has worked. Has anyone seen this before or have any ideas on how I can get it working again? I even tried removing SQL Server and its samples then reinstalling to give me a clean slate but that did not work. I did not make any changes to the software nor did I make any changes to the database however the sample did so I need to make sure I can fix this incase it happens in development not to mention I need to continue development.

The Client Queue is normally empty but sometimes has a request to two in it. The Server Queue has alot in it that are both Request and an unspecified type or has a URL for a type. I would paste it in but it takes too much space. Please let me know if you have any ideas because I am not sure what else to try.

Bellow is a sample of the output from running this sample.

Connecting to SQL Server instance
Connected to SQL Server instance

Transaction 1 begun
Dialog begun from service (HelloWorldClient) to service (HelloWorldService)
Message sent of type 'Request'
Transaction 1 committed

Transaction 2 begun
Waiting for Response....
No message received - Ending dialog with Error
Transaction 2 committed

Connection closed - exiting

Press Enter to Exit

Thanks,
Scott Allison...

Here is a good article from Remus on diagnosing Service Broker problems:

http://blogs.msdn.com/remusrusanu/archive/2005/12/20/506221.aspx

|||

Hello Rushi,

I checked out the link you sent in your reply. I am not if when he states profiler he means the SQL Server Profiler and I am not familiar with it. I will play with it some but if this will give me the needed information I was wondering if you could tell me more on how to setup the options correctly and how to use it to attach to the local machine.

Thanks,

Scott Allison...

|||

Before using the profiler, you should probably check what's in the transmission queue:

select * from sys.transmission_queue

Other places to look for errors is the Intiator and Target queues.

Rushi