Showing posts with label install. Show all posts

Thursday, March 29, 2012

Access denied and no files...

I performed an install of SSRS and SharePoint as noted in this document...
http://blogs.msdn.com/sharepoint/archive/2007/08/02/microsoft-sql-server-reporting-services-installation-and-configuration-guide-for-sharepoint-integration-mode.aspx
...with one exception I installed everything (SQL Server, Reporting
Services, and SharePoint) on the same server (single server install, don't
worry it is purely a dev box on an isolate test network, I would never do
this in production). I have rebuilt the server twice and worked though this
document each time.
Every time I get to Step 12 (on page 38-39 of the document), I try opening
the reporting services web site using the server name (e.g.
http://servername:8080/Reportserver). I get a login prompt and access denied
after three attempts. When I try to access it through localhost (e.g.
http://localhost:8080/ReportServer), I do not get the login prompt, but I do
get the typical directory browsing page with no files are listed.
All the ACLs (NTFS permissions) are set to allow Full Control for the local
admins and the three accounts being used per the document are in local admins
group. The Local admins group and the three accounts have SysAdmin rights on
SQL server.
I have done many SSRS installs but have yet to experience and issue like
this. I would greatly appreciate any of you pointing me in the right direct
to check settings. Any helpIt sounds like you are running into the Loopback Checking that was put into
place by Windows Server 2003 SP1. Follow the instructions in the KB article
listed below and that should solve your issue.
http://support.microsoft.com/kb/896861
Follow the steps under "Method 1" and see if that works.
Don't forget to reboot for it to kick in.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.

Tuesday, March 27, 2012

Access denied

I'm using SQL Server 2000, and tried to install Reporting Services. After the install completed, I got a message that stated "Setup could not initiate the report server. You must manually initialize the report server...."

I tried a few things such as rsactivate and rsconfig, but I always receive the same error when accessing the Report webpage:

Access is denied.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ApplicationException: Access is denied.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[ApplicationException: Access is denied. ] System.Security.Principal.WindowsIdentity._ResolveIdentity(IntPtr userToken) +0 System.Security.Principal.WindowsIdentity.get_Name() +71 Microsoft.ReportingServices.UI.GlobalApp.Application_AuthenticateRequest(Object sender, EventArgs e) System.Web.SyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() +60 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +87

Does anyone know how to resolve this issue?

Jeff

Run aspnet_regiis.exe -i from the windows\microsoft .net Framework\v1.1.4322 folder.

-Lukasz

|||

Thank you. Now I am receiving the following:

Server Error in '/Reports' Application.

Event source Report Manager does not exist.

Exception Details: Microsoft.ReportingServices.Diagnostics.Utilities.EventLogSourceNotFound: Event source Report Manager does not exist.

Source Error:

Stack Trace:

[EventLogSourceNotFound: Event source Report Manager does not exist.] Microsoft.ReportingServices.Diagnostics.Utilities.RSEventLog.Init() Microsoft.ReportingServices.Diagnostics.Globals.Init(RSConfigurationManager configManager, RunningApplication app) Microsoft.ReportingServices.UI.GlobalApp.Application_Start(Object sender, EventArgs e)

Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573

|||Use regmon to check if there are some registry access getting denied that is related to event log sources.

Saturday, February 25, 2012

About the location of database file.

I can install the SQL Server Express in a computer and locate the database files in another computer of the same local network?

No, you cannot.

The datafiles have to be on a local drive -NOT a mapped drive, or even an UNC share. (A properly configured NAS/SAN is different though.)

about supersocket failed

Hi!
When i install a layered SPI, the SQL will report supersocket failed while
bind to port 1433 ? when i uninstall the layered SPI, it is OK. but i
disable the SPI by move the SPI down, it also report failed? who can tell me
the reason and how to avoid it?
Thanks!
Xiaorun huangHi
Have you run netstat -b to see what is using the port?
John
"xiaorun" wrote:

> Hi!
> When i install a layered SPI, the SQL will report supersocket failed while
> bind to port 1433 ? when i uninstall the layered SPI, it is OK. but i
> disable the SPI by move the SPI down, it also report failed? who can tell
me
> the reason and how to avoid it?
> Thanks!
> Xiaorun huang
>
>|||I had see and it is sqlservr use the 1433 port, and i can connect to 1433
port and use SQL server, but it has this error in the event log.
Thanks!
Xiaorun huang
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:CE72090D-0F89-4FFF-B98E-6E7620DE129A@.microsoft.com...
> Hi
> Have you run netstat -b to see what is using the port?
> John
> "xiaorun" wrote:
>|||Hi
You can get the error message whe n the account that the SQL Server service
is running as, does not have local admin rights, but how that would be linke
d
to loading SPI and why you would not get it without, I am not sure.
John
"xiaorun" wrote:

> I had see and it is sqlservr use the 1433 port, and i can connect to 1433
> port and use SQL server, but it has this error in the event log.
> Thanks!
> Xiaorun huang
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:CE72090D-0F89-4FFF-B98E-6E7620DE129A@.microsoft.com...
>
>

About SQLH2 installation problem .....

hi,
I just tried to install SQL Health and Performance Tool (SQLH2), but when
set the schedule task procedure of the installation, it occured error. After
I read the guide, my server is Window 2000 server, it said it can only
support window server 2003 & window XP(I know that). And the wizard said
press "continue" to ignore that problem and need to set the schedule by
manual, but after I pressed "continue", it still occured that error and no
any other response of it.
So, anyone meet that error as like as me b4?
I feel appreciate anyone can help me ! ^^
Regards,
Tarek ^^'
Tarek's WorkShop
This is a bug in configuration utility.
At this point SQLH2 is installed and configured. You only need to add task
to run it on schedule. You have to do that manually on W2K.
Command to run (int the task) - sqlh2.exe
Thanks
Grigory
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
"Tarek" <Tarek@.discussions.microsoft.com> wrote in message
news:86829E85-5171-46DD-9B1F-35522EB726AF@.microsoft.com...
> hi,
> I just tried to install SQL Health and Performance Tool (SQLH2), but when
> set the schedule task procedure of the installation, it occured error.
After
> I read the guide, my server is Window 2000 server, it said it can only
> support window server 2003 & window XP(I know that). And the wizard said
> press "continue" to ignore that problem and need to set the schedule by
> manual, but after I pressed "continue", it still occured that error and no
> any other response of it.
> So, anyone meet that error as like as me b4?
> I feel appreciate anyone can help me ! ^^
>
> --
> Regards,
> Tarek ^^'
> --
> Tarek's WorkShop
|||thanks Grigory, let me try it.
Tarek ^^
"Grigory Pogulsky [MS]" wrote:

> This is a bug in configuration utility.
> At this point SQLH2 is installed and configured. You only need to add task
> to run it on schedule. You have to do that manually on W2K.
> Command to run (int the task) - sqlh2.exe
> --
> Thanks
> Grigory
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Please reply to the newsgroups only, thanks.
>
> "Tarek" <Tarek@.discussions.microsoft.com> wrote in message
> news:86829E85-5171-46DD-9B1F-35522EB726AF@.microsoft.com...
> After
>
>

Sunday, February 19, 2012

about security of SQL Server

"Hari" wrote:

> Hi,
> From command prompt execute OSQL to login to sql server MSDE:-
> OSQL -Usa -Ppassword -S Server_name (enter Key)
> 1>sp_password null,'newpassword','sa'
> 2>go
> THis will change the password of sa.
> --
> Thanks
> Hari
> MCDBA
> "Ferhat" <Ferhat@.discussions.microsoft.com> wrote in message
> news:9C3D68D6-B2D5-499E-91B4-3CE70E4D44E6@.microsoft.com...
>
>

about security of SQL Server

hi;
i have install an sql-server desktop edition on winXP
how can change my "sa" password
thank you...Hi,
From command prompt execute OSQL to login to sql server MSDE:-
OSQL -Usa -Ppassword -S Server_name (enter Key)
1>sp_password null,'newpassword','sa'
2>go
THis will change the password of sa.
--
Thanks
Hari
MCDBA
"Ferhat" <Ferhat@.discussions.microsoft.com> wrote in message
news:9C3D68D6-B2D5-499E-91B4-3CE70E4D44E6@.microsoft.com...
> hi;
> i have install an sql-server desktop edition on winXP
> how can change my "sa" password
> thank you...|||hi Hari;
i'm from Turkey
Thank you very much...:)
"Hari" wrote:
> Hi,
> From command prompt execute OSQL to login to sql server MSDE:-
> OSQL -Usa -Ppassword -S Server_name (enter Key)
> 1>sp_password null,'newpassword','sa'
> 2>go
> THis will change the password of sa.
> --
> Thanks
> Hari
> MCDBA
> "Ferhat" <Ferhat@.discussions.microsoft.com> wrote in message
> news:9C3D68D6-B2D5-499E-91B4-3CE70E4D44E6@.microsoft.com...
> > hi;
> > i have install an sql-server desktop edition on winXP
> > how can change my "sa" password
> > thank you...
>
>

about security of SQL Server

About reporting service installation

Hi all,
I have question regarding reporting service installation. Do I need to
install reporting service server software and client software respectively?
Thanks.Hi Iter,
When you say install Server software and client software I am not sure what
you mean, The client see's a web based interface so no specific software is
required, if your talking about the development enviroment, that can be
installed @. the same time... or are your referring to somthing else...
Cheers
Matt
"Iter" wrote:
> Hi all,
> I have question regarding reporting service installation. Do I need to
> install reporting service server software and client software respectively?
> Thanks.
>|||Thank you very much. The thing is that we use report designer in visual
studio.net to develop report, and generally visual studio.net is installed
in client computer. But report manager and report server install in sql
server server side. How to install those respectively. Thanks.
Jerry Mu
"Aussie Matt" wrote:
> Hi Iter,
> When you say install Server software and client software I am not sure what
> you mean, The client see's a web based interface so no specific software is
> required, if your talking about the development enviroment, that can be
> installed @. the same time... or are your referring to somthing else...
> Cheers
> Matt
> "Iter" wrote:
> > Hi all,
> > I have question regarding reporting service installation. Do I need to
> > install reporting service server software and client software respectively?
> > Thanks.
> >

Monday, February 13, 2012

About managing SQL server 2005

Hi, I just start using MSSQL server 2005, I already install vss studio2005 so SQL server 2005 is already installed by default (expressedition).

But unlike SQL server 2000, I coultn't find any tools similiar to "sqlentreprise manager". I was able to create a new database only fromserver explorer tools in VSS. But pretty strange that this database actlike a microsoft access database (creating a database file on myapp_data folder). (I am sorry I am new in SQL server 2005ExpressEdition ).

My question :
1. is that (above) really how mssql server 2005 works?
2. how to create a new user for this database? (example user: sa password: "admin")

thanks

**BUMP**

Please help me..... Crying [:'(]

|||

Test drive the eval version is it good for 180 days install it as a named instance and register the Express so you can manage it with the management studio of the full version. I have not used the Express but the full version almost self install after you select the components to install, then right click at the top of management studio to register the Express. Hope this helps.

http://www.microsoft.com/sql/downloads/trial-software.mspx

Saturday, February 11, 2012

about deployment with database

Hai,
We created one application, in .net with sql server 2005. we
created the setup file also.
Now we want to install the application in client place, But,
client don't have any sql server in their system. I heard about with
MSDE, there is no need for sql server.
Anybody can explain, what we have to do now.
Regards,
Raju.Go to www.microsoft.com/sql and look at the SQL Server 2005 Express.
It is a 'FREE' product, the successor to MSDE, and may serve your needs.
SQL Server 2005 Express Edition Feature Comparison
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
SQL Server 2005 Express Overview
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/sseoverview.asp
http://www.pcw.co.uk/personal-computer-world/software/2155087/review-microsoft-sql-server
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
"raju" <ponnurajs@.gmail.com> wrote in message
news:1162015230.775017.143230@.i42g2000cwa.googlegroups.com...
> Hai,
> We created one application, in .net with sql server 2005. we
> created the setup file also.
> Now we want to install the application in client place, But,
> client don't have any sql server in their system. I heard about with
> MSDE, there is no need for sql server.
> Anybody can explain, what we have to do now.
> Regards,
> Raju.
>|||Hai,
Thanks for you immediate response.
Whether we have to install the sql server 2005 express manually, is
it possible to install the sql server 2005 from our .net application
automatically.
First we will deploy, required installation files and database
files in our application.
So, when we install the application, first the sql server 2005
express will install and after that out application will get installed.
If this one is possible then, please give me the procedure for
that.
Thanks in advance.
Regards,
Raju.|||See:
SQL Server 2005 Unintended Installations
http://www.devx.com/dbzone/Article/31648
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
"raju" <ponnurajs@.gmail.com> wrote in message
news:1162021453.839712.248670@.i3g2000cwc.googlegroups.com...
> Hai,
> Thanks for you immediate response.
> Whether we have to install the sql server 2005 express manually, is
> it possible to install the sql server 2005 from our .net application
> automatically.
> First we will deploy, required installation files and database
> files in our application.
> So, when we install the application, first the sql server 2005
> express will install and after that out application will get installed.
> If this one is possible then, please give me the procedure for
> that.
> Thanks in advance.
> Regards,
> Raju.
>|||> SQL Server 2005 Unintended Installations
Freudian slip, Arnie? :-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Arnie Rowland" <arnie@.1568.com> wrote in message news:OFd5COr%23GHA.3952@.TK2MSFTNGP03.phx.gbl...
> See:
> SQL Server 2005 Unintended Installations
> http://www.devx.com/dbzone/Article/31648
>
> --
> 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
>
> "raju" <ponnurajs@.gmail.com> wrote in message
> news:1162021453.839712.248670@.i3g2000cwc.googlegroups.com...
>> Hai,
>> Thanks for you immediate response.
>> Whether we have to install the sql server 2005 express manually, is
>> it possible to install the sql server 2005 from our .net application
>> automatically.
>> First we will deploy, required installation files and database
>> files in our application.
>> So, when we install the application, first the sql server 2005
>> express will install and after that out application will get installed.
>> If this one is possible then, please give me the procedure for
>> that.
>> Thanks in advance.
>> Regards,
>> Raju.
>|||Got me...
But sometimes, the user may not have 'intended' to end up with a SQL
installation -but they get one anyway.
--
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
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OaGw9Xr%23GHA.4708@.TK2MSFTNGP05.phx.gbl...
>> SQL Server 2005 Unintended Installations
> Freudian slip, Arnie? :-)
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Arnie Rowland" <arnie@.1568.com> wrote in message
> news:OFd5COr%23GHA.3952@.TK2MSFTNGP03.phx.gbl...
>> See:
>> SQL Server 2005 Unintended Installations
>> http://www.devx.com/dbzone/Article/31648
>>
>> --
>> 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
>>
>> "raju" <ponnurajs@.gmail.com> wrote in message
>> news:1162021453.839712.248670@.i3g2000cwc.googlegroups.com...
>> Hai,
>> Thanks for you immediate response.
>> Whether we have to install the sql server 2005 express manually, is
>> it possible to install the sql server 2005 from our .net application
>> automatically.
>> First we will deploy, required installation files and database
>> files in our application.
>> So, when we install the application, first the sql server 2005
>> express will install and after that out application will get installed.
>> If this one is possible then, please give me the procedure for
>> that.
>> Thanks in advance.
>> Regards,
>> Raju.
>>|||Hello Arnie Rowland,
Now we got the sqlexpress, when we run the applcation it is
running smoothly.
The database is from our application only. But when we run the
crystal reports it is refering the database logon information on the
machine, where we created the crystal reports.
I know the problem, why it is. Bec., we created the crystal
reports, using the local datasource only.
So, how to give the datasource, when we creating the crystal
reports.
Thanks in advance.
Regards,
Raju.|||That is a crystal reports issue, you need to change that in crystal reports. I suggest you post this
to some suitable crystal reports forum, as there isn't that high probability that you find experts
on crystal reports here.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"raju" <ponnurajs@.gmail.com> wrote in message
news:1162188434.813391.82120@.k70g2000cwa.googlegroups.com...
> Hello Arnie Rowland,
> Now we got the sqlexpress, when we run the applcation it is
> running smoothly.
> The database is from our application only. But when we run the
> crystal reports it is refering the database logon information on the
> machine, where we created the crystal reports.
> I know the problem, why it is. Bec., we created the crystal
> reports, using the local datasource only.
> So, how to give the datasource, when we creating the crystal
> reports.
> Thanks in advance.
> Regards,
> Raju.
>|||Hello,
Thanks for your response.
We can change that datasource at runtime also. Can you guide me
on how to do that.
Regards,
Raju.
Tibor Karaszi wrote:
> That is a crystal reports issue, you need to change that in crystal reports. I suggest you post this
> to some suitable crystal reports forum, as there isn't that high probability that you find experts
> on crystal reports here.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "raju" <ponnurajs@.gmail.com> wrote in message
> news:1162188434.813391.82120@.k70g2000cwa.googlegroups.com...
> > Hello Arnie Rowland,
> >
> > Now we got the sqlexpress, when we run the applcation it is
> > running smoothly.
> >
> > The database is from our application only. But when we run the
> > crystal reports it is refering the database logon information on the
> > machine, where we created the crystal reports.
> >
> > I know the problem, why it is. Bec., we created the crystal
> > reports, using the local datasource only.
> >
> > So, how to give the datasource, when we creating the crystal
> > reports.
> >
> > Thanks in advance.
> >
> > Regards,
> > Raju.
> >|||> We can change that datasource at runtime also. Can you guide me
> on how to do that.
I've never used Crystal Reports. You need ask people who know Crystal Reports on how to do this.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"raju" <ponnurajs@.gmail.com> wrote in message
news:1162378360.362543.118220@.b28g2000cwb.googlegroups.com...
> Hello,
> Thanks for your response.
> We can change that datasource at runtime also. Can you guide me
> on how to do that.
> Regards,
> Raju.
> Tibor Karaszi wrote:
>> That is a crystal reports issue, you need to change that in crystal reports. I suggest you post
>> this
>> to some suitable crystal reports forum, as there isn't that high probability that you find
>> experts
>> on crystal reports here.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "raju" <ponnurajs@.gmail.com> wrote in message
>> news:1162188434.813391.82120@.k70g2000cwa.googlegroups.com...
>> > Hello Arnie Rowland,
>> >
>> > Now we got the sqlexpress, when we run the applcation it is
>> > running smoothly.
>> >
>> > The database is from our application only. But when we run the
>> > crystal reports it is refering the database logon information on the
>> > machine, where we created the crystal reports.
>> >
>> > I know the problem, why it is. Bec., we created the crystal
>> > reports, using the local datasource only.
>> >
>> > So, how to give the datasource, when we creating the crystal
>> > reports.
>> >
>> > Thanks in advance.
>> >
>> > Regards,
>> > Raju.
>> >
>

Thursday, March 29, 2012

Access denied and no files...

Tuesday, March 27, 2012

Access denied

Access is denied.

Server Error in '/Reports' Application.

Event source Report Manager does not exist.

Saturday, February 25, 2012

About the location of database file.

about supersocket failed

About SQLH2 installation problem .....

Sunday, February 19, 2012

about security of SQL Server

about security of SQL Server

about security of SQL Server

About reporting service installation

Monday, February 13, 2012

About managing SQL server 2005

Saturday, February 11, 2012

about deployment with database

about deployment with database

SQL About AMO

Blog Archive

About Me