Showing posts with label screen. Show all posts
Showing posts with label screen. Show all posts

Thursday, March 8, 2012

cannot upload reports: pls help

Hi,
I just installed reporting service on a new box and it contains SQL server
2000 also. But, when I get into the manager screen, the options such as New
folder, Upload files etc are all disabled. The hyperlink appears but nothing
happens when i click on them..
Any suggestions?
Thanks in advance for your help.
-sDid you ever figure this out? I too have the same problem.
Thanks.
"San" wrote:
> Hi,
> I just installed reporting service on a new box and it contains SQL server
> 2000 also. But, when I get into the manager screen, the options such as New
> folder, Upload files etc are all disabled. The hyperlink appears but nothing
> happens when i click on them..
> Any suggestions?
> Thanks in advance for your help.
> -s
>
>

Wednesday, March 7, 2012

Cannot start up SQL 2000

I just installed the SQL Server 2000 with custom option:
Druing the setup, in the screen of Service Account, I use my Windows machine
login (this is the login I use when the pc is started up), ie 'Alan' instead
of LocalSystem.
After installation, I config the Microsoft Search service by using the same
account, ie 'Alan' rather than the LocalSystem. So both Microsoft Search
Service and MSSQL Server use the 'Alan' login, in Control Panel - Admin
Tools - Services show both 'Log On As' .\Alan.
However, when I tried to run the EM, click the server instance, there is an
error:
'A connection cannot be established to 'Alan2'.
Reason: login failed for user 'sa'.
Reason:Not associated with trusted SQL Server connection.
Please verify SQL Server is running and check your SQL Server registration
properties and try again.'
I checked both MSSQL Server, SQLServer Agent are started.
Can someone give me any idea please?In EM, right-click on the server and then Edit Registration Properties.
Have it use Windows authentication.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"Man Utd" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:eet8EBKhGHA.1612@.TK2MSFTNGP04.phx.gbl...
I just installed the SQL Server 2000 with custom option:
Druing the setup, in the screen of Service Account, I use my Windows machine
login (this is the login I use when the pc is started up), ie 'Alan' instead
of LocalSystem.
After installation, I config the Microsoft Search service by using the same
account, ie 'Alan' rather than the LocalSystem. So both Microsoft Search
Service and MSSQL Server use the 'Alan' login, in Control Panel - Admin
Tools - Services show both 'Log On As' .\Alan.
However, when I tried to run the EM, click the server instance, there is an
error:
'A connection cannot be established to 'Alan2'.
Reason: login failed for user 'sa'.
Reason:Not associated with trusted SQL Server connection.
Please verify SQL Server is running and check your SQL Server registration
properties and try again.'
I checked both MSSQL Server, SQLServer Agent are started.
Can someone give me any idea please?

Cannot start up SQL 2000

I just installed the SQL Server 2000 with custom option:
Druing the setup, in the screen of Service Account, I use my Windows machine
login (this is the login I use when the pc is started up), ie 'Alan' instead
of LocalSystem.
After installation, I config the Microsoft Search service by using the same
account, ie 'Alan' rather than the LocalSystem. So both Microsoft Search
Service and MSSQL Server use the 'Alan' login, in Control Panel - Admin
Tools - Services show both 'Log On As' .\Alan.
However, when I tried to run the EM, click the server instance, there is an
error:
'A connection cannot be established to 'Alan2'.
Reason: login failed for user 'sa'.
Reason:Not associated with trusted SQL Server connection.
Please verify SQL Server is running and check your SQL Server registration
properties and try again.'
I checked both MSSQL Server, SQLServer Agent are started.
Can someone give me any idea please?In EM, right-click on the server and then Edit Registration Properties.
Have it use Windows authentication.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"Man Utd" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:eet8EBKhGHA.1612@.TK2MSFTNGP04.phx.gbl...
I just installed the SQL Server 2000 with custom option:
Druing the setup, in the screen of Service Account, I use my Windows machine
login (this is the login I use when the pc is started up), ie 'Alan' instead
of LocalSystem.
After installation, I config the Microsoft Search service by using the same
account, ie 'Alan' rather than the LocalSystem. So both Microsoft Search
Service and MSSQL Server use the 'Alan' login, in Control Panel - Admin
Tools - Services show both 'Log On As' .\Alan.
However, when I tried to run the EM, click the server instance, there is an
error:
'A connection cannot be established to 'Alan2'.
Reason: login failed for user 'sa'.
Reason:Not associated with trusted SQL Server connection.
Please verify SQL Server is running and check your SQL Server registration
properties and try again.'
I checked both MSSQL Server, SQLServer Agent are started.
Can someone give me any idea please?