显示标签为“installing”的博文。显示所有博文
显示标签为“installing”的博文。显示所有博文

2012年3月27日星期二

Anyone recently installed SQL Server 2000 Eval version

Hello,

I am having trouble installing Evaluation copy of SQL Server on my
notebook, which has XP, P4 processor,1G Ram, and 14 G harddisk space.

After I run the Setup.exe, I get the files files extracted in the
SQLEVAL directory.

As per the instruction, I need to run Autorun.exe file. For some
reason, when I try to run this file, a new windows pops up, which is
blank black screen with cursor flying around in the window. The title
of the window is
C:\windows\system32\wowexec.exe

This is how far I have reached while trying to install the database. I
would really appreciate if someone could provide some suggestions.

VS"TinTin" <lalalulu24@.yahoo.com> wrote in message
news:2d5425d1.0404021102.1ac7269f@.posting.google.c om...
> Hello,
> I am having trouble installing Evaluation copy of SQL Server on my
> notebook, which has XP, P4 processor,1G Ram, and 14 G harddisk space.
> After I run the Setup.exe, I get the files files extracted in the
> SQLEVAL directory.
> As per the instruction, I need to run Autorun.exe file. For some
> reason, when I try to run this file, a new windows pops up, which is
> blank black screen with cursor flying around in the window. The title
> of the window is
> C:\windows\system32\wowexec.exe
> This is how far I have reached while trying to install the database. I
> would really appreciate if someone could provide some suggestions.
> VS

I have no idea what the problem is, but perhaps you could try running the
setup program directly - I think it's called setupsql.exe, in the \setup
folder (from memory).

Simon|||> I
> would really appreciate if someone could provide some suggestions.

http://otn.oracle.com/software/prod...e10g/index.html :-)

2012年2月25日星期六

Any issues with 2005 SP1?

Does anyone know of any major, or indeed minor, issues with installing SP1
for SQL 2005?
Michael MacGregor
Database ArchitectThere were some installation issues.
http://www.google.com/search?source...k+1+ssis+failed
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Michael MacGregor" <nospam@.nospam.com> wrote in message
news:e4KLsm10GHA.3900@.TK2MSFTNGP05.phx.gbl...
> Does anyone know of any major, or indeed minor, issues with installing SP1
> for SQL 2005?
> Michael MacGregor
> Database Architect
>|||If I remember correctly there was something about SSIS not starting
after applying SP1
http://connect.microsoft.com/SQLSer...=12530
6
and this one
SP1 breaks SSIS Packages with date variables due to dates being now
interpreted as mmddyyyy rather than ddmmyyyy
http://connect.microsoft.com/SQLSer...=12467
5
Denis the SQL Menace
http://sqlservercode.blogspot.com/
Michael MacGregor wrote:
> Does anyone know of any major, or indeed minor, issues with installing SP1
> for SQL 2005?
> Michael MacGregor
> Database Architect|||Michael,
Is this on a cluster or standalone server?
Chris
"Michael MacGregor" <nospam@.nospam.com> wrote in message
news:e4KLsm10GHA.3900@.TK2MSFTNGP05.phx.gbl...
> Does anyone know of any major, or indeed minor, issues with installing SP1
> for SQL 2005?
> Michael MacGregor
> Database Architect
>|||The production machine is a cluster, but we have other servers that are not.
Michael MacGregor
Database Architect
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:O3Ay$d20GHA.4044@.TK2MSFTNGP04.phx.gbl...
> Michael,
> Is this on a cluster or standalone server?
> Chris
> "Michael MacGregor" <nospam@.nospam.com> wrote in message
> news:e4KLsm10GHA.3900@.TK2MSFTNGP05.phx.gbl...
>

Any issues with 2005 SP1?

Does anyone know of any major, or indeed minor, issues with installing SP1
for SQL 2005?
Michael MacGregor
Database ArchitectThere were some installation issues.
http://www.google.com/search?sourceid=navclient&ie=UTF-8&rls=GGLG,GGLG:2006-07,GGLG:en&q=sql+service+pack+1+ssis+failed
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Michael MacGregor" <nospam@.nospam.com> wrote in message
news:e4KLsm10GHA.3900@.TK2MSFTNGP05.phx.gbl...
> Does anyone know of any major, or indeed minor, issues with installing SP1
> for SQL 2005?
> Michael MacGregor
> Database Architect
>|||If I remember correctly there was something about SSIS not starting
after applying SP1
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=125306
and this one
SP1 breaks SSIS Packages with date variables due to dates being now
interpreted as mmddyyyy rather than ddmmyyyy
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124675
Denis the SQL Menace
http://sqlservercode.blogspot.com/
Michael MacGregor wrote:
> Does anyone know of any major, or indeed minor, issues with installing SP1
> for SQL 2005?
> Michael MacGregor
> Database Architect|||Michael,
Is this on a cluster or standalone server?
Chris
"Michael MacGregor" <nospam@.nospam.com> wrote in message
news:e4KLsm10GHA.3900@.TK2MSFTNGP05.phx.gbl...
> Does anyone know of any major, or indeed minor, issues with installing SP1
> for SQL 2005?
> Michael MacGregor
> Database Architect
>|||The production machine is a cluster, but we have other servers that are not.
Michael MacGregor
Database Architect
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:O3Ay$d20GHA.4044@.TK2MSFTNGP04.phx.gbl...
> Michael,
> Is this on a cluster or standalone server?
> Chris
> "Michael MacGregor" <nospam@.nospam.com> wrote in message
> news:e4KLsm10GHA.3900@.TK2MSFTNGP05.phx.gbl...
>> Does anyone know of any major, or indeed minor, issues with installing
>> SP1 for SQL 2005?
>> Michael MacGregor
>> Database Architect
>

2012年2月23日星期四

Any issues with 2005 SP1?

Does anyone know of any major, or indeed minor, issues with installing SP1
for SQL 2005?
Michael MacGregor
Database ArchitectThere were some installation issues.
http://www.google.com/search?sourceid=navclient&ie=UTF-8&rls=GGLG,GGLG:2006-07,GGLG:en&q=sql+service+pack+1+ssis+failed
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Michael MacGregor" <nospam@.nospam.com> wrote in message
news:e4KLsm10GHA.3900@.TK2MSFTNGP05.phx.gbl...
> Does anyone know of any major, or indeed minor, issues with installing SP1
> for SQL 2005?
> Michael MacGregor
> Database Architect
>|||If I remember correctly there was something about SSIS not starting
after applying SP1
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=125306
and this one
SP1 breaks SSIS Packages with date variables due to dates being now
interpreted as mmddyyyy rather than ddmmyyyy
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124675
Denis the SQL Menace
http://sqlservercode.blogspot.com/
Michael MacGregor wrote:
> Does anyone know of any major, or indeed minor, issues with installing SP1
> for SQL 2005?
> Michael MacGregor
> Database Architect|||Michael,
Is this on a cluster or standalone server?
Chris
"Michael MacGregor" <nospam@.nospam.com> wrote in message
news:e4KLsm10GHA.3900@.TK2MSFTNGP05.phx.gbl...
> Does anyone know of any major, or indeed minor, issues with installing SP1
> for SQL 2005?
> Michael MacGregor
> Database Architect
>|||The production machine is a cluster, but we have other servers that are not.
Michael MacGregor
Database Architect
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:O3Ay$d20GHA.4044@.TK2MSFTNGP04.phx.gbl...
> Michael,
> Is this on a cluster or standalone server?
> Chris
> "Michael MacGregor" <nospam@.nospam.com> wrote in message
> news:e4KLsm10GHA.3900@.TK2MSFTNGP05.phx.gbl...
>> Does anyone know of any major, or indeed minor, issues with installing
>> SP1 for SQL 2005?
>> Michael MacGregor
>> Database Architect
>

any installation no-no's?

We are installing MS Win Server 2003 and my old version (7?) of MSDE is not
supported. So I will download MSDE 2000 and install it. I do not have a lot
of experience installing MSDE. I installed it a few times years ago and, with
a few exceptions, it has run just fine since then.
I vaguely remember that I used all the installation defaults with MSDE. That
led to a problem whenever the administrator, or whoever the user was when it
was installed, changed thier password, the connection to the database no
longer worked.
Can anyone suggest a source of information that might be useful to me to
read before I install MSDE 2000?
Thanks for your help, John Brown
John Brown
hi John,
John Brown wrote:
> We are installing MS Win Server 2003 and my old version (7?) of MSDE
> is not supported. So I will download MSDE 2000 and install it. I do
> not have a lot of experience installing MSDE. I installed it a few
> times years ago and, with a few exceptions, it has run just fine
> since then.
> I vaguely remember that I used all the installation defaults with
> MSDE. That led to a problem whenever the administrator, or whoever
> the user was when it was installed, changed thier password, the
> connection to the database no longer worked.
> Can anyone suggest a source of information that might be useful to me
> to read before I install MSDE 2000?
> Thanks for your help, John Brown
modifying the "sa" password was a problem for MSDE 1.0 relating to Windows
account running the SQL Server Agent, but this does not apply to MSDE
2000... and there are not other problems I'm aware of.. but, of course, you
should have a look at the readme file bundled with the installation
package...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

2012年2月13日星期一

Any compatibility issues between SQL 2005 Express and SQL 2005 Server

Hi All,

The IP company that host my site is installing SQL 2005 soon and I my building a web application with SQL 2005 Express. So the question is has anyone heard of any problems with uploading an 2005 express onto a sql 2005 server? I would like to find out now before I finish all of the work. Don't want to find out later that you can't run a sql 2005 express database on a sql 2005 server.

Thanks for taking the time to read this.

Well it seem no one know the answer so I emailed the author of a book called Beginning SQL Server 2005 Express. He emailed me back

SQL Server 2005 Express uses .mdf and .ldf file formats that are compatible with SQL Server 2005. Therefore, if you can upload the .mdf and .ldf files for your SQL Server Express database, you or your isp should be able to attach the files to their SQL Server 2005 database server.

I hope this reply helps.

Rick Dobson

So yes you should beable to upload 2005 express onto a SQL Server 2005.

Thanks away guys

Have a good day

Freon22