Very Computer

by **Melinda Simmon** » Sun, 12 Jan 2003 12:40:12

I am currently taking a class on SQL Server and cannot
get the software to load on my PC. I receive the
following error message when setup is almost
complete "Setup failed to configure the server.Refer to
the server error logs and sqlstp.log for more
information." Once I look at the logs I find the
following error message "Data source name not found and
no default driver specified."I cannot figure out why it
will not install. Any help would be greatly appreciated.
Thanks

Melinda

by **Kimberly L. Trip** » Sun, 12 Jan 2003 17:52:39

The only thing I can think of is that you're trying to install a server
edition of SQL Server on XP and not the developer or personal editions? What
class and what are the materials? Do you know what edition you have? (ugh -
if you ask how you can tell without it being installed? I'm sure there's a
way - ANYONE?)

hth,
kt

Quote:> I am currently taking a class on SQL Server and cannot
> get the software to load on my PC. I receive the
> following error message when setup is almost
> complete "Setup failed to configure the server.Refer to
> the server error logs and sqlstp.log for more
> information." Once I look at the logs I find the
> following error message "Data source name not found and
> no default driver specified."I cannot figure out why it
> will not install. Any help would be greatly appreciated.
> Thanks

> Melinda

by **Melinda Simmon** » Sun, 12 Jan 2003 22:36:01

I am trying to install from the developers addition. I was following
instructions from the schools website(they give you instructions on how
to install but nothing on if you have problems with installation). The
class I am taking is Database Management and we use SQL Server as our
database.From what I can tell I'm following the instructions to the
letter and it is not working.

Thanks
Melinda

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

by **Kimberly L. Trip** » Mon, 13 Jan 2003 02:39:52

Wait - you're getting a message saying that a data source name cannot be
found... This sounds like it's not SQL Server that's failing but your
"students" software.

Please try this to make sure it's not SQL Server?
go to a command prompt
at the prompt type:
net start
and press enter

See if one of the following is in the list
MSSQLServer
or MSSQL$...........

If there's nothing in the list then try this
NET START MSSQLSERVER

See what that does. If it says the service is starting then you can check
again to see if it's in the list once you're done with the net start again.

NOW - also at a command prompt execute:
osql -E

once you get the 1> type this

this should tell you what version you have.

Next - try your student install again?? Maybe it's just that the server was
not started? If that's the case you *might* want to set auto start for your
server? OR - you can always use the Service Manager to start/stop. There is
an icon in your taskbar to do this.

If SQL Server is there and it's just your class software then you'll need to
contact your instructor for more help?!

hth,
kt

Quote:
> I am trying to install from the developers addition. I was following
> instructions from the schools website(they give you instructions on how
> to install but nothing on if you have problems with installation). The
> class I am taking is Database Management and we use SQL Server as our
> database.From what I can tell I'm following the instructions to the
> letter and it is not working.

> Thanks
> Melinda

> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

by **Jasper Smit** » Mon, 13 Jan 2003 02:27:08

This sounds like an ODBC SQL driver problem
Try this http://tinyurl.com/4bz7 but since you are
on XP reinstall MDAC 2.7 not 2.6.

--
HTH

Jasper Smith (SQL Server MVP)

I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org

Quote:
> I am trying to install from the developers addition. I was following
> instructions from the schools website(they give you instructions on how
> to install but nothing on if you have problems with installation). The
> class I am taking is Database Management and we use SQL Server as our
> database.From what I can tell I'm following the instructions to the
> letter and it is not working.

> Thanks
> Melinda

> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

by **Melinda Simmon** » Mon, 13 Jan 2003 13:32:05

Kim, I tried what you said with the net start and I did
not see mssqlserver. When I tried to net start
mssqlserver it didn't do anything. I have tried
reinstalling SQL but with no luck. I am going to continue
looking online for help. I have emailed my instructor and
he is looking into as well. Hopefully I can figure what's
going on. Thank you for your help. I welcome any other
help you can give me. I am ready to pull my hair out at
this point. Thanks

Melinda

Quote:>-----Original Message-----
>Wait - you're getting a message saying that a data

source name cannot be

Quote:>found... This sounds like it's not SQL Server that's
failing but your
>"students" software.

>Please try this to make sure it's not SQL Server?
> go to a command prompt
> at the prompt type:
> net start
> and press enter

>See if one of the following is in the list
> MSSQLServer
>or MSSQL$...........

>If there's nothing in the list then try this
> NET START MSSQLSERVER

>See what that does. If it says the service is starting
then you can check
>again to see if it's in the list once you're done with

the net start again.

>NOW - also at a command prompt execute:
> osql -E

>once you get the 1> type this

>this should tell you what version you have.

>Next - try your student install again?? Maybe it's just
that the server was
>not started? If that's the case you *might* want to set
auto start for your
>server? OR - you can always use the Service Manager to

start/stop. There is

- Show quoted text -

>an icon in your taskbar to do this.

>If SQL Server is there and it's just your class software
then you'll need to
>contact your instructor for more help?!

>hth,
>kt

>> I am trying to install from the developers addition. I
was following
>> instructions from the schools website(they give you
instructions on how
>> to install but nothing on if you have problems with
installation). The
>> class I am taking is Database Management and we use
SQL Server as our
>> database.From what I can tell I'm following the
instructions to the
>> letter and it is not working.

>> Thanks
>> Melinda

>> *** Sent via Developersdex

http://www.developersdex.com ***

- Show quoted text -

Quote:>> Don't just participate in USENET...get rewarded for it!

>.

by **Melinda Simmon** » Mon, 13 Jan 2003 13:58:30

Jasper,
Thanks for your help as well. I tried the download you
suggested and it still did not work. I still cannot get
SQL to load on my PC. If you can think of anything else
let me know. I am still researching the problem. It is
driving me crazy. Thanks again

Melinda

>-----Original Message-----
>This sounds like an ODBC SQL driver problem
>Try this http://tinyurl.com/4bz7 but since you are
>on XP reinstall MDAC 2.7 not 2.6.

>--
>HTH

>Jasper Smith (SQL Server MVP)

>I support PASS - the definitive, global
>community for SQL Server professionals -
>http://www.sqlpass.org

>> I am trying to install from the developers addition. I
was following
>> instructions from the schools website(they give you
instructions on how
>> to install but nothing on if you have problems with
installation). The
>> class I am taking is Database Management and we use
SQL Server as our
>> database.From what I can tell I'm following the
instructions to the
>> letter and it is not working.

>> Thanks
>> Melinda

>> *** Sent via Developersdex

http://www.developersdex.com ***

- Show quoted text -

Quote:>> Don't just participate in USENET...get rewarded for it!

>.

Very Computer

Installing SQL Server on a XP Home Edition PC

Installing SQL Server on a XP Home Edition PC

Installing SQL Server on a XP Home Edition PC

Installing SQL Server on a XP Home Edition PC

Installing SQL Server on a XP Home Edition PC

Installing SQL Server on a XP Home Edition PC

Installing SQL Server on a XP Home Edition PC

Installing SQL Server on a XP Home Edition PC