Showing posts with label web. Show all posts
Showing posts with label web. Show all posts

Thursday, March 29, 2012

Can't configure Web Service Identity

I recently renamed my server from tmpSrv to tfsSrv (names have been changed to protect the innocent). When I go to the Reporting Services Configuration Manager I have all greens except for the Web Service Identity field.

Trying to set that isn't working...the ASP.Net service account is NT Authority\Network Service, and the application pools defined are using that Network Service account as well. When I hit the "Apply" button I get a message saying:

Setting Web Service Identity

There was an error setting the identity for the web service. The previously set identity will still be used.

I'm trying to install Team Foundation Server on the box, and when I run the tfrsconfig /verify tool I see that the Web Service Identity is not set at all.

I've been battling this for a couple of days now with no effect. I even broke down and gave "Everyone" administrative access on the server in an attempt to fix it.

Thanks for any help

Hello Joe,

I think you'll need to edit the rsreportserver.config file in the directory: X:\Program Files\Microsoft SQL Server\MSSQL.x\Reporting Services\ReportServer. Search for <WebServiceAccount>NT Authority\NetworkService</WebServiceAccount> and you can change it here. I believe this will have to match the security you have setup for the application pool.

Hope this helps.

Jarret

|||Which version of OS and RS are you running? If you click on "tell me more" link in the config tool there should be more messages.

Sunday, March 25, 2012

cant add sql endpoint to my visual studio project. trying "add as web reference" does

i have created a database endpoint that just retuns some data. i am trying to call this endpoint as a web service in visual studio by adding a web reference, but i cannot find my endpoint. it seems to just check iis for endpoints, but how do i make it look for my sql endpoint? here is the code for my endpoint.

create endpoint testEndpoint authorization [FINTAN-PC\Fintan]
state=STARTED
as http
(
path ='/sql',
authentication=(INTEGRATED),
ports = (CLEAR),
site='SERVER'
)
For SOAP
(
webmethod'ProvideSQLData'(name='adventureWorks.dbo.testEndpointProcedure'),
WSDL=DEFAULT,
SCHEMA=STANDARD,
DATABASE='adventureworks',
NAMESPACE='http://thenamespace.org'
);
GO

the account that visual studio is running under has been granted connect permissions on the endpoint. can anyone say where im going wrong here?

I'm a little unclear on your mentioning of using Visual Studio to look for this SOAP endpoint. Are you referring to using UDDI?

Regarding "add as web reference" in Visual Studio, the method that has worked best for me is to type in the HTTP URL that points to the WSDL document.

In this scenario it will be: http://SERVER/sql?wsdl

This URL comes from:

site='SERVER'

path='/sql'

So, if the endpoint was configured with:

site='foobar'

path='/myOwnPath/subPath'

then the WSDL document URL will be http://foobar/myOwnPath/subPath?wsdl

One easy way to ensure the user account running Visual Studio has access to retrieve the WSDL document is to use a Web Browser (such as IE) and point to the WSDL document URL.

HTH,

Jimmy|||ok, tiny bit of progress made. when i use the http://sitename/path?wsdl , rather than getting a 404 error, i get a page cannot be displayed. this is in IE7. any ideas?

cant add sql endpoint to my visual studio project. trying "add as web reference" does

i have created a database endpoint that just retuns some data. i am trying to call this endpoint as a web service in visual studio by adding a web reference, but i cannot find my endpoint. it seems to just check iis for endpoints, but how do i make it look for my sql endpoint? here is the code for my endpoint.

create endpoint testEndpoint authorization [FINTAN-PC\Fintan]
state=STARTED
as http
(
path ='/sql',
authentication=(INTEGRATED),
ports = (CLEAR),
site='SERVER'
)
For SOAP
(
webmethod'ProvideSQLData'(name='adventureWorks.dbo.testEndpointProcedure'),
WSDL=DEFAULT,
SCHEMA=STANDARD,
DATABASE='adventureworks',
NAMESPACE='http://thenamespace.org'
);
GO

the account that visual studio is running under has been granted connect permissions on the endpoint. can anyone say where im going wrong here?

I'm a little unclear on your mentioning of using Visual Studio to look for this SOAP endpoint. Are you referring to using UDDI?

Regarding "add as web reference" in Visual Studio, the method that has worked best for me is to type in the HTTP URL that points to the WSDL document.

In this scenario it will be: http://SERVER/sql?wsdl

This URL comes from:

site='SERVER'

path='/sql'

So, if the endpoint was configured with:

site='foobar'

path='/myOwnPath/subPath'

then the WSDL document URL will be http://foobar/myOwnPath/subPath?wsdl

One easy way to ensure the user account running Visual Studio has access to retrieve the WSDL document is to use a Web Browser (such as IE) and point to the WSDL document URL.

HTH,

Jimmy|||ok, tiny bit of progress made. when i use the http://sitename/path?wsdl , rather than getting a 404 error, i get a page cannot be displayed. this is in IE7. any ideas?

Tuesday, March 20, 2012

Can't access Reporting with Management Studio

Bonjour!
I can't have access with my management studio to Reporting services
(2005)installed on my web server. (Cannot connect to...)Do my developpers
needs special rights?
Regards, Joel :)What do you mean access? You should be able to design reports without any
access to RS. It is only when deploying that you need special rights. Either
they need to be part of the local administrators group on the server where
RS is running OR they need to be put into the appropriate role (read up on
roles for Reporting Services).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Joel" <Joel@.discussions.microsoft.com> wrote in message
news:598AD496-F255-4AB9-9DFD-DEE860D45F6F@.microsoft.com...
> Bonjour!
> I can't have access with my management studio to Reporting services
> (2005)installed on my web server. (Cannot connect to...)Do my developpers
> needs special rights?
> Regards, Joel :)|||Did you check SQL Server Configuration Manager to see if the Reporting
Services service is started? It could also be a rights issue. Do you have
sysadmin rights on your MSSQL server?
--
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Joel" <Joel@.discussions.microsoft.com> wrote in message
news:598AD496-F255-4AB9-9DFD-DEE860D45F6F@.microsoft.com...
> Bonjour!
> I can't have access with my management studio to Reporting services
> (2005)installed on my web server. (Cannot connect to...)Do my developpers
> needs special rights?
> Regards, Joel :)|||Whoa! To deploy a report to RS does not need sysadmin rights. There is no
way that developers should have sysadmin rights on SQL server. RS does
everything based on its roles.
The local administrators role on the server (server not SQL Server)
automatically puts all users in that role with the rights to do anything
(subscriptions, deploy reports etc) to Reporting Services. However,
individual users or groups can be added to roles.
In Report Manager, be at Home. Click on the Properties tab, Click New Role
Assignments. Try Content Manager or Publisher. One of those roles will work.
All other folders inherit from home.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Alain Quesnel" <alainsansspam@.logiquel.com> wrote in message
news:uAqaWJKHIHA.4228@.TK2MSFTNGP02.phx.gbl...
> Did you check SQL Server Configuration Manager to see if the Reporting
> Services service is started? It could also be a rights issue. Do you have
> sysadmin rights on your MSSQL server?
> --
> Alain Quesnel
> alainsansspam@.logiquel.com
> www.logiquel.com
>
> "Joel" <Joel@.discussions.microsoft.com> wrote in message
> news:598AD496-F255-4AB9-9DFD-DEE860D45F6F@.microsoft.com...
>> Bonjour!
>> I can't have access with my management studio to Reporting services
>> (2005)installed on my web server. (Cannot connect to...)Do my developpers
>> needs special rights?
>> Regards, Joel :)
>|||Thanks Guys, when we are with the browser on Reports Server, they can deploy
and access it, I made a special role for them, but with management studio we
cannot connect to it at all.
Joel:)
"Bruce L-C [MVP]" wrote:
> Whoa! To deploy a report to RS does not need sysadmin rights. There is no
> way that developers should have sysadmin rights on SQL server. RS does
> everything based on its roles.
> The local administrators role on the server (server not SQL Server)
> automatically puts all users in that role with the rights to do anything
> (subscriptions, deploy reports etc) to Reporting Services. However,
> individual users or groups can be added to roles.
> In Report Manager, be at Home. Click on the Properties tab, Click New Role
> Assignments. Try Content Manager or Publisher. One of those roles will work.
> All other folders inherit from home.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Alain Quesnel" <alainsansspam@.logiquel.com> wrote in message
> news:uAqaWJKHIHA.4228@.TK2MSFTNGP02.phx.gbl...
> > Did you check SQL Server Configuration Manager to see if the Reporting
> > Services service is started? It could also be a rights issue. Do you have
> > sysadmin rights on your MSSQL server?
> >
> > --
> >
> > Alain Quesnel
> > alainsansspam@.logiquel.com
> >
> > www.logiquel.com
> >
> >
> > "Joel" <Joel@.discussions.microsoft.com> wrote in message
> > news:598AD496-F255-4AB9-9DFD-DEE860D45F6F@.microsoft.com...
> >> Bonjour!
> >>
> >> I can't have access with my management studio to Reporting services
> >> (2005)installed on my web server. (Cannot connect to...)Do my developpers
> >> needs special rights?
> >>
> >> Regards, Joel :)
> >
>
>|||Have you specified the path to deploy to? Right mouse click on the project
in BI Studio/VS. You need to set the target server URL to something like
this:
http://yourserver/ReportServer
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Joel" <Joel@.discussions.microsoft.com> wrote in message
news:BD19004F-06AF-48FD-8592-2B8AB74A2BF0@.microsoft.com...
> Thanks Guys, when we are with the browser on Reports Server, they can
> deploy
> and access it, I made a special role for them, but with management studio
> we
> cannot connect to it at all.
> Joel:)
> "Bruce L-C [MVP]" wrote:
>> Whoa! To deploy a report to RS does not need sysadmin rights. There is no
>> way that developers should have sysadmin rights on SQL server. RS does
>> everything based on its roles.
>> The local administrators role on the server (server not SQL Server)
>> automatically puts all users in that role with the rights to do anything
>> (subscriptions, deploy reports etc) to Reporting Services. However,
>> individual users or groups can be added to roles.
>> In Report Manager, be at Home. Click on the Properties tab, Click New
>> Role
>> Assignments. Try Content Manager or Publisher. One of those roles will
>> work.
>> All other folders inherit from home.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Alain Quesnel" <alainsansspam@.logiquel.com> wrote in message
>> news:uAqaWJKHIHA.4228@.TK2MSFTNGP02.phx.gbl...
>> > Did you check SQL Server Configuration Manager to see if the Reporting
>> > Services service is started? It could also be a rights issue. Do you
>> > have
>> > sysadmin rights on your MSSQL server?
>> >
>> > --
>> >
>> > Alain Quesnel
>> > alainsansspam@.logiquel.com
>> >
>> > www.logiquel.com
>> >
>> >
>> > "Joel" <Joel@.discussions.microsoft.com> wrote in message
>> > news:598AD496-F255-4AB9-9DFD-DEE860D45F6F@.microsoft.com...
>> >> Bonjour!
>> >>
>> >> I can't have access with my management studio to Reporting services
>> >> (2005)installed on my web server. (Cannot connect to...)Do my
>> >> developpers
>> >> needs special rights?
>> >>
>> >> Regards, Joel :)
>> >
>>|||Yes that's what I do. My little issue here is not in Visual Studio, it is
when I try to connect to report server with MS SQL Server management studio,
on my test server that I have, everything on one box, it is connecting but
with my prod it doesn't. My prod is different, the Reporting is installed on
a web server with the database on another server.
Regards, Joel :)
"Bruce L-C [MVP]" wrote:
> Have you specified the path to deploy to? Right mouse click on the project
> in BI Studio/VS. You need to set the target server URL to something like
> this:
> http://yourserver/ReportServer
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Joel" <Joel@.discussions.microsoft.com> wrote in message
> news:BD19004F-06AF-48FD-8592-2B8AB74A2BF0@.microsoft.com...
> > Thanks Guys, when we are with the browser on Reports Server, they can
> > deploy
> > and access it, I made a special role for them, but with management studio
> > we
> > cannot connect to it at all.
> >
> > Joel:)
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Whoa! To deploy a report to RS does not need sysadmin rights. There is no
> >> way that developers should have sysadmin rights on SQL server. RS does
> >> everything based on its roles.
> >>
> >> The local administrators role on the server (server not SQL Server)
> >> automatically puts all users in that role with the rights to do anything
> >> (subscriptions, deploy reports etc) to Reporting Services. However,
> >> individual users or groups can be added to roles.
> >>
> >> In Report Manager, be at Home. Click on the Properties tab, Click New
> >> Role
> >> Assignments. Try Content Manager or Publisher. One of those roles will
> >> work.
> >>
> >> All other folders inherit from home.
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >>
> >>
> >> "Alain Quesnel" <alainsansspam@.logiquel.com> wrote in message
> >> news:uAqaWJKHIHA.4228@.TK2MSFTNGP02.phx.gbl...
> >> > Did you check SQL Server Configuration Manager to see if the Reporting
> >> > Services service is started? It could also be a rights issue. Do you
> >> > have
> >> > sysadmin rights on your MSSQL server?
> >> >
> >> > --
> >> >
> >> > Alain Quesnel
> >> > alainsansspam@.logiquel.com
> >> >
> >> > www.logiquel.com
> >> >
> >> >
> >> > "Joel" <Joel@.discussions.microsoft.com> wrote in message
> >> > news:598AD496-F255-4AB9-9DFD-DEE860D45F6F@.microsoft.com...
> >> >> Bonjour!
> >> >>
> >> >> I can't have access with my management studio to Reporting services
> >> >> (2005)installed on my web server. (Cannot connect to...)Do my
> >> >> developpers
> >> >> needs special rights?
> >> >>
> >> >> Regards, Joel :)
> >> >
> >>
> >>
> >>
>
>|||I'm sorry. You asked about the developers so I immediately thought the issue
was not being able to deploy. Hence the thrust of all my posts. I never use
Management studio for anything with RS. I pulled it up just to see what it
offers and it does very little. It shows you some things but Report Manager
can easily do everything and more than what you can do with Management
Studio.
The other poster mentioned sysadmin rights on SQL Server. I don't think this
is necessary because when I look at what information is provided and changes
allowed, it is all straight Reporting Services. If you want developers to be
doing this (adding roles for instance) then have them either be in the local
administrators account on the server that is hosting Reporting Services or
add their account to the System Administrator role.
I suggest first making sure the developers can do what they need to do with
Report Manager.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Joel" <Joel@.discussions.microsoft.com> wrote in message
news:AA154A4E-229A-4F8D-BCBA-8AC2391496A5@.microsoft.com...
> Yes that's what I do. My little issue here is not in Visual Studio, it is
> when I try to connect to report server with MS SQL Server management
> studio,
> on my test server that I have, everything on one box, it is connecting but
> with my prod it doesn't. My prod is different, the Reporting is installed
> on
> a web server with the database on another server.
> Regards, Joel :)
> "Bruce L-C [MVP]" wrote:
>> Have you specified the path to deploy to? Right mouse click on the
>> project
>> in BI Studio/VS. You need to set the target server URL to something like
>> this:
>> http://yourserver/ReportServer
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Joel" <Joel@.discussions.microsoft.com> wrote in message
>> news:BD19004F-06AF-48FD-8592-2B8AB74A2BF0@.microsoft.com...
>> > Thanks Guys, when we are with the browser on Reports Server, they can
>> > deploy
>> > and access it, I made a special role for them, but with management
>> > studio
>> > we
>> > cannot connect to it at all.
>> >
>> > Joel:)
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> Whoa! To deploy a report to RS does not need sysadmin rights. There is
>> >> no
>> >> way that developers should have sysadmin rights on SQL server. RS does
>> >> everything based on its roles.
>> >>
>> >> The local administrators role on the server (server not SQL Server)
>> >> automatically puts all users in that role with the rights to do
>> >> anything
>> >> (subscriptions, deploy reports etc) to Reporting Services. However,
>> >> individual users or groups can be added to roles.
>> >>
>> >> In Report Manager, be at Home. Click on the Properties tab, Click New
>> >> Role
>> >> Assignments. Try Content Manager or Publisher. One of those roles will
>> >> work.
>> >>
>> >> All other folders inherit from home.
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >>
>> >>
>> >> "Alain Quesnel" <alainsansspam@.logiquel.com> wrote in message
>> >> news:uAqaWJKHIHA.4228@.TK2MSFTNGP02.phx.gbl...
>> >> > Did you check SQL Server Configuration Manager to see if the
>> >> > Reporting
>> >> > Services service is started? It could also be a rights issue. Do you
>> >> > have
>> >> > sysadmin rights on your MSSQL server?
>> >> >
>> >> > --
>> >> >
>> >> > Alain Quesnel
>> >> > alainsansspam@.logiquel.com
>> >> >
>> >> > www.logiquel.com
>> >> >
>> >> >
>> >> > "Joel" <Joel@.discussions.microsoft.com> wrote in message
>> >> > news:598AD496-F255-4AB9-9DFD-DEE860D45F6F@.microsoft.com...
>> >> >> Bonjour!
>> >> >>
>> >> >> I can't have access with my management studio to Reporting services
>> >> >> (2005)installed on my web server. (Cannot connect to...)Do my
>> >> >> developpers
>> >> >> needs special rights?
>> >> >>
>> >> >> Regards, Joel :)
>> >> >
>> >>
>> >>
>> >>
>>|||Thanks, that's what I will do.
Regards, Joel :)
"Bruce L-C [MVP]" wrote:
> I'm sorry. You asked about the developers so I immediately thought the issue
> was not being able to deploy. Hence the thrust of all my posts. I never use
> Management studio for anything with RS. I pulled it up just to see what it
> offers and it does very little. It shows you some things but Report Manager
> can easily do everything and more than what you can do with Management
> Studio.
> The other poster mentioned sysadmin rights on SQL Server. I don't think this
> is necessary because when I look at what information is provided and changes
> allowed, it is all straight Reporting Services. If you want developers to be
> doing this (adding roles for instance) then have them either be in the local
> administrators account on the server that is hosting Reporting Services or
> add their account to the System Administrator role.
> I suggest first making sure the developers can do what they need to do with
> Report Manager.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Joel" <Joel@.discussions.microsoft.com> wrote in message
> news:AA154A4E-229A-4F8D-BCBA-8AC2391496A5@.microsoft.com...
> > Yes that's what I do. My little issue here is not in Visual Studio, it is
> > when I try to connect to report server with MS SQL Server management
> > studio,
> > on my test server that I have, everything on one box, it is connecting but
> > with my prod it doesn't. My prod is different, the Reporting is installed
> > on
> > a web server with the database on another server.
> >
> > Regards, Joel :)
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Have you specified the path to deploy to? Right mouse click on the
> >> project
> >> in BI Studio/VS. You need to set the target server URL to something like
> >> this:
> >> http://yourserver/ReportServer
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Joel" <Joel@.discussions.microsoft.com> wrote in message
> >> news:BD19004F-06AF-48FD-8592-2B8AB74A2BF0@.microsoft.com...
> >> > Thanks Guys, when we are with the browser on Reports Server, they can
> >> > deploy
> >> > and access it, I made a special role for them, but with management
> >> > studio
> >> > we
> >> > cannot connect to it at all.
> >> >
> >> > Joel:)
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> Whoa! To deploy a report to RS does not need sysadmin rights. There is
> >> >> no
> >> >> way that developers should have sysadmin rights on SQL server. RS does
> >> >> everything based on its roles.
> >> >>
> >> >> The local administrators role on the server (server not SQL Server)
> >> >> automatically puts all users in that role with the rights to do
> >> >> anything
> >> >> (subscriptions, deploy reports etc) to Reporting Services. However,
> >> >> individual users or groups can be added to roles.
> >> >>
> >> >> In Report Manager, be at Home. Click on the Properties tab, Click New
> >> >> Role
> >> >> Assignments. Try Content Manager or Publisher. One of those roles will
> >> >> work.
> >> >>
> >> >> All other folders inherit from home.
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >>
> >> >>
> >> >> "Alain Quesnel" <alainsansspam@.logiquel.com> wrote in message
> >> >> news:uAqaWJKHIHA.4228@.TK2MSFTNGP02.phx.gbl...
> >> >> > Did you check SQL Server Configuration Manager to see if the
> >> >> > Reporting
> >> >> > Services service is started? It could also be a rights issue. Do you
> >> >> > have
> >> >> > sysadmin rights on your MSSQL server?
> >> >> >
> >> >> > --
> >> >> >
> >> >> > Alain Quesnel
> >> >> > alainsansspam@.logiquel.com
> >> >> >
> >> >> > www.logiquel.com
> >> >> >
> >> >> >
> >> >> > "Joel" <Joel@.discussions.microsoft.com> wrote in message
> >> >> > news:598AD496-F255-4AB9-9DFD-DEE860D45F6F@.microsoft.com...
> >> >> >> Bonjour!
> >> >> >>
> >> >> >> I can't have access with my management studio to Reporting services
> >> >> >> (2005)installed on my web server. (Cannot connect to...)Do my
> >> >> >> developpers
> >> >> >> needs special rights?
> >> >> >>
> >> >> >> Regards, Joel :)
> >> >> >
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||I agree that developers shoudn't have sa rights. I just wanted to know if he
could access SSRS through Management Studio with such rights. I've had a
similar issue that had to do with renaming a machine that hosts SSRS. I
still can't make the SSRS webserver work with a new machine name.
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:O1BeNPKHIHA.4228@.TK2MSFTNGP02.phx.gbl...
> Whoa! To deploy a report to RS does not need sysadmin rights. There is no
> way that developers should have sysadmin rights on SQL server. RS does
> everything based on its roles.
> The local administrators role on the server (server not SQL Server)
> automatically puts all users in that role with the rights to do anything
> (subscriptions, deploy reports etc) to Reporting Services. However,
> individual users or groups can be added to roles.
> In Report Manager, be at Home. Click on the Properties tab, Click New Role
> Assignments. Try Content Manager or Publisher. One of those roles will
> work.
> All other folders inherit from home.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Alain Quesnel" <alainsansspam@.logiquel.com> wrote in message
> news:uAqaWJKHIHA.4228@.TK2MSFTNGP02.phx.gbl...
>> Did you check SQL Server Configuration Manager to see if the Reporting
>> Services service is started? It could also be a rights issue. Do you have
>> sysadmin rights on your MSSQL server?
>> --
>> Alain Quesnel
>> alainsansspam@.logiquel.com
>> www.logiquel.com
>>
>> "Joel" <Joel@.discussions.microsoft.com> wrote in message
>> news:598AD496-F255-4AB9-9DFD-DEE860D45F6F@.microsoft.com...
>> Bonjour!
>> I can't have access with my management studio to Reporting services
>> (2005)installed on my web server. (Cannot connect to...)Do my
>> developpers
>> needs special rights?
>> Regards, Joel :)
>|||Accessing Reporting Services through SQL Server Management Studio DOES have
some good uses.
Mainly, you can organise reports much easier than in Report Manager, you can
also create the rdl from the report.
Having said that, I live with out it because I nearly always hit connection
problems on different sites and I'm not sure of the correct way to set it up.
Anyone got an idiots guide to setting the security up so that this facility
can be done. I have full administrator rights.
Thanks
Chris McGuigan
"Alain Quesnel" wrote:
> I agree that developers shoudn't have sa rights. I just wanted to know if he
> could access SSRS through Management Studio with such rights. I've had a
> similar issue that had to do with renaming a machine that hosts SSRS. I
> still can't make the SSRS webserver work with a new machine name.
>
> --
> Alain Quesnel
> alainsansspam@.logiquel.com
> www.logiquel.com
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:O1BeNPKHIHA.4228@.TK2MSFTNGP02.phx.gbl...
> > Whoa! To deploy a report to RS does not need sysadmin rights. There is no
> > way that developers should have sysadmin rights on SQL server. RS does
> > everything based on its roles.
> >
> > The local administrators role on the server (server not SQL Server)
> > automatically puts all users in that role with the rights to do anything
> > (subscriptions, deploy reports etc) to Reporting Services. However,
> > individual users or groups can be added to roles.
> >
> > In Report Manager, be at Home. Click on the Properties tab, Click New Role
> > Assignments. Try Content Manager or Publisher. One of those roles will
> > work.
> >
> > All other folders inherit from home.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> >
> > "Alain Quesnel" <alainsansspam@.logiquel.com> wrote in message
> > news:uAqaWJKHIHA.4228@.TK2MSFTNGP02.phx.gbl...
> >> Did you check SQL Server Configuration Manager to see if the Reporting
> >> Services service is started? It could also be a rights issue. Do you have
> >> sysadmin rights on your MSSQL server?
> >>
> >> --
> >>
> >> Alain Quesnel
> >> alainsansspam@.logiquel.com
> >>
> >> www.logiquel.com
> >>
> >>
> >> "Joel" <Joel@.discussions.microsoft.com> wrote in message
> >> news:598AD496-F255-4AB9-9DFD-DEE860D45F6F@.microsoft.com...
> >> Bonjour!
> >>
> >> I can't have access with my management studio to Reporting services
> >> (2005)installed on my web server. (Cannot connect to...)Do my
> >> developpers
> >> needs special rights?
> >>
> >> Regards, Joel :)
> >>
> >
> >
>sql

Can't access from internet ?

Moreno,
Reporting Services will work overt the web. Here's what I have done to
enable this to work: -
1. Installed Reporting Services on a Server inside the DMZ.
2. Set up a rule on the external DMZ firewall (ISA Server) to pass
through all requests for www.mydomain.com to the server with Reporting
Services installed on it (making sure that it's also passing through
all HTTP Headers).
3. Mapped the Site on the Reporting Services server to listen to
www.mydomain.com requests.
I then set up Forms Authentication using this sample: -
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/ufairs.asp
Does this help?
Thanks,
Phil Winstanley
Microsoft ASP.NET MVP
http://www.myservicescentral.comThank you for your response, Phil.
Points 1 and 2 are OK.
I don't know exactly how to modify configuration files to make Report Server
listen to new URL requests.
( I've tried a lot of combinations without success )
I've also configured Reporting services to work with SSL. May this causes
some additional problems ?
"Phil Winstanley [Microsoft MVP ASP.NET]" <phil@.winstanley.name> ha scritto
nel messaggio news:cbmejv$4mt@.odak26.prod.google.com...
> Moreno,
> Reporting Services will work overt the web. Here's what I have done to
> enable this to work: -
> 1. Installed Reporting Services on a Server inside the DMZ.
> 2. Set up a rule on the external DMZ firewall (ISA Server) to pass
> through all requests for www.mydomain.com to the server with Reporting
> Services installed on it (making sure that it's also passing through
> all HTTP Headers).
> 3. Mapped the Site on the Reporting Services server to listen to
> www.mydomain.com requests.
> I then set up Forms Authentication using this sample: -
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/ufairs.asp
> Does this help?
> Thanks,
> Phil Winstanley
> Microsoft ASP.NET MVP
> http://www.myservicescentral.com
>

Monday, March 19, 2012

cant "get at" 2005 express

Have Visual Web Developer ; came with 2005 SS Express - problem is there is
no way to create a database, much less stock it with test data; nothing like
a Server Enterprise Manager seems to have installed, and MS Access projects
wizards don't connect to it either -
(BTW: VWD seems very well designed - nice job MS)SQL Server Management Studio Express
http://www.microsoft.com/downloads/...&displaylang=en
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"barret bonden" <arthur@.networks-cc.com> wrote in message
news:rA%lf.4994$O05.3086@.fe09.lga...
> Have Visual Web Developer ; came with 2005 SS Express - problem is there
> is
> no way to create a database, much less stock it with test data; nothing
> like
> a Server Enterprise Manager seems to have installed, and MS Access
> projects
> wizards don't connect to it either -
> (BTW: VWD seems very well designed - nice job MS)
>|||Many thanks
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:eUnv#cD$FHA.2524@.TK2MSFTNGP10.phx.gbl...
> SQL Server Management Studio Express
>
http://www.microsoft.com/downloads/...bd59-57a4-455e-
a2d6-1d4c98d40f6e&displaylang=en
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "barret bonden" <arthur@.networks-cc.com> wrote in message
> news:rA%lf.4994$O05.3086@.fe09.lga...
>

cant "get at" 2005 express

Have Visual Web Developer ; came with 2005 SS Express - problem is there is
no way to create a database, much less stock it with test data; nothing like
a Server Enterprise Manager seems to have installed, and MS Access projects
wizards don't connect to it either -
(BTW: VWD seems very well designed - nice job MS)
SQL Server Management Studio Express
http://www.microsoft.com/downloads/d...displaylang=en
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"barret bonden" <arthur@.networks-cc.com> wrote in message
news:rA%lf.4994$O05.3086@.fe09.lga...
> Have Visual Web Developer ; came with 2005 SS Express - problem is there
> is
> no way to create a database, much less stock it with test data; nothing
> like
> a Server Enterprise Manager seems to have installed, and MS Access
> projects
> wizards don't connect to it either -
> (BTW: VWD seems very well designed - nice job MS)
>
|||Many thanks
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:eUnv#cD$FHA.2524@.TK2MSFTNGP10.phx.gbl...
> SQL Server Management Studio Express
>
http://www.microsoft.com/downloads/d...d59-57a4-455e-
a2d6-1d4c98d40f6e&displaylang=en
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "barret bonden" <arthur@.networks-cc.com> wrote in message
> news:rA%lf.4994$O05.3086@.fe09.lga...
>

Cannot View Reports in Report Manager

Alrighty... This has been a bugger of a pain all day.
We have Enterprise RS on our test server - only the web part. The databases are located on the test sql server, and both servers are more than happy to talk to each other just fine. On the webserver where report manager is, we have tossed the default website and relocated the virtual directories to a different website, which is accesible over the network via an ip address. I can get into the report manager just fine.
Here's the problem: when I click on a report in the report manager, I cannot view the report. Initially the problem was that it would give a 403 access forbidden message, which doesn't make sense since the user was a content manager and full rights were available across the board. Now after several hours of playing it gives an action cancelled, cannot link to the requested webpage error. It gives it on any report, but I can access the report properties just fine. I can get into data sources just fine as well.
Upon reading something in here, I've tried editing the RSWebApplication.config file to change the
<ReportServerUrl>http://TestWWW/ReportServer</ReportServerUrl>
value to
<ReportServerUrl>http://10.1.1.74/ReportServer</ReportServerUrl>
which is the address of the site it should be located at. When I do that and save it, it get's kinda interesting - when I try to view any report, I get a directory listing (with it enabled for the directory) of 10.1.1.74 - /ReportServer/. Then when I click any of the directories, it takes me to 10.1.1.74/ReportServer/ - (note the change in hyphens) which displays all the uploaded files on the report server. If I click on a report, it displays the report!
What the heck is going on? Anyone seen this and fixed it?
- TCorrection: when I said it displayed the report, I spoke too soon. It brings up the window with the standard report bars, but hangs with the green spinning generation graphic.

Sunday, March 11, 2012

cannot view

Thought I edited a previous post but apparently not. The cannot view problem is with a png file inserted on a start page of a web site. Other Gif and Jpeg files are viewable with IE and Mozilla but not the png file.

Your post is marked as a question but there is no question in it. How can we help?

Thanks
Laurentiu

|||Sorry for the confusion as I am a new user to these boards and didn't get the post in place as I intended. We've placed some banner ads from sponsors on our web site and I cannot view them with IE. The ones that are there in either Gif or Jpeg are viewable but we have one in png and I cannot see it. This same banner is on another site in Germany and I cannot view that one either. I've also tried other browsers such as Mozilla and get the same results. I'm of the opinion there is a setting in XP or my Norton 2005 program that may be causing the problem but so far have not been able to find it. Any help would be greatly appreciated.|||

I'd like to help but I don't know the answer to your question - this is a SQL Server newsgroup focused on security. Someone may know the answer to this, but it's a safer bet to post to an appropriate newsgroup.
To venture a guess, you may need to convert the image to a supported format or you may need to upgrade your IE browser.

For figuring out why IE does not display the PNG banner, you should check the IE newsgroups from the link below:

http://www.microsoft.com/windows/ie/support/newsgroups/default.mspx

Search for threads that discuss PNG issues and if you don't find an answer to your question on those newsgroups, then I suggest that you post your question again there.

Thanks
Laurentiu

|||thank you for your help in guiding me to the correct board to post my question.

Tim

Thursday, March 8, 2012

Cannot upload file to database

Can anyone correct my code?
I will like to add a url to my database and upload my image to web server.
txtAddTitle will become my title name
txtFileName allow user to type in image name that will upload to webserver and at the meantime will insert into database as url references
value for @.chapterid will get from drop down list(ddlLesson) and the index value will store in database.

now i am able to upload my images with the file name that i have given to web server, but I am unable to insert data to my database.

Sub DoUpload(ByVal Sender As Object, ByVal e As System.EventArgs)
Dim sPath As String
Dim sFile As String
Dim sFullPath As String
Dim sSplit() As String
Dim sPathFriendly As String


'Upload to same path as script. Internet Anonymous User must have write permissions
sPath = Server.MapPath("../Tutorial")
'sPath = Server.MapPath(".")
If Right(sPath, 1) <> "\" Then
sPathFriendly = sPath 'Friendly path name for display
sPath = sPath & "\"
Else
sPathFriendly = Left(sPath, Len(sPath) - 1)
End If


'Save as same file name being posted
'The code below resolves the file name
'(removes path info)
sFile = txtFileName.Text
'sFile = txtUpload.PostedFile.FileName
sSplit = Split(sFile, "\")
sFile = sSplit(UBound(sSplit))


sFullPath = sPath & sFile
Try
txtUpload.PostedFile.SaveAs(sFullPath)
lblResults.Text = "<br>Upload of File " & sFile & " to " & sPathFriendly & " succeeded"

Catch Ex As Exception

lblResults.Text = "<br>Upload of File " & sFile & " to " & sPathFriendly & " failed for the following reason: " & Ex.Message
Finally
lblResults.Font.Bold = True
lblResults.Visible = True
End Try

Dim mycommand As SqlCommand
Dim myConnection As SqlConnection
Message.InnerHtml = ""
'to all the valur to database
If IsValid Then

myConnection = New SqlConnection("Server=localhost;UID=sa;pwd=;database=u")
mycommand = New SqlCommand("INSERT INTO t_linkTitle(link_chapterid,link_name,link_url) VALUES (@.chapterid,@.titleName,@.titleUrl)", myConnection)

mycommand.Parameters.Add("@.chapterid", SqlDbType.VarChar, 50).Value = ddlLesson.SelectedItem.Value
mycommand.Parameters.Add("@.titleName", SqlDbType.VarChar, 50).Value = txtAddTitle.Text
mycommand.Parameters.Add("@.titleUrl", SqlDbType.VarChar, 100).Value = txtFileName.Text

mycommand.Connection.Open()
msgErrorTitle.Style("color") = "OrangeRed"
Try
mycommand.ExecuteNonQuery()
msgErrorTitle.InnerHtml = "New title <b>" + txtAddTitle.Text + "</b> Added to " + "<b>" + ddlLesson.SelectedItem.Text + "</b><br>" + mycommand.ToString()
Catch Exp As SqlException

If Exp.Number = 2627 Then
msgErrorTitle.InnerHtml = "ERROR: Title already exists. Please use another title"
Else
msgErrorTitle.InnerHtml = "ERROR: Could not add record, please ensure the fields are correctly filled out"
End If

End Try

mycommand.Connection.Close()
End If

LoadTitle()

End Sub

So what sql server error number are you getting when you attempt an insert?|||

emulti wrote:

So what sql server error number are you getting when you attempt an insert?

It show this"ERROR: Could not add record, please ensure the fields are correctly filled out"

Wednesday, March 7, 2012

Cannot subscribe report

Has anybody experienced this strange problem? I can create a e-mail
subscription in Management Studio. However, when I am in web based
subscription, type in the entries and click "OK", the next screen asks me to
"specify options for report delivery" again. No matter what I choose ("Report
Server E-mail" or "Report Server File Share"), it prompt back to the same
screen.
Any tip or help is very much appreciated.Hello Jason,
I would like to know have you applied SP1 on your reporting services?
Also, if you created a subscription in the Management Studio and then try
to modify the subscription in the web site, do you still get this issue?
And if you tested on other client, does this issue still occur?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||yes, I did apply sp1. and yes, I get the same issue when I try to modify the
subscription. I tested on both my machine (xp) and the server itself, same
thing happens. Thank you for any troubleshooting clues.
"Wei Lu [MSFT]" wrote:
> Hello Jason,
> I would like to know have you applied SP1 on your reporting services?
> Also, if you created a subscription in the Management Studio and then try
> to modify the subscription in the web site, do you still get this issue?
> And if you tested on other client, does this issue still occur?
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||Hello Jason,
Have you seen any error message in the Report Log?
By default, the log file is located at \Microsoft SQL Server\<SQL Server
Instance>\Reporting Services\LogFiles.
Please check and let me know are there any related error in the log.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Thank you for the help. I checked the WebApp log, the following looks
suspicious:
w3wp!extensionfactory!5!11/14/2006-08:09:31:: w WARN: The extension Report
Server Email does not have a LocalizedNameAttribute.
w3wp!extensionfactory!5!11/14/2006-08:09:31:: w WARN: The extension Report
Server FileShare does not have a LocalizedNameAttribute.
w3wp!extensionfactory!6!11/14/2006-08:09:34:: w WARN: The extension Report
Server Email does not have a LocalizedNameAttribute.
w3wp!extensionfactory!6!11/14/2006-08:09:34:: w WARN: The extension Report
Server FileShare does not have a LocalizedNameAttribute.
w3wp!extensionfactory!5!11/14/2006-08:09:37:: w WARN: The extension Report
Server Email does not have a LocalizedNameAttribute.
w3wp!extensionfactory!5!11/14/2006-08:09:37:: w WARN: The extension Report
Server FileShare does not have a LocalizedNameAttribute.
w3wp!extensionfactory!1!11/14/2006-08:09:39:: w WARN: The extension Report
Server Email does not have a LocalizedNameAttribute.
w3wp!extensionfactory!1!11/14/2006-08:09:39:: w WARN: The extension Report
Server FileShare does not have a LocalizedNameAttribute.
No idea what does the above mean.
"Wei Lu [MSFT]" wrote:
> Hello Jason,
> Have you seen any error message in the Report Log?
> By default, the log file is located at \Microsoft SQL Server\<SQL Server
> Instance>\Reporting Services\LogFiles.
> Please check and let me know are there any related error in the log.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Actually, the report subscription is working and the email is delivered after
I set it up in Management Studio. My problem is I can not use Management
Studio to set up other reports which requires parameters. If I understand
right, those reports subscription has to be done through report server web
interface. That is why I am having the problem. Please help.
"Wei Lu [MSFT]" wrote:
> Hello Jason,
> Have you seen any error message in the Report Log?
> By default, the log file is located at \Microsoft SQL Server\<SQL Server
> Instance>\Reporting Services\LogFiles.
> Please check and let me know are there any related error in the log.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hello Jason,
I would like to get all the Report Error log.
Also, please check your rsReportServer.config file and make sure the smtp
server name is correct.
You may zip the folder and send to me directly. I understand the
information may be sensitive to you, my direct email address is
weilu@.ONLINE.microsoft.com ( Please remove ONLINE when you send the email
), you may send the file to me directly and I will keep it secure..
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Cannot start your application. The workgroup information file is missing or opened exclusively b

hye everyone,
when i browse my web application the eror as below display..
what should i do..
any suggestion or tips...

"Cannot start your application. The workgroup information file is missing or opened exclusively by another user.

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.Data.OleDb.OleDbException: Cannot start your application. The workgroup information file is missing or opened exclusively by another user. "

thanks in advance..
thank you very much..

That is not a SQL Server problem as you aure using obviously MS Access, you better post your question to one of the Access forums in the public newgroup network. But, as far as I can remember from my old Access days, you will have to delete the lock file which is located in the same folder as the workgroup file which contains the security informa′tion.

Jens K. Suessmeyer

http://www.sqlserver2005.de

Sunday, February 19, 2012

Cannot setup SQL Server 2000 on W2003 Server

I have installed Windows Server 2003 Web Edition from scratch on a new system disk. I have updated with the latest service pack and security upgrades.

When I try to install SQL Server 2000 Standard Edition, the initial setup dialog Autoruns OK. I click on "SQL Server 2000 components", then on "Install Database Server". For a second or so a "Demoshield" pop-up appears, but that vanishes and nothing else happens.

Can anyone suggest what might be wrong? I am running on P4 1.7Ghz but only have 128Meg memory until the new chips arrive. I have around 15Gig disk space free on the drive I want to install on.

Thanks

Looks like this is not a supported configuration.

http://support.microsoft.com/default.aspx?scid=kb;en-us;819258

Tuesday, February 14, 2012

Cannot see data in database table

Hi all,

I am having a problem viewing data in a database table.

The data is entered into the database with a web service and it runs without problems. However, when I open the table with the management tool, I cannot see the data I just sent to it.

Also, when I try adding data directly to the table, the id column shows that there is data in the table. That is lets say the id for the 1st item is "1", after sending 4 records to the database with the webservice, when I try to enter data in the table directly, the next available key is 5. This indicates that there is some data in the table that I cannot see.

Does anyone know how I can reslove this?

Thanks!


Hi,
perhaps the transactions has beend rolled back again, or the data was deleted by another rpocedure / database call again. To find out what wiped out the data from the database, run the profiler, tracing all action concerned to your database.

HTH; Jens K. Suessmeyer.

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

Hi Hugo,

Is this in a productiong system? When working in debug it is common for data to disappear because of a fluke in how VS works. Check out the FAQ at the top of this forum. Just the fact that the id is 5 doesn't mean that other records exist in the table. As Jens points out, if the record was created, but then rolled back, the id value has been burned already and won't be reused.

How are you trying to view the data?

Mike

Cannot see data in database table

Hi all,

I am having a problem viewing data in a database table.

The data is entered into the database with a web service and it runs without problems. However, when I open the table with the management tool, I cannot see the data I just sent to it.

Also, when I try adding data directly to the table, the id column shows that there is data in the table. That is lets say the id for the 1st item is "1", after sending 4 records to the database with the webservice, when I try to enter data in the table directly, the next available key is 5. This indicates that there is some data in the table that I cannot see.

Does anyone know how I can reslove this?

Thanks!


Hi,
perhaps the transactions has beend rolled back again, or the data was deleted by another rpocedure / database call again. To find out what wiped out the data from the database, run the profiler, tracing all action concerned to your database.

HTH; Jens K. Suessmeyer.

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

Hi Hugo,

Is this in a productiong system? When working in debug it is common for data to disappear because of a fluke in how VS works. Check out the FAQ at the top of this forum. Just the fact that the id is 5 doesn't mean that other records exist in the table. As Jens points out, if the record was created, but then rolled back, the id value has been burned already and won't be reused.

How are you trying to view the data?

Mike

Sunday, February 12, 2012

Cannot run apparently successful installation of SQL Server Express

I am completely new to SQL Server, and have downloaded and installed Visual Web Developer and Visual Basic Express without problems
I have downloaded SQL Server Express and cannot figure how to start it up! SQL Server Management Studio Express CTP does nothing when I try to run it.

No doubt this is a very simple error or series of errors by me, but I would appreciate help.

Many thanks.

Nick

I am assuming you are installed it with default value, where express would be installed as instance sqlexpress.

1. Did you see express in Obj Explorer of MS Express ("<machine-name>\SQLEXPRESS") ? If so you could just right click on that node -> Start.

2. Alternatively, try to start it from command line by:

net start mssql$sqlexpress

|||Many thanks for your help Hungfu. I am trying your solutions which report back that SQLSever Express is running. I suspect my remaining problems are related to the CTP version!
Regards
Nick

Cannot run apparently successful installation of SQL Server Express

I am completely new to SQL Server, and have downloaded and installed Visual Web Developer and Visual Basic Express without problems
I have downloaded SQL Server Express and cannot figure how to start it up! SQL Server Management Studio Express CTP does nothing when I try to run it.

No doubt this is a very simple error or series of errors by me, but I would appreciate help.

Many thanks.

Nick

I am assuming you are installed it with default value, where express would be installed as instance sqlexpress.

1. Did you see express in Obj Explorer of MS Express ("<machine-name>\SQLEXPRESS") ? If so you could just right click on that node -> Start.

2. Alternatively, try to start it from command line by:

net start mssql$sqlexpress

|||Many thanks for your help Hungfu. I am trying your solutions which report back that SQLSever Express is running. I suspect my remaining problems are related to the CTP version!
Regards
Nick

Cannot restore db

I'm trying to restore a Db from my web site back to my local machine.

Whichever way try, I get an error message saying

RESTORE detected an error on page (0:0)in database "new databasename"

> as read from the backup

Can anyone tell me what the error might be?

Many thanks

post back the restore database statement you used... also check the backup set .... if it is sql server 2005 use verify only option to verify the backup set... i doubt its corrupted.

Madhu

|||

Madhu,

I'm a newbie to SQL...

The backup was created by my web host - I have no control over how it is was created.

My database is SQL 2005 Express and I am trying to restore using SQL Server Management Studio Express - I do not see how to use "verfiy" using this tool.

Please can you give me some more guidance?

Many thanks for your help so far.

Cannot restore db

I'm trying to restore a Db from my web site back to my local machine.

Whichever way try, I get an error message saying

RESTORE detected an error on page (0:0)in database "new databasename"

> as read from the backup

Can anyone tell me what the error might be?

Many thanks

post back the restore database statement you used... also check the backup set .... if it is sql server 2005 use verify only option to verify the backup set... i doubt its corrupted.

Madhu

|||

Madhu,

I'm a newbie to SQL...

The backup was created by my web host - I have no control over how it is was created.

My database is SQL 2005 Express and I am trying to restore using SQL Server Management Studio Express - I do not see how to use "verfiy" using this tool.

Please can you give me some more guidance?

Many thanks for your help so far.