Showing posts with label install. Show all posts
Showing posts with label install. Show all posts

Monday, March 26, 2012

How to apply SQL Server 2005 Express SP1 to the version of SQL Server 2005 Express which install

When I installed VS 2005, it installed the default version of SQL Server 2005 Express that ships with Visual Studio 2005 installer media.

How can apply SQL Server 2005 Express SP1 to update this existing instance?

Currently, if I run this query:

SELECT @.@.version

I get the following:

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

After applying SP1, I should get 9.00.2047.00.

Should I just go to this link and download & install the SQL Server 2005 Express Edition SP1:

http://msdn.microsoft.com/vstudio/express/sql/download/


Thank you,

Bashman

Follow the instructions on the readme file in the setup package. SQL Express SP1 is not a Service pack fix, its a full product. The instructions in the readme are very detailed to get through the process.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Its easy to just say go read the Readme!

Which Readme you talking about?

http://download.microsoft.com/download/b/d/1/bd1e0745-0e65-43a5-ac6a-f6173f58d80e/ReadmeSQLEXP2005.htm

http://download.microsoft.com/download/b/d/1/bd1e0745-0e65-43a5-ac6a-f6173f58d80e/ReadmeSQLEXP2005Advanced.htm

Neither of the two above Readme(s) tells me anything related to the VD2005 SQL 2005 Express that I am talking about.

If you know of any other Readme(s), please list the links!

Thanks for NOTHING!

|||

Since I didn't get any meaningful answers, I decided to take a chance and see what happens if I just run the upgrade setup as is.

I made sure I had backups first, then I stopped the SQLEXPRESS service.

Run the setup and followed the instructions on the screen using the default answers for all except for selecting which instance to upgrade.

All went well.

So for anyone looking at this thread, the quick answer is backup and install as is you'll be fine!

Again, thanks for nothing!

|||Hi,

its http://download.microsoft.com/download/b/d/1/bd1e0745-0e65-43a5-ac6a-f6173f58d80e/ReadmeSQLEXP2005.htm

3.1 Prepare for a SQL Server Express SP1 Installation

HTH, Jens SUessmeyer.

http://www.sqlserver2005.de|||

That's exactly the section I followed (Backup & Stop the service).

Other than that, the rest of the Readme didn't apply to my original question.

Also, good thing that you read the Readme now that I listed the link readly for your reading enjoyment!

Enjoy everyone,

Bashman

|||I lost you, what does "Also, good thing that you read the Readme now that I listed the link readly for your reading enjoyment!" mean ? Which readme do you expect if you are struggeling with SQL Server Express SP1 and you have problems with SQL Server Express SP1. The section if was talking about in my previous post was just about that, for making that clearer I posted you the link to the relevant readme.

You asked the question which should be investigated at 06:08, at 06:12 you answered that you did not get any meaningful explanations, what do you expect the response times to be in a public forum, thats not a monitored chat or a paid support forum. So, you did not receive any answer in 4 minutes ? Thats really "horrible".

HTH, Jens SUessmeyer.

http://www.slqserver2005.de|||

Methinks the lady protests too much!

I always knew that my PC was fast, but I didn't know that it was that fast. Where I actually can backup my data & run a lengthy SQL server installation and post a reply in 4 minutes or less!

I realy have a FAST computer. If anyone is interested, I can list my PC specs for you!

Back to the subject, my reply to your "read the Readme" post was 24 hours after my original Post.

I see your answers on this board and they are usually typical of "read the Readme" kind of answers.

That's fine if you list or point to the Readme link and even better if you would point to the section of the Readme related to the answer of the question.

I did read the Readme(s) that I listed and found the section most apply to my question and took a chance on it.

Then I came back to the board and posted a reply to you and listed the two links (it took me about 4 minuts to write, slow typies but fast PC).

Four minutes later, I then listed what I did to get the job done.

I hope in the future when you answer with "Read the Readme(s)", you would try to point the link or the section most apply to the question/answer.

You know, I could just have gone and ignured this board "because I didn't get any answers from it".

But I came back and listed the Readme(s) and listed what I did so that the next time someone looking for this question/answer, would find something meaningful other than "Read the Readme(s)".

I don't know how long this is talking me to type, but I am the slow typest with a fast PC,

Bashman

|||From you post it seems that you didn′t know where to look at: "Neither of the two above Readme(s) tells me anything related to the VD2005 SQL 2005 Express that I am talking about." My assumptions was that you are smart enough to figure out that I ment the SQL Server Express SP1 readme, sorry for that. So I gave you another hint to look into that special readme under the mentioned section. Nevertheless, good that you fixed your problem.

HTH, Jens Suessmeyer.|||

You want the Credit, you got the Credit!

Yes, whithout your hint I was lost but then I was found! I realy didn't found my why without your reply!

I need your hand holding to lead me to the right Readme file.

By listing the two links, I showed you how loast I was!

But once your hint gave my the way, I managed to resolve my own problem in less than 4 minutes using my fast PC!

Thank you, Thank you, Thank you!

|||OK, you didn′t get it yet. Its just about being polite which you weren′t.

Friday, March 23, 2012

How to alter server name?

Hi,
How to alter the server name after I install a SQL Server 2000. The SQL
Server name would be the computer name in default, however, I want to alter
the Server name different from computer name which the SQL Server reside in.Look up sp_dropserver and sp_addserver in BOL
HTH
--
Ray Higdon MCSE, MCDBA, CCNA
--
"Yelson Hwo" <hy5005@.hotmail.com> wrote in message
news:e0vxSWs6DHA.2524@.TK2MSFTNGP11.phx.gbl...
> Hi,
> How to alter the server name after I install a SQL Server 2000. The SQL
> Server name would be the computer name in default, however, I want to
alter
> the Server name different from computer name which the SQL Server reside
in.
>|||I have try this way, it does not work.
"Ray Higdon" <sqlhigdon@.nospam.yahoo.com> дÈëÓʼþ
news:OJYSmbs6DHA.2732@.TK2MSFTNGP09.phx.gbl...
> Look up sp_dropserver and sp_addserver in BOL
> HTH
> --
> Ray Higdon MCSE, MCDBA, CCNA
> --
> "Yelson Hwo" <hy5005@.hotmail.com> wrote in message
> news:e0vxSWs6DHA.2524@.TK2MSFTNGP11.phx.gbl...
> > Hi,
> > How to alter the server name after I install a SQL Server 2000. The SQL
> > Server name would be the computer name in default, however, I want to
> alter
> > the Server name different from computer name which the SQL Server reside
> in.
> >
> >
>|||What did you try? Can you provide the code?
--
Ray Higdon MCSE, MCDBA, CCNA
--
"Yelson Hwo" <hy5005@.hotmail.com> wrote in message
news:e41mZgs6DHA.3896@.TK2MSFTNGP11.phx.gbl...
> I have try this way, it does not work.
> "Ray Higdon" <sqlhigdon@.nospam.yahoo.com> дÈëÓʼþ
> news:OJYSmbs6DHA.2732@.TK2MSFTNGP09.phx.gbl...
> > Look up sp_dropserver and sp_addserver in BOL
> >
> > HTH
> >
> > --
> > Ray Higdon MCSE, MCDBA, CCNA
> > --
> > "Yelson Hwo" <hy5005@.hotmail.com> wrote in message
> > news:e0vxSWs6DHA.2524@.TK2MSFTNGP11.phx.gbl...
> > > Hi,
> > > How to alter the server name after I install a SQL Server 2000. The
SQL
> > > Server name would be the computer name in default, however, I want to
> > alter
> > > the Server name different from computer name which the SQL Server
reside
> > in.
> > >
> > >
> >
> >
>|||Hi:
Please read this KB article and it may be useful:
http://support.microsoft.com/default.aspx?scid=kb;en-us;303774
Best Wishes
Wei Ci Zhou|||I did as the below:
--
sp_dropserver 'old_name'
go
sp_addserver 'new_name', 'local'
go
--
now I restart the SQL Services, the @.@.servername change as the "new_name",
but acctually the SQL Server Name in work still is "old_name", if you try
use the "new_name" as the Server name, you can't establish a connection with
it, you can only establish a connection with the "old_name".
"Ray Higdon" <sqlhigdon@.nospam.yahoo.com>
news:uBVtRks6DHA.2576@.TK2MSFTNGP11.phx.gbl...
> What did you try? Can you provide the code?
> --
> Ray Higdon MCSE, MCDBA, CCNA
> --
> "Yelson Hwo" <hy5005@.hotmail.com> wrote in message
> news:e41mZgs6DHA.3896@.TK2MSFTNGP11.phx.gbl...
> > I have try this way, it does not work.
> > "Ray Higdon" <sqlhigdon@.nospam.yahoo.com> дÈëÓʼþ
> > news:OJYSmbs6DHA.2732@.TK2MSFTNGP09.phx.gbl...
> > > Look up sp_dropserver and sp_addserver in BOL
> > >
> > > HTH
> > >
> > > --
> > > Ray Higdon MCSE, MCDBA, CCNA
> > > --
> > > "Yelson Hwo" <hy5005@.hotmail.com> wrote in message
> > > news:e0vxSWs6DHA.2524@.TK2MSFTNGP11.phx.gbl...
> > > > Hi,
> > > > How to alter the server name after I install a SQL Server 2000. The
> SQL
> > > > Server name would be the computer name in default, however, I want
to
> > > alter
> > > > the Server name different from computer name which the SQL Server
> reside
> > > in.
> > > >
> > > >
> > >
> > >
> >
> >
>|||I didn't catch that was what you were trying to do, See if this link helps -
http://support.microsoft.com/default.aspx?scid=kb;en-us;289573
Ray Higdon MCSE, MCDBA, CCNA
--
"Yelson Hwo" <hy5005@.hotmail.com> wrote in message
news:uRvPr0s6DHA.2168@.TK2MSFTNGP12.phx.gbl...
> I did as the below:
> --
> sp_dropserver 'old_name'
> go
> sp_addserver 'new_name', 'local'
> go
> --
> now I restart the SQL Services, the @.@.servername change as the "new_name",
> but acctually the SQL Server Name in work still is "old_name", if you try
> use the "new_name" as the Server name, you can't establish a connection
with
> it, you can only establish a connection with the "old_name".
> "Ray Higdon" <sqlhigdon@.nospam.yahoo.com>
> news:uBVtRks6DHA.2576@.TK2MSFTNGP11.phx.gbl...
> > What did you try? Can you provide the code?
> >
> > --
> > Ray Higdon MCSE, MCDBA, CCNA
> > --
> > "Yelson Hwo" <hy5005@.hotmail.com> wrote in message
> > news:e41mZgs6DHA.3896@.TK2MSFTNGP11.phx.gbl...
> > > I have try this way, it does not work.
> > > "Ray Higdon" <sqlhigdon@.nospam.yahoo.com> дÈëÓʼþ
> > > news:OJYSmbs6DHA.2732@.TK2MSFTNGP09.phx.gbl...
> > > > Look up sp_dropserver and sp_addserver in BOL
> > > >
> > > > HTH
> > > >
> > > > --
> > > > Ray Higdon MCSE, MCDBA, CCNA
> > > > --
> > > > "Yelson Hwo" <hy5005@.hotmail.com> wrote in message
> > > > news:e0vxSWs6DHA.2524@.TK2MSFTNGP11.phx.gbl...
> > > > > Hi,
> > > > > How to alter the server name after I install a SQL Server 2000.
The
> > SQL
> > > > > Server name would be the computer name in default, however, I want
> to
> > > > alter
> > > > > the Server name different from computer name which the SQL Server
> > reside
> > > > in.
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||Seems like you didn't rename the machine in Windows?
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Yelson Hwo" <hy5005@.hotmail.com> wrote in message news:uRvPr0s6DHA.2168@.TK2MSFTNGP12.phx.gbl...
> I did as the below:
> --
> sp_dropserver 'old_name'
> go
> sp_addserver 'new_name', 'local'
> go
> --
> now I restart the SQL Services, the @.@.servername change as the "new_name",
> but acctually the SQL Server Name in work still is "old_name", if you try
> use the "new_name" as the Server name, you can't establish a connection with
> it, you can only establish a connection with the "old_name".
> "Ray Higdon" <sqlhigdon@.nospam.yahoo.com>
> news:uBVtRks6DHA.2576@.TK2MSFTNGP11.phx.gbl...
> > What did you try? Can you provide the code?
> >
> > --
> > Ray Higdon MCSE, MCDBA, CCNA
> > --
> > "Yelson Hwo" <hy5005@.hotmail.com> wrote in message
> > news:e41mZgs6DHA.3896@.TK2MSFTNGP11.phx.gbl...
> > > I have try this way, it does not work.
> > > "Ray Higdon" <sqlhigdon@.nospam.yahoo.com> дÈëÓʼþ
> > > news:OJYSmbs6DHA.2732@.TK2MSFTNGP09.phx.gbl...
> > > > Look up sp_dropserver and sp_addserver in BOL
> > > >
> > > > HTH
> > > >
> > > > --
> > > > Ray Higdon MCSE, MCDBA, CCNA
> > > > --
> > > > "Yelson Hwo" <hy5005@.hotmail.com> wrote in message
> > > > news:e0vxSWs6DHA.2524@.TK2MSFTNGP11.phx.gbl...
> > > > > Hi,
> > > > > How to alter the server name after I install a SQL Server 2000. The
> > SQL
> > > > > Server name would be the computer name in default, however, I want
> to
> > > > alter
> > > > > the Server name different from computer name which the SQL Server
> > reside
> > > > in.
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>sql

How to alter server name?

Hi,
How to alter the server name after I install a SQL Server 2000. The SQL
Server name would be the computer name in default, however, I want to alter
the Server name different from computer name which the SQL Server reside in.Look up sp_dropserver and sp_addserver in BOL
HTH
Ray Higdon MCSE, MCDBA, CCNA
--
"Yelson Hwo" <hy5005@.hotmail.com> wrote in message
news:e0vxSWs6DHA.2524@.TK2MSFTNGP11.phx.gbl...
quote:

> Hi,
> How to alter the server name after I install a SQL Server 2000. The SQL
> Server name would be the computer name in default, however, I want to

alter
quote:

> the Server name different from computer name which the SQL Server reside

in.
quote:

>
|||I have try this way, it does not work.
"Ray Higdon" <sqlhigdon@.nospam.yahoo.com> д?
news:OJYSmbs6DHA.2732@.TK2MSFTNGP09.phx.gbl...
quote:

> Look up sp_dropserver and sp_addserver in BOL
> HTH
> --
> Ray Higdon MCSE, MCDBA, CCNA
> --
> "Yelson Hwo" <hy5005@.hotmail.com> wrote in message
> news:e0vxSWs6DHA.2524@.TK2MSFTNGP11.phx.gbl...
> alter
> in.
>
|||What did you try? Can you provide the code?
Ray Higdon MCSE, MCDBA, CCNA
--
"Yelson Hwo" <hy5005@.hotmail.com> wrote in message
news:e41mZgs6DHA.3896@.TK2MSFTNGP11.phx.gbl...
quote:

> I have try this way, it does not work.
> "Ray Higdon" <sqlhigdon@.nospam.yahoo.com> д?
> news:OJYSmbs6DHA.2732@.TK2MSFTNGP09.phx.gbl...
SQL[QUOTE]
reside[QUOTE]
>
|||Hi:
Please read this KB article and it may be useful:
http://support.microsoft.com/defaul...kb;en-us;303774
Best Wishes
Wei Ci Zhou|||I did as the below:
--
sp_dropserver 'old_name'
go
sp_addserver 'new_name', 'local'
go
--
now I restart the SQL Services, the @.@.servername change as the "new_name",
but acctually the SQL Server Name in work still is "old_name", if you try
use the "new_name" as the Server name, you can't establish a connection with
it, you can only establish a connection with the "old_name".
"Ray Higdon" <sqlhigdon@.nospam.yahoo.com>
news:uBVtRks6DHA.2576@.TK2MSFTNGP11.phx.gbl...
quote:

> What did you try? Can you provide the code?
> --
> Ray Higdon MCSE, MCDBA, CCNA
> --
> "Yelson Hwo" <hy5005@.hotmail.com> wrote in message
> news:e41mZgs6DHA.3896@.TK2MSFTNGP11.phx.gbl...
> SQL
to[QUOTE]
> reside
>
|||I didn't catch that was what you were trying to do, See if this link helps -
http://support.microsoft.com/defaul...kb;en-us;289573
Ray Higdon MCSE, MCDBA, CCNA
--
"Yelson Hwo" <hy5005@.hotmail.com> wrote in message
news:uRvPr0s6DHA.2168@.TK2MSFTNGP12.phx.gbl...
quote:

> I did as the below:
> --
> sp_dropserver 'old_name'
> go
> sp_addserver 'new_name', 'local'
> go
> --
> now I restart the SQL Services, the @.@.servername change as the "new_name",
> but acctually the SQL Server Name in work still is "old_name", if you try
> use the "new_name" as the Server name, you can't establish a connection

with
quote:

> it, you can only establish a connection with the "old_name".
> "Ray Higdon" <sqlhigdon@.nospam.yahoo.com>
> news:uBVtRks6DHA.2576@.TK2MSFTNGP11.phx.gbl...
The[QUOTE]
> to
>
|||Seems like you didn't rename the machine in Windows?
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ls
erver
"Yelson Hwo" <hy5005@.hotmail.com> wrote in message news:uRvPr0s6DHA.2168@.TK2MSFTNGP12.phx.gbl...[Q
UOTE]
> I did as the below:
> --
> sp_dropserver 'old_name'
> go
> sp_addserver 'new_name', 'local'
> go
> --
> now I restart the SQL Services, the @.@.servername change as the "new_name",
> but acctually the SQL Server Name in work still is "old_name", if you try
> use the "new_name" as the Server name, you can't establish a connection wi
th
> it, you can only establish a connection with the "old_name".
> "Ray Higdon" <sqlhigdon@.nospam.yahoo.com>
> news:uBVtRks6DHA.2576@.TK2MSFTNGP11.phx.gbl...
> to
>[/QUOTE]

Monday, March 19, 2012

How to add sp to SQL 2005 cluster?

Hey everyone,
We are running Windows 2003 and SQL 2005 in a cluster. We now need to
install a service pack for SQL 2005.
Anyone know of a step-by-step white paper on how to do it in a cluster?
TIA,
ClaytonIt is documented in this help file.
http://go.microsoft.com/fwlink/?LinkId=71757
Jason Massie
Web: http://statisticsio.com
RSS: http://statisticsio.com/Home/tabid/36/rssid/1/Default.aspx
"Clayton Sutton" <none@.none.com> wrote in message
news:Mfg3j.119679$zb2.66162@.fe02.news.easynews.com...
> Hey everyone,
> We are running Windows 2003 and SQL 2005 in a cluster. We now need to
> install a service pack for SQL 2005.
> Anyone know of a step-by-step white paper on how to do it in a cluster?
>
> TIA,
>
> Clayton
>|||Hey Jason,
Thanks for the reply.
So from reading the below link it sounds like I don't have to stop the
cluster service or anything. Just put the service pack CD in and go for it.
That's not the way it worked when I had to update Exchange 2003 to sp2. I
had to pause each node and stop the cluster service before I could install
the sp.
Clayton
"Jason Massie" <jason**R3move**@.statisticsio.com> wrote in message
news:OwO3AndMIHA.5860@.TK2MSFTNGP04.phx.gbl...
> It is documented in this help file.
> http://go.microsoft.com/fwlink/?LinkId=71757
>
> --
> Jason Massie
> Web: http://statisticsio.com
> RSS: http://statisticsio.com/Home/tabid/36/rssid/1/Default.aspx
> "Clayton Sutton" <none@.none.com> wrote in message
> news:Mfg3j.119679$zb2.66162@.fe02.news.easynews.com...
>> Hey everyone,
>> We are running Windows 2003 and SQL 2005 in a cluster. We now need to
>> install a service pack for SQL 2005.
>> Anyone know of a step-by-step white paper on how to do it in a cluster?
>>
>> TIA,
>>
>> Clayton
>|||SQL Service packs are cluster-aware for the clustered components. You run
the SP and it updates the engine components on all nodes. You have to run
it independently on each node to get the tools updated. The tools
installer/updater is not cluster-aware. SSIS is also per-node.
Note that the updater will stop and restart the SQL Server during the update
process. You should consider the SQL Server offline during the upgrade
process.
--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Clayton Sutton" <none@.none.com> wrote in message
news:OUj3j.147664$Eg2.49227@.fe06.news.easynews.com...
> Hey Jason,
> Thanks for the reply.
> So from reading the below link it sounds like I don't have to stop the
> cluster service or anything. Just put the service pack CD in and go for
> it.
> That's not the way it worked when I had to update Exchange 2003 to sp2. I
> had to pause each node and stop the cluster service before I could install
> the sp.
>
> Clayton
>
> "Jason Massie" <jason**R3move**@.statisticsio.com> wrote in message
> news:OwO3AndMIHA.5860@.TK2MSFTNGP04.phx.gbl...
>> It is documented in this help file.
>> http://go.microsoft.com/fwlink/?LinkId=71757
>>
>> --
>> Jason Massie
>> Web: http://statisticsio.com
>> RSS: http://statisticsio.com/Home/tabid/36/rssid/1/Default.aspx
>> "Clayton Sutton" <none@.none.com> wrote in message
>> news:Mfg3j.119679$zb2.66162@.fe02.news.easynews.com...
>> Hey everyone,
>> We are running Windows 2003 and SQL 2005 in a cluster. We now need to
>> install a service pack for SQL 2005.
>> Anyone know of a step-by-step white paper on how to do it in a cluster?
>>
>> TIA,
>>
>> Clayton
>>
>|||Thanks everyone for the info.!
Clayton
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:OP89X6gMIHA.4880@.TK2MSFTNGP03.phx.gbl...
> SQL Service packs are cluster-aware for the clustered components. You run
> the SP and it updates the engine components on all nodes. You have to run
> it independently on each node to get the tools updated. The tools
> installer/updater is not cluster-aware. SSIS is also per-node.
> Note that the updater will stop and restart the SQL Server during the
> update process. You should consider the SQL Server offline during the
> upgrade process.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
>
> "Clayton Sutton" <none@.none.com> wrote in message
> news:OUj3j.147664$Eg2.49227@.fe06.news.easynews.com...
>> Hey Jason,
>> Thanks for the reply.
>> So from reading the below link it sounds like I don't have to stop the
>> cluster service or anything. Just put the service pack CD in and go for
>> it.
>> That's not the way it worked when I had to update Exchange 2003 to sp2.
>> I had to pause each node and stop the cluster service before I could
>> install the sp.
>>
>> Clayton
>>
>> "Jason Massie" <jason**R3move**@.statisticsio.com> wrote in message
>> news:OwO3AndMIHA.5860@.TK2MSFTNGP04.phx.gbl...
>> It is documented in this help file.
>> http://go.microsoft.com/fwlink/?LinkId=71757
>>
>> --
>> Jason Massie
>> Web: http://statisticsio.com
>> RSS: http://statisticsio.com/Home/tabid/36/rssid/1/Default.aspx
>> "Clayton Sutton" <none@.none.com> wrote in message
>> news:Mfg3j.119679$zb2.66162@.fe02.news.easynews.com...
>> Hey everyone,
>> We are running Windows 2003 and SQL 2005 in a cluster. We now need to
>> install a service pack for SQL 2005.
>> Anyone know of a step-by-step white paper on how to do it in a cluster?
>>
>> TIA,
>>
>> Clayton
>>
>>
>|||go Microsft or the microft developer blogs and you'll find plenty
--
Sincerely,
John K
Knowledgy Consulting
http://knowledgy.org/
Atlanta's Business Intelligence and Data Warehouse Experts
"Clayton Sutton" <none@.none.com> wrote in message
news:Mfg3j.119679$zb2.66162@.fe02.news.easynews.com...
> Hey everyone,
> We are running Windows 2003 and SQL 2005 in a cluster. We now need to
> install a service pack for SQL 2005.
> Anyone know of a step-by-step white paper on how to do it in a cluster?
>
> TIA,
>
> Clayton
>|||Not really that different from applying the service pack on a standalone. You
can just run the SP executable. The setup is cluster aware so it'll figure
out the nodes where the files need to be applied.
Linchi
"Knowledgy" wrote:
> go Microsft or the microft developer blogs and you'll find plenty
> --
> Sincerely,
> John K
> Knowledgy Consulting
> http://knowledgy.org/
> Atlanta's Business Intelligence and Data Warehouse Experts
>
> "Clayton Sutton" <none@.none.com> wrote in message
> news:Mfg3j.119679$zb2.66162@.fe02.news.easynews.com...
> > Hey everyone,
> >
> > We are running Windows 2003 and SQL 2005 in a cluster. We now need to
> > install a service pack for SQL 2005.
> >
> > Anyone know of a step-by-step white paper on how to do it in a cluster?
> >
> >
> > TIA,
> >
> >
> > Clayton
> >
>
>

Friday, March 9, 2012

How to add Full Text Search to SQL2005

Hi,
We have a server with SQL2005 Standard Edition installed. We did not install
Full Text Search and want to add it to the existing default instance. The
attempt to install it says it is already installed when we know that it is
not. Is this a known bug?
Thanks
ChrisSeems you have to give the actual instance name, MSSQL for the default,
before the install will happen.
Chris
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:%23TtGy7FIGHA.3000@.TK2MSFTNGP14.phx.gbl...
> Hi,
> We have a server with SQL2005 Standard Edition installed. We did not
> install Full Text Search and want to add it to the existing default
> instance. The attempt to install it says it is already installed when we
> know that it is not. Is this a known bug?
> Thanks
> Chris
>

How to Add Columns and Use Them at Run Time using VB 2005

In order to allow my customers to use their existing data and install updated application, I want to be able to add columns to existing CE tables at startup time, and allow the user to enter data into the new column(s) immediately. I used the ALTER TABLE command as shown in the example below:

cmd.CommandText = "ALTER TABLE tblStores ADD dtDemoDate datetime, dtDemoMode int"

cmdexe = cmd.ExecuteNonQuery()

To add the column, But this does not set the columns in the attached dataset. The program sees the columns and data is able to be added, but is not then in the underlying table? What else do I need to do?

Thank you - b2bMan

You must update the dataset to fit the new schema. Distribute an application update together with the code to update the schema.

Wednesday, March 7, 2012

How to add a new .mdf with ONLY sql authentication in SQL Express?

Hi all.

I am going around in circles all day on this.

I have a clean new install of win XP SP2, VS 2005 Pro RTM,
and a NAMED instance of Sql Express with mixed authentication mode specified at setup.
The sa pw is 123456

I would have liked just SQL authentication but no such option.

I am trying to add a new mdf file. If I just use the "Add New Item" in VS web app project it just adds a new .mdf file with windows authentication tied to the current profile I am logged in the os with. I am trying to avoid that as this projects is to be zipped and downloaded as a sample app. I am also trying to avoid embedding an instance of SSE as the recipients of the zip file already have SSE running iwth thei VS IDE.

So most logical is to create the file with SQL authentication.
I have to do it by the Add Connection GUI

and for data source: "Microsoft SQL Server Database File (SqlClient) "

for data file name: C:\WebSites\Website1\App_Data\MyDatabase1.mdf (not yet existing file)

Use SQl server authentication:

user: sa, password: 123456 (the ones specified at set up of the SSE)

I keep getting

Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection.

I keep getting the same error no matter what username I use or password, the current login, etc. It just does not let me use sql authentication.

Please help anyone. This is a nightmare.

"Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection."

This seems that you didn′t activate Mmixed Authentication, its an error you are getting if you only specified the Windows Authentication. Try setting the authentication mode for the express instance:

<snip>
Another way to change the security mode after installation is to stop
SQL Server and set the appropriate registry key for your installation:

Default instance:
HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode

Named instance:
HKLM\Software\Microsoft\Microsoft SQL Server\Instance
Name\MSSQLServer\LoginMode

to 2 for mixed-mode or 1 for integrated. (Integrated is the default
setup for the SQL Server 2000 Data Engine.)
</snip>

HTH, Jens Suessmeyer.

|||

Thanks Jens,

1. I made sure during the install I selected mixed mode.

2. This article essentially says the same. However, I cannot find in the registry any "LoginMode" subkey for either the default SQLEXPRESS, or MySSE named instance.

Actually I did a complete search and there is no Key, Value or Data that contains "LoginMode" in the whole registry.

|||

You can interrogate the database engine with the CTP SQL Express Mamnagement Suite downloadable from Microsoft.

Click select the database engine..... right click and select export

You'll get a file like this:

<?xml version="1.0" encoding="utf-8"?>
<Export serverType="8c91a03d-f9b4-46c0-a305-b5dcc79ff907">
<ServerType id="8c91a03d-f9b4-46c0-a305-b5dcc79ff907" name="Database Engine">
<Server name="Shhhh\sqlexpress" description="Local instance - 'bliss\sqlexpress'">
<ConnectionInformation>
<ServerType>8c91a03d-f9b4-46c0-a305-b5dcc79ff907</ServerType>
<ServerName>Shhhh\sqlexpress</ServerName>
<AuthenticationType>0</AuthenticationType>
<UserName />
<Password />
<AdvancedOptions />
</ConnectionInformation>
</Server>
</ServerType>
</Export>

You'll see that ny authentication type is 0 which is windows authentification.

I ust went through this and there is a way to attach this programattically.

Use the Sql Management Classes in your code....

Create an XP UserGroup and user using the SMO classes. Then create the same user group in and user in the database and Attach it. It never fails and yes... I know how frustrating this is. I lost a lost of sleep over this this weekend.

Check out the thread in the first forum of this board for more information.

Renee

|||

Thanks Rene,

I learned something. I don't need the SSMSE becuase I have the full version installed too.

However I still can't fix the problem. This is what I have done so far:

I exported a .regservr and the xml looks just like you show. authetication 0. So I went back and looked in the registry again. I found a LoginMode subkey but in a different key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.4\MSSQLServer

It didn't quite make sense, because I am trying to change a NAMED instance. As expected it did not work. The exported .regsrvr still shows the same authentication mode 0.

I am scared to start adding registry keys that do not even exist.

The nightmare continues.


|||

Carl,

You are doing this programmatically?

|||

I meant to ask you about a link to the thread you mentioned.

What do you mean programmatically?

Create a c# app that could access and modify these registry keys in code? in which case NO.|||

Not true.... I spent the weekend working on this and a friend really helped my understand. You can do excellent work with SSE.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=223272&SiteID=1&PageID=0

post an email adress and I will send you the solution.

|||

http://msdn2.microsoft.com/microsoft.sqlserver.management.smo.server.attachdatabase.aspx

http://msdn2.microsoft.com/ms160723.aspx

|||

oh yeah. . . you can't do SQL authentication only.

its either windows or mixed mode