Re-installing SP4

I posted a week or so ago about replication breaking after I installed SP4.
Raymond Mak queried about the login account I used and suggested registering
the dll's.
I did this but to no avail. I was wondering if I could re-run the SP4
install using the SQL Server account and if I need to do anything first.
i.e. can I rerun it straight away on a server already with SP4?
As the agents work from the command line, I'm sure the problem is dll / DCom
related but I'm not sure how to trace this further.
Any suggestions would be appreciated.
Thanks!
Hi Daryl,
The most important thing to check first is whether the replication Interface
guids are improperly ACL'd w.r.t. to your SQL Server Agent account. If so,
you may need to un-register and then re-register the replication components
under a high privileged account just so the ACLs on the replication guids are
refreshed. You can, of course, manually update the ACLs also. However, I am
guessing that you want a cleaner approach so you are wondering if an SP4
reinstall will work. My take is that since we don't fully understand why the
problem happened in the first place, a reinstall may lead you to the same
problem with a slight risk of aggravating other parts of the system (well, I
am chicken . As to why the ACLing problem happened in the first place, I do
have the following semi-educated guesses:
1) SP4 setup could not retrieve information for the SQL Server Agent service
account and so cannot add it to the ACLs of the replication component reg
keys. This may be a domain issue if SQL Server Agent service account is a
domain account or the account running SP4 setup simply doesn't have enough
privilege to enumerate the Agent service account information.
2) The SQL Server Agent service account was changed outside of Enterprise
Manager after SP4 install.
I can be completely wrong above but in any case, it would be tremendously
useful if you can let us know of anything unusual when you first set up SP4.
Thanks much.
-Raymond
"DJ" wrote:

> I posted a week or so ago about replication breaking after I installed SP4.
> Raymond Mak queried about the login account I used and suggested registering
> the dll's.
> I did this but to no avail. I was wondering if I could re-run the SP4
> install using the SQL Server account and if I need to do anything first.
> i.e. can I rerun it straight away on a server already with SP4?
> As the agents work from the command line, I'm sure the problem is dll / DCom
> related but I'm not sure how to trace this further.
> Any suggestions would be appreciated.
> Thanks!
>
>
|||Thanks for the reply Raymond
I'm guessing the problem was probably caused by running SP4 with an account
with lower permissions.
I will try unregistering the components with the service account but what is
the command / what do I un-register?
I'll let you know the outcome.
Many Thanks again
Daryl
"Raymond Mak [MSFT]" wrote:
[vbcol=seagreen]
> Hi Daryl,
> The most important thing to check first is whether the replication Interface
> guids are improperly ACL'd w.r.t. to your SQL Server Agent account. If so,
> you may need to un-register and then re-register the replication components
> under a high privileged account just so the ACLs on the replication guids are
> refreshed. You can, of course, manually update the ACLs also. However, I am
> guessing that you want a cleaner approach so you are wondering if an SP4
> reinstall will work. My take is that since we don't fully understand why the
> problem happened in the first place, a reinstall may lead you to the same
> problem with a slight risk of aggravating other parts of the system (well, I
> am chicken . As to why the ACLing problem happened in the first place, I do
> have the following semi-educated guesses:
> 1) SP4 setup could not retrieve information for the SQL Server Agent service
> account and so cannot add it to the ACLs of the replication component reg
> keys. This may be a domain issue if SQL Server Agent service account is a
> domain account or the account running SP4 setup simply doesn't have enough
> privilege to enumerate the Agent service account information.
> 2) The SQL Server Agent service account was changed outside of Enterprise
> Manager after SP4 install.
> I can be completely wrong above but in any case, it would be tremendously
> useful if you can let us know of anything unusual when you first set up SP4.
> Thanks much.
> -Raymond
> "DJ" wrote:
|||Hi Daryl,
For exe COM servers, you just need run the executable with the /UnRegServer
parameter followed by running it with the /RegServer parameter, e.g.
snapshot.exe /UnRegServer&snapshot.exe /RegServer. For dll COM components in
the 80\COM directory, you just need to run regsvr32 /u followed by regsvr32
on it, e.g. regsvr32 /u replagnt.dll®svr32 replagnt.dll.
-Raymond
"DJ" <DJ@.discussions.microsoft.com> wrote in message
news:FAA6361C-AB9E-468F-B998-212EB2EE18A9@.microsoft.com...[vbcol=seagreen]
> Thanks for the reply Raymond
> I'm guessing the problem was probably caused by running SP4 with an
> account
> with lower permissions.
> I will try unregistering the components with the service account but what
> is
> the command / what do I un-register?
> I'll let you know the outcome.
> Many Thanks again
> Daryl
> "Raymond Mak [MSFT]" wrote:
|||Hi Raymond
I un-registered and then re-registered them and then stopped and started the
agent (using the loacal admin account) but I still get the same error.
There was nothing unusual when I first ran SP4, although it did take ages.
I'm off home for today (in the UK) but any thoughts are appreciated as always.
Daryl
"Raymond Mak [MSFT]" wrote:

> Hi Daryl,
> For exe COM servers, you just need run the executable with the /UnRegServer
> parameter followed by running it with the /RegServer parameter, e.g.
> snapshot.exe /UnRegServer&snapshot.exe /RegServer. For dll COM components in
> the 80\COM directory, you just need to run regsvr32 /u followed by regsvr32
> on it, e.g. regsvr32 /u replagnt.dll®svr32 replagnt.dll.
> -Raymond
> "DJ" <DJ@.discussions.microsoft.com> wrote in message
> news:FAA6361C-AB9E-468F-B998-212EB2EE18A9@.microsoft.com...
>
>
|||I am pretty much out of ideas now... have you checked the ACLs on the
replication reg keys? Can you run, say, the snapshot agent from the command
line?
"DJ" <DJ@.discussions.microsoft.com> wrote in message
news:2A2307B3-DE6E-402E-A8C1-317B55D7FBF2@.microsoft.com...[vbcol=seagreen]
> Hi Raymond
> I un-registered and then re-registered them and then stopped and started
> the
> agent (using the loacal admin account) but I still get the same error.
> There was nothing unusual when I first ran SP4, although it did take ages.
> I'm off home for today (in the UK) but any thoughts are appreciated as
> always.
> Daryl
> "Raymond Mak [MSFT]" wrote:
|||Forgot to mention that you may want to try out regmon from
sysinternals.com...
-Raymond
"Raymond Mak [MSFT]" <rmak@.online.microsoft.com> wrote in message
news:ebwjbh93FHA.3628@.TK2MSFTNGP12.phx.gbl...
>I am pretty much out of ideas now... have you checked the ACLs on the
>replication reg keys? Can you run, say, the snapshot agent from the command
>line?
> "DJ" <DJ@.discussions.microsoft.com> wrote in message
> news:2A2307B3-DE6E-402E-A8C1-317B55D7FBF2@.microsoft.com...
>
|||Thanks for your help Raymond
I've run regmon and filemon the server and when I use the command line, all
processes have the '.exe' icon associated with them. When I run this via EM,
the same processes have a blue square and 'process not accessable'.
However when I compare the permissions at this level, nothing looks out of
place.
Can you confirm what the icons mean and if this does point to a permissions
error?
If I change the owner of the SQLAgent job, will this change who the job tuns
under or is it always the SQL Agent account?
Thanks again for all your help, I would not have known where to start!
Daryl
|||Hi Daryl,
First of all, I might have been on a completely wrong track here so you
should probably keep an open mind that what you are seeing may not be a
permission problem (although I can't really think of an alternative at the
moment). But in case this is indeed a permission problem, you should focus
your attention on SQL Server Agent through reg|filemon and see if it has
trouble accessing certain registry keys (for COM object creation) or files
(various replication COM components). It is actually a really good idea to
run SQL Server Agent temporarily under a high-privileged account (some admin
on the box) just so you can quickly tell whether this is a permission
problem or not. I will also encourage you to focus your troubleshooting
effort on just one agent, say, the snapshot agent which involved the
following components:
80\COM\snapshot.exe
80\COM\rinitcom.dll
80\COM\replagnt.dll
80\COM\Resources\1033\replres.rll
I am not sure if I mentioned this already but you should definitely start a
CMD window under your current SQL Server Agent account and experiment with
starting various agents from that window. This should hopefully a better
means to isolate what the problem is.
-Raymond
"DJ" <DJ@.discussions.microsoft.com> wrote in message
news:7F43DE84-E387-47B5-A735-5F5FD13A5585@.microsoft.com...
> Thanks for your help Raymond
> I've run regmon and filemon the server and when I use the command line,
> all
> processes have the '.exe' icon associated with them. When I run this via
> EM,
> the same processes have a blue square and 'process not accessable'.
> However when I compare the permissions at this level, nothing looks out of
> place.
> Can you confirm what the icons mean and if this does point to a
> permissions
> error?
> If I change the owner of the SQLAgent job, will this change who the job
> tuns
> under or is it always the SQL Agent account?
> Thanks again for all your help, I would not have known where to start!
> Daryl
>

Re-installing RS 2000 report designer

I am somewhat of an RS newbie -- many months ago I installed RS (using sql
v2K, VS 2005) and created a handful of projects - nothing crazy, but they
worked. Recently I needed to get in there and either edit an existing or
create a new one, but I am unable to do so. In VS, start page, if I hit my
project, it fails w/this error:
The application for projetc 'D:\Projects\....\Project Name.rptproj' is not
installed.
Make sure the application for the project type (.rptproj) is installed.
I have tried everything - I even removed and reinstalled VS. Still get the
same error, nothing works.
In VS, New Project, Business Intelligence Projects is no longer available.
Also, all reports are available/visible via Report Manager. I just can't
get into VS to access/edit them, or to create new ones.
I've done a little surfing, have seen indication that I may need to
re-install the report designer. Is that correct, and if so, how do I do that?
Any advice at all really is appreciated.
-- LynnCan anybody tell me how to uninstall/reinstall RS 2000 report designer?
-- Lynn
"Lynn" wrote:
> I am somewhat of an RS newbie -- many months ago I installed RS (using sql
> v2K, VS 2005) and created a handful of projects - nothing crazy, but they
> worked. Recently I needed to get in there and either edit an existing or
> create a new one, but I am unable to do so. In VS, start page, if I hit my
> project, it fails w/this error:
> The application for projetc 'D:\Projects\....\Project Name.rptproj' is not
> installed.
> Make sure the application for the project type (.rptproj) is installed.
> I have tried everything - I even removed and reinstalled VS. Still get the
> same error, nothing works.
> In VS, New Project, Business Intelligence Projects is no longer available.
> Also, all reports are available/visible via Report Manager. I just can't
> get into VS to access/edit them, or to create new ones.
> I've done a little surfing, have seen indication that I may need to
> re-install the report designer. Is that correct, and if so, how do I do that?
> Any advice at all really is appreciated.
> -- Lynn

reinstalling As

good day to all!

well i'm having a problem: i had As installed in my computer. then i needed to unistall it and now that i nedd to reinstall analysis server i have a message "please unistall the previous version". but i had do it? can someone tell me what to do? ( i'm not thinking in installing windows again!)

thx!

Hi

Try doing it from the commandline with the switch SKUUPGRADE=1. SQLDIR\setup SKUUPGRADE=1

Re-Installation problem (prev installations not removed completely)

I have installed SQL server 2005 on Win SERVER 2003, then uninstalled and then re-installed but I have found out that the previous instances are still listed and the the previous collation too (I have changed reg setting and and language option re-installation).

It looks like that removing program does not remove completely every object, probably registry values

Do you know how to perform a good uninstallation removing everything (add/remove program does not work properly as written before) ?

Any help will be very appreciated.

Thank

After uninstalling SQL Server, check the ARP to confirm that the SQL Server Native Client was also removed. There are a few other support-type components that remain on your box from time to time. This is one of them.

Thanks,
Sam Lester (MSFT)|||

Because some modules are shared among instances on the same machine, I will not be able to unstall the shared modules, like SQL Native Client,etc.

If I had installed several instances of SQL 2005, will I get problems if I uninstall and reinstall some instances later?

NP

Re-Installation of SQLExpress on XP SP2 Chinese Tra Version

When I installed SQL Express first time a few days ago, it work ok. But, after removing all sql server componets through 'control panel'->'add or remove programs,' something seems wrong in the registry because the re-installation of SQLExpress will never success with an error

-

- Performance Monitor Counter Requirement (Error)
Messages
Performance Monitor Counter Requirement
The System Configuration Check for Performance Monitor counter registry value has failed. For details, see How to: Increment the Counter Registry Key for Setup in SQL Server 2005, in the readme file or in SQL Server Books Online.

in setup configuration checker. I follow the instructions in help page and try to set the values "Last Counter" and "Last Help" in '[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib]' as same as the values "Counter" and "Help" in '[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib]'.........but the data type are dword and string resp. So, setup checker will think the values are different and no way to reinstall the SQLExpress.

Can anyone tell me how to fix it or just let me know SQLExpress not for Chinese XP SP2?

Thank you

Hi Andrew,

I've looked over the instructions that you're reading and they are a bit difficult to follow, but they do work once you figure it out. The issue is that you need to find the maximum value for the Counter and Help keys, but because of the data type of the key, the maximum value is not necesarily the last one in the list because they are not sorted numerically. Try to follow the instructions again, but this time when you're looking up the values, be sure to examine all the numbers to get the highest one. Remember they are sorted as strings, so the value list may look like...

1, 10, 11, 12, 13, 14, 2, 3, 4, 5

In this case the highest number if 14, which is in the middle of the list, not the 5 at the end. The first time I went though this myself I automactically picked the last number in the value list assuming it was numerically sorted; I was wrong. Hopefully this will solve the issue for you.

Mike

|||Thanks for your explanation and the problem is solved. sql

Reinstall SQL Server 2005 Problem (cannot connect to <server>)

I had installed SQL Server 2005 for the first time in order to study for the SQL SERVER 2005 Implementation and Maintenance exam. Everything was going ok until I got to the section on Partitions. When I attempted to follow the lessons on partitions, I received an error indicating that the Enterprise Edition was needed for Partitions.

I uninstalled SQL Server and re-installed the Enterprise Edition (MSDN disk). When I re-installed, I was not promopted for a new/default instance name). The old instance that had used for the original installation is presented when I attempt to "Connect to Server." When I select that instance and click Connect, I receive the "Cannot connect to <server name>" error message.

How do I re-establish that instance name or create another default instance?

Regards - Tony

Would you check Control Panel -> Add/Remove Programs? If there is still SQL Server 2005 entry, please choose it and click change, then click Report button to get all information about SQL Server 2005. The report will tell you which components of SQL Server 2005 are still existing on your machine.

Based on your description, maybe the previous SQL Server 2005 has not been uninstalled successfully.

If you do not mind, you can type in a new instance name to install another instance as multiple instacnes are supported provided that you have enough resourses such as free disk space.

Reinstall SQL 2005 Management Studio

We are running SQL 2005 Standard Server. Apparently our server was slightly
"damaged" and SQL 2005 Management Studio is no longer installed.
How can I re-intall this? I have tried reloading SQL to no avail. I am not
seeing it as an option. I am selecting client tools during the installation.
SQL Server is running as Dynamics GP is functional.
I am wondering if it is installed and the shortcut is missing. Can anyone
tell me the executable program name and the location so I can check this.
All help greatly appreciated.Jerry
Try Start--Run--sqlwb.exe
"Jerry Flatto" <JerryFlatto@.discussions.microsoft.com> wrote in message
news:63E1823D-01D7-435E-AF5B-25629A2CEF7B@.microsoft.com...
> We are running SQL 2005 Standard Server. Apparently our server was
> slightly
> "damaged" and SQL 2005 Management Studio is no longer installed.
> How can I re-intall this? I have tried reloading SQL to no avail. I am not
> seeing it as an option. I am selecting client tools during the
> installation.
> SQL Server is running as Dynamics GP is functional.
> I am wondering if it is installed and the shortcut is missing. Can anyone
> tell me the executable program name and the location so I can check this.
> All help greatly appreciated.|||THANKS!!!. That solved the problem. Unfortunately, the exe's name was so
cryptic, I did not realize that the program was still even installed.
Jerry
"Uri Dimant" wrote:
> Jerry
> Try Start--Run--sqlwb.exe
>|||In SQL Server 2008, SQL Server Management Studio' s executable file name is
"ssms.exe".
--
Ekrem Ã?nsoy
"Jerry Flatto" <JerryFlatto@.discussions.microsoft.com> wrote in message
news:48CCC995-0509-4BCA-8FC9-EAC9197C3F72@.microsoft.com...
> THANKS!!!. That solved the problem. Unfortunately, the exe's name was so
> cryptic, I did not realize that the program was still even installed.
> Jerry
> "Uri Dimant" wrote:
>> Jerry
>> Try Start--Run--sqlwb.exe
>>|||The tool was, while in beta, called "SQL Server WorkBench", and the name for the exe file stayed...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Jerry Flatto" <JerryFlatto@.discussions.microsoft.com> wrote in message
news:48CCC995-0509-4BCA-8FC9-EAC9197C3F72@.microsoft.com...
> THANKS!!!. That solved the problem. Unfortunately, the exe's name was so
> cryptic, I did not realize that the program was still even installed.
> Jerry
> "Uri Dimant" wrote:
>> Jerry
>> Try Start--Run--sqlwb.exe
>>

Reinstall RS Client?

Hi,
I have purchased a new copy of SQL Server for running Reporting Service as
the Evaluation copy has expired.
I have installed Visual Studio with RS client on a workstation as I don't
want to install Report Designer on the Server.
I would like to know is it necessary for me to uninstall the Evaluation Copy
RS Client on my workstation before installing the new RS Client ?
Your advice is sought.I am pretty sure the evaluation expiration is only the server part of RS,
not the design tools. Are you getting a message saying that it has expired
when you try to design? You should still be able to design and preview. If
that is the case (I am trying to remember what I did but I don't think I did
anything with the client tools). Unless you have a problem my suggestion is
to leave the designer alone. After installing the new server you should
download SP2 and install that at both the server and the client.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Peter" <Peter@.discussions.microsoft.com> wrote in message
news:%239RZUnfsFHA.3424@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have purchased a new copy of SQL Server for running Reporting Service as
> the Evaluation copy has expired.
> I have installed Visual Studio with RS client on a workstation as I don't
> want to install Report Designer on the Server.
> I would like to know is it necessary for me to uninstall the Evaluation
> Copy RS Client on my workstation before installing the new RS Client ?
> Your advice is sought.
>

Reinstall operating system without loosing SQL data?

If I have SQL server installed on one partition(D:) and the OS installed on
another(C:), if I need to re-install the OS is it possible to re-install SQL
server without loosing my already created databases?
The drive with the OS got corrupted somehow over the weekend, but the SQL
server drive still seems to be working just fine.As long as the database data and log files are on a DIFFERENT physical
drive, you can re-install SQL Server, then use sp_attach_db to re-attach the
physical files to the new SQL Server..
Look for sp_attach_db in the SQL Books.
--
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
"Russ" <russ@.acordiamn.com> wrote in message
news:%23e2DsMVcDHA.2572@.TK2MSFTNGP12.phx.gbl...
> If I have SQL server installed on one partition(D:) and the OS installed
on
> another(C:), if I need to re-install the OS is it possible to re-install
SQL
> server without loosing my already created databases?
> The drive with the OS got corrupted somehow over the weekend, but the SQL
> server drive still seems to be working just fine.
>|||You can use 'sp_change_users_login' to (find unconnected
users through 'report' option and ) link existing logins
with database permissions. Now, the logins are maintained
in master and will be lost upon new installation or master
rebuild. You have to re-enter all login/password
information. Alternatively, you can keep list of passwords
with you through this script generator
select 'EXEC sp_addlogin '''+name+''', ', CONVERT(VARBINARY
(32), password), ', @.encryptopt = ''skip_encryption'''
from syslogins
where dbname='test' -- database name
and name <> 'sa' -- exclusion list
order by name
(replace TABS with space on the resulting script and
execute it to create logins)
Happy computing,
Muhammad Zeeshan
>--Original Message--
>If I backup the Data files (mdf & ldf) before
reinstalling can I avoid
>having to redo all the permissions for the various
databases?
>I also have tape back-ups, but using them to restore
would lose the last
>weeks worth of data, so I would rather not have to do
that if it can be
>avoided.
>
>"Russ" <russ@.acordiamn.com> wrote in message
>news:%23e2DsMVcDHA.2572@.TK2MSFTNGP12.phx.gbl...
>> If I have SQL server installed on one partition(D:) and
the OS installed
>on
>> another(C:), if I need to re-install the OS is it
possible to re-install
>SQL
>> server without loosing my already created databases?
>> The drive with the OS got corrupted somehow over the
weekend, but the SQL
>> server drive still seems to be working just fine.
>>
>
>.
>sql

Registry key setting for MS SQL Server

I am installing my application thru Installshield Professional 5. How
to know whether MS SQL Server is installed or not on the machine on
which i am installing my application. What is the registry key thru
which we can find this."harish" <harishksh@.yahoo.com> wrote in message
news:ff46df6e.0401090401.732c0ecb@.posting.google.c om...
> I am installing my application thru Installshield Professional 5. How
> to know whether MS SQL Server is installed or not on the machine on
> which i am installing my application. What is the registry key thru
> which we can find this.

Have a look at points 12 and 13 in this KB article:

http://support.microsoft.com/defaul...6&Product=sql2k

Simon

registry key for sql server 2000

I would like to know what is the registry key where is written that SQL Server 2000 is installed and the registry key where is the path to the data folder (master database) on Windows Server 2003. thanks
IrinaI would not answer registry key part of your question but the Master database can be accessed in Enterprise Manager and the data files are in Data Folder in Microsoft SQL Server folder in the programs folder in Win2003. Hope this helps.

Registry For Cluster

What is the registry path for checking if there is a SQLServer installed as a
virtual server on the machine. What I am trying to get here is if I logged on
to a machine and I want to read from registry if there is any SQL Virtual
server installed on this machine or not. I need to know all the names of SQL
that could be a default instance on virtual server or a named instance.
It is a windows 2003 in sql 2000 environment.
Any help will be appreciated.
-Nitin
What a terrible newsgroup it is. Not even people from MS respond to the
request hanging for over 2 days
"Nitin" wrote:

> What is the registry path for checking if there is a SQLServer installed as a
> virtual server on the machine. What I am trying to get here is if I logged on
> to a machine and I want to read from registry if there is any SQL Virtual
> server installed on this machine or not. I need to know all the names of SQL
> that could be a default instance on virtual server or a named instance.
> It is a windows 2003 in sql 2000 environment.
> Any help will be appreciated.
> -Nitin
|||Personally, I would not interrogate the registry to find whether there is any
clustered SQL instance. rather, I'd just use Cluster Automation Server (CAS)
via a script. See this article
http://support.microsoft.com/default...B;en-us;244597
for an example on how to script with CAS.
Linchi
"Nitin" wrote:

> What is the registry path for checking if there is a SQLServer installed as a
> virtual server on the machine. What I am trying to get here is if I logged on
> to a machine and I want to read from registry if there is any SQL Virtual
> server installed on this machine or not. I need to know all the names of SQL
> that could be a default instance on virtual server or a named instance.
> It is a windows 2003 in sql 2000 environment.
> Any help will be appreciated.
> -Nitin

Registration of SQL Server

Helo All,
We have two W2K servers. One is an SQL Server(S1) and another one is a
server (S2) on which SSL Certificate is installed.
When I try to register SQL Server from S2 through enterprises manager,
following error occured:
Encryption not supported on SQL Server| ConnectionOpen(PreLoginHandshake...
In this scenario is it mandatory to have SSL installed on the SQL Server
Machine (S1) also?
Any comment on this would be highly helpful.
Thanks in anticipation!
Warm Regards
Sathian>
> We have two W2K servers. One is an SQL Server(S1) and another one is a
> server (S2) on which SSL Certificate is installed.
> When I try to register SQL Server from S2 through enterprises manager,
> following error occured:
> Encryption not supported on SQL Server|
ConnectionOpen(PreLoginHandshake...
> In this scenario is it mandatory to have SSL installed on the SQL Server
> Machine (S1) also?
> Any comment on this would be highly helpful.
--
This error indicates either sql server server thinks the certificate is
invalid
or can't locate the certificate. To check if Sql Server can use a
certificate, enable
force protocol encryption on the server side and restart the service. If
Sql Server starts then certificate is okay.
The error can also occur if you have installed the certificate on sql
server but
have not restarted sql. so even if you are using client side encryption,
you need to restart sql server once the certificate is installed.
Hope this helps,
--
Eric Cárdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.

Registration of SQL Server

Helo All,
We have two W2K servers. One is an SQL Server(S1) and another one is a
server (S2) on which SSL Certificate is installed.
When I try to register SQL Server from S2 through enterprises manager,
following error occured:
Encryption not supported on SQL Server| ConnectionOpen(PreLoginHandshake...
In this scenario is it mandatory to have SSL installed on the SQL Server
Machine (S1) also?
Any comment on this would be highly helpful.
Thanks in anticipation!
Warm Regards
Sathian
>
> We have two W2K servers. One is an SQL Server(S1) and another one is a
> server (S2) on which SSL Certificate is installed.
> When I try to register SQL Server from S2 through enterprises manager,
> following error occured:
> Encryption not supported on SQL Server|
ConnectionOpen(PreLoginHandshake...
> In this scenario is it mandatory to have SSL installed on the SQL Server
> Machine (S1) also?
> Any comment on this would be highly helpful.
This error indicates either sql server server thinks the certificate is
invalid
or can't locate the certificate. To check if Sql Server can use a
certificate, enable
force protocol encryption on the server side and restart the service. If
Sql Server starts then certificate is okay.
The error can also occur if you have installed the certificate on sql
server but
have not restarted sql. so even if you are using client side encryption,
you need to restart sql server once the certificate is installed.
Hope this helps,
Eric Crdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.

Registration of mobile data provider for SQLCE

Hi All,
I have just installed SQL Server Compact Edition (including the SDK) for use with Borland Developer Studio 2006. I have an ADOConnection component on my form, but the Provider I want (Microsoft.SQLSERVER.MOBILE.OLEDB.3.0) is not available. Typing in the connection string: "Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data Source=C:\Program Files\Microsoft SQL Server Compact Edition\v3.1\SDK\Samples\Northwind.sdf..." results in an "Unspecified Error". I have checked the HKEY_CLASSES_ROOT\CLSID and the provider associated with SQLCE is not there.
I've read a couple of posts indicating that it should have been registered during install. Is this the case or do I have to do something more to register this provider?
I've checked the assembly (system.data.sqlserverCe - it seems OK) and re-registered sqlceolebd30.dll. I'm not sure what else needs to be done.
TIA,
Luke
Have you downloaded and installed this? http://www.microsoft.com/downloads/details.aspx?FamilyId=%2085E0C3CE-3FA1-453A-8CE9-AF6CA20946C3&displaylang=en|||Thanks for you reply Erik.
I have downloaded that msi, along with the SSCE31SDK-ENU.msi.
On the link that you specified the Additional Information states in part that " Installing SQL Server 2005 Compact Edition by running SQLServerCE31-EN.msi installs the provider (System.Data.SqlServerCe.dll) in the GAC (global assembly cache) and registers the OLEDB provider (sqlceoledb30.dll)."
For some reason that hasn't happened. I'll look into some other way of registering the provider.
Thanks again.
|||

You can test if it is an OLEDB provider problem by running this VBA code in Excel/word or similar:

Code Snippet

Sub test()

Dim conn As New ADODB.Connection
conn.ConnectionString = "Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data Source=C:\Program Files\Microsoft SQL Server Compact Edition\v3.1\SDK\Samples\Northwind.sdf"
conn.Open

End Sub

(remember to add a reference to "Microsoft ActiveX Data Objects 2.8 Library")

If this works, it is a 3rd party problem...

|||Thanks Erik. I tried that in Excel and it worked so I figured it must be Delphi related, and it was.
For some reason I am not able to hook up the ADO components at design time - it raises an error. If I set the connection string at run time it works. I tried this yesterday with no luck, but this morning I uninstalled/reinstalled SQL Server Compact (with SDK and server tools) and the run time test worked, so I may well have done something with my original install that was causing me problems.

Registering/licensing DEMO SQLserver....

Hello,

I am new to SQLserver and have installed the DEMO version of SQLserver 2000 on my system. I got it up and running and verified that it was working properly.

I then purchased two CPU's of the standard edition for my system. The software has arrived, but all that arrived are the CD's. I see no key, nor do I see a way to provide a key even if I had one.

I do not know how to proceeed and need help to figure out how to obtain a key or how to enter it if I ever obtain one.

Any help is greatly appreciated!!!!!

Thanks,

JamesActually, your CD's are supposed to be accompanied by invoice where corresponding keys are clearly printed out. If this is not the case you fell victim to some SW scam.|||Ask the vendor for such keys, in general MS software CDs comes with CD key printed on the CD or a paper attached to the CD cover.|||No such keys on the CD or paper. We are trying to get paperwork for the licenses. When I do get it how do I put them in? I saw no place to put a license in the system. I looked at length, but it obviously means I was not looking in the right place!

Anyone know how to put the key into the system?

James|||look in adminstrative tools
open licensing
you can add\update your lic there

when you say DEMO version of SQL Server, what do you mean?|||I take it DEMO means eval version, and Licensing service in Control Panel has nothing to do with Product Key, BTW.|||i didnt think that he was talking about a product key
he mentions

No such keys on the CD or paper. We are trying to get paperwork for the licenses. When I do get it how do I put them in? I saw no place to put a license in the system. I looked at length, but it obviously means I was not looking in the right place!

Anyone know how to put the key into the system?


i assume he is discussing lics and then he mentions keys!!!??

i'm linguistically hogtied.|||I think it is I that is not making myself clear due to the fact that I really do not know. I have never done this before, and I am sure it is a very simple question.

We have ordered two CPU licenses for SQL Server and I have not seen anything that looks like a "key" that I would normally associate as a Microsoft license key. Hence, I think we need the paperwork that goes with the licenses from my vendor as the others have mentioned. I am awaiting that now (I hope).

I think the issues came when I asked how to register (license) the product once I get the license keys. I have found no way to actually put those ubiquitous Microsoft keys in (that I am not in possession of at this time) to any software.

To an old unix person it is a mystery.

Thanks again for putting up with my silliness.

James|||Oh, so you're saying that throughout the installation process you did not have to nor were you asked to enter the Product Key?

Can you send me this CD?|||Are those by any chance "SELECT" CD's? If you work for a corporation with volume licensing, your company may get CDs with their registration number "burned in", and pay for licenses based on inventory rather than buying them at retail.

-PatP|||Yup, that's what it sounds like...unless it's an eval, 90 or 120-day.|||I initially loaded the evaluation version that I downloaded off the web. I was calling this the DEMO version in earlier emails, sorry for that mixup.

I was also told that it was a full copy and all I needed to do was apply my licenses when they arrived. That is where the problem is, both not having the license keys, nor knowing how or being able to find out how to apply them when they do arrive.

I am handling getting the keys, but need to know how to apply them when they come.

James|||So, do you have a CD?|||I do now, but I do not see anything that looks like a Microsoft key anywhere on them. Nor did the paperwork have anything like that.|||Did you buy these CDs from a vendor, or requisition them from some kind of "IT Central" within your organization?

-PatP|||If the CD does NOT have anything like "Evaluation...", then uninstall your eval AFTER BACKING UP MASTER, MSDB, and your own DATABASES (!!!), and proceed with normal installation from the CD. If you do run into "Enter Product Key..." situation, contact your SW vendor or whoever you purchased it from, else - keep going. Once installed, you'll need to restore your master (check Books Online) and msdb, along with your user database. Last, but not least - download and apply SP3.|||Heck, I'm paranoid. I remove the TCP/IP, install SQL 2000, install either sp2 or sp3a, then reboot. Once the box has gone down, then I plug the TCP/IP cable back into it.

-PatP|||Answers:

1) These are licenses we pruchased from a vendor we deal with all the time. I actually got two sets of CD's instead of just one, I guess since I ordered two CPU's worth of licenses.

2) We do not have a site license, we are a small organization and this is the first time we are using SQLserver.

Outlook:

So, it looks like I will need to do the thing I didn't want to do which is de-install the evaluation copy and re-install the real one off CD. Of course I will not do this until I get what looks like Microsoft keys (or the like) in my hands.

Thanks for all the help. Hopefully I can learn more about this stuff and help a few others along the way.

James

Registering sqldmo.dll

Hi everybody,

I have a problem with registering sqldmo.dll (version 2000) on Win98 on client machine with no sql-server installed.
First I have run the sqlredis.exe and than I have copied all files described in sqlredis.txt into the windows system directory and than I run regsvr32 to register sqldmo.dll. On Win2000 seems to be all OK but on Win98 I got error 0x80040154: DllRegisterServer in sqldmo.dll failed.

Does anybody know what is the source of this problem?Well I have found It!

You have to register atl.dll (for Win9x it have to be ANSI version) before sqldmo.dll - such simply, but Microsoft doesn't mention this nowhere...

Registering SQL 2005 Server Evaluation

I am looking to install and configure the SQL 2005 Evaluation. Once this is installed, can it be registered to remove the evals 180 day limit?

Thanks for any help you can offer,

Andr Brisebois

Andre,

When you're ready to move off of the Evaluation Edition you will need to upgrade to a full edition of SQL Server 2005. The supported upgrades is documented here: http://msdn2.microsoft.com/en-us/library/ms143393.aspx. Evaluation edition can be upgrade to:

SQL Server 2005 Enterprise Edition
SQL Server 2005 Developer Edition
SQL Server 2005 Standard Edition
SQL Server 2005 Workgroup Edition
SQL Server 2005 Express Edition

You'll need to perform the upgrade prior to the 180-day expiration. The upgrade process must be able to start the SQL service. Once you pass the 180-day mark the service will not start. There is still a way to upgrade post 180 days but it is much more involved.

Cheers,
Dan

Registering a SQL Server Instance

Ok, well I just installed Visual Studio.NET 2003 on my PC, and toprepare for next years courses I thought I might get going on some ofthe exercises. But I am rather new to this and when I try to expand"SQL Server" in the "Server Explorer Window" I get this message.
Could not automaticly discover any SQL Server instances.
Choose Register SQL Server instance from the shortcut menu if you know there are SQL Server instances on this machine.
From there all I know is that I can right click on "SQL Server" andchose register new instance, but I do not know what to enter, and itsuggrests leaving it balck but that doesn't work. I will get aninstance but when I try to expand it another error pops up.
So as you can see I have no idea what I am doing when it comes to SQL Server, can any one help me with this?
Thanks again,
MCCCStudentTry either (local) WITH the parentheses, or the name of your computer.
|||I have tried the name of my computer and then i just tried (local), andlocal, and then when I try an expand it, it brings up the "SQL ServerLogin Window" with Administrator in the login name so i typed in myadmin password and this error poped up
[DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied.
|||Is the SQL Server service running?
|||If you right-click on the Server Group instance in Enterprise Manager,select 'properties' then click on the Connection tab, what method ofAuthentication is selected?
Tryst
|||Thanks guys my problems are solved

Registering a server

I am having difficulty registering to a newly installed server.
The server resides in a remote location.
The server is using mixed mode. I set a user up on the server named
SQLMANAGER with admin rights and also set up a user (SQLMANAGER) in SQL with
the same rights.
Whe I attempt to register the server I receive the following message :
"server does not exist or access denied"
I have 4 other servers which I have registered sucessfully, but none on this
segment of the network.
The IP am registering from is 105.1.13.206 and the server IP is 105.1.2.47.
I checked the log on the server and it is listening on port 1433.
Suggestions please!
Are you trying to register by server name or IP?
Jacco Schalkwijk
SQL Server MVP
"Gary" <Gary@.discussions.microsoft.com> wrote in message
news:03DCDD15-8280-40F4-88E1-3FE05472EB69@.microsoft.com...
>I am having difficulty registering to a newly installed server.
> The server resides in a remote location.
> The server is using mixed mode. I set a user up on the server named
> SQLMANAGER with admin rights and also set up a user (SQLMANAGER) in SQL
> with
> the same rights.
> Whe I attempt to register the server I receive the following message :
> "server does not exist or access denied"
> I have 4 other servers which I have registered sucessfully, but none on
> this
> segment of the network.
> The IP am registering from is 105.1.13.206 and the server IP is
> 105.1.2.47.
> I checked the log on the server and it is listening on port 1433.
> Suggestions please!
>
|||I have tried both.
The server does not come up in the server list so I entered it in manually.
On the server, I am able register the server to itself with no problem. I
am even able to register the server to the server that is failing to connect
to it.
"Jacco Schalkwijk" wrote:

> Are you trying to register by server name or IP?
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Gary" <Gary@.discussions.microsoft.com> wrote in message
> news:03DCDD15-8280-40F4-88E1-3FE05472EB69@.microsoft.com...
>
>