Help with update forms: installed

Showing posts with label installed. Show all posts

Friday, March 30, 2012

HELP!...VB.NET killed SQL Server

Hi,
Yesterday I installed VB.NET on my machine. I had been runnng SQL Server
2000. After the install SQL Server will not run. SQLAgent fails with the
error "1068: The dependency service or group failed to start". When I try to
start MSSQL service I get a message it started then stopped because it may
not have anything to do.
I was planning to install SP3 of SQL Server 2000, so I tried that, but it
fails to install because (it seems) it needs SQL Server to be running.
Any ideas? Right now I desperately need SQL Server but not VB. So, I
guess my next move is to un-install VB.NET, which is going to be a royal
pain, and that may not even work because such a big install cannot be truly
uninstalled. After that I would fall back to an OS restore point.
Help, please!
Tim
> When I try to
> start MSSQL service I get a message it started then stopped because it may
> not have anything to do.
Can you post the SQL Server errorlog file? Assuming it is only a few rows, of course...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tim" <Tim@.discussions.microsoft.com> wrote in message
news:D3C2B8A5-17F9-448D-8EA0-19F5A4119907@.microsoft.com...
> Hi,
> Yesterday I installed VB.NET on my machine. I had been runnng SQL Server
> 2000. After the install SQL Server will not run. SQLAgent fails with the
> error "1068: The dependency service or group failed to start". When I try to
> start MSSQL service I get a message it started then stopped because it may
> not have anything to do.
> I was planning to install SP3 of SQL Server 2000, so I tried that, but it
> fails to install because (it seems) it needs SQL Server to be running.
> Any ideas? Right now I desperately need SQL Server but not VB. So, I
> guess my next move is to un-install VB.NET, which is going to be a royal
> pain, and that may not even work because such a big install cannot be truly
> uninstalled. After that I would fall back to an OS restore point.
> Help, please!
> Tim
|||Thanks! I ran the SQL Server setup program with the option "Rebuild
Registry" and now it seems fine. Thanks again!
Tim
"Tibor Karaszi" wrote:

> Can you post the SQL Server errorlog file? Assuming it is only a few rows, of course...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Tim" <Tim@.discussions.microsoft.com> wrote in message
> news:D3C2B8A5-17F9-448D-8EA0-19F5A4119907@.microsoft.com...
>
>

Help!!!Cannot connect to remote sql server by named pipe

Hi, all,

I installed sql server 2005 express on a server with window server 2003 SP1 and tried to connect it from a remote computer with vista installed.

I have already enabled named pipe and tcp/ip protocol for instance SQLEXPRESS on the server, and started sql server browser as well. Of course, I also enabled local and remote connection using tcp/ip and named pipe by sql server surface area configuration tool.

In this senario, I can connect to server locally or remotely by tcp/ip and connect to server locally by named pipe(c>sqlcmd -S \\192.168.1.100\pipe\MSSQL$SQLEXPRESS\sql\query -U * -P *), but I can not connect to server remotely using same command line.

According to some article from MSDN, it might be caused by firewall, but I already disabled my firewall. Moreover, I used tools like makepipe.exe and readpipe.exe, they didn't work too. Why the 2 computers can't create connection using named pipe protocol.

Thanks.

Johonson Chan

By "remotely" what do you mean? Are you talking a VPN or across the Internet?

You do not want to run named pipes across the Internet for many reasons. Named pipes use TCP port 445. Across the Internet you are subject to firewall in all the routers in between the 2 computers.

Use TCP/IP.

|||

I'm having a similar issue. As far as I can tell, all the configuration is set up correctly. The remote connection is enabled, TCP/IP is enabled, firewall is turned off. I'm trying to connecto to a database on a remote server using Sharepoint desinger and always get an error message saying 'The data retrieval service encountered an error during connection to the data source'.

Anyone had a luck with using the database connection feature in the Sharepoint designer?

Thanks.

|||

I am also having a simliar issue. Running sql server 2005, trying to connect using crystal reports 8.5, get error 'unable to connect to sql server <server name>' when connecting from a machine running windows server 2003 service pack 1.

The strange this is that it connects fine when I connect using the same crystal report, version 8.5 from my PC running Windows XP service Pack 2, so it means that the sql server 2005 is configured correctly.

I can connect to the server using ODBC on the windows server 2003 machine - just not through the crystal report.

Anyone else had this issue? Or any ideas how I can solve it?

Thanks.

|||I'm having a problem too. I can connect to SQL Server 2k5 via TCP/IP on all my WinXP machines, but my WinVista machine fails. I am also not using Windows authentication because I am connecting via the Intnernet, and will not be using Windows domains.

-Simon
|||

same problem trying to connect over the internet to sql server 2005 using sql server authentication .

the client is sql server 2005 and is running on vista. it worked fine from my xp box. this problem is killing me at the moment.

tcp/ip is enabled and i've tried it with and without the firewalls. aarrrrrrrrrrrrrrrrrrrggggggggggggggghhhhhhhhhhhhhhhhhhhhhhhhhhhhh

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476

Server Name: xxxxxxxxxxx,1433
Error Number: 18456
Severity: 14
State: 1
Line Number: 65536

Help!!!Cannot connect to remote sql server by named pipe

Hi, all,

I installed sql server 2005 express on a server with window server 2003 SP1 and tried to connect it from a remote computer with vista installed.

Thanks.

Johonson Chan

By "remotely" what do you mean? Are you talking a VPN or across the Internet?

You do not want to run named pipes across the Internet for many reasons. Named pipes use TCP port 445. Across the Internet you are subject to firewall in all the routers in between the 2 computers.

Use TCP/IP.

|||

Anyone had a luck with using the database connection feature in the Sharepoint designer?

Thanks.

|||

I can connect to the server using ODBC on the windows server 2003 machine - just not through the crystal report.

Anyone else had this issue? Or any ideas how I can solve it?

Thanks.

-Simon
|||

same problem trying to connect over the internet to sql server 2005 using sql server authentication .

the client is sql server 2005 and is running on vista. it worked fine from my xp box. this problem is killing me at the moment.

tcp/ip is enabled and i've tried it with and without the firewalls. aarrrrrrrrrrrrrrrrrrrggggggggggggggghhhhhhhhhhhhhhhhhhhhhhhhhhhhh

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476

Server Name: xxxxxxxxxxx,1433
Error Number: 18456
Severity: 14
State: 1
Line Number: 65536

HELP!!! Printer Delivery Extension not Printing Landscape

Hello All,

I'm using SQL Server 2005 Reporting Services, and I'm trying to have subscriptions print. To try this, I built, installed, and configured the printer delivery extension sample provided by Microsoft.

Everything appeared to be working fine. That is, I can schedule a report to print automatically using the printer delivery extension. However, the problem is that the reports always print portrait.

We have a number of reports--some are portrait and some are landscape. So, obviously, I need the landscape reports to print lanscape.

I've even tried "hard-coding" the page width and page height parameters in the printer delivery extension to try to force it to print landscape, but it still always prints portrait.

Would any one know how to have reports that are delivered to a printer actually print in the way they are created (i.e., print landscape if the report is set up as a landscape report)?

Do I have to use the IMAGE format? Could I use PDF? If so, how?

Thanks!

Hi,

there is a likewise issue if you use linked reports in RS - the linked report does not contain the original page settings.

It probably could be that you would have to set the page settings programmatically like described by Brian Welcker for the linked reports:
http://www.fits-consulting.de/blog/PermaLink,guid,e3f1cf4a-f9d6-44d8-86e5-84a59531f87c.aspx

hth...

cheers,
Markus

|||

Thanks for the info. Markus. Unfortunately, setting the page settings programmatically didn't help. All reports and linked reports always print portrait, not landscape.

Therefore, would any one have any ideas on how to use the printer delivery extension and make scheduled reports be delivered automatically to a printer and acutally print in landscape?

Please see me original post and let me know if more info. is needed to answer my questions.

Thanks!

HELP!! SQL Server Express 2005 engine connection to my DB

Preface, I am just starting to learn about database and web development.

I installed VS.net 2005 which updated my web site project file and automatically attached it to a database. It connected to ".\app_data\aspnetdb.mdf". However it messed something up and the connection didn't work. If I create a project from scratch, it connects to its DB just fine, but not my upgraded project.

However, when I publish my web site, I need to use ODBC. So, my thought was to simply set up the system locally in a way that will make it easy to connect on the web site. I was told to add a system DSN to the "Microsoft ODBC Administrator". I tried to add a "SQL Server" and give it the database name but it failed to connect.

So, then I ran the SQL Server Configuration Manager and looked at the server properties and found this string under the advanced -> startup parameters.."-dc:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf;-ec:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG;-lc:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf"

My database is in an entirely different folder. The database it looks like it is servicing is a "master.mdf" database installed under the SQL server install folder. So, I figured that I found my problem. I just have to change this file to map to mine. I replaced these three strings with paths to my aspnetdb.mdf/ldf files, and created a LOG folder. Howwever, it wasn't able to connect to this database. It said something like "it doesn't exist or you don't have permission", even though I gave it the right path.

So, I'm at a loss for how to get my application to be able to use the ODBC interface to connect to its very own database on my local system.

What do I need to do? Please help!

You need to create a Windows Authentication account on the server for ASPNET with a password.

When an .aspx page loads and tries to access the server, it uses Windows Authentication unless you code the connectionstring to use SQL authentication.

After you create the ASPNET Account, make your connection string look like this:

connectionString="Data Source=ODC01;Initial Catalog=OEM;Integrated Security=True"

Adamus

|||

Thanks you for the feedback. Unfortunately I'm still a bit confused. My problem is that I don't have a complete picture of how this is supposed to work.

Are you saying that I must set up a the server to use an account that uses Windows Authentication before I can attach it to my own MDB file? In other words, it will only connect to the default master.mdb file until I create an account?

Also, using "local" or "system" isn't good enough, I have to specify a user account even on my own personal computer running XP? I am the only one who uses this system, and there is no windows server running on the network. This is my home setup.

This is the map that I understand. There are 3 connections that must be made for this to work.

mydb.mdb --1 (get server to serve my DB)--> SQL Server express 2005 --2 (tell ODBC about my DB exposed by the server)--> ODBC --3 (using the connection string)--> Website.

Right now I beleive none of the 3 connections are working, and I feel like I need to get the step 1 done before I can establish and verify step 2 and then finally use the connection string in step 3.

Are you saying that I must create a Windows Authentication user account before step 1 will work? Does that simply meen that I create a user called "SQL Server" with minimal access on the computer and log into it whenever I want it to connect?

Is there a "complete idiots guide to establishing a SQL server 2005 connection from your web site to your database" book that I could buy?

|||

I take it all back. You were right. Now I understand. I actually had the account set up correctly on the server side, but I wasn't logging in correctly.

Second, when I tried to attach the server to ODBC I was using my computer name alone, when I needed to use <computer_name>\SQLExpress.

Now I have to figure out the connection string. But I am finally over my biggest hurdle. Thanks!

HELP!! SQL Server Express 2005 engine connection to my DB

Preface, I am just starting to learn about database and web development.

So, I'm at a loss for how to get my application to be able to use the ODBC interface to connect to its very own database on my local system.

What do I need to do? Please help!

You need to create a Windows Authentication account on the server for ASPNET with a password.

When an .aspx page loads and tries to access the server, it uses Windows Authentication unless you code the connectionstring to use SQL authentication.

After you create the ASPNET Account, make your connection string look like this:

connectionString="Data Source=ODC01;Initial Catalog=OEM;Integrated Security=True"

Adamus

|||

Thanks you for the feedback. Unfortunately I'm still a bit confused. My problem is that I don't have a complete picture of how this is supposed to work.

This is the map that I understand. There are 3 connections that must be made for this to work.

mydb.mdb --1 (get server to serve my DB)--> SQL Server express 2005 --2 (tell ODBC about my DB exposed by the server)--> ODBC --3 (using the connection string)--> Website.

Right now I beleive none of the 3 connections are working, and I feel like I need to get the step 1 done before I can establish and verify step 2 and then finally use the connection string in step 3.

Is there a "complete idiots guide to establishing a SQL server 2005 connection from your web site to your database" book that I could buy?

|||

I take it all back. You were right. Now I understand. I actually had the account set up correctly on the server side, but I wasn't logging in correctly.

Second, when I tried to attach the server to ODBC I was using my computer name alone, when I needed to use <computer_name>\SQLExpress.

Now I have to figure out the connection string. But I am finally over my biggest hurdle. Thanks!

HELP!! i deleted services!

i have installed vs 2005 and sql server enterprise edition on an xp pro sp2 machine.but i could not connect to the mssqlexpress default database that it came with.in a moment of madness i deleted the mssqlserver services (3 of them).how do i reinstall them? i thought uninstalling the products and reinstalling them would help but it did not.

please help!

cheers OK, wait a minute. You installed the enterprise edition of the MSSQL Service on a XP prof ? This is not possible. What did you actually delete, where and what did you try to achieve ?

HTH, jens Suessmeyer.

http://www.sqlserver2005.de|||

yes it it is possible, the only thing is that you do not have access to all the functionality.i have solved the prob by uninstalling and installing the work edition.

thanks

|||Sorry to correct you, but installing SQL Server services won′t be available for enterprise edition, only the client tools.

Jens Suessmeyer.

http://www.sqlserver2005.de

Help!! i deleted mssqlserver services

have installed vs 2005 and sql server enterprise edition on an xp pro

sp2 machine.but i could not connect to the mssqlexpress default

database that it came with.in a moment of madness i deleted the

mssqlserver services (3 of them).how do i reinstall them? i thought

uninstalling the products and reinstalling them would help but it did

not.

please help!

cheers how did you delete them?|||Are you trying to connect using VS 2005?sql

Help!! "The report server has encountered a configuration error........"

Hi There,

I have installed Sql Server 2005 on my machine. I've managed to created report, but when i try to deploy e same, I'm getting e following error...am i missing something here? Idea

The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\RSReportServer.config' is denied.

when i checked in msdn..there it says
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSerrors/htm/Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings_rsServerConfigurationError.asp

Other info:

I have followed the Tutorial Project in SQL Books online. And for TargetURL, i have given --> http://localhost/reportserver

Report server is located in my local only

rsreportserver.config : I dint touch this file and mine is fresh installation. Sad

Help please :)

Can you access Report Manager via Internet Explorer (http://server/reports) at all? Or does it throw the same/similar error?

It sounds to me like the account that SSRS is running under doesn't have the proper NTFS perms on the 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\' folder. Verify that that it does, or use the filemon tool from sysinternals.com to capture a log of what process (and which account) is getting denied...this will give you most of the info you'd need to fix the issue.

Good luck!

|||

I experienced the problem described above and the filemon tool identified that the ASPNET user did not have read privileges to the .config file.

It seems strange that the server installation did not configure this correctly.. Setting privileges manually solved the problem..

|||

Add ASPNET user to SQLServer2005Reporting ServicesWebServiceUsers$<MACHINE NAME> group, reboot your machine and it should start working properly.

|||

You should be able to fix this as well by using the Report Server Configuration tool to set the web service identity.

-Lukasz

|||Web Service Identity is hard coded on the "Configure Report Server" page.|||

Hi,

I am having similar issue trying to launch report services by http://localhost/reports. I got the following error

when try to launch it.

The report server is not responding. Verify that the report server is running and can be accessed from this computer.

I used the Reporting Services Configuration tool to set all my virtual directory and etc... and verified that the report server is initiated and running. I have read other thread for similar issue, but none was able to provide a clear solution on how to resolve the problem. Any help would be appriciated.

|||

Look in your log files and see if there is a detailed error message there. That's your best place to start.

-Lukasz

|||

Hi,

I've look at the log file and it didn't help me much. Maybe you can point me to the right direction.

By the way, I am running Vista and using the Server 2005 eval edition. I don't know if this make any differences. I still couldn't get it took work for me. Any help would be greatly appriciate. The error i get is as follow when try to launch the report service using http://localhost/reports:

The report server is not responding. Verify that the report server is running and can be accessed from this computer.

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.3054.00</Product>
<Locale>en-US</Locale>
<TimeZone>Central Daylight Time</TimeZone>
<Path>c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__05_08_2007_10_17_13.log</Path>
<SystemName>ATS-PC</SystemName>
<OSName>Microsoft Windows NT 6.0.6000.0</OSName>
<OSVersion>6.0.6000.0</OSVersion>
</Header>
w3wp!webserver!1!5/8/2007-10:17:30:: i INFO: Reporting Web Server started
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!5/8/2007-10:17:30:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!resourceutilities!1!5/8/2007-10:17:30:: i INFO: Reporting Services starting SKU: Evaluation
w3wp!resourceutilities!1!5/8/2007-10:17:30:: i INFO: Evaluation copy: 175 days left
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!5/8/2007-10:17:31:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!library!1!05/08/2007-10:17:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
w3wp!library!1!05/08/2007-10:17:33:: i INFO: Exception dumped to: c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!1!05/08/2007-10:17:33:: i INFO: Catalog SQL Server Edition = Evaluation
w3wp!library!1!05/08/2007-10:17:36:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
w3wp!library!1!05/08/2007-10:17:38:: i INFO: Exception dumped to: c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!5!05/08/2007-10:27:04:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace
w3wp!library!7!5/8/2007-10:27:31:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!5!05/08/2007-10:27:35:: i INFO: Exception dumped to: c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!1!05/08/2007-10:27:37:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Authentication.WindowsAuthentication.GetUserInfo(IIdentity& userIdentity, IntPtr& userId)
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
End of inner exception stack trace

|||

If you're running on Vista, you must install SQL Server SP2. Here are some KB articles that should help you out.

http://support.microsoft.com/kb/934164 (install)

http://support.microsoft.com/kb/934163 (upgrade)

-Lukasz

|||I had a similar problem. It turned out that since I had a named instance of SQL Server 2005 I had to reference that in the url. Specifically, it was http://localhost/ReportServer$NAMEOFSQLSERVERINSTANCE

- CindyPsych

Help!! "The report server has encountered a configuration error........"

Hi There,

I have installed Sql Server 2005 on my machine. I've managed to created report, but when i try to deploy e same, I'm getting e following error...am i missing something here? Idea

Other info:

I have followed the Tutorial Project in SQL Books online. And for TargetURL, i have given --> http://localhost/reportserver

Report server is located in my local only

rsreportserver.config : I dint touch this file and mine is fresh installation. Sad

Help please :)

Can you access Report Manager via Internet Explorer (http://server/reports) at all? Or does it throw the same/similar error?

Good luck!

|||

I experienced the problem described above and the filemon tool identified that the ASPNET user did not have read privileges to the .config file.

It seems strange that the server installation did not configure this correctly.. Setting privileges manually solved the problem..

|||

Add ASPNET user to SQLServer2005Reporting ServicesWebServiceUsers$<MACHINE NAME> group, reboot your machine and it should start working properly.

|||

You should be able to fix this as well by using the Report Server Configuration tool to set the web service identity.

-Lukasz

|||Web Service Identity is hard coded on the "Configure Report Server" page.|||

Hi,

I am having similar issue trying to launch report services by http://localhost/reports. I got the following error

when try to launch it.

The report server is not responding. Verify that the report server is running and can be accessed from this computer.

|||

Look in your log files and see if there is a detailed error message there. That's your best place to start.

-Lukasz

|||

Hi,

I've look at the log file and it didn't help me much. Maybe you can point me to the right direction.

The report server is not responding. Verify that the report server is running and can be accessed from this computer.

|||

If you're running on Vista, you must install SQL Server SP2. Here are some KB articles that should help you out.

http://support.microsoft.com/kb/934164 (install)

http://support.microsoft.com/kb/934163 (upgrade)

-Lukasz

- CindyPsych

Help!! "The report server has encountered a configuration error........"

Hi There,

I have installed Sql Server 2005 on my machine. I've managed to created report, but when i try to deploy e same, I'm getting e following error...am i missing something here? Idea

Other info:

I have followed the Tutorial Project in SQL Books online. And for TargetURL, i have given --> http://localhost/reportserver

Report server is located in my local only

rsreportserver.config : I dint touch this file and mine is fresh installation. Sad

Help please :)

Can you access Report Manager via Internet Explorer (http://server/reports) at all? Or does it throw the same/similar error?

Good luck!

|||

I experienced the problem described above and the filemon tool identified that the ASPNET user did not have read privileges to the .config file.

It seems strange that the server installation did not configure this correctly.. Setting privileges manually solved the problem..

|||

Add ASPNET user to SQLServer2005Reporting ServicesWebServiceUsers$<MACHINE NAME> group, reboot your machine and it should start working properly.

|||

You should be able to fix this as well by using the Report Server Configuration tool to set the web service identity.

-Lukasz

|||Web Service Identity is hard coded on the "Configure Report Server" page.|||

Hi,

I am having similar issue trying to launch report services by http://localhost/reports. I got the following error

when try to launch it.

The report server is not responding. Verify that the report server is running and can be accessed from this computer.

|||

Look in your log files and see if there is a detailed error message there. That's your best place to start.

-Lukasz

|||

Hi,

I've look at the log file and it didn't help me much. Maybe you can point me to the right direction.

The report server is not responding. Verify that the report server is running and can be accessed from this computer.

|||

If you're running on Vista, you must install SQL Server SP2. Here are some KB articles that should help you out.

http://support.microsoft.com/kb/934164 (install)

http://support.microsoft.com/kb/934163 (upgrade)

-Lukasz

- CindyPsych

Help!! "The report server has encountered a configuration error........"

Hi There,

I have installed Sql Server 2005 on my machine. I've managed to created report, but when i try to deploy e same, I'm getting e following error...am i missing something here? Idea

Other info:

I have followed the Tutorial Project in SQL Books online. And for TargetURL, i have given --> http://localhost/reportserver

Report server is located in my local only

rsreportserver.config : I dint touch this file and mine is fresh installation. Sad

Help please :)

Can you access Report Manager via Internet Explorer (http://server/reports) at all? Or does it throw the same/similar error?

Good luck!

|||

I experienced the problem described above and the filemon tool identified that the ASPNET user did not have read privileges to the .config file.

It seems strange that the server installation did not configure this correctly.. Setting privileges manually solved the problem..

|||

Add ASPNET user to SQLServer2005Reporting ServicesWebServiceUsers$<MACHINE NAME> group, reboot your machine and it should start working properly.

|||

You should be able to fix this as well by using the Report Server Configuration tool to set the web service identity.

-Lukasz

|||Web Service Identity is hard coded on the "Configure Report Server" page.|||

Hi,

I am having similar issue trying to launch report services by http://localhost/reports. I got the following error

when try to launch it.

The report server is not responding. Verify that the report server is running and can be accessed from this computer.

|||

Look in your log files and see if there is a detailed error message there. That's your best place to start.

-Lukasz

|||

Hi,

I've look at the log file and it didn't help me much. Maybe you can point me to the right direction.

The report server is not responding. Verify that the report server is running and can be accessed from this computer.

|||

If you're running on Vista, you must install SQL Server SP2. Here are some KB articles that should help you out.

http://support.microsoft.com/kb/934164 (install)

http://support.microsoft.com/kb/934163 (upgrade)

-Lukasz

- CindyPsych

Help!! "The report server has encountered a configuration error........"

Hi There,

I have installed Sql Server 2005 on my machine. I've managed to created report, but when i try to deploy e same, I'm getting e following error...am i missing something here? Idea

Other info:

I have followed the Tutorial Project in SQL Books online. And for TargetURL, i have given --> http://localhost/reportserver

Report server is located in my local only

rsreportserver.config : I dint touch this file and mine is fresh installation. Sad

Help please :)

Can you access Report Manager via Internet Explorer (http://server/reports) at all? Or does it throw the same/similar error?

Good luck!

|||

I experienced the problem described above and the filemon tool identified that the ASPNET user did not have read privileges to the .config file.

It seems strange that the server installation did not configure this correctly.. Setting privileges manually solved the problem..

|||

Add ASPNET user to SQLServer2005Reporting ServicesWebServiceUsers$<MACHINE NAME> group, reboot your machine and it should start working properly.

|||

You should be able to fix this as well by using the Report Server Configuration tool to set the web service identity.

-Lukasz

|||Web Service Identity is hard coded on the "Configure Report Server" page.|||

Hi,

I am having similar issue trying to launch report services by http://localhost/reports. I got the following error

when try to launch it.

The report server is not responding. Verify that the report server is running and can be accessed from this computer.

|||

Look in your log files and see if there is a detailed error message there. That's your best place to start.

-Lukasz

|||

Hi,

I've look at the log file and it didn't help me much. Maybe you can point me to the right direction.

The report server is not responding. Verify that the report server is running and can be accessed from this computer.

|||

If you're running on Vista, you must install SQL Server SP2. Here are some KB articles that should help you out.

http://support.microsoft.com/kb/934164 (install)

http://support.microsoft.com/kb/934163 (upgrade)

-Lukasz

- CindyPsych

Help!! "The report server has encountered a configuration error........"

Hi There,

I have installed Sql Server 2005 on my machine. I've managed to created report, but when i try to deploy e same, I'm getting e following error...am i missing something here? Idea

Other info:

I have followed the Tutorial Project in SQL Books online. And for TargetURL, i have given --> http://localhost/reportserver

Report server is located in my local only

rsreportserver.config : I dint touch this file and mine is fresh installation. Sad

Help please :)

Can you access Report Manager via Internet Explorer (http://server/reports) at all? Or does it throw the same/similar error?

Good luck!

|||

I experienced the problem described above and the filemon tool identified that the ASPNET user did not have read privileges to the .config file.

It seems strange that the server installation did not configure this correctly.. Setting privileges manually solved the problem..

|||

Add ASPNET user to SQLServer2005Reporting ServicesWebServiceUsers$<MACHINE NAME> group, reboot your machine and it should start working properly.

|||

You should be able to fix this as well by using the Report Server Configuration tool to set the web service identity.

-Lukasz

|||Web Service Identity is hard coded on the "Configure Report Server" page.|||

Hi,

I am having similar issue trying to launch report services by http://localhost/reports. I got the following error

when try to launch it.

The report server is not responding. Verify that the report server is running and can be accessed from this computer.

|||

Look in your log files and see if there is a detailed error message there. That's your best place to start.

-Lukasz

|||

Hi,

I've look at the log file and it didn't help me much. Maybe you can point me to the right direction.

The report server is not responding. Verify that the report server is running and can be accessed from this computer.

|||

If you're running on Vista, you must install SQL Server SP2. Here are some KB articles that should help you out.

http://support.microsoft.com/kb/934164 (install)

http://support.microsoft.com/kb/934163 (upgrade)

-Lukasz

- CindyPsych

Friday, March 30, 2012

HELP!...VB.NET killed SQL Server

Help!!!Cannot connect to remote sql server by named pipe

Help!!!Cannot connect to remote sql server by named pipe

HELP!!! Printer Delivery Extension not Printing Landscape

HELP!! SQL Server Express 2005 engine connection to my DB

HELP!! SQL Server Express 2005 engine connection to my DB

HELP!! i deleted services!

Help!! i deleted mssqlserver services

Help!! "The report server has encountered a configuration error........"

Help!! "The report server has encountered a configuration error........"

Help!! "The report server has encountered a configuration error........"

Help!! "The report server has encountered a configuration error........"

Help!! "The report server has encountered a configuration error........"

Help!! "The report server has encountered a configuration error........"

Help with update forms

Blog Archive

About Me