Showing posts with label toinstall. Show all posts
Showing posts with label toinstall. Show all posts

Friday, March 30, 2012

Install QA only ?

If we want someone to use Query Analyzer only - allow end
user to run query by themselves, is it necessary for us to
install "Client Connectivity" on that machine as well?
Thanks
This is a duplicate post. It's been answered in another area.
"Paul" <anonymous@.discussions.microsoft.com> wrote in message
news:01d601c528e5$f105d400$a401280a@.phx.gbl...
> If we want someone to use Query Analyzer only - allow end
> user to run query by themselves, is it necessary for us to
> install "Client Connectivity" on that machine as well?
> Thanks
>
|||Dear Paul,
You suggest to remove the userid from Public database role
as follow:
+++++++++++++++++++++++
If you remove the public role permissions to what it
should have (ZERO), and limit the access users have in the
databases, they won't be able to do anymore with EM than
QA.
+++++++++++++++++++++++
However, from the newsgroup, a lot of people suggest that
we should not remove any user from the Public Role. Is it
OK for me to do so ?
Besides, the user belongs to the db_datareader role only,
is there still any problem ?
Since we are not using Reporting Service, is there any
other way to meet the need ?
Thanks

>--Original Message--
>This is a duplicate post. It's been answered in another
area.
>"Paul" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:01d601c528e5$f105d400$a401280a@.phx.gbl...
end[vbcol=seagreen]
to
>
>.
>

Install QA only ?

If we want someone to use Query Analyzer only - allow end
user to run query by themselves, is it necessary for us to
install "Client Connectivity" on that machine as well?
ThanksThis is a duplicate post. It's been answered in another area.
"Paul" <anonymous@.discussions.microsoft.com> wrote in message
news:01d601c528e5$f105d400$a401280a@.phx.gbl...
> If we want someone to use Query Analyzer only - allow end
> user to run query by themselves, is it necessary for us to
> install "Client Connectivity" on that machine as well?
> Thanks
>|||Dear Paul,
You suggest to remove the userid from Public database role
as follow:
+++++++++++++++++++++++
If you remove the public role permissions to what it
should have (ZERO), and limit the access users have in the
databases, they won't be able to do anymore with EM than
QA.
+++++++++++++++++++++++
However, from the newsgroup, a lot of people suggest that
we should not remove any user from the Public Role. Is it
OK for me to do so ?
Besides, the user belongs to the db_datareader role only,
is there still any problem ?
Since we are not using Reporting Service, is there any
other way to meet the need ?
Thanks

>--Original Message--
>This is a duplicate post. It's been answered in another
area.
>"Paul" <anonymous@.discussions.microsoft.com> wrote in
message
>news:01d601c528e5$f105d400$a401280a@.phx.gbl...
end[vbcol=seagreen]
to[vbcol=seagreen]
>
>.
>

Monday, March 26, 2012

Install MSDE on 2003 server cluster

I've two server 2003 configurated as cluster. How to
install MSDE2000A on nodes ?
hi Carlo,
Carlo Dolenz wrote:
> I've two server 2003 configurated as cluster. How to
> install MSDE2000A on nodes ?
AFAIK MSDE does not support cluster installation...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||You can install MSDE as an instance (default or named) on each node of the
cluster but MSDE is not cluster aware so if you're thinking of a
mini-failover cluster, that's not gonna happen with MSDE.
joe.
"Carlo Dolenz" <anonymous@.discussions.microsoft.com> wrote in message
news:282d01c514ea$7f039090$a501280a@.phx.gbl...
> I've two server 2003 configurated as cluster. How to
> install MSDE2000A on nodes ?

Friday, March 23, 2012

Install Failed

Sorry, but I am not overly knowledgabel about this topic. I am trying to
install MSDE on my Windows XP Pro machine at home so that I don't have to
commute so often. Alas, I keep getting failures. The part of the log where
"value 3" is is below but I can't see any information about why it failed.
Any help or guidance greatfully received.
Property(S): SqlStates = 0
Property(S): ROOTDRIVE = C:\
Property(S): CostingComplete = 1
Property(S): OutOfDiskSpace = 0
Property(S): OutOfNoRbDiskSpace = 0
Property(S): PrimaryVolumeSpaceAvailable = 0
Property(S): PrimaryVolumeSpaceRequired = 0
Property(S): PrimaryVolumeSpaceRemaining = 0
Property(S): SqlFeature = SqlRun
Property(S): SOURCEDIR = C:\Temporary\MSDE\Setup\
Property(S): SourcedirProduct = {E09B48B5-E141-427A-AB0C-D3605127224A}
Property(S): ProductToBeRegistered = 1
MSI (s) (F4:68): MainEngineThread is returning 1603
MSI (c) (D4:C4): Back from server. Return value: 1603
MSI (c) (D4:C4): Decrementing counter to disable shutdown. If counter >= 0,
shutdown will be denied. Counter after decrement: -1
Action ended 17:53:04: INSTALL. Return value 3.
MSI (c) (D4:C4): Note: 1: 2262 2: Control 3: -2147287038
Property(C): UpgradeCode = {421A321C-2214-4713-B3EB-253F2FBCCE49}
Property(C): VersionNT = 501
Property(C): ALLUSERS = 1
Property(C): ARPNOMODIFY = 1
Property(C): DefaultUIFont = Tahoma8
Property(C): INSTALLLEVEL = 3
Property(C): LIMITUI = 1
Property(C): Manufacturer = Microsoft Corporation
Property(C): ProductCode = {E09B48B5-E141-427A-AB0C-D3605127224A}
Property(C): ProductLanguage = 1033
Property(C): ProductName = Microsoft SQL Server Desktop Engine
Property(C): ProductVersion = 8.00.761
Property(C): MsiHiddenProperties = SqlSa...
Property(C): SQLVersion.2D02443E_7002_4C0B_ABC9_EAB2C064397B = 8.00.194
> Alas, I keep getting failures.
Can you be a bit more specific?
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
|||Sorry, I thought it was in the log file extract.
I run the MSDE installation as per the instructions and it gets so far then
backs out with the error in the log file.
I'm not sure what else you need to know, I can't find a reason for the
failure in the area of the log the instructions indicate, "Within 10 lines
of the string" ("value 3"). Sorry for being so vague.
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:%2367wSSsMEHA.3012@.tk2msftngp13.phx.gbl...
> Can you be a bit more specific?
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
|||Instead of worrying about "within 10 lines of the string," have you
considered searching the log file for the words "error" or "failure"?
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"news.microsoft.com" <jonathan_grant@.hotmail.com> wrote in message
news:#Eeg0EtMEHA.684@.TK2MSFTNGP09.phx.gbl...
> Sorry, I thought it was in the log file extract.
> I run the MSDE installation as per the instructions and it gets so far
then
> backs out with the error in the log file.
> I'm not sure what else you need to know, I can't find a reason for the
> failure in the area of the log the instructions indicate, "Within 10 lines
> of the string" ("value 3"). Sorry for being so vague.
>
> "Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
> news:%2367wSSsMEHA.3012@.tk2msftngp13.phx.gbl...
>
|||If I knew what I was looking for I wouldn't be asking for help here!
There are no instances of the word failure in the log. The reason I quoted
10 lines is because that it what it says in the Microsoft documentation. If
you can't or won't assist please leave this thread for someone who will.
|||> If I knew what I was looking for I wouldn't be asking for help here!
I told you what to look for: the word "error" or the word "failure."

> you can't or won't assist please leave this thread for someone who will.
Oh, for Christ's sake, I'm trying to help. I can't help you if I don't know
what the problem is. I can't fix "broken" or "failed" but I can point you
somewhere if you figure out what error you are getting. See my point
above... if you use verbose logging, the reason for a botched install will
be there somewhere.
A
|||I have searched the log and there is no instance of the word "failure". There are 37 "error" but I cannot for the life of me see any clues as to why the install failed in them. A lot of them seem to be removing stuff from the registry, etc, as a result o
f the failure. I appreciate that you are looking at this for no reward but please understand that I do not know any more than what I have read in the limited MS documentation and have picked up from this news group.
I copy the error lines from the log below:
MSI (s) (F4:68): Executing op: RegAddValue(,Value=Microsoft SQL Distribution Error lookup,)
WriteRegistryValues: Key: HKEY_LOCAL_MACHINE\Software\Classes\CLSID\{16D9A8E 2-C326-11d0-94E9-00C04FC2DB9C}\ExtendedErrors, Name: , Value: Microsoft SQL Distribution Error lookup
MSI (s) (F4:68): Executing op: RegAddValue(,Value=Error Lookup Service for Microsoft SQL Replication Distribution Provider,)
WriteRegistryValues: Key: HKEY_LOCAL_MACHINE\Software\Classes\CLSID\{16D9A8E 2-C326-11d0-94E9-00C04FC2DB9C}\ExtendedErrors\{246CBC55-F3E8-11d0-9AEB-00C04FB6B6EF}, Name: , Value: Error Lookup Service for Microsoft SQL Replication Distribution Provider
MSI (s) (F4:68): Executing op: RegAddValue(,Value=Microsoft SQL Replication Distribution Provider-Error Lookup,)
WriteRegistryValues: Key: HKEY_LOCAL_MACHINE\Software\Classes\CLSID\{246CBC5 5-F3E8-11d0-9AEB-00C04FB6B6EF}, Name: , Value: Microsoft SQL Replication Distribution Provider-Error Lookup
MSI (s) (F4:68): Executing op: RegAddValue(,Value=Microsoft SQL Replication Distribution Provider-Error Lookup,)
WriteRegistryValues: Key: HKEY_LOCAL_MACHINE\Software\Classes\CLSID\{246CBC5 5-F3E8-11d0-9AEB-00C04FB6B6EF}\ProgID, Name: , Value: Microsoft SQL Replication Distribution Provider-Error Lookup
MSI (s) (F4:68): Executing op: RegAddValue(,Value=Microsoft SQL Replication Distribution Provider-Error Lookup,)
WriteRegistryValues: Key: HKEY_LOCAL_MACHINE\Software\Classes\CLSID\{246CBC5 5-F3E8-11d0-9AEB-00C04FB6B6EF}\VersionIndependentProgID, Name: , Value: Microsoft SQL Replication Distribution Provider-Error Lookup
MSI (s) (F4:68): Executing op: RegAddValue(,Value=Microsoft SQL Replication Error Class,)
WriteRegistryValues: Key: HKEY_LOCAL_MACHINE\Software\Classes\SQLReplError.S QLReplError.2, Name: , Value: Microsoft SQL Replication Error Class
MSI (s) (F4:68): Executing op: RegAddValue(,Value=Microsoft SQL Replication Error Class,)
WriteRegistryValues: Key: HKEY_LOCAL_MACHINE\Software\Classes\SQLReplError.S QLReplError, Name: , Value: Microsoft SQL Replication Error Class
MSI (s) (F4:68): Executing op: RegAddValue(,Value=Microsoft SQL Replication Error Class,)
WriteRegistryValues: Key: HKEY_LOCAL_MACHINE\Software\Classes\CLSID\{08b0b2e b-3fb3-11d3-a4de-00c04f610189}, Name: , Value: Microsoft SQL Replication Error Class
MSI (s) (F4:68): Executing op: RegAddValue(,Value=Microsoft OLE DB Bulk Import Provider 7.5 Extended Error Service,)
WriteRegistryValues: Key: HKEY_LOCAL_MACHINE\Software\Classes\MSQLImpProvErr orLookup75, Name: , Value: Microsoft OLE DB Bulk Import Provider 7.5 Extended Error Service
MSI (s) (F4:68): Executing op: RegAddValue(,Value=Microsoft OLE DB Bulk Import Provider Extended Error Service,)
WriteRegistryValues: Key: HKEY_LOCAL_MACHINE\Software\Classes\MSQLImpProvErr orLookup, Name: , Value: Microsoft OLE DB Bulk Import Provider Extended Error Service
MSI (s) (F4:68): Executing op: RegAddValue(,Value=Microsoft OLE DB Bulk Import Provider 7.5 Extended Error Service,)
WriteRegistryValues: Key: HKEY_LOCAL_MACHINE\Software\Classes\MSQLImpProvErr orLookup\CurVer, Name: , Value: Microsoft OLE DB Bulk Import Provider 7.5 Extended Error Service
MSI (s) (F4:68): Executing op: RegAddValue(,Value=Microsoft OLE DB Bulk Import Provider Extended Error Service,)
WriteRegistryValues: Key: HKEY_LOCAL_MACHINE\Software\Classes\CLSID\{CB0122A 6-60BC-11D3-B2A6-00C04F68CBB6}, Name: , Value: Microsoft OLE DB Bulk Import Provider Extended Error Service
MSI (s) (F4:68): Executing op: RegRemoveValue(,Value=Microsoft OLE DB Bulk Import Provider Extended Error Service,)
MSI (s) (F4:68): Executing op: RegRemoveValue(,Value=Microsoft OLE DB Bulk Import Provider 7.5 Extended Error Service,)
MSI (s) (F4:68): Executing op: RegRemoveValue(,Value=Microsoft OLE DB Bulk Import Provider Extended Error Service,)
MSI (s) (F4:68): Executing op: RegRemoveValue(,Value=Microsoft OLE DB Bulk Import Provider 7.5 Extended Error Service,)
MSI (s) (F4:68): Executing op: RegRemoveValue(,Value=Microsoft SQL Replication Error Class,)
MSI (s) (F4:68): Executing op: RegRemoveValue(,Value=Microsoft SQL Replication Error Class,)
MSI (s) (F4:68): Executing op: RegRemoveValue(,Value=Microsoft SQL Replication Error Class,)
MSI (s) (F4:68): Executing op: RegRemoveValue(,Value=Microsoft SQL Replication Distribution Provider-Error Lookup,)
MSI (s) (F4:68): Executing op: RegRemoveValue(,Value=Microsoft SQL Replication Distribution Provider-Error Lookup,)
MSI (s) (F4:68): Executing op: RegRemoveValue(,Value=Microsoft SQL Replication Distribution Provider-Error Lookup,)
MSI (s) (F4:68): Executing op: RegRemoveValue(,Value=Error Lookup Service for Microsoft SQL Replication Distribution Provider,)
MSI (s) (F4:68): Executing op: RegRemoveValue(,Value=Microsoft SQL Distribution Error lookup,)
MSI (s) (F4:68): Error in rollback skipped. Return: 5
|||Hi Jonothan,
I'm gitting the same error. Was wondering if you managed to sort it out?
Regards
G.