Help on Registering SQL Server in Enterprise Admin

Dear All
We want to monitor SQL job history for 50+ servers using id which doesn't
have admin priviliges on server and database. On database front I can
achieveit by assiging TargetServer role but I want to add all servers in
Enterprise Administartor console. What are minimum rights we require to
register server in Enterprise Admin for Windows 2000 & 2003 Servers?
Rahul> Enterprise Administartor console. What are minimum rights we require to
> register server in Enterprise Admin for Windows 2000 & 2003 Servers?
You will have EM installed on your workstation and to know a login and
password to register the SQL Server
"rahulpt" <rahulpt@.discussions.microsoft.com> wrote in message
news:36C3F6A6-BBF7-41A1-A97B-E5EC3A6AD6F9@.microsoft.com...
> Dear All
> We want to monitor SQL job history for 50+ servers using id which doesn't
> have admin priviliges on server and database. On database front I can
> achieveit by assiging TargetServer role but I want to add all servers in
> Enterprise Administartor console. What are minimum rights we require to
> register server in Enterprise Admin for Windows 2000 & 2003 Servers?
> --
> Rahul|||The minimum 'rights' to register a server are to be able to log into the ser
ver. It is not necessary to have permissions for any database.
However, in order to view the job history in EM (SQL 2000), I think that it
will be necessary to be in the sysadmin server role for all servers. (I'm a
little fuzzy on this...)
For Management Studio (SQL 2005) you must be in the SQLAgentReaderRole (or s
ysadmin) in order to view Job history of all the jobs.
If you used Query Analyzer and had some form or script, it would be necessar
y to only have SELECT permissions on the various sysjob... tables in the msd
b databases.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"rahulpt" <rahulpt@.discussions.microsoft.com> wrote in message news:36C3F6A6-BBF7-41A1-A97B-
E5EC3A6AD6F9@.microsoft.com...
> Dear All
>
> We want to monitor SQL job history for 50+ servers using id which doesn't
> have admin priviliges on server and database. On database front I can
> achieveit by assiging TargetServer role but I want to add all servers in
> Enterprise Administartor console. What are minimum rights we require to
> register server in Enterprise Admin for Windows 2000 & 2003 Servers?
>
> --
> Rahul|||Dear All
Thanks for your inputrs. But how I will give permission to domain user to
log on to SQL Server? Do you mean by adding user in SQL Login? Also when we
add user to SQL it asks for "Database" name, like master etc or user created
like test,test1 etc.
So which database we need to assign while adding user to sql login and what
will be security implications of same? I.e.if we add user with database as
master or user database test then what rights the user will have on these
databases'
Rahul
"Arnie Rowland" wrote:
[vbcol=seagreen]
> The minimum 'rights' to register a server are to be able to log into the s
erver. It is not necessary to have permissions for any database.
> However, in order to view the job history in EM (SQL 2000), I think that i
t will be necessary to be in the sysadmin server role for all servers. (I'm
a little fuzzy on this...)
> For Management Studio (SQL 2005) you must be in the SQLAgentReaderRole (or
sysadmin) in order to view Job history of all the jobs.
> If you used Query Analyzer and had some form or script, it would be necess
ary to only have SELECT permissions on the various sysjob... tables in the m
sdb databases.
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> "rahulpt" <rahulpt@.discussions.microsoft.com> wrote in message news:36C3F6
A6-BBF7-41A1-A97B-E5EC3A6AD6F9@.microsoft.com...

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- 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

Help me: SQL Server 2005 Enterprise Setup Error

I have my computer clean with windows 2000 server SP4

then I install Visual Studio.NET 2005 Professional (With SQL Server 2005 Express Edition) - Everything is OK!

after that i try to install SQL Server 2005 Enterprise Edition, but I get an error message at the begining as following:

Title: setup.exe - Entry Point Not Found

Content: The procedure entry point _encode_pointer could not be located in the dynamic link library MSVCR80.dll

so, is there anybody can help me to solve this problem? thanks!

You may want to post this in the setup section - they have a lot more information there and might have this question answered already.

Help me: SQL Server 2005 Enterprise Setup Error

I have my computer clean with windows 2000 server SP4

then I install Visual Studio.NET 2005 Professional (With SQL Server 2005 Express Edition) - Everything is OK!

after that i try to install SQL Server 2005 Enterprise Edition, but I get an error message at the begining as following:

Title: setup.exe - Entry Point Not Found

Content: The procedure entry point _encode_pointer could not be located in the dynamic link library MSVCR80.dll

so, is there anybody can help me to solve this problem? thanks!

You may want to post this in the setup section - they have a lot more information there and might have this question answered already.

Help me with this problem, please!

I have a question..
I had to put times in this process but I don't have idea
how to do this.
The enterprise use SQL Server 2000 and pages ASP, and
their server is in Corea.
Could be by DTS in SQL server, but I'm not sure it it
possible with DTS..
Section, send automatically post card
This process send post card in birthdays of employees.
This will run dialy for to send automatically post card to
employes who is him birthday that day..
Somebody knows how to do that and could be recommend
another way if it's not possible with DTS..
Please, send me the answer to my mail
bmartinez@.cosapisoft.com.pe
Thanks anyway
Grettings
BrunoDepending on the setup you have to accomplish this task,
you can use a DTS package scheduled every day to execute
the send postcard process.
Please let me know if you have any questions.
Edgardo Valdez
MCSD, MCDBA, MCSE, MCP+I
http://www.edgardovaldez.us/
>--Original Message--
>I have a question..
>I had to put times in this process but I don't have idea
>how to do this.
>The enterprise use SQL Server 2000 and pages ASP, and
>their server is in Corea.
>Could be by DTS in SQL server, but I'm not sure it it
>possible with DTS..
>Section, send automatically post card
>This process send post card in birthdays of employees.
>This will run dialy for to send automatically post card
to
>employes who is him birthday that day..
>Somebody knows how to do that and could be recommend
>another way if it's not possible with DTS..
>Please, send me the answer to my mail
>bmartinez@.cosapisoft.com.pe
>Thanks anyway
>Grettings
>Bruno
>
>.
>

Help me to script a table including data

Im try to use SQL server 2000 and use Enterprise to cript a table

But my result is only table structure in the script (myfile.sql)

(something like "create table Tb1, column..") and not have any data in my table included.

how good it is if it can write some insert statement (depend on number of records existed).

Could I have any way to do it with MS SQLServer 2000?

Thank you much.

DongMT

Hi,

This is a SQL question and not related to SSIS. You will need to post this kind of questions in SQL Server Forums.
Anyways, here is a link which has answer for your query.
http://vyaskn.tripod.com/code.htm#inserts

Thanks