I can't view the list of databases on remote site

I have been asked to work on a remote site. I started my EM and tried to
connect to the SQL server on the remote site. I connected just fine (server
had userid/password). But when I open the "Databases" folder I get a "(no
items)" instead of a list of databases. BUT, when I view other folders I
see various items. For example, Security/Login lists lots of login entries.
Just to see what would happen I right-clicked on Databases and clicked All
Tasks/Backup Database and got a list of databases that I was NOT allowed to
backup! But, still no list of databases.
Also, I can view and manipulate the database using Query Analyzer.
Any ideas?
BTW, I am using SQL Server 2000 EM.
TIA,
Larry Woods
P.S. I cross-posted in sqlserver.server because I need an answer ASAP.
Sorry.Hi
Public probably does not have rights to master..sysdatabases but you
probably have a permitted user for the databases but without the permissions
to backup.
John
"lwoods" <larry@.lwoods.com> wrote in message
news:e%23nZpPe0FHA.1032@.TK2MSFTNGP12.phx.gbl...
> I have been asked to work on a remote site. I started my EM and tried to
> connect to the SQL server on the remote site. I connected just fine
> (server
> had userid/password). But when I open the "Databases" folder I get a "(no
> items)" instead of a list of databases. BUT, when I view other folders I
> see various items. For example, Security/Login lists lots of login
> entries.
> Just to see what would happen I right-clicked on Databases and clicked All
> Tasks/Backup Database and got a list of databases that I was NOT allowed
> to
> backup! But, still no list of databases.
> Also, I can view and manipulate the database using Query Analyzer.
> Any ideas?
>
> BTW, I am using SQL Server 2000 EM.
> TIA,
> Larry Woods
> P.S. I cross-posted in sqlserver.server because I need an answer ASAP.
> Sorry.
>
>

I can't view the list of databases on remote site

I have been asked to work on a remote site. I started my EM and tried to
connect to the SQL server on the remote site. I connected just fine (server
had userid/password). But when I open the "Databases" folder I get a "(no
items)" instead of a list of databases. BUT, when I view other folders I
see various items. For example, Security/Login lists lots of login entries.
Just to see what would happen I right-clicked on Databases and clicked All
Tasks/Backup Database and got a list of databases that I was NOT allowed to
backup! But, still no list of databases.
Any ideas?
BTW, I am using SQL Server 2000 EM.
TIA,
Larry WoodsHi,
Could you refresh the database option and see.
As well as login to Query analyzer and execute the below command to get the
databases:-
SP_HELPDB
For backing up try
BACKUP Database <dbanme> to disk='d:\backup\dbname_Oct16.bak' with
INIT,STATS=5
If you get a permission issue contact the database admin.
Thanks
Hari
SQL Server MVP
"lwoods" <larry@.lwoods.com> wrote in message
news:eG$Insd0FHA.2924@.TK2MSFTNGP15.phx.gbl...
>I have been asked to work on a remote site. I started my EM and tried to
>connect to the SQL server on the remote site. I connected just fine
>(server had userid/password). But when I open the "Databases" folder I get
>a "(no items)" instead of a list of databases. BUT, when I view other
>folders I see various items. For example, Security/Login lists lots of
>login entries. Just to see what would happen I right-clicked on Databases
>and clicked All Tasks/Backup Database and got a list of databases that I
>was NOT allowed to backup! But, still no list of databases.
> Any ideas?
>
> BTW, I am using SQL Server 2000 EM.
> TIA,
> Larry Woods
>|||Please try to connect usin Query Analyzer and execute the following
use master
go
select *
from information_schema.schemata
select *
from sysdatabases
This will enable you to display all databases on a server
--
Best Regards
Krystian Zieja / mob
"lwoods" wrote:
> I have been asked to work on a remote site. I started my EM and tried to
> connect to the SQL server on the remote site. I connected just fine (server
> had userid/password). But when I open the "Databases" folder I get a "(no
> items)" instead of a list of databases. BUT, when I view other folders I
> see various items. For example, Security/Login lists lots of login entries.
> Just to see what would happen I right-clicked on Databases and clicked All
> Tasks/Backup Database and got a list of databases that I was NOT allowed to
> backup! But, still no list of databases.
> Any ideas?
>
> BTW, I am using SQL Server 2000 EM.
> TIA,
> Larry Woods
>
>|||Hi
See answer in .programming. Please do not multi-post.
John
"lwoods" <larry@.lwoods.com> wrote in message
news:eG$Insd0FHA.2924@.TK2MSFTNGP15.phx.gbl...
>I have been asked to work on a remote site. I started my EM and tried to
>connect to the SQL server on the remote site. I connected just fine
>(server had userid/password). But when I open the "Databases" folder I get
>a "(no items)" instead of a list of databases. BUT, when I view other
>folders I see various items. For example, Security/Login lists lots of
>login entries. Just to see what would happen I right-clicked on Databases
>and clicked All Tasks/Backup Database and got a list of databases that I
>was NOT allowed to backup! But, still no list of databases.
> Any ideas?
>
> BTW, I am using SQL Server 2000 EM.
> TIA,
> Larry Woods
>|||Will do...
Please note that I DON'T usually do this, but I needed an answer FAST so I
tried to connect to multiple groups. I understand the problem...
Larry
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:%23SZCJEk0FHA.2600@.TK2MSFTNGP10.phx.gbl...
> Hi
> See answer in .programming. Please do not multi-post.
>
> John
> "lwoods" <larry@.lwoods.com> wrote in message
> news:eG$Insd0FHA.2924@.TK2MSFTNGP15.phx.gbl...
>>I have been asked to work on a remote site. I started my EM and tried to
>>connect to the SQL server on the remote site. I connected just fine
>>(server had userid/password). But when I open the "Databases" folder I
>>get a "(no items)" instead of a list of databases. BUT, when I view other
>>folders I see various items. For example, Security/Login lists lots of
>>login entries. Just to see what would happen I right-clicked on Databases
>>and clicked All Tasks/Backup Database and got a list of databases that I
>>was NOT allowed to backup! But, still no list of databases.
>> Any ideas?
>>
>> BTW, I am using SQL Server 2000 EM.
>> TIA,
>> Larry Woods
>sql

I can't view the list of databases on remote site

I have been asked to work on a remote site. I started my EM and tried to
connect to the SQL server on the remote site. I connected just fine (server
had userid/password). But when I open the "Databases" folder I get a "(no
items)" instead of a list of databases. BUT, when I view other folders I
see various items. For example, Security/Login lists lots of login entries.
Just to see what would happen I right-clicked on Databases and clicked All
Tasks/Backup Database and got a list of databases that I was NOT allowed to
backup! But, still no list of databases.
Any ideas?
BTW, I am using SQL Server 2000 EM.
TIA,
Larry WoodsHi,
Could you refresh the database option and see.
As well as login to Query analyzer and execute the below command to get the
databases:-
SP_HELPDB
For backing up try
BACKUP Database <dbanme> to disk='d:\backup\dbname_Oct16.bak' with
INIT,STATS=5
If you get a permission issue contact the database admin.
Thanks
Hari
SQL Server MVP
"lwoods" <larry@.lwoods.com> wrote in message
news:eG$Insd0FHA.2924@.TK2MSFTNGP15.phx.gbl...
>I have been asked to work on a remote site. I started my EM and tried to
>connect to the SQL server on the remote site. I connected just fine
>(server had userid/password). But when I open the "Databases" folder I get
>a "(no items)" instead of a list of databases. BUT, when I view other
>folders I see various items. For example, Security/Login lists lots of
>login entries. Just to see what would happen I right-clicked on Databases
>and clicked All Tasks/Backup Database and got a list of databases that I
>was NOT allowed to backup! But, still no list of databases.
> Any ideas?
>
> BTW, I am using SQL Server 2000 EM.
> TIA,
> Larry Woods
>|||Please try to connect usin Query Analyzer and execute the following
use master
go
select *
from information_schema.schemata
select *
from sysdatabases
This will enable you to display all databases on a server
--
Best Regards
Krystian Zieja / mob
"lwoods" wrote:

> I have been asked to work on a remote site. I started my EM and tried to
> connect to the SQL server on the remote site. I connected just fine (serv
er
> had userid/password). But when I open the "Databases" folder I get a "(no
> items)" instead of a list of databases. BUT, when I view other folders I
> see various items. For example, Security/Login lists lots of login entrie
s.
> Just to see what would happen I right-clicked on Databases and clicked All
> Tasks/Backup Database and got a list of databases that I was NOT allowed t
o
> backup! But, still no list of databases.
> Any ideas?
>
> BTW, I am using SQL Server 2000 EM.
> TIA,
> Larry Woods
>
>|||Hi
See answer in .programming. Please do not multi-post.
John
"lwoods" <larry@.lwoods.com> wrote in message
news:eG$Insd0FHA.2924@.TK2MSFTNGP15.phx.gbl...
>I have been asked to work on a remote site. I started my EM and tried to
>connect to the SQL server on the remote site. I connected just fine
>(server had userid/password). But when I open the "Databases" folder I get
>a "(no items)" instead of a list of databases. BUT, when I view other
>folders I see various items. For example, Security/Login lists lots of
>login entries. Just to see what would happen I right-clicked on Databases
>and clicked All Tasks/Backup Database and got a list of databases that I
>was NOT allowed to backup! But, still no list of databases.
> Any ideas?
>
> BTW, I am using SQL Server 2000 EM.
> TIA,
> Larry Woods
>|||Will do...
Please note that I DON'T usually do this, but I needed an answer FAST so I
tried to connect to multiple groups. I understand the problem...
Larry
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:%23SZCJEk0FHA.2600@.TK2MSFTNGP10.phx.gbl...
> Hi
> See answer in .programming. Please do not multi-post.
>
> John
> "lwoods" <larry@.lwoods.com> wrote in message
> news:eG$Insd0FHA.2924@.TK2MSFTNGP15.phx.gbl...
>

I can't view the list of databases on remote site

I have been asked to work on a remote site. I started my EM and tried to
connect to the SQL server on the remote site. I connected just fine (server
had userid/password). But when I open the "Databases" folder I get a "(no
items)" instead of a list of databases. BUT, when I view other folders I
see various items. For example, Security/Login lists lots of login entries.
Just to see what would happen I right-clicked on Databases and clicked All
Tasks/Backup Database and got a list of databases that I was NOT allowed to
backup! But, still no list of databases.
Any ideas?
BTW, I am using SQL Server 2000 EM.
TIA,
Larry Woods
Hi,
Could you refresh the database option and see.
As well as login to Query analyzer and execute the below command to get the
databases:-
SP_HELPDB
For backing up try
BACKUP Database <dbanme> to disk='d:\backup\dbname_Oct16.bak' with
INIT,STATS=5
If you get a permission issue contact the database admin.
Thanks
Hari
SQL Server MVP
"lwoods" <larry@.lwoods.com> wrote in message
news:eG$Insd0FHA.2924@.TK2MSFTNGP15.phx.gbl...
>I have been asked to work on a remote site. I started my EM and tried to
>connect to the SQL server on the remote site. I connected just fine
>(server had userid/password). But when I open the "Databases" folder I get
>a "(no items)" instead of a list of databases. BUT, when I view other
>folders I see various items. For example, Security/Login lists lots of
>login entries. Just to see what would happen I right-clicked on Databases
>and clicked All Tasks/Backup Database and got a list of databases that I
>was NOT allowed to backup! But, still no list of databases.
> Any ideas?
>
> BTW, I am using SQL Server 2000 EM.
> TIA,
> Larry Woods
>
|||Please try to connect usin Query Analyzer and execute the following
use master
go
select *
from information_schema.schemata
select *
from sysdatabases
This will enable you to display all databases on a server
Best Regards
Krystian Zieja / mob
"lwoods" wrote:

> I have been asked to work on a remote site. I started my EM and tried to
> connect to the SQL server on the remote site. I connected just fine (server
> had userid/password). But when I open the "Databases" folder I get a "(no
> items)" instead of a list of databases. BUT, when I view other folders I
> see various items. For example, Security/Login lists lots of login entries.
> Just to see what would happen I right-clicked on Databases and clicked All
> Tasks/Backup Database and got a list of databases that I was NOT allowed to
> backup! But, still no list of databases.
> Any ideas?
>
> BTW, I am using SQL Server 2000 EM.
> TIA,
> Larry Woods
>
>
|||Hi
See answer in .programming. Please do not multi-post.
John
"lwoods" <larry@.lwoods.com> wrote in message
news:eG$Insd0FHA.2924@.TK2MSFTNGP15.phx.gbl...
>I have been asked to work on a remote site. I started my EM and tried to
>connect to the SQL server on the remote site. I connected just fine
>(server had userid/password). But when I open the "Databases" folder I get
>a "(no items)" instead of a list of databases. BUT, when I view other
>folders I see various items. For example, Security/Login lists lots of
>login entries. Just to see what would happen I right-clicked on Databases
>and clicked All Tasks/Backup Database and got a list of databases that I
>was NOT allowed to backup! But, still no list of databases.
> Any ideas?
>
> BTW, I am using SQL Server 2000 EM.
> TIA,
> Larry Woods
>
|||Will do...
Please note that I DON'T usually do this, but I needed an answer FAST so I
tried to connect to multiple groups. I understand the problem...
Larry
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:%23SZCJEk0FHA.2600@.TK2MSFTNGP10.phx.gbl...
> Hi
> See answer in .programming. Please do not multi-post.
>
> John
> "lwoods" <larry@.lwoods.com> wrote in message
> news:eG$Insd0FHA.2924@.TK2MSFTNGP15.phx.gbl...
>

I can't Start\Stop\Pause SQL Server or SQL Agent from Remote SSMS

Hello,
I do all of my SQL Server administration remotely from my workstation and
i noticed that the green running status symbol was blank on one of my MS SQL
2005 servers. I also noticed that when i right click on the server name my
options for start stop and pause are disabled. I can see all of the tables
and run my queries without any issues. If i log onto the server itself i can
see the status symbols and start\stop\pause the services for the Server and
Agent. Does anyone know why i wouldnt be able to remotely do this or see the
status of the server services? Thanks in advance for the help!
jrunowski (jrunowski@.discussions.microsoft.com) writes:
> I do all of my SQL Server administration remotely from my workstation
> and i noticed that the green running status symbol was blank on one of
> my MS SQL 2005 servers. I also noticed that when i right click on the
> server name my options for start stop and pause are disabled. I can see
> all of the tables and run my queries without any issues. If i log onto
> the server itself i can see the status symbols and start\stop\pause the
> services for the Server and Agent. Does anyone know why i wouldnt be
> able to remotely do this or see the status of the server services?
Normally, you can only stop and start services on the local machine. This
is not specific to SQL Server, but applies to Windows in general. I guess
that you can configure a machine so that services can be stopped and
started from a remote computer, but it sonds like a dare security-wise.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

I can't add a new Reporting Services server registration of a remote server.

I need a help.

This is the scenario:
I have installed on my machine SQLServer 2005 Developer but not reporting services because I don't have IIS.

Now there is server: W2003 + SQL Server 2005 Developer (Complete) + II6.

From the SQL Server Management Studio I can connect to the DatabaseEngine on the server but I cannot connect to Reporting Services or Integrated Services.

On particularly when I try to create a new Server Registration and I "Browse" for a server I can see only the local server!!!

Is this a systemistic, configuration issue? Some advice to solve it?

Thank you in advance.
Marina B.

So you have Win2k3 + SQL 2005 Dev edition (SQL engine & RS) + IIS6, correct? Is RS and SQL installed on the same machine? I am still not very clear about your issue. How did you try to connect and what was the error?|||

Hi,
thank you for the answer.

Yes RS and SQL are installed on the same machine (I mean the brand new W2003 server)...

At the end I was able to solve the problem enabling the SQL server Agent and Browser!!

Thank you

Marina B.

sql

I can't access cubes from excel

I try to register the dll in a remote machine but I couldn't.
Do I need to install something else in the remote machine?whats the message / error u r gett5ing. what exactly have u done?"|||The error is Load Library "C:\........................." failed
GetLastError returns 0x00000485
In the client I haven't installed anything. I only copied the dll and try to register it. Should I install something else?
Thanks in advance|||Does anyone has connected with Excel from other computer than the server?
From the server I can connect.
What whould I install in the computer to connect to the server with Excel?
Thanks in advance.|||

Before you can connect from Excel to the Olap 2005 server, you need to install Microsoft OLEDB for Olap 9.0.

The file you need to install is: pts9.msi - Located in
"En_SQL_DEV_x86_ctp_JUNE2005\Redist\Analysis Services\pts9.msi".

Best regards,

Jakobsgaard

|||Yes I have tried this with no luck.
I think is a version problem, my server is April CTP.
I'll try to install client tools in remote client.sql

I can see an IIS Server but connot see as SQL Server on same PC thru ODBC. Why?

Why is it that I can see a remote server in the browser on a workstation by typing in

ftp://MY_IIS_SERVER

but I cannot see an SQL Server 7.0 database on that same remmote PC. In other words, I cannot manually set up a Data Source Name for that SQL Server.

This happens only on WIN NT 4.0 boxes.First from your workstation can you ping MY_IIS_SERVER, if so then check that you have TCP/IP enabled using the 'Client Network Utility' that comes with SQL Server.

If you can not ping MY_IIS_SERVER, can you ping the IP address, xxx.xxx.xxx. If so then again make sure TCP/IP is enabled and then do 1 of 2.

1) Add an entry in LMHOST for MY_IIS_SERVER xxx.xxx.xxx
or
2) Use SQL Server Client Network Utility and add an alias to MY_IIS_SERVER