Showing posts with label manager. Show all posts
Showing posts with label manager. Show all posts

Tuesday, March 27, 2012

Cannot register server

I am working on a LAN with 3 servers, VED, PM, JF
In Enterprise manager, from server PM, I registered server VED but
cannot register server JF. I see it in the list of proposed server, but
when I enter the SQL user code and password, an error message tells me
that server cannot be registered because of time out. But I tried that
last week and everything worked properly. I have been told that nothing
had been changed.
Looking forward to receiving some feedback on the above.
Regards
Patrick
A few things to try :-
Can you ping server JF
Is it listening on the default port 1433, use telnet to establish
Is SQL Server running on server JF or has the service been stopped
HTH. Ryan
"Patrick" <pmenage@.intnet.mu> wrote in message
news:1137472586.261082.252830@.o13g2000cwo.googlegr oups.com...
>I am working on a LAN with 3 servers, VED, PM, JF
> In Enterprise manager, from server PM, I registered server VED but
> cannot register server JF. I see it in the list of proposed server, but
> when I enter the SQL user code and password, an error message tells me
> that server cannot be registered because of time out. But I tried that
> last week and everything worked properly. I have been told that nothing
> had been changed.
> Looking forward to receiving some feedback on the above.
> Regards
> Patrick
>
|||Is latest version of MDAC installed on youre client machine?
Check for it also.
Regards
Amish
|||The MDAC has not been chenged
amish wrote:
> Is latest version of MDAC installed on youre client machine?
> Check for it also.
>
> Regards
> Amish
|||I can Ping the machine, I even see it in the list of proposed servers
to register. it seems that it is not a network problem.
|||I have the same problem on my client machine and I update MDAC to MDAC
2.8 and it was solved.
http://www.microsoft.com/downloads/d...displaylang=en
- To download MDAC Version
http://support.microsoft.com/default.aspx?kbid=301202 - To Check MDAC
Version
Check also for TCP IP port using telnet <server ip> <port> or check
if you have any other entry for this server name in client server
utility.
Regards
Amish

Cannot register server

I am working on a LAN with 3 servers, VED, PM, JF
In Enterprise manager, from server PM, I registered server VED but
cannot register server JF. I see it in the list of proposed server, but
when I enter the SQL user code and password, an error message tells me
that server cannot be registered because of time out. But I tried that
last week and everything worked properly. I have been told that nothing
had been changed.
Looking forward to receiving some feedback on the above.
Regards
PatrickA few things to try :-
Can you ping server JF
Is it listening on the default port 1433, use telnet to establish
Is SQL Server running on server JF or has the service been stopped
HTH. Ryan
"Patrick" <pmenage@.intnet.mu> wrote in message
news:1137472586.261082.252830@.o13g2000cwo.googlegroups.com...
>I am working on a LAN with 3 servers, VED, PM, JF
> In Enterprise manager, from server PM, I registered server VED but
> cannot register server JF. I see it in the list of proposed server, but
> when I enter the SQL user code and password, an error message tells me
> that server cannot be registered because of time out. But I tried that
> last week and everything worked properly. I have been told that nothing
> had been changed.
> Looking forward to receiving some feedback on the above.
> Regards
> Patrick
>|||Is latest version of MDAC installed on youre client machine?
Check for it also.
Regards
Amish|||The MDAC has not been chenged
amish wrote:
> Is latest version of MDAC installed on youre client machine?
> Check for it also.
>
> Regards
> Amish|||I can Ping the machine, I even see it in the list of proposed servers
to register. it seems that it is not a network problem.|||I have the same problem on my client machine and I update MDAC to MDAC
2.8 and it was solved.
http://www.microsoft.com/downloads/...&displaylang=en
- To download MDAC Version
http://support.microsoft.com/default.aspx?kbid=301202 - To Check MDAC
Version
Check also for TCP IP port using telnet <server ip> <port> or check
if you have any other entry for this server name in client server
utility.
Regards
Amishsql

Cannot register server

I am working on a LAN with 3 servers, VED, PM, JF
In Enterprise manager, from server PM, I registered server VED but
cannot register server JF. I see it in the list of proposed server, but
when I enter the SQL user code and password, an error message tells me
that server cannot be registered because of time out. But I tried that
last week and everything worked properly. I have been told that nothing
had been changed.
Looking forward to receiving some feedback on the above.
Regards
PatrickA few things to try :-
Can you ping server JF
Is it listening on the default port 1433, use telnet to establish
Is SQL Server running on server JF or has the service been stopped
--
HTH. Ryan
"Patrick" <pmenage@.intnet.mu> wrote in message
news:1137472586.261082.252830@.o13g2000cwo.googlegroups.com...
>I am working on a LAN with 3 servers, VED, PM, JF
> In Enterprise manager, from server PM, I registered server VED but
> cannot register server JF. I see it in the list of proposed server, but
> when I enter the SQL user code and password, an error message tells me
> that server cannot be registered because of time out. But I tried that
> last week and everything worked properly. I have been told that nothing
> had been changed.
> Looking forward to receiving some feedback on the above.
> Regards
> Patrick
>|||Is latest version of MDAC installed on youre client machine?
Check for it also.
Regards
Amish|||The MDAC has not been chenged
amish wrote:
> Is latest version of MDAC installed on youre client machine?
> Check for it also.
>
> Regards
> Amish|||I can Ping the machine, I even see it in the list of proposed servers
to register. it seems that it is not a network problem.|||I have the same problem on my client machine and I update MDAC to MDAC
2.8 and it was solved.
http://www.microsoft.com/downloads/details.aspx?FamilyID=6C050FE3-C795-4B7D-B037-185D0506396C&displaylang=en
- To download MDAC Version
http://support.microsoft.com/default.aspx?kbid=301202 - To Check MDAC
Version
Check also for TCP IP port using telnet <server ip> <port> or check
if you have any other entry for this server name in client server
utility.
--
Regards
Amish

Cannot Register Any Instance of SQL Server 2000 to AD

Hello; I keep getting this message, 'SQL Enterprise Manager could not add
server '(local)' to AD. Error: 14303: Stored procedure
'sp_ActiveDirectory_SCP' failed to access registry key. Now, what does this
mean? I am the SA of this instance; I am the dbo, if you will, also. So, I
have the sufficient permissions to register any instance to AD, right? I even
installed SP4, but that didn't work. I"m a student of sql server services and
I'm in a training class, so I'd appreciate "guru"-level assistance. Thanks.
DominickAre you a local administrator on the machine? The error is telling you
that EM can't access the system registry. You also need the rights on
AD to publish the instance, sorry - I don't recall off hand the exact
permission.
Dominick D. wrote:
> Hello; I keep getting this message, 'SQL Enterprise Manager could not add
> server '(local)' to AD. Error: 14303: Stored procedure
> 'sp_ActiveDirectory_SCP' failed to access registry key. Now, what does this
> mean? I am the SA of this instance; I am the dbo, if you will, also. So, I
> have the sufficient permissions to register any instance to AD, right? I even
> installed SP4, but that didn't work. I"m a student of sql server services and
> I'm in a training class, so I'd appreciate "guru"-level assistance. Thanks.
> Dominick|||Yes, I am a local administrator on the machine where AD is located; I have
enterprise/domain admin rights. I don't understand why EM is not accessing
the registry. Can you dig a little deeper? Get some assistance?
Unfortunately, your response has not helped me.
"PSPDBA" wrote:
> Are you a local administrator on the machine? The error is telling you
> that EM can't access the system registry. You also need the rights on
> AD to publish the instance, sorry - I don't recall off hand the exact
> permission.
>
> Dominick D. wrote:
> > Hello; I keep getting this message, 'SQL Enterprise Manager could not add
> > server '(local)' to AD. Error: 14303: Stored procedure
> > 'sp_ActiveDirectory_SCP' failed to access registry key. Now, what does this
> > mean? I am the SA of this instance; I am the dbo, if you will, also. So, I
> > have the sufficient permissions to register any instance to AD, right? I even
> > installed SP4, but that didn't work. I"m a student of sql server services and
> > I'm in a training class, so I'd appreciate "guru"-level assistance. Thanks.
> >
> > Dominick
>|||Based on some reading, try change the SQL Service account to your
domain admin account, and use your domain admin to run the stored proc.
I would guess that the SQL Service account doesn't have the privileges
to read/edit the registy on the server.
Dominick D. wrote:
> Yes, I am a local administrator on the machine where AD is located; I have
> enterprise/domain admin rights. I don't understand why EM is not accessing
> the registry. Can you dig a little deeper? Get some assistance?
> Unfortunately, your response has not helped me.
> "PSPDBA" wrote:
> > Are you a local administrator on the machine? The error is telling you
> > that EM can't access the system registry. You also need the rights on
> > AD to publish the instance, sorry - I don't recall off hand the exact
> > permission.
> >
> >
> > Dominick D. wrote:
> > > Hello; I keep getting this message, 'SQL Enterprise Manager could not add
> > > server '(local)' to AD. Error: 14303: Stored procedure
> > > 'sp_ActiveDirectory_SCP' failed to access registry key. Now, what does this
> > > mean? I am the SA of this instance; I am the dbo, if you will, also. So, I
> > > have the sufficient permissions to register any instance to AD, right? I even
> > > installed SP4, but that didn't work. I"m a student of sql server services and
> > > I'm in a training class, so I'd appreciate "guru"-level assistance. Thanks.
> > >
> > > Dominick
> >
> >|||OK, I placed the SQLService domain user account into the domain admins group
and I was able to register another instance to the AD, so your advice worked;
however, I was not able to register the default instance to the AD :(. I
don't get that. Any other clue for that reason? Thanks for your help.
"PSPDBA" wrote:
> Based on some reading, try change the SQL Service account to your
> domain admin account, and use your domain admin to run the stored proc.
> I would guess that the SQL Service account doesn't have the privileges
> to read/edit the registy on the server.
>
> Dominick D. wrote:
> > Yes, I am a local administrator on the machine where AD is located; I have
> > enterprise/domain admin rights. I don't understand why EM is not accessing
> > the registry. Can you dig a little deeper? Get some assistance?
> > Unfortunately, your response has not helped me.
> >
> > "PSPDBA" wrote:
> >
> > > Are you a local administrator on the machine? The error is telling you
> > > that EM can't access the system registry. You also need the rights on
> > > AD to publish the instance, sorry - I don't recall off hand the exact
> > > permission.
> > >
> > >
> > > Dominick D. wrote:
> > > > Hello; I keep getting this message, 'SQL Enterprise Manager could not add
> > > > server '(local)' to AD. Error: 14303: Stored procedure
> > > > 'sp_ActiveDirectory_SCP' failed to access registry key. Now, what does this
> > > > mean? I am the SA of this instance; I am the dbo, if you will, also. So, I
> > > > have the sufficient permissions to register any instance to AD, right? I even
> > > > installed SP4, but that didn't work. I"m a student of sql server services and
> > > > I'm in a training class, so I'd appreciate "guru"-level assistance. Thanks.
> > > >
> > > > Dominick
> > >
> > >
>|||Ok, we're getting further. I did a little more reading - check the
MSSQLServerADHelper service and set it to use the domain admin account
too.
Dominick D. wrote:
> OK, I placed the SQLService domain user account into the domain admins group
> and I was able to register another instance to the AD, so your advice worked;
> however, I was not able to register the default instance to the AD :(. I
> don't get that. Any other clue for that reason? Thanks for your help.
> "PSPDBA" wrote:
> > Based on some reading, try change the SQL Service account to your
> > domain admin account, and use your domain admin to run the stored proc.
> >
> > I would guess that the SQL Service account doesn't have the privileges
> > to read/edit the registy on the server.
> >
> >
> > Dominick D. wrote:
> > > Yes, I am a local administrator on the machine where AD is located; I have
> > > enterprise/domain admin rights. I don't understand why EM is not accessing
> > > the registry. Can you dig a little deeper? Get some assistance?
> > > Unfortunately, your response has not helped me.
> > >
> > > "PSPDBA" wrote:
> > >
> > > > Are you a local administrator on the machine? The error is telling you
> > > > that EM can't access the system registry. You also need the rights on
> > > > AD to publish the instance, sorry - I don't recall off hand the exact
> > > > permission.
> > > >
> > > >
> > > > Dominick D. wrote:
> > > > > Hello; I keep getting this message, 'SQL Enterprise Manager could not add
> > > > > server '(local)' to AD. Error: 14303: Stored procedure
> > > > > 'sp_ActiveDirectory_SCP' failed to access registry key. Now, what does this
> > > > > mean? I am the SA of this instance; I am the dbo, if you will, also. So, I
> > > > > have the sufficient permissions to register any instance to AD, right? I even
> > > > > installed SP4, but that didn't work. I"m a student of sql server services and
> > > > > I'm in a training class, so I'd appreciate "guru"-level assistance. Thanks.
> > > > >
> > > > > Dominick
> > > >
> > > >
> >
> >|||OK, I can do that, but, I noticed that there is no such user/group called
MSSQLServerADHelper. Do I have to create it or is it already created?
"PSPDBA" wrote:
> Ok, we're getting further. I did a little more reading - check the
> MSSQLServerADHelper service and set it to use the domain admin account
> too.
>
> Dominick D. wrote:
> > OK, I placed the SQLService domain user account into the domain admins group
> > and I was able to register another instance to the AD, so your advice worked;
> > however, I was not able to register the default instance to the AD :(. I
> > don't get that. Any other clue for that reason? Thanks for your help.
> >
> > "PSPDBA" wrote:
> >
> > > Based on some reading, try change the SQL Service account to your
> > > domain admin account, and use your domain admin to run the stored proc.
> > >
> > > I would guess that the SQL Service account doesn't have the privileges
> > > to read/edit the registy on the server.
> > >
> > >
> > > Dominick D. wrote:
> > > > Yes, I am a local administrator on the machine where AD is located; I have
> > > > enterprise/domain admin rights. I don't understand why EM is not accessing
> > > > the registry. Can you dig a little deeper? Get some assistance?
> > > > Unfortunately, your response has not helped me.
> > > >
> > > > "PSPDBA" wrote:
> > > >
> > > > > Are you a local administrator on the machine? The error is telling you
> > > > > that EM can't access the system registry. You also need the rights on
> > > > > AD to publish the instance, sorry - I don't recall off hand the exact
> > > > > permission.
> > > > >
> > > > >
> > > > > Dominick D. wrote:
> > > > > > Hello; I keep getting this message, 'SQL Enterprise Manager could not add
> > > > > > server '(local)' to AD. Error: 14303: Stored procedure
> > > > > > 'sp_ActiveDirectory_SCP' failed to access registry key. Now, what does this
> > > > > > mean? I am the SA of this instance; I am the dbo, if you will, also. So, I
> > > > > > have the sufficient permissions to register any instance to AD, right? I even
> > > > > > installed SP4, but that didn't work. I"m a student of sql server services and
> > > > > > I'm in a training class, so I'd appreciate "guru"-level assistance. Thanks.
> > > > > >
> > > > > > Dominick
> > > > >
> > > > >
> > >
> > >
>|||Thats a service on the server, not a group/user.
Dominick D. wrote:
> OK, I can do that, but, I noticed that there is no such user/group called
> MSSQLServerADHelper. Do I have to create it or is it already created?
> "PSPDBA" wrote:
> > Ok, we're getting further. I did a little more reading - check the
> > MSSQLServerADHelper service and set it to use the domain admin account
> > too.
> >
> >
> > Dominick D. wrote:
> > > OK, I placed the SQLService domain user account into the domain admins group
> > > and I was able to register another instance to the AD, so your advice worked;
> > > however, I was not able to register the default instance to the AD :(. I
> > > don't get that. Any other clue for that reason? Thanks for your help.
> > >
> > > "PSPDBA" wrote:
> > >
> > > > Based on some reading, try change the SQL Service account to your
> > > > domain admin account, and use your domain admin to run the stored proc.
> > > >
> > > > I would guess that the SQL Service account doesn't have the privileges
> > > > to read/edit the registy on the server.
> > > >
> > > >
> > > > Dominick D. wrote:
> > > > > Yes, I am a local administrator on the machine where AD is located; I have
> > > > > enterprise/domain admin rights. I don't understand why EM is not accessing
> > > > > the registry. Can you dig a little deeper? Get some assistance?
> > > > > Unfortunately, your response has not helped me.
> > > > >
> > > > > "PSPDBA" wrote:
> > > > >
> > > > > > Are you a local administrator on the machine? The error is telling you
> > > > > > that EM can't access the system registry. You also need the rights on
> > > > > > AD to publish the instance, sorry - I don't recall off hand the exact
> > > > > > permission.
> > > > > >
> > > > > >
> > > > > > Dominick D. wrote:
> > > > > > > Hello; I keep getting this message, 'SQL Enterprise Manager could not add
> > > > > > > server '(local)' to AD. Error: 14303: Stored procedure
> > > > > > > 'sp_ActiveDirectory_SCP' failed to access registry key. Now, what does this
> > > > > > > mean? I am the SA of this instance; I am the dbo, if you will, also. So, I
> > > > > > > have the sufficient permissions to register any instance to AD, right? I even
> > > > > > > installed SP4, but that didn't work. I"m a student of sql server services and
> > > > > > > I'm in a training class, so I'd appreciate "guru"-level assistance. Thanks.
> > > > > > >
> > > > > > > Dominick
> > > > > >
> > > > > >
> > > >
> > > >
> >
> >|||OK, how do I access it and by putting the sa into the domain admins group, I
was able to register both the default and named instance on the AD, so your
advice helped. Thanks.
"PSPDBA" wrote:
> Thats a service on the server, not a group/user.
>
> Dominick D. wrote:
> > OK, I can do that, but, I noticed that there is no such user/group called
> > MSSQLServerADHelper. Do I have to create it or is it already created?
> >
> > "PSPDBA" wrote:
> >
> > > Ok, we're getting further. I did a little more reading - check the
> > > MSSQLServerADHelper service and set it to use the domain admin account
> > > too.
> > >
> > >
> > > Dominick D. wrote:
> > > > OK, I placed the SQLService domain user account into the domain admins group
> > > > and I was able to register another instance to the AD, so your advice worked;
> > > > however, I was not able to register the default instance to the AD :(. I
> > > > don't get that. Any other clue for that reason? Thanks for your help.
> > > >
> > > > "PSPDBA" wrote:
> > > >
> > > > > Based on some reading, try change the SQL Service account to your
> > > > > domain admin account, and use your domain admin to run the stored proc.
> > > > >
> > > > > I would guess that the SQL Service account doesn't have the privileges
> > > > > to read/edit the registy on the server.
> > > > >
> > > > >
> > > > > Dominick D. wrote:
> > > > > > Yes, I am a local administrator on the machine where AD is located; I have
> > > > > > enterprise/domain admin rights. I don't understand why EM is not accessing
> > > > > > the registry. Can you dig a little deeper? Get some assistance?
> > > > > > Unfortunately, your response has not helped me.
> > > > > >
> > > > > > "PSPDBA" wrote:
> > > > > >
> > > > > > > Are you a local administrator on the machine? The error is telling you
> > > > > > > that EM can't access the system registry. You also need the rights on
> > > > > > > AD to publish the instance, sorry - I don't recall off hand the exact
> > > > > > > permission.
> > > > > > >
> > > > > > >
> > > > > > > Dominick D. wrote:
> > > > > > > > Hello; I keep getting this message, 'SQL Enterprise Manager could not add
> > > > > > > > server '(local)' to AD. Error: 14303: Stored procedure
> > > > > > > > 'sp_ActiveDirectory_SCP' failed to access registry key. Now, what does this
> > > > > > > > mean? I am the SA of this instance; I am the dbo, if you will, also. So, I
> > > > > > > > have the sufficient permissions to register any instance to AD, right? I even
> > > > > > > > installed SP4, but that didn't work. I"m a student of sql server services and
> > > > > > > > I'm in a training class, so I'd appreciate "guru"-level assistance. Thanks.
> > > > > > > >
> > > > > > > > Dominick
> > > > > > >
> > > > > > >
> > > > >
> > > > >
> > >
> > >
>

Cannot Register Any Instance of SQL Server 2000 to AD

Hello; I keep getting this message, 'SQL Enterprise Manager could not add
server '(local)' to AD. Error: 14303: Stored procedure
'sp_ActiveDirectory_SCP' failed to access registry key. Now, what does this
mean? I am the SA of this instance; I am the dbo, if you will, also. So, I
have the sufficient permissions to register any instance to AD, right? I eve
n
installed SP4, but that didn't work. I"m a student of sql server services an
d
I'm in a training class, so I'd appreciate "guru"-level assistance. Thanks.
DominickAre you a local administrator on the machine? The error is telling you
that EM can't access the system registry. You also need the rights on
AD to publish the instance, sorry - I don't recall off hand the exact
permission.
Dominick D. wrote:
> Hello; I keep getting this message, 'SQL Enterprise Manager could not add
> server '(local)' to AD. Error: 14303: Stored procedure
> 'sp_ActiveDirectory_SCP' failed to access registry key. Now, what does th
is
> mean? I am the SA of this instance; I am the dbo, if you will, also. So, I
> have the sufficient permissions to register any instance to AD, right? I e
ven
> installed SP4, but that didn't work. I"m a student of sql server services
and
> I'm in a training class, so I'd appreciate "guru"-level assistance. Thanks
.
> Dominick|||Yes, I am a local administrator on the machine where AD is located; I have
enterprise/domain admin rights. I don't understand why EM is not accessing
the registry. Can you dig a little deeper? Get some assistance?
Unfortunately, your response has not helped me.
"PSPDBA" wrote:

> Are you a local administrator on the machine? The error is telling you
> that EM can't access the system registry. You also need the rights on
> AD to publish the instance, sorry - I don't recall off hand the exact
> permission.
>
> Dominick D. wrote:
>|||Based on some reading, try change the SQL Service account to your
domain admin account, and use your domain admin to run the stored proc.
I would guess that the SQL Service account doesn't have the privileges
to read/edit the registy on the server.
Dominick D. wrote:[vbcol=seagreen]
> Yes, I am a local administrator on the machine where AD is located; I have
> enterprise/domain admin rights. I don't understand why EM is not accessing
> the registry. Can you dig a little deeper? Get some assistance?
> Unfortunately, your response has not helped me.
> "PSPDBA" wrote:
>|||OK, I placed the SQLService domain user account into the domain admins group
and I was able to register another instance to the AD, so your advice worked
;
however, I was not able to register the default instance to the AD . I
don't get that. Any other clue for that reason? Thanks for your help.
"PSPDBA" wrote:

> Based on some reading, try change the SQL Service account to your
> domain admin account, and use your domain admin to run the stored proc.
> I would guess that the SQL Service account doesn't have the privileges
> to read/edit the registy on the server.
>
> Dominick D. wrote:
>|||Ok, we're getting further. I did a little more reading - check the
MSSQLServerADHelper service and set it to use the domain admin account
too.
Dominick D. wrote:[vbcol=seagreen]
> OK, I placed the SQLService domain user account into the domain admins gro
up
> and I was able to register another instance to the AD, so your advice work
ed;
> however, I was not able to register the default instance to the AD . I
> don't get that. Any other clue for that reason? Thanks for your help.
> "PSPDBA" wrote:
>|||OK, I can do that, but, I noticed that there is no such user/group called
MSSQLServerADHelper. Do I have to create it or is it already created?
"PSPDBA" wrote:

> Ok, we're getting further. I did a little more reading - check the
> MSSQLServerADHelper service and set it to use the domain admin account
> too.
>
> Dominick D. wrote:
>|||Thats a service on the server, not a group/user.
Dominick D. wrote:[vbcol=seagreen]
> OK, I can do that, but, I noticed that there is no such user/group called
> MSSQLServerADHelper. Do I have to create it or is it already created?
> "PSPDBA" wrote:
>|||OK, how do I access it and by putting the sa into the domain admins group, I
was able to register both the default and named instance on the AD, so your
advice helped. Thanks.
"PSPDBA" wrote:

> Thats a service on the server, not a group/user.
>
> Dominick D. wrote:
>sql

Sunday, March 25, 2012

Cannot print landscape

In Report Manager in SSRS 2005, no matter what printer I go to, there is no landscape option. It's not the driver, unless the driver for the printer isn't like SSRS because I can print landscape on any of these pritnters in any other application. Why is that? I do not see an option to switch to landscape period after looking at my printer properties afer clicking the print button from SSRS

From what I understand it is not the printer you have to choose to be landscape but the report before you print it.

Set the report width and height to be the opposite to what they are now. E.g. US letter set width to 11 and height to 8.5

Craig

Cannot perform requested task because full-text manager is not

I am trying to import/transfer data tables from an existing MS SQL
2005 Express Adv install to an MS SQL 2000 Standard install (on
different boxes) but it is not working. It's seems to be failing with
the above mentioned error. Can anyone help with this?
Thanks,
J.Well, do you have full text indexes on Express Adv.? Did you install/enable
full-text on Standard? You are probably trying to move tables with
full-text indexes onto Standard, but it can't set them up because full text
is not there or not enabled...
<Jeffrey.TOL@.gmail.com> wrote in message
news:dbe41d4f-e3ed-416d-8b27-6a29030b453e@.e39g2000hsf.googlegroups.com...
> I am trying to import/transfer data tables from an existing MS SQL
> 2005 Express Adv install to an MS SQL 2000 Standard install (on
> different boxes) but it is not working. It's seems to be failing with
> the above mentioned error. Can anyone help with this?
> Thanks,
> J.|||Thanks for your reply. I was leaning towards this but was unsure.
Could you tell me how would I go about checking to see if it is
installed on both servers? Is there an SQL query that I can
perform...?
Cheers,
J.
On May 2, 2:48=A0pm, "Aaron Bertrand [SQL Server]"
<ten...@.dnartreb.noraa> wrote:
> Well, do you have full text indexes on Express Adv.? =A0Did you install/en=able
> full-text on Standard? =A0You are probably trying to move tables with
> full-text indexes onto Standard, but it can't set them up because full tex=t
> is not there or not enabled...
> <Jeffrey...@.gmail.com> wrote in message
> news:dbe41d4f-e3ed-416d-8b27-6a29030b453e@.e39g2000hsf.googlegroups.com...
>
> > I am trying to import/transfer data tables from an existing MS SQL
> > 2005 Express Adv install to an MS SQL 2000 Standard install (on
> > different boxes) but it is not working. =A0It's seems to be failing with=
> > the above mentioned error. =A0Can anyone help with this?
> > Thanks,
> > J.- Hide quoted text -
> - Show quoted text -|||> Thanks for your reply. I was leaning towards this but was unsure.
> Could you tell me how would I go about checking to see if it is
> installed on both servers? Is there an SQL query that I can
> perform...?
I would check the services applet in the control panel.|||Yup looked there but it didn't say much, so I tried a reinstall and
the option was there but unselected. Once the install went through,
all was well. I am copying the data now. Thanks!!!
Cheers,
J.
On May 2, 3:10=A0pm, "Aaron Bertrand [SQL Server]"
<ten...@.dnartreb.noraa> wrote:
> > Thanks for your reply. =A0I was leaning towards this but was unsure.
> > Could you tell me how would I go about checking to see if it is
> > installed on both servers? =A0Is there an SQL query that I can
> > perform...?
> I would check the services applet in the control panel.|||Jeffrey,
If you do not need the full text indexes, I suppose that you could go
through your databases (there are only a few, right) and try to drop all
full-text indexes.
Look under:
DatabaseName
Storage
Full Text Catalogs
From the catalogs you can determine which tables have full text indexes. If
you script a drop of the catalog it will script out a drop the indexes then
drop the catalogs. I have not tested this, but it is a free idea. If it
seems suitable, try it out and see if solves your problem.
RLF
<Jeffrey.TOL@.gmail.com> wrote in message
news:a3e0cfaf-2fef-47c9-af25-9a72bf3499d5@.y38g2000hsy.googlegroups.com...
Thanks for your reply. I was leaning towards this but was unsure.
Could you tell me how would I go about checking to see if it is
installed on both servers? Is there an SQL query that I can
perform...?
Cheers,
J.
On May 2, 2:48 pm, "Aaron Bertrand [SQL Server]"
<ten...@.dnartreb.noraa> wrote:
> Well, do you have full text indexes on Express Adv.? Did you
> install/enable
> full-text on Standard? You are probably trying to move tables with
> full-text indexes onto Standard, but it can't set them up because full
> text
> is not there or not enabled...
> <Jeffrey...@.gmail.com> wrote in message
> news:dbe41d4f-e3ed-416d-8b27-6a29030b453e@.e39g2000hsf.googlegroups.com...
>
> > I am trying to import/transfer data tables from an existing MS SQL
> > 2005 Express Adv install to an MS SQL 2000 Standard install (on
> > different boxes) but it is not working. It's seems to be failing with
> > the above mentioned error. Can anyone help with this?
> > Thanks,
> > J.- Hide quoted text -
> - Show quoted text -|||Well, the reinstall was a better idea. Congrats. - RLF
"Russell Fields" <russellfields@.nomail.com> wrote in message
news:%23Ag4UyIrIHA.524@.TK2MSFTNGP05.phx.gbl...
> Jeffrey,
> If you do not need the full text indexes, I suppose that you could go
> through your databases (there are only a few, right) and try to drop all
> full-text indexes.
> Look under:
> DatabaseName
> Storage
> Full Text Catalogs
> From the catalogs you can determine which tables have full text indexes.
> If you script a drop of the catalog it will script out a drop the indexes
> then drop the catalogs. I have not tested this, but it is a free idea. If
> it seems suitable, try it out and see if solves your problem.
> RLF
> <Jeffrey.TOL@.gmail.com> wrote in message
> news:a3e0cfaf-2fef-47c9-af25-9a72bf3499d5@.y38g2000hsy.googlegroups.com...
> Thanks for your reply. I was leaning towards this but was unsure.
> Could you tell me how would I go about checking to see if it is
> installed on both servers? Is there an SQL query that I can
> perform...?
> Cheers,
> J.
>
>
> On May 2, 2:48 pm, "Aaron Bertrand [SQL Server]"
> <ten...@.dnartreb.noraa> wrote:
>> Well, do you have full text indexes on Express Adv.? Did you
>> install/enable
>> full-text on Standard? You are probably trying to move tables with
>> full-text indexes onto Standard, but it can't set them up because full
>> text
>> is not there or not enabled...
>> <Jeffrey...@.gmail.com> wrote in message
>> news:dbe41d4f-e3ed-416d-8b27-6a29030b453e@.e39g2000hsf.googlegroups.com...
>>
>> > I am trying to import/transfer data tables from an existing MS SQL
>> > 2005 Express Adv install to an MS SQL 2000 Standard install (on
>> > different boxes) but it is not working. It's seems to be failing with
>> > the above mentioned error. Can anyone help with this?
>> > Thanks,
>> > J.- Hide quoted text -
>> - Show quoted text -
>

Thursday, March 22, 2012

cannot open table in Enterprise manager

Hi, each time I want to open a table (return all rows)
this message pop up:
The query cannot be executed because some files are
either missing or not registered.
I found, on microsoft.com, that I just have to reinstall
the product or use regsvr32.exe to register some dll's.
I tried both solutions and it's not working.
Any ideas?
thanks
A little more information might help - What application are you using to
perform the query?
Jim
"eric champagne" <anonymous@.discussions.microsoft.com> wrote in message
news:1417e01c41801$7a6a3070$a601280a@.phx.gbl...
> Hi, each time I want to open a table (return all rows)
> this message pop up:
> The query cannot be executed because some files are
> either missing or not registered.
> I found, on microsoft.com, that I just have to reinstall
> the product or use regsvr32.exe to register some dll's.
> I tried both solutions and it's not working.
> Any ideas?
> thanks
|||sql server enterprise manager 2000... on my other windows
xp workstation , it's working fine.

>--Original Message--
>A little more information might help - What application
are you using to
>perform the query?
>Jim
>"eric champagne" <anonymous@.discussions.microsoft.com>
wrote in message
>news:1417e01c41801$7a6a3070$a601280a@.phx.gbl...
reinstall
>
>.
>
|||Did you apply Service Pack 3a of SQL Server to the workstation? This needs
to be done to update EM also.
Jim
<anonymous@.discussions.microsoft.com> wrote in message
news:142be01c41813$7d1bddc0$a601280a@.phx.gbl...
> sql server enterprise manager 2000... on my other windows
> xp workstation , it's working fine.
> are you using to
> wrote in message
> reinstall
|||Yes I did that...
It's very strange because it's working on all my other
workstation with XP

>--Original Message--
>Did you apply Service Pack 3a of SQL Server to the
workstation? This needs
>to be done to update EM also.
>Jim
><anonymous@.discussions.microsoft.com> wrote in message
>news:142be01c41813$7d1bddc0$a601280a@.phx.gbl...
windows
application
rows)
dll's.
>
>.
>
|||Did you reinstall the client tools?
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"eric champagne" <anonymous@.discussions.microsoft.com> wrote in message
news:1417e01c41801$7a6a3070$a601280a@.phx.gbl...
> Hi, each time I want to open a table (return all rows)
> this message pop up:
> The query cannot be executed because some files are
> either missing or not registered.
> I found, on microsoft.com, that I just have to reinstall
> the product or use regsvr32.exe to register some dll's.
> I tried both solutions and it's not working.
> Any ideas?
> thanks
|||Are you trying to use Query Analyzer or the table data browser in EM?
Can you run queries using QA?
Jim
<anonymous@.discussions.microsoft.com> wrote in message
news:143b801c41821$c469c530$a601280a@.phx.gbl...
> Yes I did that...
> It's very strange because it's working on all my other
> workstation with XP
> workstation? This needs
> windows
> application
> rows)
> dll's.

Tuesday, March 20, 2012

Cannot Open Query analyser from SQL Enterprise Manager

I intalled SQL200SP4 on my Windows 2003 server and now, I cannot open Query
analyser from SQL Enterprise Manager.
I get the following message: "The specified file was not found"
I can go to Query Analyser directly from the Start Menu and it works fine.
Can you please suggest, what I should do to fix this?
Thanks
Hello!
I thought this was a managed Newsgroup.
Anyone from Microsoft with a clue, why this is happening and how can I fix
this?
Thanks
"gurusinghj" wrote:

> I intalled SQL200SP4 on my Windows 2003 server and now, I cannot open Query
> analyser from SQL Enterprise Manager.
> I get the following message: "The specified file was not found"
> I can go to Query Analyser directly from the Start Menu and it works fine.
> Can you please suggest, what I should do to fix this?
> Thanks
|||gurusinghj wrote:
> I intalled SQL200SP4 on my Windows 2003 server and now, I cannot open
> Query analyser from SQL Enterprise Manager.
> I get the following message: "The specified file was not found"
> I can go to Query Analyser directly from the Start Menu and it works
> fine.
> Can you please suggest, what I should do to fix this?
> Thanks
Make sure the SQL tools are in your path. The default might look
something like the following in the path environment variable:
"C:\Program Files\Microsoft SQL Server\80\Tools\Binn\;"
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||Thanks David,
But i do have this in path, but I still get this issue.
Thinking back, I did once install SQL Server 2000 Desktop Engine (MSDE)
after SQl server was already installed. (Another application that I
installed, did the insalltion, without me knowing.)
I did subsequently uninstall it. Do you think, that might have messed up
some registry settings.
Any help on how to restore these back, will be really appreciated.
Thanks
"David Gugick" wrote:

> gurusinghj wrote:
> Make sure the SQL tools are in your path. The default might look
> something like the following in the path environment variable:
> "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\;"
>
>
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
>
|||gurusinghj wrote:
> Thanks David,
> But i do have this in path, but I still get this issue.
> Thinking back, I did once install SQL Server 2000 Desktop Engine
> (MSDE) after SQl server was already installed. (Another application
> that I installed, did the insalltion, without me knowing.)
> I did subsequently uninstall it. Do you think, that might have messed
> up some registry settings.
> Any help on how to restore these back, will be really appreciated.
I doubt it. MSDE does not have any client tools and I doubt it would
add/change the PATH variable. If you open a command window and type
ISQL.EXE from the C:\ root folder, does QA come up? Also make sure the
"Start In" folder is the same as the "Target" folder in the shortcut for
SQL EM. The Target should look something like:
C:\WINDOWS\system32\mmc.exe /s "C:\Program Files\Microsoft SQL
Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC"
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||I get the same problem right after installing MSDE also
"David Gugick" wrote:

> gurusinghj wrote:
> I doubt it. MSDE does not have any client tools and I doubt it would
> add/change the PATH variable. If you open a command window and type
> ISQL.EXE from the C:\ root folder, does QA come up? Also make sure the
> "Start In" folder is the same as the "Target" folder in the shortcut for
> SQL EM. The Target should look something like:
> C:\WINDOWS\system32\mmc.exe /s "C:\Program Files\Microsoft SQL
> Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC"
>
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
>
|||In SQL Enterprise Manager (SEM), go to Tools->External Tools; add the path
to isqlw with the parameters
-S[SRV] -d[DBN]
A new menu item should be created under Tools that will launch QA with the
right database and server context based on SEM.
If the "file not found" messge box appears, you might need the full path for
isqlw.exe OR ensure the "isqlw.exe" string appears in the "command field".
If the path contains spaces, you need to wrap the path with double quotes.
The -S and -d parameters are optional but allow you to bypass the connection
dialog each and every launch.
Regards,
Keith
This posting is provided "as is" without inferring rights or warranties.
"jdehne" <jdehne@.discussions.microsoft.com> wrote in message
news:66BE5CD0-0CE9-46E3-A258-A033FD06E75A@.microsoft.com...[vbcol=seagreen]
>I get the same problem right after installing MSDE also
> "David Gugick" wrote:

cannot open Enterprise Manager

Hi All,
Several months ago, I installed SQL Server 2000
Development edition on my Windows XP laptop.
Today, for the first time, for some unknown reason I
cannot open the Enterprise Manager. I have been able to
open it, practically everyday, for the past few months.
I am getting the following Microsoft Management Console
error message:
"MMC cannot open the file C:\Program Files\Microsoft SQL
Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC.
This may be because the file does not exist, is not an
MMCconsole, or was created by a later version of MMC.
This may also be because you do not have sufficient
access rights to the file."
SQL Server Enterprise Manager.MSC file does exist in
I have all access rights to my laptop!
Any idea what have caused this problem and how could I
fix it.
Thank you,
Mitra
Try uninstalling / reinstalling the client tools, and/or reapplying SP3a.
http://www.aspfaq.com/
(Reverse address to reply.)
"mitra fatholahi" <mitra928@.hotmail.com> wrote in message
news:1b2d201c44f45$da666d60$a001280a@.phx.gbl...
> Hi All,
> Several months ago, I installed SQL Server 2000
> Development edition on my Windows XP laptop.
> Today, for the first time, for some unknown reason I
> cannot open the Enterprise Manager. I have been able to
> open it, practically everyday, for the past few months.
> I am getting the following Microsoft Management Console
> error message:
> "MMC cannot open the file C:\Program Files\Microsoft SQL
> Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC.
> This may be because the file does not exist, is not an
> MMCconsole, or was created by a later version of MMC.
> This may also be because you do not have sufficient
> access rights to the file."
> SQL Server Enterprise Manager.MSC file does exist in
> I have all access rights to my laptop!
> Any idea what have caused this problem and how could I
> fix it.
> Thank you,
> Mitra
>
>
>
|||The file that becomes the SQL Server Enterprise Manager.MSC is named
SQLEM.MSC on the SQL Server 2000 CD. You can try copying the one form the
CD, renaming it and replcacing the one on disk.
Rand
This posting is provided "as is" with no warranties and confers no rights.

Cannot open Enterprise Manager

I have performed a windows update on the server and now i am presented with
an error when trying to open enterprise manager. The MMC cannot find the
file C:\Program Files\Microsoft SQL Server\80\Tools\Bin\SQL Server Enterprise
Manager.msc
My sql server resides on D: and I have never had a problem opening SQL
Enterprise Manager. I can access the enterprise manager by adding the
snapin. Any ideas.
If you are launching it from a program icon those are all
shortcuts. Right click on the icon and select properties and
check the path to your SQL Server Enterprise Manager.msc
file.
-Sue
On Mon, 7 Nov 2005 06:30:09 -0800, KMD
<KMD@.discussions.microsoft.com> wrote:

>I have performed a windows update on the server and now i am presented with
>an error when trying to open enterprise manager. The MMC cannot find the
>file C:\Program Files\Microsoft SQL Server\80\Tools\Bin\SQL Server Enterprise
>Manager.msc
>My sql server resides on D: and I have never had a problem opening SQL
>Enterprise Manager. I can access the enterprise manager by adding the
>snapin. Any ideas.

cannot open Enterprise Manager

Hi All,
Several months ago, I installed SQL Server 2000
Development edition on my Windows XP laptop.
Today, for the first time, for some unknown reason I
cannot open the Enterprise Manager. I have been able to
open it, practically everyday, for the past few months.
I am getting the following Microsoft Management Console
error message:
"MMC cannot open the file C:\Program Files\Microsoft SQL
Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC.
This may be because the file does not exist, is not an
MMCconsole, or was created by a later version of MMC.
This may also be because you do not have sufficient
access rights to the file."
SQL Server Enterprise Manager.MSC file does exist in
I have all access rights to my laptop!
Any idea what have caused this problem and how could I
fix it.
Thank you,
MitraTry uninstalling / reinstalling the client tools, and/or reapplying SP3a.
--
http://www.aspfaq.com/
(Reverse address to reply.)
"mitra fatholahi" <mitra928@.hotmail.com> wrote in message
news:1b2d201c44f45$da666d60$a001280a@.phx.gbl...
> Hi All,
> Several months ago, I installed SQL Server 2000
> Development edition on my Windows XP laptop.
> Today, for the first time, for some unknown reason I
> cannot open the Enterprise Manager. I have been able to
> open it, practically everyday, for the past few months.
> I am getting the following Microsoft Management Console
> error message:
> "MMC cannot open the file C:\Program Files\Microsoft SQL
> Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC.
> This may be because the file does not exist, is not an
> MMCconsole, or was created by a later version of MMC.
> This may also be because you do not have sufficient
> access rights to the file."
> SQL Server Enterprise Manager.MSC file does exist in
> I have all access rights to my laptop!
> Any idea what have caused this problem and how could I
> fix it.
> Thank you,
> Mitra
>
>
>|||The file that becomes the SQL Server Enterprise Manager.MSC is named
SQLEM.MSC on the SQL Server 2000 CD. You can try copying the one form the
CD, renaming it and replcacing the one on disk.
Rand
This posting is provided "as is" with no warranties and confers no rights.sql

Cannot open Enterprise Manager

I have performed a windows update on the server and now i am presented with
an error when trying to open enterprise manager. The MMC cannot find the
file C:\Program Files\Microsoft SQL Server\80\Tools\Bin\SQL Server Enterprise
Manager.msc
My sql server resides on D: and I have never had a problem opening SQL
Enterprise Manager. I can access the enterprise manager by adding the
snapin. Any ideas.If you are launching it from a program icon those are all
shortcuts. Right click on the icon and select properties and
check the path to your SQL Server Enterprise Manager.msc
file.
-Sue
On Mon, 7 Nov 2005 06:30:09 -0800, KMD
<KMD@.discussions.microsoft.com> wrote:
>I have performed a windows update on the server and now i am presented with
>an error when trying to open enterprise manager. The MMC cannot find the
>file C:\Program Files\Microsoft SQL Server\80\Tools\Bin\SQL Server Enterprise
>Manager.msc
>My sql server resides on D: and I have never had a problem opening SQL
>Enterprise Manager. I can access the enterprise manager by adding the
>snapin. Any ideas.

Cannot open Enterprise Manager

I have performed a windows update on the server and now i am presented with
an error when trying to open enterprise manager. The MMC cannot find the
file C:\Program Files\Microsoft SQL Server\80\Tools\Bin\SQL Server Enterpris
e
Manager.msc
My sql server resides on D: and I have never had a problem opening SQL
Enterprise Manager. I can access the enterprise manager by adding the
snapin. Any ideas.If you are launching it from a program icon those are all
shortcuts. Right click on the icon and select properties and
check the path to your SQL Server Enterprise Manager.msc
file.
-Sue
On Mon, 7 Nov 2005 06:30:09 -0800, KMD
<KMD@.discussions.microsoft.com> wrote:

>I have performed a windows update on the server and now i am presented with
>an error when trying to open enterprise manager. The MMC cannot find the
>file C:\Program Files\Microsoft SQL Server\80\Tools\Bin\SQL Server Enterpri
se
>Manager.msc
>My sql server resides on D: and I have never had a problem opening SQL
>Enterprise Manager. I can access the enterprise manager by adding the
>snapin. Any ideas.

cannot open Enterprise Manager

Hi All,
Several months ago, I installed SQL Server 2000
Development edition on my Windows XP laptop.
Today, for the first time, for some unknown reason I
cannot open the Enterprise Manager. I have been able to
open it, practically everyday, for the past few months.
I am getting the following Microsoft Management Console
error message:
"MMC cannot open the file C:\Program Files\Microsoft SQL
Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC.
This may be because the file does not exist, is not an
MMCconsole, or was created by a later version of MMC.
This may also be because you do not have sufficient
access rights to the file."
SQL Server Enterprise Manager.MSC file does exist in
I have all access rights to my laptop!
Any idea what have caused this problem and how could I
fix it.
Thank you,
MitraTry uninstalling / reinstalling the client tools, and/or reapplying SP3a.
http://www.aspfaq.com/
(Reverse address to reply.)
"mitra fatholahi" <mitra928@.hotmail.com> wrote in message
news:1b2d201c44f45$da666d60$a001280a@.phx
.gbl...
> Hi All,
> Several months ago, I installed SQL Server 2000
> Development edition on my Windows XP laptop.
> Today, for the first time, for some unknown reason I
> cannot open the Enterprise Manager. I have been able to
> open it, practically everyday, for the past few months.
> I am getting the following Microsoft Management Console
> error message:
> "MMC cannot open the file C:\Program Files\Microsoft SQL
> Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC.
> This may be because the file does not exist, is not an
> MMCconsole, or was created by a later version of MMC.
> This may also be because you do not have sufficient
> access rights to the file."
> SQL Server Enterprise Manager.MSC file does exist in
> I have all access rights to my laptop!
> Any idea what have caused this problem and how could I
> fix it.
> Thank you,
> Mitra
>
>
>|||The file that becomes the SQL Server Enterprise Manager.MSC is named
SQLEM.MSC on the SQL Server 2000 CD. You can try copying the one form the
CD, renaming it and replcacing the one on disk.
Rand
This posting is provided "as is" with no warranties and confers no rights.

Sunday, March 11, 2012

Cannot modify data

Hi,
Sometimes when I try to modify data in enterprise manager, I get this error:
Key column information is insufficient or incorrect.
Too many rows were affected by
How can I solve this problem?
Many thanks in advance.
Leila
Hi
There are a few issue with modifying data in EM, this seems to be that the
row you are changing can not be distinguished i.e it does not have a Primary
Key. Query analyser is usually a better tool to do larger or more complex
updates.
John
"Leila" <lelas@.hotpop.com> wrote in message
news:uhjs7s6oEHA.1816@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Sometimes when I try to modify data in enterprise manager, I get this
error:
> Key column information is insufficient or incorrect.
> Too many rows were affected by
> How can I solve this problem?
> Many thanks in advance.
> Leila
>
|||I can image that if your PK has multiple columns, you might get this. So as
the previous poster suggests, change it using an update statement.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.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
"Leila" <lelas@.hotpop.com> wrote in message
news:uhjs7s6oEHA.1816@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Sometimes when I try to modify data in enterprise manager, I get this
error:
> Key column information is insufficient or incorrect.
> Too many rows were affected by
> How can I solve this problem?
> Many thanks in advance.
> Leila
>

Cannot modify data

Hi,
Sometimes when I try to modify data in enterprise manager, I get this error:
Key column information is insufficient or incorrect.
Too many rows were affected by
How can I solve this problem?
Many thanks in advance.
LeilaHi
There are a few issue with modifying data in EM, this seems to be that the
row you are changing can not be distinguished i.e it does not have a Primary
Key. Query analyser is usually a better tool to do larger or more complex
updates.
John
"Leila" <lelas@.hotpop.com> wrote in message
news:uhjs7s6oEHA.1816@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Sometimes when I try to modify data in enterprise manager, I get this
error:
> Key column information is insufficient or incorrect.
> Too many rows were affected by
> How can I solve this problem?
> Many thanks in advance.
> Leila
>|||I can image that if your PK has multiple columns, you might get this. So as
the previous poster suggests, change it using an update statement.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.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
"Leila" <lelas@.hotpop.com> wrote in message
news:uhjs7s6oEHA.1816@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Sometimes when I try to modify data in enterprise manager, I get this
error:
> Key column information is insufficient or incorrect.
> Too many rows were affected by
> How can I solve this problem?
> Many thanks in advance.
> Leila
>

Cannot make New role assignments

New role assignment does not work on my new installation of SQL Reporting Services Enterprise edition on a Windows 2003 server. From Report Manager I navigate to: Home->Properties and select 'New Role Assignment'. I fill in a local user and select the 'Browser' role and click 'OK'. Nothing happens - there is no post-back. I have the same problem for 'Site Settings'. It's as if the Report Manager is running in read-only mode. Do I need to change some configuration to facilitate changes?
Thanks,
--steveDo you see any script errors? They would show up in the lower left corner
of IE.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"stark" <stark@.discussions.microsoft.com> wrote in message
news:2AD202DE-EA7F-4AB2-B0D0-4B6B450C75DB@.microsoft.com...
> New role assignment does not work on my new installation of SQL Reporting
Services Enterprise edition on a Windows 2003 server. From Report Manager I
navigate to: Home->Properties and select 'New Role Assignment'. I fill in a
local user and select the 'Browser' role and click 'OK'. Nothing happens -
there is no post-back. I have the same problem for 'Site Settings'. It's as
if the Report Manager is running in read-only mode. Do I need to change some
configuration to facilitate changes?
> Thanks,
> --steve|||Dan,
I'm having the same problem on trying to create New Role on both spots as the previous poster. There is no script errors in lower left hand corner. The button "New Role" does not even post back to the browser as I always thought "submit" uses the method specified in form action? Any rate the button is not working and I'm using Windows 2003 as well with lastest Framework 1.1.
HTML Output from "EditGroup.aspx"
<input type="submit" name="ui_btnCreateNewRole" value="New Role" id="ui_btnCreateNewRole" class="msrs-button" />
"Daniel Reib [MSFT]" wrote:
> Do you see any script errors? They would show up in the lower left corner
> of IE.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "stark" <stark@.discussions.microsoft.com> wrote in message
> news:2AD202DE-EA7F-4AB2-B0D0-4B6B450C75DB@.microsoft.com...
> > New role assignment does not work on my new installation of SQL Reporting
> Services Enterprise edition on a Windows 2003 server. From Report Manager I
> navigate to: Home->Properties and select 'New Role Assignment'. I fill in a
> local user and select the 'Browser' role and click 'OK'. Nothing happens -
> there is no post-back. I have the same problem for 'Site Settings'. It's as
> if the Report Manager is running in read-only mode. Do I need to change some
> configuration to facilitate changes?
> > Thanks,
> > --steve
>
>|||I found the a partial work around to get access to exisitng parent roles.
When you create a report folder, and you click on the report folder, you will have a "security" link in left hand nav. This allowed me to assign to Browser role which I did not have access to under Parent site setting and properties. Also it will ask if youre sure you want to use specific security on that folder, you must say Yes. You can always revert back using the button provided.
"Daniel Reib [MSFT]" wrote:
> Do you see any script errors? They would show up in the lower left corner
> of IE.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "stark" <stark@.discussions.microsoft.com> wrote in message
> news:2AD202DE-EA7F-4AB2-B0D0-4B6B450C75DB@.microsoft.com...
> > New role assignment does not work on my new installation of SQL Reporting
> Services Enterprise edition on a Windows 2003 server. From Report Manager I
> navigate to: Home->Properties and select 'New Role Assignment'. I fill in a
> local user and select the 'Browser' role and click 'OK'. Nothing happens -
> there is no post-back. I have the same problem for 'Site Settings'. It's as
> if the Report Manager is running in read-only mode. Do I need to change some
> configuration to facilitate changes?
> > Thanks,
> > --steve
>
>|||We have the same problem on our reporting server as well (just after
we made the last SP installation), new rule and move report actions
are not working.
After clicking on the "OK" nothing happen, no script error or any
other error indication can be found.
Any ideas?|||Hi,
this should be it:
on the server run:
aspnet_regiis -c
from the .Net framwork dir.|||I have the same problem. This aspnet_regiis didn't solve it for me...
any other suggestions?
elad@.cydoor.com (Elad) wrote in message news:<2ba7f8ad.0408041410.38bd9598@.posting.google.com>...
> Hi,
> this should be it:
> on the server run:
> aspnet_regiis -c
> from the .Net framwork dir.|||I had the problem described above... and 'aspnet_regiis -c' worked out.
Win 2003 Server, SQL Srvr w/ sp3 and RS w/ sp1.
In case this helps anyone...
The installation had a problem (25619) with virtual directories and I had to
create them manually (setup parameter -rsdonotcreatevirtualdirectories=true)
which I found in a kb article. I followed the steps to create the vir dir's
after the install and everything functioned except for the problem described
in this thread.
Perhaps the following kb article should be updated with a step to execute
aspnet_regiis -c from the .net framework dir.
http://support.microsoft.com/?kbid=867872
"Scott Stonehouse" wrote:
> I have the same problem. This aspnet_regiis didn't solve it for me...
> any other suggestions?
> elad@.cydoor.com (Elad) wrote in message news:<2ba7f8ad.0408041410.38bd9598@.posting.google.com>...
> > Hi,
> >
> > this should be it:
> >
> > on the server run:
> > aspnet_regiis -c
> >
> > from the .Net framwork dir.
>

Thursday, March 8, 2012

Cannot load SQL Server Enterprise Manager

This morning when I tried to load SQL Server Enterprise Manager I got the
following error message dialog.
MMC cannot open the file C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\SQL Server Enterprise Manager.MCS.
This may be because the file does not exist, is not an MMC console, or was
created by a later version of MMC. This may also be because you do not have
sufficient access rights to the file.
The file exists, I've made the assumption it is an MMC console, I've had the
same version installed since sp-3 was distributed and I'm logged in under a
system adminsitrators account. Further, I've had and run the same setup for
several months with no problems.

Quote:

Originally posted by Charles
This morning when I tried to load SQL Server Enterprise Manager I got the
following error message dialog.
MMC cannot open the file C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\SQL Server Enterprise Manager.MCS.
This may be because the file does not exist, is not an MMC console, or was
created by a later version of MMC. This may also be because you do not have
sufficient access rights to the file.
The file exists, I've made the assumption it is an MMC console, I've had the
same version installed since sp-3 was distributed and I'm logged in under a
system adminsitrators account. Further, I've had and run the same setup for
several months with no problems.

cannot list tables or other objects

Sometimes, when a try to list tables or view (or access Management, etc) Enterprise Manager hungs up.
Using SELECT * FROM SYSOBECTS also freezes the process. But the SQLServer is operational for data updates and retrieves.
Anyone?
thanx!SYSOBJECTS along with SYSINDEXES, SYSPROTECTS, SYSDEPENDS, SYSCOLUMNS, and SYSCOMMENTS are the most frequently used system objects in every user database. You should ALWAYS use (NOLOCK) when attempting to directly retrieve data from those tables.|||You might also want to use the information_schema views rather than looking up directly in the tables. They're more typing but if this is part of a script/procedure having a lifetime that might span generations of SQL Server, this is safer. The system tables can change; the views will be kept stable.