Newbie Question about install

Where do I find the install for Reporting Services. Is it a separate program
from the SQL Server install?Hi,
You will find your answer here :
http://www.microsoft.com/sql/reporting/default.asp
Eric
"Cary" wrote:
> Where do I find the install for Reporting Services. Is it a separate program
> from the SQL Server install?

Newbie question - SP2

We are in a diverse workgroup here and I didn't do the install. How do I
know if I have SP2 installed? I tried to check in VS, but it didn't know.
Thanks!to determine the version you are running just type the url of the
report server (ex..http://<exampleWebServer>/reportserver.
Version info is located at the bottom of the page. The final product
release is 8.00.743.00..service pack 1 is 8.00.878.00, and sp2 is
8.00.1042.00
hope this helps

newbie question

Hi,
i'm kinda new to Microsoft SQL Server. I've just finished my first
install. Now i want to be able to connect macintosh clients to the
server. I'm able to connect using windows 2000 authentification but not
with SQL Server authentification (in mixed mode).
When using "Aqua Data Studio" on my mac, when i try to connect using
the "sa" account it fails because "the connection is not associated to
a secure SQL Server connection".
How can i establish such a secured connection '
Thanks in advance,
PierreWhen you're connecting to SQL server with sa user you are trying to
authenticate with SQL authentication.
That means that you have to set a mixed mode on the server. Then you'll be
able to connect with sa user.
Secure SQL Server connection error you're getting means that you should use
Windows account to log to SQL Server.
Danijel
"Pierre Chatel" <admin@.chatelp.org> wrote in message
news:2005011413034716807%admin@.chatelporg...
> Hi,
> i'm kinda new to Microsoft SQL Server. I've just finished my first
> install. Now i want to be able to connect macintosh clients to the server.
> I'm able to connect using windows 2000 authentification but not with SQL
> Server authentification (in mixed mode).
> When using "Aqua Data Studio" on my mac, when i try to connect using the
> "sa" account it fails because "the connection is not associated to a
> secure SQL Server connection".
> How can i establish such a secured connection '
> Thanks in advance,
> Pierre
>

Newbie Q: SQL Redundancy

Hi, If I have two machine in a cluster
- if I install SQL on one will the installation replicate on the other or do I have to install both seperatly,
- if I have SQL operating on both nodes and I write SQL to one will it replicate over automatically (does it remove the need for SQL redundancy)
- would WebPages do the same.
sorry for the newbie questions but was finding it hard to get specific answers, any help would be appreciated.
Steve
SQL Cluster installation puts the binaries on whatever host nodes you
specify. You can add or remove nodes later if you need to. The clustered
data store is accessable from both nodes, but is arbitrated so that only one
host at a time owns it owns. The entire data store shifts to another node
during a failover. A failover appears like a SQL stop/start to the outside
world. If you have a SQL instance running on a different host node in the
same cluster, it will have a different set of databases and will appear like
(because it is) a separate SQL server.
I do not understand your question about WebPages.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Steve" <anonymous@.discussions.microsoft.com> wrote in message
news:E7F75FFB-A439-4931-B7E5-80868A324720@.microsoft.com...
> Hi, If I have two machine in a cluster
> - if I install SQL on one will the installation replicate on the other or
do I have to install both seperatly,
> - if I have SQL operating on both nodes and I write SQL to one will it
replicate over automatically (does it remove the need for SQL redundancy)
> - would WebPages do the same.
> sorry for the newbie questions but was finding it hard to get specific
answers, any help would be appreciated.
> Steve
|||Setup will install SQL Server 2000 on both nodes. That is, it will install
the binaries and utilities on a local drive on each node and the data and
log files on the shared drive.
There is only one set of shared databses between the nodes. There is no
data redundancy; only high availability. So if you want data redundancy you
will need to use something like replication or log shipping.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Even in a SQL cluster, you have only one set of data (mounted by one node or
the other, but not both).
If you lose the storage solution or corrupt the data, you're toast. That's
where replication comes in.
Look at either NSI product (www.nsisoftware.com).
GeoCluster splits the storage under MSCS, so each node has its own copy -
although only one is active at a time.
DoubleTake replicates data between servers, and also from the active MSCS
node, to another server. This can be built in such a way that you could do
backups or snaps from the redundant server (which gives you some additional
restore and rollback capabilities).
jason
"Steve" <anonymous@.discussions.microsoft.com> wrote in message
news:E7F75FFB-A439-4931-B7E5-80868A324720@.microsoft.com...
> Hi, If I have two machine in a cluster
> - if I install SQL on one will the installation replicate on the other or
do I have to install both seperatly,
> - if I have SQL operating on both nodes and I write SQL to one will it
replicate over automatically (does it remove the need for SQL redundancy)
> - would WebPages do the same.
> sorry for the newbie questions but was finding it hard to get specific
answers, any help would be appreciated.
> Steve

Newbie Install question

HI,
I am new to Sql Reporting Service and I have a Newbie question. I have VS.Net installed on one Computer and SQL Server installed on a server. When I install SQL RS, Do I install it on both, my development computer and the SQL Server (windows Server)? And what VER can I put on both computers (if I have to install it on both)? Should I put Enterprise on the Server (Sql server and windows server) and Developer on the VS.Net computer? Or can I put Enterprise on both?
Thank you,
AndreWell, that depends on what you want to do. :) If you want the design app
then you have to install RS on the machine with VS. For the server
components you can install on any machine that has access to a SQL machine.
It is not a requirement that SQL and RS be on the same box.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"andre@.online.nospam" <andreonlinenospam@.discussions.microsoft.com> wrote in
message news:7D4A0AF2-17B5-447A-9042-FF56434C6353@.microsoft.com...
> HI,
> I am new to Sql Reporting Service and I have a Newbie question. I have
VS.Net installed on one Computer and SQL Server installed on a server. When
I install SQL RS, Do I install it on both, my development computer and the
SQL Server (windows Server)? And what VER can I put on both computers (if I
have to install it on both)? Should I put Enterprise on the Server (Sql
server and windows server) and Developer on the VS.Net computer? Or can I
put Enterprise on both?
> Thank you,
> Andre
>|||Thanks.
Is there any reason that I would need the Server components on my VS.Net machine? Or installing the Server components on the SQL server will do the trick?
FYI
I have both a Sql server running windows server 2003 and IIS, and a Development machine.|||There is no need to put the server components on the VS.Net machine. Some
companies will not allow IIS and SQL on the same box so they will put RS
server components on another machine.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"andre@.online.nospam" <andreonlinenospam@.discussions.microsoft.com> wrote in
message news:EAF2855F-B8D7-4074-999F-BB8EB7BE1E36@.microsoft.com...
> Thanks.
> Is there any reason that I would need the Server components on my VS.Net
machine? Or installing the Server components on the SQL server will do the
trick?
> FYI
> I have both a Sql server running windows server 2003 and IIS, and a
Development machine.
>

Newbie in SQL server 2005

Good day. Is there any version of SQL server 2005(not include Express Edition) same as SQL server 2000 Personal edition ? I am planning to install new SQL server 2005 in my pc now. I am using Windows XP SP2 now. I tried to install to Entreprise Trial version, unfortunately it just works as client. Thank you in advance.Regards,Anson

SQL Server 2005 Express Edition is the replacement for MSDE & SQL Server Personal Edition.

See the following edition information:

http://www.sqlservercentral.com/columnists/bknight/comparisonofsqlserver2005editions.asp

http://www.microsoft.com/sql/editions/default.mspx

http://www.microsoft.com/technet/prodtechnol/sql/2005/msde2sqlexpress.mspx

-Aaron

|||

Have a look into this link. This contains the minimum requirements for SQL 2005. On having a look into this you can decide which version can be installed on your machine

http://www.microsoft.com/sql/prodinfo/sysreqs/default.mspx

Note : For enterprise edition the OS required is Microsoft Windows 2003 server

|||

Best is to use Sql Server 2005 Developer Edition if want to install on Windows Xp and want to use for development...

Satya

Newbie Advice re: Installing SSRS

Hi, I've decided to install SSRS (2005) on my windows XP machine. I'm not very familiar with IIS (i'm currently using version 5.1) and I think between IIS and SSRS, i've managed to break something.

I've been looking at various articles to try and get some clarity on my predicament. However, i'm not getting any joy with them.s

I have located the logfiles (which I can provide). Unfortunately, I have no idea how to intepret the information contained therein.

Can anyone help?

Many thanks in advance

ClintPlease provide more information. First make sure every tab in the configuration tool is green. Then try to access your report server virtual directory. If there is an error on the web page please copy it here. Also copy the corresponding error in the log files.|||

Hi James, thank you for taking the time to answer me. I will endeavour to provide the information that you requested.

1. The configuration window - This is what i'm getting when I view it.

Picture held on my web site

2. When I try and browse to my Reporting Server (using I.E. 7) with the name http://<servername>/reports this is what I get.

Server Error in '/Reports' Application.

---

The configuration file contains an element that is not valid. The ReportServerUrl element is not a configuration file element.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Exception: The configuration file contains an element that is not valid. The ReportServerUrl element is not a configuration file element.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[Exception: The configuration file contains an element that is not valid. The ReportServerUrl element is not a configuration file element.]

Microsoft.ReportingServices.Diagnostics.RSConfiguration.ThrowInvalidFormat(String element) +41

Microsoft.ReportingServices.Diagnostics.UIConfiguration.ParseXML(XmlNode node, RSConfiguration configObject) +1135

Microsoft.ReportingServices.Diagnostics.RSConfiguration.ParseDocument() +972

Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load() +32

[ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information.]

Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load() +166

Microsoft.ReportingServices.Diagnostics.RSConfiguration.Construct(String configFileName) +62

Microsoft.ReportingServices.Diagnostics.RSConfiguration..ctor(String configFileName, String location) +296

Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String configFileName, String configLocation) +134

Microsoft.ReportingServices.UI.Global.get_ConfigurationManager() +84

Microsoft.ReportingServices.UI.GlobalApp.Application_Start(Object sender, EventArgs e) +32

---

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210

3. The error logs are very long so if you look at the bottom of the link above, you'll see links to the files. I'm sorry about the crude mechanism to provide the information to you. But I hope you can see access them.

Many thanks

Clint

|||

Can you open your RSWebApplication.config file(%ProgramFiles%\Microsoft SQL Server\MSSQL.x\Reporting Services\ReportManager\RSWebApplication.config) and check the entries for ReportServerUrl and ReportServerVirtualDirectory. You have to specify ONLY one of them and not both.

For example,

<Configuration>
<UI>
<ReportServerUrl></ReportServerUrl>
<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>

Thanks,
Sharmila

|||

Hi Sharmila, thanks for enquiring.

The contents of the configuration file is listed below:

The <servername> has replaced the name of my server.

Many thanks

Clint

-

<Configuration>

<UI>

<ReportServerUrl>http:/<servername>/reportserver</ReportServerUrl>

<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>

<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>

</UI>

<Extensions>

<DeliveryUI>

<Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl,ReportingServicesEmailDeliveryProvider">

<DefaultDeliveryExtension>True</DefaultDeliveryExtension>

<Configuration>

<RSEmailDPConfiguration>

<DefaultRenderingExtension>MHTML</DefaultRenderingExtension>

</RSEmailDPConfiguration>

</Configuration>

</Extension>

<Extension Name="Report Server FileShare" Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareUIControl,ReportingServicesFileShareDeliveryProvider"/>

</DeliveryUI>

</Extensions>

<Add Key="MaxActiveReqForOneUser" Value="20"/>

<Add Key="DisplayErrorLink" Value="true"/>

</Configuration>

|||

As seen in the config file, you have specified both ReportServerUrl and ReportServerVirtualDirectory. You can specify ONLY one.

<UI>

<ReportServerUrl>http:/<servername>/reportserver</ReportServerUrl>

<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>

<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>

</UI>

Try something like this,

<UI>

<ReportServerUrl>http:/<servername>/reportserver</ReportServerUrl>

<ReportServerVirtualDirectory></ReportServerVirtualDirectory>

<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>

</UI>

Hope this helps,

Sharmila

|||

Hi Sharmila, out of interest does specifying both make a difference? You clearly seem to imply that it does, I was just curious to know.

I'm going to try it now.

Regards

Clint

|||

I've just tried it with /reports and got this.

Error

The report server is not responding. Verify that the report server is running and can be accessed from this computer.

Home

I also tried browsing to the /reportserver and got this.

--

Reporting Services Error

---

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

For more information about this error navigate to the report server on the local server machine, or enable remote errors|||

Can we check a few things?

1. Is RS service running? Is yes, can we restart and also retart IIS.

2. Open the config tool and see if all sections are configured properly as before(in the screenshot you provided).

3. Also, look in the log files to get more info on the internal error.

Thanks,
Sharmila

|||

Hi Sharmila,

I have tried to answer your questions below:

1. I've restarted IIS

2. The configuration tool reports the service states in exactly the same way as my screen shot.

3. The report logs from 19:30 (GMT) are listed below the screenshot. Do you want me to provide the latest logs (22:30)?

Thanks

Clint

|||

Yes, please provide the latest logs.

Thanks,

Sharmila

|||

As an FYI..., there is a similar post that addresses the same issue. - http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=251336&SiteID=1

I just noticed that in the RSWebApplication.config, for ReportServerUrl, the Url is missing a "/" for http://. I'm assuming that it is just a typo. Can we just stop the RS service and start it again and also reset IIS.

<UI>

<ReportServerUrl>http:/<servername>/reportserver</ReportServerUrl>

<ReportServerVirtualDirectory></ReportServerVirtualDirectory>

<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>

</UI>

Thanks,
Sharmila

|||

Hi. I've updated the logs here.

Thanks

Clint

|||

Hi. I've restarted the RS services and IIS and yes it was a typo.

Thank you

Clint

|||Do you have <xmlns=..."> in your web.config (both report server and report manager dir), rsreportserver.config or rswebapplication.config files? If so remove the line.

Newbie - sa password error after ACT! install - Need pro's help!!!

Hello,
I am admittedly new to this, especially sql server and am in need of a pro's assistance.. I installed Microsoft Small Business accounting, which in turn installed and configured a sql server. When I installed ACT! 2005 (v7.0) and tried to create a database, it states that it cannot find the master file.... so I tried to install sql server from Microsofts site - downloaded all the packages, unzipped them and ran them... the error I get is that the sql server needs to have an sa password and to use some switch to change it... for the life of me I am lost here. I can't use ACT! at this point and I have not ideas of how to remove, reinstall or repair the sql server.... Any help you can provide would be greatly appreicated!

The default sa password is blank. Is it complaining that this is not acceptable and you need to change it ?

What version of SQL Server do you have ? It sounds like SQL Server Express 2005 ? You may well have two instances installed now, one that came with ACT, and one that you've installed.

Overall, I'd say ACT are the people to talk to, you're using SQL Server with ACT, right ?

|||Yes, it is saying that the sa password is empty...specifically: "A strong sa password is required for security purposes. Please us SAPWD switch to supply the same. Refer to readme for more details. Setup will now exit." That is what is says when I attempt to run ANY installation version of SQL ... attempting to correct the sql error that I get when I run ACT!. Is there a way to repair or rebuild the sql server? I have only one instance, from the ACT! install... Thanks for the reply.. !!|||By the way.. that was the install error for SQL Server 2000 version A specifically... I installed SQL Server 2005 Express... or tried to... it would run either..|||

ACT will support either one ? I'm not sure that you don't have two instances running now ( SQL Server can have more than one version, or multiple instances of the same version, running on a machine ). If I were you, I'd uninstall the lot, including SQL Server, and reinstall ACT. To set the password, you run the installer for SQL Server from the command line and specify SAPWD="whatever", which will set the SA password. If the version of SQL Server you have installed has a management console, or whatever it was called in SS2000, you can go into it, find the Users section, and change the password there.

However, I would be more inclined to do a reinstall from scratch and then try the ACT site:

http://www.act.com/support/technicalsupport/index.cfm

I've looked and I can't see anything specific there, but the problem obviously relates to ACT, and if you've paid for it, they would be the ones who know what's going on, and should be supporting you to get their program working.

|||Sounds great... as for ACT! I called them already.. since I bought this version a while ago,. they stopped supporting it a couple months ago! Nice huh?! As for uninstalling them, I'm all for it.. how do I uninstall SS2000 and all the other instances of SQL Server? It's not in my remove programs dialog....... Thanks again for the help... look for to hearing back from you|||

If SS2000 is not in your list, perhaps MSDE is ( that's the free version ). Otherwise, maybe it uninstalls with ACT. If you go to Control Panel/Administrative Tools/Services, the list is alphabetical, if there are any listings that start with SQL Server, you still have SQL Server installed :-)

Your question is right on the edge of what is on topic here, and that means you're unlikely to find people with direct, first hand experience of the problem. If an uninstall/reinstall doesn't solve it, then I'd suggest looking for a forum populated with people who use ACT. I'm happy to try and help, but I'm pretty much in the dark, all I can do is comment based on what I know of SQL Server.

Newbe Question - How to install SQL 2000 Cluster

Good day,
I'm looking for a document that shows the steps needed in order to install
SQL 2000 on a windows 2003 cluster.
Thanks in advance
Oren Zippori
Great webcast on the subject:
http://support.microsoft.com/default...lurb061002.asp
http://www.sql-server-performance.co...stall_main.asp
has great information for Windows 2000, just add Q817064 and then 301600 for
MSDTC support and you are good to go.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog
"Oren Zippori" <orenzp@.hotmail.com> wrote in message
news:ezlb3woxEHA.3416@.TK2MSFTNGP09.phx.gbl...
> Good day,
> I'm looking for a document that shows the steps needed in order to install
> SQL 2000 on a windows 2003 cluster.
> Thanks in advance
> Oren Zippori
>
|||Thanks for the Info Rodney.
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:%238D7pMpxEHA.2540@.TK2MSFTNGP15.phx.gbl...
> Great webcast on the subject:
> http://support.microsoft.com/default...lurb061002.asp
> http://www.sql-server-performance.co...stall_main.asp
> has great information for Windows 2000, just add Q817064 and then 301600
> for MSDTC support and you are good to go.
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> http://www.msmvps.com/clustering - Blog
> "Oren Zippori" <orenzp@.hotmail.com> wrote in message
> news:ezlb3woxEHA.3416@.TK2MSFTNGP09.phx.gbl...
>

NEWB: Moving DBs to new install of SQL Serv. w/o sp_detach_db

Hi,
After a power outage (and UPS failure), my boss's SQL Server 2000 won't
start (or crashes quickly or something). We don't have any backups, as it's
a test server. Is there a way to import the database files into a new SQL
installation? By "installation," I mean either a re-installed SS, a second
installation on the same PC, or maybe even on another PC. In another words,
given only the files sitting on the harddrive, is there a way to "import"
the DBs in those files into SS?
Sp_attach_db would probably be the answer, except it seems to require
running sp_detach_db...which I cannot do, as SS is not working.
Thanks in advance,
JayYou could try sp_attach_single_file_db, though I believe that may require a
successful detach as well.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Jay" <twentycavities@.hotmail.com> wrote in message
news:g2MCb.17882$Vg3.15076@.fe3.columbus.rr.com...
> Hi,
> After a power outage (and UPS failure), my boss's SQL Server 2000 won't
> start (or crashes quickly or something). We don't have any backups, as
it's
> a test server. Is there a way to import the database files into a new SQL
> installation? By "installation," I mean either a re-installed SS, a second
> installation on the same PC, or maybe even on another PC. In another
words,
> given only the files sitting on the harddrive, is there a way to "import"
> the DBs in those files into SS?
> Sp_attach_db would probably be the answer, except it seems to require
> running sp_detach_db...which I cannot do, as SS is not working.
>
> Thanks in advance,
> Jay
>
>|||Jay,
I dont see why you could not simply copy the MDF and LDF
files to another machine (or put in a safe place). Then
fix the issue with SQL2K not starting.
You should then be able to attache the database and log
file again via Enterprise Manager (right-click on
Databases/All tasks/Attach Database...).
Ron
>--Original Message--
>Hi,
>After a power outage (and UPS failure), my boss's SQL
Server 2000 won't
>start (or crashes quickly or something). We don't have
any backups, as it's
>a test server. Is there a way to import the database
files into a new SQL
>installation? By "installation," I mean either a re-
installed SS, a second
>installation on the same PC, or maybe even on another
PC. In another words,
>given only the files sitting on the harddrive, is there
a way to "import"
>the DBs in those files into SS?
>Sp_attach_db would probably be the answer, except it
seems to require
>running sp_detach_db...which I cannot do, as SS is not
working.
>
>Thanks in advance,
>Jay
>
>
>.
>|||I believe all he has to do is attach the databases. Find the old =databases and attach them. I have done this before and in fact will be =doing it again shortly. Attach through the GUI in your other SQL =Manager.
-- George Hester
__________________________________
"Jay" <twentycavities@.hotmail.com> wrote in message =news:g2MCb.17882$Vg3.15076@.fe3.columbus.rr.com...
> Hi,
> After a power outage (and UPS failure), my boss's SQL Server 2000 =won't
> start (or crashes quickly or something). We don't have any backups, as =it's
> a test server. Is there a way to import the database files into a new =SQL
> installation? By "installation," I mean either a re-installed SS, a =second
> installation on the same PC, or maybe even on another PC. In another =words,
> given only the files sitting on the harddrive, is there a way to ="import"
> the DBs in those files into SS?
> > Sp_attach_db would probably be the answer, except it seems to require
> running sp_detach_db...which I cannot do, as SS is not working.
> > > Thanks in advance,
> > Jay
> > > >|||>> I believe all he has to do is attach the databases.
This works fine when the databases have been detached successfully.
However, it's not always so easy when the "detach" wasn't clean (as in Jay's
case).
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/|||Well I have done it with no detaching. In fact I have to do it again =shortly. The Windows Server crashed and there is no reliable way I know =of to get SQL Server out of there functional and I need the databases. =So as I do it I'll probably remember the corners I had to cut to get it =to work. If he is interested I'll describe the steps here.
-- George Hester
__________________________________
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message =news:uGW9ANwwDHA.3428@.TK2MSFTNGP11.phx.gbl...
> >> I believe all he has to do is attach the databases.
> > This works fine when the databases have been detached successfully.
> However, it's not always so easy when the "detach" wasn't clean (as in =Jay's
> case).
> > -- > Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
> >|||> Well I have done it with no detaching.
I think you have been lucky, and this is certainly not guaranteed to work.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/

NEWB: Moving DBs to new install of SQL Serv. w/o sp_detach_db

Hi,
After a power outage (and UPS failure), my boss's SQL Server 2000 won't
start (or crashes quickly or something). We don't have any backups, as it's
a test server. Is there a way to import the database files into a new SQL
installation? By "installation," I mean either a re-installed SS, a second
installation on the same PC, or maybe even on another PC. In another words,
given only the files sitting on the harddrive, is there a way to "import"
the DBs in those files into SS?

Sp_attach_db would probably be the answer, except it seems to require
running sp_detach_db...which I cannot do, as SS is not working.

Thanks in advance,

Jay[posted and mailed, please reply in news]

Jay (twentycavities@.hotmail.com) writes:
> After a power outage (and UPS failure), my boss's SQL Server 2000 won't
> start (or crashes quickly or something). We don't have any backups, as
> it's a test server. Is there a way to import the database files into a
> new SQL installation? By "installation," I mean either a re-installed
> SS, a second installation on the same PC, or maybe even on another PC.
> In another words, given only the files sitting on the harddrive, is
> there a way to "import" the DBs in those files into SS?
> Sp_attach_db would probably be the answer, except it seems to require
> running sp_detach_db...which I cannot do, as SS is not working.

sp_attach_db would indeed be the first thing to try. Since you did
not detach the database cleanly, it may not work. But it's worth to
give it a try. You most likely need both the data files and the log
files.

The other option to try is sp_attach_single_file_db. but if
sp_attach_db does not work, I would not place my bets on this one.

If that files, there is yet a way, but I wiill not post this method
here as it is too dangerous. Suffice to say that while you will be
able to access the database file this, you will get it exactly in
the state it was in at the time of the crash. So if this was a state
of inconsistency in the midst of a transaction, you have a mess of a
database.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||In article <mHLCb.17818$Vg3.10491@.fe3.columbus.rr.com>,
twentycavities@.hotmail.com says...
> Sp_attach_db would probably be the answer, except it seems to require
> running sp_detach_db...which I cannot do, as SS is not working.

I got hung up on the same thing, but as Erland points out, it will
probably work. It did for me.

-- Rick