Can't find the server management studio

hey,

i did the installation, everything went well.

when i want to start the server management studio it isn't in the program files listed.

is there something i can do about it. i did the installation three times now and it didn't change a thing.

all comments are welcome

greetz

TjAnNeHi,

seems you did not insta′ll the client components. If you have another edition than SQL Server Express

(because this does not come with any clients components, unless you install the SQL Server Express Advanced Edition, but as for the non.-Advanced edition you can download the Express Management Studio from here: http://msdn.microsoft.com/vstudio/express/sql/download/)

you can simply rerun the installer and select the client components as well. If this does not solve the problem, please provide some more details about the edition of SQL Server and the SP level.

HTH, Jens K. Suessmeyer.

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

During the setup screen process you can choose custom installation and select 'entire feature to be installed on hard drive'. That takes care the installation of required components of tools.

Also explain the steps you are taking to install the tools in this case.

|||I've the developper edition 2005

in fact there're no clients to check

service pack 2

where can i find these

TjAnNE|||the problem is solved
i installed the client and everything works fine,

thx for the tip

TjAnNesql

Cant find SMSS

After installing the evaluation edition of MSSQL Enterprise 2005 I can not find SSMS. I know I installed the client tools upon installation. It's not showing up on in the menu, where is the location for the executable file.

Is SSMS even distriubted with the evaluation edition?

If not, is it possible to download it from somwhere...

Did you get any warnings while setup cheked your computer configuration?

Did you specify client tools installation during setup?

P.S. This question suits http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=95&SiteID=1 forum better.

|||

SSMS is part of the evaluation edition. To see a report of what's installed go to Add/Remove Programs, select the entry for "Microsoft SQL Server 2005", select "Change", then select "Report". Under "Common Components" you'll want to see something like this:

Workstation Components
[Version: 9.00.1399.06 Edition: Evaluation Edition Patch level: 9.00.1399.06 Language: English (United States)]

If you see this and still don't think you have SSMS installed, close the report. On the "Change" dialog you should see an entry for Workstation Components, select it and press "Next". This will launch the component in maintenance mode. Just follow the dialogs. When you get to the feature tree be sure to select Management Tools under the Client Components node.

SSMS is installed to %ProgramFiles%\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\sqlwb.exe

|||Thanks for your reply::

I got the evauation to work when I downloaded the DVD image and burnt it to disk, and did a fresh install...

I'm now in the process of converting my MySQL talbles over to MSSQL... weeee fun... SSIS takes some of the headake away!|||Excellent!

can't find Enterprise Manager and Query Analyzer after setup

I downloaded the trial version of sql server 2005. but after installation, I couldnt find the Enterprise Manager and Query Analyzer. Any idea about that? Thanks.

Hi zhishan,

I believe those services can be configured from control panel (turn windows features on or off). Check the boxes next to enterprise manager services and query analyzer, then ok, and windows wil configure and update for those services.

|||Thanks djartsinc - do you know where on the control panel has the function? I spent a long time trying to find, but couldn't...|||

Which Edition of SQL Server 2005 do you download? If it is SQL Server 2005 Express, such tool is not included. Please try SQL Server 2005 Expree with Advanced Services, which includes tools. You can get it from the same download website as SQL Server 2005 Express.

Can't debug proc after Sp2 on WinXP

Hi,
After installation of SP2 on my WinXP Prof I can't run debug in SQL Query
Analyzer.
Unable to connect to debugger on "SERVER" (Error = 0x800706ba). Ensure that
client-side components, such as SQLDBREG.EXE, are installed and registered on
"MYXP". Debugging disabled for connection nn.
Server is Win 2003 and SQL 2000 with Sp3
Before Sp2 everything was OK.
Thanks for the help.
ML
Make sure you have followed all the steps in the help topic
in books online: Troubleshooting the Transact-SQL Debugger
You should also check the following knowledge base article:
INF: T-SQL Debugger Is Turned Off By Default for Earlier
Clients After You Install SQL Server 2000 Service Pack 3
http://support.microsoft.com/?id=328151
-Sue
On Wed, 27 Oct 2004 05:13:03 -0700, MarekL
<MarekL@.discussions.microsoft.com> wrote:

>Hi,
>After installation of SP2 on my WinXP Prof I can't run debug in SQL Query
>Analyzer.
>Unable to connect to debugger on "SERVER" (Error = 0x800706ba). Ensure that
>client-side components, such as SQLDBREG.EXE, are installed and registered on
>"MYXP". Debugging disabled for connection nn.
>Server is Win 2003 and SQL 2000 with Sp3
>Before Sp2 everything was OK.
>Thanks for the help.
>ML

Can't create http endpoint - don't have permission

I am trying to install an application that have following code in SQL Server
installation script
CREATE ENDPOINT RequirementsAuthoring
STATE = STARTED
AS HTTP (
SITE = '*',
PATH = '/sql/RequirementsAuthoring',
AUTHENTICATION = (INTEGRATED),
PORTS=(CLEAR)
)
FOR SOAP (...
I get following error
The user 'SIATA\Shimon' does not have permission to register endpoint
'RequirementsAuthoring' on the specified URL. Please ensure the URL refers
to a namespace that is reserved for listening by SQL.
I logged as computer admin on Windows XP with IIS installed.
I tried to run
sp_reserve_http_namespace N'http://Siata:80/sql/RequirementsAuthoring'
That runs just fine. But I still get the same error when I run first script.
Any suggestions?
Thanks,
ShimonHello Shimon,
Although you are logged into Windows as an Admin, that doesn't automatically
make you a member of SA role. Can you do this:
use master
go
grant create endpoint to [your-domain\your-account]
Thanks,
Kent Tegels, DevelopMentor
http://staff.develop.com/ktegels/|||Thanks for fast replay.
No, I can't do it I got this
Cannot find the login 'Siata\Shimon', because it does not exist or you do
not have permission.
I don't get this but. When I am using Management Studio I get this ID as
logged in ID.
I am probably the member of BUILDIN/Administrators
Any solution?
Thanks
"Kent Tegels" <ktegels@.develop.com> wrote in message
news:b87ad741b7c58c89f11cfb03360@.news.microsoft.com...
> Hello Shimon,
> Although you are logged into Windows as an Admin, that doesn't
> automatically make you a member of SA role. Can you do this:
> use master
> go
> grant create endpoint to [your-domain\your-account]
> Thanks,
> Kent Tegels, DevelopMentor
> http://staff.develop.com/ktegels/
>|||Well I created the log in and run your script. It worked. I still have the
same error with original script.
How can I confirm that the namespace 'is reserved for listening by SQL.'
Thanks
"Kent Tegels" <ktegels@.develop.com> wrote in message
news:b87ad741b7c58c89f11cfb03360@.news.microsoft.com...
> Hello Shimon,
> Although you are logged into Windows as an Admin, that doesn't
> automatically make you a member of SA role. Can you do this:
> use master
> go
> grant create endpoint to [your-domain\your-account]
> Thanks,
> Kent Tegels, DevelopMentor
> http://staff.develop.com/ktegels/
>

Cant connect to SQL Server 2005 with Pet Shop 4.0 : No process at other end of pipe?!

I downloaded MS Pet Shop 4.0 recently for best-practice training purposes. The installation went smoothly with a SQL Server 2005 backend. At first I had a problem authenticating the mspetshop4 user in the database, but that was solved by fixing some settings with the password policy. Now the mspetshop4 user is authenticated properly, but I came across this error instead:

Server Error in '/Web' Application.A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.Exception Details: System.Data.SqlClient.SqlException: A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)Source Error:Line 216:Line 217: if (conn.State != ConnectionState.Open)Line 218: conn.Open();Line 219:Line 220: cmd.Connection = conn;Source File: C:\Program Files\Microsoft\.NET Pet Shop 4.0\DBUtility\SQLHelper.cs Line: 218Stack Trace:[SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +117 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +346 System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) +619 System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj) +224 System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32 bytesExpected) +113 System.Data.SqlClient.TdsParserStateObject.ReadBuffer() +59 System.Data.SqlClient.TdsParserStateObject.ReadByte() +36 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +181 System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +56 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +1083 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +272 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +688 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +82 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +558 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +126 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +651 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +160 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +122 System.Data.SqlClient.SqlConnection.Open() +229 PetShop.DBUtility.SqlHelper.PrepareCommand(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, CommandType cmdType, String cmdText, SqlParameter[] cmdParms) in C:\Program Files\Microsoft\.NET Pet Shop 4.0\DBUtility\SQLHelper.cs:218 PetShop.DBUtility.SqlHelper.ExecuteReader(String connectionString, CommandType cmdType, String cmdText, SqlParameter[] commandParameters) in C:\Program Files\Microsoft\.NET Pet Shop 4.0\DBUtility\SQLHelper.cs:127 PetShop.SQLServerDAL.Category.GetCategories() in C:\Program Files\Microsoft\.NET Pet Shop 4.0\SQLServer\Category.cs:27 PetShop.BLL.Category.GetCategories() in C:\Program Files\Microsoft\.NET Pet Shop 4.0\BLL\Category.cs:20 PetShop.Web.NavigationControl.BindCategories() in c:\Program Files\Microsoft\.NET Pet Shop 4.0\Web\Controls\NavigationControl.ascx.cs:53 PetShop.Web.NavigationControl.Page_Load(Object sender, EventArgs e) in c:\Program Files\Microsoft\.NET Pet Shop 4.0\Web\Controls\NavigationControl.ascx.cs:27 System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +31 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +68 System.Web.UI.Control.OnLoad(EventArgs e) +88 System.Web.UI.Control.LoadRecursive() +74 System.Web.UI.Control.LoadRecursive() +158 System.Web.UI.BasePartialCachingControl.LoadRecursive() +61 System.Web.UI.Control.LoadRecursive() +158 System.Web.UI.Control.LoadRecursive() +158 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3035Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

Now I'm clueless. What does No process at the other end of the pipe mean?Check if SQL Server is configured to accept Local and Remote Connections (using tcp) in Surface Area Configuration Manager. Also, check to see if your SQL Server is configured to accept connections over both TCP/IP and named pipes.|||

Hi, quick searched on these forums and I found a post with excatly similar issue as yours, hope this helps:

http://forums.asp.net/thread/1072499.aspx

Can't connect to Report Server via Management Studio

Hi,

I have a local installation of SQL Server 2005 (Developer Edition) on XP Professional SP2, with Reporting Services, Integration Services, and Analysis Server installed.

I can connect to Integration Services and Analysis Server via the SQL Server Management Studio, but not to the Report Server. I can access and use the Report Server installation via http://localhost/Reports and http://localhost/ReportServer, and everything checks out on the Reporting Services Configuration tool, so the server appears to be working fine.

I've uninstalled/re-formatted/reinstalled the services (with all default options, and services running as "Local Service"), but always end up with the following error when connecting to Report Server via Management Studio:

The request failed with HTTP status 503: Service Unavailable. (Microsoft.SqlServer.Management.UI.RSClient)

Program Location:
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at Microsoft.SqlServer.Management.UI.RSClient.RSClientConnection.CreateConnection(String connectionString)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.CreateConnectionObject()
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.RSType.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()
Any hints would be appreciated...

Thanks,
/vijayan

There are two server addresses you can use in the SSMS connection dialog:

http://servername/reportserver

or

servername/instance

The second uses WMI to enumerate the instance so you either need to be an administrator or in the DCOM users group on the server machine.|||Thanks for your reply; I tried the 'http://' address, and that fails with exactly the same error. Also, I am an administrator.

Indeed, I can't connect to RS installations on other servers either, while other users are able to. They also connect successfully to my RS instance via SSMS... so it appears to be something completely on my client that I need to fix.

Run out of ideas to try...

/v|||This is a bit of a stretch, but you can try www.sysinternals.com filemon utility and look for access denied or buffer overflow messages when connecting. If you can narrow it down to a file permissions problem it may be easier to troubleshoot.
Also try using your machine name or IP address to connect rather than localhost.|||

You don't have any other version of the .NET Framework on the client machine, do you? Maybe uninstalling the SQL tools and the .NET framework and the reinstalling might help. I've never seen this before.

|||

Vijayan

Did you manage to solve this problem? I am getting the same error message (HTTP Status 503) when connecting to Report Server from Management Studio. Any advice would be appreciated.

Thanks

Brad

|||Vijayan -

I am also having the same problem. and I have no idea on how to trouble shoot it? Can you let us know if you made any progress on the resolution of the issue?

Jim|||

I am also having the same problem. Tried everything, no solution yet. My server is having two SQL Server instances SQL 2000 and 2005, will this be a problem. It doesn't connect to IIS.

Roshan.

|||

Can you open IIS manager in MMC and tell me what the settings are for the reportserver virtual directory?

I firstly, can you provide the directory to which the reportserver virtual directory is pointing

Secondly, what are the script mappings for the virtual directory? You can get to this from the properties page for the V-dir and then clicking the 'configuration' button.

Lastly, if there is an ASP.Net tab, what is the value set to?

If there isn't a reportserer virtual directory, is there one called reportserver$InstanceName?

If there is no virtual directory starting with report server, can you open the reporting services configuration tool from the start menu and create one on the report server virtual directory tab?

Thanks!

-Lukasz

|||

Hi Lukasz,

Following are the information requested.

ReportServer virtual directory is pointing to :

C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer

Mappings:

Application extensions: There are no entries

Wildcard application maps:

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll

Options:

Enable session state : Ticked

Enable buffering : Ticked

Default ASP Language : VBScript

There is no ASP.Net tab.

Best Regards,

Roshan.

|||

Do you know if you installed .Net Framework v2 before you had IIS installed? If you did or if the following registry key is not present, you'll need to register ASP.NET.

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ASP.NET\2.0.50727.0

If it does not exist, run the command:

aspnet_regiis.exe -i

from the folder:

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\

You may want to run it regardless just to ensure ASP.NET is registered correctly on your computer. Note this does have consequences for encryption keys for the ASP.NET account (and consequently the RS 2000). Before running the command back up your symmetric key for the RS2K server using:

rskeymgmt.exe

-Lukasz

|||

Hi Lukas,

Thanks for the reply.

I tried with registering ASP.NET again, but still it's not connecting to Report Server using SQL Mgmt Studio. Also it's not connecting to Report Manager using Internet explorer too. I have created a report server project and deployed a sample report to IIS, it's working and I can view it from the browser.

Thanks,

Roshan.

|||

So if you open the report server virtual directory in IE you can browse the report server namespace and execute the report, but if you try to view the report using report manager, it doesn't work?

That is really unusual.

When you say you deploy the report to IIS - did you use the Deploy feature of Report Designer?

-Lukasz

|||Has anyone found an answer to this issue? I am having the same problem.|||

Can you provide more info on exactly how you reproduce the problem?

Can you provide answers to my post above?

-Lukasz

Can't connect to Report Server via Management Studio

Hi,

I have a local installation of SQL Server 2005 (Developer Edition) on XP Professional SP2, with Reporting Services, Integration Services, and Analysis Server installed.

I can connect to Integration Services and Analysis Server via the SQL Server Management Studio, but not to the Report Server. I can access and use the Report Server installation via http://localhost/Reports and http://localhost/ReportServer, and everything checks out on the Reporting Services Configuration tool, so the server appears to be working fine.

I've uninstalled/re-formatted/reinstalled the services (with all default options, and services running as "Local Service"), but always end up with the following error when connecting to Report Server via Management Studio:

The request failed with HTTP status 503: Service Unavailable. (Microsoft.SqlServer.Management.UI.RSClient)

Program Location:
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at Microsoft.SqlServer.Management.UI.RSClient.RSClientConnection.CreateConnection(String connectionString)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.CreateConnectionObject()
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.RSType.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()
Any hints would be appreciated...

Thanks,
/vijayan

There are two server addresses you can use in the SSMS connection dialog:

http://servername/reportserver

or

servername/instance

The second uses WMI to enumerate the instance so you either need to be an administrator or in the DCOM users group on the server machine.|||Thanks for your reply; I tried the 'http://' address, and that fails with exactly the same error. Also, I am an administrator.

Indeed, I can't connect to RS installations on other servers either, while other users are able to. They also connect successfully to my RS instance via SSMS... so it appears to be something completely on my client that I need to fix.

Run out of ideas to try...

/v|||This is a bit of a stretch, but you can try www.sysinternals.com filemon utility and look for access denied or buffer overflow messages when connecting. If you can narrow it down to a file permissions problem it may be easier to troubleshoot.
Also try using your machine name or IP address to connect rather than localhost.|||

You don't have any other version of the .NET Framework on the client machine, do you? Maybe uninstalling the SQL tools and the .NET framework and the reinstalling might help. I've never seen this before.

|||

Vijayan

Did you manage to solve this problem? I am getting the same error message (HTTP Status 503) when connecting to Report Server from Management Studio. Any advice would be appreciated.

Thanks

Brad

|||Vijayan -

I am also having the same problem. and I have no idea on how to trouble shoot it? Can you let us know if you made any progress on the resolution of the issue?

Jim|||

I am also having the same problem. Tried everything, no solution yet. My server is having two SQL Server instances SQL 2000 and 2005, will this be a problem. It doesn't connect to IIS.

Roshan.

|||

Can you open IIS manager in MMC and tell me what the settings are for the reportserver virtual directory?

I firstly, can you provide the directory to which the reportserver virtual directory is pointing

Secondly, what are the script mappings for the virtual directory? You can get to this from the properties page for the V-dir and then clicking the 'configuration' button.

Lastly, if there is an ASP.Net tab, what is the value set to?

If there isn't a reportserer virtual directory, is there one called reportserver$InstanceName?

If there is no virtual directory starting with report server, can you open the reporting services configuration tool from the start menu and create one on the report server virtual directory tab?

Thanks!

-Lukasz

|||

Hi Lukasz,

Following are the information requested.

ReportServer virtual directory is pointing to :

C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer

Mappings:

Application extensions: There are no entries

Wildcard application maps:

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll

Options:

Enable session state : Ticked

Enable buffering : Ticked

Default ASP Language : VBScript

There is no ASP.Net tab.

Best Regards,

Roshan.

|||

Do you know if you installed .Net Framework v2 before you had IIS installed? If you did or if the following registry key is not present, you'll need to register ASP.NET.

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ASP.NET\2.0.50727.0

If it does not exist, run the command:

aspnet_regiis.exe -i

from the folder:

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\

You may want to run it regardless just to ensure ASP.NET is registered correctly on your computer. Note this does have consequences for encryption keys for the ASP.NET account (and consequently the RS 2000). Before running the command back up your symmetric key for the RS2K server using:

rskeymgmt.exe

-Lukasz

|||

Hi Lukas,

Thanks for the reply.

I tried with registering ASP.NET again, but still it's not connecting to Report Server using SQL Mgmt Studio. Also it's not connecting to Report Manager using Internet explorer too. I have created a report server project and deployed a sample report to IIS, it's working and I can view it from the browser.

Thanks,

Roshan.

|||

So if you open the report server virtual directory in IE you can browse the report server namespace and execute the report, but if you try to view the report using report manager, it doesn't work?

That is really unusual.

When you say you deploy the report to IIS - did you use the Deploy feature of Report Designer?

-Lukasz

|||Has anyone found an answer to this issue? I am having the same problem.|||

Can you provide more info on exactly how you reproduce the problem?

Can you provide answers to my post above?

-Lukasz

Can't connect to Report Server via Management Studio

Hi,

I have a local installation of SQL Server 2005 (Developer Edition) on XP Professional SP2, with Reporting Services, Integration Services, and Analysis Server installed.

I can connect to Integration Services and Analysis Server via the SQL Server Management Studio, but not to the Report Server. I can access and use the Report Server installation via http://localhost/Reports and http://localhost/ReportServer, and everything checks out on the Reporting Services Configuration tool, so the server appears to be working fine.

I've uninstalled/re-formatted/reinstalled the services (with all default options, and services running as "Local Service"), but always end up with the following error when connecting to Report Server via Management Studio:

The request failed with HTTP status 503: Service Unavailable. (Microsoft.SqlServer.Management.UI.RSClient)

Program Location:
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at Microsoft.SqlServer.Management.UI.RSClient.RSClientConnection.CreateConnection(String connectionString)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.CreateConnectionObject()
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.RSType.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()
Any hints would be appreciated...

Thanks,
/vijayan

There are two server addresses you can use in the SSMS connection dialog:

http://servername/reportserver

or

servername/instance

The second uses WMI to enumerate the instance so you either need to be an administrator or in the DCOM users group on the server machine.|||Thanks for your reply; I tried the 'http://' address, and that fails with exactly the same error. Also, I am an administrator.

Indeed, I can't connect to RS installations on other servers either, while other users are able to. They also connect successfully to my RS instance via SSMS... so it appears to be something completely on my client that I need to fix.

Run out of ideas to try...

/v|||This is a bit of a stretch, but you can try www.sysinternals.com filemon utility and look for access denied or buffer overflow messages when connecting. If you can narrow it down to a file permissions problem it may be easier to troubleshoot.
Also try using your machine name or IP address to connect rather than localhost.

|||

You don't have any other version of the .NET Framework on the client machine, do you? Maybe uninstalling the SQL tools and the .NET framework and the reinstalling might help. I've never seen this before.

|||

Vijayan

Did you manage to solve this problem? I am getting the same error message (HTTP Status 503) when connecting to Report Server from Management Studio. Any advice would be appreciated.

Thanks

Brad

|||Vijayan -

I am also having the same problem. and I have no idea on how to trouble shoot it? Can you let us know if you made any progress on the resolution of the issue?

Jim|||

I am also having the same problem. Tried everything, no solution yet. My server is having two SQL Server instances SQL 2000 and 2005, will this be a problem. It doesn't connect to IIS.

Roshan.

|||

Can you open IIS manager in MMC and tell me what the settings are for the reportserver virtual directory?

I firstly, can you provide the directory to which the reportserver virtual directory is pointing

Secondly, what are the script mappings for the virtual directory? You can get to this from the properties page for the V-dir and then clicking the 'configuration' button.

Lastly, if there is an ASP.Net tab, what is the value set to?

If there isn't a reportserer virtual directory, is there one called reportserver$InstanceName?

If there is no virtual directory starting with report server, can you open the reporting services configuration tool from the start menu and create one on the report server virtual directory tab?

Thanks!

-Lukasz

|||

Hi Lukasz,

Following are the information requested.

ReportServer virtual directory is pointing to :

C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer

Mappings:

Application extensions: There are no entries

Wildcard application maps:

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll

Options:

Enable session state : Ticked

Enable buffering : Ticked

Default ASP Language : VBScript

There is no ASP.Net tab.

Best Regards,

Roshan.

|||

Do you know if you installed .Net Framework v2 before you had IIS installed? If you did or if the following registry key is not present, you'll need to register ASP.NET.

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ASP.NET\2.0.50727.0

If it does not exist, run the command:

aspnet_regiis.exe -i

from the folder:

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\

You may want to run it regardless just to ensure ASP.NET is registered correctly on your computer. Note this does have consequences for encryption keys for the ASP.NET account (and consequently the RS 2000). Before running the command back up your symmetric key for the RS2K server using:

rskeymgmt.exe

-Lukasz

|||

Hi Lukas,

Thanks for the reply.

I tried with registering ASP.NET again, but still it's not connecting to Report Server using SQL Mgmt Studio. Also it's not connecting to Report Manager using Internet explorer too. I have created a report server project and deployed a sample report to IIS, it's working and I can view it from the browser.

Thanks,

Roshan.

|||

So if you open the report server virtual directory in IE you can browse the report server namespace and execute the report, but if you try to view the report using report manager, it doesn't work?

That is really unusual.

When you say you deploy the report to IIS - did you use the Deploy feature of Report Designer?

-Lukasz

|||Has anyone found an answer to this issue? I am having the same problem.|||

Can you provide more info on exactly how you reproduce the problem?

Can you provide answers to my post above?

-Lukasz

Can't connect to Report Server via Management Studio

Hi,

I have a local installation of SQL Server 2005 (Developer Edition) on XP Professional SP2, with Reporting Services, Integration Services, and Analysis Server installed.

I can connect to Integration Services and Analysis Server via the SQL Server Management Studio, but not to the Report Server. I can access and use the Report Server installation via http://localhost/Reports and http://localhost/ReportServer, and everything checks out on the Reporting Services Configuration tool, so the server appears to be working fine.

I've uninstalled/re-formatted/reinstalled the services (with all default options, and services running as "Local Service"), but always end up with the following error when connecting to Report Server via Management Studio:

The request failed with HTTP status 503: Service Unavailable. (Microsoft.SqlServer.Management.UI.RSClient)

Program Location:
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at Microsoft.SqlServer.Management.UI.RSClient.RSClientConnection.CreateConnection(String connectionString)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.CreateConnectionObject()
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.RSType.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()
Any hints would be appreciated...

Thanks,
/vijayan

There are two server addresses you can use in the SSMS connection dialog:

http://servername/reportserver

or

servername/instance

The second uses WMI to enumerate the instance so you either need to be an administrator or in the DCOM users group on the server machine.|||Thanks for your reply; I tried the 'http://' address, and that fails with exactly the same error. Also, I am an administrator.

Indeed, I can't connect to RS installations on other servers either, while other users are able to. They also connect successfully to my RS instance via SSMS... so it appears to be something completely on my client that I need to fix.

Run out of ideas to try...

/v|||This is a bit of a stretch, but you can try www.sysinternals.com filemon utility and look for access denied or buffer overflow messages when connecting. If you can narrow it down to a file permissions problem it may be easier to troubleshoot.
Also try using your machine name or IP address to connect rather than localhost.

|||

You don't have any other version of the .NET Framework on the client machine, do you? Maybe uninstalling the SQL tools and the .NET framework and the reinstalling might help. I've never seen this before.

|||

Vijayan

Did you manage to solve this problem? I am getting the same error message (HTTP Status 503) when connecting to Report Server from Management Studio. Any advice would be appreciated.

Thanks

Brad

|||Vijayan -

I am also having the same problem. and I have no idea on how to trouble shoot it? Can you let us know if you made any progress on the resolution of the issue?

Jim|||

I am also having the same problem. Tried everything, no solution yet. My server is having two SQL Server instances SQL 2000 and 2005, will this be a problem. It doesn't connect to IIS.

Roshan.

|||

Can you open IIS manager in MMC and tell me what the settings are for the reportserver virtual directory?

I firstly, can you provide the directory to which the reportserver virtual directory is pointing

Secondly, what are the script mappings for the virtual directory? You can get to this from the properties page for the V-dir and then clicking the 'configuration' button.

Lastly, if there is an ASP.Net tab, what is the value set to?

If there isn't a reportserer virtual directory, is there one called reportserver$InstanceName?

If there is no virtual directory starting with report server, can you open the reporting services configuration tool from the start menu and create one on the report server virtual directory tab?

Thanks!

-Lukasz

|||

Hi Lukasz,

Following are the information requested.

ReportServer virtual directory is pointing to :

C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer

Mappings:

Application extensions: There are no entries

Wildcard application maps:

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll

Options:

Enable session state : Ticked

Enable buffering : Ticked

Default ASP Language : VBScript

There is no ASP.Net tab.

Best Regards,

Roshan.

|||

Do you know if you installed .Net Framework v2 before you had IIS installed? If you did or if the following registry key is not present, you'll need to register ASP.NET.

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ASP.NET\2.0.50727.0

If it does not exist, run the command:

aspnet_regiis.exe -i

from the folder:

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\

You may want to run it regardless just to ensure ASP.NET is registered correctly on your computer. Note this does have consequences for encryption keys for the ASP.NET account (and consequently the RS 2000). Before running the command back up your symmetric key for the RS2K server using:

rskeymgmt.exe

-Lukasz

|||

Hi Lukas,

Thanks for the reply.

I tried with registering ASP.NET again, but still it's not connecting to Report Server using SQL Mgmt Studio. Also it's not connecting to Report Manager using Internet explorer too. I have created a report server project and deployed a sample report to IIS, it's working and I can view it from the browser.

Thanks,

Roshan.

|||

So if you open the report server virtual directory in IE you can browse the report server namespace and execute the report, but if you try to view the report using report manager, it doesn't work?

That is really unusual.

When you say you deploy the report to IIS - did you use the Deploy feature of Report Designer?

-Lukasz

|||Has anyone found an answer to this issue? I am having the same problem.|||

Can you provide more info on exactly how you reproduce the problem?

Can you provide answers to my post above?

-Lukasz

Can't connect to Report Server via Management Studio

Hi,

I have a local installation of SQL Server 2005 (Developer Edition) on XP Professional SP2, with Reporting Services, Integration Services, and Analysis Server installed.

I can connect to Integration Services and Analysis Server via the SQL Server Management Studio, but not to the Report Server. I can access and use the Report Server installation via http://localhost/Reports and http://localhost/ReportServer, and everything checks out on the Reporting Services Configuration tool, so the server appears to be working fine.

I've uninstalled/re-formatted/reinstalled the services (with all default options, and services running as "Local Service"), but always end up with the following error when connecting to Report Server via Management Studio:

The request failed with HTTP status 503: Service Unavailable. (Microsoft.SqlServer.Management.UI.RSClient)

Program Location:
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at Microsoft.SqlServer.Management.UI.RSClient.RSClientConnection.CreateConnection(String connectionString)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.CreateConnectionObject()
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.RSType.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()
Any hints would be appreciated...

Thanks,
/vijayan

There are two server addresses you can use in the SSMS connection dialog:

http://servername/reportserver

or

servername/instance

The second uses WMI to enumerate the instance so you either need to be an administrator or in the DCOM users group on the server machine.|||Thanks for your reply; I tried the 'http://' address, and that fails with exactly the same error. Also, I am an administrator.

Indeed, I can't connect to RS installations on other servers either, while other users are able to. They also connect successfully to my RS instance via SSMS... so it appears to be something completely on my client that I need to fix.

Run out of ideas to try...

/v|||This is a bit of a stretch, but you can try www.sysinternals.com filemon utility and look for access denied or buffer overflow messages when connecting. If you can narrow it down to a file permissions problem it may be easier to troubleshoot.
Also try using your machine name or IP address to connect rather than localhost.

|||

You don't have any other version of the .NET Framework on the client machine, do you? Maybe uninstalling the SQL tools and the .NET framework and the reinstalling might help. I've never seen this before.

|||

Vijayan

Did you manage to solve this problem? I am getting the same error message (HTTP Status 503) when connecting to Report Server from Management Studio. Any advice would be appreciated.

Thanks

Brad

|||Vijayan -

I am also having the same problem. and I have no idea on how to trouble shoot it? Can you let us know if you made any progress on the resolution of the issue?

Jim|||

I am also having the same problem. Tried everything, no solution yet. My server is having two SQL Server instances SQL 2000 and 2005, will this be a problem. It doesn't connect to IIS.

Roshan.

|||

Can you open IIS manager in MMC and tell me what the settings are for the reportserver virtual directory?

I firstly, can you provide the directory to which the reportserver virtual directory is pointing

Secondly, what are the script mappings for the virtual directory? You can get to this from the properties page for the V-dir and then clicking the 'configuration' button.

Lastly, if there is an ASP.Net tab, what is the value set to?

If there isn't a reportserer virtual directory, is there one called reportserver$InstanceName?

If there is no virtual directory starting with report server, can you open the reporting services configuration tool from the start menu and create one on the report server virtual directory tab?

Thanks!

-Lukasz

|||

Hi Lukasz,

Following are the information requested.

ReportServer virtual directory is pointing to :

C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer

Mappings:

Application extensions: There are no entries

Wildcard application maps:

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll

Options:

Enable session state : Ticked

Enable buffering : Ticked

Default ASP Language : VBScript

There is no ASP.Net tab.

Best Regards,

Roshan.

|||

Do you know if you installed .Net Framework v2 before you had IIS installed? If you did or if the following registry key is not present, you'll need to register ASP.NET.

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ASP.NET\2.0.50727.0

If it does not exist, run the command:

aspnet_regiis.exe -i

from the folder:

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\

You may want to run it regardless just to ensure ASP.NET is registered correctly on your computer. Note this does have consequences for encryption keys for the ASP.NET account (and consequently the RS 2000). Before running the command back up your symmetric key for the RS2K server using:

rskeymgmt.exe

-Lukasz

|||

Hi Lukas,

Thanks for the reply.

I tried with registering ASP.NET again, but still it's not connecting to Report Server using SQL Mgmt Studio. Also it's not connecting to Report Manager using Internet explorer too. I have created a report server project and deployed a sample report to IIS, it's working and I can view it from the browser.

Thanks,

Roshan.

|||

So if you open the report server virtual directory in IE you can browse the report server namespace and execute the report, but if you try to view the report using report manager, it doesn't work?

That is really unusual.

When you say you deploy the report to IIS - did you use the Deploy feature of Report Designer?

-Lukasz

|||Has anyone found an answer to this issue? I am having the same problem.|||

Can you provide more info on exactly how you reproduce the problem?

Can you provide answers to my post above?

-Lukasz

Can't connect to Report Server via Management Studio

Hi,

I have a local installation of SQL Server 2005 (Developer Edition) on XP Professional SP2, with Reporting Services, Integration Services, and Analysis Server installed.

I can connect to Integration Services and Analysis Server via the SQL Server Management Studio, but not to the Report Server. I can access and use the Report Server installation via http://localhost/Reports and http://localhost/ReportServer, and everything checks out on the Reporting Services Configuration tool, so the server appears to be working fine.

I've uninstalled/re-formatted/reinstalled the services (with all default options, and services running as "Local Service"), but always end up with the following error when connecting to Report Server via Management Studio:

The request failed with HTTP status 503: Service Unavailable. (Microsoft.SqlServer.Management.UI.RSClient)

Program Location:
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at Microsoft.SqlServer.Management.UI.RSClient.RSClientConnection.CreateConnection(String connectionString)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.CreateConnectionObject()
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.RSType.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()
Any hints would be appreciated...

Thanks,
/vijayan

There are two server addresses you can use in the SSMS connection dialog:

http://servername/reportserver

or

servername/instance

The second uses WMI to enumerate the instance so you either need to be an administrator or in the DCOM users group on the server machine.|||Thanks for your reply; I tried the 'http://' address, and that fails with exactly the same error. Also, I am an administrator.

Indeed, I can't connect to RS installations on other servers either, while other users are able to. They also connect successfully to my RS instance via SSMS... so it appears to be something completely on my client that I need to fix.

Run out of ideas to try...

/v|||This is a bit of a stretch, but you can try www.sysinternals.com filemon utility and look for access denied or buffer overflow messages when connecting. If you can narrow it down to a file permissions problem it may be easier to troubleshoot.
Also try using your machine name or IP address to connect rather than localhost.|||

You don't have any other version of the .NET Framework on the client machine, do you? Maybe uninstalling the SQL tools and the .NET framework and the reinstalling might help. I've never seen this before.

|||

Vijayan

Did you manage to solve this problem? I am getting the same error message (HTTP Status 503) when connecting to Report Server from Management Studio. Any advice would be appreciated.

Thanks

Brad

|||Vijayan -

I am also having the same problem. and I have no idea on how to trouble shoot it? Can you let us know if you made any progress on the resolution of the issue?

Jim|||

I am also having the same problem. Tried everything, no solution yet. My server is having two SQL Server instances SQL 2000 and 2005, will this be a problem. It doesn't connect to IIS.

Roshan.

|||

Can you open IIS manager in MMC and tell me what the settings are for the reportserver virtual directory?

I firstly, can you provide the directory to which the reportserver virtual directory is pointing

Secondly, what are the script mappings for the virtual directory? You can get to this from the properties page for the V-dir and then clicking the 'configuration' button.

Lastly, if there is an ASP.Net tab, what is the value set to?

If there isn't a reportserer virtual directory, is there one called reportserver$InstanceName?

If there is no virtual directory starting with report server, can you open the reporting services configuration tool from the start menu and create one on the report server virtual directory tab?

Thanks!

-Lukasz

|||

Hi Lukasz,

Following are the information requested.

ReportServer virtual directory is pointing to :

C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer

Mappings:

Application extensions: There are no entries

Wildcard application maps:

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll

Options:

Enable session state : Ticked

Enable buffering : Ticked

Default ASP Language : VBScript

There is no ASP.Net tab.

Best Regards,

Roshan.

|||

Do you know if you installed .Net Framework v2 before you had IIS installed? If you did or if the following registry key is not present, you'll need to register ASP.NET.

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ASP.NET\2.0.50727.0

If it does not exist, run the command:

aspnet_regiis.exe -i

from the folder:

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\

You may want to run it regardless just to ensure ASP.NET is registered correctly on your computer. Note this does have consequences for encryption keys for the ASP.NET account (and consequently the RS 2000). Before running the command back up your symmetric key for the RS2K server using:

rskeymgmt.exe

-Lukasz

|||

Hi Lukas,

Thanks for the reply.

I tried with registering ASP.NET again, but still it's not connecting to Report Server using SQL Mgmt Studio. Also it's not connecting to Report Manager using Internet explorer too. I have created a report server project and deployed a sample report to IIS, it's working and I can view it from the browser.

Thanks,

Roshan.

|||

So if you open the report server virtual directory in IE you can browse the report server namespace and execute the report, but if you try to view the report using report manager, it doesn't work?

That is really unusual.

When you say you deploy the report to IIS - did you use the Deploy feature of Report Designer?

-Lukasz

|||Has anyone found an answer to this issue? I am having the same problem.|||

Can you provide more info on exactly how you reproduce the problem?

Can you provide answers to my post above?

-Lukasz