Error when using SSL encryption for SQL server 2000

Hi,
I am having trouble connecting to SQL server 2000 using SSL.
My environment is as follows:
1. Microsoft Certificate server running on a Windows 2000 server machine.
2. SQL Server 2000 running on a Win NT machine with SP6 installed. SQL
Server service pack 3a has been installed.
3. Client machine running Windows XP with SQL Server service pack 3a
installed.
We use a type 4 JDBC secure driver to connect to SQL server from our Java ap
plication running on the client machine.
We also setup the certificate as described in the article 276553 - HOW TO: E
nable SSL Encryption for SQL Server 2000 with Certificate Server.
The installation of the certificate was successful. However, when I tried to
connect to the SQL server using SQL Query Analyzer, I received the followin
g error message.
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Encryption not supported on SQL Serv
er
Thanks,
Chacko.Usually, you receive that error if you enable SSL from the client and the
server doesn't have the certificate.
But, the bad news is you won't be able to use SSL with a type 4 Java driver.
The implementation of protocol encryption requires the driver to access
SSL. In
particular protocol encryption uses SSL APIs implemented in NT. Type 4 JDBC
drivers have a problem in that they are not allowed to directly call system
dlls. There is no library in Java 1.4 or below that emulates the protocol
encryption behavior of SSL from Windows NT.
If your JDBC application requires protocol encryption to SQL 2000,
you will have to use alternate method of encryption such as IPSEC or use a
suitable SSL enabled Type 3 JDBC Driver.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Hi Kevin,
Thanks for your response.
We did generate and install the certificate using the web browser and not us
ing MMC since it is a Win NT 4.0 box. When we look at the certificate on the
database server machine via the IE properties applet, the certificate shows
up fine as described in th
e Microsoft setup document. So, I am not sure where I am going wrong. Is the
re any way to trouble shoot this issue?
Also, we are not even trying the connectivity with the type 4 JDBC driver ye
t even though that is what we want to do ultimately. However, right now we a
re using Query Analyzer on the client machine to test the communication. We
get the error when we try a
nd login to the database via Query Analyzer.
About the type 4 JDBC driver, the documentation from i-net OPTA type 4 JDBC driver says
that it supports SSL for SQL Server 2000. Am I misunderstanding something here? You ca
n find information about i-net OPTA at [url]http://www.inetsoftware.de/English/Produkt[
/url]
e/OPTA/default.htm
Your thoughts are greatly appreciated.
Thanks Kevin.
Chacko.

Error when using 'LIKE'

I am running the following query using Query Analyzer against an MSDE version. The query seems like a textbook use of 'LIKE', so the error makes to sense to me. Thanks for any help.

SELECT _FAX

FROM _IRISH_BNB_DETAILS

WHERE _FAX LIKE "[A-Z]%"

Error:

Server: Msg 207, Level 16, State 3, Line 1

Invalid column name '[A-Z]%'.

Try executing:

SET QUOTED_IDENTIFIER OFF

Dave

|||

In SQL, use the single quote character to delimit strings, so:

LIKE '[A-Z]%'

instead of

LIKE "[A-Z]%"

Double quotes are used to allow for quoted identifiers, so it is thinking that "[A-Z]%" is a column name

|||

Thank you!

I was following an example in "SQL Server 2000 Administrator Companion" on page 309 that uses double quotes.

|||

Sorry, my answer is too short. Try this:

SET QUOTED_IDENTIFIER OFF

SELECT _FAX
FROM _IRISH_BNB_DETAILS
WHERE _FAX LIKE "[A-Z]%"

SET QUOTED_IDENTIFIER ON

and then try this:

SELECT _FAX
FROM _IRISH_BNB_DETAILS
WHERE _FAX LIKE '[A-Z]%'

You are really better changing your literal, that is "[A-Z]%" into a single quote delimited literal for the sake of ANSI compliance; however, an alternative is to set QUOTED_IDENTIFIER on so that the original code can work as is.

Dave

|||Yeah, Louis answered before I could correct myself. Sorry about that.|||Yeah, and you answered while I was answering :)|||

Hey, it was a typing war! You won!

:-)

Error when trying to log in to SQL server

I've just finished developing a web app, which works fine on my PC, running IIS locally. It uses windows authentication and a trusted connection to retrieve data from SQL server. So far so routine. When I deploy the app to my live server, it returns the error:

Login failed for user '\'

The stack trace seems to indicate that it's at the point where the app tries to retrieve data that the error occurs. I proved this by changing my connection string to explicitly define the log on, and it retrieved the data no problem.

I set up a very simple webform with a label on, to return what it thought the user's log on name was, and it returns the correct name.

Any ideas as to why the username isn't being correctly passed to SQL server?Have you made sure the Web Account is a valid user of the SQL Server? If the IIS box and the SQL box are different you have to ensure the user has network rights too.|||Yes, the user (me!) definitely has rights on the SQL server. How come it works locally on my PC, but not on the server?

What network rights do you think I should investigate?

Thanks.|||Sorry I mis-read your original post, I didn't notice that your site was using NT Authentication. So here is my mental checklist:
1. Web Server has access to the Domain server to authenticate the user
2. The Web Server isn't the Domain Server
3. SQL Server security logins knows about the Windows user/user group
4. The SQL Database knows about the Windows user/user group

I mentioned the network security because when you use anon web access the user must have network access to go across machines. That "shouldn't" be an issue here.

Also run SQL Profiler to see if the user is getting set to SQL and then going wrong. Sounds more like its a problem on the web server though, something wrong with the impersonation.|||I'm positive that the user is being authenticated properly on the app, because when I load a simple page with a label which displays the user name, it displays correctly. For some reason this user name isn't getting passed to SQL server correctly.

I tried deploying the application to the box which has the SQL server running, and gess what? It worked. So does this mean that the first box can't access the domain server? Any idea how I can check that?

I'll have a think, and let you know how I get on.

Cheers.|||Hang on, just cause you're using Web Authentication doesn't mean it will impersonate the user onto SQL Server. Do you set the principal security when the user connects?

Check out:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/SecNetch03.asp

Error when trying to deploy report

Hi,
I'm running Reporting Services 2000 SP1. Everytime I try and deploy a report
to our reporting server I get the following error:
"A connection could not be made to the report server
http://sqlreportserver/ReportServer"
I can browse to the Report Manager and view reports. I am also able to debug
reports in VS.NET 2003. I've double checked the TargetFolder and
TargetServerURL in the project properties.
I am on a different domain than the report server. Could this be why I am
unable to deploy? If so, does anybody know how I can work around this.
Thanks
John a.k.a.HansHi again,
I'm still having problems with this. If anyone could give me a few pointers
that would be much appreciated.
Thanks
J
"Hans Gruber" wrote:
> Hi,
> I'm running Reporting Services 2000 SP1. Everytime I try and deploy a report
> to our reporting server I get the following error:
> "A connection could not be made to the report server
> http://sqlreportserver/ReportServer"
> I can browse to the Report Manager and view reports. I am also able to debug
> reports in VS.NET 2003. I've double checked the TargetFolder and
> TargetServerURL in the project properties.
> I am on a different domain than the report server. Could this be why I am
> unable to deploy? If so, does anybody know how I can work around this.
> Thanks
> John a.k.a.Hans
>|||OK. I've made some progress. Hopefully this may help other people with the
same problem.
1) In IE. Tools --> Internet Options --> Connections --> LAN Settings.
Uncheck the 'Use a proxy server for your LAN (These.....' box.
2) Restart VS.NET 2003
3) I can now deploy reports.
Still frustrating because my colleague does not have to uncheck this box in
order to deploy...so any pointers would be much appreciated.
J
> > Hi,
> >
> > I'm running Reporting Services 2000 SP1. Everytime I try and deploy a report
> > to our reporting server I get the following error:
> >
> > "A connection could not be made to the report server
> > http://sqlreportserver/ReportServer"
> >
> > I can browse to the Report Manager and view reports. I am also able to debug
> > reports in VS.NET 2003. I've double checked the TargetFolder and
> > TargetServerURL in the project properties.
> >
> > I am on a different domain than the report server. Could this be why I am
> > unable to deploy? If so, does anybody know how I can work around this.
> >
> > Thanks
> > John a.k.a.Hans
> >
> >

Error when trying to create "datasources"

Brand new at this !

I'm running VB 2005 express edition installed from full MS download which included the SQL2005 express server V9.00.1116

Have used the Video tutorial (video 8 & 9) to create a database and have followed instructiions faithfully

Problem.

From the Data / Add New Datasource menu everything proceeds ok - that is a "dataset.xsd" file is created but then I get an error message

" Could not get type information for .........myfilename dataset "

and so the process is not completed properly and a datasource is not created.

I'm unsure what the type information is and have been unsuccesful turning up anything from the help files or forum so hoping someone can maybe tell me whats happening and how to fix this.

Thanks

I also ran into this problem and got it solved by removing the connection strings in 'My Project - Settings'. I hope this also works for you.

Harmen.|||

Thanks for that idea

For the record had trouble removing strings however -

My problems have been solved by accident when I created a new windows user account and ran VB express from there. I believe the problem was to do with the connection address because my system name has an " & " in the name(stupid me when I set up Windows XP ) the ampersand maybe an illegal character in a path name.

Here's the full path i used

Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Documents and Settings\TB&MA\My Documents\Visual Studio 2005\Projects\MyDataBase\MyDataBase\Database1.mdf";Integrated Security=True;User Instance=True

I think this why running it from a new user account worked ok as the connection string would have new directory path name

Thanks again

sql

Error when trying to create "datasources"

Brand new at this !

I'm running VB 2005 express edition installed from full MS download which included the SQL2005 express server V9.00.1116

Have used the Video tutorial (video 8 & 9) to create a database and have followed instructiions faithfully

Problem.

From the Data / Add New Datasource menu everything proceeds ok - that is a "dataset.xsd" file is created but then I get an error message

" Could not get type information for .........myfilename dataset "

and so the process is not completed properly and a datasource is not created.

I'm unsure what the type information is and have been unsuccesful turning up anything from the help files or forum so hoping someone can maybe tell me whats happening and how to fix this.

Thanks

I also ran into this problem and got it solved by removing the connection strings in 'My Project - Settings'. I hope this also works for you.

Harmen.
|||

Thanks for that idea

For the record had trouble removing strings however -

My problems have been solved by accident when I created a new windows user account and ran VB express from there. I believe the problem was to do with the connection address because my system name has an " & " in the name(stupid me when I set up Windows XP ) the ampersand maybe an illegal character in a path name.

Here's the full path i used

Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Documents and Settings\TB&MA\My Documents\Visual Studio 2005\Projects\MyDataBase\MyDataBase\Database1.mdf";Integrated Security=True;User Instance=True

I think this why running it from a new user account worked ok as the connection string would have new directory path name

Thanks again

Error when running Tuning advisor

When I try to launch the tuning advisor, I get this error - Any help will be much appriciated.

===================================

Failed to connect to an IPC Port: The system cannot find the file specified.
(mscorlib)

Program Location:

Server stack trace:
at System.Runtime.Remoting.Channels.Ipc.IpcPort.Connect(String portName, Boolean secure, TokenImpersonationLevel impersonationLevel, Int32 timeout)
at System.Runtime.Remoting.Channels.Ipc.ConnectionCache.GetConnection(String portName, Boolean secure, TokenImpersonationLevel level, Int32 timeout)
at System.Runtime.Remoting.Channels.Ipc.IpcClientTransportSink.ProcessMessage(IMessage msg, ITransportHeaders requestHeaders, Stream requestStream, ITransportHeaders& responseHeaders, Stream& responseStream)
at System.Runtime.Remoting.Channels.BinaryClientFormatterSink.SyncProcessMessage(IMessage msg)

Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at Microsoft.SqlServer.Management.UI.VSIntegration.ISessionController.CreateSessionFromQuery(SqlConnectionInfo connectionInfo, String sqlQuery, String batchSeparator)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.SqlScriptEditorControl.OnDatabaseTuningAdvisor(Object sender, EventArgs a)

What is the service pack level on SQL Server?

Any recent changes to the server and client machine you are using, such as automatic updates?

|||Hi,

I had got the same error when I tried to tune my query.

However after I click "OK" button of the Error message, in few seconds the "Tuning Adviser" window opens but it is not connected to the session of the query editor (in which the query was executed).

Now without closing this tuning adviser window, if I again click on Analyser button, the analyser opens fine and the query is also tunned properly.

Let me know if this works for you too.

Regards,

Shweta

error when running the DTSRUN command

Hi
We're using SqlServer 2000.

I want to run a DTS using the DTSRUN command.
The commmand is inside a ".bat" file which my application is running
from an SQL client.
No matter how I run it from the client it fails giving me the message:

[ConnectionOpen (Connect()).]SQL Server does not exist or access denied

I've tried to run it from the client from the application, from the
command prompt and it fails.
I went into enterprise on the client and tried to run the DTS from
there. The run failed already on the 1st step which is a call to a
stored procedure, also giving me the same message. This really stuck me
as wierd because in enterprise I'm accessing the server successfully so
why the above messgae. It identifies the server and I am accessing it.

Because it failed on the 1st step which is a call to a stored procedure
I tried running the sp from within query analyzer and it succeeded.

Has anyone got any idea what the problem is and ghow to solve it.

Thanks !

David GreenbergDavid Greenberg (davidgr@.iba.org.il) writes:

Quote:

Originally Posted by

I want to run a DTS using the DTSRUN command.
The commmand is inside a ".bat" file which my application is running
from an SQL client.
No matter how I run it from the client it fails giving me the message:
>
[ConnectionOpen (Connect()).]SQL Server does not exist or access denied
>
I've tried to run it from the client from the application, from the
command prompt and it fails.
I went into enterprise on the client and tried to run the DTS from
there. The run failed already on the 1st step which is a call to a
stored procedure, also giving me the same message. This really stuck me
as wierd because in enterprise I'm accessing the server successfully so
why the above messgae. It identifies the server and I am accessing it.
>
Because it failed on the 1st step which is a call to a stored procedure
I tried running the sp from within query analyzer and it succeeded.
>
Has anyone got any idea what the problem is and ghow to solve it.

You can't accuse me to know too much about DTS, but I see that a
DTS package has connection properties. I would assume that you can
have a package on server A, and run it against server B.

So I would check the connection properties of the package (or the step,
as different task surely must be able to connect to different servers).

The error message simply means that you are trying to connect to a
server that is not available. (Not running, misspelled, a firewall
in the way etc.)

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

error when running SSIS package as a job

I am running into an error when running a package using a scheduled job under SQL Server Agent account. I am getting following error:

Date 6/12/2007 4:19:15 PM
Log Job History (VistaODSFeed)

Step ID 0
Server 006-DEVSQL2005
Job Name VistaODSFeed
Step Name (Job outcome)
Duration 00:00:00
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
The job failed. Unable to determine if the owner (ACI\snasir) of job VistaODSFeed has server access (reason: Could not obtain information about Windows NT group/user 'ACI\snasir', error code 0x6ba. [SQLSTATE 42000] (Error 15404)).

ACI\snasir is not the account under which SQL Server Agent service runs. However ACI\snasir has sa priveleges. not sure why am I getting ACI\snasir in the error and not the account under which sql server agent runs.

ideas?

Hi Shahab,

Is ACI\snasir hard-coded as the username in any of the connection managers?

Andy

Error when running SQL Job

I get an Event ID: 40961 when running a job in SQL the error message is as follows;
The Security System could not establish a secured connection with the server MSSQLSvc/PTISERV.Pinnacle.PTI:1433. No authentication protocol was available.
The job is run on another server and is trying to hit the server listed above.
There are a few related knowledge base articles and several
reasons for the error listed at this site:
http://www.eventid.net/display.asp?e...aS rv&phase=1
-Sue
On Tue, 18 May 2004 04:46:04 -0700, "JZanone"
<anonymous@.discussions.microsoft.com> wrote:

>I get an Event ID: 40961 when running a job in SQL the error message is as follows;
>The Security System could not establish a secured connection with the server MSSQLSvc/PTISERV.Pinnacle.PTI:1433. No authentication protocol was available.
>The job is run on another server and is trying to hit the server listed above.

Error when running SQL Job

I get an Event ID: 40961 when running a job in SQL the error message is as f
ollows;
The Security System could not establish a secured connection with the server
MSSQLSvc/PTISERV.Pinnacle.PTI:1433. No authentication protocol was availab
le.
The job is run on another server and is trying to hit the server listed abov
e.There are a few related knowledge base articles and several
reasons for the error listed at this site:
1" target="_blank">http://www.eventid.net/display.asp?...phase=
1
-Sue
On Tue, 18 May 2004 04:46:04 -0700, "JZanone"
<anonymous@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>I get an Event ID: 40961 when running a job in SQL the error message is as
follows;
>The Security System could not establish a secured connection with the serve
r MSSQLSvc/PTISERV.Pinnacle.PTI:1433. No authentication protocol was availa
ble.
>The job is run on another server and is trying to hit the server listed above.[/vbc
ol]sql

Error when running SQL Job

I get an Event ID: 40961 when running a job in SQL the error message is as follows
The Security System could not establish a secured connection with the server MSSQLSvc/PTISERV.Pinnacle.PTI:1433. No authentication protocol was available
The job is run on another server and is trying to hit the server listed above.There are a few related knowledge base articles and several
reasons for the error listed at this site:
http://www.eventid.net/display.asp?eventid=40961&eventno=1398&source=LsaSrv&phase=1
-Sue
On Tue, 18 May 2004 04:46:04 -0700, "JZanone"
<anonymous@.discussions.microsoft.com> wrote:
>I get an Event ID: 40961 when running a job in SQL the error message is as follows;
>The Security System could not establish a secured connection with the server MSSQLSvc/PTISERV.Pinnacle.PTI:1433. No authentication protocol was available.
>The job is run on another server and is trying to hit the server listed above.

Error when running sp_helpdb query

I get the following error when running command "sp_helpdb" in Query Analyzer.
Server: Msg 515, Level 16, State 2, Procedure sp_helpdb, Line 53 Cannot
insert the value NULL into column 'owner', table
'tempdb.dbo.#spdbdesc___________________________________________________________________________________________________________000100371F02';
column does not allow nulls. INSERT fails.
The statement has been terminated.Kush
use master
go
sp_helptext 'sp_helpdb'
I think it fails to find suser_sname of the current session
"Kush" <Kush@.discussions.microsoft.com> wrote in message
news:44DAF4E9-9DCA-47FC-85A3-79234F68EFF3@.microsoft.com...
>I get the following error when running command "sp_helpdb" in Query
>Analyzer.
> Server: Msg 515, Level 16, State 2, Procedure sp_helpdb, Line 53 Cannot
> insert the value NULL into column 'owner', table
> 'tempdb.dbo.#spdbdesc___________________________________________________________________________________________________________000100371F02';
> column does not allow nulls. INSERT fails.
> The statement has been terminated.|||Here's an URL that might explain it. Google is your friend :-)
http://groups.google.com/group/microsoft.public.sqlserver.server/browse_thread/thread/bc6f4659bb8dd60c/50f0170456dd13b5?q=sp_helpdb+insert+NULL&rnum=3#50f0170456dd13b5
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Kush" <Kush@.discussions.microsoft.com> wrote in message
news:44DAF4E9-9DCA-47FC-85A3-79234F68EFF3@.microsoft.com...
>I get the following error when running command "sp_helpdb" in Query Analyzer.
> Server: Msg 515, Level 16, State 2, Procedure sp_helpdb, Line 53 Cannot
> insert the value NULL into column 'owner', table
> 'tempdb.dbo.#spdbdesc___________________________________________________________________________________________________________000100371F02';
> column does not allow nulls. INSERT fails.
> The statement has been terminated.|||I will try that and let you know what happens!
"Tibor Karaszi" wrote:
> Here's an URL that might explain it. Google is your friend :-)
> http://groups.google.com/group/microsoft.public.sqlserver.server/browse_thread/thread/bc6f4659bb8dd60c/50f0170456dd13b5?q=sp_helpdb+insert+NULL&rnum=3#50f0170456dd13b5
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Kush" <Kush@.discussions.microsoft.com> wrote in message
> news:44DAF4E9-9DCA-47FC-85A3-79234F68EFF3@.microsoft.com...
> >I get the following error when running command "sp_helpdb" in Query Analyzer.
> >
> > Server: Msg 515, Level 16, State 2, Procedure sp_helpdb, Line 53 Cannot
> > insert the value NULL into column 'owner', table
> > 'tempdb.dbo.#spdbdesc___________________________________________________________________________________________________________000100371F02';
> > column does not allow nulls. INSERT fails.
> > The statement has been terminated.
>

Error when running sp_helpdb query

Kush
use master
go
sp_helptext 'sp_helpdb'
I think it fails to find suser_sname of the current session
"Kush" <Kush@.discussions.microsoft.com> wrote in message
news:44DAF4E9-9DCA-47FC-85A3-79234F68EFF3@.microsoft.com...
>I get the following error when running command "sp_helpdb" in Query
>Analyzer.
> Server: Msg 515, Level 16, State 2, Procedure sp_helpdb, Line 53 Cannot
> insert the value NULL into column 'owner', table
> 'tempdb.dbo. #spdbdesc_______________________________
______________________
________________________________________
______________000100371F02';
> column does not allow nulls. INSERT fails.
> The statement has been terminated.I get the following error when running command "sp_helpdb" in Query Analyzer
.
Server: Msg 515, Level 16, State 2, Procedure sp_helpdb, Line 53 Cannot
insert the value NULL into column 'owner', table
'tempdb.dbo. #spdbdesc_______________________________
________________________
________________________________________
____________000100371F02';
column does not allow nulls. INSERT fails.
The statement has been terminated.|||Kush
use master
go
sp_helptext 'sp_helpdb'
I think it fails to find suser_sname of the current session
"Kush" <Kush@.discussions.microsoft.com> wrote in message
news:44DAF4E9-9DCA-47FC-85A3-79234F68EFF3@.microsoft.com...
>I get the following error when running command "sp_helpdb" in Query
>Analyzer.
> Server: Msg 515, Level 16, State 2, Procedure sp_helpdb, Line 53 Cannot
> insert the value NULL into column 'owner', table
> 'tempdb.dbo. #spdbdesc_______________________________
______________________
________________________________________
______________000100371F02';
> column does not allow nulls. INSERT fails.
> The statement has been terminated.|||Here's an URL that might explain it. Google is your friend :-)
3b5" target="_blank">http://groups.google.com/group/micr...6dd1
3b5
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Kush" <Kush@.discussions.microsoft.com> wrote in message
news:44DAF4E9-9DCA-47FC-85A3-79234F68EFF3@.microsoft.com...
>I get the following error when running command "sp_helpdb" in Query Analyze
r.
> Server: Msg 515, Level 16, State 2, Procedure sp_helpdb, Line 53 Cannot
> insert the value NULL into column 'owner', table
> 'tempdb.dbo. #spdbdesc_______________________________
______________________
________________________________________
______________000100371F02';
> column does not allow nulls. INSERT fails.
> The statement has been terminated.|||I will try that and let you know what happens!
"Tibor Karaszi" wrote:

> Here's an URL that might explain it. Google is your friend :-)
> d13b5" target="_blank">http://groups.google.com/group/micr...6d
d13b5
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Kush" <Kush@.discussions.microsoft.com> wrote in message
> news:44DAF4E9-9DCA-47FC-85A3-79234F68EFF3@.microsoft.com...
>|||Here's an URL that might explain it. Google is your friend :-)
3b5" target="_blank">http://groups.google.com/group/micr...6dd1
3b5
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Kush" <Kush@.discussions.microsoft.com> wrote in message
news:44DAF4E9-9DCA-47FC-85A3-79234F68EFF3@.microsoft.com...
>I get the following error when running command "sp_helpdb" in Query Analyze
r.
> Server: Msg 515, Level 16, State 2, Procedure sp_helpdb, Line 53 Cannot
> insert the value NULL into column 'owner', table
> 'tempdb.dbo. #spdbdesc_______________________________
______________________
________________________________________
______________000100371F02';
> column does not allow nulls. INSERT fails.
> The statement has been terminated.|||I will try that and let you know what happens!
"Tibor Karaszi" wrote:

> Here's an URL that might explain it. Google is your friend :-)
> d13b5" target="_blank">http://groups.google.com/group/micr...6d
d13b5
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Kush" <Kush@.discussions.microsoft.com> wrote in message
> news:44DAF4E9-9DCA-47FC-85A3-79234F68EFF3@.microsoft.com...
>

Error when running Snapshot Agent

David,
can you have a look at the list of processes and see if
the snapshot.exe is listed, then kill it if it is.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
No - definitely no snapshot.exe.
"Paul Ibison" wrote:

> David,
> can you have a look at the list of processes and see if
> the snapshot.exe is listed, then kill it if it is.
> HTH,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||David,
have a look at sp_removedbreplication, which should
remove any lingering system table traces. Have a look for
any orphaned jobs which are running the snapshot agent.
Also, consider restarting the sql server service.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||An update on this issue:
I disabled replication and distribution on the publisher and distributor
(respectivley) started again.
I was able to start the snapshot agent.
I then received a different error from the snapshot agent:
Invalid object name: syspublications.
Still stuck on this error though.
"Paul Ibison" wrote:

> David,
> have a look at sp_removedbreplication, which should
> remove any lingering system table traces. Have a look for
> any orphaned jobs which are running the snapshot agent.
> Also, consider restarting the sql server service.
> HTH,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
>

error when running reports

Hi all
Has anyone seen the following error - cannot run any reports - start then
crashes
Reporting Services Error
----
a.. An internal error occurred on the report server. See the error log for
more details. (rsInternalError) Get Online Help
a.. Invalid object name 'ReportServerTempDB.dbo.ExecutionCache'.
----
Microsoft Reporting Services
PeterThere seems to be a corruption with your temp DB. First check to see if
there is a ReportServerTempDB database. If so then check for the
ExecutionCache table, if it exist make sure the owner is dbo. If the DB
does not exist you can run the CatalogTempDB.sql script to create it. Make
sure to first create the DB as ReportServerTempDB and then create a Role
called RSExecRole, then you can run the script. You will also need to make
sure all the users that are in the RSExecRole in the ReportServer Database
are in the ReportServerTempDB's RSExecRole.
I hope that helps.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Pete" <p0911@.hotmail.com> wrote in message
news:%23TjeE%236%23FHA.532@.TK2MSFTNGP15.phx.gbl...
> Hi all
> Has anyone seen the following error - cannot run any reports - start
> then crashes
> Reporting Services Error
> ----
> a.. An internal error occurred on the report server. See the error log
> for more details. (rsInternalError) Get Online Help
> a.. Invalid object name 'ReportServerTempDB.dbo.ExecutionCache'.
> ----
> Microsoft Reporting Services
>
> Peter
>|||Daniel
Thank you for your suggestions - I will try them out and post back
Pete
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:e9lgNFC$FHA.3992@.TK2MSFTNGP15.phx.gbl...
> There seems to be a corruption with your temp DB. First check to see if
> there is a ReportServerTempDB database. If so then check for the
> ExecutionCache table, if it exist make sure the owner is dbo. If the DB
> does not exist you can run the CatalogTempDB.sql script to create it.
> Make sure to first create the DB as ReportServerTempDB and then create a
> Role called RSExecRole, then you can run the script. You will also need
> to make sure all the users that are in the RSExecRole in the ReportServer
> Database are in the ReportServerTempDB's RSExecRole.
>
> I hope that helps.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Pete" <p0911@.hotmail.com> wrote in message
> news:%23TjeE%236%23FHA.532@.TK2MSFTNGP15.phx.gbl...
>> Hi all
>> Has anyone seen the following error - cannot run any reports - start
>> then crashes
>> Reporting Services Error
>> ----
>> a.. An internal error occurred on the report server. See the error log
>> for more details. (rsInternalError) Get Online Help
>> a.. Invalid object name 'ReportServerTempDB.dbo.ExecutionCache'.
>> ----
>> Microsoft Reporting Services
>>
>> Peter
>|||Daniel
Tried your suggestions - DB was missing - created , added user , added
role , ran script - all seemed to run ok - thought I was home
However I now get this and can't seem to find where to fix it
Reporting Services Error
----
a.. An internal error occurred on the report server. See the error log for
more details. (rsInternalError) Get Online Help
a.. Cannot resolve collation conflict for equal to operation.
----
Microsoft Reporting Services
Also , there appears o be multiple scripts for Service packs etc where the
create script is - any idea what order to run them if necessary - I had
installed SSRS SP2 initially
Thank you
Pete
"Pete" <p0911@.hotmail.com> wrote in message
news:utAoZyD$FHA.912@.TK2MSFTNGP11.phx.gbl...
> Daniel
> Thank you for your suggestions - I will try them out and post back
> Pete
>
> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
> news:e9lgNFC$FHA.3992@.TK2MSFTNGP15.phx.gbl...
>> There seems to be a corruption with your temp DB. First check to see if
>> there is a ReportServerTempDB database. If so then check for the
>> ExecutionCache table, if it exist make sure the owner is dbo. If the DB
>> does not exist you can run the CatalogTempDB.sql script to create it.
>> Make sure to first create the DB as ReportServerTempDB and then create a
>> Role called RSExecRole, then you can run the script. You will also need
>> to make sure all the users that are in the RSExecRole in the ReportServer
>> Database are in the ReportServerTempDB's RSExecRole.
>>
>> I hope that helps.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Pete" <p0911@.hotmail.com> wrote in message
>> news:%23TjeE%236%23FHA.532@.TK2MSFTNGP15.phx.gbl...
>> Hi all
>> Has anyone seen the following error - cannot run any reports - start
>> then crashes
>> Reporting Services Error
>> ----
>> a.. An internal error occurred on the report server. See the error log
>> for more details. (rsInternalError) Get Online Help
>> a.. Invalid object name 'ReportServerTempDB.dbo.ExecutionCache'.
>> ----
>> Microsoft Reporting Services
>>
>> Peter
>>
>|||Where do you see this error? When running a report or in the log files?
You only need to run the catalogtemp.sql script, non of the upgrade scripts.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Pete" <p0911@.hotmail.com> wrote in message
news:%23BJiSYE$FHA.2420@.TK2MSFTNGP12.phx.gbl...
> Daniel
> Tried your suggestions - DB was missing - created , added user , added
> role , ran script - all seemed to run ok - thought I was home
> However I now get this and can't seem to find where to fix it
> Reporting Services Error
> ----
> a.. An internal error occurred on the report server. See the error log
> for more details. (rsInternalError) Get Online Help
> a.. Cannot resolve collation conflict for equal to operation.
> ----
> Microsoft Reporting Services
>
> Also , there appears o be multiple scripts for Service packs etc where the
> create script is - any idea what order to run them if necessary - I had
> installed SSRS SP2 initially
> Thank you
> Pete
>
> "Pete" <p0911@.hotmail.com> wrote in message
> news:utAoZyD$FHA.912@.TK2MSFTNGP11.phx.gbl...
>> Daniel
>> Thank you for your suggestions - I will try them out and post back
>> Pete
>>
>> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
>> news:e9lgNFC$FHA.3992@.TK2MSFTNGP15.phx.gbl...
>> There seems to be a corruption with your temp DB. First check to see if
>> there is a ReportServerTempDB database. If so then check for the
>> ExecutionCache table, if it exist make sure the owner is dbo. If the DB
>> does not exist you can run the CatalogTempDB.sql script to create it.
>> Make sure to first create the DB as ReportServerTempDB and then create a
>> Role called RSExecRole, then you can run the script. You will also need
>> to make sure all the users that are in the RSExecRole in the
>> ReportServer Database are in the ReportServerTempDB's RSExecRole.
>>
>> I hope that helps.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Pete" <p0911@.hotmail.com> wrote in message
>> news:%23TjeE%236%23FHA.532@.TK2MSFTNGP15.phx.gbl...
>> Hi all
>> Has anyone seen the following error - cannot run any reports - start
>> then crashes
>> Reporting Services Error
>> ----
>> a.. An internal error occurred on the report server. See the error log
>> for more details. (rsInternalError) Get Online Help
>> a.. Invalid object name 'ReportServerTempDB.dbo.ExecutionCache'.
>> ----
>> Microsoft Reporting Services
>>
>> Peter
>>
>>
>|||Daniel
It happens when I run a report from Report Manager (or from within
RM3.0) - it starts off ok (view report) and then come up with this error -
If I create a new report in Visual Studio and run preview from there
everything is fine !!! - if I then import this into ReportManager and try to
run it comes up with this error - along with all the other reports currently
in ReportManager
Everything was working fine until the other day and as far as I know I've
done nothing to the server (don't even touch it) although we did have a
power outage when I wasn't here and the UPS expired - don't even know how
the TempDb went missing ( ps I'm the only one who uses the system - it is
my dev network etc )
I thought the collating seq may have been wrong so I checked with a VPC that
works and changed it to the same as the Report Server
Latin1_General_CI_Ai_KS_WS but made no difference
This box is SBS 2003 with SQL 2000 plus MS CRM 3.0 plus SSRS 2000 plus SP2
plus Visual Studio 2003
Peter
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:uS%23qQdE$FHA.984@.tk2msftngp13.phx.gbl...
> Where do you see this error? When running a report or in the log files?
> You only need to run the catalogtemp.sql script, non of the upgrade
> scripts.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Pete" <p0911@.hotmail.com> wrote in message
> news:%23BJiSYE$FHA.2420@.TK2MSFTNGP12.phx.gbl...
>> Daniel
>> Tried your suggestions - DB was missing - created , added user , added
>> role , ran script - all seemed to run ok - thought I was home
>> However I now get this and can't seem to find where to fix it
>> Reporting Services Error
>> ----
>> a.. An internal error occurred on the report server. See the error log
>> for more details. (rsInternalError) Get Online Help
>> a.. Cannot resolve collation conflict for equal to operation.
>> ----
>> Microsoft Reporting Services
>>
>> Also , there appears o be multiple scripts for Service packs etc where
>> the create script is - any idea what order to run them if necessary - I
>> had installed SSRS SP2 initially
>> Thank you
>> Pete
>>
>> "Pete" <p0911@.hotmail.com> wrote in message
>> news:utAoZyD$FHA.912@.TK2MSFTNGP11.phx.gbl...
>> Daniel
>> Thank you for your suggestions - I will try them out and post back
>> Pete
>>
>> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
>> news:e9lgNFC$FHA.3992@.TK2MSFTNGP15.phx.gbl...
>> There seems to be a corruption with your temp DB. First check to see
>> if there is a ReportServerTempDB database. If so then check for the
>> ExecutionCache table, if it exist make sure the owner is dbo. If the
>> DB does not exist you can run the CatalogTempDB.sql script to create
>> it. Make sure to first create the DB as ReportServerTempDB and then
>> create a Role called RSExecRole, then you can run the script. You will
>> also need to make sure all the users that are in the RSExecRole in the
>> ReportServer Database are in the ReportServerTempDB's RSExecRole.
>>
>> I hope that helps.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Pete" <p0911@.hotmail.com> wrote in message
>> news:%23TjeE%236%23FHA.532@.TK2MSFTNGP15.phx.gbl...
>> Hi all
>> Has anyone seen the following error - cannot run any reports -
>> start then crashes
>> Reporting Services Error
>> ----
>> a.. An internal error occurred on the report server. See the error
>> log for more details. (rsInternalError) Get Online Help
>> a.. Invalid object name 'ReportServerTempDB.dbo.ExecutionCache'.
>> ----
>> Microsoft Reporting Services
>>
>> Peter
>>
>>
>>
>|||Do the log files have more of a call stack? Perhaps that will lead us to
where the problem is occurring.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Pete" <p0911@.hotmail.com> wrote in message
news:O$HJsEF$FHA.3800@.TK2MSFTNGP10.phx.gbl...
> Daniel
> It happens when I run a report from Report Manager (or from within
> M3.0) - it starts off ok (view report) and then come up with this
> error - If I create a new report in Visual Studio and run preview from
> there everything is fine !!! - if I then import this into ReportManager
> and try to run it comes up with this error - along with all the other
> reports currently in ReportManager
> Everything was working fine until the other day and as far as I know I've
> done nothing to the server (don't even touch it) although we did have a
> power outage when I wasn't here and the UPS expired - don't even know
> how the TempDb went missing ( ps I'm the only one who uses the system -
> it is my dev network etc )
> I thought the collating seq may have been wrong so I checked with a VPC
> that works and changed it to the same as the Report Server
> Latin1_General_CI_Ai_KS_WS but made no difference
> This box is SBS 2003 with SQL 2000 plus MS CRM 3.0 plus SSRS 2000 plus SP2
> plus Visual Studio 2003
> Peter
>
> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
> news:uS%23qQdE$FHA.984@.tk2msftngp13.phx.gbl...
>> Where do you see this error? When running a report or in the log files?
>> You only need to run the catalogtemp.sql script, non of the upgrade
>> scripts.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Pete" <p0911@.hotmail.com> wrote in message
>> news:%23BJiSYE$FHA.2420@.TK2MSFTNGP12.phx.gbl...
>> Daniel
>> Tried your suggestions - DB was missing - created , added user , added
>> role , ran script - all seemed to run ok - thought I was home
>> However I now get this and can't seem to find where to fix it
>> Reporting Services Error
>> ----
>> a.. An internal error occurred on the report server. See the error log
>> for more details. (rsInternalError) Get Online Help
>> a.. Cannot resolve collation conflict for equal to operation.
>> ----
>> Microsoft Reporting Services
>>
>> Also , there appears o be multiple scripts for Service packs etc where
>> the create script is - any idea what order to run them if necessary -
>> I had installed SSRS SP2 initially
>> Thank you
>> Pete
>>
>> "Pete" <p0911@.hotmail.com> wrote in message
>> news:utAoZyD$FHA.912@.TK2MSFTNGP11.phx.gbl...
>> Daniel
>> Thank you for your suggestions - I will try them out and post back
>> Pete
>>
>> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
>> news:e9lgNFC$FHA.3992@.TK2MSFTNGP15.phx.gbl...
>> There seems to be a corruption with your temp DB. First check to see
>> if there is a ReportServerTempDB database. If so then check for the
>> ExecutionCache table, if it exist make sure the owner is dbo. If the
>> DB does not exist you can run the CatalogTempDB.sql script to create
>> it. Make sure to first create the DB as ReportServerTempDB and then
>> create a Role called RSExecRole, then you can run the script. You
>> will also need to make sure all the users that are in the RSExecRole
>> in the ReportServer Database are in the ReportServerTempDB's
>> RSExecRole.
>>
>> I hope that helps.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Pete" <p0911@.hotmail.com> wrote in message
>> news:%23TjeE%236%23FHA.532@.TK2MSFTNGP15.phx.gbl...
>> Hi all
>> Has anyone seen the following error - cannot run any reports -
>> start then crashes
>> Reporting Services Error
>> ----
>> a.. An internal error occurred on the report server. See the error
>> log for more details. (rsInternalError) Get Online Help
>> a.. Invalid object name 'ReportServerTempDB.dbo.ExecutionCache'.
>> ----
>> Microsoft Reporting Services
>>
>> Peter
>>
>>
>>
>>
>|||Daniel
I'm going to delete the tempDB again and recreate it and make sure it has
exactly the same collating sequence and see what happens and let you know -
Peter Yang (MSFT)suggested checking that on the private newsgroup ( i
wasn't subscribed there before but I am now
ReportServer is Latin1_General CI_AS_KS_WS and the TempDB
Latin1_General_CI_AI_KS_WS -
I obviously made a mistake when I recreatedthe TempDB
Thank yuo for you help and assistance
Peter
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:OniKgWaAGHA.3436@.TK2MSFTNGP10.phx.gbl...
> Do the log files have more of a call stack? Perhaps that will lead us to
> where the problem is occurring.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Pete" <p0911@.hotmail.com> wrote in message
> news:O$HJsEF$FHA.3800@.TK2MSFTNGP10.phx.gbl...
>> Daniel
>> It happens when I run a report from Report Manager (or from within
>> 3.0) - it starts off ok (view report) and then come up with this
>> error - If I create a new report in Visual Studio and run preview from
>> there everything is fine !!! - if I then import this into ReportManager
>> and try to run it comes up with this error - along with all the other
>> reports currently in ReportManager
>> Everything was working fine until the other day and as far as I know I've
>> done nothing to the server (don't even touch it) although we did have a
>> power outage when I wasn't here and the UPS expired - don't even know
>> how the TempDb went missing ( ps I'm the only one who uses the system -
>> it is my dev network etc )
>> I thought the collating seq may have been wrong so I checked with a VPC
>> that works and changed it to the same as the Report Server
>> Latin1_General_CI_Ai_KS_WS but made no difference
>> This box is SBS 2003 with SQL 2000 plus MS CRM 3.0 plus SSRS 2000 plus
>> SP2 plus Visual Studio 2003
>> Peter
>>
>> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
>> news:uS%23qQdE$FHA.984@.tk2msftngp13.phx.gbl...
>> Where do you see this error? When running a report or in the log files?
>> You only need to run the catalogtemp.sql script, non of the upgrade
>> scripts.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Pete" <p0911@.hotmail.com> wrote in message
>> news:%23BJiSYE$FHA.2420@.TK2MSFTNGP12.phx.gbl...
>> Daniel
>> Tried your suggestions - DB was missing - created , added user ,
>> added role , ran script - all seemed to run ok - thought I was home
>> However I now get this and can't seem to find where to fix it
>> Reporting Services Error
>> ----
>> a.. An internal error occurred on the report server. See the error log
>> for more details. (rsInternalError) Get Online Help
>> a.. Cannot resolve collation conflict for equal to operation.
>> ----
>> Microsoft Reporting Services
>>
>> Also , there appears o be multiple scripts for Service packs etc where
>> the create script is - any idea what order to run them if necessary -
>> I had installed SSRS SP2 initially
>> Thank you
>> Pete
>>
>> "Pete" <p0911@.hotmail.com> wrote in message
>> news:utAoZyD$FHA.912@.TK2MSFTNGP11.phx.gbl...
>> Daniel
>> Thank you for your suggestions - I will try them out and post back
>> Pete
>>
>> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
>> news:e9lgNFC$FHA.3992@.TK2MSFTNGP15.phx.gbl...
>> There seems to be a corruption with your temp DB. First check to see
>> if there is a ReportServerTempDB database. If so then check for the
>> ExecutionCache table, if it exist make sure the owner is dbo. If the
>> DB does not exist you can run the CatalogTempDB.sql script to create
>> it. Make sure to first create the DB as ReportServerTempDB and then
>> create a Role called RSExecRole, then you can run the script. You
>> will also need to make sure all the users that are in the RSExecRole
>> in the ReportServer Database are in the ReportServerTempDB's
>> RSExecRole.
>>
>> I hope that helps.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Pete" <p0911@.hotmail.com> wrote in message
>> news:%23TjeE%236%23FHA.532@.TK2MSFTNGP15.phx.gbl...
>>> Hi all
>>>
>>> Has anyone seen the following error - cannot run any reports -
>>> start then crashes
>>>
>>> Reporting Services Error
>>> ----
>>>
>>> a.. An internal error occurred on the report server. See the error
>>> log for more details. (rsInternalError) Get Online Help
>>> a.. Invalid object name 'ReportServerTempDB.dbo.ExecutionCache'.
>>>
>>> ----
>>> Microsoft Reporting Services
>>>
>>>
>>> Peter
>>>
>>
>>
>>
>>
>>
>|||Daniel
Have managed to fix problem by recreating ReportServerTempDB with the
correct collating sequence this time
Thank you for you assistance - maybe well talk again in the future
Peter Hale
"Pete" <p0911@.hotmail.com> wrote in message
news:%23IIJp1tBGHA.4012@.TK2MSFTNGP10.phx.gbl...
> Daniel
> I'm going to delete the tempDB again and recreate it and make sure it has
> exactly the same collating sequence and see what happens and let you
> now - Peter Yang (MSFT)suggested checking that on the private newsgroup
> ( i wasn't subscribed there before but I am now
> ReportServer is Latin1_General CI_AS_KS_WS and the TempDB
> Latin1_General_CI_AI_KS_WS -
> I obviously made a mistake when I recreatedthe TempDB
> Thank yuo for you help and assistance
> Peter
> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
> news:OniKgWaAGHA.3436@.TK2MSFTNGP10.phx.gbl...
>> Do the log files have more of a call stack? Perhaps that will lead us to
>> where the problem is occurring.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Pete" <p0911@.hotmail.com> wrote in message
>> news:O$HJsEF$FHA.3800@.TK2MSFTNGP10.phx.gbl...
>> Daniel
>> It happens when I run a report from Report Manager (or from within
>> .0) - it starts off ok (view report) and then come up with this
>> error - If I create a new report in Visual Studio and run preview from
>> there everything is fine !!! - if I then import this into ReportManager
>> and try to run it comes up with this error - along with all the other
>> reports currently in ReportManager
>> Everything was working fine until the other day and as far as I know
>> I've done nothing to the server (don't even touch it) although we did
>> have a power outage when I wasn't here and the UPS expired - don't
>> even know how the TempDb went missing ( ps I'm the only one who uses
>> the system - it is my dev network etc )
>> I thought the collating seq may have been wrong so I checked with a VPC
>> that works and changed it to the same as the Report Server
>> Latin1_General_CI_Ai_KS_WS but made no difference
>> This box is SBS 2003 with SQL 2000 plus MS CRM 3.0 plus SSRS 2000 plus
>> SP2 plus Visual Studio 2003
>> Peter
>>
>> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
>> news:uS%23qQdE$FHA.984@.tk2msftngp13.phx.gbl...
>> Where do you see this error? When running a report or in the log
>> files?
>> You only need to run the catalogtemp.sql script, non of the upgrade
>> scripts.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Pete" <p0911@.hotmail.com> wrote in message
>> news:%23BJiSYE$FHA.2420@.TK2MSFTNGP12.phx.gbl...
>> Daniel
>> Tried your suggestions - DB was missing - created , added user ,
>> added role , ran script - all seemed to run ok - thought I was home
>> However I now get this and can't seem to find where to fix it
>> Reporting Services Error
>> ----
>> a.. An internal error occurred on the report server. See the error
>> log for more details. (rsInternalError) Get Online Help
>> a.. Cannot resolve collation conflict for equal to operation.
>> ----
>> Microsoft Reporting Services
>>
>> Also , there appears o be multiple scripts for Service packs etc where
>> the create script is - any idea what order to run them if necessary -
>> I had installed SSRS SP2 initially
>> Thank you
>> Pete
>>
>> "Pete" <p0911@.hotmail.com> wrote in message
>> news:utAoZyD$FHA.912@.TK2MSFTNGP11.phx.gbl...
>> Daniel
>> Thank you for your suggestions - I will try them out and post back
>> Pete
>>
>> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
>> news:e9lgNFC$FHA.3992@.TK2MSFTNGP15.phx.gbl...
>>> There seems to be a corruption with your temp DB. First check to
>>> see if there is a ReportServerTempDB database. If so then check for
>>> the ExecutionCache table, if it exist make sure the owner is dbo.
>>> If the DB does not exist you can run the CatalogTempDB.sql script to
>>> create it. Make sure to first create the DB as ReportServerTempDB
>>> and then create a Role called RSExecRole, then you can run the
>>> script. You will also need to make sure all the users that are in
>>> the RSExecRole in the ReportServer Database are in the
>>> ReportServerTempDB's RSExecRole.
>>>
>>>
>>> I hope that helps.
>>>
>>> --
>>> -Daniel
>>> This posting is provided "AS IS" with no warranties, and confers no
>>> rights.
>>>
>>>
>>> "Pete" <p0911@.hotmail.com> wrote in message
>>> news:%23TjeE%236%23FHA.532@.TK2MSFTNGP15.phx.gbl...
>>> Hi all
>>>
>>> Has anyone seen the following error - cannot run any reports -
>>> start then crashes
>>>
>>> Reporting Services Error
>>> ----
>>>
>>> a.. An internal error occurred on the report server. See the error
>>> log for more details. (rsInternalError) Get Online Help
>>> a.. Invalid object name 'ReportServerTempDB.dbo.ExecutionCache'.
>>>
>>> ----
>>> Microsoft Reporting Services
>>>
>>>
>>> Peter
>>>
>>>
>>>
>>
>>
>>
>>
>>
>

Error when running RedGate SQL Backup Job in SQL Server 2005

I have 4 SQL Server 2005 production servers that I installed RedGate SQL Bac
k
up on. All but one run fine. The one that doesn't I get the below error.
Executed as user : AD-DomainName\UserName. SQL Backup job failed with
exitcode 0 SQL Error code 18456[SQLState 42000] (Error 50000) The step f
ailed.
The back up is backing up to the AD server which is different than the
server the job runs on. It is a shared folder on the AD and the permissions
grant the owner of the job Full Access.
I do not know what else to do with this issue. It mirrors the other 3 that
work fine.
Any and all help is appreciated.
-ChrisChris,
SQL Server caches login information from active directory. The one
troublesome machine has apparently cached out of date AD information. In
David Grey's BLOG he discusses a similar problem (not with Red Gate) that
may help you resolve.
http://www.codefounders.com/communi...entication.aspx
RLF
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:2B7A5543-C258-4BA2-8CF4-BF2A7F4F1434@.microsoft.com...
>I have 4 SQL Server 2005 production servers that I installed RedGate SQL
>Back
> up on. All but one run fine. The one that doesn't I get the below error.
> Executed as user : AD-DomainName\UserName. SQL Backup job failed with
> exitcode 0 SQL Error code 18456[SQLState 42000] (Error 50000) The step
> failed.
> The back up is backing up to the AD server which is different than the
> server the job runs on. It is a shared folder on the AD and the
> permissions
> grant the owner of the job Full Access.
> I do not know what else to do with this issue. It mirrors the other 3 that
> work fine.
> Any and all help is appreciated.
> -Chris
>

Error when running Profiler

I install SQL Server 2005 Dev to my computer, when I try to run the Profiler,
I got the error message:
"The application failed to initialize properly (0xc0000005). Click on OK to
terminate the application."
How can I fix it so that I could run the Profiler on my machine?
Thanks in advance.
QHi
Error 0xc0000005 is usually an access violation. Does this occur for other
users? Can you run profiler on other machines?
John
"Q" wrote:
> I install SQL Server 2005 Dev to my computer, when I try to run the Profiler,
> I got the error message:
> "The application failed to initialize properly (0xc0000005). Click on OK to
> terminate the application."
> How can I fix it so that I could run the Profiler on my machine?
> Thanks in advance.
> Q

Error when running Profiler

I install SQL Server 2005 Dev to my computer, when I try to run the Profiler,
I got the error message:
"The application failed to initialize properly (0xc0000005). Click on OK to
terminate the application."
How can I fix it so that I could run the Profiler on my machine?
Thanks in advance.
Q
Hi
Error 0xc0000005 is usually an access violation. Does this occur for other
users? Can you run profiler on other machines?
John
"Q" wrote:

> I install SQL Server 2005 Dev to my computer, when I try to run the Profiler,
> I got the error message:
> "The application failed to initialize properly (0xc0000005). Click on OK to
> terminate the application."
> How can I fix it so that I could run the Profiler on my machine?
> Thanks in advance.
> Q

Error when running Profiler

I install SQL Server 2005 Dev to my computer, when I try to run the Profiler
,
I got the error message:
"The application failed to initialize properly (0xc0000005). Click on OK to
terminate the application."
How can I fix it so that I could run the Profiler on my machine?
Thanks in advance.
QHi
Error 0xc0000005 is usually an access violation. Does this occur for other
users? Can you run profiler on other machines?
John
"Q" wrote:

> I install SQL Server 2005 Dev to my computer, when I try to run the Profil
er,
> I got the error message:
> "The application failed to initialize properly (0xc0000005). Click on OK t
o
> terminate the application."
> How can I fix it so that I could run the Profiler on my machine?
> Thanks in advance.
> Qsql