CAN I GET MY DATA BACK AFTER REINSTALLING MSDE

WHEN I REINSTALLED MSDE THE MSQL7/DATA FOLDER HAS MYDB.MDF AND MYDB.LDF FILES IN THERE.
THE NEW INSTALLATION WILL NOT RECOGNISE THESE FROM THE OLD INSTALLATION.
IS THERE ANY WAY TO REINSTATE THESE DBS OTHER THAN FROM THE BACK UP THAT I DID NOT DO?
HOPING AND PRAYING IN YOUR HANDS O LORD GURU.
Hi Lofty,
You can "reattach" the database. Take a look at the sp_attach_db stored proc
in BOL.
Basically, you can just say:
sp_attach_db 'newdbname','pathtomdffile','pathtoldsfile'
HTH,
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"LOFTY" <anonymous@.discussions.microsoft.com> wrote in message
news:57943C4F-8CC8-4CB8-AC3F-C5B097662168@.microsoft.com...
> WHEN I REINSTALLED MSDE THE MSQL7/DATA FOLDER HAS MYDB.MDF AND MYDB.LDF
FILES IN THERE.
> THE NEW INSTALLATION WILL NOT RECOGNISE THESE FROM THE OLD INSTALLATION.
> IS THERE ANY WAY TO REINSTATE THESE DBS OTHER THAN FROM THE BACK UP THAT I
DID NOT DO?
> HOPING AND PRAYING IN YOUR HANDS O LORD GURU.

Can I change the language settings after installation?

Hi All,

I have sql server 2005 dveloper edition installed on my XP pro. Both are English editions. I used the default language settings to install sql server 2005. The XP Pro has asian-language support installed and supports Chinese input.

I have tables with columns in nvarchar. But I can not input Chinese into the columns directly in the management studio or using sql statement.

How could I change the language so the Chinese chracaters being accepted?

Thanks a lot!

Gavin

You can change the collation sequence at the database, table, and column level. If you didn't specify any options, then the database will be created with your default collation sequence from the instance. If you change the collation sequence on the database or table to one compatible by the Chinese character set you are using, then you can input that data. You are going to need to drop and recreate the table since switching the collation sequence on the database doesn't automatically do so on the table.|||

Thanks Michael.

I remembered that it's not easy to do this in the previous versions (maybe I'm wrong?). So I think it is the same for 2005. When I was checking properties of the database, I noticed collation could be changed. I tried and it worked for me. I did not check the table and column level but I believe your are right. I may try them later.

Gavin

Can create login but cannot connect (sa doesn't even work also)

Hi,

Please direct me to the right forum if this is not the right one.

Upon installation of SQL Server 2005, I opened the SQL Server Management Studio, connected using Windows Authentication and went to the security node in the tree. I created a log in called "TestLogin". I restarted my server just to make sure everything took and when I tried to log in using TestLogin via SQL Server Authentication, I get the below error. I have mixed mode enabled as well as named pipes. I am not sure what the issue is or what to try next. I even get the same error when trying to use "sa".

Thanks,

- Joel

TITLE: Connect to Server

Cannot connect to TestServer.

ADDITIONAL INFORMATION:

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476

BUTTONS:

OK

Can you check the SQL Server errorlog and copy the last errors reported there?

Thanks
Laurentiu

|||Hi. I had the same problem. Username is case sensitiv and the error message is odd...

Can create login but cannot connect (sa doesn't even work also)

Hi,

Please direct me to the right forum if this is not the right one.

Upon installation of SQL Server 2005, I opened the SQL Server Management Studio, connected using Windows Authentication and went to the security node in the tree. I created a log in called "TestLogin". I restarted my server just to make sure everything took and when I tried to log in using TestLogin via SQL Server Authentication, I get the below error. I have mixed mode enabled as well as named pipes. I am not sure what the issue is or what to try next. I even get the same error when trying to use "sa".

Thanks,

- Joel

TITLE: Connect to Server

Cannot connect to TestServer.

ADDITIONAL INFORMATION:

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476

BUTTONS:

OK

Can you check the SQL Server errorlog and copy the last errors reported there?

Thanks
Laurentiu

|||Hi. I had the same problem. Username is case sensitiv and the error message is odd...

Can a clustered SQL 2000 installation run without DNS

A client of ours wants to run a clustered instance of SQL and not have it
dependent on name resolution for anything.
Since it appears that SQL is heavily dependent on AD and DNS for the virtual
server piece, does this dependancy constitute a single point of failure?
You will need DNS and AD for installing a SQL Server cluster or adding nodes
to it.
The nodes themselves don't necessarily need an active DC or DNS. In fact you
should enter the node, and cluster name in the host file to reduce the
amount of time a node requires to go online.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Brian Cook" <BrianCook@.discussions.microsoft.com> wrote in message
news:368FFF28-CD47-4F92-A2D8-0FA72DEC1897@.microsoft.com...
> A client of ours wants to run a clustered instance of SQL and not have it
> dependent on name resolution for anything.
> Since it appears that SQL is heavily dependent on AD and DNS for the
virtual
> server piece, does this dependancy constitute a single point of failure?
>
|||Hilary, thanks for the validation. I know that AD and DNS is required, I just
am having problems convincing the client that they are required. I have
pointed out multiple articles in SQL books online, and TechNet/Support items
that also say the same thing.
Must have assumptions are not a satisfactory answer for this client. They
need to see it it writing that it must have explicitly AD/DNS.
Brian
"Hilary Cotter" wrote:

> You will need DNS and AD for installing a SQL Server cluster or adding nodes
> to it.
> The nodes themselves don't necessarily need an active DC or DNS. In fact you
> should enter the node, and cluster name in the host file to reduce the
> amount of time a node requires to go online.
>
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> "Brian Cook" <BrianCook@.discussions.microsoft.com> wrote in message
> news:368FFF28-CD47-4F92-A2D8-0FA72DEC1897@.microsoft.com...
> virtual
>
>
|||I'd try to run cluster administrator to create a new cluster on a standalone
win2003 and take screen shots of it failing because it can't register the
cluster name in AD, or the IP address for the cluster in DNS.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Brian Cook" <BrianCook@.discussions.microsoft.com> wrote in message
news:30241601-0AD5-4673-8102-48FEC2C932DE@.microsoft.com...
> Hilary, thanks for the validation. I know that AD and DNS is required, I
just
> am having problems convincing the client that they are required. I have
> pointed out multiple articles in SQL books online, and TechNet/Support
items[vbcol=seagreen]
> that also say the same thing.
> Must have assumptions are not a satisfactory answer for this client. They
> need to see it it writing that it must have explicitly AD/DNS.
> Brian
> "Hilary Cotter" wrote:
nodes[vbcol=seagreen]
you[vbcol=seagreen]
it[vbcol=seagreen]
failure?[vbcol=seagreen]
|||Hillary, here is the kicker for you. I don't know how they did it, however
they got the cluster and sql to run without the domain controllers/dns
servers. I will be heading over there in a little while to figure out what
they did.
Either way I know it is not a supported configuration by Microsoft, and I
cannot guarantee that it will not fail completely at some point and bite them
in the fanny.
Brian
"Hilary Cotter" wrote:

> I'd try to run cluster administrator to create a new cluster on a standalone
> win2003 and take screen shots of it failing because it can't register the
> cluster name in AD, or the IP address for the cluster in DNS.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> "Brian Cook" <BrianCook@.discussions.microsoft.com> wrote in message
> news:30241601-0AD5-4673-8102-48FEC2C932DE@.microsoft.com...
> just
> items
> nodes
> you
> it
> failure?
>
>
|||Hilary, the following items were changed on both nodes of the cluster and
allows the resources to function correctly without AD/DNS.
MSSQLSERVER service to use LocalSystem Account, Interact with Desktop
unchecked.
SQLSERVERAGENT service to use LocalSystem Account, Interact with Desktop
unchecked.
Cluster Service to use local user account which has admin rights. Use same
account and password for both computers.
Following items added to lmhosts file;
10.50.32.34 NOCTMDS-DBTSQL #PRE //SQL Server Virtual IP
10.50.32.35 NOCTMDS-DBTEST #PRE //Microsoft Cluster Server
Virtual IP
DNS servers removed from TCP/IP Properties.
Enable NetBIOS over TCP/IP.
Only other change that was made is to /flushdns from both computers. Both
AD/DNS servers are turned off.
Cluster failover occurs normally.
First question is why does this work?
Is this a supported configuration by Microsoft, or does this go against
“Best Practices” for any specific reason?
If not supported by Microsoft, what is the down side to running in this
manner, and what problems could be expected by not using a Domain\Username
account for the services?
Any white papers, tech notes, releasable internal documents that specify it
must be done one way or the other (AD/DNS or Not needed) would be greatly
appreciated.
"Brian Cook" wrote:
[vbcol=seagreen]
> Hillary, here is the kicker for you. I don't know how they did it, however
> they got the cluster and sql to run without the domain controllers/dns
> servers. I will be heading over there in a little while to figure out what
> they did.
> Either way I know it is not a supported configuration by Microsoft, and I
> cannot guarantee that it will not fail completely at some point and bite them
> in the fanny.
> Brian
> "Hilary Cotter" wrote:
|||What version of the OS are we talking about 2000 or 2003?
2003 does seem to require AD and DNS to be live when creating the cluster.
It does appear that somehow they have managed to create a cluster without an
active DNS or AD. I don't believe Microsoft will support this configuration.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Brian Cook" <BrianCook@.discussions.microsoft.com> wrote in message
news:B2143F93-C7C2-427E-9F54-970EB2117B7D@.microsoft.com...
> Hilary, the following items were changed on both nodes of the cluster and
> allows the resources to function correctly without AD/DNS.
> MSSQLSERVER service to use LocalSystem Account, Interact with Desktop
> unchecked.
> SQLSERVERAGENT service to use LocalSystem Account, Interact with Desktop
> unchecked.
> Cluster Service to use local user account which has admin rights. Use same
> account and password for both computers.
> Following items added to lmhosts file;
> 10.50.32.34 NOCTMDS-DBTSQL #PRE //SQL Server Virtual IP
> 10.50.32.35 NOCTMDS-DBTEST #PRE //Microsoft Cluster Server
> Virtual IP
> DNS servers removed from TCP/IP Properties.
> Enable NetBIOS over TCP/IP.
> Only other change that was made is to /flushdns from both computers. Both
> AD/DNS servers are turned off.
> Cluster failover occurs normally.
> First question is why does this work?
> Is this a supported configuration by Microsoft, or does this go against
> "Best Practices" for any specific reason?
> If not supported by Microsoft, what is the down side to running in this
> manner, and what problems could be expected by not using a Domain\Username
> account for the services?
> Any white papers, tech notes, releasable internal documents that specify
it[vbcol=seagreen]
> must be done one way or the other (AD/DNS or Not needed) would be greatly
> appreciated.
>
> "Brian Cook" wrote:
however[vbcol=seagreen]
what[vbcol=seagreen]
I[vbcol=seagreen]
them[vbcol=seagreen]
standalone[vbcol=seagreen]
the[vbcol=seagreen]
required, I[vbcol=seagreen]
have[vbcol=seagreen]
TechNet/Support[vbcol=seagreen]
They[vbcol=seagreen]
adding[vbcol=seagreen]
In fact[vbcol=seagreen]
the[vbcol=seagreen]
message[vbcol=seagreen]
not have[vbcol=seagreen]
the[vbcol=seagreen]
|||Hilary, this is a two node W2K3 installation. We have replicated it in our
lab and it is working. I am opening a case with Microsoft today to confirm my
suspicions that it is not a support configuration, and also see if there are
any down sides to this configuration.
My concern is that since we are developing an application that uses SQL, yet
does not rely on the "name" of the db server, and at some point down the
road, if the cluster fails, and stops working will it be because of the way
the system is configured or something else as it is not configured as it was
designed to be used, and our company end up with the liability for the
failure.
Brian
"Hilary Cotter" wrote:

> What version of the OS are we talking about 2000 or 2003?
> 2003 does seem to require AD and DNS to be live when creating the cluster.
> It does appear that somehow they have managed to create a cluster without an
> active DNS or AD. I don't believe Microsoft will support this configuration.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> "Brian Cook" <BrianCook@.discussions.microsoft.com> wrote in message
> news:B2143F93-C7C2-427E-9F54-970EB2117B7D@.microsoft.com...
> it
> however
> what
> I
> them
> standalone
> the
> required, I
> have
> TechNet/Support
> They
> adding
> In fact
> the
> message
> not have
> the
>
>

Can *datastore.xml be used to populate template.ini as a substitute for setup.iss?

Objective

Do a manual installation of SQL Server 2005 (which could be an upgrade from SQL Server 2000) and record the steps. Replay the steps for an unattended installation of SQL Server 2005.

Problem

There isn't a setup.ini file for SQL Server 2005. There is a template.ini for unattended installations of SQL Server 2005, but it doesn't obviously map to selections on manual installation dialog boxes.

Desired workaround

Capture the steps of a manual installation and use them to populate template.ini.

Relevant background for a potential solution

A manual installation creates log files. So does an unattended installation. But the unattended installation writes all of the log files into a single zip file.

What is important to know is that an unattended installation creates an additional file, a *datasource.xml file. This XML file is found in the zip file with all of the other log files. If you open this XML file, you'll see that the attribute names correspond to keywords in template.ini.

Potential solution

If a manual installation could be forced to generate a *datasource.xml file, then it should be possible to map the settings in the file to keywords in template.ini.

So, how can a *datasource.xml file be created? In post http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=359678&SiteID=1, Jeffrey Baker says "add LOGNAME=<path to cab> and run setup again". Unfortunately, these instructions are too vague. Where is this added? To the command line, to a setup.ini (if so, in which directory, and in which section should he addition be made?). I did lots of searches and couldn't find the answers.

Hi John,

In SQL2K we supported the option of "recording" the installation options to a settings file which could be used in subsequent installations. This functionality was not carried forward to SQL2K5.

Using the datasource.xml file, as mentioned above, is not a supported mechanism for creating an input template.ini file. You'll need to manually author the template.ini to contain the installation settings you wish.