Re: SQL Server client components - What is this?

Hi Adams,

Thanks for reply!

I tried the second option first and that didnt' solve my problem. I tried
the first option second, and still no go.

btw the first option only takes up 60MB of hard drive space whereas the
second option takes up 650MB.

I don't think my problem is a Microsoft one as either option finds my remote
SQL Server just fine.

It is probably beyond the scope of this forum, but here's the problem I am
having.

I installed Symantec AntiVirus Corporate Edition on Windows Server 2003. I'm
now trying to install the Reporting Server component and have it use my SQL
Server 2005 named instance.
Per the Symantec instructions, when I get to the installation dialog where
it asks about the database, I select "Install Reporting Server using a
database server on this machine".

Note that this is the same response for an existing SQL server or to have
Symantec install MSDE instead.

The problem is the install doesn't seem to find my SQL Server 2005 named
instance and trys to install MSDE.

Another Symantec option is to "Install Reporting Server using a database
server on another machine" (which is why I started this post because I
needed "SQL Server client components" to do so).

This second option with Symantec at least trys to find the SQL Sever via a
server alias that I created using the
Client Network Utility - cliconfg.exe, but it still fails to find the SQL
Server.



I have no problem with Microsoft SQL Server Management Studio Express
finding the server alias however.



Symantec also requires that SQL Server 2005 be SP1 or greater (I'm at SP2).
Also, authentication must be configured for Mixed Mode (which it wasn't), so
I changed it from Windows Authentication mode to SQL Server and Windows
Authentication mode (and rebooted even though it was probably not
necessary). It also uses the SQL "sa" account, so I rekeyed that password
as I don't know how to tell what it was. It doesn't want the default
instance; but I don't think I have one as when I installed SQL Server, I
keyed in instance "ComputerCreate" instead. It also requires SQL Server
Browser service to be running and I can see it is.



So, I'm at a loss (other than letting it install MSDE, which I hope will
work!).



Thanks again!



Bob.


.

Relevant Pages

  • RE: SBS 2003 SP1 Upgrade - MSDE 2000 Service Pack 4 did not instal
    ... The DSRestore Filter failed to connect to local SAM server. ... registry keys of the Microsoft SQL server and mail to me for analyze. ... This newsgroup only focuses on SBS technical issues. ... SBS 2003 SP1 Upgrade - MSDE 2000 Service Pack 4 did not install ...
    (microsoft.public.windows.server.sbs)
  • RE: How do I get back to base SQL server on my SBS 2003 server?
    ... Can I reinstall the files from another SBS2003 server I manage? ... On my install of SLQ2005, I told it to upgrade all instances. ... Installing SQL Server 2005 WorkGroup Edition in Windows Small Business ... <The server-based applications that were running fine are: McAFee EPO, ...
    (microsoft.public.windows.server.sbs)
  • Re: Installed VS 2005 want to Manage SQL 2005 Server
    ... I Guess I didn't copy it to the Install Source on the Server. ... To change an existing instance of Microsoft SQL Server 2005 to a different edition of SQL Server 2005, you must run SQL Server 2005 Setup from the command prompt and include the SKUUPGRADE=1 parameter. ... The Following Components that you chose to install are already installed onthe machine. ...
    (microsoft.public.sqlserver.setup)
  • Re: Clearer version of my earlier question re sp_grantlogin and sp_grantdbaccess
    ... > Server, doesn't have the right to grant DB access to Domain Groups. ... I didn't know that an SQL Server login as ... > I did the install about a month ago as Domain Admin (default install - mixed ... > site where they let me login as Domain Admin. ...
    (microsoft.public.sqlserver.msde)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
Loading