cant start sql 2000 on port 1433

for some reason i dont get any errors, but i believe that my server is
not running on port 1433. the tcpip protocol is selected in the
network configuration utility as well as name piper. the port
selected is 1433. but when i telnet to 1433 i get the same errors as i
would if i telnet to a non existant port. i also tried nbstat with no
luck. what else can i do? thanks"Joseph" <jcharth@.hotmail.com> wrote in message
news:2f2b8b0b.0407100759.56318482@.posting.google.c om...
> for some reason i dont get any errors, but i believe that my server is
> not running on port 1433. the tcpip protocol is selected in the
> network configuration utility as well as name piper. the port
> selected is 1433. but when i telnet to 1433 i get the same errors as i
> would if i telnet to a non existant port. i also tried nbstat with no
> luck. what else can i do? thanks

Are you using MSDE, by any chance? Network access is disabled by default
from SP3 onwards:

http://support.microsoft.com/default.aspx?kbid=814130

If that doesn't help, then this article covers other possibilities:

http://support.microsoft.com/defaul...306&Product=sql

Simon|||thanks i found the problem i had to install it in another computer that had sp3

Cant start MSSQL 2005 after DCPROMO

I have a 2003 sta server which has a MSSQL on it.

after running dcpromo on that server (secondary DC) the sql service is not running.

i get errors 17204/17207

any ideas?

DCPromo will disable / delete some of the local administrator accounts, if you have configured them as startup accounts, the service wont find them and therefore cannot start.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

So is there any thing i can do?

|||

Yes,

change the startup accounts for the service to priviledged domain accounts and restart your Services. This should solve your problem.

Jens K. Suessmeyer

http://www.sqlserver2005.de

Can't start 2005 Report Services on XP SP2

Hej,
I am attempting to get a test environment up and running on my XP SP2
machine but I can't start reporting services. I found the following log in
the Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles directory:
ReportingServicesService!servicecontroller!4!28-03-2006-09:27:22:: e ERROR:
Exception caught starting RPC server:
Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException:
The user or group name 'ANEISHA\ASPNET' is not recognized.
at Microsoft.ReportingServices.Library.Native.NameToSid(String name)
at
Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer(Boolean
firstTime)
Anybody have any clues?
Thanks in advance,
Antony C. Roberts.In desperation, I created an ASPNET user and gave it all possible roles.
That solved the problem... What is the CORRECT solution to this problem?
Thanks!
/Ant.
"Antony C. Roberts" <acr@.no.way.com> wrote in message
news:ONFgYrjUGHA.1444@.TK2MSFTNGP11.phx.gbl...
> Hej,
> I am attempting to get a test environment up and running on my XP SP2
> machine but I can't start reporting services. I found the following log in
> the Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles directory:
> ReportingServicesService!servicecontroller!4!28-03-2006-09:27:22:: e
> ERROR: Exception caught starting RPC server:
> Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException:
> The user or group name 'ANEISHA\ASPNET' is not recognized.
> at Microsoft.ReportingServices.Library.Native.NameToSid(String name)
> at
> Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer(Boolean
> firstTime)
> Anybody have any clues?
> Thanks in advance,
> Antony C. Roberts.
>

Can't shrink a database

Hi there,
I am running SQL2005 SP1 Standard.
I have a database that was originally a SQL2K db that was rolled up to 2K5.
Everything was fine with it until I truncated a few tables and dropped a
large column & index on a few tables. Since then the following symptoms are
present:
1) The size of the datafile and log file are about 2.5x the size of the
actual data
2) The DB properties ALWAYS shows "Space Available" as "0.00 MB"
3) The shrink dialog with the file type set to "Log" shows avaialble free
space to be 98% but shrinking it does not release any of the free space.
I have tried backing up the database, deleting it and restoring it but the
inflated log file still exists. I've also tried creating a new blank DB
(versus letting the restore create it) and restoring into that but the
problem persists.
Does anyone have any ideas on how to shrink this database down?
Thanks,
--
-Steven1) Is it the data or the log file which is "too big"?
2) Read about DBCC UPDATEUSAGE
3) See http://www.karaszi.com/SQLServer/info_dont_shrink.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Steven Berkovitz" <mbcdev@.community.nospam> wrote in message
news:F4B6BA40-9143-4D52-BC8F-3FB9CFBEB133@.microsoft.com...
> Hi there,
> I am running SQL2005 SP1 Standard.
> I have a database that was originally a SQL2K db that was rolled up to 2K5.
> Everything was fine with it until I truncated a few tables and dropped a
> large column & index on a few tables. Since then the following symptoms are
> present:
> 1) The size of the datafile and log file are about 2.5x the size of the
> actual data
> 2) The DB properties ALWAYS shows "Space Available" as "0.00 MB"
> 3) The shrink dialog with the file type set to "Log" shows avaialble free
> space to be 98% but shrinking it does not release any of the free space.
> I have tried backing up the database, deleting it and restoring it but the
> inflated log file still exists. I've also tried creating a new blank DB
> (versus letting the restore create it) and restoring into that but the
> problem persists.
> Does anyone have any ideas on how to shrink this database down?
> Thanks,
> --
> -Steven|||Hi Steven,
I would like to know the issue status and whether or not you need further
research.
You can try setting the recovery mode to simple, backing up your database
completely, truncating the log with BACKUP LOG ... WITH TRUNCATE ONLY, and
then use DBCC SHRINKFILE to shrink the log file.
Have a great day!
Charles Wang
Microsoft Online Community Support

Can't shrink a database

Hi there,
I am running SQL2005 SP1 Standard.
I have a database that was originally a SQL2K db that was rolled up to 2K5.
Everything was fine with it until I truncated a few tables and dropped a
large column & index on a few tables. Since then the following symptoms are
present:
1) The size of the datafile and log file are about 2.5x the size of the
actual data
2) The DB properties ALWAYS shows "Space Available" as "0.00 MB"
3) The shrink dialog with the file type set to "Log" shows avaialble free
space to be 98% but shrinking it does not release any of the free space.
I have tried backing up the database, deleting it and restoring it but the
inflated log file still exists. I've also tried creating a new blank DB
(versus letting the restore create it) and restoring into that but the
problem persists.
Does anyone have any ideas on how to shrink this database down?
Thanks,
--
-Steven1) Is it the data or the log file which is "too big"?
2) Read about DBCC UPDATEUSAGE
3) See http://www.karaszi.com/SQLServer/info_dont_shrink.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Steven Berkovitz" <mbcdev@.community.nospam> wrote in message
news:F4B6BA40-9143-4D52-BC8F-3FB9CFBEB133@.microsoft.com...
> Hi there,
> I am running SQL2005 SP1 Standard.
> I have a database that was originally a SQL2K db that was rolled up to 2K5
.
> Everything was fine with it until I truncated a few tables and dropped a
> large column & index on a few tables. Since then the following symptoms a
re
> present:
> 1) The size of the datafile and log file are about 2.5x the size of the
> actual data
> 2) The DB properties ALWAYS shows "Space Available" as "0.00 MB"
> 3) The shrink dialog with the file type set to "Log" shows avaialble free
> space to be 98% but shrinking it does not release any of the free space.
> I have tried backing up the database, deleting it and restoring it but the
> inflated log file still exists. I've also tried creating a new blank DB
> (versus letting the restore create it) and restoring into that but the
> problem persists.
> Does anyone have any ideas on how to shrink this database down?
> Thanks,
> --
> -Steven|||Hi Steven,
I would like to know the issue status and whether or not you need further
research.
You can try setting the recovery mode to simple, backing up your database
completely, truncating the log with BACKUP LOG ... WITH TRUNCATE ONLY, and
then use DBCC SHRINKFILE to shrink the log file.
Have a great day!
Charles Wang
Microsoft Online Community Supportsql

Can't see reportserver and reports applications

I'm trying to use Reporting Services 2005. The service is running, but if I
type http://192.168.1.49:8888/reportserver I see the directory list.
With http://192.1681.49:8888/reports, I see an error: The request failed
with HTTP status 503: Service Unavailable.The error is in URL.
http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least I know is
inside the application.
I'm completely stuck. What can I do or where can I search?
--
Regards,
Diego F.Google is your friend. Type in "reporting services" 503 "service
unavailable" and you'll get quite a lot of info. Not all of it is directly
connected to Reporting Services, but you should be able to pick up some info
on the 503 problem in general. It seems that there's a problem with the
Reporting Services web service.
Are you allowed to log on to the actual server and try running Report
Manager from that box?
What sort of authentication is set?
Try adding the report server site to your Trusted sites in IE, and then
change the Security Settings for Trusted Sites to "Prompt for user name and
password" in User Authentication - Logon. Type in your username and
password. If it fails, that might be what causes the problem. In that case,
you need to figure out what rights are needed for you to access the reports.
Kaisa M. Lindahl
"Diego F." <diegofrNO@.terra.es> wrote in message
news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
> I'm trying to use Reporting Services 2005. The service is running, but if
> I type http://192.168.1.49:8888/reportserver I see the directory list.
> With http://192.1681.49:8888/reports, I see an error: The request failed
> with HTTP status 503: Service Unavailable.The error is in URL.
> http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least I know is
> inside the application.
> I'm completely stuck. What can I do or where can I search?
> --
> Regards,
> Diego F.
>|||Hi again.
I installed again the whole server: Window 2003 and SQL Server 2005 full.
Now I finally see the reports site :-)
There is a Visual Studio installed with SQL 2005 and I can design reports
there. But now I don't know how to configure the project to deploy
correctly.
I get that error:
A connection could not be made to the report server http://localhost/reports
Additional information:
The attempt to connect to the report server failed. Check your connection
information and the report server is a compatible version.
(Microsoft.ReportingServices.Designer).
If I try with: http://localhost/reportserver then I get a compilation error:
The Report Server Windows Service ReportServer is not running. The service
must be running to use the Report Server.
How can I solve that?
--
Regards,
Diego F.
"Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
news:exkoPudFGHA.3280@.TK2MSFTNGP10.phx.gbl...
> Google is your friend. Type in "reporting services" 503 "service
> unavailable" and you'll get quite a lot of info. Not all of it is directly
> connected to Reporting Services, but you should be able to pick up some
> info on the 503 problem in general. It seems that there's a problem with
> the Reporting Services web service.
> Are you allowed to log on to the actual server and try running Report
> Manager from that box?
> What sort of authentication is set?
> Try adding the report server site to your Trusted sites in IE, and then
> change the Security Settings for Trusted Sites to "Prompt for user name
> and password" in User Authentication - Logon. Type in your username and
> password. If it fails, that might be what causes the problem. In that
> case, you need to figure out what rights are needed for you to access the
> reports.
> Kaisa M. Lindahl
>
> "Diego F." <diegofrNO@.terra.es> wrote in message
> news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
>> I'm trying to use Reporting Services 2005. The service is running, but if
>> I type http://192.168.1.49:8888/reportserver I see the directory list.
>> With http://192.1681.49:8888/reports, I see an error: The request failed
>> with HTTP status 503: Service Unavailable.The error is in URL.
>> http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least I know is
>> inside the application.
>> I'm completely stuck. What can I do or where can I search?
>> --
>> Regards,
>> Diego F.
>|||Open IIS, a.k.a Internet Information Services Manager
Open your Reports site, is probably under Web SItes - Default Web Site.
RIght click and choose Browse. Does it open correctly?
If it does, what is the URL? I did a test install of the 2005 edition, and I
think you might get some extra "name" or something, like
http://localhost/reports$instancename
Which means that the reports are still there, but the URL might have
changed. Or something.
Also, with Sql Server 2005 there's an nice Reporting Services configuration
tool. Start it and look to see if there are any things that needs to be
started.
Kaisa M. Lindahl
"Diego F." <diegofrNO@.terra.es> wrote in message
news:usLfZ8rFGHA.208@.tk2msftngp13.phx.gbl...
> Hi again.
> I installed again the whole server: Window 2003 and SQL Server 2005 full.
> Now I finally see the reports site :-)
> There is a Visual Studio installed with SQL 2005 and I can design reports
> there. But now I don't know how to configure the project to deploy
> correctly.
> I get that error:
> A connection could not be made to the report server
> http://localhost/reports
> Additional information:
> The attempt to connect to the report server failed. Check your
> connection information and the report server is a compatible version.
> (Microsoft.ReportingServices.Designer).
> If I try with: http://localhost/reportserver then I get a compilation
> error:
> The Report Server Windows Service ReportServer is not running. The service
> must be running to use the Report Server.
> How can I solve that?
> --
> Regards,
> Diego F.
>
> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
> news:exkoPudFGHA.3280@.TK2MSFTNGP10.phx.gbl...
>> Google is your friend. Type in "reporting services" 503 "service
>> unavailable" and you'll get quite a lot of info. Not all of it is
>> directly connected to Reporting Services, but you should be able to pick
>> up some info on the 503 problem in general. It seems that there's a
>> problem with the Reporting Services web service.
>> Are you allowed to log on to the actual server and try running Report
>> Manager from that box?
>> What sort of authentication is set?
>> Try adding the report server site to your Trusted sites in IE, and then
>> change the Security Settings for Trusted Sites to "Prompt for user name
>> and password" in User Authentication - Logon. Type in your username and
>> password. If it fails, that might be what causes the problem. In that
>> case, you need to figure out what rights are needed for you to access the
>> reports.
>> Kaisa M. Lindahl
>>
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
>> I'm trying to use Reporting Services 2005. The service is running, but
>> if I type http://192.168.1.49:8888/reportserver I see the directory
>> list.
>> With http://192.1681.49:8888/reports, I see an error: The request failed
>> with HTTP status 503: Service Unavailable.The error is in URL.
>> http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least I know
>> is inside the application.
>> I'm completely stuck. What can I do or where can I search?
>> --
>> Regards,
>> Diego F.
>>
>|||I finally uploaded a report. I made it with Visual Studio 2005 installed by
SQL Server 2005. I made a report and deployed it, and in the Report Manager
shows the new report, but I can't see it because:
- 'The report server cannot process the report. The data source connection
information has been deleted. (rsInvalidDataSourceReference).
I made the connection with the project.
If I'm understanding something, is it the idea to have all the reports in
the server, and the applications should link to that URL to load the report?
Thanks a lot for your help. I really appreciate.
--
Regards,
Diego F.
"Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
news:umHKqBsFGHA.2084@.TK2MSFTNGP09.phx.gbl...
> Open IIS, a.k.a Internet Information Services Manager
> Open your Reports site, is probably under Web SItes - Default Web Site.
> RIght click and choose Browse. Does it open correctly?
> If it does, what is the URL? I did a test install of the 2005 edition, and
> I think you might get some extra "name" or something, like
> http://localhost/reports$instancename
> Which means that the reports are still there, but the URL might have
> changed. Or something.
> Also, with Sql Server 2005 there's an nice Reporting Services
> configuration tool. Start it and look to see if there are any things that
> needs to be started.
> Kaisa M. Lindahl
> "Diego F." <diegofrNO@.terra.es> wrote in message
> news:usLfZ8rFGHA.208@.tk2msftngp13.phx.gbl...
>> Hi again.
>> I installed again the whole server: Window 2003 and SQL Server 2005 full.
>> Now I finally see the reports site :-)
>> There is a Visual Studio installed with SQL 2005 and I can design reports
>> there. But now I don't know how to configure the project to deploy
>> correctly.
>> I get that error:
>> A connection could not be made to the report server
>> http://localhost/reports
>> Additional information:
>> The attempt to connect to the report server failed. Check your
>> connection information and the report server is a compatible version.
>> (Microsoft.ReportingServices.Designer).
>> If I try with: http://localhost/reportserver then I get a compilation
>> error:
>> The Report Server Windows Service ReportServer is not running. The
>> service must be running to use the Report Server.
>> How can I solve that?
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:exkoPudFGHA.3280@.TK2MSFTNGP10.phx.gbl...
>> Google is your friend. Type in "reporting services" 503 "service
>> unavailable" and you'll get quite a lot of info. Not all of it is
>> directly connected to Reporting Services, but you should be able to pick
>> up some info on the 503 problem in general. It seems that there's a
>> problem with the Reporting Services web service.
>> Are you allowed to log on to the actual server and try running Report
>> Manager from that box?
>> What sort of authentication is set?
>> Try adding the report server site to your Trusted sites in IE, and then
>> change the Security Settings for Trusted Sites to "Prompt for user name
>> and password" in User Authentication - Logon. Type in your username and
>> password. If it fails, that might be what causes the problem. In that
>> case, you need to figure out what rights are needed for you to access
>> the reports.
>> Kaisa M. Lindahl
>>
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
>> I'm trying to use Reporting Services 2005. The service is running, but
>> if I type http://192.168.1.49:8888/reportserver I see the directory
>> list.
>> With http://192.1681.49:8888/reports, I see an error: The request
>> failed with HTTP status 503: Service Unavailable.The error is in URL.
>> http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least I know
>> is inside the application.
>> I'm completely stuck. What can I do or where can I search?
>> --
>> Regards,
>> Diego F.
>>
>>
>|||I did the process again and now -don't ask me why- it shows the report.
Then, as I asked you before, is the idea to create all the reports I need
and upload to the server?
My idea is to intergate that in a web application, so I expected to show
just the report by clicking a button. Is that possible?
And last but not least ;-), is it possible to dinamically -by code- generate
the reports temporally? I have all my queries as stored procedures.
Thanks a lot!
--
Regards,
Diego F.
"Diego F." <diegofrNO@.terra.es> escribió en el mensaje
news:OI94mSsFGHA.752@.TK2MSFTNGP12.phx.gbl...
>I finally uploaded a report. I made it with Visual Studio 2005 installed by
>SQL Server 2005. I made a report and deployed it, and in the Report Manager
>shows the new report, but I can't see it because:
> - 'The report server cannot process the report. The data source connection
> information has been deleted. (rsInvalidDataSourceReference).
> I made the connection with the project.
> If I'm understanding something, is it the idea to have all the reports in
> the server, and the applications should link to that URL to load the
> report?
> Thanks a lot for your help. I really appreciate.
> --
> Regards,
> Diego F.
>
> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
> news:umHKqBsFGHA.2084@.TK2MSFTNGP09.phx.gbl...
>> Open IIS, a.k.a Internet Information Services Manager
>> Open your Reports site, is probably under Web SItes - Default Web Site.
>> RIght click and choose Browse. Does it open correctly?
>> If it does, what is the URL? I did a test install of the 2005 edition,
>> and I think you might get some extra "name" or something, like
>> http://localhost/reports$instancename
>> Which means that the reports are still there, but the URL might have
>> changed. Or something.
>> Also, with Sql Server 2005 there's an nice Reporting Services
>> configuration tool. Start it and look to see if there are any things that
>> needs to be started.
>> Kaisa M. Lindahl
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:usLfZ8rFGHA.208@.tk2msftngp13.phx.gbl...
>> Hi again.
>> I installed again the whole server: Window 2003 and SQL Server 2005
>> full.
>> Now I finally see the reports site :-)
>> There is a Visual Studio installed with SQL 2005 and I can design
>> reports there. But now I don't know how to configure the project to
>> deploy correctly.
>> I get that error:
>> A connection could not be made to the report server
>> http://localhost/reports
>> Additional information:
>> The attempt to connect to the report server failed. Check your
>> connection information and the report server is a compatible version.
>> (Microsoft.ReportingServices.Designer).
>> If I try with: http://localhost/reportserver then I get a compilation
>> error:
>> The Report Server Windows Service ReportServer is not running. The
>> service must be running to use the Report Server.
>> How can I solve that?
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:exkoPudFGHA.3280@.TK2MSFTNGP10.phx.gbl...
>> Google is your friend. Type in "reporting services" 503 "service
>> unavailable" and you'll get quite a lot of info. Not all of it is
>> directly connected to Reporting Services, but you should be able to
>> pick up some info on the 503 problem in general. It seems that there's
>> a problem with the Reporting Services web service.
>> Are you allowed to log on to the actual server and try running Report
>> Manager from that box?
>> What sort of authentication is set?
>> Try adding the report server site to your Trusted sites in IE, and then
>> change the Security Settings for Trusted Sites to "Prompt for user name
>> and password" in User Authentication - Logon. Type in your username and
>> password. If it fails, that might be what causes the problem. In that
>> case, you need to figure out what rights are needed for you to access
>> the reports.
>> Kaisa M. Lindahl
>>
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
>> I'm trying to use Reporting Services 2005. The service is running, but
>> if I type http://192.168.1.49:8888/reportserver I see the directory
>> list.
>> With http://192.1681.49:8888/reports, I see an error: The request
>> failed with HTTP status 503: Service Unavailable.The error is in URL.
>> http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least I know
>> is inside the application.
>> I'm completely stuck. What can I do or where can I search?
>> --
>> Regards,
>> Diego F.
>>
>>
>>
>|||There are three ways to integrate with RS 2005.
1. URL Integration
2. Web Services
3. Visual Studio 2005 Reporting Control
The reporting control has a local mode, you get it a datatable and a report.
I suggest you back up and learn how to create reports before you deal with
integration. There is a lot more that you have to do in local mode.
Normal function is to create a report and deploy it. Make sure it works from
the shipping portal (Report Manager web site).
Have your queries as stored procedures is great. No reason to create the RDL
on the fly. Just pass parameters to the report and use your stored
procedure.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Diego F." <diegofrNO@.terra.es> wrote in message
news:%23ejqOcsFGHA.2444@.TK2MSFTNGP11.phx.gbl...
>I did the process again and now -don't ask me why- it shows the report.
> Then, as I asked you before, is the idea to create all the reports I need
> and upload to the server?
> My idea is to intergate that in a web application, so I expected to show
> just the report by clicking a button. Is that possible?
> And last but not least ;-), is it possible to dinamically -by code-
> generate the reports temporally? I have all my queries as stored
> procedures.
> Thanks a lot!
> --
> Regards,
> Diego F.
>
> "Diego F." <diegofrNO@.terra.es> escribió en el mensaje
> news:OI94mSsFGHA.752@.TK2MSFTNGP12.phx.gbl...
>>I finally uploaded a report. I made it with Visual Studio 2005 installed
>>by SQL Server 2005. I made a report and deployed it, and in the Report
>>Manager shows the new report, but I can't see it because:
>> - 'The report server cannot process the report. The data source
>> connection information has been deleted. (rsInvalidDataSourceReference).
>> I made the connection with the project.
>> If I'm understanding something, is it the idea to have all the reports in
>> the server, and the applications should link to that URL to load the
>> report?
>> Thanks a lot for your help. I really appreciate.
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:umHKqBsFGHA.2084@.TK2MSFTNGP09.phx.gbl...
>> Open IIS, a.k.a Internet Information Services Manager
>> Open your Reports site, is probably under Web SItes - Default Web Site.
>> RIght click and choose Browse. Does it open correctly?
>> If it does, what is the URL? I did a test install of the 2005 edition,
>> and I think you might get some extra "name" or something, like
>> http://localhost/reports$instancename
>> Which means that the reports are still there, but the URL might have
>> changed. Or something.
>> Also, with Sql Server 2005 there's an nice Reporting Services
>> configuration tool. Start it and look to see if there are any things
>> that needs to be started.
>> Kaisa M. Lindahl
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:usLfZ8rFGHA.208@.tk2msftngp13.phx.gbl...
>> Hi again.
>> I installed again the whole server: Window 2003 and SQL Server 2005
>> full.
>> Now I finally see the reports site :-)
>> There is a Visual Studio installed with SQL 2005 and I can design
>> reports there. But now I don't know how to configure the project to
>> deploy correctly.
>> I get that error:
>> A connection could not be made to the report server
>> http://localhost/reports
>> Additional information:
>> The attempt to connect to the report server failed. Check your
>> connection information and the report server is a compatible version.
>> (Microsoft.ReportingServices.Designer).
>> If I try with: http://localhost/reportserver then I get a compilation
>> error:
>> The Report Server Windows Service ReportServer is not running. The
>> service must be running to use the Report Server.
>> How can I solve that?
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:exkoPudFGHA.3280@.TK2MSFTNGP10.phx.gbl...
>> Google is your friend. Type in "reporting services" 503 "service
>> unavailable" and you'll get quite a lot of info. Not all of it is
>> directly connected to Reporting Services, but you should be able to
>> pick up some info on the 503 problem in general. It seems that there's
>> a problem with the Reporting Services web service.
>> Are you allowed to log on to the actual server and try running Report
>> Manager from that box?
>> What sort of authentication is set?
>> Try adding the report server site to your Trusted sites in IE, and
>> then change the Security Settings for Trusted Sites to "Prompt for
>> user name and password" in User Authentication - Logon. Type in your
>> username and password. If it fails, that might be what causes the
>> problem. In that case, you need to figure out what rights are needed
>> for you to access the reports.
>> Kaisa M. Lindahl
>>
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
>> I'm trying to use Reporting Services 2005. The service is running,
>> but if I type http://192.168.1.49:8888/reportserver I see the
>> directory list.
>> With http://192.1681.49:8888/reports, I see an error: The request
>> failed with HTTP status 503: Service Unavailable.The error is in URL.
>> http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least I
>> know is inside the application.
>> I'm completely stuck. What can I do or where can I search?
>> --
>> Regards,
>> Diego F.
>>
>>
>>
>>
>|||Bruce already answered some of your questions, I'll just add something.
- Create your reports locally, deploy to the server.
- When it comes to webapplications, you can either link directly to each
report, with parameters and everything else, or you can create an iFrame and
make the Report Manager show up inside. (Look for tips on integrating with
SharePoint, even if you're not using SharePoint, as you can use some of the
info in your web app.)
http://blogs.spipp.net/kaisa/archive/2005/09/27/1185.aspx
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/webrssp2.mspx
The beauty of using an iFrame against Report Manager, is that Report Manager
will still deal with authentication for the different reports.
- Make sure to test your reports with user accounts with less priveleges
than yourself, before allowing your users to try them out. SOmetimes setting
the rights values in the datasource can be a bit tricky.
Kaisa M. Lindahl
"Diego F." <diegofrNO@.terra.es> wrote in message
news:%23ejqOcsFGHA.2444@.TK2MSFTNGP11.phx.gbl...
>I did the process again and now -don't ask me why- it shows the report.
> Then, as I asked you before, is the idea to create all the reports I need
> and upload to the server?
> My idea is to intergate that in a web application, so I expected to show
> just the report by clicking a button. Is that possible?
> And last but not least ;-), is it possible to dinamically -by code-
> generate the reports temporally? I have all my queries as stored
> procedures.
> Thanks a lot!
> --
> Regards,
> Diego F.
>
> "Diego F." <diegofrNO@.terra.es> escribió en el mensaje
> news:OI94mSsFGHA.752@.TK2MSFTNGP12.phx.gbl...
>>I finally uploaded a report. I made it with Visual Studio 2005 installed
>>by SQL Server 2005. I made a report and deployed it, and in the Report
>>Manager shows the new report, but I can't see it because:
>> - 'The report server cannot process the report. The data source
>> connection information has been deleted. (rsInvalidDataSourceReference).
>> I made the connection with the project.
>> If I'm understanding something, is it the idea to have all the reports in
>> the server, and the applications should link to that URL to load the
>> report?
>> Thanks a lot for your help. I really appreciate.
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:umHKqBsFGHA.2084@.TK2MSFTNGP09.phx.gbl...
>> Open IIS, a.k.a Internet Information Services Manager
>> Open your Reports site, is probably under Web SItes - Default Web Site.
>> RIght click and choose Browse. Does it open correctly?
>> If it does, what is the URL? I did a test install of the 2005 edition,
>> and I think you might get some extra "name" or something, like
>> http://localhost/reports$instancename
>> Which means that the reports are still there, but the URL might have
>> changed. Or something.
>> Also, with Sql Server 2005 there's an nice Reporting Services
>> configuration tool. Start it and look to see if there are any things
>> that needs to be started.
>> Kaisa M. Lindahl
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:usLfZ8rFGHA.208@.tk2msftngp13.phx.gbl...
>> Hi again.
>> I installed again the whole server: Window 2003 and SQL Server 2005
>> full.
>> Now I finally see the reports site :-)
>> There is a Visual Studio installed with SQL 2005 and I can design
>> reports there. But now I don't know how to configure the project to
>> deploy correctly.
>> I get that error:
>> A connection could not be made to the report server
>> http://localhost/reports
>> Additional information:
>> The attempt to connect to the report server failed. Check your
>> connection information and the report server is a compatible version.
>> (Microsoft.ReportingServices.Designer).
>> If I try with: http://localhost/reportserver then I get a compilation
>> error:
>> The Report Server Windows Service ReportServer is not running. The
>> service must be running to use the Report Server.
>> How can I solve that?
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:exkoPudFGHA.3280@.TK2MSFTNGP10.phx.gbl...
>> Google is your friend. Type in "reporting services" 503 "service
>> unavailable" and you'll get quite a lot of info. Not all of it is
>> directly connected to Reporting Services, but you should be able to
>> pick up some info on the 503 problem in general. It seems that there's
>> a problem with the Reporting Services web service.
>> Are you allowed to log on to the actual server and try running Report
>> Manager from that box?
>> What sort of authentication is set?
>> Try adding the report server site to your Trusted sites in IE, and
>> then change the Security Settings for Trusted Sites to "Prompt for
>> user name and password" in User Authentication - Logon. Type in your
>> username and password. If it fails, that might be what causes the
>> problem. In that case, you need to figure out what rights are needed
>> for you to access the reports.
>> Kaisa M. Lindahl
>>
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
>> I'm trying to use Reporting Services 2005. The service is running,
>> but if I type http://192.168.1.49:8888/reportserver I see the
>> directory list.
>> With http://192.1681.49:8888/reports, I see an error: The request
>> failed with HTTP status 503: Service Unavailable.The error is in URL.
>> http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least I
>> know is inside the application.
>> I'm completely stuck. What can I do or where can I search?
>> --
>> Regards,
>> Diego F.
>>
>>
>>
>>
>|||Thank you. I'm trying to use just the URL to see the report, so it
integrates easily with my application.
I tried with a test server I installed just to make tests with that. The
only problem I met is that I have to put user and password, but I hope that
doing from the same domain avoids that.
Anyway, it's a lot of work to manually create each report from a whole
application.
--
Regards,
Diego F.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> escribió en el mensaje
news:usBxTgsFGHA.1192@.TK2MSFTNGP11.phx.gbl...
> There are three ways to integrate with RS 2005.
> 1. URL Integration
> 2. Web Services
> 3. Visual Studio 2005 Reporting Control
> The reporting control has a local mode, you get it a datatable and a
> report.
> I suggest you back up and learn how to create reports before you deal with
> integration. There is a lot more that you have to do in local mode.
> Normal function is to create a report and deploy it. Make sure it works
> from the shipping portal (Report Manager web site).
> Have your queries as stored procedures is great. No reason to create the
> RDL on the fly. Just pass parameters to the report and use your stored
> procedure.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Diego F." <diegofrNO@.terra.es> wrote in message
> news:%23ejqOcsFGHA.2444@.TK2MSFTNGP11.phx.gbl...
>>I did the process again and now -don't ask me why- it shows the report.
>> Then, as I asked you before, is the idea to create all the reports I need
>> and upload to the server?
>> My idea is to intergate that in a web application, so I expected to show
>> just the report by clicking a button. Is that possible?
>> And last but not least ;-), is it possible to dinamically -by code-
>> generate the reports temporally? I have all my queries as stored
>> procedures.
>> Thanks a lot!
>> --
>> Regards,
>> Diego F.
>>
>> "Diego F." <diegofrNO@.terra.es> escribió en el mensaje
>> news:OI94mSsFGHA.752@.TK2MSFTNGP12.phx.gbl...
>>I finally uploaded a report. I made it with Visual Studio 2005 installed
>>by SQL Server 2005. I made a report and deployed it, and in the Report
>>Manager shows the new report, but I can't see it because:
>> - 'The report server cannot process the report. The data source
>> connection information has been deleted. (rsInvalidDataSourceReference).
>> I made the connection with the project.
>> If I'm understanding something, is it the idea to have all the reports
>> in the server, and the applications should link to that URL to load the
>> report?
>> Thanks a lot for your help. I really appreciate.
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:umHKqBsFGHA.2084@.TK2MSFTNGP09.phx.gbl...
>> Open IIS, a.k.a Internet Information Services Manager
>> Open your Reports site, is probably under Web SItes - Default Web Site.
>> RIght click and choose Browse. Does it open correctly?
>> If it does, what is the URL? I did a test install of the 2005 edition,
>> and I think you might get some extra "name" or something, like
>> http://localhost/reports$instancename
>> Which means that the reports are still there, but the URL might have
>> changed. Or something.
>> Also, with Sql Server 2005 there's an nice Reporting Services
>> configuration tool. Start it and look to see if there are any things
>> that needs to be started.
>> Kaisa M. Lindahl
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:usLfZ8rFGHA.208@.tk2msftngp13.phx.gbl...
>> Hi again.
>> I installed again the whole server: Window 2003 and SQL Server 2005
>> full.
>> Now I finally see the reports site :-)
>> There is a Visual Studio installed with SQL 2005 and I can design
>> reports there. But now I don't know how to configure the project to
>> deploy correctly.
>> I get that error:
>> A connection could not be made to the report server
>> http://localhost/reports
>> Additional information:
>> The attempt to connect to the report server failed. Check your
>> connection information and the report server is a compatible version.
>> (Microsoft.ReportingServices.Designer).
>> If I try with: http://localhost/reportserver then I get a compilation
>> error:
>> The Report Server Windows Service ReportServer is not running. The
>> service must be running to use the Report Server.
>> How can I solve that?
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:exkoPudFGHA.3280@.TK2MSFTNGP10.phx.gbl...
>> Google is your friend. Type in "reporting services" 503 "service
>> unavailable" and you'll get quite a lot of info. Not all of it is
>> directly connected to Reporting Services, but you should be able to
>> pick up some info on the 503 problem in general. It seems that
>> there's a problem with the Reporting Services web service.
>> Are you allowed to log on to the actual server and try running Report
>> Manager from that box?
>> What sort of authentication is set?
>> Try adding the report server site to your Trusted sites in IE, and
>> then change the Security Settings for Trusted Sites to "Prompt for
>> user name and password" in User Authentication - Logon. Type in your
>> username and password. If it fails, that might be what causes the
>> problem. In that case, you need to figure out what rights are needed
>> for you to access the reports.
>> Kaisa M. Lindahl
>>
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
>>> I'm trying to use Reporting Services 2005. The service is running,
>>> but if I type http://192.168.1.49:8888/reportserver I see the
>>> directory list.
>>> With http://192.1681.49:8888/reports, I see an error: The request
>>> failed with HTTP status 503: Service Unavailable.The error is in
>>> URL. http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least
>>> I know is inside the application.
>>>
>>> I'm completely stuck. What can I do or where can I search?
>>>
>>> --
>>> Regards,
>>>
>>> Diego F.
>>>
>>
>>
>>
>>
>>
>|||I'll also use SharePoint to integrate the whole application, so I'll check
that.
Where can I set the reports permissions?
--
Regards,
Diego F.
"Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
news:uF8RP1sFGHA.532@.TK2MSFTNGP15.phx.gbl...
> Bruce already answered some of your questions, I'll just add something.
> - Create your reports locally, deploy to the server.
> - When it comes to webapplications, you can either link directly to each
> report, with parameters and everything else, or you can create an iFrame
> and make the Report Manager show up inside. (Look for tips on integrating
> with SharePoint, even if you're not using SharePoint, as you can use some
> of the info in your web app.)
> http://blogs.spipp.net/kaisa/archive/2005/09/27/1185.aspx
> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/webrssp2.mspx
> The beauty of using an iFrame against Report Manager, is that Report
> Manager will still deal with authentication for the different reports.
> - Make sure to test your reports with user accounts with less priveleges
> than yourself, before allowing your users to try them out. SOmetimes
> setting the rights values in the datasource can be a bit tricky.
> Kaisa M. Lindahl
> "Diego F." <diegofrNO@.terra.es> wrote in message
> news:%23ejqOcsFGHA.2444@.TK2MSFTNGP11.phx.gbl...
>>I did the process again and now -don't ask me why- it shows the report.
>> Then, as I asked you before, is the idea to create all the reports I need
>> and upload to the server?
>> My idea is to intergate that in a web application, so I expected to show
>> just the report by clicking a button. Is that possible?
>> And last but not least ;-), is it possible to dinamically -by code-
>> generate the reports temporally? I have all my queries as stored
>> procedures.
>> Thanks a lot!
>> --
>> Regards,
>> Diego F.
>>
>> "Diego F." <diegofrNO@.terra.es> escribió en el mensaje
>> news:OI94mSsFGHA.752@.TK2MSFTNGP12.phx.gbl...
>>I finally uploaded a report. I made it with Visual Studio 2005 installed
>>by SQL Server 2005. I made a report and deployed it, and in the Report
>>Manager shows the new report, but I can't see it because:
>> - 'The report server cannot process the report. The data source
>> connection information has been deleted. (rsInvalidDataSourceReference).
>> I made the connection with the project.
>> If I'm understanding something, is it the idea to have all the reports
>> in the server, and the applications should link to that URL to load the
>> report?
>> Thanks a lot for your help. I really appreciate.
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:umHKqBsFGHA.2084@.TK2MSFTNGP09.phx.gbl...
>> Open IIS, a.k.a Internet Information Services Manager
>> Open your Reports site, is probably under Web SItes - Default Web Site.
>> RIght click and choose Browse. Does it open correctly?
>> If it does, what is the URL? I did a test install of the 2005 edition,
>> and I think you might get some extra "name" or something, like
>> http://localhost/reports$instancename
>> Which means that the reports are still there, but the URL might have
>> changed. Or something.
>> Also, with Sql Server 2005 there's an nice Reporting Services
>> configuration tool. Start it and look to see if there are any things
>> that needs to be started.
>> Kaisa M. Lindahl
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:usLfZ8rFGHA.208@.tk2msftngp13.phx.gbl...
>> Hi again.
>> I installed again the whole server: Window 2003 and SQL Server 2005
>> full.
>> Now I finally see the reports site :-)
>> There is a Visual Studio installed with SQL 2005 and I can design
>> reports there. But now I don't know how to configure the project to
>> deploy correctly.
>> I get that error:
>> A connection could not be made to the report server
>> http://localhost/reports
>> Additional information:
>> The attempt to connect to the report server failed. Check your
>> connection information and the report server is a compatible version.
>> (Microsoft.ReportingServices.Designer).
>> If I try with: http://localhost/reportserver then I get a compilation
>> error:
>> The Report Server Windows Service ReportServer is not running. The
>> service must be running to use the Report Server.
>> How can I solve that?
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:exkoPudFGHA.3280@.TK2MSFTNGP10.phx.gbl...
>> Google is your friend. Type in "reporting services" 503 "service
>> unavailable" and you'll get quite a lot of info. Not all of it is
>> directly connected to Reporting Services, but you should be able to
>> pick up some info on the 503 problem in general. It seems that
>> there's a problem with the Reporting Services web service.
>> Are you allowed to log on to the actual server and try running Report
>> Manager from that box?
>> What sort of authentication is set?
>> Try adding the report server site to your Trusted sites in IE, and
>> then change the Security Settings for Trusted Sites to "Prompt for
>> user name and password" in User Authentication - Logon. Type in your
>> username and password. If it fails, that might be what causes the
>> problem. In that case, you need to figure out what rights are needed
>> for you to access the reports.
>> Kaisa M. Lindahl
>>
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
>>> I'm trying to use Reporting Services 2005. The service is running,
>>> but if I type http://192.168.1.49:8888/reportserver I see the
>>> directory list.
>>> With http://192.1681.49:8888/reports, I see an error: The request
>>> failed with HTTP status 503: Service Unavailable.The error is in
>>> URL. http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least
>>> I know is inside the application.
>>>
>>> I'm completely stuck. What can I do or where can I search?
>>>
>>> --
>>> Regards,
>>>
>>> Diego F.
>>>
>>
>>
>>
>>
>>
>|||On either a folder or a single report: Click Properties and the Security.
ANd then you can add what users and groups are allowed to see or update
reports.
Kaisa
"Diego F." <diegofrNO@.terra.es> wrote in message
news:%23ToFp6sFGHA.916@.TK2MSFTNGP10.phx.gbl...
> I'll also use SharePoint to integrate the whole application, so I'll check
> that.
> Where can I set the reports permissions?
> --
> Regards,
> Diego F.
>
> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
> news:uF8RP1sFGHA.532@.TK2MSFTNGP15.phx.gbl...
>> Bruce already answered some of your questions, I'll just add something.
>> - Create your reports locally, deploy to the server.
>> - When it comes to webapplications, you can either link directly to each
>> report, with parameters and everything else, or you can create an iFrame
>> and make the Report Manager show up inside. (Look for tips on integrating
>> with SharePoint, even if you're not using SharePoint, as you can use some
>> of the info in your web app.)
>> http://blogs.spipp.net/kaisa/archive/2005/09/27/1185.aspx
>> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/webrssp2.mspx
>> The beauty of using an iFrame against Report Manager, is that Report
>> Manager will still deal with authentication for the different reports.
>> - Make sure to test your reports with user accounts with less priveleges
>> than yourself, before allowing your users to try them out. SOmetimes
>> setting the rights values in the datasource can be a bit tricky.
>> Kaisa M. Lindahl
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:%23ejqOcsFGHA.2444@.TK2MSFTNGP11.phx.gbl...
>>I did the process again and now -don't ask me why- it shows the report.
>> Then, as I asked you before, is the idea to create all the reports I
>> need and upload to the server?
>> My idea is to intergate that in a web application, so I expected to show
>> just the report by clicking a button. Is that possible?
>> And last but not least ;-), is it possible to dinamically -by code-
>> generate the reports temporally? I have all my queries as stored
>> procedures.
>> Thanks a lot!
>> --
>> Regards,
>> Diego F.
>>
>> "Diego F." <diegofrNO@.terra.es> escribió en el mensaje
>> news:OI94mSsFGHA.752@.TK2MSFTNGP12.phx.gbl...
>>I finally uploaded a report. I made it with Visual Studio 2005 installed
>>by SQL Server 2005. I made a report and deployed it, and in the Report
>>Manager shows the new report, but I can't see it because:
>> - 'The report server cannot process the report. The data source
>> connection information has been deleted.
>> (rsInvalidDataSourceReference).
>> I made the connection with the project.
>> If I'm understanding something, is it the idea to have all the reports
>> in the server, and the applications should link to that URL to load the
>> report?
>> Thanks a lot for your help. I really appreciate.
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:umHKqBsFGHA.2084@.TK2MSFTNGP09.phx.gbl...
>> Open IIS, a.k.a Internet Information Services Manager
>> Open your Reports site, is probably under Web SItes - Default Web
>> Site. RIght click and choose Browse. Does it open correctly?
>> If it does, what is the URL? I did a test install of the 2005 edition,
>> and I think you might get some extra "name" or something, like
>> http://localhost/reports$instancename
>> Which means that the reports are still there, but the URL might have
>> changed. Or something.
>> Also, with Sql Server 2005 there's an nice Reporting Services
>> configuration tool. Start it and look to see if there are any things
>> that needs to be started.
>> Kaisa M. Lindahl
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:usLfZ8rFGHA.208@.tk2msftngp13.phx.gbl...
>> Hi again.
>> I installed again the whole server: Window 2003 and SQL Server 2005
>> full.
>> Now I finally see the reports site :-)
>> There is a Visual Studio installed with SQL 2005 and I can design
>> reports there. But now I don't know how to configure the project to
>> deploy correctly.
>> I get that error:
>> A connection could not be made to the report server
>> http://localhost/reports
>> Additional information:
>> The attempt to connect to the report server failed. Check your
>> connection information and the report server is a compatible version.
>> (Microsoft.ReportingServices.Designer).
>> If I try with: http://localhost/reportserver then I get a compilation
>> error:
>> The Report Server Windows Service ReportServer is not running. The
>> service must be running to use the Report Server.
>> How can I solve that?
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:exkoPudFGHA.3280@.TK2MSFTNGP10.phx.gbl...
>>> Google is your friend. Type in "reporting services" 503 "service
>>> unavailable" and you'll get quite a lot of info. Not all of it is
>>> directly connected to Reporting Services, but you should be able to
>>> pick up some info on the 503 problem in general. It seems that
>>> there's a problem with the Reporting Services web service.
>>>
>>> Are you allowed to log on to the actual server and try running
>>> Report Manager from that box?
>>> What sort of authentication is set?
>>> Try adding the report server site to your Trusted sites in IE, and
>>> then change the Security Settings for Trusted Sites to "Prompt for
>>> user name and password" in User Authentication - Logon. Type in your
>>> username and password. If it fails, that might be what causes the
>>> problem. In that case, you need to figure out what rights are needed
>>> for you to access the reports.
>>>
>>> Kaisa M. Lindahl
>>>
>>>
>>> "Diego F." <diegofrNO@.terra.es> wrote in message
>>> news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
>>> I'm trying to use Reporting Services 2005. The service is running,
>>> but if I type http://192.168.1.49:8888/reportserver I see the
>>> directory list.
>>> With http://192.1681.49:8888/reports, I see an error: The request
>>> failed with HTTP status 503: Service Unavailable.The error is in
>>> URL. http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at
>>> least I know is inside the application.
>>>
>>> I'm completely stuck. What can I do or where can I search?
>>>
>>> --
>>> Regards,
>>>
>>> Diego F.
>>>
>>>
>>>
>>
>>
>>
>>
>>
>sql

can't see print messages during the running a of stored procedure

I have a stored procedure running from Query Analyzer that runs for a long
time and would like to have status messages print out during the procedure.
They all seem to come when the procedure is complete - is there any way to
have them print while it is running. I 've actually tried having the main
SP call a smaller SP with prints, but they don't come out till the end as
well.
Help to a new Transact SQL writer,
Thanks
TW
TW,
I don't know how to do just what you want, but you could try pumping your
messages into a trace table. Then you could query that table while the
long-running stored procedure continues. Transaction isolation levels would
affect how this works for you.
Russell Fields
"Weave" <tweaver60@.suscom.net> wrote in message
news:10apu6dm256v76@.corp.supernews.com...
> I have a stored procedure running from Query Analyzer that runs for a long
> time and would like to have status messages print out during the
procedure.
> They all seem to come when the procedure is complete - is there any way to
> have them print while it is running. I 've actually tried having the main
> SP call a smaller SP with prints, but they don't come out till the end as
> well.
> Help to a new Transact SQL writer,
> Thanks
> TW
>
|||You could use RAISERROR and the NOWAIT option instead of PRINT.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Weave" <tweaver60@.suscom.net> wrote in message news:10apu6dm256v76@.corp.supernews.com...
> I have a stored procedure running from Query Analyzer that runs for a long
> time and would like to have status messages print out during the procedure.
> They all seem to come when the procedure is complete - is there any way to
> have them print while it is running. I 've actually tried having the main
> SP call a smaller SP with prints, but they don't come out till the end as
> well.
> Help to a new Transact SQL writer,
> Thanks
> TW
>

Can't see new objects created in SQL Server from C#

We have just installed SQL and C# Express. We have lots of experience with SQL, but none with C#. With both the SQL and C# apps running; if we create a new table, view etc, we cannot see that new object from C# only the objects that existed when we opened the apps for the first time (each time).

If we close everything and re-open everything from scratch, the new objects show..!?!?

Thank you for any information on this difficult problem.

Hard to tell without knowing which technique youuse to display the objects and if there is eventually somehow a caching mechanism involved. Could you post some code which does the retrieval ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

Can't see named instance

I have a client running NT 4.0 on one of his workstations. For some reason f
rom that machine he can't see the named Instance on the Server (MyServer\MyI
nstance) and therefore can't connect to the database. If I pull up a list of
available servers, the Ser
ver comes up on the list, just not the named instance. ANy ideas on what mig
ht be causing this?Old version of MDAC. Apply the latest supported MDAC for NT 4.0 and the
client can connect. Alternatively, you can create an alias on the client
that includes the port number and connect via it.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Sean" <anonymous@.discussions.microsoft.com> wrote in message
news:2E49EBDD-9A7E-4772-9241-FA5A3EFA50C1@.microsoft.com...
> I have a client running NT 4.0 on one of his workstations. For some reason
from that machine he can't see the named Instance on the Server
(MyServer\MyInstance) and therefore can't connect to the database. If I pull
up a list of available servers, the Server comes up on the list, just not
the named instance. ANy ideas on what might be causing this?|||Yeah, thanks, that was it. Was getting burned by the user rights. The instal
l is supposed to load version 2.7 but I don't think the user had enough righ
ts on the box to do it.

Can't see named instance

I have a client running NT 4.0 on one of his workstations. For some reason from that machine he can't see the named Instance on the Server (MyServer\MyInstance) and therefore can't connect to the database. If I pull up a list of available servers, the Server comes up on the list, just not the named instance. ANy ideas on what might be causing this?Old version of MDAC. Apply the latest supported MDAC for NT 4.0 and the
client can connect. Alternatively, you can create an alias on the client
that includes the port number and connect via it.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Sean" <anonymous@.discussions.microsoft.com> wrote in message
news:2E49EBDD-9A7E-4772-9241-FA5A3EFA50C1@.microsoft.com...
> I have a client running NT 4.0 on one of his workstations. For some reason
from that machine he can't see the named Instance on the Server
(MyServer\MyInstance) and therefore can't connect to the database. If I pull
up a list of available servers, the Server comes up on the list, just not
the named instance. ANy ideas on what might be causing this?

can't see MSDE icon on XP pro...

hi..
for some reason i can't see the MSDE icon on the tray (it came with
Visual Studio .NET 2002)
althought the service i running i cann't access the MSDE from access
or visual studio..
Hi,
I presume you meant to say the service is running. Are you determining that
by looking in the Services applet (in Administrative tools via Control
Panel)?
If so, when you say you can't access it from Access or Visual Studio, what
error is returned?
Are there any errors in your system or application event logs? (access the
event viewer also from Administrative tools).
Regards,
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Elhanan Maayan" <emaayan@.hotmail.com> wrote in message
news:ec817d75.0405122055.77a6de3@.posting.google.co m...
> hi..
> for some reason i can't see the MSDE icon on the tray (it came with
> Visual Studio .NET 2002)
> althought the service i running i cann't access the MSDE from access
> or visual studio..

cant see more than 3gb mem

We are running SQL server 2000 on Windows 2003 on a Compaq MLxxx. I
have /pae and /3gb switch in the boot.ini and 'awe enabled' in sql
server. However the target server memorry is only 2725808 and sql
server goes to a max to 2.7 GB. I have played with the 'max memory'
parameter but it dosent help. Any idea what am I missing ?How much physical memory is on the machine?
Rand
This posting is provided "as is" with no warranties and confers no rights.|||I have 8GB of RAM. Here is the output of @.@.version
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: )
>--Original Message--
>How much physical memory is on the machine?
>Rand
>This posting is provided "as is" with no warranties and
confers no rights.
>.
>|||The problem was the service account didnt have previlage "
lock pages in memory "
Details http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/adminsql/ad_1_server_1fnd.asp
>--Original Message--
>I have 8GB of RAM. Here is the output of @.@.version
>Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Enterprise Edition on Windows NT 5.2 (Build 3790: )
>>--Original Message--
>>How much physical memory is on the machine?
>>Rand
>>This posting is provided "as is" with no warranties and
>confers no rights.
>>.
>.
>

cant see more than 3gb mem

We are running SQL server 2000 on Windows 2003 on a Compaq MLxxx. I
have /pae and /3gb switch in the boot.ini and 'awe enabled' in sql
server. However the target server memorry is only 2725808 and sql
server goes to a max to 2.7 GB. I have played with the 'max memory'
parameter but it dosent help. Any idea what am I missing ?How much physical memory is on the machine?
Rand
This posting is provided "as is" with no warranties and confers no rights.|||I have 8GB of RAM. Here is the output of @.@.version
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: )

>--Original Message--
>How much physical memory is on the machine?
>Rand
>This posting is provided "as is" with no warranties and
confers no rights.
>.
>|||The problem was the service account didnt have previlage "
lock pages in memory "
Details http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/adminsql/ad_1_server_1fnd.asp

>--Original Message--
>I have 8GB of RAM. Here is the output of @.@.version
>Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Enterprise Edition on Windows NT 5.2 (Build 3790: )
>
>confers no rights.
>.
>sql

Can't see Mapped Drives in Database Maintenance tool!

I have SQL2000 & SQL2005 running on Windows 2003 servers.
I am using the Database Maintenance tool to backup selected databases. I
realized the only drives I can save these backups to are the local drives. We
don't have enough space on these local drives, so is there anyway to see the
network mapped drives for this procedure?
Thanks,
Ted
Don't use a mapped drive. Use the UNC pathing instead. You need to ensure
the account SQL Server is running under has permissions to read and write to
this share first.
http://support.microsoft.com/kb/555128
Andrew J. Kelly SQL MVP
"Infomax" <Infomax@.discussions.microsoft.com> wrote in message
news:EBB765BE-0A41-456C-9615-C6AB069AAADB@.microsoft.com...
>I have SQL2000 & SQL2005 running on Windows 2003 servers.
> I am using the Database Maintenance tool to backup selected databases. I
> realized the only drives I can save these backups to are the local drives.
> We
> don't have enough space on these local drives, so is there anyway to see
> the
> network mapped drives for this procedure?
> Thanks,
> Ted

Can't run SP with GETDATE()

I'm having a problem running this stored procedure that is supposed to count
the "Failed Domains" based on the beginning date and end date.
I'd like to simply run this sp with getdate()-2 and getdate-1, but when I
run this:
Exec dbo.PROC_SuccessCountByDate getdate()-1, (getdate()
I get the error
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near ')'.
The Stored Procedure:
CREATE PROC PROC_SuccessCountByDate
@.begdate datetime,
@.enddate datetime
as
select count(domain_) as 'Failed Domain Count', T1m.domain_
from Table1 T1
join Table2 T2
on T2.memberid = T1.memberid_
where T2.completionstatusid in (301, 303)
and T2.finalattempt > @.begdate
and T2.finalattempt < @.enddate
group by T1.domain_
having count(domain_)>5
order by 'Failed Domain Count' descDeclare @.Today datetime
Declare @.Yesterday datetime
SET @.Today = Getdate()
SET @.Yesterday = DATEADD(dd,-1,Getdate())
Exec dbo.PROC_SuccessCountByDate @.Yesterday,@.Today
HTH, Jens SUessmeyer.
"savvy95" <savvy95@.discussions.microsoft.com> schrieb im Newsbeitrag
news:058453F4-9FE1-440E-ADB0-67D284B6957C@.microsoft.com...
> I'm having a problem running this stored procedure that is supposed to
> count
> the "Failed Domains" based on the beginning date and end date.
> I'd like to simply run this sp with getdate()-2 and getdate-1, but when I
> run this:
> Exec dbo.PROC_SuccessCountByDate getdate()-1, (getdate()
> I get the error
> Server: Msg 170, Level 15, State 1, Line 1
> Line 1: Incorrect syntax near ')'.
>
> The Stored Procedure:
> CREATE PROC PROC_SuccessCountByDate
> @.begdate datetime,
> @.enddate datetime
> as
> select count(domain_) as 'Failed Domain Count', T1m.domain_
> from Table1 T1
> join Table2 T2
> on T2.memberid = T1.memberid_
> where T2.completionstatusid in (301, 303)
> and T2.finalattempt > @.begdate
> and T2.finalattempt < @.enddate
> group by T1.domain_
> having count(domain_)>5
> order by 'Failed Domain Count' desc
>|||Yes, you can;t pass an "Expression". like [getdate() - 1], as a parameter
to a Stored Proc.
You can only pass constant values, or variables (either the variable value
or address)
So in your case, create a variable (Declare @.MyDateTime DateTime) and set
the value of that variableto getdate() - 1, and then make your call using th
e
variable...
Exec dbo.PROC_SuccessCountByDate @.MyDateTime, getdate()
And get rid of the extra parentheses after the comma
Exec dbo.PROC_SuccessCountByDate getdate()-1, (getdate()
"savvy95" wrote:

> I'm having a problem running this stored procedure that is supposed to cou
nt
> the "Failed Domains" based on the beginning date and end date.
> I'd like to simply run this sp with getdate()-2 and getdate-1, but when I
> run this:
> Exec dbo.PROC_SuccessCountByDate getdate()-1, (getdate()
> I get the error
> Server: Msg 170, Level 15, State 1, Line 1
> Line 1: Incorrect syntax near ')'.
>
> The Stored Procedure:
> CREATE PROC PROC_SuccessCountByDate
> @.begdate datetime,
> @.enddate datetime
> as
> select count(domain_) as 'Failed Domain Count', T1m.domain_
> from Table1 T1
> join Table2 T2
> on T2.memberid = T1.memberid_
> where T2.completionstatusid in (301, 303)
> and T2.finalattempt > @.begdate
> and T2.finalattempt < @.enddate
> group by T1.domain_
> having count(domain_)>5
> order by 'Failed Domain Count' desc
>|||declare @.bd datetime
declare @.ed datetime
set @.bd = dateadd(day, -1, getdate())
set @.ed = getdate()
Exec dbo.PROC_SuccessCountByDate @.bd, @.ed
...
AMB
"savvy95" wrote:

> I'm having a problem running this stored procedure that is supposed to cou
nt
> the "Failed Domains" based on the beginning date and end date.
> I'd like to simply run this sp with getdate()-2 and getdate-1, but when I
> run this:
> Exec dbo.PROC_SuccessCountByDate getdate()-1, (getdate()
> I get the error
> Server: Msg 170, Level 15, State 1, Line 1
> Line 1: Incorrect syntax near ')'.
>
> The Stored Procedure:
> CREATE PROC PROC_SuccessCountByDate
> @.begdate datetime,
> @.enddate datetime
> as
> select count(domain_) as 'Failed Domain Count', T1m.domain_
> from Table1 T1
> join Table2 T2
> on T2.memberid = T1.memberid_
> where T2.completionstatusid in (301, 303)
> and T2.finalattempt > @.begdate
> and T2.finalattempt < @.enddate
> group by T1.domain_
> having count(domain_)>5
> order by 'Failed Domain Count' desc
>|||This is why I love this community; so many willing to help. Thanks. All of
you had the same solution.
Thanks again
"Jens Sü?meyer" wrote:

> Declare @.Today datetime
> Declare @.Yesterday datetime
> SET @.Today = Getdate()
> SET @.Yesterday = DATEADD(dd,-1,Getdate())
> Exec dbo.PROC_SuccessCountByDate @.Yesterday,@.Today
> HTH, Jens SUessmeyer.
> "savvy95" <savvy95@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:058453F4-9FE1-440E-ADB0-67D284B6957C@.microsoft.com...
>
>|||Perhaps one time there will be an issue which you can also solve in here...
:-)
"savvy95" <savvy95@.discussions.microsoft.com> schrieb im Newsbeitrag
news:0BA224B0-F049-4E46-8BBD-6113DCCAF216@.microsoft.com...
> This is why I love this community; so many willing to help. Thanks. All
> of
> you had the same solution.
> Thanks again
> "Jens Smeyer" wrote:
>|||i want to make SP that enters values into my table, which has the default
value of the date column to getdate
so, if i didn't enter a value it will take the default value of the column
how can i describe this in the sp declaration ?
my sp is as follows :
---
create procedure add_new_abstract
@.abs_name nvarchar(20) ,
@.id_reg nvarchar(10),
@.id_topic nvarchar(10),
@.id_stat nvarchar(10),
@.abst nvarchar(20) ,
@.job_id nvarchar(20),
@.date_abs datetime
as
insert abstract
values (cast(cast(rand()*9285 as int)as
nvarchar(10)),@.abs_name,@.id_reg,@.id_topi
c,@.id_stat,@.abst,@.job_id,@.date_abs)
go
---
so, when i execute it with the getdate() it raise the error specified in
this discussion
and when i neglect it so that it takes the value as the default value of the
column , it asks for it
so, how can i solve this ?
thanx for ur help
--
regards
Maidoo.
"Jens Sü?meyer" wrote:

> Perhaps one time there will be an issue which you can also solve in here..
.
> :-)
>
> "savvy95" <savvy95@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:0BA224B0-F049-4E46-8BBD-6113DCCAF216@.microsoft.com...
>
>|||On Fri, 10 Jun 2005 10:59:27 -0700, maidoo wrote:

>i want to make SP that enters values into my table, which has the default
>value of the date column to getdate
>so, if i didn't enter a value it will take the default value of the column
>how can i describe this in the sp declaration ?
Hi maidoo,
Change your proc like this:
create procedure add_new_abstract
@.abs_name nvarchar(20) ,
@.id_reg nvarchar(10),
@.id_topic nvarchar(10),
@.id_stat nvarchar(10),
@.abst nvarchar(20) ,
@.job_id nvarchar(20),
@.date_abs datetime = null
as
insert abstract
values (cast(cast(rand()*9285 as int)as
nvarchar(10)),@.abs_name,@.id_reg,@.id_topi
c,@.id_stat,@.abst,@.job_id,
COALESCE(@.date_abs, CURRENT_TIMESTAMP))
go
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)|||create procedure add_new_abstract
@.abs_name nvarchar(20) ,
@.id_reg nvarchar(10),
@.id_topic nvarchar(10),
@.id_stat nvarchar(10),
@.abst nvarchar(20) ,
@.job_id nvarchar(20),
@.date_abs datetime
as
SET @.date_abs = ISNULL(@.date_abs, GETDATE())
insert abstract
values (cast(cast(rand()*9285 as int)as
nvarchar(10)),@.abs_name,@.id_reg,@.id_topi
c,@.id_stat,@.abst,@.job_id,@.date_abs)
go
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"maidoo" <maidooalex@.msn.com> wrote in message
news:B70444AF-0A65-416E-91DB-05E4D911809E@.microsoft.com...
>i want to make SP that enters values into my table, which has the default
> value of the date column to getdate
> so, if i didn't enter a value it will take the default value of the column
> how can i describe this in the sp declaration ?
> my sp is as follows :
> ---
> create procedure add_new_abstract
> @.abs_name nvarchar(20) ,
> @.id_reg nvarchar(10),
> @.id_topic nvarchar(10),
> @.id_stat nvarchar(10),
> @.abst nvarchar(20) ,
> @.job_id nvarchar(20),
> @.date_abs datetime
> as
> insert abstract
> values (cast(cast(rand()*9285 as int)as
> nvarchar(10)),@.abs_name,@.id_reg,@.id_topi
c,@.id_stat,@.abst,@.job_id,@.date_abs
)
> go
> ---
> so, when i execute it with the getdate() it raise the error specified in
> this discussion
> and when i neglect it so that it takes the value as the default value of
> the
> column , it asks for it
> so, how can i solve this ?
> thanx for ur help
> --
> regards
> Maidoo.
>
> "Jens Smeyer" wrote:
>

Can't remove SA account or delete xp_cmdshell ext stored proc?

I'm trying to make my SQL Server a tad more secure, but I'm unable to remove
SA (I'm running Mixed mode) -- can the SA account only be removed when using
windows Authentication? When I try to remove SA I get "selected user
cannot be dropped because the user owns objects". When I try to delect
xp_cmdshell I get the following error "You tried to delete one or more
system objects. They were not deleted."
I must admit, I'm a little confused, I'm trying to implement Microsofts
security recommendations, but either the documention is not
detailed/accurate or I'm missing something?
Any suggestions?
Thanks, Rob.Hi
You can not remove the SA account. Set a very complicated password for it,
write it down and put it in a safe.
For the xp_ look at
http://support.microsoft.com/defaul...kb;en-us;891984
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Rob R. Ainscough" wrote:

> I'm trying to make my SQL Server a tad more secure, but I'm unable to remo
ve
> SA (I'm running Mixed mode) -- can the SA account only be removed when usi
ng
> windows Authentication? When I try to remove SA I get "selected user
> cannot be dropped because the user owns objects". When I try to delect
> xp_cmdshell I get the following error "You tried to delete one or more
> system objects. They were not deleted."
> I must admit, I'm a little confused, I'm trying to implement Microsofts
> security recommendations, but either the documention is not
> detailed/accurate or I'm missing something?
> Any suggestions?
> Thanks, Rob.
>
>
>|||> I'm trying to make my SQL Server a tad more secure, but I'm unable to
> remove SA (I'm running Mixed mode) -- can the SA account only be removed
> when using windows Authentication? When I try to remove SA I get
> "selected user cannot be dropped because the user owns objects". When I
> try to delect xp_cmdshell I get the following error "You tried to delete
> one or more system objects. They were not deleted."
The sa login account cannot be deleted or renameed, nor it can't be revoked
any permission.

> I must admit, I'm a little confused, I'm trying to implement Microsofts
> security recommendations, but either the documention is not
> detailed/accurate or I'm missing something?
I don't think MS ever mentioned droping the sa account (as it can't be
done). Here are recommendations from Operations Guide: "
The sa account in a production environment should be given a complex
password, made up of uppercase and lowercase letters, symbols, spaces, and
numbers. The sa account should have a complex password, even if the SQL
Server is running in only Windows Authentication Mode. A complex password
protects SQL Server from someone easily getting administrative access to SQL
Server. This also protects the server in the event that an administrator
changes the security authentication mode to Mixed Mode.
Do not use the sa login account in a production environment. Instead, place
each DBA's network user account into a Windows group, create a single SQL
Server login account for the group then add the login account to the
sysadmin fixed server role. "
(http://www.microsoft.com/technet/pr...in/sqlops3.mspx
).
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com|||Thank you for the information.
The book I was reading is Microsoft Press and the authors are Ed Robinson
and Michael James Bond.
I have the SA password complex so no worries there.
I guess I'll leave the xp_cmdshell alone as it seems to be more trouble that
it is worth to remove it.
Should I think about installing URLScan ?
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:%23BAAU89pFHA.3112@.TK2MSFTNGP12.phx.gbl...
> The sa login account cannot be deleted or renameed, nor it can't be
> revoked any permission.
>
> I don't think MS ever mentioned droping the sa account (as it can't be
> done). Here are recommendations from Operations Guide: "
> The sa account in a production environment should be given a complex
> password, made up of uppercase and lowercase letters, symbols, spaces, and
> numbers. The sa account should have a complex password, even if the SQL
> Server is running in only Windows Authentication Mode. A complex password
> protects SQL Server from someone easily getting administrative access to
> SQL Server. This also protects the server in the event that an
> administrator changes the security authentication mode to Mixed Mode.
> Do not use the sa login account in a production environment. Instead,
> place each DBA's network user account into a Windows group, create a
> single SQL Server login account for the group then add the login account
> to the sysadmin fixed server role. "
> (http://www.microsoft.com/technet/pr...ityLearning.com
>|||> Should I think about installing URLScan ?
Why don't you ask this in some IIS group, with explanation why do you think
you need it?
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com

Cant register local instance of SQL Server on local server PLUS

I have two servers running SQL Server on the same network and I am
receiving errors registering the various instances as follows:

SERVER1 tried to register the local instance (by netname, ip address
and local)
ERROR Msg: SQL Server does not exist or access denied (ConnectionOpen |
Connect()

SERVER1 trying to register Server2's default instance (by netname, ip
address and local) COMPLETES SUCESSFULLY (THIS INSTANCE CAN BE REGISTER
FROM ANYWHERE PROVIDED THAT YOU HAVE PERMISSION(S)

SERVER2 tried to register the local instance (by netname, ip address
and local)
ERROR Msg: ssl security error -connectionopen(secdoclienthandshake)

SERVER2 trying to register Server1's default instance (by netname, ip
address and local)
ERROR Msg: SQL Server does not exist or access denied (ConnectionOpen |
Connect()

Note: SERVER2's default instance was registered locally before, but I
wanted to change the alias name so I unregistered it and tried to
register it with the new alias. I only change the alias name not the
underlying information which was previously registered. That is when I
started to receive the errors. ALSO I DON'T KNOW IF THIS MATTERS, BUT
D01 WAS CLONED FROM D02 BECAUSE OF A DISK FAILURE. I DID HOWEVER RUN
THE NEWSID UTILITY.

Any Ideas?(war_wheelan@.yahoo.com) writes:
> SERVER1 tried to register the local instance (by netname, ip address
> and local)
> ERROR Msg: SQL Server does not exist or access denied (ConnectionOpen |
> Connect()

Have you ensured that is running?

> SERVER1 trying to register Server2's default instance (by netname, ip
> address and local) COMPLETES SUCESSFULLY (THIS INSTANCE CAN BE REGISTER
> FROM ANYWHERE PROVIDED THAT YOU HAVE PERMISSION(S)
> SERVER2 tried to register the local instance (by netname, ip address
> and local)
> ERROR Msg: ssl security error -connectionopen(secdoclienthandshake)

Could http://support.microsoft.com/kb/322144/EN-US/ apply?

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Erland,

Thanks for the pointer to the Microsoft article. In the future, I will
look on the Microsoft's web site more throughly.

Answer: Someone in my organization must of inadvertently enable
encryption for the client without my knowledge.

Thanks.

can't rebuild msdb

Hello,
After running dbcc checkdb i'm getting:
"..54 consistency errors in database 'msdb'"
i want to rebuild the msdb database via
instmsdb.sql but i can't delete the database...
Which is the right way to do it avoiding rebuild the
master database?
Many Thank in Advance,
Galit.Galit
Do you have a last backup of msdb database?
If you do so try to restote it.
"Galit" <galitm@.ladpc.co.il> wrote in message
news:059101c3b7e1$3cd6f1b0$a301280a@.phx.gbl...
> Hello,
> After running dbcc checkdb i'm getting:
> "..54 consistency errors in database 'msdb'"
> i want to rebuild the msdb database via
> instmsdb.sql but i can't delete the database...
> Which is the right way to do it avoiding rebuild the
> master database?
> Many Thank in Advance,
> Galit.
>|||There's a section in below KB article on how you can detach the msdb database:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;224071
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Galit" <galitm@.ladpc.co.il> wrote in message news:059101c3b7e1$3cd6f1b0$a301280a@.phx.gbl...
> Hello,
> After running dbcc checkdb i'm getting:
> "..54 consistency errors in database 'msdb'"
> i want to rebuild the msdb database via
> instmsdb.sql but i can't delete the database...
> Which is the right way to do it avoiding rebuild the
> master database?
> Many Thank in Advance,
> Galit.
>|||Tibor Karaszi wrote:
> There's a section in below KB article on how you can detach the msdb
> database:
> http://support.microsoft.com/default.aspx?scid=kb;EN-US;224071
following tibors link, after you have detached msdb, if you want to use
a blank msdb, look in the msde sp3 sql2ksp3\MSDE\Setup directory. You
will see a cabinet file sqlrun.cab. From this extract the two files
msdbdata.mdfXXXXXX and msdblog.ldfXXXXXX (both of these files are named
with a string of characters -which I think is a checksum, you can
simply rename them both to their correct respective names msdbdata.mdf
and msdblog.ldfXXXXXX)
Dont overwrite your existing msdb (just in case) rename them to *.old
for them time being till you are happy.
--
Br,
Mark Broadbent
mcdba , mcse+i
=============|||Mark,
Wouldn't running instmsdb.sql also be an option at this stage? (Instead of attaching, as there will
be a problem if the template file doesn't have the same collation as the other system databases...)
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Mark Broadbent" <no-spam-please_mark.broadbent@.virgin.net> wrote in message
news:ecPhp5BuDHA.1680@.TK2MSFTNGP12.phx.gbl...
> Tibor Karaszi wrote:
> > There's a section in below KB article on how you can detach the msdb
> > database:
> >
> > http://support.microsoft.com/default.aspx?scid=kb;EN-US;224071
> following tibors link, after you have detached msdb, if you want to use
> a blank msdb, look in the msde sp3 sql2ksp3\MSDE\Setup directory. You
> will see a cabinet file sqlrun.cab. From this extract the two files
> msdbdata.mdfXXXXXX and msdblog.ldfXXXXXX (both of these files are named
> with a string of characters -which I think is a checksum, you can
> simply rename them both to their correct respective names msdbdata.mdf
> and msdblog.ldfXXXXXX)
> Dont overwrite your existing msdb (just in case) rename them to *.old
> for them time being till you are happy.
> --
> Br,
> Mark Broadbent
> mcdba , mcse+i
> =============|||Tibor Karaszi wrote:
> Mark,
> Wouldn't running instmsdb.sql also be an option at this stage?
> (Instead of attaching, as there will be a problem if the template
> file doesn't have the same collation as the other system databases...)
Yes very good point. Been staring at my monitor for too long #:-)
--
Br,
Mark Broadbent
mcdba , mcse+i
=============|||That's what i did.
Many many thanks,
Galit.
>--Original Message--
>Tibor Karaszi wrote:
>> Mark,
>> Wouldn't running instmsdb.sql also be an option at this
stage?
>> (Instead of attaching, as there will be a problem if
the template
>> file doesn't have the same collation as the other
system databases...)
>Yes very good point. Been staring at my monitor for too
long #:-)
>--
>Br,
>Mark Broadbent
>mcdba , mcse+i
>=============>.
>

Can't Re-attach db to a SQL Server 2000 server

Hi,

I had a database running under a SQL Server 2000 server. I detached it and then attached it to a 2005 Server. I the detached it from the 2005 server and tried to re-attach it to the 2000 server. I got this error message:

You can′t. During attaching the database to the SQL 2k5, the internal structure is migrated to SQL Server 2005 specific requirements which are not understandable for the SQL 2000 instance. This is one way only.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Can't print from SSRS on Citrix

Hi,
We have SSRS 2005 running on SQL Server 2000 on a Citrix network. When I
click the print icon in SSRS, I get an Internet Explorer Security Warning
asking if I want to install Microsoft SQL Server. When I click "Don't
Install" I get the message, "Unable to load client print control." It seems
like there's a component that needs to be installed to enable printing from
SSRS, but I don't know what it is. Can anyone point me in the right
direction here?
--
Thanks,
JeffI think the IE security Warning refers to installing SSRS's report
preview/print activeX control, not the SQL Server itself. When you use IE to
open a report and try to print it the first time, that preview/print ActiveX
control must be downloaded to the computer where IE run and installed. So,
you need to go ahead to allow the installation once for all.
"Jeff Stroope" <JeffStroope@.discussions.microsoft.com> wrote in message
news:6C241737-15F5-4A8C-9FD5-724D650105DC@.microsoft.com...
> Hi,
> We have SSRS 2005 running on SQL Server 2000 on a Citrix network. When I
> click the print icon in SSRS, I get an Internet Explorer Security Warning
> asking if I want to install Microsoft SQL Server. When I click "Don't
> Install" I get the message, "Unable to load client print control." It
> seems
> like there's a component that needs to be installed to enable printing
> from
> SSRS, but I don't know what it is. Can anyone point me in the right
> direction here?
> --
> Thanks,
> Jeff|||Thanks Norman!
--
Thanks,
Jeff
"Norman Yuan" wrote:
> I think the IE security Warning refers to installing SSRS's report
> preview/print activeX control, not the SQL Server itself. When you use IE to
> open a report and try to print it the first time, that preview/print ActiveX
> control must be downloaded to the computer where IE run and installed. So,
> you need to go ahead to allow the installation once for all.
> "Jeff Stroope" <JeffStroope@.discussions.microsoft.com> wrote in message
> news:6C241737-15F5-4A8C-9FD5-724D650105DC@.microsoft.com...
> > Hi,
> >
> > We have SSRS 2005 running on SQL Server 2000 on a Citrix network. When I
> > click the print icon in SSRS, I get an Internet Explorer Security Warning
> > asking if I want to install Microsoft SQL Server. When I click "Don't
> > Install" I get the message, "Unable to load client print control." It
> > seems
> > like there's a component that needs to be installed to enable printing
> > from
> > SSRS, but I don't know what it is. Can anyone point me in the right
> > direction here?
> > --
> > Thanks,
> >
> > Jeff
>
>