Hi,
I installed sql05 on a new box and I don't like the name I chose for the
instance.
How do I change it?
TIA,
Mike
Backup your databases, uninstall SQL Server, install it properly, then
restore your databases. There is no sp_rename_instance.
"Mike" <mikenospam@.yahoo.es> wrote in message
news:691977F7-8CB6-4107-B71E-6584B15311D4@.microsoft.com...
> Hi,
> I installed sql05 on a new box and I don't like the name I chose for the
> instance.
> How do I change it?
> TIA,
> Mike
>
Showing posts with label installed. Show all posts
Showing posts with label installed. Show all posts
Friday, March 30, 2012
How to rename instance
Hi,
I installed sql05 on a new box and I don't like the name I chose for the
instance.
How do I change it?
TIA,
MikeBackup your databases, uninstall SQL Server, install it properly, then
restore your databases. There is no sp_rename_instance.
"Mike" <mikenospam@.yahoo.es> wrote in message
news:691977F7-8CB6-4107-B71E-6584B15311D4@.microsoft.com...
> Hi,
> I installed sql05 on a new box and I don't like the name I chose for the
> instance.
> How do I change it?
> TIA,
> Mike
>
I installed sql05 on a new box and I don't like the name I chose for the
instance.
How do I change it?
TIA,
MikeBackup your databases, uninstall SQL Server, install it properly, then
restore your databases. There is no sp_rename_instance.
"Mike" <mikenospam@.yahoo.es> wrote in message
news:691977F7-8CB6-4107-B71E-6584B15311D4@.microsoft.com...
> Hi,
> I installed sql05 on a new box and I don't like the name I chose for the
> instance.
> How do I change it?
> TIA,
> Mike
>
How to remove the sqlcachedependancy ?
I had sqlcachedependancy installed. But now I cannot uninstall it?
1. I unregistered:
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>aspnet_regsql.exe -E -S localhost
-d DNN1 -dd
2. I remove the Dependencry.Start() from my application_start
' System.Data.SqlClient.SqlDependency.Start(ConfigurationManager.ConnectionStrings("SiteSqlServer").ConnectionString)
3. I removed the cache section from my web.config
4. I removed the outputcache statements from my aspx pages.
<!--<%@. OutputCache Duration="1" VaryByParam="*" SqlDependency="CommandNotification" %>-->
However, I still get the next error:
What to do?
Any help or advice is appreciated.
Jelle
Have you done a search through all of your application's files, looking for a rogue SqlDependency instance?|||
Thank you for your reply. I looked mainly in the default.aspx and forgot that for Dotnetnuke I also modified the install.aspx file. So in the end I copy-past all the next files over my files:
default.aspx + codebehind
install.aspx + codebehind
global.ascx
assembly + global file in app_code directory
That solved the solution.
Main reason I wanted to uninstall is that in case the webserver does stop a connection, the database server starts logging errors that the connectio n with the remote webserver is lost...and then the database server hangs. Would be nicer of MS SQL2005 to stop the logging in case the webserver does not request any info anymore.
Monday, March 26, 2012
How to remove a previous Installed instance
I uninstall the complete SQL Server 2005, and then when I reinstall it,
Reporting Services don't want to install because a previous installed
instance is detected.Hi Robert,
Welcome to MSDN newsgroup.
From your description, you've uninstalled the existing SQL Server 2005 on
your server. However, when you try reinstalling it later, you get
error(during Reporting Service installation) indicate that there is a
previous installed instance, correct?
Based on my experience, when installing the SQL Server, setup program will
try detecting existing SQL Server instances through the windows registry.
So you can have a look in the registry to see whether the Reporting Service
entry is still there. For SQL 2005, it uses the MSSQL.X like naming
convention, e.g
on my test server, the SQL 2005 Reporting Service is associated with the
below key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.4
In addition, before we performing registry editing, I suggest you still
have a look at the following SQL Server setup document and try the
commandline uninstallation (for specific named instance...) to see whether
it can help clearly remove the Reporting service instance.
#How to: Uninstall an Existing Instance of SQL Server 2005 (Setup)
http://msdn2.microsoft.com/en-us/library/ms143412.aspx
Hope helps. Thanks,
Steven Cheng
Microsoft Online Support
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
| From: "Roberto Hernández" <robertohh@.newsgroups.nospam>
| Subject: How to remove a previous Installed instance
| Date: Tue, 24 Jan 2006 12:30:59 -0600
| Lines: 5
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| Message-ID: <e1y#uoRIGHA.3036@.tk2msftngp13.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: 201.201.36.70
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:67408
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I uninstall the complete SQL Server 2005, and then when I reinstall it,
| Reporting Services don't want to install because a previous installed
| instance is detected.
|
|
||||Thanks,
solved deleting the regedit key
And then I reinstall it and all works ok.
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> escribió en el mensaje
news:VOdn65WIGHA.3944@.TK2MSFTNGXA02.phx.gbl...
> Hi Robert,
> Welcome to MSDN newsgroup.
> From your description, you've uninstalled the existing SQL Server 2005 on
> your server. However, when you try reinstalling it later, you get
> error(during Reporting Service installation) indicate that there is a
> previous installed instance, correct?
> Based on my experience, when installing the SQL Server, setup program will
> try detecting existing SQL Server instances through the windows registry.
> So you can have a look in the registry to see whether the Reporting
> Service
> entry is still there. For SQL 2005, it uses the MSSQL.X like naming
> convention, e.g
> on my test server, the SQL 2005 Reporting Service is associated with the
> below key:
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.4
> In addition, before we performing registry editing, I suggest you still
> have a look at the following SQL Server setup document and try the
> commandline uninstallation (for specific named instance...) to see whether
> it can help clearly remove the Reporting service instance.
> #How to: Uninstall an Existing Instance of SQL Server 2005 (Setup)
> http://msdn2.microsoft.com/en-us/library/ms143412.aspx
> Hope helps. Thanks,
> Steven Cheng
> Microsoft Online Support
> Get Secure! www.microsoft.com/security
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>
> --
> | From: "Roberto Hernández" <robertohh@.newsgroups.nospam>
> | Subject: How to remove a previous Installed instance
> | Date: Tue, 24 Jan 2006 12:30:59 -0600
> | Lines: 5
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
> | X-RFC2646: Format=Flowed; Original
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
> | Message-ID: <e1y#uoRIGHA.3036@.tk2msftngp13.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: 201.201.36.70
> | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
> | Xref: TK2MSFTNGXA02.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:67408
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | I uninstall the complete SQL Server 2005, and then when I reinstall it,
> | Reporting Services don't want to install because a previous installed
> | instance is detected.
> |
> |
> |
>|||Thanks for your response Roberto,
Glad that we've resolved the problem.
Have a good day!
Steven Cheng
Microsoft Online Support
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
--
| From: "Roberto Hernández" <robertohh@.newsgroups.nospam>
| References: <e1y#uoRIGHA.3036@.tk2msftngp13.phx.gbl>
<VOdn65WIGHA.3944@.TK2MSFTNGXA02.phx.gbl>
| Subject: Re: How to remove a previous Installed instance
| Date: Wed, 25 Jan 2006 14:32:42 -0600
| Lines: 72
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| Message-ID: <uk3xA6eIGHA.984@.tk2msftngp13.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: 201.201.36.70
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:67515
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Thanks,
| solved deleting the regedit key
| And then I reinstall it and all works ok.
|
|
| "Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> escribi?en el mensaje
| news:VOdn65WIGHA.3944@.TK2MSFTNGXA02.phx.gbl...
| > Hi Robert,
| >
| > Welcome to MSDN newsgroup.
| > From your description, you've uninstalled the existing SQL Server 2005
on
| > your server. However, when you try reinstalling it later, you get
| > error(during Reporting Service installation) indicate that there is a
| > previous installed instance, correct?
| >
| > Based on my experience, when installing the SQL Server, setup program
will
| > try detecting existing SQL Server instances through the windows
registry.
| > So you can have a look in the registry to see whether the Reporting
| > Service
| > entry is still there. For SQL 2005, it uses the MSSQL.X like naming
| > convention, e.g
| >
| > on my test server, the SQL 2005 Reporting Service is associated with the
| > below key:
| >
| > HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.4
| >
| > In addition, before we performing registry editing, I suggest you still
| > have a look at the following SQL Server setup document and try the
| > commandline uninstallation (for specific named instance...) to see
whether
| > it can help clearly remove the Reporting service instance.
| >
| > #How to: Uninstall an Existing Instance of SQL Server 2005 (Setup)
| > http://msdn2.microsoft.com/en-us/library/ms143412.aspx
| >
| > Hope helps. Thanks,
| >
| > Steven Cheng
| > Microsoft Online Support
| >
| > Get Secure! www.microsoft.com/security
| > (This posting is provided "AS IS", with no warranties, and confers no
| > rights.)
| >
| >
| > --
| > | From: "Roberto Hernández" <robertohh@.newsgroups.nospam>
| > | Subject: How to remove a previous Installed instance
| > | Date: Tue, 24 Jan 2006 12:30:59 -0600
| > | Lines: 5
| > | X-Priority: 3
| > | X-MSMail-Priority: Normal
| > | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| > | X-RFC2646: Format=Flowed; Original
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| > | Message-ID: <e1y#uoRIGHA.3036@.tk2msftngp13.phx.gbl>
| > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| > | NNTP-Posting-Host: 201.201.36.70
| > | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
| > | Xref: TK2MSFTNGXA02.phx.gbl
| > microsoft.public.sqlserver.reportingsvcs:67408
| > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| > |
| > | I uninstall the complete SQL Server 2005, and then when I reinstall
it,
| > | Reporting Services don't want to install because a previous installed
| > | instance is detected.
| > |
| > |
| > |
| >
|
|
|
Reporting Services don't want to install because a previous installed
instance is detected.Hi Robert,
Welcome to MSDN newsgroup.
From your description, you've uninstalled the existing SQL Server 2005 on
your server. However, when you try reinstalling it later, you get
error(during Reporting Service installation) indicate that there is a
previous installed instance, correct?
Based on my experience, when installing the SQL Server, setup program will
try detecting existing SQL Server instances through the windows registry.
So you can have a look in the registry to see whether the Reporting Service
entry is still there. For SQL 2005, it uses the MSSQL.X like naming
convention, e.g
on my test server, the SQL 2005 Reporting Service is associated with the
below key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.4
In addition, before we performing registry editing, I suggest you still
have a look at the following SQL Server setup document and try the
commandline uninstallation (for specific named instance...) to see whether
it can help clearly remove the Reporting service instance.
#How to: Uninstall an Existing Instance of SQL Server 2005 (Setup)
http://msdn2.microsoft.com/en-us/library/ms143412.aspx
Hope helps. Thanks,
Steven Cheng
Microsoft Online Support
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
| From: "Roberto Hernández" <robertohh@.newsgroups.nospam>
| Subject: How to remove a previous Installed instance
| Date: Tue, 24 Jan 2006 12:30:59 -0600
| Lines: 5
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| Message-ID: <e1y#uoRIGHA.3036@.tk2msftngp13.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: 201.201.36.70
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:67408
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I uninstall the complete SQL Server 2005, and then when I reinstall it,
| Reporting Services don't want to install because a previous installed
| instance is detected.
|
|
||||Thanks,
solved deleting the regedit key
And then I reinstall it and all works ok.
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> escribió en el mensaje
news:VOdn65WIGHA.3944@.TK2MSFTNGXA02.phx.gbl...
> Hi Robert,
> Welcome to MSDN newsgroup.
> From your description, you've uninstalled the existing SQL Server 2005 on
> your server. However, when you try reinstalling it later, you get
> error(during Reporting Service installation) indicate that there is a
> previous installed instance, correct?
> Based on my experience, when installing the SQL Server, setup program will
> try detecting existing SQL Server instances through the windows registry.
> So you can have a look in the registry to see whether the Reporting
> Service
> entry is still there. For SQL 2005, it uses the MSSQL.X like naming
> convention, e.g
> on my test server, the SQL 2005 Reporting Service is associated with the
> below key:
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.4
> In addition, before we performing registry editing, I suggest you still
> have a look at the following SQL Server setup document and try the
> commandline uninstallation (for specific named instance...) to see whether
> it can help clearly remove the Reporting service instance.
> #How to: Uninstall an Existing Instance of SQL Server 2005 (Setup)
> http://msdn2.microsoft.com/en-us/library/ms143412.aspx
> Hope helps. Thanks,
> Steven Cheng
> Microsoft Online Support
> Get Secure! www.microsoft.com/security
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>
> --
> | From: "Roberto Hernández" <robertohh@.newsgroups.nospam>
> | Subject: How to remove a previous Installed instance
> | Date: Tue, 24 Jan 2006 12:30:59 -0600
> | Lines: 5
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
> | X-RFC2646: Format=Flowed; Original
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
> | Message-ID: <e1y#uoRIGHA.3036@.tk2msftngp13.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: 201.201.36.70
> | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
> | Xref: TK2MSFTNGXA02.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:67408
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | I uninstall the complete SQL Server 2005, and then when I reinstall it,
> | Reporting Services don't want to install because a previous installed
> | instance is detected.
> |
> |
> |
>|||Thanks for your response Roberto,
Glad that we've resolved the problem.
Have a good day!
Steven Cheng
Microsoft Online Support
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
--
| From: "Roberto Hernández" <robertohh@.newsgroups.nospam>
| References: <e1y#uoRIGHA.3036@.tk2msftngp13.phx.gbl>
<VOdn65WIGHA.3944@.TK2MSFTNGXA02.phx.gbl>
| Subject: Re: How to remove a previous Installed instance
| Date: Wed, 25 Jan 2006 14:32:42 -0600
| Lines: 72
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| Message-ID: <uk3xA6eIGHA.984@.tk2msftngp13.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: 201.201.36.70
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:67515
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Thanks,
| solved deleting the regedit key
| And then I reinstall it and all works ok.
|
|
| "Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> escribi?en el mensaje
| news:VOdn65WIGHA.3944@.TK2MSFTNGXA02.phx.gbl...
| > Hi Robert,
| >
| > Welcome to MSDN newsgroup.
| > From your description, you've uninstalled the existing SQL Server 2005
on
| > your server. However, when you try reinstalling it later, you get
| > error(during Reporting Service installation) indicate that there is a
| > previous installed instance, correct?
| >
| > Based on my experience, when installing the SQL Server, setup program
will
| > try detecting existing SQL Server instances through the windows
registry.
| > So you can have a look in the registry to see whether the Reporting
| > Service
| > entry is still there. For SQL 2005, it uses the MSSQL.X like naming
| > convention, e.g
| >
| > on my test server, the SQL 2005 Reporting Service is associated with the
| > below key:
| >
| > HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.4
| >
| > In addition, before we performing registry editing, I suggest you still
| > have a look at the following SQL Server setup document and try the
| > commandline uninstallation (for specific named instance...) to see
whether
| > it can help clearly remove the Reporting service instance.
| >
| > #How to: Uninstall an Existing Instance of SQL Server 2005 (Setup)
| > http://msdn2.microsoft.com/en-us/library/ms143412.aspx
| >
| > Hope helps. Thanks,
| >
| > Steven Cheng
| > Microsoft Online Support
| >
| > Get Secure! www.microsoft.com/security
| > (This posting is provided "AS IS", with no warranties, and confers no
| > rights.)
| >
| >
| > --
| > | From: "Roberto Hernández" <robertohh@.newsgroups.nospam>
| > | Subject: How to remove a previous Installed instance
| > | Date: Tue, 24 Jan 2006 12:30:59 -0600
| > | Lines: 5
| > | X-Priority: 3
| > | X-MSMail-Priority: Normal
| > | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| > | X-RFC2646: Format=Flowed; Original
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| > | Message-ID: <e1y#uoRIGHA.3036@.tk2msftngp13.phx.gbl>
| > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| > | NNTP-Posting-Host: 201.201.36.70
| > | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
| > | Xref: TK2MSFTNGXA02.phx.gbl
| > microsoft.public.sqlserver.reportingsvcs:67408
| > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| > |
| > | I uninstall the complete SQL Server 2005, and then when I reinstall
it,
| > | Reporting Services don't want to install because a previous installed
| > | instance is detected.
| > |
| > |
| > |
| >
|
|
|
How to remove a database without deleting the mdf file ?
I have both sql 2005 express and developer edition installed.
If I have attached a mdf file to my local sql server default instance, how can I remove that database from this instance without deleting the underlying mdf file ? I have attached an mdf file under sql 2005 (dev edition) default instance, but now I want to detach it and reattach it under my sql 2005 express named instance. Why is there not a "detach" menu option ?
If I have attached a mdf file to my local sql server default instance, how can I remove that database from this instance without deleting the underlying mdf file ? I have attached an mdf file under sql 2005 (dev edition) default instance, but now I want to detach it and reattach it under my sql 2005 express named instance. Why is there not a "detach" menu option ?
help ?for some strange reason, a "detach" menu option is there when I select the database node in the left panel of mgt studio, then right-click the db and choose tasks > detach.
Oh wait, its there under the right-click menu in the left pane as well. disregard everything i just said 
How to reinstall SQL 2005 in Windows Server 2003 for SBS?
I've got a Windows Server 2003 for Small Business Server. It had got SQL
installed. But then SQL was uninstalled. Now I need to put SQL back in, but
I don't see how!
There're three CD-Rom but I don't see how and from which CD to install back
SQL.
PS: Correct me if I'm wrong, Windows Server 2003 is sold with SQL 2005, right?I don't know, but I seriously doubt that SQL Server comes with Windows
Server 2003, unless it is the Express version ...
Licensing for SQL Server can run into some serious money.
"TFS" <TFS@.discussions.microsoft.com> wrote in message
news:B877BB42-5FBA-4DF8-9ACC-24DD96F55AB4@.microsoft.com...
> I've got a Windows Server 2003 for Small Business Server. It had got SQL
> installed. But then SQL was uninstalled. Now I need to put SQL back in,
> but
> I don't see how!
> There're three CD-Rom but I don't see how and from which CD to install
> back
> SQL.
> PS: Correct me if I'm wrong, Windows Server 2003 is sold with SQL 2005,
> right?
>|||Hello Jay,
SBS is a package of softwares and it consists of Windows Server 2003, SQL
Server, Exchange Server etc...
Windows Small Business Server 2003 R2:
http://www.microsoft.com/windowsserver2003/sbs/default.mspx
Also, please do not post your question more than one newsgroup TFS.
--
Ekrem Önsoy
http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com
MCBDA, MCTS: SQL Server 2005, MCITP:DBA, MCSD.Net, MCSE, MCT
"Jay" <spam@.nospam.org> wrote in message
news:ufiHseaEIHA.4748@.TK2MSFTNGP06.phx.gbl...
>I don't know, but I seriously doubt that SQL Server comes with Windows
>Server 2003, unless it is the Express version ...
> Licensing for SQL Server can run into some serious money.
> "TFS" <TFS@.discussions.microsoft.com> wrote in message
> news:B877BB42-5FBA-4DF8-9ACC-24DD96F55AB4@.microsoft.com...
>> I've got a Windows Server 2003 for Small Business Server. It had got SQL
>> installed. But then SQL was uninstalled. Now I need to put SQL back in,
>> but
>> I don't see how!
>> There're three CD-Rom but I don't see how and from which CD to install
>> back
>> SQL.
>> PS: Correct me if I'm wrong, Windows Server 2003 is sold with SQL 2005,
>> right?
>
installed. But then SQL was uninstalled. Now I need to put SQL back in, but
I don't see how!
There're three CD-Rom but I don't see how and from which CD to install back
SQL.
PS: Correct me if I'm wrong, Windows Server 2003 is sold with SQL 2005, right?I don't know, but I seriously doubt that SQL Server comes with Windows
Server 2003, unless it is the Express version ...
Licensing for SQL Server can run into some serious money.
"TFS" <TFS@.discussions.microsoft.com> wrote in message
news:B877BB42-5FBA-4DF8-9ACC-24DD96F55AB4@.microsoft.com...
> I've got a Windows Server 2003 for Small Business Server. It had got SQL
> installed. But then SQL was uninstalled. Now I need to put SQL back in,
> but
> I don't see how!
> There're three CD-Rom but I don't see how and from which CD to install
> back
> SQL.
> PS: Correct me if I'm wrong, Windows Server 2003 is sold with SQL 2005,
> right?
>|||Hello Jay,
SBS is a package of softwares and it consists of Windows Server 2003, SQL
Server, Exchange Server etc...
Windows Small Business Server 2003 R2:
http://www.microsoft.com/windowsserver2003/sbs/default.mspx
Also, please do not post your question more than one newsgroup TFS.
--
Ekrem Önsoy
http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com
MCBDA, MCTS: SQL Server 2005, MCITP:DBA, MCSD.Net, MCSE, MCT
"Jay" <spam@.nospam.org> wrote in message
news:ufiHseaEIHA.4748@.TK2MSFTNGP06.phx.gbl...
>I don't know, but I seriously doubt that SQL Server comes with Windows
>Server 2003, unless it is the Express version ...
> Licensing for SQL Server can run into some serious money.
> "TFS" <TFS@.discussions.microsoft.com> wrote in message
> news:B877BB42-5FBA-4DF8-9ACC-24DD96F55AB4@.microsoft.com...
>> I've got a Windows Server 2003 for Small Business Server. It had got SQL
>> installed. But then SQL was uninstalled. Now I need to put SQL back in,
>> but
>> I don't see how!
>> There're three CD-Rom but I don't see how and from which CD to install
>> back
>> SQL.
>> PS: Correct me if I'm wrong, Windows Server 2003 is sold with SQL 2005,
>> right?
>
Monday, March 19, 2012
How to recover sql server database data
Hi all. A few days ago i installed mcafee total protection 2007 and that disabled my internet connection totally!! I couldn't fix it so i had to uninstall it. After uninstalling mcafee total protection 2007 still i couldn't join Internet!!
So i got mad and went and made repair installation of windows xp pro. After repair installation i couldn't activate it since Internet connection was still not working!! So i went and installed another copy of xp pro on different folder and named it WINDOWS (old one was WINDOWS2).Thanks god now i could join Internet but all my shortcuts and menu items are not visible.
Unfortunately I can't even start sql server 2000 either!! could any one tell me what should i do in order to get access to all database tables and data that i had in sql server and make a back up. I didn't install any new sql server yet. I be happy if an expert tell me what should i do. The installation folder of old windows(WINDOWS2) is still available along with sql server installation folder.Thank and looking forward for reply.As this question is really more of a Windows / Microsoft SQL Server question than a true SQL language question, I'm going to move the thread to the Microsoft SQL Server forum so it will get more attention.
-PatP|||what I presume, when you install a new copy of Windows leaving behind the old copy will not copy all your applications onto new winodws software. You need to install all your applications and sql server as well because when you install the new copy of windows xp, this will create a new registry file which may not have your old windows application registry details...
I hope this will you.
So i got mad and went and made repair installation of windows xp pro. After repair installation i couldn't activate it since Internet connection was still not working!! So i went and installed another copy of xp pro on different folder and named it WINDOWS (old one was WINDOWS2).Thanks god now i could join Internet but all my shortcuts and menu items are not visible.
Unfortunately I can't even start sql server 2000 either!! could any one tell me what should i do in order to get access to all database tables and data that i had in sql server and make a back up. I didn't install any new sql server yet. I be happy if an expert tell me what should i do. The installation folder of old windows(WINDOWS2) is still available along with sql server installation folder.Thank and looking forward for reply.As this question is really more of a Windows / Microsoft SQL Server question than a true SQL language question, I'm going to move the thread to the Microsoft SQL Server forum so it will get more attention.
-PatP|||what I presume, when you install a new copy of Windows leaving behind the old copy will not copy all your applications onto new winodws software. You need to install all your applications and sql server as well because when you install the new copy of windows xp, this will create a new registry file which may not have your old windows application registry details...
I hope this will you.
Monday, March 12, 2012
How to rebuild the master database.?
Installed SQLSERVER 2005 EVAL copy in my server and trying to rebuild the master database and it is not working.
I tried the following command.
start /wait setup.exe /qn INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=RAJESH
Any thoughts?
Thanks
First off, can you help me understand why you need to rebuild master instead of restoring from backup? Rebuilding master is typically done when it is too corrupt to allow the instance to start.
If the instance is running, that would probably prevent the procedure above from working. It isn't intended for running instances.
If your instance is down and it still doesn't work, please post the exact error message and we'll see what we can find out.
Wednesday, March 7, 2012
How to read a cell of Excel in Script task?
BTW, I cannot use Office automation because MS office is not installed on the machine.
Thanks,
Without using office automation, you are quite limited to what you can get out.
Either use Excel Source, which is like a flat table of rows and columns, or a 3rd party product like Data Defractor which allows you to "drill" into the document and return specific areas.
Subscribe to:
Posts (Atom)