Showing posts with label http. Show all posts
Showing posts with label http. Show all posts

Thursday, March 22, 2012

Can't add database to projects

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

I have gone through the above and, while I can connect to the sql server and activate connections, I can not add a sql database to a project.

Open a project
Right click - add new item
Choose sql database

or

Add existing item
choose existing sql database

results in:

"Connections to SQL server files (*.mdf) require sql server express 2005 to function properly blah blah blah"

Like I said, I can connect to the DB through the server explorer and view table definitions and data. I just can't add one to a solution. I have reinstalled sqlexpress already and am trying to avoid having to reinstall visual studio.

OK, is the SQL Express service started properly ? If you are not sure, have a look in the Service manager. User Instance can be only attached to SQLExpress instances. There is sure an option to also do that in SQL Server > Express editions, but that should not be turned on. if you are not sure why the connection can′t take place navigate through Tools > Options > Database Tools > Database connections. You will need to make sure that the right instance name is mentioned here, otherwise SQL Server won′t find the instance for attaching the database as a user instance. If the entry in here is right you will have to see if the SQL Browser is started. This service will act like a redirector for user requests and will redirect the user to the right port of the requested instance. If you don′t want SQL Browser running on your computer, you will have to put the portnumber after the instanceName like in the syntax InstanceName,portnumber.

HTH, Jens Suessmeyer.


http://www.sqlserver2005.de

|||Sorry for the delay.

I have reviewed and confirmed your suggestions. I have also uninstalled sql express and installed it again without using the advanced install.

Once again, I can connect to the database from the server window in the IDE (VS 2005), but I cannot add a new or existing database to any projects.

I thought perhaps it would have been permissions so I granted network service full rights to my project folder without success.

At this point, I'm starting to think that re-installing Visual Studio is going to end up being the solution. I hate that idea.

Any help?

Tuesday, March 20, 2012

Can't access reports by server name

I am trying to set up Reporting Services on one of our servers. It is set up
and I can get to the reports by typing in http://localhost/reports but when
I try http://<servername>/reports I get page not found - this also applies
to any files in the default website. I think it is something straight
forward in IIS but I don't what it is - I am a programmer and a bit clueless
with IIS. Regards, Chris.Are you sure your <servername> is where the reports are located? The
<localhost> is an alias for 127.0.0.1 or the local loopback address. It
sounds like I would check to see also if the server has more than one address
on it. The /reports URL may not be listening on the address for <servername>.
Regards,
Norm Hill
"Fresno Bob" wrote:
> I am trying to set up Reporting Services on one of our servers. It is set up
> and I can get to the reports by typing in http://localhost/reports but when
> I try http://<servername>/reports I get page not found - this also applies
> to any files in the default website. I think it is something straight
> forward in IIS but I don't what it is - I am a programmer and a bit clueless
> with IIS. Regards, Chris.
>
>

Can't access Report Manager -> Http status 401: Unauthorized

I've been struggeling with this problem on and off for a few weeks now.
I can't access the Report Manager, but I can access Report Server.
The server: Windows 2003 Standard Edition, no SP.
It runs SQL Server Enterprise Edition sp 3 and Analysis Services sp 3.
I've installed Reporting Services Ent. Edition, sp 1.
I can access http://machinename/reportserver but not
http://machinename/reports. I get the login box, but I get this error
message when "logged in":
The request failed with HTTP status 401: Unauthorized.
Both Vdirs have Integrated Windows Authentication and not enabled Anonymous
Access.
I've tried logging in with 3 different users, but they all fail.
All help appreciated for getting this to work!
Kaisa M. LindahlI have the identical problem, but the login provided has the necessary rights
and Admin in both the Domain and local Builtin Admin groups.
--
Keith Powers, MCDBA
"David Siebert" wrote:
> What rights do the logins you used have for the server on which RS is located?
> "Kaisa M. Lindahl" wrote:
> > I've been struggeling with this problem on and off for a few weeks now.
> > I can't access the Report Manager, but I can access Report Server.
> >
> > The server: Windows 2003 Standard Edition, no SP.
> > It runs SQL Server Enterprise Edition sp 3 and Analysis Services sp 3.
> > I've installed Reporting Services Ent. Edition, sp 1.
> >
> > I can access http://machinename/reportserver but not
> > http://machinename/reports. I get the login box, but I get this error
> > message when "logged in":
> > The request failed with HTTP status 401: Unauthorized.
> >
> > Both Vdirs have Integrated Windows Authentication and not enabled Anonymous
> > Access.
> > I've tried logging in with 3 different users, but they all fail.
> >
> > All help appreciated for getting this to work!
> >
> > Kaisa M. Lindahl
> >
> >
> >

Can't Access http://MyServer/Reports -- 401 Error

Not sure if this is the place to post this or over at the IIS group so
I'll try both!
Although I've never seen it, I've been told that our Reporting Service
used to work until I changed the permissions on a TOTALLY unrelated
virtual directory and file folder. Using IE, when I try to go to the
site I get that nasty message, "The request failed with HTTP status
401: Unauthorized." I've researched here, looked at several MSDN
knowledge base articles (the ones about negotiating Kerebos logins),
and tried everything else I could think of. Interestingly, when I use
FireFox, I at least get a dialog box asking me for my user name and
password although it doesn't accept login.
Any suggestions would be most appreciated.
Thanks.
RandyIt sounds like it was broken before you made changes but no one knew
about it, and since you were the last one making server changes that
anyone knew about... you got stuck with having to fix something you did
not break.
By default, IIS does not return any 401 message that looks like "The
request failed with HTTP status 401: Unauthorized". IE does not
translate any errors into that, either.
So, I believe you are getting 401 from some non-IIS-related custom
authentication component, in which case you need to identify that
component and obtain configuration support for it. It is important for
you to obtain support from the component having problems and not just
generic assistance because there are unknown details that can be
important.
I did a search on those words, and it appears to come from a .NET
Client. Probably used by the Reporting Service application itself. So
you want to start your questions from them.
FYI: IE skipped to the 401 message because it already automatically
tried several logons over different allowed protocols on your behalf
and decided to stop trying. FireFox assumes you can retry yourself so
it pops up the login. But they both fail to login, of course.
//David
http://w3-4u.blogspot.com
//
EoRaptor013 wrote:
> Not sure if this is the place to post this or over at the IIS group so
> I'll try both!
> Although I've never seen it, I've been told that our Reporting Service
> used to work until I changed the permissions on a TOTALLY unrelated
> virtual directory and file folder. Using IE, when I try to go to the
> site I get that nasty message, "The request failed with HTTP status
> 401: Unauthorized." I've researched here, looked at several MSDN
> knowledge base articles (the ones about negotiating Kerebos logins),
> and tried everything else I could think of. Interestingly, when I use
> FireFox, I at least get a dialog box asking me for my user name and
> password although it doesn't accept login.
> Any suggestions would be most appreciated.
> Thanks.
> Randy

Sunday, March 11, 2012

Cannot view http://webserver/Reports/Pages/Folder.aspx page from my system

Hi,
I am trying to view http://webserver/Reports/Pages/Folder.aspx page that resides on my collegues system as he has got SQL Reporting Services installed on it, but what all i can see is the title 'SQL Server Reporting Services' and 'Home' written on it. I am not able to view tabs like 'Contents', 'properties' which my collegue can when he browses for the page from his system.

Is there any problem with the rights. Please suggest how can I view these options like 'Contents' etc.

Ashu

Report server out of the box only gives local admins any rights. All other rights must be granted by a local admin.

Have a local admin click on the properties tab on the home page and then on the security tab. From there they can add new users and give them the desired permissions.

You can find more information on the predefined roles here:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rswork/htm/rms_security_v1_01h4.asp

Saturday, February 25, 2012

Cannot start SQL Server 2005 management express studio CTP?

I downloaded it from the link in
http://msdn.microsoft.com/vstudio/express/sql/. It's still Nov CTP version.
And it cannot be run on two machines. Both installed VS 2003.http://msdn.microsoft.com/sql/express/default.aspx has RTM version.
--
William Stacey [MVP]
"nick" <nick@.discussions.microsoft.com> wrote in message
news:4ECA7D5A-6987-41E5-A1DD-41C49D190BBC@.microsoft.com...
>I downloaded it from the link in
> http://msdn.microsoft.com/vstudio/express/sql/. It's still Nov CTP
> version.
> And it cannot be run on two machines. Both installed VS 2003.|||Still CTP:
"Get SQL Server Management Studio Express
Download a Community Technology Preview (CTP) of SQL Server Management
Studio Express (SSMSE). SSMSE is a free graphical management tool for SQL
Express that makes it easy for you to administer SQL Server Express
databases."
"William Stacey [MVP]" wrote:
> http://msdn.microsoft.com/sql/express/default.aspx has RTM version.
> --
> William Stacey [MVP]
> "nick" <nick@.discussions.microsoft.com> wrote in message
> news:4ECA7D5A-6987-41E5-A1DD-41C49D190BBC@.microsoft.com...
> >I downloaded it from the link in
> > http://msdn.microsoft.com/vstudio/express/sql/. It's still Nov CTP
> > version.
> > And it cannot be run on two machines. Both installed VS 2003.
>
>|||No. SQL Express is RTM. SSME is CTP.
--
William Stacey [MVP]
"nick" <nick@.discussions.microsoft.com> wrote in message
news:E8E707DD-793B-4D99-978A-03ECAAA3DE98@.microsoft.com...
> Still CTP:
> "Get SQL Server Management Studio Express
> Download a Community Technology Preview (CTP) of SQL Server Management
> Studio Express (SSMSE). SSMSE is a free graphical management tool for SQL
> Express that makes it easy for you to administer SQL Server Express
> databases."
> "William Stacey [MVP]" wrote:
>> http://msdn.microsoft.com/sql/express/default.aspx has RTM version.
>> --
>> William Stacey [MVP]
>> "nick" <nick@.discussions.microsoft.com> wrote in message
>> news:4ECA7D5A-6987-41E5-A1DD-41C49D190BBC@.microsoft.com...
>> >I downloaded it from the link in
>> > http://msdn.microsoft.com/vstudio/express/sql/. It's still Nov CTP
>> > version.
>> > And it cannot be run on two machines. Both installed VS 2003.
>>

Cannot start Reporting Service

Hi
when i try starting http://localhost/ReportServer i get the error
(rsReportserverdatabaseLogonFailed)
The RPC server is not listenning
Can anyone helpTry starting the ReportServer windows service. If it does not start, look
in the ReportServerService<date>.log file for information on the failure.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"SJ" <SJ@.discussions.microsoft.com> wrote in message
news:C186CA94-D4ED-4717-80A6-FF97BBED8057@.microsoft.com...
> Hi
> when i try starting http://localhost/ReportServer i get the error
> (rsReportserverdatabaseLogonFailed)
> The RPC server is not listenning
> Can anyone help