INSTALLING SQL SERVER 2005 WITH VISTA BUSINESS

I have been trying to install SQL Server 2005 (Developer Edition) on a computer with Vista Business. I can't seem to be able to install SQL Server 2005 SP2 and when I attempt to login, I get the message.

Cannot connect to Server.

the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - A connection attemp failed because the connected party dd not properly respond after a period of time, or established connection failed because connect host has failed to respond) Microsoftw SQL Server Errore 10060

Is the service running ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Yes, I finally got SQL Server 2005 Developer Edition working on Vista Business. I could not find the resolution to this issue anywhere. After losing 5 days of work I decided to break down and pay the $245 charge for a Microsoft Support call. I was put on hold for over an hour to try to speak to someone in India. For $245 I would like to talk with an American. I finally decided to hang up before the support person picked up. I was sooooooooooooo frustrated.

The way I see it the default installation on the Developer Edition would never work. Unlike previous versions of SQL Server that were very easy to install. This was a mess. I am very disappointed in SQL Server 20005 Developer Edition to date.

I would be happy to share my resolution with another user and with Microsoft for $245.00.

|||

So the issue finally got resolved ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

Installing SQL Server 2005 Standard on 2nd HD

I have a computer with a 40GB HD as the original and added a 2nd 200GB later (formatted with 2 partitions, 160GB and 40GB).

Before I added the 2nd HD, I installed SQL Server 2000 Developer on my machine.
I also have VS 2003 Pro and VS 2005 Standard installed (most files are on the 2nd HD) along with SQL Server 2005 Express.

When trying to install SQL Server 2005 Standard it would not let me change the location of the install to be on my E: drive. I am trying to do the setup on the 2nd HD to keep approximately 25% of the original (C:) drive free.

Do I need to uninstall the previous versions of SQL Server in order to change the install location? If so, what is the best order for the uninstalls (I am assuming SQL Server 2005 EXP first then SQL Server 2000)

Thanks in advance for any reply

You can change the location for some things, but not the entire installation. For instance, the management tools require ~1.6GB on your system drive for installation of shared components.

jeff.

|||Hi,
I also came across this problem with sql server swamping up lots of space on c:, it's very annoying.
Does anyone know of any workaround to be able to install all of sql server on a alternate drive?

cheers,
Johan
|||

Hi Johan,

It's impossible to put all of SQL Server 2005 on an alternate drive, but after uninstalling SQL 2000 from my C: drive I was able to put a lot of the files on my E: drive

That saved a good deal of space from my boot drive.

Hope this helps.

Mike

|||Hi,
Thanks for the answer. Then I guess I will have to find some other ways to free up space on the c-drive.

Cheers,
Johan

Installing SQL Server 2005 Standard on 2nd HD

I have a computer with a 40GB HD as the original and added a 2nd 200GB later (formatted with 2 partitions, 160GB and 40GB).

Before I added the 2nd HD, I installed SQL Server 2000 Developer on my machine.
I also have VS 2003 Pro and VS 2005 Standard installed (most files are on the 2nd HD) along with SQL Server 2005 Express.

When trying to install SQL Server 2005 Standard it would not let me change the location of the install to be on my E: drive. I am trying to do the setup on the 2nd HD to keep approximately 25% of the original (C:) drive free.

Do I need to uninstall the previous versions of SQL Server in order to change the install location? If so, what is the best order for the uninstalls (I am assuming SQL Server 2005 EXP first then SQL Server 2000)

Thanks in advance for any reply

You can change the location for some things, but not the entire installation. For instance, the management tools require ~1.6GB on your system drive for installation of shared components.

jeff.

|||Hi,
I also came across this problem with sql server swamping up lots of space on c:, it's very annoying.
Does anyone know of any workaround to be able to install all of sql server on a alternate drive?

cheers,
Johan
|||

Hi Johan,

It's impossible to put all of SQL Server 2005 on an alternate drive, but after uninstalling SQL 2000 from my C: drive I was able to put a lot of the files on my E: drive

That saved a good deal of space from my boot drive.

Hope this helps.

Mike

|||Hi,
Thanks for the answer. Then I guess I will have to find some other ways to free up space on the c-drive.

Cheers,
Johan

Installing SQL Server 2005 Reporting Services

Dear All,

I've installed SQL Server 2005 Management Studio Express on my computer from

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

Now, I would like to get SQL Server 2005 Reporting Services and Business Intelligence Developer Studio.

Can I go ahead and install "SQL Server 2005 Express Edition with Advanced Services" provided on the above link?

My question is, "SQL Server 2005 Express Edition with Advanced Services" comes with SQL Server 2005 Management Studio Express that I already have on my computer. When I install "SQL Server 2005 Express Edition with Advanced Services" , does it impact SQL Server 2005 Management Studio Express that I already have on my computer?

Do I have to uninstall Server 2005 Management Studio Express and

then...install "SQL Server 2005 Express Edition with Advanced Services" ?

Please suggest. Thank you

You are in the wrong forum. Please head over to the SQL Server Reporting Services forum for more assistance.|||This thread started in SSIS forum...moved to SSRS.|||You should be able to install "SQL Server 2005 Express Edition with Advanced Services SP1" and "SQL Server 2005 Express Edition Toolkit SP1" right over the top of whatever you got with VS Express. I'm pretty sure the setup programs will just skip over Management Studio Express if it's already on the box.sql

Integrated Security with local SQL & IIS

I have SQL RS running on a Win 2K (dev only) machine with IIS on the same local machine. I am trying to access the reports from another computer, but am getting an error

An error has occurred during report processing. (rsProcessingAborted) Get Online Help

Cannot create a connection to data source '<Shared Data Source Name>'. (rsErrorOpeningConnection) Get Online Help

Login failed for user '<DOMAINNAME>\Guest'.

IIS and the Datasource are setup for integrated security and the Datasource is aimed at the local SQL DB. Anonymous access is turned off in IIS and it prompts for the login info when trying to access it via the web. My understanding is that this should work without problems due to IIS & SQL being on the same machine, but I can't seem to get it to work. Is there a doc somewhere or anything that goes thru the settings so I can see what I'm missing? Or does anyone have any ideas?

Thanks.

Does it work if you access the reports locally? How about using stored windows credentials for hte data source instead of integrated security?|||

Yes, the reports work fine locally. I just can't access them from another machine. I need to use integrated security due to needing the windows login to lookup the correct info in the report and to know the type of user (admin, basic, etc).

Thanks for your help.

|||

Probably a kerberos configuration issue. Try forcing NTLM. See the workaround in http://support.microsoft.com/default.aspx?scid=kb;en-us;871179

Integrated Security to RS and SSAS not working

Hi,
Here's my setup:
1. ReportServer website is setup to use Integrated Authentication
2. I added a new user group (in computer management) called ReportAdmins
3. I used Management Studio to connect to my Reposting Services, at the top
level, I added the user group I just created, and gave it Content Manager
permissions.
4. I added an NT user to the group - ReportAdmins.
5. My datasources is an Analysis Services database, and is setup to use
Integrated Security. So I added the NT User to the OLAP Administrators group
as well. (Analysis Services and Reporting Services are all on the same
machine, running under the same service account that is an admin on the box)
Now I go to another machine, login with the NT User I specified above,
launch IE and the when I request the report I get an rsErrorExecutingCommand
- Query execution failed for data set 'abc'
What am I missing? I'ev searched other posts and I seem to have setup all
suggested access relevant to my situation, but somehow the reports aren't
working. If I make this NT USer the machine admin on the box hosting
ReportingServices, ANalysis Services etc, everything works fine (so at least
I know the reports work OK).
Any help is greatly appreciated.
Thanks.does the report works fine if you use the basic authentication instead-of
NTLM?
have you created a role in AS associated to the user group?
"Raghu" <Raghu@.discussions.microsoft.com> wrote in message
news:200FCBCA-570B-4AA1-AEB3-6321729D345D@.microsoft.com...
> Hi,
> Here's my setup:
> 1. ReportServer website is setup to use Integrated Authentication
> 2. I added a new user group (in computer management) called ReportAdmins
> 3. I used Management Studio to connect to my Reposting Services, at the
> top
> level, I added the user group I just created, and gave it Content Manager
> permissions.
> 4. I added an NT user to the group - ReportAdmins.
> 5. My datasources is an Analysis Services database, and is setup to use
> Integrated Security. So I added the NT User to the OLAP Administrators
> group
> as well. (Analysis Services and Reporting Services are all on the same
> machine, running under the same service account that is an admin on the
> box)
> Now I go to another machine, login with the NT User I specified above,
> launch IE and the when I request the report I get an
> rsErrorExecutingCommand
> - Query execution failed for data set 'abc'
> What am I missing? I'ev searched other posts and I seem to have setup all
> suggested access relevant to my situation, but somehow the reports aren't
> working. If I make this NT USer the machine admin on the box hosting
> ReportingServices, ANalysis Services etc, everything works fine (so at
> least
> I know the reports work OK).
> Any help is greatly appreciated.
> Thanks.|||Thank you for your response.
1. Basic Authentication cannot be used for the data source because AS
requires integrated authentication and if I specify basic authentication,
then I cannot use an NT account to connect to AS.
2. The role in AS for the user group is not necessary as the NTUsers in
that group are OLAP admins (in my test case below. I have only one NTUser and
he is an OLAP admin).
BTW, sorry for not mentioning this earlier - I am using RS2005 and SSAS2005.
"Jéjé" wrote:
> does the report works fine if you use the basic authentication instead-of
> NTLM?
> have you created a role in AS associated to the user group?
> "Raghu" <Raghu@.discussions.microsoft.com> wrote in message
> news:200FCBCA-570B-4AA1-AEB3-6321729D345D@.microsoft.com...
> > Hi,
> >
> > Here's my setup:
> > 1. ReportServer website is setup to use Integrated Authentication
> > 2. I added a new user group (in computer management) called ReportAdmins
> > 3. I used Management Studio to connect to my Reposting Services, at the
> > top
> > level, I added the user group I just created, and gave it Content Manager
> > permissions.
> > 4. I added an NT user to the group - ReportAdmins.
> > 5. My datasources is an Analysis Services database, and is setup to use
> > Integrated Security. So I added the NT User to the OLAP Administrators
> > group
> > as well. (Analysis Services and Reporting Services are all on the same
> > machine, running under the same service account that is an admin on the
> > box)
> >
> > Now I go to another machine, login with the NT User I specified above,
> > launch IE and the when I request the report I get an
> > rsErrorExecutingCommand
> > - Query execution failed for data set 'abc'
> >
> > What am I missing? I'ev searched other posts and I seem to have setup all
> > suggested access relevant to my situation, but somehow the reports aren't
> > working. If I make this NT USer the machine admin on the box hosting
> > ReportingServices, ANalysis Services etc, everything works fine (so at
> > least
> > I know the reports work OK).
> >
> > Any help is greatly appreciated.
> >
> > Thanks.
>
>|||Sorry, I misread the 'Basic Authentication' test to mean simple userid
password in RS data source setup. I was playing with IIS setup again and
found that there is a 'Basic Authentication' checkbox for security as well.
I tried the Basic Authentication and it prompts for userid and password. If
I provide the NT UserID and password that is the admin on the ReportServer
and AServer box, everything works fine, but if I use the regular user that I
added to the 'ReportUser' group, it doesn't work.
"Raghu" wrote:
> Thank you for your response.
> 1. Basic Authentication cannot be used for the data source because AS
> requires integrated authentication and if I specify basic authentication,
> then I cannot use an NT account to connect to AS.
> 2. The role in AS for the user group is not necessary as the NTUsers in
> that group are OLAP admins (in my test case below. I have only one NTUser and
> he is an OLAP admin).
> BTW, sorry for not mentioning this earlier - I am using RS2005 and SSAS2005.
> "Jéjé" wrote:
> > does the report works fine if you use the basic authentication instead-of
> > NTLM?
> > have you created a role in AS associated to the user group?
> >
> > "Raghu" <Raghu@.discussions.microsoft.com> wrote in message
> > news:200FCBCA-570B-4AA1-AEB3-6321729D345D@.microsoft.com...
> > > Hi,
> > >
> > > Here's my setup:
> > > 1. ReportServer website is setup to use Integrated Authentication
> > > 2. I added a new user group (in computer management) called ReportAdmins
> > > 3. I used Management Studio to connect to my Reposting Services, at the
> > > top
> > > level, I added the user group I just created, and gave it Content Manager
> > > permissions.
> > > 4. I added an NT user to the group - ReportAdmins.
> > > 5. My datasources is an Analysis Services database, and is setup to use
> > > Integrated Security. So I added the NT User to the OLAP Administrators
> > > group
> > > as well. (Analysis Services and Reporting Services are all on the same
> > > machine, running under the same service account that is an admin on the
> > > box)
> > >
> > > Now I go to another machine, login with the NT User I specified above,
> > > launch IE and the when I request the report I get an
> > > rsErrorExecutingCommand
> > > - Query execution failed for data set 'abc'
> > >
> > > What am I missing? I'ev searched other posts and I seem to have setup all
> > > suggested access relevant to my situation, but somehow the reports aren't
> > > working. If I make this NT USer the machine admin on the box hosting
> > > ReportingServices, ANalysis Services etc, everything works fine (so at
> > > least
> > > I know the reports work OK).
> > >
> > > Any help is greatly appreciated.
> > >
> > > Thanks.
> >
> >
> >|||I think the security is not correctly setup on the server
the reportuser group has not enough authorization on the server.
the error message will display where.
remember that AS2005 is more secure then AS2000, so you must authorize this
group to access the cubes through a role.
"Raghu" <Raghu@.discussions.microsoft.com> wrote in message
news:2DD1B7A0-764E-405B-A247-DDC5C26A4532@.microsoft.com...
> Sorry, I misread the 'Basic Authentication' test to mean simple userid
> password in RS data source setup. I was playing with IIS setup again and
> found that there is a 'Basic Authentication' checkbox for security as
> well.
> I tried the Basic Authentication and it prompts for userid and password.
> If
> I provide the NT UserID and password that is the admin on the ReportServer
> and AServer box, everything works fine, but if I use the regular user
> that I
> added to the 'ReportUser' group, it doesn't work.
> "Raghu" wrote:
>> Thank you for your response.
>> 1. Basic Authentication cannot be used for the data source because AS
>> requires integrated authentication and if I specify basic authentication,
>> then I cannot use an NT account to connect to AS.
>> 2. The role in AS for the user group is not necessary as the NTUsers in
>> that group are OLAP admins (in my test case below. I have only one NTUser
>> and
>> he is an OLAP admin).
>> BTW, sorry for not mentioning this earlier - I am using RS2005 and
>> SSAS2005.
>> "Jéjé" wrote:
>> > does the report works fine if you use the basic authentication
>> > instead-of
>> > NTLM?
>> > have you created a role in AS associated to the user group?
>> >
>> > "Raghu" <Raghu@.discussions.microsoft.com> wrote in message
>> > news:200FCBCA-570B-4AA1-AEB3-6321729D345D@.microsoft.com...
>> > > Hi,
>> > >
>> > > Here's my setup:
>> > > 1. ReportServer website is setup to use Integrated Authentication
>> > > 2. I added a new user group (in computer management) called
>> > > ReportAdmins
>> > > 3. I used Management Studio to connect to my Reposting Services, at
>> > > the
>> > > top
>> > > level, I added the user group I just created, and gave it Content
>> > > Manager
>> > > permissions.
>> > > 4. I added an NT user to the group - ReportAdmins.
>> > > 5. My datasources is an Analysis Services database, and is setup to
>> > > use
>> > > Integrated Security. So I added the NT User to the OLAP
>> > > Administrators
>> > > group
>> > > as well. (Analysis Services and Reporting Services are all on the
>> > > same
>> > > machine, running under the same service account that is an admin on
>> > > the
>> > > box)
>> > >
>> > > Now I go to another machine, login with the NT User I specified
>> > > above,
>> > > launch IE and the when I request the report I get an
>> > > rsErrorExecutingCommand
>> > > - Query execution failed for data set 'abc'
>> > >
>> > > What am I missing? I'ev searched other posts and I seem to have setup
>> > > all
>> > > suggested access relevant to my situation, but somehow the reports
>> > > aren't
>> > > working. If I make this NT USer the machine admin on the box hosting
>> > > ReportingServices, ANalysis Services etc, everything works fine (so
>> > > at
>> > > least
>> > > I know the reports work OK).
>> > >
>> > > Any help is greatly appreciated.
>> > >
>> > > Thanks.
>> >
>> >
>> >

Installing Sql Server

Hi,

I downloaded the Sql server 2005 express advanced and installed it in my computer. Everything went well except for a warning message that said "minimum hardware requirements not met". I have dual core pentium 4 computer with 250 G hard disk and 1gb ram.

Anyways, after installing I cannot find the real application anywhere. When I goto start, programs, sql server it only shows sql server configuration tools. I have never used sql server before and how do I start the app?

Any help will be much appreciated. Please note I already installed net framework 2 and also visual studio 2005 professional.

You need to go and download Express Advanced Services which includes SQL Server Management Studio Express, thats the main GUI for SSE.|||

Hi Euan,

Thx for yr reply. Actually I downloaded & installed the sql server with advanced options but I did not see any gui. So after posting my question on this forum I downloaded the SQL Server Management Studio Express from microsoft and installed it and now I have got what I was looking for.

What I don't understand is how come if advanced options had the gui builtin it did not work in my computer?

Fareez...

|||

Hi Fareez,

Management Studio Express is included in Express Advanced, but you have to choose to install it from the Feature Tree in the Setup UI. It sounds like you just did a default install without changing the feature set being installed.

For other who experience this, you can go back into the Express Advanced setup from Add/Remove Programs and choose to install Management Studio Express, you don't have to download it separately. Just open Add/Remove Programs, select SQL Server 2005 and click Change. Follow the prompts to modify your installation.

Regards,

Mike Wachal
SQL Express team

Installing SQL express and attaching a mdf db from the Command Prompt

Hi,

I need to install a customed SQL server express instance on the client's computer by using the Command prompt installation. I've already defined the security settings and everything i need but i was wondering if is possible to attach a mdf database during the installation. Perhaps there is a paramenter i can include in the in the ini file.

Thank you

No, you can not attach a database as part of the installation command prompt. You will need to do that from some other process, possibly in the wrapper that you're using to run the command prompt in the first place. If you're not using a language that supports connecting to SQL, you could just create a script and call that script using the SQLCmd utility, which runs from the command prompt as well.

Search BOL for information about using SQLCmd.

Mike

|||Hi,

if you embedded your installation as part of a bootstrapper you could call (as Mike said) the SQLCmd.exe utiltiy as a custom install step and use the sp_attachdb or CREATE DATABSE for attaching within the command like the following example: SQLCMD.exe -E -Q"sp_attach @.dbname ='SomeDbname', @.FileName1 ='C:\SomeFOlder\SomeFile.mdf', @.FileName2 ='C:\SomeFOlder\SomeFile.mdf'

Jens K. Suessmeyer.

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

Thank you for your answers.

Just one last thing: I creating two separate procedures to install and attach the database into one wrapper. Because launching a SqlCmd starts a separate sql installation. Is there a way to know when the installation is completed and how it went so the attachment process can be launched automatically?

|||

When I do the script you mention it works for some computers and for others it won't.

I found that changing the SQL Server Configuration manager(SCM) to local for those that it doesn't work is enough to make the script run. When it was setup as NTAuthority instead of local it gave a Error 5 (acces denied).

Is any command to change the Logon Mode for the SCM that I can add as part of my script?
What am I doing wrong? How to default it to be a local logon instead of NTAuthority?

Installing SQL express and attaching a mdf db from the Command Prompt

Hi,

I need to install a customed SQL server express instance on the client's computer by using the Command prompt installation. I've already defined the security settings and everything i need but i was wondering if is possible to attach a mdf database during the installation. Perhaps there is a paramenter i can include in the in the ini file.

Thank you

No, you can not attach a database as part of the installation command prompt. You will need to do that from some other process, possibly in the wrapper that you're using to run the command prompt in the first place. If you're not using a language that supports connecting to SQL, you could just create a script and call that script using the SQLCmd utility, which runs from the command prompt as well.

Search BOL for information about using SQLCmd.

Mike

|||Hi,

if you embedded your installation as part of a bootstrapper you could call (as Mike said) the SQLCmd.exe utiltiy as a custom install step and use the sp_attachdb or CREATE DATABSE for attaching within the command like the following example: SQLCMD.exe -E -Q"sp_attach @.dbname ='SomeDbname', @.FileName1 ='C:\SomeFOlder\SomeFile.mdf', @.FileName2 ='C:\SomeFOlder\SomeFile.mdf'

Jens K. Suessmeyer.

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

Thank you for your answers.

Just one last thing: I creating two separate procedures to install and attach the database into one wrapper. Because launching a SqlCmd starts a separate sql installation. Is there a way to know when the installation is completed and how it went so the attachment process can be launched automatically?

|||

When I do the script you mention it works for some computers and for others it won't.

I found that changing the SQL Server Configuration manager(SCM) to local for those that it doesn't work is enough to make the script run. When it was setup as NTAuthority instead of local it gave a Error 5 (acces denied).

Is any command to change the Logon Mode for the SCM that I can add as part of my script?
What am I doing wrong? How to default it to be a local logon instead of NTAuthority?

Installing SQL Express : File is corrupt !!!

Hello,

On my computer, XP SP2, VB 2005 Express and VisualWeb 2005 Express are installed.

SQL 2005 Server express was also automatically installed in the same time.

I want to complete this SQL SERVER EXPRESS Installation, by downloading complements;

No problem to install SQL Server Management Studio

but problem occurs :

I downloaded SQLEXPR_ADV_FRN.EXE (Version : 0.0.0.0)

When I want to install it, I have a first box Extracting Files with :

Extracting Files :setup\sqlrun_rs.msi

To Directory ;i:\8eefbf891116a71dbc7190cceb05b9

(I don’t know why it wants to install in this partition !!!!)

Then an error box :

Extraction Failed

File is corrupt

I had same issue when I tried to install SQLEXPR_TOOLKIT_FRN.EXE

Can anyone explain me how to resolve these issues ?

Regards

Mouspi

try to disable your AV software when running the setup and see what happens.

Are you able to download the ISO image and burning it to CD for example, or mounting it to a virtual CD, and installing it from that?

|||

I disabled my AV, but I got the same messages.

I didn't find the right place where i can download the ISO images for these two files.

If you know the way to reach them, it would be fine.

Regards

Mouspi

installing sql 7.0 on Win2000

Hi,
I have upgraded from sql 7.0 on my computer with windows 2000. Can I install
this on my computer?
When I install I am unable to register the server. It says server not
available. Can anybody help me?
did you hear =?Utf-8?B?cHJhc2Fk?= <prasad@.discussions.microsoft.com> say
in news:4A444A9F-E808-4126-AAA8-1BBE18B01EBF@.microsoft.com:

> Hi,
> I have upgraded from sql 7.0 on my computer with windows 2000. Can I
> install this on my computer?
> When I install I am unable to register the server. It says server not
> available. Can anybody help me?
>
I have multiple SQL 7 boxes on Win2000. What is the exact error and when is
it occuring (no such error for me)? Did you attempt to upgrade from SQL7 to
SQL 2000? I know there is a known issue with that (setup.ins a little
wobbly on the upgrade, I will try to dig out the kb article)
Neil MacMurchy
|||Have you rebooted and have you checked that the SQL Server service is
running?
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"prasad" <prasad@.discussions.microsoft.com> wrote in message
news:4A444A9F-E808-4126-AAA8-1BBE18B01EBF@.microsoft.com...
> Hi,
> I have upgraded from sql 7.0 on my computer with windows 2000. Can I
> install
> this on my computer?
> When I install I am unable to register the server. It says server not
> available. Can anybody help me?

installing sql 7.0 on Win2000

Hi,
I have upgraded from sql 7.0 on my computer with windows 2000. Can I install
this on my computer?
When I install I am unable to register the server. It says server not
available. Can anybody help me?did you hear =?Utf-8?B?cHJhc2Fk?= <prasad@.discussions.microsoft.com> say
in news:4A444A9F-E808-4126-AAA8-1BBE18B01EBF@.microsoft.com:
> Hi,
> I have upgraded from sql 7.0 on my computer with windows 2000. Can I
> install this on my computer?
> When I install I am unable to register the server. It says server not
> available. Can anybody help me?
>
I have multiple SQL 7 boxes on Win2000. What is the exact error and when is
it occuring (no such error for me)? Did you attempt to upgrade from SQL7 to
SQL 2000? I know there is a known issue with that (setup.ins a little
wobbly on the upgrade, I will try to dig out the kb article)
Neil MacMurchy|||Have you rebooted and have you checked that the SQL Server service is
running?
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"prasad" <prasad@.discussions.microsoft.com> wrote in message
news:4A444A9F-E808-4126-AAA8-1BBE18B01EBF@.microsoft.com...
> Hi,
> I have upgraded from sql 7.0 on my computer with windows 2000. Can I
> install
> this on my computer?
> When I install I am unable to register the server. It says server not
> available. Can anybody help me?

installing sql 7.0 on Win2000

Hi,
I have upgraded from sql 7.0 on my computer with windows 2000. Can I install
this on my computer?
When I install I am unable to register the server. It says server not
available. Can anybody help me?did you hear examnotes <prasad@.discussions.microsoft.com> say
in news:4A444A9F-E808-4126-AAA8-1BBE18B01EBF@.microsoft.com:

> Hi,
> I have upgraded from sql 7.0 on my computer with windows 2000. Can I
> install this on my computer?
> When I install I am unable to register the server. It says server not
> available. Can anybody help me?
>
I have multiple SQL 7 boxes on Win2000. What is the exact error and when is
it occuring (no such error for me)? Did you attempt to upgrade from SQL7 to
SQL 2000? I know there is a known issue with that (setup.ins a little
wobbly on the upgrade, I will try to dig out the kb article)
Neil MacMurchy|||Have you rebooted and have you checked that the SQL Server service is
running?
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"prasad" <prasad@.discussions.microsoft.com> wrote in message
news:4A444A9F-E808-4126-AAA8-1BBE18B01EBF@.microsoft.com...
> Hi,
> I have upgraded from sql 7.0 on my computer with windows 2000. Can I
> install
> this on my computer?
> When I install I am unable to register the server. It says server not
> available. Can anybody help me?

installing sql 7 from backoffice server 2000

Hi group.
I have on my computer installed sql server 6.5.
my computer runs windows nt 4.0.
Now am having backoffice server 2000 CDs.
I want to upgrade my sql server 6.5 to 7 only.
Pls tell me how.
I went to upgrade in the setup option of 6.5 it asked for
service park3. When i go through the readme file it says i
run service pack5.
Non of them works either way.
Pliz assist.
Thank you.Leno,
>> Pls tell me how.
See if these articles helps:
INF: Frequently Asked Questions - SQL Server 7.0 - Conversion
http://support.microsoft.com/default.aspx?scid=kb;en-us;195444
INF: Microsoft SQL Server 7.0 Preparedness Review (White Paper)
http://support.microsoft.com/default.aspx?scid=kb;en-us;323136
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Leno" <leboy@.nationalbank.co.ke> wrote in message
news:0a0201c35db4$0e1b6a40$a401280a@.phx.gbl...
> Hi group.
> I have on my computer installed sql server 6.5.
> my computer runs windows nt 4.0.
> Now am having backoffice server 2000 CDs.
> I want to upgrade my sql server 6.5 to 7 only.
> Pls tell me how.
> I went to upgrade in the setup option of 6.5 it asked for
> service park3. When i go through the readme file it says i
> run service pack5.
> Non of them works either way.
> Pliz assist.
> Thank you.