Hi Guru,
I'm tired of trouleshoot one of my sql box that the sqlagent can't started.
Here is the message:
SQLServerAgent could not be started (reason: Unable to connect to server '
(local)'; SQLServerAgent cannot start)
? SQLSERVER runs on LocalSystem account with started up type automatic and
successful
? Connect to SQL Analyzer: LocalHost, . (period), (local) and blank all
successful
? Registry key and MDAC are good safe
? BUILTIN\Administrators is present and SYSADMIN rights
? From AD, domain accounts passwords are in synch.
? Win2000, SQL2000 SP3a and build 800.00.760
? Client and network utility used both name pipe and TCP
From enterprise manager on the server itself, I am able to register the
server by supplying the server name. However, when I tried to register with
the (local), I was never able to do so.
I also tried to restart the SQL agent with localsystem, domain and local
admin accounts none of them can start the service. These accounts are local
admin to the box and have complete sysdmin rights to sql server. From query
analyzer, these accounts can connect to server with blank, LocalHost, (local),
and period. So, this tells me that the server does not experience of
resolving (local) connection.
I tried to log on to the server with both local and domain accounts to start
agent but nothing is good for me. I tried to change startup account from
enterprise manager to make sure security is in synch but still the same.
However, the last thing that I?ve not done is reboot the OS.
Please help,
Thanks,
Silaphet,
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200605/1(local) only works on the default instance. Are you trying to connect
to a named instance?|||can you check whats the exact message in SQLAGENT.OUT
Showing posts with label service. Show all posts
Showing posts with label service. Show all posts
Thursday, March 29, 2012
Tuesday, March 27, 2012
Can't start the SQLAGENT service
Hi Guru,
I'm tired of trouleshoot one of my sql box that the sqlagent can't started.
Here is the message:
SQLServerAgent could not be started (reason: Unable to connect to server '
(local)'; SQLServerAgent cannot start)
SQLSERVER runs on LocalSystem account with started up type automatic and
successful
Connect to SQL Analyzer: LocalHost, . (period), (local) and blank all
successful
Registry key and MDAC are good safe
BUILTIN\Administrators is present and SYSADMIN rights
From AD, domain accounts passwords are in synch.
Win2000, SQL2000 SP3a and build 800.00.760
Client and network utility used both name pipe and TCP
From enterprise manager on the server itself, I am able to register the
server by supplying the server name. However, when I tried to register with
the (local), I was never able to do so.
I also tried to restart the SQL agent with localsystem, domain and local
admin accounts none of them can start the service. These accounts are local
admin to the box and have complete sysdmin rights to sql server. From query
analyzer, these accounts can connect to server with blank, LocalHost, (local
),
and period. So, this tells me that the server does not experience of
resolving (local) connection.
I tried to log on to the server with both local and domain accounts to start
agent but nothing is good for me. I tried to change startup account from
enterprise manager to make sure security is in synch but still the same.
However, the last thing that Ive not done is reboot the OS.
Please help,
Thanks,
Silaphet,
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200605/1(local) only works on the default instance. Are you trying to connect
to a named instance?|||can you check whats the exact message in SQLAGENT.OUT
I'm tired of trouleshoot one of my sql box that the sqlagent can't started.
Here is the message:
SQLServerAgent could not be started (reason: Unable to connect to server '
(local)'; SQLServerAgent cannot start)
SQLSERVER runs on LocalSystem account with started up type automatic and
successful
Connect to SQL Analyzer: LocalHost, . (period), (local) and blank all
successful
Registry key and MDAC are good safe
BUILTIN\Administrators is present and SYSADMIN rights
From AD, domain accounts passwords are in synch.
Win2000, SQL2000 SP3a and build 800.00.760
Client and network utility used both name pipe and TCP
From enterprise manager on the server itself, I am able to register the
server by supplying the server name. However, when I tried to register with
the (local), I was never able to do so.
I also tried to restart the SQL agent with localsystem, domain and local
admin accounts none of them can start the service. These accounts are local
admin to the box and have complete sysdmin rights to sql server. From query
analyzer, these accounts can connect to server with blank, LocalHost, (local
),
and period. So, this tells me that the server does not experience of
resolving (local) connection.
I tried to log on to the server with both local and domain accounts to start
agent but nothing is good for me. I tried to change startup account from
enterprise manager to make sure security is in synch but still the same.
However, the last thing that Ive not done is reboot the OS.
Please help,
Thanks,
Silaphet,
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200605/1(local) only works on the default instance. Are you trying to connect
to a named instance?|||can you check whats the exact message in SQLAGENT.OUT
cant start the sql server services
Hi all
After i configure the Merge Replication, my sql server services wont start again.
The error show that "The request failed for the service did not respone in time fashion. Consult the event log or other application error logs for detail"
>>The error show that "The request failed for the service did not respone in time fashion. Consult the event log or other application error logs for detail"
Did you?
|||what is that mean actually/|||Did you consult with sql server log?|||Go to C:\MS SQL Server\MSSQL4 (or 3 something like that)
There find a LOG folder and several log files which should tell you what exactly happend and why the service is not running.
Also check if you have set the services to start automatically or manually.
Can't start the MSSQLServer Service
I just got a new laptop for work, and our local IT/Hardware guy used
PCMover from Laplink to migrate the apps and settings from my old
machine to this new one. I was skeptical, but it's actually worked
quite well, the biggest issue that I'm having is getting SQL Server to
run on the new machine.
Using SQL Server 2000. Both laptops are Windows XP Pro SP2.
After the migration, I did have to recreate the services for the
server and agent (those services weren't migrated):
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\scm.exe -action 5 -
service MSSQLServer -exepath "c:\Program Files\Microsoft SQL Server
\MSSQL\Binn\sqlservr.exe"
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\scm.exe -action 5 -
service SQLSERVERAGENT -exepath "c:\Program Files\Microsoft SQL Server
\MSSQL\Binn\sqlagent.exe" -dependencies MSSQLServer
If I don't include the SQL Server dependency on the SQL Agent, then
the Agent starts just fine. When I try to start the SQL Server
service, it displays a dialog error:
The MSSQLServer service on Local Computer started and then stopped.
Some Services stop automatically if they have no work to do, for
example, the Performance Logs and Alerts service.
Here's the contents of the server log:
2007-02-08 10:38:58.14 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
2007-02-08 10:38:58.14 server Copyright (C) 1988-2002 Microsoft
Corporation.
2007-02-08 10:38:58.14 server All rights reserved.
2007-02-08 10:38:58.14 server Server Process ID is 5860.
2007-02-08 10:38:58.14 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
2007-02-08 10:38:58.17 server SQL Server is starting at priority
class 'normal'(2 CPUs detected).
2007-02-08 10:38:58.84 server SQL Server configured for thread mode
processing.
2007-02-08 10:38:58.84 server Using dynamic lock allocation. [2500]
Lock Blocks, [5000] Lock Owner Blocks.
2007-02-08 10:38:58.87 server Attempting to initialize Distributed
Transaction Coordinator.
2007-02-08 10:38:58.89 server Failed to obtain
TransactionDispenserInterface: Result Code = 0x8004d01b
2007-02-08 10:38:58.89 server Unable to load any NETLIBs. Server
shutting down.
2007-02-08 10:38:58.89 spid4 Starting up database 'master'.
The failure to obtain TransactionDispenserInterface message was
occurring on the old machine, so I conclude that isn't part of the
issue.
The Server Network Utility does show TCP/IP as the only protocol
enabled. The Network Libraries tab does show the TCP/IP SSNETLIB.DLL
listed and that dll is residing in the expected location (C:\Program
Files\Microsoft SQL Server\MSSQL\Binn).
The service properties page page Log On tab shows the Local System
Account to be used for logon.
So, I'm figuring it can't find ssnetlib.dll. Short of uninstalling
and re-installing SQL Server, how can I get my SQL Server back up and
running?
Thanks in advance
Mark>I just got a new laptop for work, and our local IT/Hardware guy used
> PCMover from Laplink to migrate the apps and settings from my old
> machine to this new one. I was skeptical,
And you should have been. The errorlog clearly states that SQL Server cannot load any netlibs, so it
refuses to start. I.e., the installation isn't OK...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<mark.a.lemoine@.gmail.com> wrote in message
news:1170950095.972400.293760@.s48g2000cws.googlegroups.com...
>I just got a new laptop for work, and our local IT/Hardware guy used
> PCMover from Laplink to migrate the apps and settings from my old
> machine to this new one. I was skeptical, but it's actually worked
> quite well, the biggest issue that I'm having is getting SQL Server to
> run on the new machine.
> Using SQL Server 2000. Both laptops are Windows XP Pro SP2.
> After the migration, I did have to recreate the services for the
> server and agent (those services weren't migrated):
> C:\Program Files\Microsoft SQL Server\80\Tools\Binn\scm.exe -action 5 -
> service MSSQLServer -exepath "c:\Program Files\Microsoft SQL Server
> \MSSQL\Binn\sqlservr.exe"
> C:\Program Files\Microsoft SQL Server\80\Tools\Binn\scm.exe -action 5 -
> service SQLSERVERAGENT -exepath "c:\Program Files\Microsoft SQL Server
> \MSSQL\Binn\sqlagent.exe" -dependencies MSSQLServer
> If I don't include the SQL Server dependency on the SQL Agent, then
> the Agent starts just fine. When I try to start the SQL Server
> service, it displays a dialog error:
> The MSSQLServer service on Local Computer started and then stopped.
> Some Services stop automatically if they have no work to do, for
> example, the Performance Logs and Alerts service.
> Here's the contents of the server log:
> 2007-02-08 10:38:58.14 server Microsoft SQL Server 2000 - 8.00.760
> (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
> 2007-02-08 10:38:58.14 server Copyright (C) 1988-2002 Microsoft
> Corporation.
> 2007-02-08 10:38:58.14 server All rights reserved.
> 2007-02-08 10:38:58.14 server Server Process ID is 5860.
> 2007-02-08 10:38:58.14 server Logging SQL Server messages in file
> 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
> 2007-02-08 10:38:58.17 server SQL Server is starting at priority
> class 'normal'(2 CPUs detected).
> 2007-02-08 10:38:58.84 server SQL Server configured for thread mode
> processing.
> 2007-02-08 10:38:58.84 server Using dynamic lock allocation. [2500]
> Lock Blocks, [5000] Lock Owner Blocks.
> 2007-02-08 10:38:58.87 server Attempting to initialize Distributed
> Transaction Coordinator.
> 2007-02-08 10:38:58.89 server Failed to obtain
> TransactionDispenserInterface: Result Code = 0x8004d01b
> 2007-02-08 10:38:58.89 server Unable to load any NETLIBs. Server
> shutting down.
> 2007-02-08 10:38:58.89 spid4 Starting up database 'master'.
> The failure to obtain TransactionDispenserInterface message was
> occurring on the old machine, so I conclude that isn't part of the
> issue.
> The Server Network Utility does show TCP/IP as the only protocol
> enabled. The Network Libraries tab does show the TCP/IP SSNETLIB.DLL
> listed and that dll is residing in the expected location (C:\Program
> Files\Microsoft SQL Server\MSSQL\Binn).
> The service properties page page Log On tab shows the Local System
> Account to be used for logon.
> So, I'm figuring it can't find ssnetlib.dll. Short of uninstalling
> and re-installing SQL Server, how can I get my SQL Server back up and
> running?
> Thanks in advance
> Mark
>sql
PCMover from Laplink to migrate the apps and settings from my old
machine to this new one. I was skeptical, but it's actually worked
quite well, the biggest issue that I'm having is getting SQL Server to
run on the new machine.
Using SQL Server 2000. Both laptops are Windows XP Pro SP2.
After the migration, I did have to recreate the services for the
server and agent (those services weren't migrated):
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\scm.exe -action 5 -
service MSSQLServer -exepath "c:\Program Files\Microsoft SQL Server
\MSSQL\Binn\sqlservr.exe"
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\scm.exe -action 5 -
service SQLSERVERAGENT -exepath "c:\Program Files\Microsoft SQL Server
\MSSQL\Binn\sqlagent.exe" -dependencies MSSQLServer
If I don't include the SQL Server dependency on the SQL Agent, then
the Agent starts just fine. When I try to start the SQL Server
service, it displays a dialog error:
The MSSQLServer service on Local Computer started and then stopped.
Some Services stop automatically if they have no work to do, for
example, the Performance Logs and Alerts service.
Here's the contents of the server log:
2007-02-08 10:38:58.14 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
2007-02-08 10:38:58.14 server Copyright (C) 1988-2002 Microsoft
Corporation.
2007-02-08 10:38:58.14 server All rights reserved.
2007-02-08 10:38:58.14 server Server Process ID is 5860.
2007-02-08 10:38:58.14 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
2007-02-08 10:38:58.17 server SQL Server is starting at priority
class 'normal'(2 CPUs detected).
2007-02-08 10:38:58.84 server SQL Server configured for thread mode
processing.
2007-02-08 10:38:58.84 server Using dynamic lock allocation. [2500]
Lock Blocks, [5000] Lock Owner Blocks.
2007-02-08 10:38:58.87 server Attempting to initialize Distributed
Transaction Coordinator.
2007-02-08 10:38:58.89 server Failed to obtain
TransactionDispenserInterface: Result Code = 0x8004d01b
2007-02-08 10:38:58.89 server Unable to load any NETLIBs. Server
shutting down.
2007-02-08 10:38:58.89 spid4 Starting up database 'master'.
The failure to obtain TransactionDispenserInterface message was
occurring on the old machine, so I conclude that isn't part of the
issue.
The Server Network Utility does show TCP/IP as the only protocol
enabled. The Network Libraries tab does show the TCP/IP SSNETLIB.DLL
listed and that dll is residing in the expected location (C:\Program
Files\Microsoft SQL Server\MSSQL\Binn).
The service properties page page Log On tab shows the Local System
Account to be used for logon.
So, I'm figuring it can't find ssnetlib.dll. Short of uninstalling
and re-installing SQL Server, how can I get my SQL Server back up and
running?
Thanks in advance
Mark>I just got a new laptop for work, and our local IT/Hardware guy used
> PCMover from Laplink to migrate the apps and settings from my old
> machine to this new one. I was skeptical,
And you should have been. The errorlog clearly states that SQL Server cannot load any netlibs, so it
refuses to start. I.e., the installation isn't OK...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<mark.a.lemoine@.gmail.com> wrote in message
news:1170950095.972400.293760@.s48g2000cws.googlegroups.com...
>I just got a new laptop for work, and our local IT/Hardware guy used
> PCMover from Laplink to migrate the apps and settings from my old
> machine to this new one. I was skeptical, but it's actually worked
> quite well, the biggest issue that I'm having is getting SQL Server to
> run on the new machine.
> Using SQL Server 2000. Both laptops are Windows XP Pro SP2.
> After the migration, I did have to recreate the services for the
> server and agent (those services weren't migrated):
> C:\Program Files\Microsoft SQL Server\80\Tools\Binn\scm.exe -action 5 -
> service MSSQLServer -exepath "c:\Program Files\Microsoft SQL Server
> \MSSQL\Binn\sqlservr.exe"
> C:\Program Files\Microsoft SQL Server\80\Tools\Binn\scm.exe -action 5 -
> service SQLSERVERAGENT -exepath "c:\Program Files\Microsoft SQL Server
> \MSSQL\Binn\sqlagent.exe" -dependencies MSSQLServer
> If I don't include the SQL Server dependency on the SQL Agent, then
> the Agent starts just fine. When I try to start the SQL Server
> service, it displays a dialog error:
> The MSSQLServer service on Local Computer started and then stopped.
> Some Services stop automatically if they have no work to do, for
> example, the Performance Logs and Alerts service.
> Here's the contents of the server log:
> 2007-02-08 10:38:58.14 server Microsoft SQL Server 2000 - 8.00.760
> (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
> 2007-02-08 10:38:58.14 server Copyright (C) 1988-2002 Microsoft
> Corporation.
> 2007-02-08 10:38:58.14 server All rights reserved.
> 2007-02-08 10:38:58.14 server Server Process ID is 5860.
> 2007-02-08 10:38:58.14 server Logging SQL Server messages in file
> 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
> 2007-02-08 10:38:58.17 server SQL Server is starting at priority
> class 'normal'(2 CPUs detected).
> 2007-02-08 10:38:58.84 server SQL Server configured for thread mode
> processing.
> 2007-02-08 10:38:58.84 server Using dynamic lock allocation. [2500]
> Lock Blocks, [5000] Lock Owner Blocks.
> 2007-02-08 10:38:58.87 server Attempting to initialize Distributed
> Transaction Coordinator.
> 2007-02-08 10:38:58.89 server Failed to obtain
> TransactionDispenserInterface: Result Code = 0x8004d01b
> 2007-02-08 10:38:58.89 server Unable to load any NETLIBs. Server
> shutting down.
> 2007-02-08 10:38:58.89 spid4 Starting up database 'master'.
> The failure to obtain TransactionDispenserInterface message was
> occurring on the old machine, so I conclude that isn't part of the
> issue.
> The Server Network Utility does show TCP/IP as the only protocol
> enabled. The Network Libraries tab does show the TCP/IP SSNETLIB.DLL
> listed and that dll is residing in the expected location (C:\Program
> Files\Microsoft SQL Server\MSSQL\Binn).
> The service properties page page Log On tab shows the Local System
> Account to be used for logon.
> So, I'm figuring it can't find ssnetlib.dll. Short of uninstalling
> and re-installing SQL Server, how can I get my SQL Server back up and
> running?
> Thanks in advance
> Mark
>sql
Can't start the MSSQLServer Service
I just got a new laptop for work, and our local IT/Hardware guy used
PCMover from Laplink to migrate the apps and settings from my old
machine to this new one. I was skeptical, but it's actually worked
quite well, the biggest issue that I'm having is getting SQL Server to
run on the new machine.
Using SQL Server 2000. Both laptops are Windows XP Pro SP2.
After the migration, I did have to recreate the services for the
server and agent (those services weren't migrated):
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\scm.exe -action 5 -
service MSSQLServer -exepath "c:\Program Files\Microsoft SQL Server
\MSSQL\Binn\sqlservr.exe"
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\scm.exe -action 5 -
service SQLSERVERAGENT -exepath "c:\Program Files\Microsoft SQL Server
\MSSQL\Binn\sqlagent.exe" -dependencies MSSQLServer
If I don't include the SQL Server dependency on the SQL Agent, then
the Agent starts just fine. When I try to start the SQL Server
service, it displays a dialog error:
The MSSQLServer service on Local Computer started and then stopped.
Some Services stop automatically if they have no work to do, for
example, the Performance Logs and Alerts service.
Here's the contents of the server log:
2007-02-08 10:38:58.14 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
2007-02-08 10:38:58.14 server Copyright (C) 1988-2002 Microsoft
Corporation.
2007-02-08 10:38:58.14 server All rights reserved.
2007-02-08 10:38:58.14 server Server Process ID is 5860.
2007-02-08 10:38:58.14 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
2007-02-08 10:38:58.17 server SQL Server is starting at priority
class 'normal'(2 CPUs detected).
2007-02-08 10:38:58.84 server SQL Server configured for thread mode
processing.
2007-02-08 10:38:58.84 server Using dynamic lock allocation. [2500]
Lock Blocks, [5000] Lock Owner Blocks.
2007-02-08 10:38:58.87 server Attempting to initialize Distributed
Transaction Coordinator.
2007-02-08 10:38:58.89 server Failed to obtain
TransactionDispenserInterface: Result Code = 0x8004d01b
2007-02-08 10:38:58.89 server Unable to load any NETLIBs. Server
shutting down.
2007-02-08 10:38:58.89 spid4 Starting up database 'master'.
The failure to obtain TransactionDispenserInterface message was
occurring on the old machine, so I conclude that isn't part of the
issue.
The Server Network Utility does show TCP/IP as the only protocol
enabled. The Network Libraries tab does show the TCP/IP SSNETLIB.DLL
listed and that dll is residing in the expected location (C:\Program
Files\Microsoft SQL Server\MSSQL\Binn).
The service properties page page Log On tab shows the Local System
Account to be used for logon.
So, I'm figuring it can't find ssnetlib.dll. Short of uninstalling
and re-installing SQL Server, how can I get my SQL Server back up and
running?
Thanks in advance
Mark>I just got a new laptop for work, and our local IT/Hardware guy used
> PCMover from Laplink to migrate the apps and settings from my old
> machine to this new one. I was skeptical,
And you should have been. The errorlog clearly states that SQL Server cannot
load any netlibs, so it
refuses to start. I.e., the installation isn't OK...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<mark.a.lemoine@.gmail.com> wrote in message
news:1170950095.972400.293760@.s48g2000cws.googlegroups.com...
>I just got a new laptop for work, and our local IT/Hardware guy used
> PCMover from Laplink to migrate the apps and settings from my old
> machine to this new one. I was skeptical, but it's actually worked
> quite well, the biggest issue that I'm having is getting SQL Server to
> run on the new machine.
> Using SQL Server 2000. Both laptops are Windows XP Pro SP2.
> After the migration, I did have to recreate the services for the
> server and agent (those services weren't migrated):
> C:\Program Files\Microsoft SQL Server\80\Tools\Binn\scm.exe -action 5 -
> service MSSQLServer -exepath "c:\Program Files\Microsoft SQL Server
> \MSSQL\Binn\sqlservr.exe"
> C:\Program Files\Microsoft SQL Server\80\Tools\Binn\scm.exe -action 5 -
> service SQLSERVERAGENT -exepath "c:\Program Files\Microsoft SQL Server
> \MSSQL\Binn\sqlagent.exe" -dependencies MSSQLServer
> If I don't include the SQL Server dependency on the SQL Agent, then
> the Agent starts just fine. When I try to start the SQL Server
> service, it displays a dialog error:
> The MSSQLServer service on Local Computer started and then stopped.
> Some Services stop automatically if they have no work to do, for
> example, the Performance Logs and Alerts service.
> Here's the contents of the server log:
> 2007-02-08 10:38:58.14 server Microsoft SQL Server 2000 - 8.00.760
> (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
> 2007-02-08 10:38:58.14 server Copyright (C) 1988-2002 Microsoft
> Corporation.
> 2007-02-08 10:38:58.14 server All rights reserved.
> 2007-02-08 10:38:58.14 server Server Process ID is 5860.
> 2007-02-08 10:38:58.14 server Logging SQL Server messages in file
> 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
> 2007-02-08 10:38:58.17 server SQL Server is starting at priority
> class 'normal'(2 CPUs detected).
> 2007-02-08 10:38:58.84 server SQL Server configured for thread mode
> processing.
> 2007-02-08 10:38:58.84 server Using dynamic lock allocation. [2500]
> Lock Blocks, [5000] Lock Owner Blocks.
> 2007-02-08 10:38:58.87 server Attempting to initialize Distributed
> Transaction Coordinator.
> 2007-02-08 10:38:58.89 server Failed to obtain
> TransactionDispenserInterface: Result Code = 0x8004d01b
> 2007-02-08 10:38:58.89 server Unable to load any NETLIBs. Server
> shutting down.
> 2007-02-08 10:38:58.89 spid4 Starting up database 'master'.
> The failure to obtain TransactionDispenserInterface message was
> occurring on the old machine, so I conclude that isn't part of the
> issue.
> The Server Network Utility does show TCP/IP as the only protocol
> enabled. The Network Libraries tab does show the TCP/IP SSNETLIB.DLL
> listed and that dll is residing in the expected location (C:\Program
> Files\Microsoft SQL Server\MSSQL\Binn).
> The service properties page page Log On tab shows the Local System
> Account to be used for logon.
> So, I'm figuring it can't find ssnetlib.dll. Short of uninstalling
> and re-installing SQL Server, how can I get my SQL Server back up and
> running?
> Thanks in advance
> Mark
>
PCMover from Laplink to migrate the apps and settings from my old
machine to this new one. I was skeptical, but it's actually worked
quite well, the biggest issue that I'm having is getting SQL Server to
run on the new machine.
Using SQL Server 2000. Both laptops are Windows XP Pro SP2.
After the migration, I did have to recreate the services for the
server and agent (those services weren't migrated):
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\scm.exe -action 5 -
service MSSQLServer -exepath "c:\Program Files\Microsoft SQL Server
\MSSQL\Binn\sqlservr.exe"
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\scm.exe -action 5 -
service SQLSERVERAGENT -exepath "c:\Program Files\Microsoft SQL Server
\MSSQL\Binn\sqlagent.exe" -dependencies MSSQLServer
If I don't include the SQL Server dependency on the SQL Agent, then
the Agent starts just fine. When I try to start the SQL Server
service, it displays a dialog error:
The MSSQLServer service on Local Computer started and then stopped.
Some Services stop automatically if they have no work to do, for
example, the Performance Logs and Alerts service.
Here's the contents of the server log:
2007-02-08 10:38:58.14 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
2007-02-08 10:38:58.14 server Copyright (C) 1988-2002 Microsoft
Corporation.
2007-02-08 10:38:58.14 server All rights reserved.
2007-02-08 10:38:58.14 server Server Process ID is 5860.
2007-02-08 10:38:58.14 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
2007-02-08 10:38:58.17 server SQL Server is starting at priority
class 'normal'(2 CPUs detected).
2007-02-08 10:38:58.84 server SQL Server configured for thread mode
processing.
2007-02-08 10:38:58.84 server Using dynamic lock allocation. [2500]
Lock Blocks, [5000] Lock Owner Blocks.
2007-02-08 10:38:58.87 server Attempting to initialize Distributed
Transaction Coordinator.
2007-02-08 10:38:58.89 server Failed to obtain
TransactionDispenserInterface: Result Code = 0x8004d01b
2007-02-08 10:38:58.89 server Unable to load any NETLIBs. Server
shutting down.
2007-02-08 10:38:58.89 spid4 Starting up database 'master'.
The failure to obtain TransactionDispenserInterface message was
occurring on the old machine, so I conclude that isn't part of the
issue.
The Server Network Utility does show TCP/IP as the only protocol
enabled. The Network Libraries tab does show the TCP/IP SSNETLIB.DLL
listed and that dll is residing in the expected location (C:\Program
Files\Microsoft SQL Server\MSSQL\Binn).
The service properties page page Log On tab shows the Local System
Account to be used for logon.
So, I'm figuring it can't find ssnetlib.dll. Short of uninstalling
and re-installing SQL Server, how can I get my SQL Server back up and
running?
Thanks in advance
Mark>I just got a new laptop for work, and our local IT/Hardware guy used
> PCMover from Laplink to migrate the apps and settings from my old
> machine to this new one. I was skeptical,
And you should have been. The errorlog clearly states that SQL Server cannot
load any netlibs, so it
refuses to start. I.e., the installation isn't OK...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<mark.a.lemoine@.gmail.com> wrote in message
news:1170950095.972400.293760@.s48g2000cws.googlegroups.com...
>I just got a new laptop for work, and our local IT/Hardware guy used
> PCMover from Laplink to migrate the apps and settings from my old
> machine to this new one. I was skeptical, but it's actually worked
> quite well, the biggest issue that I'm having is getting SQL Server to
> run on the new machine.
> Using SQL Server 2000. Both laptops are Windows XP Pro SP2.
> After the migration, I did have to recreate the services for the
> server and agent (those services weren't migrated):
> C:\Program Files\Microsoft SQL Server\80\Tools\Binn\scm.exe -action 5 -
> service MSSQLServer -exepath "c:\Program Files\Microsoft SQL Server
> \MSSQL\Binn\sqlservr.exe"
> C:\Program Files\Microsoft SQL Server\80\Tools\Binn\scm.exe -action 5 -
> service SQLSERVERAGENT -exepath "c:\Program Files\Microsoft SQL Server
> \MSSQL\Binn\sqlagent.exe" -dependencies MSSQLServer
> If I don't include the SQL Server dependency on the SQL Agent, then
> the Agent starts just fine. When I try to start the SQL Server
> service, it displays a dialog error:
> The MSSQLServer service on Local Computer started and then stopped.
> Some Services stop automatically if they have no work to do, for
> example, the Performance Logs and Alerts service.
> Here's the contents of the server log:
> 2007-02-08 10:38:58.14 server Microsoft SQL Server 2000 - 8.00.760
> (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
> 2007-02-08 10:38:58.14 server Copyright (C) 1988-2002 Microsoft
> Corporation.
> 2007-02-08 10:38:58.14 server All rights reserved.
> 2007-02-08 10:38:58.14 server Server Process ID is 5860.
> 2007-02-08 10:38:58.14 server Logging SQL Server messages in file
> 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
> 2007-02-08 10:38:58.17 server SQL Server is starting at priority
> class 'normal'(2 CPUs detected).
> 2007-02-08 10:38:58.84 server SQL Server configured for thread mode
> processing.
> 2007-02-08 10:38:58.84 server Using dynamic lock allocation. [2500]
> Lock Blocks, [5000] Lock Owner Blocks.
> 2007-02-08 10:38:58.87 server Attempting to initialize Distributed
> Transaction Coordinator.
> 2007-02-08 10:38:58.89 server Failed to obtain
> TransactionDispenserInterface: Result Code = 0x8004d01b
> 2007-02-08 10:38:58.89 server Unable to load any NETLIBs. Server
> shutting down.
> 2007-02-08 10:38:58.89 spid4 Starting up database 'master'.
> The failure to obtain TransactionDispenserInterface message was
> occurring on the old machine, so I conclude that isn't part of the
> issue.
> The Server Network Utility does show TCP/IP as the only protocol
> enabled. The Network Libraries tab does show the TCP/IP SSNETLIB.DLL
> listed and that dll is residing in the expected location (C:\Program
> Files\Microsoft SQL Server\MSSQL\Binn).
> The service properties page page Log On tab shows the Local System
> Account to be used for logon.
> So, I'm figuring it can't find ssnetlib.dll. Short of uninstalling
> and re-installing SQL Server, how can I get my SQL Server back up and
> running?
> Thanks in advance
> Mark
>
Can't start SQL Server Agent - wants MSSQLServerADHelper
When I try to start the SQL Server Agent service, it gives an error about
starting MSSQLServerADHelper.
When I look in the event log, it says:
The MSSQLServerADHelper service terminated with service-specific error
3221225572.
How can I get SQL Server Agent started? I had maintenance tasks scheduled
(backup, etc.) that now will not run.Are you sure that it is Agent who writes this error?
Check the Agent errorlog for error messages.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"JJ" <jjjj@.nospam.com> wrote in message news:eBOIaBurDHA.2244@.TK2MSFTNGP09.phx.gbl...
> When I try to start the SQL Server Agent service, it gives an error about
> starting MSSQLServerADHelper.
> When I look in the event log, it says:
> The MSSQLServerADHelper service terminated with service-specific error
> 3221225572.
> How can I get SQL Server Agent started? I had maintenance tasks scheduled
> (backup, etc.) that now will not run.
>|||I am positive that this is what occurs:
In the Services Control Panel applet, the SQL Server Agent service is
stopped. (It had been running on this system up until a few weeks ago -
this is a customer system, so I didn't know it stopped until now.)
When I right-click on SQL Server Agent and choose Start, that's when I get
the error on the screen that MSSQLServerADHelper could not be started.
But I think I have found the problem - it looks like someone there changed
SQL Server Agent to run in a specific account. I changed it to run as Local
System and then I could start it.
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
wrote in message news:%23dILAtzrDHA.1764@.TK2MSFTNGP10.phx.gbl...
> Are you sure that it is Agent who writes this error?
> Check the Agent errorlog for error messages.
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
>
> "JJ" <jjjj@.nospam.com> wrote in message
news:eBOIaBurDHA.2244@.TK2MSFTNGP09.phx.gbl...
> > When I try to start the SQL Server Agent service, it gives an error
about
> > starting MSSQLServerADHelper.
> >
> > When I look in the event log, it says:
> >
> > The MSSQLServerADHelper service terminated with service-specific error
> > 3221225572.
> >
> > How can I get SQL Server Agent started? I had maintenance tasks
scheduled
> > (backup, etc.) that now will not run.
> >
> >
>|||The startup account that they changed it to most likely
didn't have permissions to start the MSSQLServerADHelper
service.
-Sue
On Thu, 20 Nov 2003 09:19:49 -0500, "JJ" <jjjj@.nospam.com>
wrote:
>I am positive that this is what occurs:
>In the Services Control Panel applet, the SQL Server Agent service is
>stopped. (It had been running on this system up until a few weeks ago -
>this is a customer system, so I didn't know it stopped until now.)
>When I right-click on SQL Server Agent and choose Start, that's when I get
>the error on the screen that MSSQLServerADHelper could not be started.
>But I think I have found the problem - it looks like someone there changed
>SQL Server Agent to run in a specific account. I changed it to run as Local
>System and then I could start it.
>
>"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
>wrote in message news:%23dILAtzrDHA.1764@.TK2MSFTNGP10.phx.gbl...
>> Are you sure that it is Agent who writes this error?
>> Check the Agent errorlog for error messages.
>> --
>> Tibor Karaszi, SQL Server MVP
>> Archive at:
>http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
>>
>> "JJ" <jjjj@.nospam.com> wrote in message
>news:eBOIaBurDHA.2244@.TK2MSFTNGP09.phx.gbl...
>> > When I try to start the SQL Server Agent service, it gives an error
>about
>> > starting MSSQLServerADHelper.
>> >
>> > When I look in the event log, it says:
>> >
>> > The MSSQLServerADHelper service terminated with service-specific error
>> > 3221225572.
>> >
>> > How can I get SQL Server Agent started? I had maintenance tasks
>scheduled
>> > (backup, etc.) that now will not run.
>> >
>> >
>>
>|||Hi JJ,
Thank you for using MSDN Newsgroup! It's my pleasure to assist you with
your issue.
MSSQLServerADHelper is a service installed by the SQL Server Setup program
that handles the Active Directory objects for all instances of the SQL
Server relational database engine and all Analysis Manager applications
that are running on the computer. There is only one MSSQLServerADHelper
service on a computer for all of the instances of Microsoft SQL Server
2000. This service is set to use the Local System Account by default.
This error only happens only if someone or some service tried to start the
service manually. It's possible that some "monitoring service" would
attempt to start a service if it identified that the service was not
started/running. If you check for such a service and make sure to remove
MSSQLServerADHelper service from it list of service to watch.
To avoid seeing this message again, you should not set the service to start
automatically. You can change this service to manually by
Start->Programs->Administrative tools->Services", find the
"MSSQLServerADHelper" in the list of services and change the property of
it. You right click the "MSSQLServerADHelper" and choose the "properties"
from the menu. Please check and see if the service MSSQLServerADHelper has
"Interact with the desktop" checked in the properties, if yes, then please
uncheck that. Also set the service to manual.
After the above steps are complete let me know if the event logs still get
the error.
I hope my information will help you to solve your problem. Please feel free
to post new information here and I am ready to provide further support.
Sincerely Yours
Baisong, Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.
--
| From: "JJ" <jjjj@.nospam.com>
| Subject: Can't start SQL Server Agent - wants MSSQLServerADHelper
| Date: Wed, 19 Nov 2003 16:01:48 -0500
| Lines: 12
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <eBOIaBurDHA.2244@.TK2MSFTNGP09.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: 146.145.51.166
| Path:
cpmsftngxa07.phx.gbl!cpmsftngxa10.phx.gbl!TK2MSFTNGXA05.phx.gbl!TK2MSFTNGP08|||I am unable to start the service after following the steps mentioned and it is showing the same error in the event log
From http://www.developmentnow.com/g/118_2003_11_0_0_465849/Cant-start-SQL-Server-Agent--wants-MSSQLServerADHelper.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com|||Hi
Have tou tried to use the local system account and/or start the service from
SQL Server Service Manager or through enterprise manager? What does the SQL
Agent log file contain?
John
"prashanthi" wrote:
> I am unable to start the service after following the steps mentioned and it is showing the same error in the event log.
> From http://www.developmentnow.com/g/118_2003_11_0_0_465849/Cant-start-SQL-Server-Agent--wants-MSSQLServerADHelper.htm
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com
>
starting MSSQLServerADHelper.
When I look in the event log, it says:
The MSSQLServerADHelper service terminated with service-specific error
3221225572.
How can I get SQL Server Agent started? I had maintenance tasks scheduled
(backup, etc.) that now will not run.Are you sure that it is Agent who writes this error?
Check the Agent errorlog for error messages.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"JJ" <jjjj@.nospam.com> wrote in message news:eBOIaBurDHA.2244@.TK2MSFTNGP09.phx.gbl...
> When I try to start the SQL Server Agent service, it gives an error about
> starting MSSQLServerADHelper.
> When I look in the event log, it says:
> The MSSQLServerADHelper service terminated with service-specific error
> 3221225572.
> How can I get SQL Server Agent started? I had maintenance tasks scheduled
> (backup, etc.) that now will not run.
>|||I am positive that this is what occurs:
In the Services Control Panel applet, the SQL Server Agent service is
stopped. (It had been running on this system up until a few weeks ago -
this is a customer system, so I didn't know it stopped until now.)
When I right-click on SQL Server Agent and choose Start, that's when I get
the error on the screen that MSSQLServerADHelper could not be started.
But I think I have found the problem - it looks like someone there changed
SQL Server Agent to run in a specific account. I changed it to run as Local
System and then I could start it.
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
wrote in message news:%23dILAtzrDHA.1764@.TK2MSFTNGP10.phx.gbl...
> Are you sure that it is Agent who writes this error?
> Check the Agent errorlog for error messages.
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
>
> "JJ" <jjjj@.nospam.com> wrote in message
news:eBOIaBurDHA.2244@.TK2MSFTNGP09.phx.gbl...
> > When I try to start the SQL Server Agent service, it gives an error
about
> > starting MSSQLServerADHelper.
> >
> > When I look in the event log, it says:
> >
> > The MSSQLServerADHelper service terminated with service-specific error
> > 3221225572.
> >
> > How can I get SQL Server Agent started? I had maintenance tasks
scheduled
> > (backup, etc.) that now will not run.
> >
> >
>|||The startup account that they changed it to most likely
didn't have permissions to start the MSSQLServerADHelper
service.
-Sue
On Thu, 20 Nov 2003 09:19:49 -0500, "JJ" <jjjj@.nospam.com>
wrote:
>I am positive that this is what occurs:
>In the Services Control Panel applet, the SQL Server Agent service is
>stopped. (It had been running on this system up until a few weeks ago -
>this is a customer system, so I didn't know it stopped until now.)
>When I right-click on SQL Server Agent and choose Start, that's when I get
>the error on the screen that MSSQLServerADHelper could not be started.
>But I think I have found the problem - it looks like someone there changed
>SQL Server Agent to run in a specific account. I changed it to run as Local
>System and then I could start it.
>
>"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
>wrote in message news:%23dILAtzrDHA.1764@.TK2MSFTNGP10.phx.gbl...
>> Are you sure that it is Agent who writes this error?
>> Check the Agent errorlog for error messages.
>> --
>> Tibor Karaszi, SQL Server MVP
>> Archive at:
>http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
>>
>> "JJ" <jjjj@.nospam.com> wrote in message
>news:eBOIaBurDHA.2244@.TK2MSFTNGP09.phx.gbl...
>> > When I try to start the SQL Server Agent service, it gives an error
>about
>> > starting MSSQLServerADHelper.
>> >
>> > When I look in the event log, it says:
>> >
>> > The MSSQLServerADHelper service terminated with service-specific error
>> > 3221225572.
>> >
>> > How can I get SQL Server Agent started? I had maintenance tasks
>scheduled
>> > (backup, etc.) that now will not run.
>> >
>> >
>>
>|||Hi JJ,
Thank you for using MSDN Newsgroup! It's my pleasure to assist you with
your issue.
MSSQLServerADHelper is a service installed by the SQL Server Setup program
that handles the Active Directory objects for all instances of the SQL
Server relational database engine and all Analysis Manager applications
that are running on the computer. There is only one MSSQLServerADHelper
service on a computer for all of the instances of Microsoft SQL Server
2000. This service is set to use the Local System Account by default.
This error only happens only if someone or some service tried to start the
service manually. It's possible that some "monitoring service" would
attempt to start a service if it identified that the service was not
started/running. If you check for such a service and make sure to remove
MSSQLServerADHelper service from it list of service to watch.
To avoid seeing this message again, you should not set the service to start
automatically. You can change this service to manually by
Start->Programs->Administrative tools->Services", find the
"MSSQLServerADHelper" in the list of services and change the property of
it. You right click the "MSSQLServerADHelper" and choose the "properties"
from the menu. Please check and see if the service MSSQLServerADHelper has
"Interact with the desktop" checked in the properties, if yes, then please
uncheck that. Also set the service to manual.
After the above steps are complete let me know if the event logs still get
the error.
I hope my information will help you to solve your problem. Please feel free
to post new information here and I am ready to provide further support.
Sincerely Yours
Baisong, Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.
--
| From: "JJ" <jjjj@.nospam.com>
| Subject: Can't start SQL Server Agent - wants MSSQLServerADHelper
| Date: Wed, 19 Nov 2003 16:01:48 -0500
| Lines: 12
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <eBOIaBurDHA.2244@.TK2MSFTNGP09.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: 146.145.51.166
| Path:
cpmsftngxa07.phx.gbl!cpmsftngxa10.phx.gbl!TK2MSFTNGXA05.phx.gbl!TK2MSFTNGP08|||I am unable to start the service after following the steps mentioned and it is showing the same error in the event log
From http://www.developmentnow.com/g/118_2003_11_0_0_465849/Cant-start-SQL-Server-Agent--wants-MSSQLServerADHelper.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com|||Hi
Have tou tried to use the local system account and/or start the service from
SQL Server Service Manager or through enterprise manager? What does the SQL
Agent log file contain?
John
"prashanthi" wrote:
> I am unable to start the service after following the steps mentioned and it is showing the same error in the event log.
> From http://www.developmentnow.com/g/118_2003_11_0_0_465849/Cant-start-SQL-Server-Agent--wants-MSSQLServerADHelper.htm
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com
>
Can't start SQL Server Agent
Hello,
When I try to start SQL Server Agent I get a message "An error 1049 - (The
service did not start due to a logon failure) while performing this service
operation on the SQLServerAgent service."
I am logged on to the machine as Administrator and SQL Server has a login
for Servername\Administrator.
I can perform data manipulation operations with no problems. I have not had
this problem on other servers before.
Any help would be appreciated.
RagnarHello,
Go to the COntrol Panel, Services, SQL Server Agent -- Go to Logon option
and chnage it to Local System Account and try restarting.
If it works fine then use a domain account and specify the password and
restrt the service.
I recommend you to start SQL Server and SQL Server Agent using the same
login account.
Thanks
Hari
"Ragnar Midtskogen" <ragnar_ng@.newsgroups.com> wrote in message
news:%23EzZ4wQYHHA.588@.TK2MSFTNGP06.phx.gbl...
> Hello,
> When I try to start SQL Server Agent I get a message "An error 1049 - (The
> service did not start due to a logon failure) while performing this
> service operation on the SQLServerAgent service."
> I am logged on to the machine as Administrator and SQL Server has a login
> for Servername\Administrator.
> I can perform data manipulation operations with no problems. I have not
> had this problem on other servers before.
> Any help would be appreciated.
> Ragnar
>|||Thank you Hari,
The logon was set as Administrator, so I just reset the password and that
solved the problem.
By the way, the SQL Server Agent properties shows startup account as being
Administrator and it also shows that the connection should use Windows
authentication.
I am a little confused as to what the difference is between the startup and
the connect properties, but as long as it works I am happy.
Ragnarsql
When I try to start SQL Server Agent I get a message "An error 1049 - (The
service did not start due to a logon failure) while performing this service
operation on the SQLServerAgent service."
I am logged on to the machine as Administrator and SQL Server has a login
for Servername\Administrator.
I can perform data manipulation operations with no problems. I have not had
this problem on other servers before.
Any help would be appreciated.
RagnarHello,
Go to the COntrol Panel, Services, SQL Server Agent -- Go to Logon option
and chnage it to Local System Account and try restarting.
If it works fine then use a domain account and specify the password and
restrt the service.
I recommend you to start SQL Server and SQL Server Agent using the same
login account.
Thanks
Hari
"Ragnar Midtskogen" <ragnar_ng@.newsgroups.com> wrote in message
news:%23EzZ4wQYHHA.588@.TK2MSFTNGP06.phx.gbl...
> Hello,
> When I try to start SQL Server Agent I get a message "An error 1049 - (The
> service did not start due to a logon failure) while performing this
> service operation on the SQLServerAgent service."
> I am logged on to the machine as Administrator and SQL Server has a login
> for Servername\Administrator.
> I can perform data manipulation operations with no problems. I have not
> had this problem on other servers before.
> Any help would be appreciated.
> Ragnar
>|||Thank you Hari,
The logon was set as Administrator, so I just reset the password and that
solved the problem.
By the way, the SQL Server Agent properties shows startup account as being
Administrator and it also shows that the connection should use Windows
authentication.
I am a little confused as to what the difference is between the startup and
the connect properties, but as long as it works I am happy.
Ragnarsql
Can't start SQL on 2005 Cluster
The SQL Server (MSSQLSERVER) service terminated with service-specific error
3417 (0xD59).
This is what I get on my 2005 Cluster when I try to start SQL on one of the
nodes. Another node is running fine, no problems what so ever.
Please help...Check out:
http://msdn2.microsoft.com/en-us/library/aa337262.aspx
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
.
"Leon Shargorodsky" <LeonShargorodsky@.discussions.microsoft.com> wrote in
message news:185F94E0-9E8E-4048-A25B-7311CCDC9D96@.microsoft.com...
The SQL Server (MSSQLSERVER) service terminated with service-specific error
3417 (0xD59).
This is what I get on my 2005 Cluster when I try to start SQL on one of the
nodes. Another node is running fine, no problems what so ever.
Please help...|||I've found that a good way to inadvertently generate this error is to compre
ss the files on the drive that your instance is running on - not to be recom
mended as a rule.
When you attempt to start the instance the System event log gives the servic
e specific error 3417 as you've seen.
The Application event log was a bit more useful for me - "The file "D:\Progr
am Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf" is compressed b
ut does not reside in a read-only database or filegroup. The file must be de
compressed."
I decompressed the files and the service started fine - something to conside
r.
Mark
From http://www.developmentnow.com/g/118...>
-Cluster.htm
Posted via DevelopmentNow.com Groups
http://www.developmentnow.com
3417 (0xD59).
This is what I get on my 2005 Cluster when I try to start SQL on one of the
nodes. Another node is running fine, no problems what so ever.
Please help...Check out:
http://msdn2.microsoft.com/en-us/library/aa337262.aspx
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
.
"Leon Shargorodsky" <LeonShargorodsky@.discussions.microsoft.com> wrote in
message news:185F94E0-9E8E-4048-A25B-7311CCDC9D96@.microsoft.com...
The SQL Server (MSSQLSERVER) service terminated with service-specific error
3417 (0xD59).
This is what I get on my 2005 Cluster when I try to start SQL on one of the
nodes. Another node is running fine, no problems what so ever.
Please help...|||I've found that a good way to inadvertently generate this error is to compre
ss the files on the drive that your instance is running on - not to be recom
mended as a rule.
When you attempt to start the instance the System event log gives the servic
e specific error 3417 as you've seen.
The Application event log was a bit more useful for me - "The file "D:\Progr
am Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf" is compressed b
ut does not reside in a read-only database or filegroup. The file must be de
compressed."
I decompressed the files and the service started fine - something to conside
r.
Mark
From http://www.developmentnow.com/g/118...>
-Cluster.htm
Posted via DevelopmentNow.com Groups
http://www.developmentnow.com
Can't start SQL on 2005 Cluster
The SQL Server (MSSQLSERVER) service terminated with service-specific error
3417 (0xD59).
This is what I get on my 2005 Cluster when I try to start SQL on one of the
nodes. Another node is running fine, no problems what so ever.
Please help...Check out:
http://msdn2.microsoft.com/en-us/library/aa337262.aspx
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
.
"Leon Shargorodsky" <LeonShargorodsky@.discussions.microsoft.com> wrote in
message news:185F94E0-9E8E-4048-A25B-7311CCDC9D96@.microsoft.com...
The SQL Server (MSSQLSERVER) service terminated with service-specific error
3417 (0xD59).
This is what I get on my 2005 Cluster when I try to start SQL on one of the
nodes. Another node is running fine, no problems what so ever.
Please help...|||I've found that a good way to inadvertently generate this error is to compress the files on the drive that your instance is running on - not to be recommended as a rule.
When you attempt to start the instance the System event log gives the service specific error 3417 as you've seen.
The Application event log was a bit more useful for me - "The file "D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed."
I decompressed the files and the service started fine - something to consider.
Mar
From http://www.developmentnow.com/g/118_2006_10_0_0_840331/Cant-start-SQL-on-2005-Cluster.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com|||thanks for upstai
From http://www.developmentnow.com/g/118_2006_10_0_0_840331/Cant-start-SQL-on-2005-Cluster.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com
3417 (0xD59).
This is what I get on my 2005 Cluster when I try to start SQL on one of the
nodes. Another node is running fine, no problems what so ever.
Please help...Check out:
http://msdn2.microsoft.com/en-us/library/aa337262.aspx
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
.
"Leon Shargorodsky" <LeonShargorodsky@.discussions.microsoft.com> wrote in
message news:185F94E0-9E8E-4048-A25B-7311CCDC9D96@.microsoft.com...
The SQL Server (MSSQLSERVER) service terminated with service-specific error
3417 (0xD59).
This is what I get on my 2005 Cluster when I try to start SQL on one of the
nodes. Another node is running fine, no problems what so ever.
Please help...|||I've found that a good way to inadvertently generate this error is to compress the files on the drive that your instance is running on - not to be recommended as a rule.
When you attempt to start the instance the System event log gives the service specific error 3417 as you've seen.
The Application event log was a bit more useful for me - "The file "D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed."
I decompressed the files and the service started fine - something to consider.
Mar
From http://www.developmentnow.com/g/118_2006_10_0_0_840331/Cant-start-SQL-on-2005-Cluster.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com|||thanks for upstai
From http://www.developmentnow.com/g/118_2006_10_0_0_840331/Cant-start-SQL-on-2005-Cluster.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com
Can't start sql agent
Hi there,
I install SQL server 2000 in Win 2000 server with SQL SP3
and Win 2000 SP4.
The SQL is default instance and use local system as
service startup account.
Currently I change the startup services account from local
system to domain user account.
SQL Server success start but the sql agant no! I don't
know why? I check the error message - it say cannot
connect local server.
Now I change back the sql agent startup agent to local
system but it still can't start!!
Please help cause I need SQL agent!!
ThanksMay be that the BUILTIN\Administrators group was dropped from SQL Server. If
so, recreate it.
--
Sérgio Monteiro - Brasil
www.sqlpass.org
"Chai" <wingschai@.hotmail.com> escreveu na mensagem
news:082a01c38a25$78aa36f0$a401280a@.phx.gbl...
> Hi there,
> I install SQL server 2000 in Win 2000 server with SQL SP3
> and Win 2000 SP4.
> The SQL is default instance and use local system as
> service startup account.
> Currently I change the startup services account from local
> system to domain user account.
> SQL Server success start but the sql agant no! I don't
> know why? I check the error message - it say cannot
> connect local server.
> Now I change back the sql agent startup agent to local
> system but it still can't start!!
> Please help cause I need SQL agent!!
> Thanks|||I'd check what the SQL Server instance is listening on. In the errorlog, you
should find entries similar to the following:
2003-10-03 20:45:28.95 server SQL server listening on 67.83.16.85: 1058.
2003-10-03 20:45:28.95 server SQL server listening on 127.0.0.1: 1058.
2003-10-03 20:45:32.49 server SQL server listening on TCP, Shared Memory,
Named Pipes.
Also, you may want to log into the SQL Server box with the SQL Agent account
and try osql -S<ServerName> -E from the command line.
--
Linchi Shea
linchi_shea@.NOSPAMml.com
"Chai" <wingschai@.hotmail.com> wrote in message
news:082a01c38a25$78aa36f0$a401280a@.phx.gbl...
> Hi there,
> I install SQL server 2000 in Win 2000 server with SQL SP3
> and Win 2000 SP4.
> The SQL is default instance and use local system as
> service startup account.
> Currently I change the startup services account from local
> system to domain user account.
> SQL Server success start but the sql agant no! I don't
> know why? I check the error message - it say cannot
> connect local server.
> Now I change back the sql agent startup agent to local
> system but it still can't start!!
> Please help cause I need SQL agent!!
> Thanks|||If I'm not mistaken, a different error (other than cannot connect to local
server) would be issued if you drop BUILTIN\Administrators from SQL Server
and then try to start SQLServerAgent.
By the way, SQL Server Agent log file SQLAgent.out may contain useful info.
--
Linchi Shea
linchi_shea@.NOSPAMml.com
"Sérgio Monteiro" <shsmonteiro@.horizon.com.br> wrote in message
news:ucRO6piiDHA.3204@.TK2MSFTNGP11.phx.gbl...
> May be that the BUILTIN\Administrators group was dropped from SQL Server.
If
> so, recreate it.
> --
> Sérgio Monteiro - Brasil
> www.sqlpass.org
> "Chai" <wingschai@.hotmail.com> escreveu na mensagem
> news:082a01c38a25$78aa36f0$a401280a@.phx.gbl...
> > Hi there,
> >
> > I install SQL server 2000 in Win 2000 server with SQL SP3
> > and Win 2000 SP4.
> >
> > The SQL is default instance and use local system as
> > service startup account.
> >
> > Currently I change the startup services account from local
> > system to domain user account.
> >
> > SQL Server success start but the sql agant no! I don't
> > know why? I check the error message - it say cannot
> > connect local server.
> >
> > Now I change back the sql agent startup agent to local
> > system but it still can't start!!
> >
> > Please help cause I need SQL agent!!
> >
> > Thanks
>|||You're right. The exact message is "SQLServerAgent could not be started
(reason: SQLServerAgent must be able to
connect to SQLServer as SysAdmin, but '(Unknown)' is not a member of the
SysAdmin role). "
But I remember one situation in which I faced this issue and somebody had
dropped the BUILTIN\Administrators. May be I'm confusing the situations.
Sérgio Monteiro - Brasil
www.sqlpass.org
"Linchi Shea" <linchi_shea@.NOSPAMml.com> escreveu na mensagem
news:#kncH4iiDHA.1692@.TK2MSFTNGP10.phx.gbl...
> If I'm not mistaken, a different error (other than cannot connect to local
> server) would be issued if you drop BUILTIN\Administrators from SQL Server
> and then try to start SQLServerAgent.
> By the way, SQL Server Agent log file SQLAgent.out may contain useful
info.
> --
> Linchi Shea
> linchi_shea@.NOSPAMml.com
>
> "Sérgio Monteiro" <shsmonteiro@.horizon.com.br> wrote in message
> news:ucRO6piiDHA.3204@.TK2MSFTNGP11.phx.gbl...
> > May be that the BUILTIN\Administrators group was dropped from SQL
Server.
> If
> > so, recreate it.
> >
> > --
> > Sérgio Monteiro - Brasil
> > www.sqlpass.org
> > "Chai" <wingschai@.hotmail.com> escreveu na mensagem
> > news:082a01c38a25$78aa36f0$a401280a@.phx.gbl...
> > > Hi there,
> > >
> > > I install SQL server 2000 in Win 2000 server with SQL SP3
> > > and Win 2000 SP4.
> > >
> > > The SQL is default instance and use local system as
> > > service startup account.
> > >
> > > Currently I change the startup services account from local
> > > system to domain user account.
> > >
> > > SQL Server success start but the sql agant no! I don't
> > > know why? I check the error message - it say cannot
> > > connect local server.
> > >
> > > Now I change back the sql agent startup agent to local
> > > system but it still can't start!!
> > >
> > > Please help cause I need SQL agent!!
> > >
> > > Thanks
> >
> >
>
I install SQL server 2000 in Win 2000 server with SQL SP3
and Win 2000 SP4.
The SQL is default instance and use local system as
service startup account.
Currently I change the startup services account from local
system to domain user account.
SQL Server success start but the sql agant no! I don't
know why? I check the error message - it say cannot
connect local server.
Now I change back the sql agent startup agent to local
system but it still can't start!!
Please help cause I need SQL agent!!
ThanksMay be that the BUILTIN\Administrators group was dropped from SQL Server. If
so, recreate it.
--
Sérgio Monteiro - Brasil
www.sqlpass.org
"Chai" <wingschai@.hotmail.com> escreveu na mensagem
news:082a01c38a25$78aa36f0$a401280a@.phx.gbl...
> Hi there,
> I install SQL server 2000 in Win 2000 server with SQL SP3
> and Win 2000 SP4.
> The SQL is default instance and use local system as
> service startup account.
> Currently I change the startup services account from local
> system to domain user account.
> SQL Server success start but the sql agant no! I don't
> know why? I check the error message - it say cannot
> connect local server.
> Now I change back the sql agent startup agent to local
> system but it still can't start!!
> Please help cause I need SQL agent!!
> Thanks|||I'd check what the SQL Server instance is listening on. In the errorlog, you
should find entries similar to the following:
2003-10-03 20:45:28.95 server SQL server listening on 67.83.16.85: 1058.
2003-10-03 20:45:28.95 server SQL server listening on 127.0.0.1: 1058.
2003-10-03 20:45:32.49 server SQL server listening on TCP, Shared Memory,
Named Pipes.
Also, you may want to log into the SQL Server box with the SQL Agent account
and try osql -S<ServerName> -E from the command line.
--
Linchi Shea
linchi_shea@.NOSPAMml.com
"Chai" <wingschai@.hotmail.com> wrote in message
news:082a01c38a25$78aa36f0$a401280a@.phx.gbl...
> Hi there,
> I install SQL server 2000 in Win 2000 server with SQL SP3
> and Win 2000 SP4.
> The SQL is default instance and use local system as
> service startup account.
> Currently I change the startup services account from local
> system to domain user account.
> SQL Server success start but the sql agant no! I don't
> know why? I check the error message - it say cannot
> connect local server.
> Now I change back the sql agent startup agent to local
> system but it still can't start!!
> Please help cause I need SQL agent!!
> Thanks|||If I'm not mistaken, a different error (other than cannot connect to local
server) would be issued if you drop BUILTIN\Administrators from SQL Server
and then try to start SQLServerAgent.
By the way, SQL Server Agent log file SQLAgent.out may contain useful info.
--
Linchi Shea
linchi_shea@.NOSPAMml.com
"Sérgio Monteiro" <shsmonteiro@.horizon.com.br> wrote in message
news:ucRO6piiDHA.3204@.TK2MSFTNGP11.phx.gbl...
> May be that the BUILTIN\Administrators group was dropped from SQL Server.
If
> so, recreate it.
> --
> Sérgio Monteiro - Brasil
> www.sqlpass.org
> "Chai" <wingschai@.hotmail.com> escreveu na mensagem
> news:082a01c38a25$78aa36f0$a401280a@.phx.gbl...
> > Hi there,
> >
> > I install SQL server 2000 in Win 2000 server with SQL SP3
> > and Win 2000 SP4.
> >
> > The SQL is default instance and use local system as
> > service startup account.
> >
> > Currently I change the startup services account from local
> > system to domain user account.
> >
> > SQL Server success start but the sql agant no! I don't
> > know why? I check the error message - it say cannot
> > connect local server.
> >
> > Now I change back the sql agent startup agent to local
> > system but it still can't start!!
> >
> > Please help cause I need SQL agent!!
> >
> > Thanks
>|||You're right. The exact message is "SQLServerAgent could not be started
(reason: SQLServerAgent must be able to
connect to SQLServer as SysAdmin, but '(Unknown)' is not a member of the
SysAdmin role). "
But I remember one situation in which I faced this issue and somebody had
dropped the BUILTIN\Administrators. May be I'm confusing the situations.
Sérgio Monteiro - Brasil
www.sqlpass.org
"Linchi Shea" <linchi_shea@.NOSPAMml.com> escreveu na mensagem
news:#kncH4iiDHA.1692@.TK2MSFTNGP10.phx.gbl...
> If I'm not mistaken, a different error (other than cannot connect to local
> server) would be issued if you drop BUILTIN\Administrators from SQL Server
> and then try to start SQLServerAgent.
> By the way, SQL Server Agent log file SQLAgent.out may contain useful
info.
> --
> Linchi Shea
> linchi_shea@.NOSPAMml.com
>
> "Sérgio Monteiro" <shsmonteiro@.horizon.com.br> wrote in message
> news:ucRO6piiDHA.3204@.TK2MSFTNGP11.phx.gbl...
> > May be that the BUILTIN\Administrators group was dropped from SQL
Server.
> If
> > so, recreate it.
> >
> > --
> > Sérgio Monteiro - Brasil
> > www.sqlpass.org
> > "Chai" <wingschai@.hotmail.com> escreveu na mensagem
> > news:082a01c38a25$78aa36f0$a401280a@.phx.gbl...
> > > Hi there,
> > >
> > > I install SQL server 2000 in Win 2000 server with SQL SP3
> > > and Win 2000 SP4.
> > >
> > > The SQL is default instance and use local system as
> > > service startup account.
> > >
> > > Currently I change the startup services account from local
> > > system to domain user account.
> > >
> > > SQL Server success start but the sql agant no! I don't
> > > know why? I check the error message - it say cannot
> > > connect local server.
> > >
> > > Now I change back the sql agent startup agent to local
> > > system but it still can't start!!
> > >
> > > Please help cause I need SQL agent!!
> > >
> > > Thanks
> >
> >
>
can't start sql 2005 service
Hi guys, I have sql 2005 beta 2 installed.. It used to work before, toda
y I try to start the service, it said following messages.
I use local system account, my other instance sql 2000 can start, I think
it's only YUKON problem, I do not know how to troubleshoot this error.
Can you guys help? Thanks a lot!!Have you checked the SQL Server 2005 error log?
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Britney" <britneychen_2001@.yahoo.com> wrote in message news:urW5U81oFHA.303
6@.TK2MSFTNGP14.phx.gbl...
Hi guys, I have sql 2005 beta 2 installed.. It used to work before, today
I try to start the service, it said following messages.
I use local system account, my other instance sql 2000 can start, I think
it's only YUKON problem, I do not know how to troubleshoot this error.
Can you guys help? Thanks a lot!!|||where do I look for the log?
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message news:%23F
eit92oFHA.3304@.tk2msftngp13.phx.gbl...
Have you checked the SQL Server 2005 error log?
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Britney" <britneychen_2001@.yahoo.com> wrote in message news:urW5U81oFHA.303
6@.TK2MSFTNGP14.phx.gbl...
Hi guys, I have sql 2005 beta 2 installed.. It used to work before, toda
y I try to start the service, it said following messages.
I use local system account, my other instance sql 2000 can start, I think
it's only YUKON problem, I do not know how to troubleshoot this error.
Can you guys help? Thanks a lot!!
y I try to start the service, it said following messages.
I use local system account, my other instance sql 2000 can start, I think
it's only YUKON problem, I do not know how to troubleshoot this error.
Can you guys help? Thanks a lot!!Have you checked the SQL Server 2005 error log?
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Britney" <britneychen_2001@.yahoo.com> wrote in message news:urW5U81oFHA.303
6@.TK2MSFTNGP14.phx.gbl...
Hi guys, I have sql 2005 beta 2 installed.. It used to work before, today
I try to start the service, it said following messages.
I use local system account, my other instance sql 2000 can start, I think
it's only YUKON problem, I do not know how to troubleshoot this error.
Can you guys help? Thanks a lot!!|||where do I look for the log?
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message news:%23F
eit92oFHA.3304@.tk2msftngp13.phx.gbl...
Have you checked the SQL Server 2005 error log?
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Britney" <britneychen_2001@.yahoo.com> wrote in message news:urW5U81oFHA.303
6@.TK2MSFTNGP14.phx.gbl...
Hi guys, I have sql 2005 beta 2 installed.. It used to work before, toda
y I try to start the service, it said following messages.
I use local system account, my other instance sql 2000 can start, I think
it's only YUKON problem, I do not know how to troubleshoot this error.
Can you guys help? Thanks a lot!!
can't start server
I can't seem to start SQL Server 7.0. I open up the
service manager, click the "start" button, and nothing
happens! It was working fine, and now all of a sudden,
it won't work. Does anyone have any suggestions?Hi,
Go to command prompt and start the SQL Server.
SQLSERVR -c
This will give you the detailed information for the startup issue. With that
u will be able to trouble shoot.
Thanks
Hari
MCDBA
"Eric" <ethomp99@.yahoo.com> wrote in message
news:270401c4a42d$56275b80$a301280a@.phx.gbl...
>I can't seem to start SQL Server 7.0. I open up the
> service manager, click the "start" button, and nothing
> happens! It was working fine, and now all of a sudden,
> it won't work. Does anyone have any suggestions?sql
service manager, click the "start" button, and nothing
happens! It was working fine, and now all of a sudden,
it won't work. Does anyone have any suggestions?Hi,
Go to command prompt and start the SQL Server.
SQLSERVR -c
This will give you the detailed information for the startup issue. With that
u will be able to trouble shoot.
Thanks
Hari
MCDBA
"Eric" <ethomp99@.yahoo.com> wrote in message
news:270401c4a42d$56275b80$a301280a@.phx.gbl...
>I can't seem to start SQL Server 7.0. I open up the
> service manager, click the "start" button, and nothing
> happens! It was working fine, and now all of a sudden,
> it won't work. Does anyone have any suggestions?sql
Can't start ReportServer service
Hello
I having problem to start ReportServer service after our Network administrator reboot the reporting server. Getting an error: "Error 1075: The dependency service does not exist or has been marked for deletion."
This is an error message from Event Viewer: "The ReportServer service depends on the following nonexistent service: mssqlserver"
First there are no explicit dependencies, second we have sql server installed on different machine. Any ideas how to fix it? Would appriciate any help.
Is this RS 2005? Early versions of RS2000 had a dependency on SQL Server, but this has not been the case for sometime and never in a released version. Is it possible this was an upgrade from an early 2000 beta?
The best option might be to uninstall RS then reinstall, hooking up to the old DB. Make sure you back up your symmetric key first or you will have to reenter all credentials.
Cant start report server
Hey all. I'm using SQL server Express and I've installed the Report service. When I go into the reporting services configuration manager and I want to start the service, the system won't let me. Here is the error
System.ServiceProcess.TimeoutException: Time out has expired and the operation has not been completed.
at System.ServiceProcess.ServiceController.WaitForStatus(ServiceControllerStatus desiredStatus, TimeSpan timeout)
at ReportServicesConfigUI.Panels.ServerInformationPanel.StartStopServiceTask(Boolean start)
I just can't seem to be able to start the service.
Can you plz help?
Thanks
Hi,
Based on my understanding, this error message is caused by the permission issue. You should take a look at the Report Server logs, and make sure you are configuring locally and you are administrator on the machine. And re-modify your reporting service configuration in the following way:
1. Created ReportService database using Report Service Configuration
2. Edited your personal account to Web Service Account in rsreportserver.config
3. Used rsconfig utility to encrypt the connection and account information
4. Edited your personal account to <processModel userName=" " >
If the problem still exists, you should try the following methods.
Set the Report Server Web service and Report Manager to use the same application pool.
|||Thank you for your answer. But how can I create a reportservice database if I can't connect to the service?
++ Where do I go to
Set the Report Server Web service and Report Manager to use the same application pool.
Add the security account to the SQLServer2005ReportingServicesWebServiceUser$InstanceName group that you use for the application pool identity.
|||Hi,
Set the Report Server Web service and Report Manager to use the same application pool.
Add the security account to the SQLServer2005ReportingServicesWebServiceUser$InstanceName group that you use for the application pool identity.
Sunday, March 25, 2012
Cant start MSSQL 2005 after DCPROMO
I have a 2003 sta server which has a MSSQL on it.
after running dcpromo on that server (secondary DC) the sql service is not running.
i get errors 17204/17207
any ideas?
DCPromo will disable / delete some of the local administrator accounts, if you have configured them as startup accounts, the service wont find them and therefore cannot start.
Jens K. Suessmeyer
http://www.sqlserver2005.de
|||So is there any thing i can do?
|||Yes,
change the startup accounts for the service to priviledged domain accounts and restart your Services. This should solve your problem.
Jens K. Suessmeyer
http://www.sqlserver2005.de
Can't setup SQL AgentMail
Dear all:
I've setup Outlook 2003 for my MAPI client, and setup service that not run
the local machine. And my SQL Mail can work. However, the profile in SQL
AgentMail still can't setup. How should I setup the SQL Agent Mail?Sorry that forgot post my environment:
Win2003 + AD
SQL 2000 + sp3a
Exchange 2003
Outlook 2003
Thank you very much for your reply!
"David" <david@.ms59.ideanote.org.NOSPAM> glsD
:uKhVx5A5DHA.2556@.TK2MSFTNGP09.phx.gbl...
Outlook profile's user account.
Try to use the Outlook user login to your SQL server, then create the
Outlook profile.
Then check again that SQL agentmail profile can setup or not.
2.Verify the MAPI32.dll version, you can see this to check your version.
http://support.microsoft.com/defaul...kb;en-us;263556
Microsoft MVP
Alvin Chen for Windows Server
MCP,MCSE,MCSA,MCSA+Messenger,RHCE,CCNA,T
CSE.
"David" <david@.ms59.ideanote.org.NOSPAM> glsD
:ORmhc4B5DHA.1936@.TK2MSFTNGP12.phx.gbl...
I've setup Outlook 2003 for my MAPI client, and setup service that not run
the local machine. And my SQL Mail can work. However, the profile in SQL
AgentMail still can't setup. How should I setup the SQL Agent Mail?Sorry that forgot post my environment:
Win2003 + AD
SQL 2000 + sp3a
Exchange 2003
Outlook 2003
Thank you very much for your reply!
"David" <david@.ms59.ideanote.org.NOSPAM> glsD
:uKhVx5A5DHA.2556@.TK2MSFTNGP09.phx.gbl...
quote:|||1.And make sure that SQL service account have permission to access the
> Dear all:
> I've setup Outlook 2003 for my MAPI client, and setup service that not run
> the local machine. And my SQL Mail can work. However, the profile in SQL
> AgentMail still can't setup. How should I setup the SQL Agent Mail?
>
Outlook profile's user account.
Try to use the Outlook user login to your SQL server, then create the
Outlook profile.
Then check again that SQL agentmail profile can setup or not.
2.Verify the MAPI32.dll version, you can see this to check your version.
http://support.microsoft.com/defaul...kb;en-us;263556
Microsoft MVP
Alvin Chen for Windows Server
MCP,MCSE,MCSA,MCSA+Messenger,RHCE,CCNA,T
CSE.
"David" <david@.ms59.ideanote.org.NOSPAM> glsD
:ORmhc4B5DHA.1936@.TK2MSFTNGP12.phx.gbl...
quote:
> Sorry that forgot post my environment:
> Win2003 + AD
> SQL 2000 + sp3a
> Exchange 2003
> Outlook 2003
> Thank you very much for your reply!
> "David" <david@.ms59.ideanote.org.NOSPAM> glsD
> :uKhVx5A5DHA.2556@.TK2MSFTNGP09.phx.gbl...
run[QUOTE]
>
Can't setup SQL AgentMail
Dear all:
I've setup Outlook 2003 for my MAPI client, and setup service that not run
the local machine. And my SQL Mail can work. However, the profile in SQL
AgentMail still can't setup. How should I setup the SQL Agent Mail?Sorry that forgot post my environment:
Win2003 + AD
SQL 2000 + sp3a
Exchange 2003
Outlook 2003
Thank you very much for your reply!
"David" <david@.ms59.ideanote.org.NOSPAM> ¼¶¼g©ó¶l¥ó·s»D
:uKhVx5A5DHA.2556@.TK2MSFTNGP09.phx.gbl...
> Dear all:
> I've setup Outlook 2003 for my MAPI client, and setup service that not run
> the local machine. And my SQL Mail can work. However, the profile in SQL
> AgentMail still can't setup. How should I setup the SQL Agent Mail?
>|||1.And make sure that SQL service account have permission to access the
Outlook profile's user account.
Try to use the Outlook user login to your SQL server, then create the
Outlook profile.
Then check again that SQL agentmail profile can setup or not.
2.Verify the MAPI32.dll version, you can see this to check your version.
http://support.microsoft.com/default.aspx?scid=kb;en-us;263556
Microsoft MVP
Alvin Chen for Windows Server
MCP,MCSE,MCSA,MCSA+Messenger,RHCE,CCNA,TCSE.
"David" <david@.ms59.ideanote.org.NOSPAM> ¼¶¼g©ó¶l¥ó·s»D
:ORmhc4B5DHA.1936@.TK2MSFTNGP12.phx.gbl...
> Sorry that forgot post my environment:
> Win2003 + AD
> SQL 2000 + sp3a
> Exchange 2003
> Outlook 2003
> Thank you very much for your reply!
> "David" <david@.ms59.ideanote.org.NOSPAM> ¼¶¼g©ó¶l¥ó·s»D
> :uKhVx5A5DHA.2556@.TK2MSFTNGP09.phx.gbl...
> > Dear all:
> >
> > I've setup Outlook 2003 for my MAPI client, and setup service that not
run
> > the local machine. And my SQL Mail can work. However, the profile in SQL
> > AgentMail still can't setup. How should I setup the SQL Agent Mail?
> >
> >
>
I've setup Outlook 2003 for my MAPI client, and setup service that not run
the local machine. And my SQL Mail can work. However, the profile in SQL
AgentMail still can't setup. How should I setup the SQL Agent Mail?Sorry that forgot post my environment:
Win2003 + AD
SQL 2000 + sp3a
Exchange 2003
Outlook 2003
Thank you very much for your reply!
"David" <david@.ms59.ideanote.org.NOSPAM> ¼¶¼g©ó¶l¥ó·s»D
:uKhVx5A5DHA.2556@.TK2MSFTNGP09.phx.gbl...
> Dear all:
> I've setup Outlook 2003 for my MAPI client, and setup service that not run
> the local machine. And my SQL Mail can work. However, the profile in SQL
> AgentMail still can't setup. How should I setup the SQL Agent Mail?
>|||1.And make sure that SQL service account have permission to access the
Outlook profile's user account.
Try to use the Outlook user login to your SQL server, then create the
Outlook profile.
Then check again that SQL agentmail profile can setup or not.
2.Verify the MAPI32.dll version, you can see this to check your version.
http://support.microsoft.com/default.aspx?scid=kb;en-us;263556
Microsoft MVP
Alvin Chen for Windows Server
MCP,MCSE,MCSA,MCSA+Messenger,RHCE,CCNA,TCSE.
"David" <david@.ms59.ideanote.org.NOSPAM> ¼¶¼g©ó¶l¥ó·s»D
:ORmhc4B5DHA.1936@.TK2MSFTNGP12.phx.gbl...
> Sorry that forgot post my environment:
> Win2003 + AD
> SQL 2000 + sp3a
> Exchange 2003
> Outlook 2003
> Thank you very much for your reply!
> "David" <david@.ms59.ideanote.org.NOSPAM> ¼¶¼g©ó¶l¥ó·s»D
> :uKhVx5A5DHA.2556@.TK2MSFTNGP09.phx.gbl...
> > Dear all:
> >
> > I've setup Outlook 2003 for my MAPI client, and setup service that not
run
> > the local machine. And my SQL Mail can work. However, the profile in SQL
> > AgentMail still can't setup. How should I setup the SQL Agent Mail?
> >
> >
>
Tuesday, March 20, 2012
Can't see reportserver and reports applications
I'm trying to use Reporting Services 2005. The service is running, but if I
type http://192.168.1.49:8888/reportserver I see the directory list.
With http://192.1681.49:8888/reports, I see an error: The request failed
with HTTP status 503: Service Unavailable.The error is in URL.
http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least I know is
inside the application.
I'm completely stuck. What can I do or where can I search?
--
Regards,
Diego F.Google is your friend. Type in "reporting services" 503 "service
unavailable" and you'll get quite a lot of info. Not all of it is directly
connected to Reporting Services, but you should be able to pick up some info
on the 503 problem in general. It seems that there's a problem with the
Reporting Services web service.
Are you allowed to log on to the actual server and try running Report
Manager from that box?
What sort of authentication is set?
Try adding the report server site to your Trusted sites in IE, and then
change the Security Settings for Trusted Sites to "Prompt for user name and
password" in User Authentication - Logon. Type in your username and
password. If it fails, that might be what causes the problem. In that case,
you need to figure out what rights are needed for you to access the reports.
Kaisa M. Lindahl
"Diego F." <diegofrNO@.terra.es> wrote in message
news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
> I'm trying to use Reporting Services 2005. The service is running, but if
> I type http://192.168.1.49:8888/reportserver I see the directory list.
> With http://192.1681.49:8888/reports, I see an error: The request failed
> with HTTP status 503: Service Unavailable.The error is in URL.
> http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least I know is
> inside the application.
> I'm completely stuck. What can I do or where can I search?
> --
> Regards,
> Diego F.
>|||Hi again.
I installed again the whole server: Window 2003 and SQL Server 2005 full.
Now I finally see the reports site :-)
There is a Visual Studio installed with SQL 2005 and I can design reports
there. But now I don't know how to configure the project to deploy
correctly.
I get that error:
A connection could not be made to the report server http://localhost/reports
Additional information:
The attempt to connect to the report server failed. Check your connection
information and the report server is a compatible version.
(Microsoft.ReportingServices.Designer).
If I try with: http://localhost/reportserver then I get a compilation error:
The Report Server Windows Service ReportServer is not running. The service
must be running to use the Report Server.
How can I solve that?
--
Regards,
Diego F.
"Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
news:exkoPudFGHA.3280@.TK2MSFTNGP10.phx.gbl...
> Google is your friend. Type in "reporting services" 503 "service
> unavailable" and you'll get quite a lot of info. Not all of it is directly
> connected to Reporting Services, but you should be able to pick up some
> info on the 503 problem in general. It seems that there's a problem with
> the Reporting Services web service.
> Are you allowed to log on to the actual server and try running Report
> Manager from that box?
> What sort of authentication is set?
> Try adding the report server site to your Trusted sites in IE, and then
> change the Security Settings for Trusted Sites to "Prompt for user name
> and password" in User Authentication - Logon. Type in your username and
> password. If it fails, that might be what causes the problem. In that
> case, you need to figure out what rights are needed for you to access the
> reports.
> Kaisa M. Lindahl
>
> "Diego F." <diegofrNO@.terra.es> wrote in message
> news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
>> I'm trying to use Reporting Services 2005. The service is running, but if
>> I type http://192.168.1.49:8888/reportserver I see the directory list.
>> With http://192.1681.49:8888/reports, I see an error: The request failed
>> with HTTP status 503: Service Unavailable.The error is in URL.
>> http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least I know is
>> inside the application.
>> I'm completely stuck. What can I do or where can I search?
>> --
>> Regards,
>> Diego F.
>|||Open IIS, a.k.a Internet Information Services Manager
Open your Reports site, is probably under Web SItes - Default Web Site.
RIght click and choose Browse. Does it open correctly?
If it does, what is the URL? I did a test install of the 2005 edition, and I
think you might get some extra "name" or something, like
http://localhost/reports$instancename
Which means that the reports are still there, but the URL might have
changed. Or something.
Also, with Sql Server 2005 there's an nice Reporting Services configuration
tool. Start it and look to see if there are any things that needs to be
started.
Kaisa M. Lindahl
"Diego F." <diegofrNO@.terra.es> wrote in message
news:usLfZ8rFGHA.208@.tk2msftngp13.phx.gbl...
> Hi again.
> I installed again the whole server: Window 2003 and SQL Server 2005 full.
> Now I finally see the reports site :-)
> There is a Visual Studio installed with SQL 2005 and I can design reports
> there. But now I don't know how to configure the project to deploy
> correctly.
> I get that error:
> A connection could not be made to the report server
> http://localhost/reports
> Additional information:
> The attempt to connect to the report server failed. Check your
> connection information and the report server is a compatible version.
> (Microsoft.ReportingServices.Designer).
> If I try with: http://localhost/reportserver then I get a compilation
> error:
> The Report Server Windows Service ReportServer is not running. The service
> must be running to use the Report Server.
> How can I solve that?
> --
> Regards,
> Diego F.
>
> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
> news:exkoPudFGHA.3280@.TK2MSFTNGP10.phx.gbl...
>> Google is your friend. Type in "reporting services" 503 "service
>> unavailable" and you'll get quite a lot of info. Not all of it is
>> directly connected to Reporting Services, but you should be able to pick
>> up some info on the 503 problem in general. It seems that there's a
>> problem with the Reporting Services web service.
>> Are you allowed to log on to the actual server and try running Report
>> Manager from that box?
>> What sort of authentication is set?
>> Try adding the report server site to your Trusted sites in IE, and then
>> change the Security Settings for Trusted Sites to "Prompt for user name
>> and password" in User Authentication - Logon. Type in your username and
>> password. If it fails, that might be what causes the problem. In that
>> case, you need to figure out what rights are needed for you to access the
>> reports.
>> Kaisa M. Lindahl
>>
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
>> I'm trying to use Reporting Services 2005. The service is running, but
>> if I type http://192.168.1.49:8888/reportserver I see the directory
>> list.
>> With http://192.1681.49:8888/reports, I see an error: The request failed
>> with HTTP status 503: Service Unavailable.The error is in URL.
>> http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least I know
>> is inside the application.
>> I'm completely stuck. What can I do or where can I search?
>> --
>> Regards,
>> Diego F.
>>
>|||I finally uploaded a report. I made it with Visual Studio 2005 installed by
SQL Server 2005. I made a report and deployed it, and in the Report Manager
shows the new report, but I can't see it because:
- 'The report server cannot process the report. The data source connection
information has been deleted. (rsInvalidDataSourceReference).
I made the connection with the project.
If I'm understanding something, is it the idea to have all the reports in
the server, and the applications should link to that URL to load the report?
Thanks a lot for your help. I really appreciate.
--
Regards,
Diego F.
"Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
news:umHKqBsFGHA.2084@.TK2MSFTNGP09.phx.gbl...
> Open IIS, a.k.a Internet Information Services Manager
> Open your Reports site, is probably under Web SItes - Default Web Site.
> RIght click and choose Browse. Does it open correctly?
> If it does, what is the URL? I did a test install of the 2005 edition, and
> I think you might get some extra "name" or something, like
> http://localhost/reports$instancename
> Which means that the reports are still there, but the URL might have
> changed. Or something.
> Also, with Sql Server 2005 there's an nice Reporting Services
> configuration tool. Start it and look to see if there are any things that
> needs to be started.
> Kaisa M. Lindahl
> "Diego F." <diegofrNO@.terra.es> wrote in message
> news:usLfZ8rFGHA.208@.tk2msftngp13.phx.gbl...
>> Hi again.
>> I installed again the whole server: Window 2003 and SQL Server 2005 full.
>> Now I finally see the reports site :-)
>> There is a Visual Studio installed with SQL 2005 and I can design reports
>> there. But now I don't know how to configure the project to deploy
>> correctly.
>> I get that error:
>> A connection could not be made to the report server
>> http://localhost/reports
>> Additional information:
>> The attempt to connect to the report server failed. Check your
>> connection information and the report server is a compatible version.
>> (Microsoft.ReportingServices.Designer).
>> If I try with: http://localhost/reportserver then I get a compilation
>> error:
>> The Report Server Windows Service ReportServer is not running. The
>> service must be running to use the Report Server.
>> How can I solve that?
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:exkoPudFGHA.3280@.TK2MSFTNGP10.phx.gbl...
>> Google is your friend. Type in "reporting services" 503 "service
>> unavailable" and you'll get quite a lot of info. Not all of it is
>> directly connected to Reporting Services, but you should be able to pick
>> up some info on the 503 problem in general. It seems that there's a
>> problem with the Reporting Services web service.
>> Are you allowed to log on to the actual server and try running Report
>> Manager from that box?
>> What sort of authentication is set?
>> Try adding the report server site to your Trusted sites in IE, and then
>> change the Security Settings for Trusted Sites to "Prompt for user name
>> and password" in User Authentication - Logon. Type in your username and
>> password. If it fails, that might be what causes the problem. In that
>> case, you need to figure out what rights are needed for you to access
>> the reports.
>> Kaisa M. Lindahl
>>
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
>> I'm trying to use Reporting Services 2005. The service is running, but
>> if I type http://192.168.1.49:8888/reportserver I see the directory
>> list.
>> With http://192.1681.49:8888/reports, I see an error: The request
>> failed with HTTP status 503: Service Unavailable.The error is in URL.
>> http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least I know
>> is inside the application.
>> I'm completely stuck. What can I do or where can I search?
>> --
>> Regards,
>> Diego F.
>>
>>
>|||I did the process again and now -don't ask me why- it shows the report.
Then, as I asked you before, is the idea to create all the reports I need
and upload to the server?
My idea is to intergate that in a web application, so I expected to show
just the report by clicking a button. Is that possible?
And last but not least ;-), is it possible to dinamically -by code- generate
the reports temporally? I have all my queries as stored procedures.
Thanks a lot!
--
Regards,
Diego F.
"Diego F." <diegofrNO@.terra.es> escribió en el mensaje
news:OI94mSsFGHA.752@.TK2MSFTNGP12.phx.gbl...
>I finally uploaded a report. I made it with Visual Studio 2005 installed by
>SQL Server 2005. I made a report and deployed it, and in the Report Manager
>shows the new report, but I can't see it because:
> - 'The report server cannot process the report. The data source connection
> information has been deleted. (rsInvalidDataSourceReference).
> I made the connection with the project.
> If I'm understanding something, is it the idea to have all the reports in
> the server, and the applications should link to that URL to load the
> report?
> Thanks a lot for your help. I really appreciate.
> --
> Regards,
> Diego F.
>
> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
> news:umHKqBsFGHA.2084@.TK2MSFTNGP09.phx.gbl...
>> Open IIS, a.k.a Internet Information Services Manager
>> Open your Reports site, is probably under Web SItes - Default Web Site.
>> RIght click and choose Browse. Does it open correctly?
>> If it does, what is the URL? I did a test install of the 2005 edition,
>> and I think you might get some extra "name" or something, like
>> http://localhost/reports$instancename
>> Which means that the reports are still there, but the URL might have
>> changed. Or something.
>> Also, with Sql Server 2005 there's an nice Reporting Services
>> configuration tool. Start it and look to see if there are any things that
>> needs to be started.
>> Kaisa M. Lindahl
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:usLfZ8rFGHA.208@.tk2msftngp13.phx.gbl...
>> Hi again.
>> I installed again the whole server: Window 2003 and SQL Server 2005
>> full.
>> Now I finally see the reports site :-)
>> There is a Visual Studio installed with SQL 2005 and I can design
>> reports there. But now I don't know how to configure the project to
>> deploy correctly.
>> I get that error:
>> A connection could not be made to the report server
>> http://localhost/reports
>> Additional information:
>> The attempt to connect to the report server failed. Check your
>> connection information and the report server is a compatible version.
>> (Microsoft.ReportingServices.Designer).
>> If I try with: http://localhost/reportserver then I get a compilation
>> error:
>> The Report Server Windows Service ReportServer is not running. The
>> service must be running to use the Report Server.
>> How can I solve that?
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:exkoPudFGHA.3280@.TK2MSFTNGP10.phx.gbl...
>> Google is your friend. Type in "reporting services" 503 "service
>> unavailable" and you'll get quite a lot of info. Not all of it is
>> directly connected to Reporting Services, but you should be able to
>> pick up some info on the 503 problem in general. It seems that there's
>> a problem with the Reporting Services web service.
>> Are you allowed to log on to the actual server and try running Report
>> Manager from that box?
>> What sort of authentication is set?
>> Try adding the report server site to your Trusted sites in IE, and then
>> change the Security Settings for Trusted Sites to "Prompt for user name
>> and password" in User Authentication - Logon. Type in your username and
>> password. If it fails, that might be what causes the problem. In that
>> case, you need to figure out what rights are needed for you to access
>> the reports.
>> Kaisa M. Lindahl
>>
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
>> I'm trying to use Reporting Services 2005. The service is running, but
>> if I type http://192.168.1.49:8888/reportserver I see the directory
>> list.
>> With http://192.1681.49:8888/reports, I see an error: The request
>> failed with HTTP status 503: Service Unavailable.The error is in URL.
>> http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least I know
>> is inside the application.
>> I'm completely stuck. What can I do or where can I search?
>> --
>> Regards,
>> Diego F.
>>
>>
>>
>|||There are three ways to integrate with RS 2005.
1. URL Integration
2. Web Services
3. Visual Studio 2005 Reporting Control
The reporting control has a local mode, you get it a datatable and a report.
I suggest you back up and learn how to create reports before you deal with
integration. There is a lot more that you have to do in local mode.
Normal function is to create a report and deploy it. Make sure it works from
the shipping portal (Report Manager web site).
Have your queries as stored procedures is great. No reason to create the RDL
on the fly. Just pass parameters to the report and use your stored
procedure.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Diego F." <diegofrNO@.terra.es> wrote in message
news:%23ejqOcsFGHA.2444@.TK2MSFTNGP11.phx.gbl...
>I did the process again and now -don't ask me why- it shows the report.
> Then, as I asked you before, is the idea to create all the reports I need
> and upload to the server?
> My idea is to intergate that in a web application, so I expected to show
> just the report by clicking a button. Is that possible?
> And last but not least ;-), is it possible to dinamically -by code-
> generate the reports temporally? I have all my queries as stored
> procedures.
> Thanks a lot!
> --
> Regards,
> Diego F.
>
> "Diego F." <diegofrNO@.terra.es> escribió en el mensaje
> news:OI94mSsFGHA.752@.TK2MSFTNGP12.phx.gbl...
>>I finally uploaded a report. I made it with Visual Studio 2005 installed
>>by SQL Server 2005. I made a report and deployed it, and in the Report
>>Manager shows the new report, but I can't see it because:
>> - 'The report server cannot process the report. The data source
>> connection information has been deleted. (rsInvalidDataSourceReference).
>> I made the connection with the project.
>> If I'm understanding something, is it the idea to have all the reports in
>> the server, and the applications should link to that URL to load the
>> report?
>> Thanks a lot for your help. I really appreciate.
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:umHKqBsFGHA.2084@.TK2MSFTNGP09.phx.gbl...
>> Open IIS, a.k.a Internet Information Services Manager
>> Open your Reports site, is probably under Web SItes - Default Web Site.
>> RIght click and choose Browse. Does it open correctly?
>> If it does, what is the URL? I did a test install of the 2005 edition,
>> and I think you might get some extra "name" or something, like
>> http://localhost/reports$instancename
>> Which means that the reports are still there, but the URL might have
>> changed. Or something.
>> Also, with Sql Server 2005 there's an nice Reporting Services
>> configuration tool. Start it and look to see if there are any things
>> that needs to be started.
>> Kaisa M. Lindahl
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:usLfZ8rFGHA.208@.tk2msftngp13.phx.gbl...
>> Hi again.
>> I installed again the whole server: Window 2003 and SQL Server 2005
>> full.
>> Now I finally see the reports site :-)
>> There is a Visual Studio installed with SQL 2005 and I can design
>> reports there. But now I don't know how to configure the project to
>> deploy correctly.
>> I get that error:
>> A connection could not be made to the report server
>> http://localhost/reports
>> Additional information:
>> The attempt to connect to the report server failed. Check your
>> connection information and the report server is a compatible version.
>> (Microsoft.ReportingServices.Designer).
>> If I try with: http://localhost/reportserver then I get a compilation
>> error:
>> The Report Server Windows Service ReportServer is not running. The
>> service must be running to use the Report Server.
>> How can I solve that?
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:exkoPudFGHA.3280@.TK2MSFTNGP10.phx.gbl...
>> Google is your friend. Type in "reporting services" 503 "service
>> unavailable" and you'll get quite a lot of info. Not all of it is
>> directly connected to Reporting Services, but you should be able to
>> pick up some info on the 503 problem in general. It seems that there's
>> a problem with the Reporting Services web service.
>> Are you allowed to log on to the actual server and try running Report
>> Manager from that box?
>> What sort of authentication is set?
>> Try adding the report server site to your Trusted sites in IE, and
>> then change the Security Settings for Trusted Sites to "Prompt for
>> user name and password" in User Authentication - Logon. Type in your
>> username and password. If it fails, that might be what causes the
>> problem. In that case, you need to figure out what rights are needed
>> for you to access the reports.
>> Kaisa M. Lindahl
>>
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
>> I'm trying to use Reporting Services 2005. The service is running,
>> but if I type http://192.168.1.49:8888/reportserver I see the
>> directory list.
>> With http://192.1681.49:8888/reports, I see an error: The request
>> failed with HTTP status 503: Service Unavailable.The error is in URL.
>> http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least I
>> know is inside the application.
>> I'm completely stuck. What can I do or where can I search?
>> --
>> Regards,
>> Diego F.
>>
>>
>>
>>
>|||Bruce already answered some of your questions, I'll just add something.
- Create your reports locally, deploy to the server.
- When it comes to webapplications, you can either link directly to each
report, with parameters and everything else, or you can create an iFrame and
make the Report Manager show up inside. (Look for tips on integrating with
SharePoint, even if you're not using SharePoint, as you can use some of the
info in your web app.)
http://blogs.spipp.net/kaisa/archive/2005/09/27/1185.aspx
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/webrssp2.mspx
The beauty of using an iFrame against Report Manager, is that Report Manager
will still deal with authentication for the different reports.
- Make sure to test your reports with user accounts with less priveleges
than yourself, before allowing your users to try them out. SOmetimes setting
the rights values in the datasource can be a bit tricky.
Kaisa M. Lindahl
"Diego F." <diegofrNO@.terra.es> wrote in message
news:%23ejqOcsFGHA.2444@.TK2MSFTNGP11.phx.gbl...
>I did the process again and now -don't ask me why- it shows the report.
> Then, as I asked you before, is the idea to create all the reports I need
> and upload to the server?
> My idea is to intergate that in a web application, so I expected to show
> just the report by clicking a button. Is that possible?
> And last but not least ;-), is it possible to dinamically -by code-
> generate the reports temporally? I have all my queries as stored
> procedures.
> Thanks a lot!
> --
> Regards,
> Diego F.
>
> "Diego F." <diegofrNO@.terra.es> escribió en el mensaje
> news:OI94mSsFGHA.752@.TK2MSFTNGP12.phx.gbl...
>>I finally uploaded a report. I made it with Visual Studio 2005 installed
>>by SQL Server 2005. I made a report and deployed it, and in the Report
>>Manager shows the new report, but I can't see it because:
>> - 'The report server cannot process the report. The data source
>> connection information has been deleted. (rsInvalidDataSourceReference).
>> I made the connection with the project.
>> If I'm understanding something, is it the idea to have all the reports in
>> the server, and the applications should link to that URL to load the
>> report?
>> Thanks a lot for your help. I really appreciate.
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:umHKqBsFGHA.2084@.TK2MSFTNGP09.phx.gbl...
>> Open IIS, a.k.a Internet Information Services Manager
>> Open your Reports site, is probably under Web SItes - Default Web Site.
>> RIght click and choose Browse. Does it open correctly?
>> If it does, what is the URL? I did a test install of the 2005 edition,
>> and I think you might get some extra "name" or something, like
>> http://localhost/reports$instancename
>> Which means that the reports are still there, but the URL might have
>> changed. Or something.
>> Also, with Sql Server 2005 there's an nice Reporting Services
>> configuration tool. Start it and look to see if there are any things
>> that needs to be started.
>> Kaisa M. Lindahl
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:usLfZ8rFGHA.208@.tk2msftngp13.phx.gbl...
>> Hi again.
>> I installed again the whole server: Window 2003 and SQL Server 2005
>> full.
>> Now I finally see the reports site :-)
>> There is a Visual Studio installed with SQL 2005 and I can design
>> reports there. But now I don't know how to configure the project to
>> deploy correctly.
>> I get that error:
>> A connection could not be made to the report server
>> http://localhost/reports
>> Additional information:
>> The attempt to connect to the report server failed. Check your
>> connection information and the report server is a compatible version.
>> (Microsoft.ReportingServices.Designer).
>> If I try with: http://localhost/reportserver then I get a compilation
>> error:
>> The Report Server Windows Service ReportServer is not running. The
>> service must be running to use the Report Server.
>> How can I solve that?
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:exkoPudFGHA.3280@.TK2MSFTNGP10.phx.gbl...
>> Google is your friend. Type in "reporting services" 503 "service
>> unavailable" and you'll get quite a lot of info. Not all of it is
>> directly connected to Reporting Services, but you should be able to
>> pick up some info on the 503 problem in general. It seems that there's
>> a problem with the Reporting Services web service.
>> Are you allowed to log on to the actual server and try running Report
>> Manager from that box?
>> What sort of authentication is set?
>> Try adding the report server site to your Trusted sites in IE, and
>> then change the Security Settings for Trusted Sites to "Prompt for
>> user name and password" in User Authentication - Logon. Type in your
>> username and password. If it fails, that might be what causes the
>> problem. In that case, you need to figure out what rights are needed
>> for you to access the reports.
>> Kaisa M. Lindahl
>>
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
>> I'm trying to use Reporting Services 2005. The service is running,
>> but if I type http://192.168.1.49:8888/reportserver I see the
>> directory list.
>> With http://192.1681.49:8888/reports, I see an error: The request
>> failed with HTTP status 503: Service Unavailable.The error is in URL.
>> http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least I
>> know is inside the application.
>> I'm completely stuck. What can I do or where can I search?
>> --
>> Regards,
>> Diego F.
>>
>>
>>
>>
>|||Thank you. I'm trying to use just the URL to see the report, so it
integrates easily with my application.
I tried with a test server I installed just to make tests with that. The
only problem I met is that I have to put user and password, but I hope that
doing from the same domain avoids that.
Anyway, it's a lot of work to manually create each report from a whole
application.
--
Regards,
Diego F.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> escribió en el mensaje
news:usBxTgsFGHA.1192@.TK2MSFTNGP11.phx.gbl...
> There are three ways to integrate with RS 2005.
> 1. URL Integration
> 2. Web Services
> 3. Visual Studio 2005 Reporting Control
> The reporting control has a local mode, you get it a datatable and a
> report.
> I suggest you back up and learn how to create reports before you deal with
> integration. There is a lot more that you have to do in local mode.
> Normal function is to create a report and deploy it. Make sure it works
> from the shipping portal (Report Manager web site).
> Have your queries as stored procedures is great. No reason to create the
> RDL on the fly. Just pass parameters to the report and use your stored
> procedure.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Diego F." <diegofrNO@.terra.es> wrote in message
> news:%23ejqOcsFGHA.2444@.TK2MSFTNGP11.phx.gbl...
>>I did the process again and now -don't ask me why- it shows the report.
>> Then, as I asked you before, is the idea to create all the reports I need
>> and upload to the server?
>> My idea is to intergate that in a web application, so I expected to show
>> just the report by clicking a button. Is that possible?
>> And last but not least ;-), is it possible to dinamically -by code-
>> generate the reports temporally? I have all my queries as stored
>> procedures.
>> Thanks a lot!
>> --
>> Regards,
>> Diego F.
>>
>> "Diego F." <diegofrNO@.terra.es> escribió en el mensaje
>> news:OI94mSsFGHA.752@.TK2MSFTNGP12.phx.gbl...
>>I finally uploaded a report. I made it with Visual Studio 2005 installed
>>by SQL Server 2005. I made a report and deployed it, and in the Report
>>Manager shows the new report, but I can't see it because:
>> - 'The report server cannot process the report. The data source
>> connection information has been deleted. (rsInvalidDataSourceReference).
>> I made the connection with the project.
>> If I'm understanding something, is it the idea to have all the reports
>> in the server, and the applications should link to that URL to load the
>> report?
>> Thanks a lot for your help. I really appreciate.
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:umHKqBsFGHA.2084@.TK2MSFTNGP09.phx.gbl...
>> Open IIS, a.k.a Internet Information Services Manager
>> Open your Reports site, is probably under Web SItes - Default Web Site.
>> RIght click and choose Browse. Does it open correctly?
>> If it does, what is the URL? I did a test install of the 2005 edition,
>> and I think you might get some extra "name" or something, like
>> http://localhost/reports$instancename
>> Which means that the reports are still there, but the URL might have
>> changed. Or something.
>> Also, with Sql Server 2005 there's an nice Reporting Services
>> configuration tool. Start it and look to see if there are any things
>> that needs to be started.
>> Kaisa M. Lindahl
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:usLfZ8rFGHA.208@.tk2msftngp13.phx.gbl...
>> Hi again.
>> I installed again the whole server: Window 2003 and SQL Server 2005
>> full.
>> Now I finally see the reports site :-)
>> There is a Visual Studio installed with SQL 2005 and I can design
>> reports there. But now I don't know how to configure the project to
>> deploy correctly.
>> I get that error:
>> A connection could not be made to the report server
>> http://localhost/reports
>> Additional information:
>> The attempt to connect to the report server failed. Check your
>> connection information and the report server is a compatible version.
>> (Microsoft.ReportingServices.Designer).
>> If I try with: http://localhost/reportserver then I get a compilation
>> error:
>> The Report Server Windows Service ReportServer is not running. The
>> service must be running to use the Report Server.
>> How can I solve that?
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:exkoPudFGHA.3280@.TK2MSFTNGP10.phx.gbl...
>> Google is your friend. Type in "reporting services" 503 "service
>> unavailable" and you'll get quite a lot of info. Not all of it is
>> directly connected to Reporting Services, but you should be able to
>> pick up some info on the 503 problem in general. It seems that
>> there's a problem with the Reporting Services web service.
>> Are you allowed to log on to the actual server and try running Report
>> Manager from that box?
>> What sort of authentication is set?
>> Try adding the report server site to your Trusted sites in IE, and
>> then change the Security Settings for Trusted Sites to "Prompt for
>> user name and password" in User Authentication - Logon. Type in your
>> username and password. If it fails, that might be what causes the
>> problem. In that case, you need to figure out what rights are needed
>> for you to access the reports.
>> Kaisa M. Lindahl
>>
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
>>> I'm trying to use Reporting Services 2005. The service is running,
>>> but if I type http://192.168.1.49:8888/reportserver I see the
>>> directory list.
>>> With http://192.1681.49:8888/reports, I see an error: The request
>>> failed with HTTP status 503: Service Unavailable.The error is in
>>> URL. http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least
>>> I know is inside the application.
>>>
>>> I'm completely stuck. What can I do or where can I search?
>>>
>>> --
>>> Regards,
>>>
>>> Diego F.
>>>
>>
>>
>>
>>
>>
>|||I'll also use SharePoint to integrate the whole application, so I'll check
that.
Where can I set the reports permissions?
--
Regards,
Diego F.
"Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
news:uF8RP1sFGHA.532@.TK2MSFTNGP15.phx.gbl...
> Bruce already answered some of your questions, I'll just add something.
> - Create your reports locally, deploy to the server.
> - When it comes to webapplications, you can either link directly to each
> report, with parameters and everything else, or you can create an iFrame
> and make the Report Manager show up inside. (Look for tips on integrating
> with SharePoint, even if you're not using SharePoint, as you can use some
> of the info in your web app.)
> http://blogs.spipp.net/kaisa/archive/2005/09/27/1185.aspx
> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/webrssp2.mspx
> The beauty of using an iFrame against Report Manager, is that Report
> Manager will still deal with authentication for the different reports.
> - Make sure to test your reports with user accounts with less priveleges
> than yourself, before allowing your users to try them out. SOmetimes
> setting the rights values in the datasource can be a bit tricky.
> Kaisa M. Lindahl
> "Diego F." <diegofrNO@.terra.es> wrote in message
> news:%23ejqOcsFGHA.2444@.TK2MSFTNGP11.phx.gbl...
>>I did the process again and now -don't ask me why- it shows the report.
>> Then, as I asked you before, is the idea to create all the reports I need
>> and upload to the server?
>> My idea is to intergate that in a web application, so I expected to show
>> just the report by clicking a button. Is that possible?
>> And last but not least ;-), is it possible to dinamically -by code-
>> generate the reports temporally? I have all my queries as stored
>> procedures.
>> Thanks a lot!
>> --
>> Regards,
>> Diego F.
>>
>> "Diego F." <diegofrNO@.terra.es> escribió en el mensaje
>> news:OI94mSsFGHA.752@.TK2MSFTNGP12.phx.gbl...
>>I finally uploaded a report. I made it with Visual Studio 2005 installed
>>by SQL Server 2005. I made a report and deployed it, and in the Report
>>Manager shows the new report, but I can't see it because:
>> - 'The report server cannot process the report. The data source
>> connection information has been deleted. (rsInvalidDataSourceReference).
>> I made the connection with the project.
>> If I'm understanding something, is it the idea to have all the reports
>> in the server, and the applications should link to that URL to load the
>> report?
>> Thanks a lot for your help. I really appreciate.
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:umHKqBsFGHA.2084@.TK2MSFTNGP09.phx.gbl...
>> Open IIS, a.k.a Internet Information Services Manager
>> Open your Reports site, is probably under Web SItes - Default Web Site.
>> RIght click and choose Browse. Does it open correctly?
>> If it does, what is the URL? I did a test install of the 2005 edition,
>> and I think you might get some extra "name" or something, like
>> http://localhost/reports$instancename
>> Which means that the reports are still there, but the URL might have
>> changed. Or something.
>> Also, with Sql Server 2005 there's an nice Reporting Services
>> configuration tool. Start it and look to see if there are any things
>> that needs to be started.
>> Kaisa M. Lindahl
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:usLfZ8rFGHA.208@.tk2msftngp13.phx.gbl...
>> Hi again.
>> I installed again the whole server: Window 2003 and SQL Server 2005
>> full.
>> Now I finally see the reports site :-)
>> There is a Visual Studio installed with SQL 2005 and I can design
>> reports there. But now I don't know how to configure the project to
>> deploy correctly.
>> I get that error:
>> A connection could not be made to the report server
>> http://localhost/reports
>> Additional information:
>> The attempt to connect to the report server failed. Check your
>> connection information and the report server is a compatible version.
>> (Microsoft.ReportingServices.Designer).
>> If I try with: http://localhost/reportserver then I get a compilation
>> error:
>> The Report Server Windows Service ReportServer is not running. The
>> service must be running to use the Report Server.
>> How can I solve that?
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:exkoPudFGHA.3280@.TK2MSFTNGP10.phx.gbl...
>> Google is your friend. Type in "reporting services" 503 "service
>> unavailable" and you'll get quite a lot of info. Not all of it is
>> directly connected to Reporting Services, but you should be able to
>> pick up some info on the 503 problem in general. It seems that
>> there's a problem with the Reporting Services web service.
>> Are you allowed to log on to the actual server and try running Report
>> Manager from that box?
>> What sort of authentication is set?
>> Try adding the report server site to your Trusted sites in IE, and
>> then change the Security Settings for Trusted Sites to "Prompt for
>> user name and password" in User Authentication - Logon. Type in your
>> username and password. If it fails, that might be what causes the
>> problem. In that case, you need to figure out what rights are needed
>> for you to access the reports.
>> Kaisa M. Lindahl
>>
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
>>> I'm trying to use Reporting Services 2005. The service is running,
>>> but if I type http://192.168.1.49:8888/reportserver I see the
>>> directory list.
>>> With http://192.1681.49:8888/reports, I see an error: The request
>>> failed with HTTP status 503: Service Unavailable.The error is in
>>> URL. http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least
>>> I know is inside the application.
>>>
>>> I'm completely stuck. What can I do or where can I search?
>>>
>>> --
>>> Regards,
>>>
>>> Diego F.
>>>
>>
>>
>>
>>
>>
>|||On either a folder or a single report: Click Properties and the Security.
ANd then you can add what users and groups are allowed to see or update
reports.
Kaisa
"Diego F." <diegofrNO@.terra.es> wrote in message
news:%23ToFp6sFGHA.916@.TK2MSFTNGP10.phx.gbl...
> I'll also use SharePoint to integrate the whole application, so I'll check
> that.
> Where can I set the reports permissions?
> --
> Regards,
> Diego F.
>
> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
> news:uF8RP1sFGHA.532@.TK2MSFTNGP15.phx.gbl...
>> Bruce already answered some of your questions, I'll just add something.
>> - Create your reports locally, deploy to the server.
>> - When it comes to webapplications, you can either link directly to each
>> report, with parameters and everything else, or you can create an iFrame
>> and make the Report Manager show up inside. (Look for tips on integrating
>> with SharePoint, even if you're not using SharePoint, as you can use some
>> of the info in your web app.)
>> http://blogs.spipp.net/kaisa/archive/2005/09/27/1185.aspx
>> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/webrssp2.mspx
>> The beauty of using an iFrame against Report Manager, is that Report
>> Manager will still deal with authentication for the different reports.
>> - Make sure to test your reports with user accounts with less priveleges
>> than yourself, before allowing your users to try them out. SOmetimes
>> setting the rights values in the datasource can be a bit tricky.
>> Kaisa M. Lindahl
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:%23ejqOcsFGHA.2444@.TK2MSFTNGP11.phx.gbl...
>>I did the process again and now -don't ask me why- it shows the report.
>> Then, as I asked you before, is the idea to create all the reports I
>> need and upload to the server?
>> My idea is to intergate that in a web application, so I expected to show
>> just the report by clicking a button. Is that possible?
>> And last but not least ;-), is it possible to dinamically -by code-
>> generate the reports temporally? I have all my queries as stored
>> procedures.
>> Thanks a lot!
>> --
>> Regards,
>> Diego F.
>>
>> "Diego F." <diegofrNO@.terra.es> escribió en el mensaje
>> news:OI94mSsFGHA.752@.TK2MSFTNGP12.phx.gbl...
>>I finally uploaded a report. I made it with Visual Studio 2005 installed
>>by SQL Server 2005. I made a report and deployed it, and in the Report
>>Manager shows the new report, but I can't see it because:
>> - 'The report server cannot process the report. The data source
>> connection information has been deleted.
>> (rsInvalidDataSourceReference).
>> I made the connection with the project.
>> If I'm understanding something, is it the idea to have all the reports
>> in the server, and the applications should link to that URL to load the
>> report?
>> Thanks a lot for your help. I really appreciate.
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:umHKqBsFGHA.2084@.TK2MSFTNGP09.phx.gbl...
>> Open IIS, a.k.a Internet Information Services Manager
>> Open your Reports site, is probably under Web SItes - Default Web
>> Site. RIght click and choose Browse. Does it open correctly?
>> If it does, what is the URL? I did a test install of the 2005 edition,
>> and I think you might get some extra "name" or something, like
>> http://localhost/reports$instancename
>> Which means that the reports are still there, but the URL might have
>> changed. Or something.
>> Also, with Sql Server 2005 there's an nice Reporting Services
>> configuration tool. Start it and look to see if there are any things
>> that needs to be started.
>> Kaisa M. Lindahl
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:usLfZ8rFGHA.208@.tk2msftngp13.phx.gbl...
>> Hi again.
>> I installed again the whole server: Window 2003 and SQL Server 2005
>> full.
>> Now I finally see the reports site :-)
>> There is a Visual Studio installed with SQL 2005 and I can design
>> reports there. But now I don't know how to configure the project to
>> deploy correctly.
>> I get that error:
>> A connection could not be made to the report server
>> http://localhost/reports
>> Additional information:
>> The attempt to connect to the report server failed. Check your
>> connection information and the report server is a compatible version.
>> (Microsoft.ReportingServices.Designer).
>> If I try with: http://localhost/reportserver then I get a compilation
>> error:
>> The Report Server Windows Service ReportServer is not running. The
>> service must be running to use the Report Server.
>> How can I solve that?
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:exkoPudFGHA.3280@.TK2MSFTNGP10.phx.gbl...
>>> Google is your friend. Type in "reporting services" 503 "service
>>> unavailable" and you'll get quite a lot of info. Not all of it is
>>> directly connected to Reporting Services, but you should be able to
>>> pick up some info on the 503 problem in general. It seems that
>>> there's a problem with the Reporting Services web service.
>>>
>>> Are you allowed to log on to the actual server and try running
>>> Report Manager from that box?
>>> What sort of authentication is set?
>>> Try adding the report server site to your Trusted sites in IE, and
>>> then change the Security Settings for Trusted Sites to "Prompt for
>>> user name and password" in User Authentication - Logon. Type in your
>>> username and password. If it fails, that might be what causes the
>>> problem. In that case, you need to figure out what rights are needed
>>> for you to access the reports.
>>>
>>> Kaisa M. Lindahl
>>>
>>>
>>> "Diego F." <diegofrNO@.terra.es> wrote in message
>>> news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
>>> I'm trying to use Reporting Services 2005. The service is running,
>>> but if I type http://192.168.1.49:8888/reportserver I see the
>>> directory list.
>>> With http://192.1681.49:8888/reports, I see an error: The request
>>> failed with HTTP status 503: Service Unavailable.The error is in
>>> URL. http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at
>>> least I know is inside the application.
>>>
>>> I'm completely stuck. What can I do or where can I search?
>>>
>>> --
>>> Regards,
>>>
>>> Diego F.
>>>
>>>
>>>
>>
>>
>>
>>
>>
>sql
type http://192.168.1.49:8888/reportserver I see the directory list.
With http://192.1681.49:8888/reports, I see an error: The request failed
with HTTP status 503: Service Unavailable.The error is in URL.
http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least I know is
inside the application.
I'm completely stuck. What can I do or where can I search?
--
Regards,
Diego F.Google is your friend. Type in "reporting services" 503 "service
unavailable" and you'll get quite a lot of info. Not all of it is directly
connected to Reporting Services, but you should be able to pick up some info
on the 503 problem in general. It seems that there's a problem with the
Reporting Services web service.
Are you allowed to log on to the actual server and try running Report
Manager from that box?
What sort of authentication is set?
Try adding the report server site to your Trusted sites in IE, and then
change the Security Settings for Trusted Sites to "Prompt for user name and
password" in User Authentication - Logon. Type in your username and
password. If it fails, that might be what causes the problem. In that case,
you need to figure out what rights are needed for you to access the reports.
Kaisa M. Lindahl
"Diego F." <diegofrNO@.terra.es> wrote in message
news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
> I'm trying to use Reporting Services 2005. The service is running, but if
> I type http://192.168.1.49:8888/reportserver I see the directory list.
> With http://192.1681.49:8888/reports, I see an error: The request failed
> with HTTP status 503: Service Unavailable.The error is in URL.
> http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least I know is
> inside the application.
> I'm completely stuck. What can I do or where can I search?
> --
> Regards,
> Diego F.
>|||Hi again.
I installed again the whole server: Window 2003 and SQL Server 2005 full.
Now I finally see the reports site :-)
There is a Visual Studio installed with SQL 2005 and I can design reports
there. But now I don't know how to configure the project to deploy
correctly.
I get that error:
A connection could not be made to the report server http://localhost/reports
Additional information:
The attempt to connect to the report server failed. Check your connection
information and the report server is a compatible version.
(Microsoft.ReportingServices.Designer).
If I try with: http://localhost/reportserver then I get a compilation error:
The Report Server Windows Service ReportServer is not running. The service
must be running to use the Report Server.
How can I solve that?
--
Regards,
Diego F.
"Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
news:exkoPudFGHA.3280@.TK2MSFTNGP10.phx.gbl...
> Google is your friend. Type in "reporting services" 503 "service
> unavailable" and you'll get quite a lot of info. Not all of it is directly
> connected to Reporting Services, but you should be able to pick up some
> info on the 503 problem in general. It seems that there's a problem with
> the Reporting Services web service.
> Are you allowed to log on to the actual server and try running Report
> Manager from that box?
> What sort of authentication is set?
> Try adding the report server site to your Trusted sites in IE, and then
> change the Security Settings for Trusted Sites to "Prompt for user name
> and password" in User Authentication - Logon. Type in your username and
> password. If it fails, that might be what causes the problem. In that
> case, you need to figure out what rights are needed for you to access the
> reports.
> Kaisa M. Lindahl
>
> "Diego F." <diegofrNO@.terra.es> wrote in message
> news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
>> I'm trying to use Reporting Services 2005. The service is running, but if
>> I type http://192.168.1.49:8888/reportserver I see the directory list.
>> With http://192.1681.49:8888/reports, I see an error: The request failed
>> with HTTP status 503: Service Unavailable.The error is in URL.
>> http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least I know is
>> inside the application.
>> I'm completely stuck. What can I do or where can I search?
>> --
>> Regards,
>> Diego F.
>|||Open IIS, a.k.a Internet Information Services Manager
Open your Reports site, is probably under Web SItes - Default Web Site.
RIght click and choose Browse. Does it open correctly?
If it does, what is the URL? I did a test install of the 2005 edition, and I
think you might get some extra "name" or something, like
http://localhost/reports$instancename
Which means that the reports are still there, but the URL might have
changed. Or something.
Also, with Sql Server 2005 there's an nice Reporting Services configuration
tool. Start it and look to see if there are any things that needs to be
started.
Kaisa M. Lindahl
"Diego F." <diegofrNO@.terra.es> wrote in message
news:usLfZ8rFGHA.208@.tk2msftngp13.phx.gbl...
> Hi again.
> I installed again the whole server: Window 2003 and SQL Server 2005 full.
> Now I finally see the reports site :-)
> There is a Visual Studio installed with SQL 2005 and I can design reports
> there. But now I don't know how to configure the project to deploy
> correctly.
> I get that error:
> A connection could not be made to the report server
> http://localhost/reports
> Additional information:
> The attempt to connect to the report server failed. Check your
> connection information and the report server is a compatible version.
> (Microsoft.ReportingServices.Designer).
> If I try with: http://localhost/reportserver then I get a compilation
> error:
> The Report Server Windows Service ReportServer is not running. The service
> must be running to use the Report Server.
> How can I solve that?
> --
> Regards,
> Diego F.
>
> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
> news:exkoPudFGHA.3280@.TK2MSFTNGP10.phx.gbl...
>> Google is your friend. Type in "reporting services" 503 "service
>> unavailable" and you'll get quite a lot of info. Not all of it is
>> directly connected to Reporting Services, but you should be able to pick
>> up some info on the 503 problem in general. It seems that there's a
>> problem with the Reporting Services web service.
>> Are you allowed to log on to the actual server and try running Report
>> Manager from that box?
>> What sort of authentication is set?
>> Try adding the report server site to your Trusted sites in IE, and then
>> change the Security Settings for Trusted Sites to "Prompt for user name
>> and password" in User Authentication - Logon. Type in your username and
>> password. If it fails, that might be what causes the problem. In that
>> case, you need to figure out what rights are needed for you to access the
>> reports.
>> Kaisa M. Lindahl
>>
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
>> I'm trying to use Reporting Services 2005. The service is running, but
>> if I type http://192.168.1.49:8888/reportserver I see the directory
>> list.
>> With http://192.1681.49:8888/reports, I see an error: The request failed
>> with HTTP status 503: Service Unavailable.The error is in URL.
>> http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least I know
>> is inside the application.
>> I'm completely stuck. What can I do or where can I search?
>> --
>> Regards,
>> Diego F.
>>
>|||I finally uploaded a report. I made it with Visual Studio 2005 installed by
SQL Server 2005. I made a report and deployed it, and in the Report Manager
shows the new report, but I can't see it because:
- 'The report server cannot process the report. The data source connection
information has been deleted. (rsInvalidDataSourceReference).
I made the connection with the project.
If I'm understanding something, is it the idea to have all the reports in
the server, and the applications should link to that URL to load the report?
Thanks a lot for your help. I really appreciate.
--
Regards,
Diego F.
"Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
news:umHKqBsFGHA.2084@.TK2MSFTNGP09.phx.gbl...
> Open IIS, a.k.a Internet Information Services Manager
> Open your Reports site, is probably under Web SItes - Default Web Site.
> RIght click and choose Browse. Does it open correctly?
> If it does, what is the URL? I did a test install of the 2005 edition, and
> I think you might get some extra "name" or something, like
> http://localhost/reports$instancename
> Which means that the reports are still there, but the URL might have
> changed. Or something.
> Also, with Sql Server 2005 there's an nice Reporting Services
> configuration tool. Start it and look to see if there are any things that
> needs to be started.
> Kaisa M. Lindahl
> "Diego F." <diegofrNO@.terra.es> wrote in message
> news:usLfZ8rFGHA.208@.tk2msftngp13.phx.gbl...
>> Hi again.
>> I installed again the whole server: Window 2003 and SQL Server 2005 full.
>> Now I finally see the reports site :-)
>> There is a Visual Studio installed with SQL 2005 and I can design reports
>> there. But now I don't know how to configure the project to deploy
>> correctly.
>> I get that error:
>> A connection could not be made to the report server
>> http://localhost/reports
>> Additional information:
>> The attempt to connect to the report server failed. Check your
>> connection information and the report server is a compatible version.
>> (Microsoft.ReportingServices.Designer).
>> If I try with: http://localhost/reportserver then I get a compilation
>> error:
>> The Report Server Windows Service ReportServer is not running. The
>> service must be running to use the Report Server.
>> How can I solve that?
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:exkoPudFGHA.3280@.TK2MSFTNGP10.phx.gbl...
>> Google is your friend. Type in "reporting services" 503 "service
>> unavailable" and you'll get quite a lot of info. Not all of it is
>> directly connected to Reporting Services, but you should be able to pick
>> up some info on the 503 problem in general. It seems that there's a
>> problem with the Reporting Services web service.
>> Are you allowed to log on to the actual server and try running Report
>> Manager from that box?
>> What sort of authentication is set?
>> Try adding the report server site to your Trusted sites in IE, and then
>> change the Security Settings for Trusted Sites to "Prompt for user name
>> and password" in User Authentication - Logon. Type in your username and
>> password. If it fails, that might be what causes the problem. In that
>> case, you need to figure out what rights are needed for you to access
>> the reports.
>> Kaisa M. Lindahl
>>
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
>> I'm trying to use Reporting Services 2005. The service is running, but
>> if I type http://192.168.1.49:8888/reportserver I see the directory
>> list.
>> With http://192.1681.49:8888/reports, I see an error: The request
>> failed with HTTP status 503: Service Unavailable.The error is in URL.
>> http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least I know
>> is inside the application.
>> I'm completely stuck. What can I do or where can I search?
>> --
>> Regards,
>> Diego F.
>>
>>
>|||I did the process again and now -don't ask me why- it shows the report.
Then, as I asked you before, is the idea to create all the reports I need
and upload to the server?
My idea is to intergate that in a web application, so I expected to show
just the report by clicking a button. Is that possible?
And last but not least ;-), is it possible to dinamically -by code- generate
the reports temporally? I have all my queries as stored procedures.
Thanks a lot!
--
Regards,
Diego F.
"Diego F." <diegofrNO@.terra.es> escribió en el mensaje
news:OI94mSsFGHA.752@.TK2MSFTNGP12.phx.gbl...
>I finally uploaded a report. I made it with Visual Studio 2005 installed by
>SQL Server 2005. I made a report and deployed it, and in the Report Manager
>shows the new report, but I can't see it because:
> - 'The report server cannot process the report. The data source connection
> information has been deleted. (rsInvalidDataSourceReference).
> I made the connection with the project.
> If I'm understanding something, is it the idea to have all the reports in
> the server, and the applications should link to that URL to load the
> report?
> Thanks a lot for your help. I really appreciate.
> --
> Regards,
> Diego F.
>
> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
> news:umHKqBsFGHA.2084@.TK2MSFTNGP09.phx.gbl...
>> Open IIS, a.k.a Internet Information Services Manager
>> Open your Reports site, is probably under Web SItes - Default Web Site.
>> RIght click and choose Browse. Does it open correctly?
>> If it does, what is the URL? I did a test install of the 2005 edition,
>> and I think you might get some extra "name" or something, like
>> http://localhost/reports$instancename
>> Which means that the reports are still there, but the URL might have
>> changed. Or something.
>> Also, with Sql Server 2005 there's an nice Reporting Services
>> configuration tool. Start it and look to see if there are any things that
>> needs to be started.
>> Kaisa M. Lindahl
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:usLfZ8rFGHA.208@.tk2msftngp13.phx.gbl...
>> Hi again.
>> I installed again the whole server: Window 2003 and SQL Server 2005
>> full.
>> Now I finally see the reports site :-)
>> There is a Visual Studio installed with SQL 2005 and I can design
>> reports there. But now I don't know how to configure the project to
>> deploy correctly.
>> I get that error:
>> A connection could not be made to the report server
>> http://localhost/reports
>> Additional information:
>> The attempt to connect to the report server failed. Check your
>> connection information and the report server is a compatible version.
>> (Microsoft.ReportingServices.Designer).
>> If I try with: http://localhost/reportserver then I get a compilation
>> error:
>> The Report Server Windows Service ReportServer is not running. The
>> service must be running to use the Report Server.
>> How can I solve that?
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:exkoPudFGHA.3280@.TK2MSFTNGP10.phx.gbl...
>> Google is your friend. Type in "reporting services" 503 "service
>> unavailable" and you'll get quite a lot of info. Not all of it is
>> directly connected to Reporting Services, but you should be able to
>> pick up some info on the 503 problem in general. It seems that there's
>> a problem with the Reporting Services web service.
>> Are you allowed to log on to the actual server and try running Report
>> Manager from that box?
>> What sort of authentication is set?
>> Try adding the report server site to your Trusted sites in IE, and then
>> change the Security Settings for Trusted Sites to "Prompt for user name
>> and password" in User Authentication - Logon. Type in your username and
>> password. If it fails, that might be what causes the problem. In that
>> case, you need to figure out what rights are needed for you to access
>> the reports.
>> Kaisa M. Lindahl
>>
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
>> I'm trying to use Reporting Services 2005. The service is running, but
>> if I type http://192.168.1.49:8888/reportserver I see the directory
>> list.
>> With http://192.1681.49:8888/reports, I see an error: The request
>> failed with HTTP status 503: Service Unavailable.The error is in URL.
>> http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least I know
>> is inside the application.
>> I'm completely stuck. What can I do or where can I search?
>> --
>> Regards,
>> Diego F.
>>
>>
>>
>|||There are three ways to integrate with RS 2005.
1. URL Integration
2. Web Services
3. Visual Studio 2005 Reporting Control
The reporting control has a local mode, you get it a datatable and a report.
I suggest you back up and learn how to create reports before you deal with
integration. There is a lot more that you have to do in local mode.
Normal function is to create a report and deploy it. Make sure it works from
the shipping portal (Report Manager web site).
Have your queries as stored procedures is great. No reason to create the RDL
on the fly. Just pass parameters to the report and use your stored
procedure.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Diego F." <diegofrNO@.terra.es> wrote in message
news:%23ejqOcsFGHA.2444@.TK2MSFTNGP11.phx.gbl...
>I did the process again and now -don't ask me why- it shows the report.
> Then, as I asked you before, is the idea to create all the reports I need
> and upload to the server?
> My idea is to intergate that in a web application, so I expected to show
> just the report by clicking a button. Is that possible?
> And last but not least ;-), is it possible to dinamically -by code-
> generate the reports temporally? I have all my queries as stored
> procedures.
> Thanks a lot!
> --
> Regards,
> Diego F.
>
> "Diego F." <diegofrNO@.terra.es> escribió en el mensaje
> news:OI94mSsFGHA.752@.TK2MSFTNGP12.phx.gbl...
>>I finally uploaded a report. I made it with Visual Studio 2005 installed
>>by SQL Server 2005. I made a report and deployed it, and in the Report
>>Manager shows the new report, but I can't see it because:
>> - 'The report server cannot process the report. The data source
>> connection information has been deleted. (rsInvalidDataSourceReference).
>> I made the connection with the project.
>> If I'm understanding something, is it the idea to have all the reports in
>> the server, and the applications should link to that URL to load the
>> report?
>> Thanks a lot for your help. I really appreciate.
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:umHKqBsFGHA.2084@.TK2MSFTNGP09.phx.gbl...
>> Open IIS, a.k.a Internet Information Services Manager
>> Open your Reports site, is probably under Web SItes - Default Web Site.
>> RIght click and choose Browse. Does it open correctly?
>> If it does, what is the URL? I did a test install of the 2005 edition,
>> and I think you might get some extra "name" or something, like
>> http://localhost/reports$instancename
>> Which means that the reports are still there, but the URL might have
>> changed. Or something.
>> Also, with Sql Server 2005 there's an nice Reporting Services
>> configuration tool. Start it and look to see if there are any things
>> that needs to be started.
>> Kaisa M. Lindahl
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:usLfZ8rFGHA.208@.tk2msftngp13.phx.gbl...
>> Hi again.
>> I installed again the whole server: Window 2003 and SQL Server 2005
>> full.
>> Now I finally see the reports site :-)
>> There is a Visual Studio installed with SQL 2005 and I can design
>> reports there. But now I don't know how to configure the project to
>> deploy correctly.
>> I get that error:
>> A connection could not be made to the report server
>> http://localhost/reports
>> Additional information:
>> The attempt to connect to the report server failed. Check your
>> connection information and the report server is a compatible version.
>> (Microsoft.ReportingServices.Designer).
>> If I try with: http://localhost/reportserver then I get a compilation
>> error:
>> The Report Server Windows Service ReportServer is not running. The
>> service must be running to use the Report Server.
>> How can I solve that?
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:exkoPudFGHA.3280@.TK2MSFTNGP10.phx.gbl...
>> Google is your friend. Type in "reporting services" 503 "service
>> unavailable" and you'll get quite a lot of info. Not all of it is
>> directly connected to Reporting Services, but you should be able to
>> pick up some info on the 503 problem in general. It seems that there's
>> a problem with the Reporting Services web service.
>> Are you allowed to log on to the actual server and try running Report
>> Manager from that box?
>> What sort of authentication is set?
>> Try adding the report server site to your Trusted sites in IE, and
>> then change the Security Settings for Trusted Sites to "Prompt for
>> user name and password" in User Authentication - Logon. Type in your
>> username and password. If it fails, that might be what causes the
>> problem. In that case, you need to figure out what rights are needed
>> for you to access the reports.
>> Kaisa M. Lindahl
>>
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
>> I'm trying to use Reporting Services 2005. The service is running,
>> but if I type http://192.168.1.49:8888/reportserver I see the
>> directory list.
>> With http://192.1681.49:8888/reports, I see an error: The request
>> failed with HTTP status 503: Service Unavailable.The error is in URL.
>> http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least I
>> know is inside the application.
>> I'm completely stuck. What can I do or where can I search?
>> --
>> Regards,
>> Diego F.
>>
>>
>>
>>
>|||Bruce already answered some of your questions, I'll just add something.
- Create your reports locally, deploy to the server.
- When it comes to webapplications, you can either link directly to each
report, with parameters and everything else, or you can create an iFrame and
make the Report Manager show up inside. (Look for tips on integrating with
SharePoint, even if you're not using SharePoint, as you can use some of the
info in your web app.)
http://blogs.spipp.net/kaisa/archive/2005/09/27/1185.aspx
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/webrssp2.mspx
The beauty of using an iFrame against Report Manager, is that Report Manager
will still deal with authentication for the different reports.
- Make sure to test your reports with user accounts with less priveleges
than yourself, before allowing your users to try them out. SOmetimes setting
the rights values in the datasource can be a bit tricky.
Kaisa M. Lindahl
"Diego F." <diegofrNO@.terra.es> wrote in message
news:%23ejqOcsFGHA.2444@.TK2MSFTNGP11.phx.gbl...
>I did the process again and now -don't ask me why- it shows the report.
> Then, as I asked you before, is the idea to create all the reports I need
> and upload to the server?
> My idea is to intergate that in a web application, so I expected to show
> just the report by clicking a button. Is that possible?
> And last but not least ;-), is it possible to dinamically -by code-
> generate the reports temporally? I have all my queries as stored
> procedures.
> Thanks a lot!
> --
> Regards,
> Diego F.
>
> "Diego F." <diegofrNO@.terra.es> escribió en el mensaje
> news:OI94mSsFGHA.752@.TK2MSFTNGP12.phx.gbl...
>>I finally uploaded a report. I made it with Visual Studio 2005 installed
>>by SQL Server 2005. I made a report and deployed it, and in the Report
>>Manager shows the new report, but I can't see it because:
>> - 'The report server cannot process the report. The data source
>> connection information has been deleted. (rsInvalidDataSourceReference).
>> I made the connection with the project.
>> If I'm understanding something, is it the idea to have all the reports in
>> the server, and the applications should link to that URL to load the
>> report?
>> Thanks a lot for your help. I really appreciate.
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:umHKqBsFGHA.2084@.TK2MSFTNGP09.phx.gbl...
>> Open IIS, a.k.a Internet Information Services Manager
>> Open your Reports site, is probably under Web SItes - Default Web Site.
>> RIght click and choose Browse. Does it open correctly?
>> If it does, what is the URL? I did a test install of the 2005 edition,
>> and I think you might get some extra "name" or something, like
>> http://localhost/reports$instancename
>> Which means that the reports are still there, but the URL might have
>> changed. Or something.
>> Also, with Sql Server 2005 there's an nice Reporting Services
>> configuration tool. Start it and look to see if there are any things
>> that needs to be started.
>> Kaisa M. Lindahl
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:usLfZ8rFGHA.208@.tk2msftngp13.phx.gbl...
>> Hi again.
>> I installed again the whole server: Window 2003 and SQL Server 2005
>> full.
>> Now I finally see the reports site :-)
>> There is a Visual Studio installed with SQL 2005 and I can design
>> reports there. But now I don't know how to configure the project to
>> deploy correctly.
>> I get that error:
>> A connection could not be made to the report server
>> http://localhost/reports
>> Additional information:
>> The attempt to connect to the report server failed. Check your
>> connection information and the report server is a compatible version.
>> (Microsoft.ReportingServices.Designer).
>> If I try with: http://localhost/reportserver then I get a compilation
>> error:
>> The Report Server Windows Service ReportServer is not running. The
>> service must be running to use the Report Server.
>> How can I solve that?
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:exkoPudFGHA.3280@.TK2MSFTNGP10.phx.gbl...
>> Google is your friend. Type in "reporting services" 503 "service
>> unavailable" and you'll get quite a lot of info. Not all of it is
>> directly connected to Reporting Services, but you should be able to
>> pick up some info on the 503 problem in general. It seems that there's
>> a problem with the Reporting Services web service.
>> Are you allowed to log on to the actual server and try running Report
>> Manager from that box?
>> What sort of authentication is set?
>> Try adding the report server site to your Trusted sites in IE, and
>> then change the Security Settings for Trusted Sites to "Prompt for
>> user name and password" in User Authentication - Logon. Type in your
>> username and password. If it fails, that might be what causes the
>> problem. In that case, you need to figure out what rights are needed
>> for you to access the reports.
>> Kaisa M. Lindahl
>>
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
>> I'm trying to use Reporting Services 2005. The service is running,
>> but if I type http://192.168.1.49:8888/reportserver I see the
>> directory list.
>> With http://192.1681.49:8888/reports, I see an error: The request
>> failed with HTTP status 503: Service Unavailable.The error is in URL.
>> http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least I
>> know is inside the application.
>> I'm completely stuck. What can I do or where can I search?
>> --
>> Regards,
>> Diego F.
>>
>>
>>
>>
>|||Thank you. I'm trying to use just the URL to see the report, so it
integrates easily with my application.
I tried with a test server I installed just to make tests with that. The
only problem I met is that I have to put user and password, but I hope that
doing from the same domain avoids that.
Anyway, it's a lot of work to manually create each report from a whole
application.
--
Regards,
Diego F.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> escribió en el mensaje
news:usBxTgsFGHA.1192@.TK2MSFTNGP11.phx.gbl...
> There are three ways to integrate with RS 2005.
> 1. URL Integration
> 2. Web Services
> 3. Visual Studio 2005 Reporting Control
> The reporting control has a local mode, you get it a datatable and a
> report.
> I suggest you back up and learn how to create reports before you deal with
> integration. There is a lot more that you have to do in local mode.
> Normal function is to create a report and deploy it. Make sure it works
> from the shipping portal (Report Manager web site).
> Have your queries as stored procedures is great. No reason to create the
> RDL on the fly. Just pass parameters to the report and use your stored
> procedure.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Diego F." <diegofrNO@.terra.es> wrote in message
> news:%23ejqOcsFGHA.2444@.TK2MSFTNGP11.phx.gbl...
>>I did the process again and now -don't ask me why- it shows the report.
>> Then, as I asked you before, is the idea to create all the reports I need
>> and upload to the server?
>> My idea is to intergate that in a web application, so I expected to show
>> just the report by clicking a button. Is that possible?
>> And last but not least ;-), is it possible to dinamically -by code-
>> generate the reports temporally? I have all my queries as stored
>> procedures.
>> Thanks a lot!
>> --
>> Regards,
>> Diego F.
>>
>> "Diego F." <diegofrNO@.terra.es> escribió en el mensaje
>> news:OI94mSsFGHA.752@.TK2MSFTNGP12.phx.gbl...
>>I finally uploaded a report. I made it with Visual Studio 2005 installed
>>by SQL Server 2005. I made a report and deployed it, and in the Report
>>Manager shows the new report, but I can't see it because:
>> - 'The report server cannot process the report. The data source
>> connection information has been deleted. (rsInvalidDataSourceReference).
>> I made the connection with the project.
>> If I'm understanding something, is it the idea to have all the reports
>> in the server, and the applications should link to that URL to load the
>> report?
>> Thanks a lot for your help. I really appreciate.
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:umHKqBsFGHA.2084@.TK2MSFTNGP09.phx.gbl...
>> Open IIS, a.k.a Internet Information Services Manager
>> Open your Reports site, is probably under Web SItes - Default Web Site.
>> RIght click and choose Browse. Does it open correctly?
>> If it does, what is the URL? I did a test install of the 2005 edition,
>> and I think you might get some extra "name" or something, like
>> http://localhost/reports$instancename
>> Which means that the reports are still there, but the URL might have
>> changed. Or something.
>> Also, with Sql Server 2005 there's an nice Reporting Services
>> configuration tool. Start it and look to see if there are any things
>> that needs to be started.
>> Kaisa M. Lindahl
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:usLfZ8rFGHA.208@.tk2msftngp13.phx.gbl...
>> Hi again.
>> I installed again the whole server: Window 2003 and SQL Server 2005
>> full.
>> Now I finally see the reports site :-)
>> There is a Visual Studio installed with SQL 2005 and I can design
>> reports there. But now I don't know how to configure the project to
>> deploy correctly.
>> I get that error:
>> A connection could not be made to the report server
>> http://localhost/reports
>> Additional information:
>> The attempt to connect to the report server failed. Check your
>> connection information and the report server is a compatible version.
>> (Microsoft.ReportingServices.Designer).
>> If I try with: http://localhost/reportserver then I get a compilation
>> error:
>> The Report Server Windows Service ReportServer is not running. The
>> service must be running to use the Report Server.
>> How can I solve that?
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:exkoPudFGHA.3280@.TK2MSFTNGP10.phx.gbl...
>> Google is your friend. Type in "reporting services" 503 "service
>> unavailable" and you'll get quite a lot of info. Not all of it is
>> directly connected to Reporting Services, but you should be able to
>> pick up some info on the 503 problem in general. It seems that
>> there's a problem with the Reporting Services web service.
>> Are you allowed to log on to the actual server and try running Report
>> Manager from that box?
>> What sort of authentication is set?
>> Try adding the report server site to your Trusted sites in IE, and
>> then change the Security Settings for Trusted Sites to "Prompt for
>> user name and password" in User Authentication - Logon. Type in your
>> username and password. If it fails, that might be what causes the
>> problem. In that case, you need to figure out what rights are needed
>> for you to access the reports.
>> Kaisa M. Lindahl
>>
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
>>> I'm trying to use Reporting Services 2005. The service is running,
>>> but if I type http://192.168.1.49:8888/reportserver I see the
>>> directory list.
>>> With http://192.1681.49:8888/reports, I see an error: The request
>>> failed with HTTP status 503: Service Unavailable.The error is in
>>> URL. http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least
>>> I know is inside the application.
>>>
>>> I'm completely stuck. What can I do or where can I search?
>>>
>>> --
>>> Regards,
>>>
>>> Diego F.
>>>
>>
>>
>>
>>
>>
>|||I'll also use SharePoint to integrate the whole application, so I'll check
that.
Where can I set the reports permissions?
--
Regards,
Diego F.
"Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
news:uF8RP1sFGHA.532@.TK2MSFTNGP15.phx.gbl...
> Bruce already answered some of your questions, I'll just add something.
> - Create your reports locally, deploy to the server.
> - When it comes to webapplications, you can either link directly to each
> report, with parameters and everything else, or you can create an iFrame
> and make the Report Manager show up inside. (Look for tips on integrating
> with SharePoint, even if you're not using SharePoint, as you can use some
> of the info in your web app.)
> http://blogs.spipp.net/kaisa/archive/2005/09/27/1185.aspx
> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/webrssp2.mspx
> The beauty of using an iFrame against Report Manager, is that Report
> Manager will still deal with authentication for the different reports.
> - Make sure to test your reports with user accounts with less priveleges
> than yourself, before allowing your users to try them out. SOmetimes
> setting the rights values in the datasource can be a bit tricky.
> Kaisa M. Lindahl
> "Diego F." <diegofrNO@.terra.es> wrote in message
> news:%23ejqOcsFGHA.2444@.TK2MSFTNGP11.phx.gbl...
>>I did the process again and now -don't ask me why- it shows the report.
>> Then, as I asked you before, is the idea to create all the reports I need
>> and upload to the server?
>> My idea is to intergate that in a web application, so I expected to show
>> just the report by clicking a button. Is that possible?
>> And last but not least ;-), is it possible to dinamically -by code-
>> generate the reports temporally? I have all my queries as stored
>> procedures.
>> Thanks a lot!
>> --
>> Regards,
>> Diego F.
>>
>> "Diego F." <diegofrNO@.terra.es> escribió en el mensaje
>> news:OI94mSsFGHA.752@.TK2MSFTNGP12.phx.gbl...
>>I finally uploaded a report. I made it with Visual Studio 2005 installed
>>by SQL Server 2005. I made a report and deployed it, and in the Report
>>Manager shows the new report, but I can't see it because:
>> - 'The report server cannot process the report. The data source
>> connection information has been deleted. (rsInvalidDataSourceReference).
>> I made the connection with the project.
>> If I'm understanding something, is it the idea to have all the reports
>> in the server, and the applications should link to that URL to load the
>> report?
>> Thanks a lot for your help. I really appreciate.
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:umHKqBsFGHA.2084@.TK2MSFTNGP09.phx.gbl...
>> Open IIS, a.k.a Internet Information Services Manager
>> Open your Reports site, is probably under Web SItes - Default Web Site.
>> RIght click and choose Browse. Does it open correctly?
>> If it does, what is the URL? I did a test install of the 2005 edition,
>> and I think you might get some extra "name" or something, like
>> http://localhost/reports$instancename
>> Which means that the reports are still there, but the URL might have
>> changed. Or something.
>> Also, with Sql Server 2005 there's an nice Reporting Services
>> configuration tool. Start it and look to see if there are any things
>> that needs to be started.
>> Kaisa M. Lindahl
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:usLfZ8rFGHA.208@.tk2msftngp13.phx.gbl...
>> Hi again.
>> I installed again the whole server: Window 2003 and SQL Server 2005
>> full.
>> Now I finally see the reports site :-)
>> There is a Visual Studio installed with SQL 2005 and I can design
>> reports there. But now I don't know how to configure the project to
>> deploy correctly.
>> I get that error:
>> A connection could not be made to the report server
>> http://localhost/reports
>> Additional information:
>> The attempt to connect to the report server failed. Check your
>> connection information and the report server is a compatible version.
>> (Microsoft.ReportingServices.Designer).
>> If I try with: http://localhost/reportserver then I get a compilation
>> error:
>> The Report Server Windows Service ReportServer is not running. The
>> service must be running to use the Report Server.
>> How can I solve that?
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:exkoPudFGHA.3280@.TK2MSFTNGP10.phx.gbl...
>> Google is your friend. Type in "reporting services" 503 "service
>> unavailable" and you'll get quite a lot of info. Not all of it is
>> directly connected to Reporting Services, but you should be able to
>> pick up some info on the 503 problem in general. It seems that
>> there's a problem with the Reporting Services web service.
>> Are you allowed to log on to the actual server and try running Report
>> Manager from that box?
>> What sort of authentication is set?
>> Try adding the report server site to your Trusted sites in IE, and
>> then change the Security Settings for Trusted Sites to "Prompt for
>> user name and password" in User Authentication - Logon. Type in your
>> username and password. If it fails, that might be what causes the
>> problem. In that case, you need to figure out what rights are needed
>> for you to access the reports.
>> Kaisa M. Lindahl
>>
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
>>> I'm trying to use Reporting Services 2005. The service is running,
>>> but if I type http://192.168.1.49:8888/reportserver I see the
>>> directory list.
>>> With http://192.1681.49:8888/reports, I see an error: The request
>>> failed with HTTP status 503: Service Unavailable.The error is in
>>> URL. http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least
>>> I know is inside the application.
>>>
>>> I'm completely stuck. What can I do or where can I search?
>>>
>>> --
>>> Regards,
>>>
>>> Diego F.
>>>
>>
>>
>>
>>
>>
>|||On either a folder or a single report: Click Properties and the Security.
ANd then you can add what users and groups are allowed to see or update
reports.
Kaisa
"Diego F." <diegofrNO@.terra.es> wrote in message
news:%23ToFp6sFGHA.916@.TK2MSFTNGP10.phx.gbl...
> I'll also use SharePoint to integrate the whole application, so I'll check
> that.
> Where can I set the reports permissions?
> --
> Regards,
> Diego F.
>
> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
> news:uF8RP1sFGHA.532@.TK2MSFTNGP15.phx.gbl...
>> Bruce already answered some of your questions, I'll just add something.
>> - Create your reports locally, deploy to the server.
>> - When it comes to webapplications, you can either link directly to each
>> report, with parameters and everything else, or you can create an iFrame
>> and make the Report Manager show up inside. (Look for tips on integrating
>> with SharePoint, even if you're not using SharePoint, as you can use some
>> of the info in your web app.)
>> http://blogs.spipp.net/kaisa/archive/2005/09/27/1185.aspx
>> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/webrssp2.mspx
>> The beauty of using an iFrame against Report Manager, is that Report
>> Manager will still deal with authentication for the different reports.
>> - Make sure to test your reports with user accounts with less priveleges
>> than yourself, before allowing your users to try them out. SOmetimes
>> setting the rights values in the datasource can be a bit tricky.
>> Kaisa M. Lindahl
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:%23ejqOcsFGHA.2444@.TK2MSFTNGP11.phx.gbl...
>>I did the process again and now -don't ask me why- it shows the report.
>> Then, as I asked you before, is the idea to create all the reports I
>> need and upload to the server?
>> My idea is to intergate that in a web application, so I expected to show
>> just the report by clicking a button. Is that possible?
>> And last but not least ;-), is it possible to dinamically -by code-
>> generate the reports temporally? I have all my queries as stored
>> procedures.
>> Thanks a lot!
>> --
>> Regards,
>> Diego F.
>>
>> "Diego F." <diegofrNO@.terra.es> escribió en el mensaje
>> news:OI94mSsFGHA.752@.TK2MSFTNGP12.phx.gbl...
>>I finally uploaded a report. I made it with Visual Studio 2005 installed
>>by SQL Server 2005. I made a report and deployed it, and in the Report
>>Manager shows the new report, but I can't see it because:
>> - 'The report server cannot process the report. The data source
>> connection information has been deleted.
>> (rsInvalidDataSourceReference).
>> I made the connection with the project.
>> If I'm understanding something, is it the idea to have all the reports
>> in the server, and the applications should link to that URL to load the
>> report?
>> Thanks a lot for your help. I really appreciate.
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:umHKqBsFGHA.2084@.TK2MSFTNGP09.phx.gbl...
>> Open IIS, a.k.a Internet Information Services Manager
>> Open your Reports site, is probably under Web SItes - Default Web
>> Site. RIght click and choose Browse. Does it open correctly?
>> If it does, what is the URL? I did a test install of the 2005 edition,
>> and I think you might get some extra "name" or something, like
>> http://localhost/reports$instancename
>> Which means that the reports are still there, but the URL might have
>> changed. Or something.
>> Also, with Sql Server 2005 there's an nice Reporting Services
>> configuration tool. Start it and look to see if there are any things
>> that needs to be started.
>> Kaisa M. Lindahl
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:usLfZ8rFGHA.208@.tk2msftngp13.phx.gbl...
>> Hi again.
>> I installed again the whole server: Window 2003 and SQL Server 2005
>> full.
>> Now I finally see the reports site :-)
>> There is a Visual Studio installed with SQL 2005 and I can design
>> reports there. But now I don't know how to configure the project to
>> deploy correctly.
>> I get that error:
>> A connection could not be made to the report server
>> http://localhost/reports
>> Additional information:
>> The attempt to connect to the report server failed. Check your
>> connection information and the report server is a compatible version.
>> (Microsoft.ReportingServices.Designer).
>> If I try with: http://localhost/reportserver then I get a compilation
>> error:
>> The Report Server Windows Service ReportServer is not running. The
>> service must be running to use the Report Server.
>> How can I solve that?
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:exkoPudFGHA.3280@.TK2MSFTNGP10.phx.gbl...
>>> Google is your friend. Type in "reporting services" 503 "service
>>> unavailable" and you'll get quite a lot of info. Not all of it is
>>> directly connected to Reporting Services, but you should be able to
>>> pick up some info on the 503 problem in general. It seems that
>>> there's a problem with the Reporting Services web service.
>>>
>>> Are you allowed to log on to the actual server and try running
>>> Report Manager from that box?
>>> What sort of authentication is set?
>>> Try adding the report server site to your Trusted sites in IE, and
>>> then change the Security Settings for Trusted Sites to "Prompt for
>>> user name and password" in User Authentication - Logon. Type in your
>>> username and password. If it fails, that might be what causes the
>>> problem. In that case, you need to figure out what rights are needed
>>> for you to access the reports.
>>>
>>> Kaisa M. Lindahl
>>>
>>>
>>> "Diego F." <diegofrNO@.terra.es> wrote in message
>>> news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
>>> I'm trying to use Reporting Services 2005. The service is running,
>>> but if I type http://192.168.1.49:8888/reportserver I see the
>>> directory list.
>>> With http://192.1681.49:8888/reports, I see an error: The request
>>> failed with HTTP status 503: Service Unavailable.The error is in
>>> URL. http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at
>>> least I know is inside the application.
>>>
>>> I'm completely stuck. What can I do or where can I search?
>>>
>>> --
>>> Regards,
>>>
>>> Diego F.
>>>
>>>
>>>
>>
>>
>>
>>
>>
>sql
Subscribe to:
Posts (Atom)