Difficulty uninstalling Native Client

I have been running SQL Server 2005 Express (basic) Instance MSSMLBIZ in conjunction with Microsoft Office Accounting 2007 Professional.

I want to make a "clean install" of SQL Server 2005 Express Advanced, SQL Server2005 Express Tools, in order to create additional Reports in Microsoft Office Accounting 2007 Professional.

I ran uininstall on the basic SQL Server 2005 Express, but Native Client did not uninstall; the following message was posted:

"An installation package for the product Microsoft SQL Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli.msi'."

I then attempted to install SQL Server 2005 Express Advanced, but it failed to load Native Client. I then uninstalled all instances, deleted the SQL Server Express Files in Programs, and ran "CC Cleaner" to clear the Registry.

I then attempted to uninstall Native Client again, and received the following message:

"This action is only valid for products that are currently installed."

I the returned to CCCleaner Tools to attempt to delete the residuals and received the following message

"Cannot delete msi installer."

I ran "Search - *.msi" and there is no instance of sqlncli.msi visible.

I have Removed Registry Entries for SQL Express,
except HKEY_CLASSES_ROOT instances.

Should I delete these?

Have I forgotten or omitted something?

Please Help.

Try the link below for another option to remove Express from your box , another option is to use System Restore to roll your system back to the point before your first install now I am not sure if your registry utility have removed entries that may not allow the roll back. Hope this helps.

http://msdn.microsoft.com/vstudio/express/sql/download/advanced/default.aspx|||

hi,

you can try manually "fixing" SQL Native Client installing the last package you can find here.. then you can go on installing SQLExpress with Advanced Services..

regards

|||

I am trying to manually "fix" but I don't know where to go next, hence my post.

I simply want to remove all traces of SQL Server 2005 Express from my machine before I Install the SP2 Advanced version.

I need some real help, not more download options that are not identified.

|||

hi,

I do understand your comprehensible irritation, but often comes you can not completely remove a piece of software.. my advice is to fix the Native Client component, as it often causes problems when installing SQL Server as well..

the provided link i not "not identified" as it is a supported and well known Microsoft link to a Microsoft released package.. it's then up to you..

with kind regards

Differential backups failing regularly

Hi,
Don't know what the problem is here. We are running a clustered
instance of SQL Server 2005 on Windows 2003 - the backups are being
written to a location on a SAN.
Here is the error message:
[SQLSTATE 40001] (Error 1205) Could not insert a backup or restore
history/detail record in the msdb database. This may indicate a problem
with the msdb database. The backup/restore operation was still
successful. [SQLSTATE 42000] (Error 3009) BACKUP DATABASE WITH
DIFFERENTIAL successfully processed 6529 pages in 2.079 seconds (25.726
MB/sec). [SQLSTATE 01000] (Error 3014). The step failed.
Says there's something wrong with msdb' Haven't made any changes.
ThanksActually, I have made some small changes - I removed the Backups user
from the databases. The Backups login still exists.
I notice that SQL Server now creates this login/user by default. I
don't think it comes with any built-in permissions, so I couldn't
figure out what it's for.
I removed the Backups user from another server - that one has had no
problems, so I doubt that is what is the causing the above error.|||Who starts the backup? Do you get the same problem if you login with a sysadmin account and execute
the backup command?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<tootsuite@.gmail.com> wrote in message news:1157576820.954491.165730@.m79g2000cwm.googlegroups.com...
> Actually, I have made some small changes - I removed the Backups user
> from the databases. The Backups login still exists.
> I notice that SQL Server now creates this login/user by default. I
> don't think it comes with any built-in permissions, so I couldn't
> figure out what it's for.
> I removed the Backups user from another server - that one has had no
> problems, so I doubt that is what is the causing the above error.
>|||Hi Tibor,
The "owner" of the job that start the backup is a SQL server login with
sysadmin privileges. Is that what you are asking?
Also, I am now also seeing this problem when I run the translog backup
job. I searched the application logs in event viewer, as well as the
sql server error logs - it indicates nothing whatsover out of the
ordinary. No error msgs, nothing.
So it's hard to say what it is.
Tibor Karaszi wrote:
> Who starts the backup? Do you get the same problem if you login with a sysadmin account and execute
> the backup command?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> <tootsuite@.gmail.com> wrote in message news:1157576820.954491.165730@.m79g2000cwm.googlegroups.com...
> > Actually, I have made some small changes - I removed the Backups user
> > from the databases. The Backups login still exists.
> >
> > I notice that SQL Server now creates this login/user by default. I
> > don't think it comes with any built-in permissions, so I couldn't
> > figure out what it's for.
> >
> > I removed the Backups user from another server - that one has had no
> > problems, so I doubt that is what is the causing the above error.
> >|||Did you try executing the backup command from a query window?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<tootsuite@.gmail.com> wrote in message news:1157656240.841901.298570@.h48g2000cwc.googlegroups.com...
> Hi Tibor,
> The "owner" of the job that start the backup is a SQL server login with
> sysadmin privileges. Is that what you are asking?
> Also, I am now also seeing this problem when I run the translog backup
> job. I searched the application logs in event viewer, as well as the
> sql server error logs - it indicates nothing whatsover out of the
> ordinary. No error msgs, nothing.
> So it's hard to say what it is.
>
> Tibor Karaszi wrote:
>> Who starts the backup? Do you get the same problem if you login with a sysadmin account and
>> execute
>> the backup command?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> <tootsuite@.gmail.com> wrote in message
>> news:1157576820.954491.165730@.m79g2000cwm.googlegroups.com...
>> > Actually, I have made some small changes - I removed the Backups user
>> > from the databases. The Backups login still exists.
>> >
>> > I notice that SQL Server now creates this login/user by default. I
>> > don't think it comes with any built-in permissions, so I couldn't
>> > figure out what it's for.
>> >
>> > I removed the Backups user from another server - that one has had no
>> > problems, so I doubt that is what is the causing the above error.
>> >
>|||It looks like it's the writing of the backup history that is
causing the problem. The error you posted is:
Could not insert a backup or restore history/detail record
in the msdb database. This may indicate a problem with the
msdb database. The backup/restore operation was still
successful.
Have you run a DBCC CHECKDB on msdb? Can you view job
histories without any problems and are they current and
accurate? Did you check for any other errors related to job
history or msdb in general? Have you run a trace and run a
backup during this time to track down where exactly the
error happens, what statement and what if any other errors
are raised?
-Sue
On 7 Sep 2006 12:10:40 -0700, tootsuite@.gmail.com wrote:
>Hi Tibor,
>The "owner" of the job that start the backup is a SQL server login with
>sysadmin privileges. Is that what you are asking?
>Also, I am now also seeing this problem when I run the translog backup
>job. I searched the application logs in event viewer, as well as the
>sql server error logs - it indicates nothing whatsover out of the
>ordinary. No error msgs, nothing.
>So it's hard to say what it is.
>
>Tibor Karaszi wrote:
>> Who starts the backup? Do you get the same problem if you login with a sysadmin account and execute
>> the backup command?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> <tootsuite@.gmail.com> wrote in message news:1157576820.954491.165730@.m79g2000cwm.googlegroups.com...
>> > Actually, I have made some small changes - I removed the Backups user
>> > from the databases. The Backups login still exists.
>> >
>> > I notice that SQL Server now creates this login/user by default. I
>> > don't think it comes with any built-in permissions, so I couldn't
>> > figure out what it's for.
>> >
>> > I removed the Backups user from another server - that one has had no
>> > problems, so I doubt that is what is the causing the above error.
>> >

Different times on different instances

Hi,
we have sql server 2000, sp4 and we need to add new instance to this server.
Is it possible to setup time (zone) different than server local time for this
new instance?
I am asking this because application which should rely on new instance uses
extensively getdate() function, and cost of redevelopement would be huge...
How about changing getdate()?
Thanks,
PedjaPedja wrote:
> Hi,
> we have sql server 2000, sp4 and we need to add new instance to this
> server. Is it possible to setup time (zone) different than server
> local time for this new instance?
> I am asking this because application which should rely on new
> instance uses extensively getdate() function, and cost of
> redevelopement would be huge... How about changing getdate()?
> Thanks,
> Pedja
Not unless you are using virtual servers, then maybe. If you change
getdate() to GETUTCDATE(), you could store all your dates in GMT.
--
David Gugick - SQL Server MVP
Quest Software

Different times on different instances

Hi,
we have sql server 2000, sp4 and we need to add new instance to this server.
Is it possible to setup time (zone) different than server local time for thi
s
new instance?
I am asking this because application which should rely on new instance uses
extensively getdate() function, and cost of redevelopement would be huge...
How about changing getdate()?
Thanks,
PedjaPedja wrote:
> Hi,
> we have sql server 2000, sp4 and we need to add new instance to this
> server. Is it possible to setup time (zone) different than server
> local time for this new instance?
> I am asking this because application which should rely on new
> instance uses extensively getdate() function, and cost of
> redevelopement would be huge... How about changing getdate()?
> Thanks,
> Pedja
Not unless you are using virtual servers, then maybe. If you change
getdate() to GETUTCDATE(), you could store all your dates in GMT.
David Gugick - SQL Server MVP
Quest Software

Different times on different instances

Hi,
we have sql server 2000, sp4 and we need to add new instance to this server.
Is it possible to setup time (zone) different than server local time for this
new instance?
I am asking this because application which should rely on new instance uses
extensively getdate() function, and cost of redevelopement would be huge...
How about changing getdate()?
Thanks,
Pedja
Pedja wrote:
> Hi,
> we have sql server 2000, sp4 and we need to add new instance to this
> server. Is it possible to setup time (zone) different than server
> local time for this new instance?
> I am asking this because application which should rely on new
> instance uses extensively getdate() function, and cost of
> redevelopement would be huge... How about changing getdate()?
> Thanks,
> Pedja
Not unless you are using virtual servers, then maybe. If you change
getdate() to GETUTCDATE(), you could store all your dates in GMT.
David Gugick - SQL Server MVP
Quest Software

Different Port

Is there a way to change the default instance of SQL 2005 to use another
port, say 9000? When I try to change these properties under Server
Configuration (Protocols, TCPIP) none of it will then connect outside of
that machine.
Thanks for any help.
KellyWhat di you mean by "none of it will then connect outside of that
machine." Do you mean the clients. If so,you have to specify the Port
on the client side stating Servername\instanceName,Portnumber or you
create an alias on the client machine to connect with.
HTH, jens Suessmeyer.|||resolved had the conneciton string wrong.
Kelly
"scorpion53061" <scorpion_53061@.nospamhereyahoo.com> wrote in message
news:O%23BCgqKLGHA.2828@.TK2MSFTNGP12.phx.gbl...
> Is there a way to change the default instance of SQL 2005 to use another
> port, say 9000? When I try to change these properties under Server
> Configuration (Protocols, TCPIP) none of it will then connect outside of
> that machine.
> Thanks for any help.
> Kelly
>
>

Different language instances on same server

Is it possible to install two different SQL server version
instances, for instance, one in english and the other one
in Spanish, in the same server?
We are having a problem in our central server, with a
especific software which runs correctly only in the SQL
server spanish version.
For sure, all collation and language settings have been
tested in the english version with no result.
Thanks in advanceGustavo,
Yes, given you can even install SQL7 and SQL2000 on the same
server - they don't share much at all !
But there are license issues / costs:
http://www.microsoft.com/sql/howtobuy/faq.asp
"SQL Server 2000 Enterprise Edition includes the ability to run multiple instances of SQL Server 2000 on a
single computer. Multiple instances are used by organizations that have several applications running on a
server, but want them to run in isolation so that any problem in one instance will not affect the other
instances.
With SQL Server 2000 Enterprise Edition, you can install multiple instances of SQL Server on the same computer
without having additional licenses. Although SQL Server 2000 Standard Edition will technically support
multiple instances, each instance requires a separate license. "
"Gustavo" <gcarreras@.koppert.es> wrote in message news:002401c39a39$237e29b0$a101280a@.phx.gbl...
> Is it possible to install two different SQL server version
> instances, for instance, one in english and the other one
> in Spanish, in the same server?
> We are having a problem in our central server, with a
> especific software which runs correctly only in the SQL
> server spanish version.
> For sure, all collation and language settings have been
> tested in the english version with no result.
> Thanks in advance

Different instances of SQL Server

Hi there,

I was wondering if it's possible to create a new instance in the SQL Server something like this:

(Local)\\MSSMLBIZ

(Local)\\BUSINESS

Thank you

yes you can create as Server name \\ instance name where the Server name can be the same.......i have 3 instances where my server name is Deepak\\instance1 similarly instance2 and instnace3

|||

you can have multiple instances on one physical machine. One Defualt instance and all others are called Named Instance. Default instance will have same physical machine name. all other will have Physical machine name \Name of the instance

sql server 2005

sql server 32 bit 64 bit

Instances per computer

50 instances on a stand-alone server for all SQL Server 2005 editions except for Workgroup Edition. Workgroup Edition supports a maximum of 16 instances.

SQL Server 2005 supports 25 instances on a failover cluster.

50 instances on a stand-alone server.

25 instances on a failover cluster

http://technet.microsoft.com/en-us/library/ms143432.aspx

Madhu

|||

Does it apply to SQL Server Express? if yes how do I create (Local)\Myinstance in C#? or if I can't do it in C#, how do I create it manually?

Thank you

|||

Yes. You need to re-run setup to create a new instance of sql server with instance name = "MyInstance". The instance name page is on one of pages in the setup wizard. There is no way to automate creating a new instance with C# with an API like SMO. You can invoke setup with parameters to specify things like instance name, and run setup without user intervention. There is more information in BOL.

Different Default Date format for 2 SQL Server Instances

Hi,
We recently had a new environment created. The servers were all installed
as separate instances on the same physical machine.
For my first instance INST1
When I execute the following query exec getMyData '1964-11-19'
in query analyser everything is fine
from my (ASP) website everything is fine
For my second instance INST2
in query analyser everything is fine
from my asp website I get varchar cannot be converted to datetime.
I can only believe that the default settings for the server were different
when each of the SQL Server Installs were performed.
I cannot change the way we pass dates in our website because it is a massive
re-write of everytihg if I do.
Is there some why of changing the default settings of the server after
installing?
I have tried using
sp_configure
SET language
sp_defaultlanguage
and all these methods did not fix my problem.
Any ideas?
JayneK wrote:
> Hi,
> We recently had a new environment created. The servers were all
> installed as separate instances on the same physical machine.
> For my first instance INST1
> When I execute the following query exec getMyData '1964-11-19'
> in query analyser everything is fine
> from my (ASP) website everything is fine
> For my second instance INST2
> in query analyser everything is fine
> from my asp website I get varchar cannot be converted to datetime.
> I can only believe that the default settings for the server were
> different when each of the SQL Server Installs were performed.
> I cannot change the way we pass dates in our website because it is a
> massive re-write of everytihg if I do.
> Is there some why of changing the default settings of the server after
> installing?
> I have tried using
> sp_configure
> SET language
> sp_defaultlanguage
> and all these methods did not fix my problem.
> Any ideas?
When working with dates in character format, you should only ever use a
portable format. Two formats are supported that will never cause
problems related to the server's regional settings:
yyyy-mm-ddThh:mm:ss.mmm (no spaces)
yyyymmdd
What is probably occurring is that one server is using MDY format and
the other is using DMY.
For example:
SET NOCOUNT ON
SET DATEFORMAT MDY
SELECT CAST('1964-11-19' as DATETIME)
SET DATEFORMAT DMY
SELECT CAST('1964-11-19' as DATETIME)
-- Results
1964-11-19 00:00:00.000
Server: Msg 242, Level 16, State 3, Line 9
The conversion of a char data type to a datetime data type resulted in
an out-of-range datetime value.
David Gugick - SQL Server MVP
Quest Software
|||David,
Unfortunately they all have all their language setting exactly the same. So
they are all set to us_english as default language, yet one server acts
differently to the other.
How can we fix this? do we have to uninstall and re-install, can't we hack
a file or something?
"David Gugick" wrote:

> JayneK wrote:
> When working with dates in character format, you should only ever use a
> portable format. Two formats are supported that will never cause
> problems related to the server's regional settings:
> yyyy-mm-ddThh:mm:ss.mmm (no spaces)
> yyyymmdd
>
> What is probably occurring is that one server is using MDY format and
> the other is using DMY.
> For example:
> SET NOCOUNT ON
> SET DATEFORMAT MDY
> SELECT CAST('1964-11-19' as DATETIME)
> SET DATEFORMAT DMY
> SELECT CAST('1964-11-19' as DATETIME)
> -- Results
> 1964-11-19 00:00:00.000
> Server: Msg 242, Level 16, State 3, Line 9
> The conversion of a char data type to a datetime data type resulted in
> an out-of-range datetime value.
>
>
> --
> David Gugick - SQL Server MVP
> Quest Software
>
|||JayneK wrote:[vbcol=seagreen]
> David,
> Unfortunately they all have all their language setting exactly the
> same. So they are all set to us_english as default language, yet one
> server acts differently to the other.
> How can we fix this? do we have to uninstall and re-install, can't
> we hack a file or something?
> "David Gugick" wrote:
The ASP web site client is likely set up different. Go to that PC, open
up QA, and run the example above. The problem is that you are not using
a portable date format and are bound to run into these types of
problems. If you get rid of the hyphens in the date parameter, that will
probably fix the issue. Since you cannot easily change the code
executing the date procedure you wrote, why not just change the
procedure itself to strip the hyphens out using Set @.MyDate =
REPLACE(@.MyDate, '-', '')
David Gugick - SQL Server MVP
Quest Software

Different date for each instance

Is there a way to run multiple SQL instance on the same server with different date and time for each ?
No. SQL Server uses the system date and time. If you are talking about
time zones though you can always handle time zones in your code.
Jeff Duncan
MCDBA, MCSE+I
"Elsay Papantout" <luc.cloutier@.costco.com> wrote in message
news:E8169651-5200-4E16-915E-279E471683D3@.microsoft.com...
> Is there a way to run multiple SQL instance on the same server with
different date and time for each ?
|||Thanks Jeff. Then I'll try running SQL over Virtual Server.

Different date for each instance

Is there a way to run multiple SQL instance on the same server with differen
t date and time for each ?No. SQL Server uses the system date and time. If you are talking about
time zones though you can always handle time zones in your code.
Jeff Duncan
MCDBA, MCSE+I
"Elsay Papantout" <luc.cloutier@.costco.com> wrote in message
news:E8169651-5200-4E16-915E-279E471683D3@.microsoft.com...
> Is there a way to run multiple SQL instance on the same server with
different date and time for each ?|||Thanks Jeff. Then I'll try running SQL over Virtual Server.

Different Data Sources

I am a RS newbe, and I have common reports but different data sources. Is
there a way to modify the data source for an instance of a report without
changing the values in the ReportServer database?
--
BobRS 2005 supports expression-based connection strings with private data
sources only. Look at the ExpressionBasedConnection report
here(http://prologika.com/CS/blogs/blog/archive/2005/12/08/714.aspx)
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"Bob Joyce" <BobJoyce@.discussions.microsoft.com> wrote in message
news:E813E946-5635-491A-973C-F4ADB4A63726@.microsoft.com...
>I am a RS newbe, and I have common reports but different data sources. Is
> there a way to modify the data source for an instance of a report without
> changing the values in the ReportServer database?
> --
> Bob