Showing posts with label professional. Show all posts
Showing posts with label professional. Show all posts

Saturday, February 25, 2012

Can't connet to MSDE with Query Analyzer

I'm running MSDE on a WIN2K and I'm having a problem accessing the MSDE from
a laptop with WINXP Professional. I'm using a NETGEAR MR314 cable router w/
firewall to connect the two computers and I'm getting the following error:
Unable to connec to server SERVERNAME
Server: Msg 17, Level 16, State1
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
access denied
I've tried by creating a new account with owner rights to all databases and
I still get the same error when connecting with Query Analyzer. When I get
the "Connect to SQL Server" dialog box I can see the server but when I enter
the user name an password it gives me the error message.
The client is attempting to connect using TCP/IP so you will
want to make sure this protocol is enabled for MSDE. You can
use the server network utility to check, enable the
protocols. The utility file name is svrnetcn.exe. You can
find it in the Tools\Binn directory of your installation
path.
You can also find some general troubleshooting for the error
at:
INF: Potential Causes of the "SQL Server Does Not Exist or
Access Denied" Error Message
http://support.microsoft.com/?id=328306
-Sue
On Sun, 2 May 2004 16:00:49 -0500, "Sal Young"
<salyoung@.comcast.net> wrote:

>I'm running MSDE on a WIN2K and I'm having a problem accessing the MSDE from
>a laptop with WINXP Professional. I'm using a NETGEAR MR314 cable router w/
>firewall to connect the two computers and I'm getting the following error:
>Unable to connec to server SERVERNAME
>Server: Msg 17, Level 16, State1
>[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
>access denied
>
>I've tried by creating a new account with owner rights to all databases and
>I still get the same error when connecting with Query Analyzer. When I get
>the "Connect to SQL Server" dialog box I can see the server but when I enter
>the user name an password it gives me the error message.
>

Can't connet to MSDE with Query Analyzer

I'm running MSDE on a WIN2K and I'm having a problem accessing the MSDE from
a laptop with WINXP Professional. I'm using a NETGEAR MR314 cable router w/
firewall to connect the two computers and I'm getting the following error:
Unable to connec to server SERVERNAME
Server: Msg 17, Level 16, State1
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not
exist or
access denied
I've tried by creating a new account with owner rights to all databases and
I still get the same error when connecting with Query Analyzer. When I get
the "Connect to SQL Server" dialog box I can see the server but when I enter
the user name an password it gives me the error message.Hi Sal,
Try creating a Test ODBC DSN to the MSDE server. Then review the OS
Error returned.
This will help troubleshoot the problem.
Example:
10060 = Connection Timeout
11001 = Host not found.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Can't connet to MSDE with Query Analyzer

I'm running MSDE on a WIN2K and I'm having a problem accessing the MSDE from
a laptop with WINXP Professional. I'm using a NETGEAR MR314 cable router w/
firewall to connect the two computers and I'm getting the following error:
Unable to connec to server SERVERNAME
Server: Msg 17, Level 16, State1
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
access denied
I've tried by creating a new account with owner rights to all databases and
I still get the same error when connecting with Query Analyzer. When I get
the "Connect to SQL Server" dialog box I can see the server but when I enter
the user name an password it gives me the error message.
MSDE doesn't listen to any netlibs by default. You can enable netlibs using the svrnetcn.exe utility.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Sal Young" <salyoung@.comcast.net> wrote in message news:MMadnZ23tfPw_AjdRVn-sA@.comcast.com...
> I'm running MSDE on a WIN2K and I'm having a problem accessing the MSDE from
> a laptop with WINXP Professional. I'm using a NETGEAR MR314 cable router w/
> firewall to connect the two computers and I'm getting the following error:
> Unable to connec to server SERVERNAME
> Server: Msg 17, Level 16, State1
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
> access denied
>
> I've tried by creating a new account with owner rights to all databases and
> I still get the same error when connecting with Query Analyzer. When I get
> the "Connect to SQL Server" dialog box I can see the server but when I enter
> the user name an password it gives me the error message.
>

Can't connet to MSDE with Query Analyzer

I'm running MSDE on a WIN2K and I'm having a problem accessing the MSDE from
a laptop with WINXP Professional. I'm using a NETGEAR MR314 cable router w/
firewall to connect the two computers and I'm getting the following error:
Unable to connec to server SERVERNAME
Server: Msg 17, Level 16, State1
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
access denied
I've tried by creating a new account with owner rights to all databases and
I still get the same error when connecting with Query Analyzer. When I get
the "Connect to SQL Server" dialog box I can see the server but when I enter
the user name an password it gives me the error message.
Hi Sal,
Try creating a Test ODBC DSN to the MSDE server. Then review the OS
Error returned.
This will help troubleshoot the problem.
Example:
10060 = Connection Timeout
11001 = Host not found.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Tuesday, February 14, 2012

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

Can't connect to MSDE with Query Analyzer

I'm running MSDE on a WIN2K and I'm having a problem accessing the MSDE from
a laptop with WINXP Professional. I'm using a NETGEAR MR314 cable router w/
firewall to connect the two computers and I'm getting the following error:
Unable to connec to server SERVERNAME
Server: Msg 17, Level 16, State1
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
access denied
I've tried by creating a new account with owner rights to all databases and
I still get the same error when connecting with Query Analyzer. When I get
the "Connect to SQL Server" dialog box I can see the server but when I enter
the user name an password it gives me the error message.
To start with, run the following command using ISQL.exe
ISQL -Stcp:ServerNameHere -Usa -Ppassword -Q"select @.@.version"
The reason why I am asking you to do this is because this will help you in
troubleshooting the error. Try looking for the OS Error returned.
I am suspecting that the server is not listening on the port and you can
try to restart MSSQLServer and can verify that SQL is listening. Hope this
helps.
Sanchan [MSFT]
sanchans@.online.microsoft.com
This posting is provided "AS IS" with no warranties, and confers no rights.