Showing posts with label tool. Show all posts
Showing posts with label tool. Show all posts

Sunday, March 11, 2012

"server could not be found" problem

hi all,
i downloaded the msde 2000 release A and a graphic tool . i named the
instance as "MSSQLSERVER". installation was success ful. i gave the directory
in the set up parameter to my local drive "C:\vinoth". Installation
automatically creadted a folder named "C:\vinothMSSQL". inside contains the
binn and data files.
when i ry to connect thru the graphic tool in gave server name
"MSSQLSERVER"
user name "sa" , pass word "sa". but it says server not found.i saw
the services in control panel . the MSSQLSERVER is running.
please help to resolve this issue
thanks
vinoth
hi,
vinoth wrote:
> hi all,
> i downloaded the msde 2000 release A and a graphic tool . i
> named the instance as "MSSQLSERVER". installation was success ful. i
> gave the directory in the set up parameter to my local drive
> "C:\vinoth". Installation automatically creadted a folder named
> "C:\vinothMSSQL". inside contains the binn and data files.
> when i ry to connect thru the graphic tool in gave server name
> "MSSQLSERVER"
> user name "sa" , pass word "sa". but it says server not
> found.i saw the services in control panel . the MSSQLSERVER is
> running.
>
please do not open all these threads for the same question...
instead of providing the "MSSQLSERVER" name (which only is the name of the
service) provide the server name (=ComputerName or ComputerName\InstanceName
for named instances)
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Thursday, March 8, 2012

"Report Manager Virtual Directory" link greyed out in config. tool

I've just installed SQL Server 2005 Reporting Services on our development
servers and the "Report Manager Virtual Directory" link is disabled in the
configuration tool. Does anyone know why it is disabled, and how do I enable
it?
Also, the Web Service Identity link displays the following error message
when I click on it:
"There was an error while switching panels. The most likely cause is an
error retrieving WMI properties. The exception details are:
Object reference not set to an instance of an object."
I've verified that the "Windows Management Instrumentation" service is
running.
Background/current configuration:
- OS: Windows Server 2003 (Enterprise) SP1
- Web server separate from database server
- Reporting Svcs 2000 installed and working correctly
- Side-by-side installation of Reporting Svcs 2005 with 2000.
Any help would be greatly appreciated!
Thank you,
SanjayI am having the same issues on Server 2003 with SQL 2005.

Tuesday, March 6, 2012

"Org Chart" Type Tool?

We have a list of companies in our SQL Server 2000 database. We would
like to graphically show the parent companies and subsidiary
companies. I can create a query that will list this information, but
is there a tool that can show this graphically?imani_technology_spam@.yahoo.com wrote:
> We have a list of companies in our SQL Server 2000 database. We would
> like to graphically show the parent companies and subsidiary
> companies. I can create a query that will list this information, but
> is there a tool that can show this graphically?

Visio has a wizard for producing an org chart from a datafile. you should
be able to use it to produce the desired chart.

Kennedy Fraser