cant comm with RS

After installing SP1 Report Manager can't communicate with Report Server.
Error says...
Unable to communicate with report server. Please verify that the report
server is operational.
The report server service is running. I rebooted after installing sp1.
Any ideas?
Thanks,
GaryVerify that you can access http://<machinename>/ReportServer. If you can,
make sure this URL is specified in the config file of Report Manager
(RSWebApplication.config).
--
Dmitry Vasilevsky, SQL Server Reporting Services Developer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
---
"Gary D." <Dean@.nospam.com> wrote in message
news:#IQgxtIhEHA.140@.TK2MSFTNGP12.phx.gbl...
> After installing SP1 Report Manager can't communicate with Report Server.
> Error says...
> Unable to communicate with report server. Please verify that the report
> server is operational.
> The report server service is running. I rebooted after installing sp1.
> Any ideas?
> Thanks,
> Gary
>

Cannot use Windows Authentication to connect to local Sql 2005

Hi,
I am building my workstation again, freshly installing everything.
The OS is Vista Business, 32 bit. I've installed Sql Server 2005
Developer Edition fine and applied service pack 2 successfully. It
seems to run fine, with one exception.
I can't logon using Windows Authentication. I'm a member of the Local
administrators group (as well as a Domain admin), but my domain
\username gets a logon denied error. I can logon just fine with the
sa account, but I prefer Windows Authentication.
Any ideas?
Thanks
AndyAndy (andyj@.med-associates.com) writes:
> I am building my workstation again, freshly installing everything.
> The OS is Vista Business, 32 bit. I've installed Sql Server 2005
> Developer Edition fine and applied service pack 2 successfully. It
> seems to run fine, with one exception.
> I can't logon using Windows Authentication. I'm a member of the Local
> administrators group (as well as a Domain admin), but my domain
> \username gets a logon denied error. I can logon just fine with the
> sa account, but I prefer Windows Authentication.
Did you run the special Vista thing at the end of the SP2 setup? Keep in
mind that on Vista you are normally not admin, only if you request and
confirm. Either start Mgmt Studio with Run As Administrator, or - better -
add your Windows user as a long and grant it CONTROL SERVER.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||On Jul 12, 6:30 pm, Erland Sommarskog <esq...@.sommarskog.se> wrote:
> Did you run the special Vista thing at the end of the SP2 setup? Keep in
> mind that on Vista you are normally not admin, only if you request and
> confirm. Either start Mgmt Studio with Run As Administrator, or - better -
> add your Windows user as a long and grant it CONTROL SERVER.
Yes, I ran the provisioning tool. I added my user specifically and
granted connect and control server, that seems to have worked. I
thought I had tried something similar by adding domain admins, but
that didn't seem to work.
Thanks for the tip.
Andy

Cannot Start SQL Server 2000 after installing Vista

Just installed the Vista Business Upgrade. Now I cannot start SQL Server 200
0
even though my Windows Authentication has not changed. The Service Manager
reports "Access Denied" when I try to start the server.
Do I need to reinstall the server or is there a workaround? I tried the SSMS
but had no success.
--
malcolmHi,
can you elaborate more, is you MSSQL service run under domain or local
account?...However you an use registry rebuild to rebuild sql server
instllation and accounts without effecting your databases.
Omar
"malcolm" wrote:

> Just installed the Vista Business Upgrade. Now I cannot start SQL Server 2
000
> even though my Windows Authentication has not changed. The Service Manager
> reports "Access Denied" when I try to start the server.
> Do I need to reinstall the server or is there a workaround? I tried the SS
MS
> but had no success.
> --
> malcolm|||malcolm (ramartower@.access312.com) writes:
> Just installed the Vista Business Upgrade. Now I cannot start SQL Server
> 2000 even though my Windows Authentication has not changed. The Service
> Manager reports "Access Denied" when I try to start the server.
> Do I need to reinstall the server or is there a workaround? I tried the
> SSMS but had no success.
You could try to start it from Computer Management, or run Service Manager
by running as Admin. I guess the first showstopper is the UAC. But the
more basic problem is that SQL 2000 is not supported on Vista, so you may
not get it work at all. If you need the databases, you will need to find
another machine with a different operating system, or upgrade to SQL 2005.
(And you need SP2 of SQL 2005 to run on Vista.)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

cannot start or verify that SQL 2005 is running

Hi,

I am new to sql 2005.

I have installed a trial version of 2005 enterprise edition.

After installing I went to Management Studio. I noticed that the server name

dropdown menu was blank so I tried to browse. No server names appear under local

or network servers. I then went to configuration manager and noticed that

although client protocols are listed under SQL client native config,

SQL server 2005 services and sql server 2005 network config are both blank. Is SQL

installed correctly? I hope this is enough info to illicit a helpful response.

Thank You.

Problem solved. I went to add remove apps and clicked change

on Microsoft SQL Server 2005 button. I am not sure what Microsoft

SQL Server Native Client is so I didn't mess with it. I saw that no instances

were listed under SQL Server 2005 instances so I clicked away until I had

added an instance - MSSQLSERVER. I am going to be using .net 2.0 framework

objects to connect to SQL so I am not sure if I messed up by Not installing in

mixed mode. Any advice on the mixed mode issue would be appreciated.

|||If you have no need for mixed mode, then don't install it. It kind of sounds like you don't so no worries.

Cannot select "Server Database Engine" when installing SQL Server Sep 2005 CTP

I am trying to install SQL Server Sep 2005 CTP - ENTERPRISE, there are
check boxes on the Components to Install page of the Microsoft SQL Server Installation Wizard to select component groups for your SQL Server installation, they are all disabled, except "Workstation Components, Development Tools, and SQL Server Books Online".
I tried installing and after it finishes, there are no SQL instances.... What am I doing wrong? Please help. Thank you.

1. What is your operating systems. SQL Server 2005 Enterprise needs server operating systems such as W2K SP4, W2K3 EE SP1, LH Server.

2. What is the instance name you select? If you have already installed SQL Engine with instance name "SQLEngine" and now you restart setup with the same instance name "SQLEngine", then SQL Engine cannot be selected as it is already installed with under the specified instance name. You can only choose other components, which has not been installed under the specified instance name or other shared common components.

Note, "SQLEngine" is a fabricated instance name.

Cannot select "Server Database Engine" when installing SQL Server Sep 2005 CTP

I am trying to install SQL Server Sep 2005 CTP - ENTERPRISE, there are
check boxes on the Components to Install page of the Microsoft SQL Server Installation Wizard to select component groups for your SQL Server installation, they are all disabled, except "Workstation Components, Development Tools, and SQL Server Books Online".
I tried installing and after it finishes, there are no SQL instances.... What am I doing wrong? Please help. Thank you.

1. What is your operating systems. SQL Server 2005 Enterprise needs server operating systems such as W2K SP4, W2K3 EE SP1, LH Server.

2. What is the instance name you select? If you have already installed SQL Engine with instance name "SQLEngine" and now you restart setup with the same instance name "SQLEngine", then SQL Engine cannot be selected as it is already installed with under the specified instance name. You can only choose other components, which has not been installed under the specified instance name or other shared common components.

Note, "SQLEngine" is a fabricated instance name.