install SQL on WinXP: windows

Showing posts with label windows. Show all posts

Thursday, March 29, 2012

Can not install Reporting Services, Help!

Hi,
I'm running Windows XP and SQL Server Developer Edition (sp3) and I'm trying
to install the MS SQL Server Reporting Services that is in the MSDN of April
2004. I also have Visual studio.net installed.
So when I run the CD all goes well until you specify the database for the
reporting server and then I get the following error:
"This edition of the Report Server Database is not supported on the edition
of SQL Server 2000 you have chosen. Please choose on that matches the
requirements."
MS Requirements are SQL 2000 Standard, SQL 2000 Enterprise, and SQL 2000
Developer edition.
What does this mean, any comments or feedback will be greately appreciated.
- SergioI would verify that you are running the developer addition. You can do that
by running this SELECT statement on your XP machine:
SELECT SERVERPROPERTY ('edition')
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"SD" <npspam@.nowhere.net> wrote in message
news:f000323c8d8a00f8f3a9e2a81b3d483d@.ne
ws.teranews.com...
> Hi,
> I'm running Windows XP and SQL Server Developer Edition (sp3) and I'm
trying
> to install the MS SQL Server Reporting Services that is in the MSDN of
April
> 2004. I also have Visual studio.net installed.
> So when I run the CD all goes well until you specify the database for the
> reporting server and then I get the following error:
> "This edition of the Report Server Database is not supported on the
edition
> of SQL Server 2000 you have chosen. Please choose on that matches the
> requirements."
> MS Requirements are SQL 2000 Standard, SQL 2000 Enterprise, and SQL 2000
> Developer edition.
> What does this mean, any comments or feedback will be greately
appreciated.
> - Sergio
>|||Ha!
I wasn't for some stupid reason I was running the personal edition. Thanks
for your help, I would still be wasting time if I hadn't followed your
suggestion.
Thank you a heap.
"Gregory A. Larsen" <greg.larsen@.netzero.com> wrote in message
news:%23SBoVWUMEHA.3348@.TK2MSFTNGP09.phx.gbl...
> I would verify that you are running the developer addition. You can do
that
> by running this SELECT statement on your XP machine:
> SELECT SERVERPROPERTY ('edition')
> --
> ----
--
> ----
--
> --
> Need SQL Server Examples check out my website at
> http://www.geocities.com/sqlserverexamples
> "SD" <npspam@.nowhere.net> wrote in message
> news:f000323c8d8a00f8f3a9e2a81b3d483d@.ne
ws.teranews.com...
> trying
> April
the[vbcol=seagreen]
> edition
> appreciated.
>|||I am running SQL Server developer and got the same message. However, I
continued with the installation and it works fine. That is, it works
in VS.NET 2003. I can create new "business intelligence" projects.
"SD" <npspam@.nowhere.net> wrote in message news:<ab8fe521601065edf8fa050f7602dbb6@.news.teran
ews.com>...[vbcol=seagreen]
> Ha!
> I wasn't for some stupid reason I was running the personal edition. Thanks
> for your help, I would still be wasting time if I hadn't followed your
> suggestion.
> Thank you a heap.
>
> "Gregory A. Larsen" <greg.larsen@.netzero.com> wrote in message
> news:%23SBoVWUMEHA.3348@.TK2MSFTNGP09.phx.gbl...
> that
> --
> --
> trying
> April
> the
> edition
> appreciated.

Can not install Reporting Services, Help!

Hi,
I'm running Windows XP and SQL Server Developer Edition (sp3) and I'm trying
to install the MS SQL Server Reporting Services that is in the MSDN of April
2004. I also have Visual studio.net installed.
So when I run the CD all goes well until you specify the database for the
reporting server and then I get the following error:
"This edition of the Report Server Database is not supported on the edition
of SQL Server 2000 you have chosen. Please choose on that matches the
requirements."
MS Requirements are SQL 2000 Standard, SQL 2000 Enterprise, and SQL 2000
Developer edition.
What does this mean, any comments or feedback will be greately appreciated.
- Sergio
I would verify that you are running the developer addition. You can do that
by running this SELECT statement on your XP machine:
SELECT SERVERPROPERTY ('edition')
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"SD" <npspam@.nowhere.net> wrote in message
news:f000323c8d8a00f8f3a9e2a81b3d483d@.news.teranew s.com...
> Hi,
> I'm running Windows XP and SQL Server Developer Edition (sp3) and I'm
trying
> to install the MS SQL Server Reporting Services that is in the MSDN of
April
> 2004. I also have Visual studio.net installed.
> So when I run the CD all goes well until you specify the database for the
> reporting server and then I get the following error:
> "This edition of the Report Server Database is not supported on the
edition
> of SQL Server 2000 you have chosen. Please choose on that matches the
> requirements."
> MS Requirements are SQL 2000 Standard, SQL 2000 Enterprise, and SQL 2000
> Developer edition.
> What does this mean, any comments or feedback will be greately
appreciated.
> - Sergio
>
|||Ha!
I wasn't for some stupid reason I was running the personal edition. Thanks
for your help, I would still be wasting time if I hadn't followed your
suggestion.
Thank you a heap.
"Gregory A. Larsen" <greg.larsen@.netzero.com> wrote in message
news:%23SBoVWUMEHA.3348@.TK2MSFTNGP09.phx.gbl...
> I would verify that you are running the developer addition. You can do
that
> by running this SELECT statement on your XP machine:
> SELECT SERVERPROPERTY ('edition')
> --
> ----
--
> ----
--[vbcol=seagreen]
> --
> Need SQL Server Examples check out my website at
> http://www.geocities.com/sqlserverexamples
> "SD" <npspam@.nowhere.net> wrote in message
> news:f000323c8d8a00f8f3a9e2a81b3d483d@.news.teranew s.com...
> trying
> April
the
> edition
> appreciated.
>
|||I am running SQL Server developer and got the same message. However, I
continued with the installation and it works fine. That is, it works
in VS.NET 2003. I can create new "business intelligence" projects.
"SD" <npspam@.nowhere.net> wrote in message news:<ab8fe521601065edf8fa050f7602dbb6@.news.terane ws.com>...[vbcol=seagreen]
> Ha!
> I wasn't for some stupid reason I was running the personal edition. Thanks
> for your help, I would still be wasting time if I hadn't followed your
> suggestion.
> Thank you a heap.
>
> "Gregory A. Larsen" <greg.larsen@.netzero.com> wrote in message
> news:%23SBoVWUMEHA.3348@.TK2MSFTNGP09.phx.gbl...
> that
> --
> --
> trying
> April
> the
> edition
> appreciated.
sql

Can not install Reporting Services, Help!

Hi,

I'm running Windows XP and SQL Server Developer Edition (sp3) and I'm trying
to install the MS SQL Server Reporting Services that is in the MSDN of April
2004. I also have Visual studio.net installed.

So when I run the CD all goes well until you specify the database for the
reporting server and then I get the following error:

"This edition of the Report Server Database is not supported on the edition
of SQL Server 2000 you have chosen. Please choose on that matches the
requirements."

MS Requirements are SQL 2000 Standard, SQL 2000 Enterprise, and SQL 2000
Developer edition.

What does this mean, any comments or feedback will be greately appreciated.

- SergioI would verify that you are running the developer addition. You can do that
by running this SELECT statement on your XP machine:

SELECT SERVERPROPERTY ('edition')

-----------------------
-----------------------
--

Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"SD" <npspam@.nowhere.net> wrote in message
news:f000323c8d8a00f8f3a9e2a81b3d483d@.news.teranew s.com...
> Hi,
> I'm running Windows XP and SQL Server Developer Edition (sp3) and I'm
trying
> to install the MS SQL Server Reporting Services that is in the MSDN of
April
> 2004. I also have Visual studio.net installed.
> So when I run the CD all goes well until you specify the database for the
> reporting server and then I get the following error:
> "This edition of the Report Server Database is not supported on the
edition
> of SQL Server 2000 you have chosen. Please choose on that matches the
> requirements."
> MS Requirements are SQL 2000 Standard, SQL 2000 Enterprise, and SQL 2000
> Developer edition.
> What does this mean, any comments or feedback will be greately
appreciated.
> - Sergio|||Ha!

I wasn't for some stupid reason I was running the personal edition. Thanks
for your help, I would still be wasting time if I hadn't followed your
suggestion.

Thank you a heap.

"Gregory A. Larsen" <greg.larsen@.netzero.com> wrote in message
news:%23SBoVWUMEHA.3348@.TK2MSFTNGP09.phx.gbl...
> I would verify that you are running the developer addition. You can do
that
> by running this SELECT statement on your XP machine:
> SELECT SERVERPROPERTY ('edition')
> --
> -----------------------
--
> -----------------------
--
> --
> Need SQL Server Examples check out my website at
> http://www.geocities.com/sqlserverexamples
> "SD" <npspam@.nowhere.net> wrote in message
> news:f000323c8d8a00f8f3a9e2a81b3d483d@.news.teranew s.com...
> > Hi,
> > I'm running Windows XP and SQL Server Developer Edition (sp3) and I'm
> trying
> > to install the MS SQL Server Reporting Services that is in the MSDN of
> April
> > 2004. I also have Visual studio.net installed.
> > So when I run the CD all goes well until you specify the database for
the
> > reporting server and then I get the following error:
> > "This edition of the Report Server Database is not supported on the
> edition
> > of SQL Server 2000 you have chosen. Please choose on that matches the
> > requirements."
> > MS Requirements are SQL 2000 Standard, SQL 2000 Enterprise, and SQL 2000
> > Developer edition.
> > What does this mean, any comments or feedback will be greately
> appreciated.
> > - Sergio|||I am running SQL Server developer and got the same message. However, I
continued with the installation and it works fine. That is, it works
in VS.NET 2003. I can create new "business intelligence" projects.

"SD" <npspam@.nowhere.net> wrote in message news:<ab8fe521601065edf8fa050f7602dbb6@.news.teranews.com >...
> Ha!
> I wasn't for some stupid reason I was running the personal edition. Thanks
> for your help, I would still be wasting time if I hadn't followed your
> suggestion.
> Thank you a heap.
>
> "Gregory A. Larsen" <greg.larsen@.netzero.com> wrote in message
> news:%23SBoVWUMEHA.3348@.TK2MSFTNGP09.phx.gbl...
> > I would verify that you are running the developer addition. You can do
> that
> > by running this SELECT statement on your XP machine:
> > SELECT SERVERPROPERTY ('edition')
> > --
> > -----------------------
> --
> > -----------------------
> --
> > --
> > Need SQL Server Examples check out my website at
> > http://www.geocities.com/sqlserverexamples
> > "SD" <npspam@.nowhere.net> wrote in message
> > news:f000323c8d8a00f8f3a9e2a81b3d483d@.news.teranew s.com...
> > > Hi,
> > > > I'm running Windows XP and SQL Server Developer Edition (sp3) and I'm
> trying
> > > to install the MS SQL Server Reporting Services that is in the MSDN of
> April
> > > 2004. I also have Visual studio.net installed.
> > > > So when I run the CD all goes well until you specify the database for
> the
> > > reporting server and then I get the following error:
> > > > "This edition of the Report Server Database is not supported on the
> edition
> > > of SQL Server 2000 you have chosen. Please choose on that matches the
> > > requirements."
> > > > MS Requirements are SQL 2000 Standard, SQL 2000 Enterprise, and SQL 2000
> > > Developer edition.
> > > > What does this mean, any comments or feedback will be greately
> appreciated.
> > > > - Sergio
> >|||How did you continue with the install. I have the same error, the
Developer Edition and when I get the error and click OK, it just returns
me to the same install step. Click Next again and I get the error message
again and so on...

Can not install Reporting Services, Help!

Hi,

So when I run the CD all goes well until you specify the database for the
reporting server and then I get the following error:

"This edition of the Report Server Database is not supported on the edition
of SQL Server 2000 you have chosen. Please choose on that matches the
requirements."

MS Requirements are SQL 2000 Standard, SQL 2000 Enterprise, and SQL 2000
Developer edition.

What does this mean, any comments or feedback will be greately appreciated.

- SergioI would verify that you are running the developer addition. You can do that
by running this SELECT statement on your XP machine:

SELECT SERVERPROPERTY ('edition')

-----------------------
-----------------------
--

I wasn't for some stupid reason I was running the personal edition. Thanks
for your help, I would still be wasting time if I hadn't followed your
suggestion.

Thank you a heap.

Sunday, March 25, 2012

Can not delete database. Gives Error 21776. Suggestions please?

Hi,
I just installed MS SQL 2000 SE then SP3 on Windows 2000 Server. I
then backed-up a database from another MS SQL 2000 server and restored
it. After the restore, I noticed not all my tables were there, so I
decided to just do an import instead of restore. So I'm now trying to
delete the restored table, but I get the following error:
Microsoft SQL-DMO:
Error 21776:[SQL-DMO]The Name 'Accounting Database' was not found in
the Database collection. If the name is a qualified name, use [] to
seperate various parts of the name, and try again.
This is causing all sorts of problems now. Is there a script or
something I can run that will remove this database 100%? I want to
start clean, but use this same DB name. If I have to do this
manually, what tables in what database do I need to modify? And why
does Microsoft make this so difficult?
Thanks,
Alex.Hi Alex,
From Query Analyzer , Login as SA and execute the below command ,
sp_helpdb
From the result set , cut and past the Accounting database name along with
the below command,
drop database <paste the dbname>
Thanks
Hari
MCDBA
"Alex" <alex@.totallynerd.com> wrote in message
news:2ba4b4eb.0310270740.3be18d34@.posting.google.com...
> Hi,
> I just installed MS SQL 2000 SE then SP3 on Windows 2000 Server. I
> then backed-up a database from another MS SQL 2000 server and restored
> it. After the restore, I noticed not all my tables were there, so I
> decided to just do an import instead of restore. So I'm now trying to
> delete the restored table, but I get the following error:
> Microsoft SQL-DMO:
> Error 21776:[SQL-DMO]The Name 'Accounting Database' was not found in
> the Database collection. If the name is a qualified name, use [] to
> seperate various parts of the name, and try again.
> This is causing all sorts of problems now. Is there a script or
> something I can run that will remove this database 100%? I want to
> start clean, but use this same DB name. If I have to do this
> manually, what tables in what database do I need to modify? And why
> does Microsoft make this so difficult?
> Thanks,
> Alex.|||drop database [Accounting Database]
You need to wrap the database name in brackets since it has a space in the
name. Or you can right click on the database in QA and drop it, provided
that there are no connections.
-Morgan
"Alex" <alex@.totallynerd.com> wrote in message
news:2ba4b4eb.0310270740.3be18d34@.posting.google.com...
> Hi,
> I just installed MS SQL 2000 SE then SP3 on Windows 2000 Server. I
> then backed-up a database from another MS SQL 2000 server and restored
> it. After the restore, I noticed not all my tables were there, so I
> decided to just do an import instead of restore. So I'm now trying to
> delete the restored table, but I get the following error:
> Microsoft SQL-DMO:
> Error 21776:[SQL-DMO]The Name 'Accounting Database' was not found in
> the Database collection. If the name is a qualified name, use [] to
> seperate various parts of the name, and try again.
> This is causing all sorts of problems now. Is there a script or
> something I can run that will remove this database 100%? I want to
> start clean, but use this same DB name. If I have to do this
> manually, what tables in what database do I need to modify? And why
> does Microsoft make this so difficult?
> Thanks,
> Alex.|||Hi ,
Just issue this command ,
drop database [Accounting Database]
Thanks
Hari
MCDBA
"Morgan" <mfears@.spamcop.net> wrote in message
news:#5IV1sLnDHA.1764@.tk2msftngp13.phx.gbl...
> drop database [Accounting Database]
> You need to wrap the database name in brackets since it has a space in the
> name. Or you can right click on the database in QA and drop it, provided
> that there are no connections.
> -Morgan
> "Alex" <alex@.totallynerd.com> wrote in message
> news:2ba4b4eb.0310270740.3be18d34@.posting.google.com...
> > Hi,
> >
> > I just installed MS SQL 2000 SE then SP3 on Windows 2000 Server. I
> > then backed-up a database from another MS SQL 2000 server and restored
> > it. After the restore, I noticed not all my tables were there, so I
> > decided to just do an import instead of restore. So I'm now trying to
> > delete the restored table, but I get the following error:
> >
> > Microsoft SQL-DMO:
> > Error 21776:[SQL-DMO]The Name 'Accounting Database' was not found in
> > the Database collection. If the name is a qualified name, use [] to
> > seperate various parts of the name, and try again.
> >
> > This is causing all sorts of problems now. Is there a script or
> > something I can run that will remove this database 100%? I want to
> > start clean, but use this same DB name. If I have to do this
> > manually, what tables in what database do I need to modify? And why
> > does Microsoft make this so difficult?
> >
> > Thanks,
> >
> > Alex.
>

Thursday, March 22, 2012

Can not connect to SQL server 2000 on windows authentication mode

Hello everyone,

We have SQL server 2000 on windows 2000. From our desktop MS Access was connected to database through ODBC. Since yesterday (after our consultant had updated another asp application in the same server) we are getting “SQL Server Error: 18452. ….. Login failed for user ‘(null)’. Reason: not associated with a trusted SQL Server connection. “

The consultant saying he did not touch any settings on server (?). And the problem is even server’s security property shows it has mixed mode authentication. But I cannot connect to server even through my SQL server enterprise manager in windows authentication mode. I can connect if I use SQL server authentication. Through ODBC I can connect also and test fine, if I use SQL authentication. But the Access application wouldn’t connect using SQL authentication in ODBC.

So, can any one help me to find out what else could be done to make sure that the server is going to accept windows authentication. I’m thinking any other settings or registry change … etc. Please help.

Thanks

You are getting the error during the communication with the Web Servcie, right ? Then you probably changed the Security of the ASP application to not allow Integrated authentication. Are you using an asp or an ASP.nET application ?

HTH, jens K. Suessmeyer.

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

Hi Jens,

No our web service is fine. We are trying to connect through ODBC and SQL enterprise manager.

|||

Hi Taposh,

Did any of the security settings on the SQL Server itself changed? (ie. was some Windows user account access removed from SQL security settings?) You can verify this by using Enterprise manager and login using "sa" and expand the server; expand Security, and then click Logins.

Unfortunately, there are a few scenarios in which you will receive an 18452 error back from the server. Some of the typical scenarios include; missing login rights for Windows users; client and server on different domains (Kerberos trust issue).

Please have a look at http://blogs.msdn.com/sql_protocols/archive/2006/12/02/understanding-kerberos-and-ntlm-authentication-in-sql-server-connections.aspx

I would also recommend searching on the web using the error message as the key phrase.

HTH,
Jimmy

Can not connect to SQL Server

I installed SQL Server 2005 (server and client components) on Windows Server 2003 with SP1. I can connect to this sql server from any other machine. However, I can not connect from this machine to sql servers on other machines. I have tried named pipe and TCP/IP. Neither of them works. The error message is can not establish connection. Any suggestion?

Thanks,

What is the exact error message ?

HTH, Jens Suessmeyer.

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

Here is the error message:

An error has occured while establishing a connection to server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Cound not open a connection to SQL Server) (Microsoft SQL Server, Error 53)

Had enabled the remote connection from other server and can connect that server from other machines.

Thanks,

|||Is a firewall (Perhaps the WIndows default one) installed and configured on the server ? Perhaps then outgoing traffic on the ports is restricted.

-Jens.|||

Also, if you're connecting to a named instance, make sure that you're either specifying the port number in the connection string or you have SQL Browser running on the server machine.

Thanks,
Il-Sung.

can not connect to Report server from SQL SERVER 2005 Management studio

Hi All,

I have a brand new install of sql server 2005 on brand new WINDOWS SERVER2003 with latest versions. Every thing works fine excepting I get a 404 when I connect to report server from management studio..

I am even able to publish reports and all the

url://localhost/reportserver

url://localhost/reports

url://localhost/reportserver/reportbuilder/reportbuilder.application

all work fine on local machine and with in the network behind the fire wall.

But when I try to connect to report server using management studio on the local server or remote server, I get the following error.

TITLE: Microsoft SQL Server Management Studio

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.SqlServer.Management.UI.RSClient)

ADDITIONAL INFORMATION:

The request failed with HTTP status 404: Not Found. (Microsoft.SqlServer.Management.UI.RSClient)

More techinal details

"===================================

Cannot connect to xxxxxxxxxxxx.

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

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.SqlServer.Management.UI.RSClient)

Program Location:

at Microsoft.SqlServer.ReportingServices2005.RSConnection.MissingEndpointException.ThrowIfEndpointMissing(WebException e)
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()

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

The request failed with HTTP status 404: Not Found. (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()

Any help would be greatly appreciated.

Bob

What are you passing in as the server name to Management Studio?

You can connect several ways

http://localhost/reportserver

servername

servername\instance

|||

I passed both the servername and the servername\instance to the management studio.

My IIS and uses port 80. I can access Reportserver, report manager and report bilder thru the Internet. I just can not connect to Report server from Management studio.

I will try connecting to RS is Management studo using http://localhost/reportserver.

Regards

Bobba

|||

Hi Brad Syputa,

Thank you for the suggestion. I worked. I was not able to try your suggestion immediatly as I was out of town.

Now I have this big question:

Why am I only able to connect to "report server" from "management studio" using

1. http://localhost/reportserver

and not using

2. servername

3. servername\instance.

Your help would save me a lot of time

Regards

Bobba(Bob)

|||

bobba wrote:

Hi Brad Syputa,

Thank you for the suggestion. I worked. I was not able to try your suggestion immediatly as I was out of town.

Now I have this big question:

Why am I only able to connect to "report server" from "management studio" using

1. http://localhost/reportserver

and not using

2. servername

3. servername\instance.

Your help would save me a lot of time

Regards

Bobba(Bob)

|||

Indeed, I am very interested in disvoering the answer. We had a developer in our organization with the same problem and could only connect by enterting http://localhost/reportserver. The DBA team is fine using servername\instance.

Is this a bug that will be resolved?

thanks in advance,

Jason Wall

|||You should be able to connect using machine\instance. This method uses WMI to get the url for SOAP calls. Will you try opening the report server config tool? Can this tool connect to the machine? Are you specifying the same instance name listed in the config tool connection dialog?|||

I have the same problem.

I can connect to the reporting service by using machine\instance in report server config tool.

But I cannot connect to the reporting service through managment studio by providing machine\instance, instead, if I use http://localhost/reportserver, I can connect to the report server through management studio.

I even tried to uninstall the report service, and reinstall it again. This problem still exists.

But the same thing does not happen on my colleague's machine.

I think it is better to look into this issue...

|||

I managed to solve this problem...

If you want to use machine\instance to connect Management studio.

You need to make sure in rsreportservice.config, element <UrlRoot>http://localhost/reportserver</UrlRoot> is correctly configured. (You can test this by visit this url)

I guess, the machine\instance will eventurally be translated to the <UrlRoot>. If the <UrlRoot> is not correct, then you will not be able to use machine\instance to connect report service.

|||the attempt to connect to the report server failed. check your connection information and that the report server is a compatible version(.Net 2003 version)|||I am try to solve this problem i give for this error"

The request failed with HTTP status 400: Bad Request. "

plz send me Slution|||hi all,
i have SQL 2205 with SP1 installed on my machine.
and i m not bale to connect to Report Server using SQL management studio as well as from web.

i have installed reporting server and database on same machine. i tried using

"http://localhost/reportserver"
"http://localhost/reports"
"http://localhost/reportmanager"

but i am not bale to connect i am getting "Service Unavailable" page.

and when i try to connect using SQL Management Studio with "servername/instance" as well as "http://localhost/reportserver" i am getting a error saying.

===================================
Cannot connect to http://localhost/reportserver.

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

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

but if i try and connect to other reporting server on other machine using web http://servername/reportserver i m able to connect it.
but dont know whats the problem on my machine.

do i need to start any services for this...

so anybody knows how to troubleshoot this issue.

Thanks in advance...

|||

Hi,

Any solution for the above mentioned problem?

have SQL 2005 without SP1 installed on my machine.
and i m not bale to connect to Report Server using SQL management studio as well as from web.

i have installed reporting server and database on same machine. i tried using

"http://localhost/reportserver"
"http://localhost/reports"
"http://localhost/reportmanager"

but i am not bale to connect i am getting "Service Unavailable" page.

and when i try to connect using SQL Management Studio with "servername/instance" it says, "No connection could not be made because the target machine actively refused it"

===================================
Cannot connect to http://localhost/reportserver.

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

Please post your suggestion, if you resolved it already.

Regards,

Bhuvana

|||i tried visiting this URL. it says 503, service un available error. Please give me the solution.|||

Something to try:

I had the same issue, what I did to fix is goto C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services and ensure that the ASPNET user has read,read&Execute and List Folder security permissions applied to all the subdirectories also ensure that you click the 'Advance' button when applying the permissions to ensure the security settings are applied to all child objects. During my installation for some reason it did not assign the proper permissions to the ASPNET user (aspnet_wp account). It couldn't even read the config files.

good luck

sql

can not connect to Report server from SQL SERVER 2005 Management studio

Hi All,

I am even able to publish reports and all the

url://localhost/reportserver

url://localhost/reports

url://localhost/reportserver/reportbuilder/reportbuilder.application

all work fine on local machine and with in the network behind the fire wall.

But when I try to connect to report server using management studio on the local server or remote server, I get the following error.

TITLE: Microsoft SQL Server Management Studio

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.SqlServer.Management.UI.RSClient)

ADDITIONAL INFORMATION:

The request failed with HTTP status 404: Not Found. (Microsoft.SqlServer.Management.UI.RSClient)

More techinal details

"===================================

Cannot connect to xxxxxxxxxxxx.

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

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.SqlServer.Management.UI.RSClient)

Program Location:

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

The request failed with HTTP status 404: Not Found. (Microsoft.SqlServer.Management.UI.RSClient)

Program Location:

Any help would be greatly appreciated.

Bob

What are you passing in as the server name to Management Studio?

You can connect several ways

http://localhost/reportserver

servername

servername\instance

|||

I passed both the servername and the servername\instance to the management studio.

My IIS and uses port 80. I can access Reportserver, report manager and report bilder thru the Internet. I just can not connect to Report server from Management studio.

I will try connecting to RS is Management studo using http://localhost/reportserver.

Regards

Bobba

|||

Hi Brad Syputa,

Thank you for the suggestion. I worked. I was not able to try your suggestion immediatly as I was out of town.

Now I have this big question:

Why am I only able to connect to "report server" from "management studio" using

1. http://localhost/reportserver

and not using

2. servername

3. servername\instance.

Your help would save me a lot of time

Regards

Bobba(Bob)

|||

bobba wrote:

Hi Brad Syputa,

Thank you for the suggestion. I worked. I was not able to try your suggestion immediatly as I was out of town.

Now I have this big question:

Why am I only able to connect to "report server" from "management studio" using

1. http://localhost/reportserver

and not using

2. servername

3. servername\instance.

Your help would save me a lot of time

Regards

Bobba(Bob)

|||

Is this a bug that will be resolved?

thanks in advance,

Jason Wall

I have the same problem.

I can connect to the reporting service by using machine\instance in report server config tool.

I even tried to uninstall the report service, and reinstall it again. This problem still exists.

But the same thing does not happen on my colleague's machine.

I think it is better to look into this issue...

|||

I managed to solve this problem...

If you want to use machine\instance to connect Management studio.

You need to make sure in rsreportservice.config, element <UrlRoot>http://localhost/reportserver</UrlRoot> is correctly configured. (You can test this by visit this url)

I guess, the machine\instance will eventurally be translated to the <UrlRoot>. If the <UrlRoot> is not correct, then you will not be able to use machine\instance to connect report service.

The request failed with HTTP status 400: Bad Request. "

plz send me Slution|||hi all,
i have SQL 2205 with SP1 installed on my machine.
and i m not bale to connect to Report Server using SQL management studio as well as from web.

i have installed reporting server and database on same machine. i tried using

"http://localhost/reportserver"
"http://localhost/reports"
"http://localhost/reportmanager"

but i am not bale to connect i am getting "Service Unavailable" page.

and when i try to connect using SQL Management Studio with "servername/instance" as well as "http://localhost/reportserver" i am getting a error saying.

===================================
Cannot connect to http://localhost/reportserver.

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

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

but if i try and connect to other reporting server on other machine using web http://servername/reportserver i m able to connect it.
but dont know whats the problem on my machine.

do i need to start any services for this...

so anybody knows how to troubleshoot this issue.

Thanks in advance...

|||

Hi,

Any solution for the above mentioned problem?

have SQL 2005 without SP1 installed on my machine.
and i m not bale to connect to Report Server using SQL management studio as well as from web.

i have installed reporting server and database on same machine. i tried using

"http://localhost/reportserver"
"http://localhost/reports"
"http://localhost/reportmanager"

but i am not bale to connect i am getting "Service Unavailable" page.

and when i try to connect using SQL Management Studio with "servername/instance" it says, "No connection could not be made because the target machine actively refused it"

===================================
Cannot connect to http://localhost/reportserver.

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

Please post your suggestion, if you resolved it already.

Regards,

Bhuvana

|||i tried visiting this URL. it says 503, service un available error. Please give me the solution.|||

Something to try:

good luck

can not connect to Report server from SQL SERVER 2005 Management studio

Hi All,

I am even able to publish reports and all the

url://localhost/reportserver

url://localhost/reports

url://localhost/reportserver/reportbuilder/reportbuilder.application

all work fine on local machine and with in the network behind the fire wall.

But when I try to connect to report server using management studio on the local server or remote server, I get the following error.

TITLE: Microsoft SQL Server Management Studio

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.SqlServer.Management.UI.RSClient)

ADDITIONAL INFORMATION:

The request failed with HTTP status 404: Not Found. (Microsoft.SqlServer.Management.UI.RSClient)

More techinal details

"===================================

Cannot connect to xxxxxxxxxxxx.

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

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.SqlServer.Management.UI.RSClient)

Program Location:

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

The request failed with HTTP status 404: Not Found. (Microsoft.SqlServer.Management.UI.RSClient)

Program Location:

Any help would be greatly appreciated.

Bob

What are you passing in as the server name to Management Studio?

You can connect several ways

http://localhost/reportserver

servername

servername\instance

|||

I passed both the servername and the servername\instance to the management studio.

My IIS and uses port 80. I can access Reportserver, report manager and report bilder thru the Internet. I just can not connect to Report server from Management studio.

I will try connecting to RS is Management studo using http://localhost/reportserver.

Regards

Bobba

|||

Hi Brad Syputa,

Thank you for the suggestion. I worked. I was not able to try your suggestion immediatly as I was out of town.

Now I have this big question:

Why am I only able to connect to "report server" from "management studio" using

1. http://localhost/reportserver

and not using

2. servername

3. servername\instance.

Your help would save me a lot of time

Regards

Bobba(Bob)

|||

bobba wrote:

Hi Brad Syputa,

Thank you for the suggestion. I worked. I was not able to try your suggestion immediatly as I was out of town.

Now I have this big question:

Why am I only able to connect to "report server" from "management studio" using

1. http://localhost/reportserver

and not using

2. servername

3. servername\instance.

Your help would save me a lot of time

Regards

Bobba(Bob)

|||

Is this a bug that will be resolved?

thanks in advance,

Jason Wall

I have the same problem.

I can connect to the reporting service by using machine\instance in report server config tool.

I even tried to uninstall the report service, and reinstall it again. This problem still exists.

But the same thing does not happen on my colleague's machine.

I think it is better to look into this issue...

|||

I managed to solve this problem...

If you want to use machine\instance to connect Management studio.

You need to make sure in rsreportservice.config, element <UrlRoot>http://localhost/reportserver</UrlRoot> is correctly configured. (You can test this by visit this url)

I guess, the machine\instance will eventurally be translated to the <UrlRoot>. If the <UrlRoot> is not correct, then you will not be able to use machine\instance to connect report service.

The request failed with HTTP status 400: Bad Request. "

plz send me Slution|||hi all,
i have SQL 2205 with SP1 installed on my machine.
and i m not bale to connect to Report Server using SQL management studio as well as from web.

i have installed reporting server and database on same machine. i tried using

"http://localhost/reportserver"
"http://localhost/reports"
"http://localhost/reportmanager"

but i am not bale to connect i am getting "Service Unavailable" page.

and when i try to connect using SQL Management Studio with "servername/instance" as well as "http://localhost/reportserver" i am getting a error saying.

===================================
Cannot connect to http://localhost/reportserver.

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

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

but if i try and connect to other reporting server on other machine using web http://servername/reportserver i m able to connect it.
but dont know whats the problem on my machine.

do i need to start any services for this...

so anybody knows how to troubleshoot this issue.

Thanks in advance...

|||

Hi,

Any solution for the above mentioned problem?

have SQL 2005 without SP1 installed on my machine.
and i m not bale to connect to Report Server using SQL management studio as well as from web.

i have installed reporting server and database on same machine. i tried using

"http://localhost/reportserver"
"http://localhost/reports"
"http://localhost/reportmanager"

but i am not bale to connect i am getting "Service Unavailable" page.

and when i try to connect using SQL Management Studio with "servername/instance" it says, "No connection could not be made because the target machine actively refused it"

===================================
Cannot connect to http://localhost/reportserver.

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

Please post your suggestion, if you resolved it already.

Regards,

Bhuvana

|||i tried visiting this URL. it says 503, service un available error. Please give me the solution.|||

Something to try:

good luck

can not connect to Report server from SQL SERVER 2005 Management studio

Hi All,

I am even able to publish reports and all the

url://localhost/reportserver

url://localhost/reports

url://localhost/reportserver/reportbuilder/reportbuilder.application

all work fine on local machine and with in the network behind the fire wall.

But when I try to connect to report server using management studio on the local server or remote server, I get the following error.

TITLE: Microsoft SQL Server Management Studio

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.SqlServer.Management.UI.RSClient)

ADDITIONAL INFORMATION:

The request failed with HTTP status 404: Not Found. (Microsoft.SqlServer.Management.UI.RSClient)

More techinal details

"===================================

Cannot connect to xxxxxxxxxxxx.

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

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.SqlServer.Management.UI.RSClient)

Program Location:

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

The request failed with HTTP status 404: Not Found. (Microsoft.SqlServer.Management.UI.RSClient)

Program Location:

Any help would be greatly appreciated.

Bob

What are you passing in as the server name to Management Studio?

You can connect several ways

http://localhost/reportserver

servername

servername\instance

|||

I passed both the servername and the servername\instance to the management studio.

My IIS and uses port 80. I can access Reportserver, report manager and report bilder thru the Internet. I just can not connect to Report server from Management studio.

I will try connecting to RS is Management studo using http://localhost/reportserver.

Regards

Bobba

|||

Hi Brad Syputa,

Thank you for the suggestion. I worked. I was not able to try your suggestion immediatly as I was out of town.

Now I have this big question:

Why am I only able to connect to "report server" from "management studio" using

1. http://localhost/reportserver

and not using

2. servername

3. servername\instance.

Your help would save me a lot of time

Regards

Bobba(Bob)

|||

bobba wrote:

Hi Brad Syputa,
Thank you for the suggestion. I worked. I was not able to try your suggestion immediatly as I was out of town.
Now I have this big question:
Why am I only able to connect to "report server" from "management studio" using
1. http://localhost/reportserver
and not using
2. servername
3. servername\instance.
Your help would save me a lot of time
Regards
Bobba(Bob)

|||

Is this a bug that will be resolved?

thanks in advance,

Jason Wall

I have the same problem.

I can connect to the reporting service by using machine\instance in report server config tool.

I even tried to uninstall the report service, and reinstall it again. This problem still exists.

But the same thing does not happen on my colleague's machine.

I think it is better to look into this issue...

|||

I managed to solve this problem...

If you want to use machine\instance to connect Management studio.

You need to make sure in rsreportservice.config, element <UrlRoot>http://localhost/reportserver</UrlRoot> is correctly configured. (You can test this by visit this url)

I guess, the machine\instance will eventurally be translated to the <UrlRoot>. If the <UrlRoot> is not correct, then you will not be able to use machine\instance to connect report service.

The request failed with HTTP status 400: Bad Request. "

plz send me Slution|||hi all,
i have SQL 2205 with SP1 installed on my machine.
and i m not bale to connect to Report Server using SQL management studio as well as from web.

i have installed reporting server and database on same machine. i tried using

"http://localhost/reportserver"
"http://localhost/reports"
"http://localhost/reportmanager"

but i am not bale to connect i am getting "Service Unavailable" page.

and when i try to connect using SQL Management Studio with "servername/instance" as well as "http://localhost/reportserver" i am getting a error saying.

===================================
Cannot connect to http://localhost/reportserver.

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

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

but if i try and connect to other reporting server on other machine using web http://servername/reportserver i m able to connect it.
but dont know whats the problem on my machine.

do i need to start any services for this...

so anybody knows how to troubleshoot this issue.

Thanks in advance...

|||

Hi,

Any solution for the above mentioned problem?

have SQL 2005 without SP1 installed on my machine.
and i m not bale to connect to Report Server using SQL management studio as well as from web.

i have installed reporting server and database on same machine. i tried using

"http://localhost/reportserver"
"http://localhost/reports"
"http://localhost/reportmanager"

but i am not bale to connect i am getting "Service Unavailable" page.

and when i try to connect using SQL Management Studio with "servername/instance" it says, "No connection could not be made because the target machine actively refused it"

===================================
Cannot connect to http://localhost/reportserver.

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

Please post your suggestion, if you resolved it already.

Regards,

Bhuvana

|||i tried visiting this URL. it says 503, service un available error. Please give me the solution.|||

Something to try:

good luck

can not connect to Report server from SQL SERVER 2005 Management studio

Hi All,

I am even able to publish reports and all the

url://localhost/reportserver

url://localhost/reports

url://localhost/reportserver/reportbuilder/reportbuilder.application

all work fine on local machine and with in the network behind the fire wall.

But when I try to connect to report server using management studio on the local server or remote server, I get the following error.

TITLE: Microsoft SQL Server Management Studio

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.SqlServer.Management.UI.RSClient)

ADDITIONAL INFORMATION:

The request failed with HTTP status 404: Not Found. (Microsoft.SqlServer.Management.UI.RSClient)

More techinal details

"===================================

Cannot connect to xxxxxxxxxxxx.

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

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.SqlServer.Management.UI.RSClient)

Program Location:

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

The request failed with HTTP status 404: Not Found. (Microsoft.SqlServer.Management.UI.RSClient)

Program Location:

Any help would be greatly appreciated.

Bob

What are you passing in as the server name to Management Studio?

You can connect several ways

http://localhost/reportserver

servername

servername\instance

|||

I passed both the servername and the servername\instance to the management studio.

My IIS and uses port 80. I can access Reportserver, report manager and report bilder thru the Internet. I just can not connect to Report server from Management studio.

I will try connecting to RS is Management studo using http://localhost/reportserver.

Regards

Bobba

|||

Hi Brad Syputa,

Thank you for the suggestion. I worked. I was not able to try your suggestion immediatly as I was out of town.

Now I have this big question:

Why am I only able to connect to "report server" from "management studio" using

1. http://localhost/reportserver

and not using

2. servername

3. servername\instance.

Your help would save me a lot of time

Regards

Bobba(Bob)

|||

bobba wrote:

Hi Brad Syputa,

Thank you for the suggestion. I worked. I was not able to try your suggestion immediatly as I was out of town.

Now I have this big question:

Why am I only able to connect to "report server" from "management studio" using

1. http://localhost/reportserver

and not using

2. servername

3. servername\instance.

Your help would save me a lot of time

Regards

Bobba(Bob)

|||

Is this a bug that will be resolved?

thanks in advance,

Jason Wall

I have the same problem.

I can connect to the reporting service by using machine\instance in report server config tool.

I even tried to uninstall the report service, and reinstall it again. This problem still exists.

But the same thing does not happen on my colleague's machine.

I think it is better to look into this issue...

|||

I managed to solve this problem...

If you want to use machine\instance to connect Management studio.

You need to make sure in rsreportservice.config, element <UrlRoot>http://localhost/reportserver</UrlRoot> is correctly configured. (You can test this by visit this url)

I guess, the machine\instance will eventurally be translated to the <UrlRoot>. If the <UrlRoot> is not correct, then you will not be able to use machine\instance to connect report service.

The request failed with HTTP status 400: Bad Request. "

plz send me Slution|||hi all,
i have SQL 2205 with SP1 installed on my machine.
and i m not bale to connect to Report Server using SQL management studio as well as from web.

i have installed reporting server and database on same machine. i tried using

"http://localhost/reportserver"
"http://localhost/reports"
"http://localhost/reportmanager"

but i am not bale to connect i am getting "Service Unavailable" page.

and when i try to connect using SQL Management Studio with "servername/instance" as well as "http://localhost/reportserver" i am getting a error saying.

===================================
Cannot connect to http://localhost/reportserver.

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

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

but if i try and connect to other reporting server on other machine using web http://servername/reportserver i m able to connect it.
but dont know whats the problem on my machine.

do i need to start any services for this...

so anybody knows how to troubleshoot this issue.

Thanks in advance...

|||

Hi,

Any solution for the above mentioned problem?

have SQL 2005 without SP1 installed on my machine.
and i m not bale to connect to Report Server using SQL management studio as well as from web.

i have installed reporting server and database on same machine. i tried using

"http://localhost/reportserver"
"http://localhost/reports"
"http://localhost/reportmanager"

but i am not bale to connect i am getting "Service Unavailable" page.

and when i try to connect using SQL Management Studio with "servername/instance" it says, "No connection could not be made because the target machine actively refused it"

===================================
Cannot connect to http://localhost/reportserver.

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

Please post your suggestion, if you resolved it already.

Regards,

Bhuvana

|||i tried visiting this URL. it says 503, service un available error. Please give me the solution.|||

Something to try:

good luck

can not connect to Report server from SQL SERVER 2005 Management studio

Hi All,

I am even able to publish reports and all the

url://localhost/reportserver

url://localhost/reports

url://localhost/reportserver/reportbuilder/reportbuilder.application

all work fine on local machine and with in the network behind the fire wall.

But when I try to connect to report server using management studio on the local server or remote server, I get the following error.

TITLE: Microsoft SQL Server Management Studio

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.SqlServer.Management.UI.RSClient)

ADDITIONAL INFORMATION:

The request failed with HTTP status 404: Not Found. (Microsoft.SqlServer.Management.UI.RSClient)

More techinal details

"===================================

Cannot connect to xxxxxxxxxxxx.

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

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.SqlServer.Management.UI.RSClient)

Program Location:

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

The request failed with HTTP status 404: Not Found. (Microsoft.SqlServer.Management.UI.RSClient)

Program Location:

Any help would be greatly appreciated.

Bob

What are you passing in as the server name to Management Studio?

You can connect several ways

http://localhost/reportserver

servername

servername\instance

|||

I passed both the servername and the servername\instance to the management studio.

My IIS and uses port 80. I can access Reportserver, report manager and report bilder thru the Internet. I just can not connect to Report server from Management studio.

I will try connecting to RS is Management studo using http://localhost/reportserver.

Regards

Bobba

|||

Hi Brad Syputa,

Thank you for the suggestion. I worked. I was not able to try your suggestion immediatly as I was out of town.

Now I have this big question:

Why am I only able to connect to "report server" from "management studio" using

1. http://localhost/reportserver

and not using

2. servername

3. servername\instance.

Your help would save me a lot of time

Regards

Bobba(Bob)

|||

bobba wrote:

Hi Brad Syputa,

Thank you for the suggestion. I worked. I was not able to try your suggestion immediatly as I was out of town.

Now I have this big question:

Why am I only able to connect to "report server" from "management studio" using

1. http://localhost/reportserver

and not using

2. servername

3. servername\instance.

Your help would save me a lot of time

Regards

Bobba(Bob)

|||

Is this a bug that will be resolved?

thanks in advance,

Jason Wall

I have the same problem.

I can connect to the reporting service by using machine\instance in report server config tool.

I even tried to uninstall the report service, and reinstall it again. This problem still exists.

But the same thing does not happen on my colleague's machine.

I think it is better to look into this issue...

|||

I managed to solve this problem...

If you want to use machine\instance to connect Management studio.

You need to make sure in rsreportservice.config, element <UrlRoot>http://localhost/reportserver</UrlRoot> is correctly configured. (You can test this by visit this url)

I guess, the machine\instance will eventurally be translated to the <UrlRoot>. If the <UrlRoot> is not correct, then you will not be able to use machine\instance to connect report service.

The request failed with HTTP status 400: Bad Request. "

plz send me Slution|||hi all,
i have SQL 2205 with SP1 installed on my machine.
and i m not bale to connect to Report Server using SQL management studio as well as from web.

i have installed reporting server and database on same machine. i tried using

"http://localhost/reportserver"
"http://localhost/reports"
"http://localhost/reportmanager"

but i am not bale to connect i am getting "Service Unavailable" page.

and when i try to connect using SQL Management Studio with "servername/instance" as well as "http://localhost/reportserver" i am getting a error saying.

===================================
Cannot connect to http://localhost/reportserver.

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

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

but if i try and connect to other reporting server on other machine using web http://servername/reportserver i m able to connect it.
but dont know whats the problem on my machine.

do i need to start any services for this...

so anybody knows how to troubleshoot this issue.

Thanks in advance...

|||

Hi,

Any solution for the above mentioned problem?

have SQL 2005 without SP1 installed on my machine.
and i m not bale to connect to Report Server using SQL management studio as well as from web.

i have installed reporting server and database on same machine. i tried using

"http://localhost/reportserver"
"http://localhost/reports"
"http://localhost/reportmanager"

but i am not bale to connect i am getting "Service Unavailable" page.

and when i try to connect using SQL Management Studio with "servername/instance" it says, "No connection could not be made because the target machine actively refused it"

===================================
Cannot connect to http://localhost/reportserver.

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

Please post your suggestion, if you resolved it already.

Regards,

Bhuvana

|||i tried visiting this URL. it says 503, service un available error. Please give me the solution.|||

Something to try:

good luck

sql

Can not connect to MS SQL server 2000 with Windows XP

First is can I use Windows XP with the client tools (Enterprise Manager) to
connect to MS SQL Server 2000? If so, can someone explaine? I have tried
using SQL Server Authentication but I get an error saying server does not
exit or access denied. I tried using the SA account and that does not work
either.
Thanks,Yes you should be able to . One gotcha is that XP Home always
authenticates as Guest.
Create a Test ODBC DSN to get a better error message if you can't connect.
Check the OS error number.
Example:
OS Error 10061 = Connection Refused. Server is not listening on the socket.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Can not connect to MS SQL server 2000 with Windows XP

First is can I use Windows XP with the client tools (Enterprise Manager) to
connect to MS SQL Server 2000? If so, can someone explaine? I have tried
using SQL Server Authentication but I get an error saying server does not
exit or access denied. I tried using the SA account and that does not work
either.
Thanks,
Yes you should be able to . One gotcha is that XP Home always
authenticates as Guest.
Create a Test ODBC DSN to get a better error message if you can't connect.
Check the OS error number.
Example:
OS Error 10061 = Connection Refused. Server is not listening on the socket.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Can not connect to MS SQL server

Hi I have problems with connecting to MS SQL server.

SQL server is configured to log in with Windows Authentication mode.

The only thing I need is to configure the web.config.

My configuration in web.config-file is as follow:

<appSettings>

<addkey="forumDSN"value="server=localhost;uid=;pwd=;database=forum"/>

</appSettings>

I get the following message afte running my ASP page:

Exception Details:System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.

HELP please.

Is the SQL Server on the same machine as the Web server? In the real Web.Config, to you provide an actual uid and password?|||

Hey hi,

1st u check out wheter the sql server whichs running has got any name...coz, some times the local host is not taken as the default instead, its named with some name.

to check that, just open the sql server service manager, there u can C Server :"........"

that name should be used.

also for further details go through the following link

http://www.functionx.com/sqlserver/Lesson01.htm

also the this one for the security issues

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

hope this helps

all the best

|||

yes, It is in the same machine running WindowsXP

thanks

sql

Can not connect to database

I am new to windows apps in .net 2.0. I am trying to create a windows service that will connect to a database and email info out to people that have had status changes.

Right now, I can not connect to the database. Here is the connection string:

Private cnnAsNew SqlClient.SqlConnection("Data Source=IPAddress;Initial Catalog=TheServer;Persist Security Info=True;User ID=userid;Password=password provider=SQLOLEDB.1;connect timeout=3600")

This is how I am trying to connect:

cnn.Open()

myCMD.CommandTimeout = 0

dr = myCMD.ExecuteReader

I keep getting an error message that I can not be logged on. I know that the credentials are correct because I use them for the web app. Something has to be wrong with my connection string, but what?

Thanks,

enak

Seehttp://www.connectionstrings.com for examples of properly formatted connection strings. You do not need the "provider" parameter, and if you did it should be separated from the other parameters by a semicolon (not a space).

If you are still having trouble you should post the exact error message (or better yet, first search the forums or Google for that error message).|||Took out the provider and it worked. Thanks.sql

Can not connect to AS 2005 from Excel

I'm having issues connecting to AS 2005 sp1 from Excel 2003. I have tried
two configurations as follows:

Secario 1
Installed on a Windows Server 2003 is AS 2005 sp1.
Installed on a workstation with XP sp2 is Office 2003, msxml parser 6.0, SQL
Server AS ADOMD, Excel Add-in for SQL Server Analysis Services sp1.

Secario 2
Installed all on workstation with XP sp2: Full install of SQL Server 2005
Dev Edition, Office 2003, msxml parser 6.0, SQL Server AS ADOMD, Excel
Add-in for SQL Server Analysis Services sp1.

In both cases the error returned is server does not exist or is too busy.

The cube is created and can be browsed from BI Studio.
The LAN id has been added to the AS 2005 security.
All SQL Services are started including Browser and AS.
Firewalls are not enabled.
Local and remote clients are allowed to connect to AS.
I can open TCP port 2383 with telnet on the AS server from the workstation.

Any one see anything I've missed or can shed some light on why the server is
not allowing connections?

Thanks,
Danny

Make sure you install "Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider " on you client machine

You can get it from http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||I think this gets installed with SQL 2005 locally but I reinstalled it. Unfortunately this had no impact and the error message is the same.|||

Take a look at this post: http://www.sqljunkies.com/WebLog/edwardm/archive/2006/05/26/21447.aspx

In addition: Another way to test connectivity:

1. Create new empty text file.
2. Change it's extension to .udl
3. Double click on the file, and in the "Data Link Properties" dialog go to the "Provider" tab. Select there "Microsoft OLE DB Provider for Analysis Services 9.0" then "Next".
4 On the connection page type name of your server and select "Use Windows NT integrated security"

At this point you should be able to list of databases on Analysis Server.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||Thanks Edward. It succeeded on the Test connection and the initial catalog select list populated with the SSAS database names. Looks like the server is responding and the OLE DB driver for AS 9.0 is working. That narrows the issue down to MSExcel 2003 and/or the Addin.|||Issue somehow resolved itself after perfroming a repair on Excel following by reregistering the OLEDB 9.0 dll.

Can not connect to AS 2005 from Excel

I'm having issues connecting to AS 2005 sp1 from Excel 2003. I have tried
two configurations as follows:

Secario 2
Installed all on workstation with XP sp2: Full install of SQL Server 2005
Dev Edition, Office 2003, msxml parser 6.0, SQL Server AS ADOMD, Excel
Add-in for SQL Server Analysis Services sp1.

In both cases the error returned is server does not exist or is too busy.

Any one see anything I've missed or can shed some light on why the server is
not allowing connections?

Thanks,
Danny

Make sure you install "Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider " on you client machine

You can get it from http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||I think this gets installed with SQL 2005 locally but I reinstalled it. Unfortunately this had no impact and the error message is the same.|||

Take a look at this post: http://www.sqljunkies.com/WebLog/edwardm/archive/2006/05/26/21447.aspx

In addition: Another way to test connectivity:

At this point you should be able to list of databases on Analysis Server.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Tuesday, March 20, 2012

Can not conenct to MSDE with VB.NET 2003

Hellow
First i appoligize for my english but I'm from Belgium
Second, this is my problem:
I installed a Server on my Server PC (Windows XP Professional)
setup SAPWD="mypwd" INSTANCENAME="MSDESERVER" DISABLENETWORKPROTOCOLS=0
SECURITYMODE="SQL" TARGETDIR="C:\MSDEINSTALL" /L*v C:\MSDELOG.TXT +
Enter
Works perfect, then I attached a database to it
osql -E -S peter-developer\VA3+ ENTER
EXEC sp_attach_db @.dbname='VA2005',@.filename1='C:\test\VA2005.mdf',
@.filename2='C:\test\VA2005_LOG.ldf' + ENTER
This works, and in vb.net i can connect to it with
"Data Source=PETER-DEVELOPER\va3;Initial Catalog=VA2005;Integrated
Security=SSPI;"
But when i try this from i remote PC (Windows XP) I get an error that
says: SQL server does not exist or access is denied
I searched almost everywhere and i can't find the answer.
EXTRA information
With svrnetcn.exe a set Named pipes, TCP/IP and NWLINK IPX/SPX to
enabled
I put the firewall of, and the firewal of the router is off
Please help me
How do you connect the MSDE from the remote computer? Via an application
with the same ConnectionString as you showed? If yes, that means you are
using Windows security to connect to the MSDE. Is the remote computer on the
same domain network or peer-to-peer network? If it is domain network, you
need to have a SQL Server login created in MSDE that maps to the domain user
account used on that remote computer, or the user logged on to that remote
computer is a domain admin.
Since your MSDE's SQL Server security is enabled, you could specify user
name and password in the ConnectionString (i.e. using SQL Server security,
instead of Windows security). More important thing is to do a bit more study
on SQL Server/MSDE security.
"Thorgal" <declerck_peter@.yahoo.com> wrote in message
news:1164211363.096453.64060@.e3g2000cwe.googlegrou ps.com...
> Hellow
> First i appoligize for my english but I'm from Belgium
> Second, this is my problem:
> I installed a Server on my Server PC (Windows XP Professional)
> setup SAPWD="mypwd" INSTANCENAME="MSDESERVER" DISABLENETWORKPROTOCOLS=0
> SECURITYMODE="SQL" TARGETDIR="C:\MSDEINSTALL" /L*v C:\MSDELOG.TXT +
> Enter
> Works perfect, then I attached a database to it
> osql -E -S peter-developer\VA3+ ENTER
> EXEC sp_attach_db @.dbname='VA2005',@.filename1='C:\test\VA2005.mdf',
> @.filename2='C:\test\VA2005_LOG.ldf' + ENTER
> This works, and in vb.net i can connect to it with
> "Data Source=PETER-DEVELOPER\va3;Initial Catalog=VA2005;Integrated
> Security=SSPI;"
> But when i try this from i remote PC (Windows XP) I get an error that
> says: SQL server does not exist or access is denied
> I searched almost everywhere and i can't find the answer.
> EXTRA information
> With svrnetcn.exe a set Named pipes, TCP/IP and NWLINK IPX/SPX to
> enabled
> I put the firewall of, and the firewal of the router is off
> Please help me
>
|||I'm confused.
In the setup, you indicate that the instance name is: "MSDESERVER", yet in
the connection string you are connecting to: "PETER-DEVELOPER\va3".
Do you have a second instance named [va3]?
Shouldn't you use the instancename [MSDESERVER] in the connection string if
you want to connect to that instance?
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Thorgal" <declerck_peter@.yahoo.com> wrote in message
news:1164211363.096453.64060@.e3g2000cwe.googlegrou ps.com...
> Hellow
> First i appoligize for my english but I'm from Belgium
> Second, this is my problem:
> I installed a Server on my Server PC (Windows XP Professional)
> setup SAPWD="mypwd" INSTANCENAME="MSDESERVER" DISABLENETWORKPROTOCOLS=0
> SECURITYMODE="SQL" TARGETDIR="C:\MSDEINSTALL" /L*v C:\MSDELOG.TXT +
> Enter
> Works perfect, then I attached a database to it
> osql -E -S peter-developer\VA3+ ENTER
> EXEC sp_attach_db @.dbname='VA2005',@.filename1='C:\test\VA2005.mdf',
> @.filename2='C:\test\VA2005_LOG.ldf' + ENTER
> This works, and in vb.net i can connect to it with
> "Data Source=PETER-DEVELOPER\va3;Initial Catalog=VA2005;Integrated
> Security=SSPI;"
> But when i try this from i remote PC (Windows XP) I get an error that
> says: SQL server does not exist or access is denied
> I searched almost everywhere and i can't find the answer.
> EXTRA information
> With svrnetcn.exe a set Named pipes, TCP/IP and NWLINK IPX/SPX to
> enabled
> I put the firewall of, and the firewal of the router is off
> Please help me
>
|||Arnie Rowland schreef:

> I'm confused.
> In the setup, you indicate that the instance name is: "MSDESERVER", yet in
> the connection string you are connecting to: "PETER-DEVELOPER\va3".
> Do you have a second instance named [va3]?
> Shouldn't you use the instancename [MSDESERVER] in the connection string if
> you want to connect to that instance?
> --
Sorry i copy pasted somethings from the installation board but this is
how it is
setup SAPWD="mypwd" INSTANCENAME="VA3" DISABLENETWORKPROTOCOLS=0
SECURITYMODE="SQL" TARGETDIR="C:\VA3" /L*v C:\MSDELOG.TXT +
Enter
Then attaching the database:
osql -E -S peter-developer\VA3+ ENTER
EXEC sp_attach_db @.dbname='VA2005',@.filename1='C:\test\VA2005.mdf',
@.filename2='C:\test\VA2005_LOG.ldf' + ENTER
Sorry for that mistake.
The 2 computers are in the same worgroup, and when i typ
\\peter-developer I see the server PC and I can get files from it or
drop files on the PC.
I want to connect to the VA3 server with a VB.NET 2003 application and
i do it with following connection string
"Data Source=PETER-DEVELOPER\va3;Initial Catalog=VA2005;Integrated
Security=SSPI;"
Doesn't work
"Data Source=PETER-DEVELOPER\va3;Initial Catalog=VA2005;Integrated
Security=SSPI;User ID=sa; Password=pass"
Doesn't work
"Data Source=PETER-DEVELOPER\va3,1433;Initial Catalog=VA2005;Integrated
Security=SSPI;User ID=sa; Password=pass"
Doesn't work
"Data Source=Peter-developer\VA3,1433;Network
Library=DBMSSOCN;Integrated Security=SSPI;Initial Catalog=VA2005;User
ID=peter;Password=peter"
Doesn't work ether
You say something about making a new user, I don't understand that,
could you explain it again please
|||You do not need to combine both "Integrated Security=SSPI" AND "User ID=sa;
Password=pass".
It is EITHER "Integrated Security=SSPI" OR "User ID=sa; Password=pass".
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Thorgal" <declerck_peter@.yahoo.com> wrote in message
news:1164269346.083379.243730@.l12g2000cwl.googlegr oups.com...
> Arnie Rowland schreef:
>
> Sorry i copy pasted somethings from the installation board but this is
> how it is
> setup SAPWD="mypwd" INSTANCENAME="VA3" DISABLENETWORKPROTOCOLS=0
>
> SECURITYMODE="SQL" TARGETDIR="C:\VA3" /L*v C:\MSDELOG.TXT +
> Enter
> Then attaching the database:
> osql -E -S peter-developer\VA3+ ENTER
> EXEC sp_attach_db @.dbname='VA2005',@.filename1='C:\test\VA2005.mdf',
> @.filename2='C:\test\VA2005_LOG.ldf' + ENTER
>
> Sorry for that mistake.
> The 2 computers are in the same worgroup, and when i typ
> \\peter-developer I see the server PC and I can get files from it or
> drop files on the PC.
> I want to connect to the VA3 server with a VB.NET 2003 application and
> i do it with following connection string
> "Data Source=PETER-DEVELOPER\va3;Initial Catalog=VA2005;Integrated
> Security=SSPI;"
>
> Doesn't work
> "Data Source=PETER-DEVELOPER\va3;Initial Catalog=VA2005;Integrated
> Security=SSPI;User ID=sa; Password=pass"
> Doesn't work
> "Data Source=PETER-DEVELOPER\va3,1433;Initial Catalog=VA2005;Integrated
> Security=SSPI;User ID=sa; Password=pass"
> Doesn't work
> "Data Source=Peter-developer\VA3,1433;Network
> Library=DBMSSOCN;Integrated Security=SSPI;Initial Catalog=VA2005;User
> ID=peter;Password=peter"
> Doesn't work ether
> You say something about making a new user, I don't understand that,
> could you explain it again please
>
sql

Thursday, March 29, 2012

Can not install Reporting Services, Help!

Can not install Reporting Services, Help!

Can not install Reporting Services, Help!

Can not install Reporting Services, Help!

Sunday, March 25, 2012

Can not delete database. Gives Error 21776. Suggestions please?

Thursday, March 22, 2012

Can not connect to SQL server 2000 on windows authentication mode

Can not connect to SQL Server

can not connect to Report server from SQL SERVER 2005 Management studio

can not connect to Report server from SQL SERVER 2005 Management studio

can not connect to Report server from SQL SERVER 2005 Management studio

can not connect to Report server from SQL SERVER 2005 Management studio

can not connect to Report server from SQL SERVER 2005 Management studio

can not connect to Report server from SQL SERVER 2005 Management studio

Can not connect to MS SQL server 2000 with Windows XP

Can not connect to MS SQL server 2000 with Windows XP

Can not connect to MS SQL server

Can not connect to database

Can not connect to AS 2005 from Excel

Can not connect to AS 2005 from Excel

Tuesday, March 20, 2012

Can not conenct to MSDE with VB.NET 2003

install SQL on WinXP

Blog Archive

About Me