can't start SQL Server Analysis Services

Hi I am using SQL 2005 but when I go to the SQL Server Configuration manager
and try to start the SQL Server Analysis Services, I get the error message
Requiest failed or the service did not respond in a timely fashion.
In the event log it looks like there was a problem with login,
The SQL Server Analysis Services (MSSQLSERVER) service failed to start due
to the following error:
The service did not start due to a logon failure.
I currently have the logon as domain\username. Anyhow just wondering how to
fix this?
thanks Paul.
--
Paul G
Software engineer.got it working, for some reason the password was not set correctly, so just
used the properties box to correct it.
--
Paul G
Software engineer.
"Paul" wrote:
> Hi I am using SQL 2005 but when I go to the SQL Server Configuration manager
> and try to start the SQL Server Analysis Services, I get the error message
> Requiest failed or the service did not respond in a timely fashion.
> In the event log it looks like there was a problem with login,
> The SQL Server Analysis Services (MSSQLSERVER) service failed to start due
> to the following error:
> The service did not start due to a logon failure.
> I currently have the logon as domain\username. Anyhow just wondering how to
> fix this?
> thanks Paul.
> --
> Paul G
> Software engineer.sql

can't start server

I can't seem to start SQL Server 7.0. I open up the
service manager, click the "start" button, and nothing
happens! It was working fine, and now all of a sudden,
it won't work. Does anyone have any suggestions?Hi,
Go to command prompt and start the SQL Server.
SQLSERVR -c
This will give you the detailed information for the startup issue. With that
u will be able to trouble shoot.
Thanks
Hari
MCDBA
"Eric" <ethomp99@.yahoo.com> wrote in message
news:270401c4a42d$56275b80$a301280a@.phx.gbl...
>I can't seem to start SQL Server 7.0. I open up the
> service manager, click the "start" button, and nothing
> happens! It was working fine, and now all of a sudden,
> it won't work. Does anyone have any suggestions?sql

can't start server

I can't seem to start SQL Server 7.0. I open up the
service manager, click the "start" button, and nothing
happens! It was working fine, and now all of a sudden,
it won't work. Does anyone have any suggestions?
Hi,
Go to command prompt and start the SQL Server.
SQLSERVR -c
This will give you the detailed information for the startup issue. With that
u will be able to trouble shoot.
Thanks
Hari
MCDBA
"Eric" <ethomp99@.yahoo.com> wrote in message
news:270401c4a42d$56275b80$a301280a@.phx.gbl...
>I can't seem to start SQL Server 7.0. I open up the
> service manager, click the "start" button, and nothing
> happens! It was working fine, and now all of a sudden,
> it won't work. Does anyone have any suggestions?

Can't start RS2005

Hi,
I am new and just installed SS2005 Developer Edition on a server.
I can see the following services on Configuration Manager -> Services
Integration Services - Running
FullText Search - Running
SQL Server - Running
Analysis Service - Running
Reporting Service - Stopped
Browser - Running
Agent - Running
I tried to start RS, it ends up with error:
The request failed or the service did not respond in a timely fashion.
Consult the event log or other applicable error logs for details.
Checked the event log:
- The Remote Procedure Call (RPC) service failed to start
- Service cannot be started.
Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException:
=E7=84=A1=E6=B3=95=E8=BE=A8=E8=AD=98=E4=BD=BF=E7=94=A8=E8=80=85=E6=88=96=E7= =BE=A4=E7=B5=84=E5=90=8D=E7=A8=B1 'TPEW2KDM\ASPNET'=E3=80=82
at Microsoft.ReportingServices.Library.Native.NameToSid(String name)
at
Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServ= er(Boolean
firstTime)
at
Microsoft.ReportingServices.Library.ServiceAppDomainController.Start(Boolean
firstTime)
at
Microsoft.ReportingServices.NTService.ReportService.OnStart(String[]
args)
at
System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object
state)
- The report server database is an invalid version.
I am wondering why reporting service is the only service that's not
running.
Any comments are highly appreciated.Still waiting for advice anyone? tks|||did you find a solution to this problem ?
From http://www.developmentnow.com/g/115_2006_1_0_0_679705/Cant-start-RS2005.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com

Cant start report server

Hey all. I'm using SQL server Express and I've installed the Report service. When I go into the reporting services configuration manager and I want to start the service, the system won't let me. Here is the error

System.ServiceProcess.TimeoutException: Time out has expired and the operation has not been completed.
at System.ServiceProcess.ServiceController.WaitForStatus(ServiceControllerStatus desiredStatus, TimeSpan timeout)
at ReportServicesConfigUI.Panels.ServerInformationPanel.StartStopServiceTask(Boolean start)

I just can't seem to be able to start the service.

Can you plz help?

Thanks

Hi,

Based on my understanding, this error message is caused by the permission issue. You should take a look at the Report Server logs, and make sure you are configuring locally and you are administrator on the machine. And re-modify your reporting service configuration in the following way:

1. Created ReportService database using Report Service Configuration
2. Edited your personal account to Web Service Account in rsreportserver.config
3. Used rsconfig utility to encrypt the connection and account information
4. Edited your personal account to <processModel userName=" " >

If the problem still exists, you should try the following methods.

Set the Report Server Web service and Report Manager to use the same application pool.

|||

Thank you for your answer. But how can I create a reportservice database if I can't connect to the service?

++ Where do I go to

Set the Report Server Web service and Report Manager to use the same application pool.

Add the security account to the SQLServer2005ReportingServicesWebServiceUser$InstanceName group that you use for the application pool identity.

|||

Hi,

Set the Report Server Web service and Report Manager to use the same application pool.

Add the security account to the SQLServer2005ReportingServicesWebServiceUser$InstanceName group that you use for the application pool identity.

can't start mssqlserver

I installed a copy of SQL server 2005 on a Win 2003 machine. I connected remotely from another machine and started Sql Server Configuration manager. The MSSQLServer is stopped. So, I click to start and it failed. The error it gave me was that it time out. I am new to SQL 2005 and I thought the next step after installing was to configure. Can anyone help me please.

Check in the SQL Server log file for any info. If SQL received the startup request, the log will show why the timeout occurred. Presumably there was a configuration problem that caused startup to fail.

Also check the network configuration. I believe local connections require shared memory to be enabled.

|||Hi, in addition to the aother post, try to make a snapshot of your event log if you can't figure out the problem and send the appropiate parts (like starting the service which breaks) to this forum again.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Can't see the Report Manager page

Hi There,

I have installed the Sql Server 2005 reporting services and I see that two default directories being created in IIS (Report and ReportServer..). For some reason, if I type http://localhost/reports, I am unable to see the report manager homepage. Can anybody suggest me if I need to configure any more stuff to see the report manager?

I enabled the anonymous authentication and still cannot see....

I can see the webservice however by typing http://localhost/reportserver...

Any suggestions are greatly apprecaited...

Thanks.

Sam.

I got it. I had to set up the reportserver to be accessible anonymous along with Reports.

Thanks.

sql

cant see Report manager page

Hi Friends
we've report server (sql server 2005 standard edi) on win 2003 server. i can see report manager page (i.e. http://servername/reports) from my machine but some of out users cant see this page !!
all they can see is "sql server reporting services" text nothing else. no reports and no models ertc.,

i assume its something to do with rights issue. where can i set these rights so that all users within our domain can see and create reports off report server page.
Thanks for your help.From the main page, select the properties tab, then select the security sub-tab. You can grant the necessary permissions to any group or user there.|||Thanks for that Brian. I just tried that but did not work.
our domain name is "yabba.co.nz" so i added domain by clicking "new role assignment" but to no avail.
so i tried add one of users ,who is having this problem like "yabba.co.nz\Peter" but got following error
The user or group name 'yabba.co.nz/Peter' is not recognized. (rsUnknownUserName)

any ideas please.
Thanks for your help|||You should be specifying the user or group name the same way you would for an ACL, such as for the file system. If you are using a domain user, the report server machine must be a part of that domain.|||Thank you very much Brian.
That really helped . now all our users could view report manager page and they can view and run reports now :)

one thing remained though, they cant see "Report builder" link .i tried to assign all roles (i.e. browser,content manager etc.,) but still did not help.
any ideas on this one.
Thanks for your help again :)|||

The user must have "Execute Report Definition" permission. This is a system level permission that can be configured from the "Site Settings" link at the top of Report Manager.

|||Thank you very much Brian.
That worked like a charm. Thanks for all your help :)

Can't see mapped drives

Hi,
Am unable to see mapped drive when going to restore db in
sql 2000 enterprise manager. Service is set to start
with a lan acct. acct is in the local machine admin grp
and remote machine admin grp.
Any suggestions:-)
Thanks in advanceDo not use mapped drives for backup\restore with SQL server. Use UNC names
instead. SQL may or may not see a mapped drive correctly but will always
find a UNC share that it has permission and connection to.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
<anonymous@.discussions.microsoft.com> wrote in message
news:8f9b01c40541$3ade3230$a301280a@.phx.gbl...
> Hi,
> Am unable to see mapped drive when going to restore db in
> sql 2000 enterprise manager. Service is set to start
> with a lan acct. acct is in the local machine admin grp
> and remote machine admin grp.
> Any suggestions:-)
> Thanks in advance|||Hi,
You cant see the mapped drives in Enterprise manager. Rather you can
directly mention the UNC path directly in Enterprise manager or use
Restore database command from Query Analyzer.
Restore database <dbname> from disk='\\machinename\share\backupfile.bak'
with stats=10 With
Move 'logicaldatafile' to physcaldatafile',
Move 'logiallogfile' to physcallogfile'
stats will show the restore status
Thanks
Hari
MCDBA
<anonymous@.discussions.microsoft.com> wrote in message
news:8f9b01c40541$3ade3230$a301280a@.phx.gbl...
> Hi,
> Am unable to see mapped drive when going to restore db in
> sql 2000 enterprise manager. Service is set to start
> with a lan acct. acct is in the local machine admin grp
> and remote machine admin grp.
> Any suggestions:-)
> Thanks in advance|||It is possible to get SQL Server to use mapped network drives, through the u
se of trace flag 1807.
Check out knowledge base article #304261 for full details
http://support.microsoft.com/defaul...1&Product=sql2k

Can't see database in enterprise manager

When connecting to server using enterprise manager it
shows tree view but won't allow me to see datbases? I f I
stop and start the service it says something lik ean error
1056(an instance of service already running) can't find a
solution anywhere getting desperate. pleas ehelp A.S.A.P.Have you logged on using sa ? Is is the same kinda view when you open
Enterprise Manager from other clients that have connectivity to the server ?
What about from Query Analyser ? Can you connect and do you see all
databases ?
"johnboy" <anonymous@.discussions.microsoft.com> wrote in message
news:12c901c4a2e9$ba258fc0$7d02280a@.phx.gbl...
> When connecting to server using enterprise manager it
> shows tree view but won't allow me to see datbases? I f I
> stop and start the service it says something lik ean error
> 1056(an instance of service already running) can't find a
> solution anywhere getting desperate. pleas ehelp A.S.A.P.|||"johnboy" <anonymous@.discussions.microsoft.com> wrote in message
news:12c901c4a2e9$ba258fc0$7d02280a@.phx.gbl...
> When connecting to server using enterprise manager it
> shows tree view but won't allow me to see datbases? I f I
> stop and start the service it says something lik ean error
> 1056(an instance of service already running) can't find a
> solution anywhere getting desperate. pleas ehelp A.S.A.P.
Log in as SA user and check read permissions in sysdatabase table in master
database.
Dra

Can't see database in enterprise manager

When connecting to server using enterprise manager it
shows tree view but won't allow me to see datbases? I f I
stop and start the service it says something lik ean error
1056(an instance of service already running) can't find a
solution anywhere getting desperate. pleas ehelp A.S.A.P.
Have you logged on using sa ? Is is the same kinda view when you open
Enterprise Manager from other clients that have connectivity to the server ?
What about from Query Analyser ? Can you connect and do you see all
databases ?
"johnboy" <anonymous@.discussions.microsoft.com> wrote in message
news:12c901c4a2e9$ba258fc0$7d02280a@.phx.gbl...
> When connecting to server using enterprise manager it
> shows tree view but won't allow me to see datbases? I f I
> stop and start the service it says something lik ean error
> 1056(an instance of service already running) can't find a
> solution anywhere getting desperate. pleas ehelp A.S.A.P.
|||"johnboy" <anonymous@.discussions.microsoft.com> wrote in message
news:12c901c4a2e9$ba258fc0$7d02280a@.phx.gbl...
> When connecting to server using enterprise manager it
> shows tree view but won't allow me to see datbases? I f I
> stop and start the service it says something lik ean error
> 1056(an instance of service already running) can't find a
> solution anywhere getting desperate. pleas ehelp A.S.A.P.
Log in as SA user and check read permissions in sysdatabase table in master
database.
Dra

Can't see content tab or properties tab.

An administrator installed reporting services. I went to the url to the
report manager, I cannot see anything on the home page, no tabs at all. How
do I set it up to show me these tabs?
Thanks,
Rick.Log into the machine locally as a member of the local administartor's group.
You'll be able to assign permissions either using the SiteSettings-->Manage
site wide security or through the properties tab
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"Rick" <noodle@.noodle.com> wrote in message
news:%23cSbAlPaEHA.644@.tk2msftngp13.phx.gbl...
> An administrator installed reporting services. I went to the url to the
> report manager, I cannot see anything on the home page, no tabs at all.
> How
> do I set it up to show me these tabs?
> Thanks,
> Rick.
>

Can't see all drives in a cluster within Enterprise manager

When I am in Enterprise Manager to create a new database, I click on the location of the data and log file, I only see 1 drive where SQL Server was installed...How do I get SQL Server to display all the other drives the node owns in the cluster? I can view them under My Computer and within the Cluster Administrator. Each node owns it's own drives. But I should be able to see all drives owned by the node when browsing to create a new database so I can assign different drives for the Data and Log files.
Any ideas would be helpful
Thanks
WarrenPerhaps you have to restart SQL Server?
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Warren Tyler" <anonymous@.discussions.microsoft.com> wrote in message
news:B873E1EB-030A-41F4-910A-1F15FE1A2D7B@.microsoft.com...
> When I am in Enterprise Manager to create a new database, I click on the location of the data and
log file, I only see 1 drive where SQL Server was installed...How do I get SQL Server to display all
the other drives the node owns in the cluster? I can view them under My Computer and within the
Cluster Administrator. Each node owns it's own drives. But I should be able to see all drives
owned by the node when browsing to create a new database so I can assign different drives for the
Data and Log files..
> Any ideas would be helpful,
> Thanks,
> Warren|||Dear Tibor
I will try it and let you know
Thanks
Warren|||Dear Tibor,
Same result. Still can't see all the drives?|||Sorry, that was just a wild guess...
Re-reading your original post, you say that you only see the drive where SQL Server was installed.
Do you mean the local drive? That would imply, methinks, that you didn't install the SQL Server as a
clustered SQL Server. SQL Server should not show the local drives when creating databases etc, it
should only show the "shared" drives.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Warren Tyler" <anonymous@.discussions.microsoft.com> wrote in message
news:7B544C67-CF57-4D8B-B726-3C259486A975@.microsoft.com...
> Dear Tibor,
> Same result. Still can't see all the drives?|||I found the answer. After a successful install of SQL Server on the cluster and testing fail-over. You have to take one node off-line and add dependencies (IE. the other drives) to the SQl Server , bring that node back on-line and repeat for the other node. This should be your last step then, re-test failover and moving the cluster between nodes
Whew
Thanks
Warren

Can't see all drives in a cluster within Enterprise manager

When I am in Enterprise Manager to create a new database, I click on the loc
ation of the data and log file, I only see 1 drive where SQL Server was inst
alled...How do I get SQL Server to display all the other drives the node own
s in the cluster? I can vi
ew them under My Computer and within the Cluster Administrator. Each node o
wns it's own drives. But I should be able to see all drives owned by the no
de when browsing to create a new database so I can assign different drives f
or the Data and Log files..
Any ideas would be helpful,
Thanks,
WarrenPerhaps you have to restart SQL Server?
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ls
erver
"Warren Tyler" <anonymous@.discussions.microsoft.com> wrote in message
news:B873E1EB-030A-41F4-910A-1F15FE1A2D7B@.microsoft.com...

quote:

---

> When I am in Enterprise Manager to create a new database, I click on the location of the d
ata and

---

log file, I only see 1 drive where SQL Server was installed...How do I get S
QL Server to display all
the other drives the node owns in the cluster? I can view them under My Com
puter and within the
Cluster Administrator. Each node owns it's own drives. But I should be abl
e to see all drives
owned by the node when browsing to create a new database so I can assign dif
ferent drives for the
Data and Log files..

quote:

---

> Any ideas would be helpful,
> Thanks,
> Warren

---

|||Dear Tibor,
I will try it and let you know.
Thanks,
Warren|||Dear Tibor,
Same result. Still can't see all the drives?|||Sorry, that was just a wild guess...
Re-reading your original post, you say that you only see the drive where SQL
Server was installed.
Do you mean the local drive? That would imply, methinks, that you didn't ins
tall the SQL Server as a
clustered SQL Server. SQL Server should not show the local drives when creat
ing databases etc, it
should only show the "shared" drives.
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ls
erver
"Warren Tyler" <anonymous@.discussions.microsoft.com> wrote in message
news:7B544C67-CF57-4D8B-B726-3C259486A975@.microsoft.com...

quote:

---

> Dear Tibor,
> Same result. Still can't see all the drives?

---

|||I found the answer. After a successful install of SQL Server on the cluster
and testing fail-over. You have to take one node off-line and add dependen
cies (IE. the other drives) to the SQl Server , bring that node back on-line
and repeat for the other n
ode. This should be your last step then, re-test failover and moving the cl
uster between nodes.
Whew!
Thanks,
Warren

Can't Run Query Analyzer

When trying to access Query Analyzer from Enterprise Manager, I receive the
error, "The specified file was not found". I don't know what happened, as it
was working fine yesterday, and I've made no changes to the system in the
interim. SQL Server 2000 Standard Edition running under Win 2003 Server, sp1.
Any immediate thoughts would be welcome.Hi
You may want to check out http://tinyurl.com/85xwc, you could re-add it as
an external tool or re-install the client tools should fix it.
John
"Mike Kelly" <Mike Kelly@.discussions.microsoft.com> wrote in message
news:D0FE4485-A324-44C3-B4EC-59E996B84987@.microsoft.com...
> When trying to access Query Analyzer from Enterprise Manager, I receive
> the
> error, "The specified file was not found". I don't know what happened, as
> it
> was working fine yesterday, and I've made no changes to the system in the
> interim. SQL Server 2000 Standard Edition running under Win 2003 Server,
> sp1.
> Any immediate thoughts would be welcome.

Can't Run Query Analyzer

When trying to access Query Analyzer from Enterprise Manager, I receive the
error, "The specified file was not found". I don't know what happened, as it
was working fine yesterday, and I've made no changes to the system in the
interim. SQL Server 2000 Standard Edition running under Win 2003 Server, sp1
.
Any immediate thoughts would be welcome.Hi
You may want to check out http://tinyurl.com/85xwc, you could re-add it as
an external tool or re-install the client tools should fix it.
John
"Mike Kelly" <Mike Kelly@.discussions.microsoft.com> wrote in message
news:D0FE4485-A324-44C3-B4EC-59E996B84987@.microsoft.com...
> When trying to access Query Analyzer from Enterprise Manager, I receive
> the
> error, "The specified file was not found". I don't know what happened, as
> it
> was working fine yesterday, and I've made no changes to the system in the
> interim. SQL Server 2000 Standard Edition running under Win 2003 Server,
> sp1.
> Any immediate thoughts would be welcome.

Can't Run Query Analyzer

When trying to access Query Analyzer from Enterprise Manager, I receive the
error, "The specified file was not found". I don't know what happened, as it
was working fine yesterday, and I've made no changes to the system in the
interim. SQL Server 2000 Standard Edition running under Win 2003 Server, sp1.
Any immediate thoughts would be welcome.
Hi
You may want to check out http://tinyurl.com/85xwc, you could re-add it as
an external tool or re-install the client tools should fix it.
John
"Mike Kelly" <Mike Kelly@.discussions.microsoft.com> wrote in message
news:D0FE4485-A324-44C3-B4EC-59E996B84987@.microsoft.com...
> When trying to access Query Analyzer from Enterprise Manager, I receive
> the
> error, "The specified file was not found". I don't know what happened, as
> it
> was working fine yesterday, and I've made no changes to the system in the
> interim. SQL Server 2000 Standard Edition running under Win 2003 Server,
> sp1.
> Any immediate thoughts would be welcome.

cant restore database from .a .bak file in enterprise manager

Hi Everybody,

I use MS SQL server 2000 enterprise manager on a windows server 2003.

I created a new database in enterprise manager, and try to restore the new database from a .bak file.
I went to -->restore database. I checked"from device"and select the right path to the .bak file.
Then I click ok, but there is anerrorpop up."tend to override existing database",
so I went to -->option, and checked"force override existing database". then I click ok, but get an error look like this http://ewwa.lo7.net/error.JPG

I thought it was a problem with my .bak file. So I try to use another .bak file which I am sure it is 100% good. It prompt the restore issucessfully. But when I checked the db, therenothing there(No tables).

I think there must be something wrong with my enterprise manager's configuration.

Do you know what happen with my enterprise manager? Thank you a lot in advance:)!!

barbarallama:

Hi Everybody,

I use MS SQL server 2000 enterprise manager on a windows server 2003.

I created a new database in enterprise manager, and try to restore the new database from a .bak file.
I went to -->restore database. I checked"from device"and select the right path to the .bak file.
Then I click ok, but there is anerrorpop up."tend to override existing database",
so I went to -->option, and checked"force override existing database". then I click ok, but get an error look like this http://ewwa.lo7.net/error.JPG

You tried to create a new database by restoring from a .bak file, right? Then there are some tips you may know:

1. Specify a database name that differs from existing databases for the new database, then the restore will create a new database rather than attemping to override existing database.

2. In the Options tab, make sure all values in the 'Move to physical file name' column point to a valid file path. If any path dose not exist, an error likeshttp://ewwa.lo7.net/error.JPG will be raised.

barbarallama:

I thought it was a problem with my .bak file. So I try to use another .bak file which I am sure it is 100% good. It prompt the restore issucessfully. But when I checked the db, therenothing there(No tables).

Not sure why this happened. Can you perform queries on the database? If yes, login as 'sa' and perform a query like this :

select * from sysobjects where xtype <>'S'

|||Hi Lori,
That is really helpful, the problem is the path is invalid. Thanks A Lot!

Can't Register SQLServer in Enterprise Manager

I have been trying to register a SQL server in my server
group in Enterprise Manager but it cannot find the
server. The SQL server (SQLServer2k) resides on a server
machine running WinServer2K. I am trying to gain access
from a remote PC running Win2k.
I am able to see the server in the list of available
servers when I run the registration wizard. But when I
finish the wizard it fails to establish a connection. I
have double checked login ID and password. I even set up
another instance of a SQL server on the server machine.
When I start the wizard again to register the new server,
I see the new server in the available list but I can't
connect to it either.
I uninstalled and reinstalled SQLServer2k on both the
server and the client PC. Still no luck. I can establish
ethernet connection between the two machines so it doesn't
appear to be a network problem, especially when I can see
the servers in my availability list.
Any ideas on why this is happening and how to fix?
Roger.
We had some issues in our group, where the default database specified in the
Login was no longer attached to the SQL Server.
This caused the Server Registration to fail.
HTH, Amol.
"Roger Denison" <anonymous@.discussions.microsoft.com> wrote in message
news:92c101c43367$84ec1910$a501280a@.phx.gbl...
> I have been trying to register a SQL server in my server
> group in Enterprise Manager but it cannot find the
> server. The SQL server (SQLServer2k) resides on a server
> machine running WinServer2K. I am trying to gain access
> from a remote PC running Win2k.
> I am able to see the server in the list of available
> servers when I run the registration wizard. But when I
> finish the wizard it fails to establish a connection. I
> have double checked login ID and password. I even set up
> another instance of a SQL server on the server machine.
> When I start the wizard again to register the new server,
> I see the new server in the available list but I can't
> connect to it either.
> I uninstalled and reinstalled SQLServer2k on both the
> server and the client PC. Still no luck. I can establish
> ethernet connection between the two machines so it doesn't
> appear to be a network problem, especially when I can see
> the servers in my availability list.
> Any ideas on why this is happening and how to fix?
> Roger.
>

Can't Register SQLServer in Enterprise Manager

I have been trying to register a SQL server in my server
group in Enterprise Manager but it cannot find the
server. The SQL server (SQLServer2k) resides on a server
machine running WinServer2K. I am trying to gain access
from a remote PC running Win2k.
I am able to see the server in the list of available
servers when I run the registration wizard. But when I
finish the wizard it fails to establish a connection. I
have double checked login ID and password. I even set up
another instance of a SQL server on the server machine.
When I start the wizard again to register the new server,
I see the new server in the available list but I can't
connect to it either.
I uninstalled and reinstalled SQLServer2k on both the
server and the client PC. Still no luck. I can establish
ethernet connection between the two machines so it doesn't
appear to be a network problem, especially when I can see
the servers in my availability list.
Any ideas on why this is happening and how to fix?
Roger.We had some issues in our group, where the default database specified in the
Login was no longer attached to the SQL Server.
This caused the Server Registration to fail.
HTH, Amol.
"Roger Denison" <anonymous@.discussions.microsoft.com> wrote in message
news:92c101c43367$84ec1910$a501280a@.phx.gbl...
> I have been trying to register a SQL server in my server
> group in Enterprise Manager but it cannot find the
> server. The SQL server (SQLServer2k) resides on a server
> machine running WinServer2K. I am trying to gain access
> from a remote PC running Win2k.
> I am able to see the server in the list of available
> servers when I run the registration wizard. But when I
> finish the wizard it fails to establish a connection. I
> have double checked login ID and password. I even set up
> another instance of a SQL server on the server machine.
> When I start the wizard again to register the new server,
> I see the new server in the available list but I can't
> connect to it either.
> I uninstalled and reinstalled SQLServer2k on both the
> server and the client PC. Still no luck. I can establish
> ethernet connection between the two machines so it doesn't
> appear to be a network problem, especially when I can see
> the servers in my availability list.
> Any ideas on why this is happening and how to fix?
> Roger.
>