install SQL on WinXP: studio

Showing posts with label studio. Show all posts

Tuesday, March 27, 2012

can not expand table group in internet explorer

Hey all
I hope one of you encountered this problem..
I have grouped fields on one table object in some report.
In visual studio all is well i can expand the grouping fields to see thier
children and thier data.
The problem appears in internet explorer - under no sircumstances will this
group expand there!
I am left with the upper most grouping field and can not drill down to its
members!
I have tried both to define these aggregating fields by my self
and by the vs wizard . Also i tried the matrix component instead of the
table one.
One interesting fact is that once exported to excell, things return to
normal again..
I can expand groups and drill down correctly.
I have installed sp1 for reporting services and use ie6 on winxp
professional (both client and server).
If you did not encounter this before where will you start looking'
Thanks for your attention
ReaThe driil down capability requires Session cookies be enabled. Change the
Internet Explorer setting to "Allow Session Cookies" and it should work
"Rea Peleg" <rea_p@.afek.co.il> wrote in message
news:uQfy2B8bEHA.1764@.TK2MSFTNGP10.phx.gbl...
> Hey all
> I hope one of you encountered this problem..
> I have grouped fields on one table object in some report.
> In visual studio all is well i can expand the grouping fields to see thier
> children and thier data.
> The problem appears in internet explorer - under no sircumstances will
this
> group expand there!
> I am left with the upper most grouping field and can not drill down to its
> members!
> I have tried both to define these aggregating fields by my self
> and by the vs wizard . Also i tried the matrix component instead of the
> table one.
> One interesting fact is that once exported to excell, things return to
> normal again..
> I can expand groups and drill down correctly.
> I have installed sp1 for reporting services and use ie6 on winxp
> professional (both client and server).
> If you did not encounter this before where will you start looking'
> Thanks for your attention
> Rea
>
>

Can not drop a member from a role

I've just changed server from SQL2000 to SQL2005 (by backup/restore).
But I can not drop a user from a role. I did it from Management Studio.
It didn't give any error message but even I refresh the db, I can still
see same user in the role.
Then I've tried sp_droprolemember 'X','Y' but same result. Does not
give any error message, looks like it did it. But user is still in the
role.
Even I'm server admin, I can not do it. I'll be happy if someone can
help me to solve the issue.
Thx
AvniCheck out sp_change_users_login. Run it to find the mismatched users, as
well as to correct the problem. Then, drop the role member.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
<avni.cengel@.gmail.com> wrote in message
news:1141984205.157637.62570@.u72g2000cwu.googlegroups.com...
I've just changed server from SQL2000 to SQL2005 (by backup/restore).
But I can not drop a user from a role. I did it from Management Studio.
It didn't give any error message but even I refresh the db, I can still
see same user in the role.
Then I've tried sp_droprolemember 'X','Y' but same result. Does not
give any error message, looks like it did it. But user is still in the
role.
Even I'm server admin, I can not do it. I'll be happy if someone can
help me to solve the issue.
Thx
Avni

Can not drop a member from a role

I've just changed server from SQL2000 to SQL2005 (by backup/restore).
But I can not drop a user from a role. I did it from Management Studio.
It didn't give any error message but even I refresh the db, I can still
see same user in the role.
Then I've tried sp_droprolemember 'X','Y' but same result. Does not
give any error message, looks like it did it. But user is still in the
role.
Even I'm server admin, I can not do it. I'll be happy if someone can
help me to solve the issue.
Thx
AvniCheck out sp_change_users_login. Run it to find the mismatched users, as
well as to correct the problem. Then, drop the role member.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
<avni.cengel@.gmail.com> wrote in message
news:1141984205.157637.62570@.u72g2000cwu.googlegroups.com...
I've just changed server from SQL2000 to SQL2005 (by backup/restore).
But I can not drop a user from a role. I did it from Management Studio.
It didn't give any error message but even I refresh the db, I can still
see same user in the role.
Then I've tried sp_droprolemember 'X','Y' but same result. Does not
give any error message, looks like it did it. But user is still in the
role.
Even I'm server admin, I can not do it. I'll be happy if someone can
help me to solve the issue.
Thx
Avni

Can not drop a member from a role

I've just changed server from SQL2000 to SQL2005 (by backup/restore).
But I can not drop a user from a role. I did it from Management Studio.
It didn't give any error message but even I refresh the db, I can still
see same user in the role.
Then I've tried sp_droprolemember 'X','Y' but same result. Does not
give any error message, looks like it did it. But user is still in the
role.
Even I'm server admin, I can not do it. I'll be happy if someone can
help me to solve the issue.
Thx
Avni
Check out sp_change_users_login. Run it to find the mismatched users, as
well as to correct the problem. Then, drop the role member.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
<avni.cengel@.gmail.com> wrote in message
news:1141984205.157637.62570@.u72g2000cwu.googlegro ups.com...
I've just changed server from SQL2000 to SQL2005 (by backup/restore).
But I can not drop a user from a role. I did it from Management Studio.
It didn't give any error message but even I refresh the db, I can still
see same user in the role.
Then I've tried sp_droprolemember 'X','Y' but same result. Does not
give any error message, looks like it did it. But user is still in the
role.
Even I'm server admin, I can not do it. I'll be happy if someone can
help me to solve the issue.
Thx
Avni
sql

Sunday, March 25, 2012

Can not connect to SQL Server 2005 Developer edition remotely

I setup a SQL Server 2005 Developer edition, which is bundled with Visual Studio .NET 2005 Professional edition. The SQL Server authentication mode is enabled in this database server. But when I try to connect it from another PC using SQL Server authentication, it failed. Is it a limitation on the developer edition?

Hi,

although you didn′t post the erro rmessage, I assume that remote connectivity is not enabled, change the remote flag which can be see in this screen:

http://www.sqlserver2005.de/SharedFiles/Remoteconnection.jpg

HTH, jens suessmeyer.

http://www.sqlserver2005.de

|||

Hi,

I still can't login remotely to the server, the error message is:

Cannot connect to 137.xxx.xx.xx\STD2005
error: 26 - Error Locating Sever/Instance Specified

I setup a MSSQL Server 2005 Standard edition on a remote computer 137.xxx.xx.xx (I'm sure the network has no any problem, since this remote computer has a SQL2000 server that I can use the Enterprise Manager in my PC to connect to it), and the named instance called STD2005. I try to connect to it through the Management Studio in my PC, using the sa account and one acccount that I created before, both not work. Any idea?

|||Hi,

so you are usinga named instance. I assume you didn′t put the named instance on the defaulport, which is as a default used to connect to a sql server instance. If the named instances has another port you have to specify it with the syntax:

Servername\InstanceName,Portnumber

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||Also: Can we rule out a firewall problem? Is the SQL Browser service running on the server machine?

Best,
Nils Loeber
|||

In SQL 2005 Developer Edition TCP\IP is disabled by default. You can go to Server Configuration and enable it. I hope that helps.

Thursday, March 22, 2012

Can not connect to SQL server

I am using SQL server 2005 express edition. I have instaled the managment studio, so I can create the databases and login. Than after it I have changed from Windows authentication to SQL server authentication. So I opened the VWD on another client pc and I tried to connect to specified database, but I get the error COULD NOT CONNECT TO SQL SERVER, check if the server allow the remote connections.

I have chenked it and it is configured to allow remote connections. Why this happens ?? I had never these problems when I used the sql server 2005 beta version. The client pc and this sql server have connections so there is no problem with network connection at all.

Any suggestions ??

PS: I also tried using syntax:

Server name: myserver\SQLEXPRESS (instance)

Best regards

This might occur also if you didnt specify the correct username/password for the SQL authentication method.

Make sure that the database contain that user and is already mapped to the db.

Regards

|||

Hello !! Thank You for answering !!

Actually I found that problem was DISABLED TCP / IP on the SQL server. I have enabled it and now it work fine. When installing the SQL server express the tcp/ip is disabled so it will not respond on the request for other pc`s.

Best regards

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 remote SQL Express 2005

Hi,
I am having problems with my Visual Studio 2005 VB.net win app connecting
to SQL Express. I have configured my SQL Express to enable remote
connections, I believe it is correct, since others in the office can connect
to it using MS SQL Server Management Studio, and I can make a successful test
ODBC connection from the client computer, using both named pipes and tcpip.
But my VB.net app can not connect on the client computer, I get error -
System.Data.SqlClient.SqlException: An error has occurred while establishing
a connection to the 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 - Could
not open a connection to SQL Server).
This app runs fine on the machine the SQL Express is running on (Windows
2000). My connection code is: Data Source=xxx\sqlexpress;Initial
Catalog=xxx;User ID=xxx;Password=xxx. I have tried putting np: and tcp: with
the port on the data source, but then the code doesn't run on the app on the
server...
Anybody know what I am doing wrong?
Thank you for any help.
Sandy
Hi,
any blocking firewall in the machine ? See if you can open up a
connction using the SQLCMD application from the command prompt.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
|||Hi, Yes I can open a connection using SQLCMD, specifying both tcp with port,
and specifying np. The client machine doesn't have SQL installed, but the
odbc connections worked.
Sandy
"Jens" wrote:

> Hi,
> any blocking firewall in the machine ? See if you can open up a
> connction using the SQLCMD application from the command prompt.
> HTH, Jens K. Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>

can not connect to remote SQL Express 2005

Hi,
I am having problems with my Visual Studio 2005 VB.net win app connecting
to SQL Express. I have configured my SQL Express to enable remote
connections, I believe it is correct, since others in the office can connec
t
to it using MS SQL Server Management Studio, and I can make a successful tes
t
ODBC connection from the client computer, using both named pipes and tcpip.
But my VB.net app can not connect on the client computer, I get error -
System.Data.SqlClient.SqlException: An error has occurred while establishing
a connection to the server. When connecting to SQL Server 2005, this failur
e
may be caused by the fact that under the default settings SQL Server does no
t
allow remote connections. (provider: Named Pipes Provider, error: 40 - Could
not open a connection to SQL Server).
This app runs fine on the machine the SQL Express is running on (Windows
2000). My connection code is: Data Source=xxx\sqlexpress;Initial
Catalog=xxx;User ID=xxx;Password=xxx. I have tried putting np: and tcp: wit
h
the port on the data source, but then the code doesn't run on the app on the
server...
Anybody know what I am doing wrong?
Thank you for any help.
SandyHi,
any blocking firewall in the machine ? See if you can open up a
connction using the SQLCMD application from the command prompt.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
--|||Hi, Yes I can open a connection using SQLCMD, specifying both tcp with port
,
and specifying np. The client machine doesn't have SQL installed, but the
odbc connections worked.
Sandy
"Jens" wrote:

> Hi,
> any blocking firewall in the machine ? See if you can open up a
> connction using the SQLCMD application from the command prompt.
> HTH, Jens K. Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>

Can not connect to desktop sql database from mobile device (Pocket PC)

Hi,

I am developing an application for a Pocket PC (PPC). I am using Visual studio 2005, and the Operating system on this PPC is Window Mobile 2003 SE. The followings are my codes to connect PPC with the database on my PC with sql server 2005. But when I cick the button1, the error with "SQL Server does not exist or access denied." Any ideas? Thanks a lot.

Imports System.IO

Imports System.Data

Imports System.Data.SqlClient

Imports System.Math

Imports System.Drawing

Imports System

Public Class Form1

Dim strConnection As String = "Server=localhost;Integrated Security=SSPI;database=AdventureWorks"

Dim strQuery As String

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

Label1.Text = "Hello, Clicking after."

ReadOrderData()

End Sub

Private Sub ReadOrderData()

Dim queryString As String = "select * from Person.Address where AddressID < '10'"

Using connection As New SqlConnection(strConnection)

Dim command As New SqlCommand(queryString, connection)

connection.Open()

Dim reader As SqlDataReader = command.ExecuteReader()

While reader.Read()

MsgBox(String.Format("{0}, {1}", _

reader(0), reader(1)))

End While

reader.Close()

End Using

End Sub

End Class

Please see this:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=184007&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=235638&SiteID=1

If it still does not work after you fixed your 'localhost' issue:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=270532&SiteID=1

Also, we have forum dedicated to SQL Mobile. Please post to it should you have any SQL or SQL Mobile related questions:

http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=152&SiteID=1

|||

Thanks for your reply.

I would like to install vxUtil, and I have already read the readme.txt file. But I still have some questions about that. Should vxUtil be installed on my personal PC or the Pocket PC(PPC)? If it should be installed in the PPC, how can I install? In the readme.txt, I get the following information:

Open the appropriate folder on the hard drive then double-click
on the InstallCE icon to start the install process for the correct device.

From this information, I feel that vxUtil should be installed in my personal PC. Is it correct?

Could you please answer me about that?

Thanks a lot.

|||

vxUtil should be ultimately installed on device. However, like pretty much all Pocket PC products, it goes through desktop and Active Sync. You install/unzip application on to desktop, then you (or desktop installer) execute something which would push it to device via AS. As a developer you would have to do the same for your application eventually. In some cases there's no desktop installer, just a device CAB file. In that case simply copy CAB to device and click on it from device's file explorer.

|||

Dear Ilya Tumanov,

Your answer is so great. I have already installed it into the PPC, and it scanned the ports in my desktop PC. From the result, the ports 25, 80, 135, 139, 443, 445, 990 and1025 are all open. But the program that I posted yesterday and listed above can not still work. What do I need in the next step?

Moreover, I have changed the connection string to

Dim strConnection As String = "Server=Server1;Integrated Security=SSPI;database=AdventureWorks"

Thanks a lot.

|||

Hi,

I have already installed vxUtil into the PPC, and Ping is OK. I use it to scan the ports in my desktop PC. From the result, the ports 25, 80, 135, 139, 443, 445, 990 and1025 are all open. But the program can not still work.

Any ideas? Thanks a lot.

Imports System.IO

Imports System.Data

Imports System.Data.SqlClient

Imports System.Math

Imports System.Drawing

Imports System

Public Class Form1

Dim strConnection As String = "Server=server1;Integrated Security=SSPI;database=AdventureWorks"

Dim strQuery As String

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

Label1.Text = "Hello, Clicking after."

ReadOrderData()

End Sub

Private Sub ReadOrderData()

Dim queryString As String = "select * from Person.Address where AddressID < '10'"

Using connection As New SqlConnection(strConnection)

Dim command As New SqlCommand(queryString, connection)

connection.Open()

Dim reader As SqlDataReader = command.ExecuteReader()

While reader.Read()

MsgBox(String.Format("{0}, {1}", _

reader(0), reader(1)))

End While

reader.Close()

End Using

End Sub

End Class

|||

Default SQL Server port is 1433 which is not opened so it's not going to work until your SQL Server is properly configured. Also you have to provide credential in connection string, this string is not going to work.

I'm moving this thread to appropriate forum.

|||

Hi,

Thanks for your answer, and right now 1433 port is open. I would like to use windows authentication protocol. Could you please provide a sample for the connection string? Thanks a lot.

|||

Hi,

Thanks for your answer, and right now 1433 port is open. I would like to use windows authentication protocol. Could you please provide a sample for the connection string? Thanks a lot.

|||

This should work:

"Server=YourServerHere,1433;Initial Catalog=YourDataBaseHere;User ID=YourLoginHere;Password=YourPasswordHere;Integrated Security=SSPI;"

Note you have to provide login and password even though windows authentication will be used. That's because there's no login procedure on devices.

|||

Dear Ilya Tumanov,

Thanks a lot for your so many helps, and it works.

|||

so..It must have a password?is it same with windows user's password?what if blank?

if I'm not wrong, if we set the windows password, we should change the SQL password too right?

|||

you should check this link http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=709129&SiteID=1&mode=1

It works for me after a loooooonggg time testing

Can not connect to a flat file

Hi all....

With Visual Studio, I have created a new "Integration Services Project".

As per the tutorial instructions, I right-click in the "Connection Managers" box, and I select "New Flat File Connection"

When I do so, I get this error:

The new connection manager could not be created.
Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)

Any suggestions? (BTW, I'm using 64-Bit Enterprise edition for x64)

Thanks!

Forch

at Microsoft.SqlServer.Dts.Runtime.ConnectionManager.get_Properties()
at Microsoft.DataTransformationServices.Controls.FlatFileConnectionManagerUtils.GetLocaleID(ConnectionManager connectionManager)
at Microsoft.DataTransformationServices.Controls.FlatFileManagerGeneralPage.LoadState(ConnectionManager connManager)
at Microsoft.DataTransformationServices.Controls.FlatFileManagerGeneralPage.set_ConnectionManager(ConnectionManager value)
at Microsoft.DataTransformationServices.Controls.FlatFileConnectionManagerControl.set_ConnectionManager(ConnectionManager value)
at Microsoft.DataTransformationServices.Design.FlatFileConnectionManagerForm.set_ConnectionManager(ConnectionManager value)
at Microsoft.DataTransformationServices.Design.FlatFileConnectionManagerUI.New(IWin32Window parentWindow, Connections connections, ConnectionManagerUIArgs connectionUIArg)
at Microsoft.DataTransformationServices.Design.ConnectionManagerDesigner.OnNewConnectionAdded(ConnectionManagerUIArgs connectionUIArg)
at Microsoft.DataTransformationServices.Design.DtsConnectionService.CreateConnection(String connectionType, ConnectionManagerUIArgs connectionUIArg)

.... To continue, I am not able to make ANY data connections at all.... SQL Server, Oracle, FTP, Text file, nothing.

I have tried to remove and re-install Integrated services, but I have had no luck.

Sad

Forch|||I have this exact same problem and can't seem to be able to find any information about it. I too have uninstalled and reinstalled everything with no success. Any help greatly appreciated.|||

Hi Scott,

Its too late to ask this question. Can you remember what makes this problem fixed? We too have exact problem and unable to get any help

Any refernce would be helpful.

Thanks in Advance

Phani Kiran K

|||

Hi Forch,

I too have exact problem. Can you remember the solution you had for this problem?

Any reference would be helpful.

Thanks in Advance,

Phani Kiran K.

|||

Sorry.... I have not visited this in a while. I just changed everything I need to do to script.

Cheers,

Forch

|||

This issues is realted to 64 bit environment. Once we register the necessary dlls in the 64 bit environmen, everything is working fine

Regards,

Phani.

Can not connect to a flat file

Hi all....

With Visual Studio, I have created a new "Integration Services Project".

As per the tutorial instructions, I right-click in the "Connection Managers" box, and I select "New Flat File Connection"

When I do so, I get this error:

The new connection manager could not be created.
Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)

Any suggestions? (BTW, I'm using 64-Bit Enterprise edition for x64)

Thanks!

Forch

.... To continue, I am not able to make ANY data connections at all.... SQL Server, Oracle, FTP, Text file, nothing.

I have tried to remove and re-install Integrated services, but I have had no luck.

Sad

Forch|||I have this exact same problem and can't seem to be able to find any information about it. I too have uninstalled and reinstalled everything with no success. Any help greatly appreciated.|||

Hi Scott,

Its too late to ask this question. Can you remember what makes this problem fixed? We too have exact problem and unable to get any help

Any refernce would be helpful.

Thanks in Advance

Phani Kiran K

|||

Hi Forch,

I too have exact problem. Can you remember the solution you had for this problem?

Any reference would be helpful.

Thanks in Advance,

Phani Kiran K.

|||

Sorry.... I have not visited this in a while. I just changed everything I need to do to script.

Cheers,

Forch

|||

This issues is realted to 64 bit environment. Once we register the necessary dlls in the 64 bit environmen, everything is working fine

Regards,

Phani.

Can not connect to a flat file

Hi all....

With Visual Studio, I have created a new "Integration Services Project".

As per the tutorial instructions, I right-click in the "Connection Managers" box, and I select "New Flat File Connection"

When I do so, I get this error:

The new connection manager could not be created.
Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)

Any suggestions? (BTW, I'm using 64-Bit Enterprise edition for x64)

Thanks!

Forch

.... To continue, I am not able to make ANY data connections at all.... SQL Server, Oracle, FTP, Text file, nothing.

I have tried to remove and re-install Integrated services, but I have had no luck.

Sad

Forch|||I have this exact same problem and can't seem to be able to find any information about it. I too have uninstalled and reinstalled everything with no success. Any help greatly appreciated.|||

Hi Scott,

Its too late to ask this question. Can you remember what makes this problem fixed? We too have exact problem and unable to get any help

Any refernce would be helpful.

Thanks in Advance

Phani Kiran K

|||

Hi Forch,

I too have exact problem. Can you remember the solution you had for this problem?

Any reference would be helpful.

Thanks in Advance,

Phani Kiran K.

|||

Sorry.... I have not visited this in a while. I just changed everything I need to do to script.

Cheers,

Forch

|||

This issues is realted to 64 bit environment. Once we register the necessary dlls in the 64 bit environmen, everything is working fine

Regards,

Phani.

Can not connect to a flat file

Hi all....

With Visual Studio, I have created a new "Integration Services Project".

As per the tutorial instructions, I right-click in the "Connection Managers" box, and I select "New Flat File Connection"

When I do so, I get this error:

The new connection manager could not be created.
Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)

Any suggestions? (BTW, I'm using 64-Bit Enterprise edition for x64)

Thanks!

Forch

.... To continue, I am not able to make ANY data connections at all.... SQL Server, Oracle, FTP, Text file, nothing.

I have tried to remove and re-install Integrated services, but I have had no luck.

Sad

Forch

|||I have this exact same problem and can't seem to be able to find any information about it. I too have uninstalled and reinstalled everything with no success. Any help greatly appreciated.

Tuesday, March 20, 2012

Can not access SQL database for Website security settings

I'm using Visual Studio 2005 (8.0.50727.42) and going into the menu option Website > ASP.Net Configuration, access the security tab and all I get is an error message stating that there is a problem with the selected data store "Unable to Connect to the SQL Server Database"

I have SQL Server 2005 (Express Edition). I have created a database "NetDev" with the right connection, etc.

I can use the SQL server fine for my Windows applications, but somehow this ASp.Net Configuration tool is not making any sense.

I also used the aspnet_regsql command from framework 2.0 to create a DataBase to no avail.

Does anyone out there knows if there is a bug with this tool?

Responding to my own question.

I finally reinstalled everything from scratch, IIS first, and then Visual Studio and my problem went away. It obviously had some corruption as I havce deleted and recreated many apps I may have induced some problems. Also the NET Service had to be added to the APP-Data dir with write permissions (this may have been the real cause).

sql

Tuesday, March 27, 2012

can not expand table group in internet explorer

Can not drop a member from a role

Can not drop a member from a role

Can not drop a member from a role

Sunday, March 25, 2012

Can not connect to SQL Server 2005 Developer edition remotely

Thursday, March 22, 2012

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 remote SQL Express 2005

can not connect to remote SQL Express 2005

Can not connect to desktop sql database from mobile device (Pocket PC)

Can not connect to a flat file

Can not connect to a flat file

Can not connect to a flat file

Can not connect to a flat file

Tuesday, March 20, 2012

Can not access SQL database for Website security settings

install SQL on WinXP

Blog Archive

About Me