newbie IIS & MS SQL connection problem ;-(

Have successfully installed MS SQL on my Win XP Pro machine, created tables,
and a dsn, which is working fine in Dreamweaver. So far so good.

When I run the page on IIS I get the following:-

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database
requested in login 'MenuPlanner'. Login fails.

I think it's permissions - anyone got any clues as to where to look?

TIA

GrantBuzby wrote:
> Have successfully installed MS SQL on my Win XP Pro machine, created
tables,
> and a dsn, which is working fine in Dreamweaver. So far so good.
> When I run the page on IIS I get the following:-
> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database
> requested in login 'MenuPlanner'. Login fails.
> I think it's permissions - anyone got any clues as to where to look?

You could see if the login MenuPlanner has got permissions to the
database you are logging in to. That would be a start.

--
David Rowland
For a good user and performance monitor, check DBMonitor
http://dbmonitor.tripod.com

> TIA
> Grant|||"dbmonitor" <dbmonitor_support@.hotmail.com> wrote in message
news:1107519068.678569.226760@.o13g2000cwo.googlegr oups.com...
> Buzby wrote:
>> Have successfully installed MS SQL on my Win XP Pro machine, created
> tables,
>> and a dsn, which is working fine in Dreamweaver. So far so good.
>>
>> When I run the page on IIS I get the following:-
>>
>> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
>> [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database
>> requested in login 'MenuPlanner'. Login fails.
>>
>> I think it's permissions - anyone got any clues as to where to look?
> You could see if the login MenuPlanner has got permissions to the
> database you are logging in to. That would be a start.

This is what has got me - permissions are set up. I've created a dsn, which
I can run queries in Dreamweaver and filter results just fine. I'm having
trouble when running the page on my webserver (IIS which is working fine)

Stumped ;-(|||Buzby wrote:
> "dbmonitor" <dbmonitor_support@.hotmail.com> wrote in message
> news:1107519068.678569.226760@.o13g2000cwo.googlegr oups.com...
> > Buzby wrote:
> >> Have successfully installed MS SQL on my Win XP Pro machine,
created
> > tables,
> >> and a dsn, which is working fine in Dreamweaver. So far so good.
> >>
> >> When I run the page on IIS I get the following:-
> >>
> >> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> >> [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open
database
> >> requested in login 'MenuPlanner'. Login fails.
> >>
> >> I think it's permissions - anyone got any clues as to where to
look?
> > You could see if the login MenuPlanner has got permissions to the
> > database you are logging in to. That would be a start.
> This is what has got me - permissions are set up. I've created a dsn,
which
> I can run queries in Dreamweaver and filter results just fine. I'm
having
> trouble when running the page on my webserver (IIS which is working
fine)
> Stumped ;-(

Is MenuPlanner the database name or the login name?

If it is the database name, are you connecting to the database via a
userid/password or are you connecting with Windows interactive UserID?
--
David Rowland
For a good user and performance monitor, check DBMonitor
http://dbmonitor.tripod.com|||Buzby (gb@.pumpupthe.net) writes:
> Have successfully installed MS SQL on my Win XP Pro machine, created
> tables, and a dsn, which is working fine in Dreamweaver. So far so
> good.
> When I run the page on IIS I get the following:-
> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database
> requested in login 'MenuPlanner'. Login fails.
> I think it's permissions - anyone got any clues as to where to look?

Sounds like the login has a default db which does not exist, or the login
does have access to. Use sp_helplogins to check, use sp_defaultdb to change.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||On 2/4/05 5:37 PM, in article Xns95F3F003A2514Yazorman@.127.0.0.1, "Erland
Sommarskog" <esquel@.sommarskog.se> wrote:

> Buzby (gb@.pumpupthe.net) writes:
>> Have successfully installed MS SQL on my Win XP Pro machine, created
>> tables, and a dsn, which is working fine in Dreamweaver. So far so
>> good.
>>
>> When I run the page on IIS I get the following:-
>>
>> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
>> [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database
>> requested in login 'MenuPlanner'. Login fails.
>>
>> I think it's permissions - anyone got any clues as to where to look?
> Sounds like the login has a default db which does not exist, or the login
> does have access to. Use sp_helplogins to check, use sp_defaultdb to change.

Yea, but a DSN is being used so we have to believe that MenuPlanner is the
name of the DSN Connection. I am assuming that the DSN was created on the
IIS server and connects successfully when you "test connection" in the ODBC
dialog.

I highly recommend using a DSN-less connection in your ASP pages. There is
lots of documentation on ADODB.

If you need some sample connection strings let me know.|||Gregory Dean (gdean@.datapex.com) writes:
> On 2/4/05 5:37 PM, in article Xns95F3F003A2514Yazorman@.127.0.0.1, "Erland
> Sommarskog" <esquel@.sommarskog.se> wrote:
>> Buzby (gb@.pumpupthe.net) writes:
>>> Have successfully installed MS SQL on my Win XP Pro machine, created
>>> tables, and a dsn, which is working fine in Dreamweaver. So far so
>>> good.
>>>
>>> When I run the page on IIS I get the following:-
>>>
>>> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
>>> [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database
>>> requested in login 'MenuPlanner'. Login fails.
>>>
>>> I think it's permissions - anyone got any clues as to where to look?
>>
>> Sounds like the login has a default db which does not exist, or the
>> login does have access to. Use sp_helplogins to check, use sp_defaultdb
>> to change.
> Yea, but a DSN is being used so we have to believe that MenuPlanner is
> the name of the DSN Connection. I am assuming that the DSN was created
> on the IIS server and connects successfully when you "test connection"
> in the ODBC dialog.

Not sure what you mean, but since SQL Server does not know what a DSN
is, MenuPlanner cannot be the name of the DNS. But it can be the
login name specified in the DSN.

> I highly recommend using a DSN-less connection in your ASP pages.

I echo that. DSN is a concept that I never understood the point with.
An extra layer that only causes hassle.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Thanks one and all - it turned out it was an IIS permissions issue - however
I've taken on board what you have suggested and dsn less is the way we are
going!

Cheers

Buzby

newbie can't connect

Windows XP pro, SQL Server 2000 developers edition installed on the =
client computer.
Installed SQL Server using all defaults except changed detination drive =
and folders to D:
Now the server does not run. I get the following error:
SQL Server registration failed...
SQL Server does not exist or access denied.
I'm trying to use "Windows authentication", which I assume means that =
when I log onto my Windows computer that that's the only login =
information that SQL server needs (that's how it seemed to work on my =
notebook).
What do I start to look for to solve this problem?
TIA.Is the SQL Service actually running ? If you run the following from the
command line does it connect
osql -S(local) -E
This assumes you installed a default instance. You can check this by running
Start>Run services.msc
Check for services starting with MSSQL. If you have one called MSSQLServer
then you have a default instance, if the service has a dollar ($) sign in it
e.g. MSSQL$INST01 then you have a named instance and connect like so
osql -S(local)\INST01 -E
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Karl" <kthompson@.pine-grove.com.nospam> wrote in message
news:eER5eb5$DHA.1036@.TK2MSFTNGP10.phx.gbl...
Windows XP pro, SQL Server 2000 developers edition installed on the client
computer.
Installed SQL Server using all defaults except changed detination drive and
folders to D:
Now the server does not run. I get the following error:
SQL Server registration failed...
SQL Server does not exist or access denied.
I'm trying to use "Windows authentication", which I assume means that when I
log onto my Windows computer that that's the only login information that SQL
server needs (that's how it seemed to work on my notebook).
What do I start to look for to solve this problem?
TIA.

Newbie - sa password error after ACT! install - Need pro's help!!!

Hello,
I am admittedly new to this, especially sql server and am in need of a pro's assistance.. I installed Microsoft Small Business accounting, which in turn installed and configured a sql server. When I installed ACT! 2005 (v7.0) and tried to create a database, it states that it cannot find the master file.... so I tried to install sql server from Microsofts site - downloaded all the packages, unzipped them and ran them... the error I get is that the sql server needs to have an sa password and to use some switch to change it... for the life of me I am lost here. I can't use ACT! at this point and I have not ideas of how to remove, reinstall or repair the sql server.... Any help you can provide would be greatly appreicated!

The default sa password is blank. Is it complaining that this is not acceptable and you need to change it ?

What version of SQL Server do you have ? It sounds like SQL Server Express 2005 ? You may well have two instances installed now, one that came with ACT, and one that you've installed.

Overall, I'd say ACT are the people to talk to, you're using SQL Server with ACT, right ?

|||Yes, it is saying that the sa password is empty...specifically: "A strong sa password is required for security purposes. Please us SAPWD switch to supply the same. Refer to readme for more details. Setup will now exit." That is what is says when I attempt to run ANY installation version of SQL ... attempting to correct the sql error that I get when I run ACT!. Is there a way to repair or rebuild the sql server? I have only one instance, from the ACT! install... Thanks for the reply.. !!|||By the way.. that was the install error for SQL Server 2000 version A specifically... I installed SQL Server 2005 Express... or tried to... it would run either..|||

ACT will support either one ? I'm not sure that you don't have two instances running now ( SQL Server can have more than one version, or multiple instances of the same version, running on a machine ). If I were you, I'd uninstall the lot, including SQL Server, and reinstall ACT. To set the password, you run the installer for SQL Server from the command line and specify SAPWD="whatever", which will set the SA password. If the version of SQL Server you have installed has a management console, or whatever it was called in SS2000, you can go into it, find the Users section, and change the password there.

However, I would be more inclined to do a reinstall from scratch and then try the ACT site:

http://www.act.com/support/technicalsupport/index.cfm

I've looked and I can't see anything specific there, but the problem obviously relates to ACT, and if you've paid for it, they would be the ones who know what's going on, and should be supporting you to get their program working.

|||Sounds great... as for ACT! I called them already.. since I bought this version a while ago,. they stopped supporting it a couple months ago! Nice huh?! As for uninstalling them, I'm all for it.. how do I uninstall SS2000 and all the other instances of SQL Server? It's not in my remove programs dialog....... Thanks again for the help... look for to hearing back from you|||

If SS2000 is not in your list, perhaps MSDE is ( that's the free version ). Otherwise, maybe it uninstalls with ACT. If you go to Control Panel/Administrative Tools/Services, the list is alphabetical, if there are any listings that start with SQL Server, you still have SQL Server installed :-)

Your question is right on the edge of what is on topic here, and that means you're unlikely to find people with direct, first hand experience of the problem. If an uninstall/reinstall doesn't solve it, then I'd suggest looking for a forum populated with people who use ACT. I'm happy to try and help, but I'm pretty much in the dark, all I can do is comment based on what I know of SQL Server.