Help needed...badly

I am having a problem with SQL server. When I go into enterprise manager and drill down to the Server level, right before you see the databases running on your server, I am getting an error message. The message I am getting is stating:
A connection could not be established to MAINSERVER.
Reason: Data source name not found and no default driver specified.
Please verify SQL Server is running and check your SQL Server registration properties (by right-clicking on the MAINSERVER node) and try again.
I did this and everything looks right...but I am still getting this message. I would really appreciate some help on this, as we have an update to run on one of the databases. But before I run the update, I must move that database off of the partitian it
is on because the partitian is almost full. Any help would be nice. Thank you in advance.
Tom
This sounds like a drivers issue, I assume yoiu are connecting from a seperate machine than the server. Try re-installing the enterprise management tools.

Help needed...badly

I am having a problem with SQL server. When I go into enterprise manager an
d drill down to the Server level, right before you see the databases running
on your server, I am getting an error message. The message I am getting is
stating:
A connection could not be established to MAINSERVER.
Reason: Data source name not found and no default driver specified.
Please verify SQL Server is running and check your SQL Server registration p
roperties (by right-clicking on the MAINSERVER node) and try again.
I did this and everything looks right...but I am still getting this message.
I would really appreciate some help on this, as we have an update to run o
n one of the databases. But before I run the update, I must move that datab
ase off of the partitian it
is on because the partitian is almost full. Any help would be nice. Thank
you in advance.
TomThis sounds like a drivers issue, I assume yoiu are connecting from a sepera
te machine than the server. Try re-installing the enterprise management tool
s.

Help needed with SQL SERVER 2000 Analysis Manager

I am going through the tutorial and I got to the portion on Set Dimension Custom Rollups, Write Back and more. I selected the Parent-Child dimension, and followed all of the steps as directed until it asked me to Select advanced options. The Write Back option is not listed and it has to be selected in order for me to complete this section. Please help.Same for me, I even try to change connexion without any success
any help ?

HELP- need to convert SQL 6.5 Back Up to 2000

HELP- need to convert SQL 6.5 Back Up to 2000
I have made enterprise manager back ups of two databases
on a SQL 6.5 server. The back ups are .dat files. I
want/need to convert these to SQL 2000 or SQL 7.0. I have
a SQL 2000 server. I tried to create a new database on
the SQL 2000 server and then restore the back ups to the
SQL 2000 server's new database I just created. I get an
error saying that the back up is not valid.
What is the procedure for getting this .dat 6.5 back up to
SQL 2000?
mick2767@.hotmail.comWhat you should do is to use the Upgrade Wizard... If you have the SQL 6.5
server with the dbs installed... Simply go to program files -> SQL Server
and you will find the upgrade wizard... That's the way to go.!
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
<mick2767@.hotmail.com> wrote in message
news:0cc201c3adf9$da109e50$a501280a@.phx.gbl...
> HELP- need to convert SQL 6.5 Back Up to 2000
> I have made enterprise manager back ups of two databases
> on a SQL 6.5 server. The back ups are .dat files. I
> want/need to convert these to SQL 2000 or SQL 7.0. I have
> a SQL 2000 server. I tried to create a new database on
> the SQL 2000 server and then restore the back ups to the
> SQL 2000 server's new database I just created. I get an
> error saying that the back up is not valid.
> What is the procedure for getting this .dat 6.5 back up to
> SQL 2000?
> mick2767@.hotmail.com|||When you do your restore, make sure that under options...Force restore
over existing database is checked. That might solve your problem.
"Wayne Snyder" <wsnyder@.ikon.com> wrote in message news:<e#z$IxfrDHA.1880@.TK2MSFTNGP09.phx.gbl>...
> What you should do is to use the Upgrade Wizard... If you have the SQL 6.5
> server with the dbs installed... Simply go to program files -> SQL Server
> and you will find the upgrade wizard... That's the way to go.!
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Computer Education Services Corporation (CESC), Charlotte, NC
> www.computeredservices.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> <mick2767@.hotmail.com> wrote in message
> news:0cc201c3adf9$da109e50$a501280a@.phx.gbl...
> > HELP- need to convert SQL 6.5 Back Up to 2000
> >
> > I have made enterprise manager back ups of two databases
> > on a SQL 6.5 server. The back ups are .dat files. I
> > want/need to convert these to SQL 2000 or SQL 7.0. I have
> > a SQL 2000 server. I tried to create a new database on
> > the SQL 2000 server and then restore the back ups to the
> > SQL 2000 server's new database I just created. I get an
> > error saying that the back up is not valid.
> >
> > What is the procedure for getting this .dat 6.5 back up to
> > SQL 2000?
> >
> > mick2767@.hotmail.com|||As Wayne said in his post: you cannot restore a 6.5 database into 7.0 or 2000.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Indigo Montoya" <Indigo_Montoya_2@.hotmail.com> wrote in message
news:f18452ec.0311181645.5b561bc7@.posting.google.com...
> When you do your restore, make sure that under options...Force restore
> over existing database is checked. That might solve your problem.
>
> "Wayne Snyder" <wsnyder@.ikon.com> wrote in message news:<e#z$IxfrDHA.1880@.TK2MSFTNGP09.phx.gbl>...
> > What you should do is to use the Upgrade Wizard... If you have the SQL 6.5
> > server with the dbs installed... Simply go to program files -> SQL Server
> > and you will find the upgrade wizard... That's the way to go.!
> >
> > --
> > Wayne Snyder, MCDBA, SQL Server MVP
> > Computer Education Services Corporation (CESC), Charlotte, NC
> > www.computeredservices.com
> > (Please respond only to the newsgroups.)
> >
> > I support the Professional Association of SQL Server (PASS) and it's
> > community of SQL Server professionals.
> > www.sqlpass.org
> > <mick2767@.hotmail.com> wrote in message
> > news:0cc201c3adf9$da109e50$a501280a@.phx.gbl...
> > > HELP- need to convert SQL 6.5 Back Up to 2000
> > >
> > > I have made enterprise manager back ups of two databases
> > > on a SQL 6.5 server. The back ups are .dat files. I
> > > want/need to convert these to SQL 2000 or SQL 7.0. I have
> > > a SQL 2000 server. I tried to create a new database on
> > > the SQL 2000 server and then restore the back ups to the
> > > SQL 2000 server's new database I just created. I get an
> > > error saying that the back up is not valid.
> > >
> > > What is the procedure for getting this .dat 6.5 back up to
> > > SQL 2000?
> > >
> > > mick2767@.hotmail.com