ASP and MSDE Connection Problems

Hello
I have a simple MSDE database set up on this local machine. I have a small
asp.net web page that tries to query the database and returns a list from
one of the columns. Nothing fancy, just trying to set it all up and get it
all working.
I get an error on the page when I run it.
Exception Details: System.Data.SqlClient.SqlException: Login failed for
user 'BBAISLEY\ASPNET'.
I assume this means that the user account isn't set up right, but I am not
telling it to use this account. I have the following connection string:
Dim connectionString As String = "server='BBAISLEY\MSDEBBAISLEY';
trusted_connection=true; database='music_cds'; user id=SQL;
password=xxxxxxxxxx;"
Can someone help me get this working? I would like to make a simple account
for all of my apps to use, don't really care what its called for now.
When I log in, I can only use the windows authencation method, so maybe my
MSDE instance isn't set for SQL passwords? How can I check this?
Thanks
Brett
You are using ASP.NET?
This is a common error as the applications default to using the ASPNET
account.
You have two choices:
1. Give access to the ASPNET account. (I dont think you want to do this
though).
2. Modify the AUTHENTICATION heading in the web.config file, & also the
virtual directory/site/directory property to only allow windows
authenticated users into the folder:
Under the AUTHENTICATION heading add:
<identity impersonate="true" />
Modify IIS to only allow windows authenticated users through...
Cheers,
James Goodman
"Brett Baisley" <baisley@.hotmail.com.REMOVETHIS> wrote in message
news:e$TLLgdLEHA.3292@.TK2MSFTNGP11.phx.gbl...
> Hello
> I have a simple MSDE database set up on this local machine. I have a small
> asp.net web page that tries to query the database and returns a list from
> one of the columns. Nothing fancy, just trying to set it all up and get it
> all working.
> I get an error on the page when I run it.
> Exception Details: System.Data.SqlClient.SqlException: Login failed for
> user 'BBAISLEY\ASPNET'.
> I assume this means that the user account isn't set up right, but I am not
> telling it to use this account. I have the following connection string:
> Dim connectionString As String = "server='BBAISLEY\MSDEBBAISLEY';
> trusted_connection=true; database='music_cds'; user id=SQL;
> password=xxxxxxxxxx;"
> Can someone help me get this working? I would like to make a simple
account
> for all of my apps to use, don't really care what its called for now.
> When I log in, I can only use the windows authencation method, so maybe my
> MSDE instance isn't set for SQL passwords? How can I check this?
> Thanks
> Brett
>
|||Whoops, I misread!
It looks like you do want to use the first suggestion I made.
By default, msde is only setup for Windows Authentication, rather than sql
authentication.
See this link for information on how to modify this:
http://support.microsoft.com/default...en-us%3B319930
http://support.microsoft.com/default...n-us%3BQ322336
Cheers,
James Goodman
"Brett Baisley" <baisley@.hotmail.com.REMOVETHIS> wrote in message
news:e$TLLgdLEHA.3292@.TK2MSFTNGP11.phx.gbl...
> Hello
> I have a simple MSDE database set up on this local machine. I have a small
> asp.net web page that tries to query the database and returns a list from
> one of the columns. Nothing fancy, just trying to set it all up and get it
> all working.
> I get an error on the page when I run it.
> Exception Details: System.Data.SqlClient.SqlException: Login failed for
> user 'BBAISLEY\ASPNET'.
> I assume this means that the user account isn't set up right, but I am not
> telling it to use this account. I have the following connection string:
> Dim connectionString As String = "server='BBAISLEY\MSDEBBAISLEY';
> trusted_connection=true; database='music_cds'; user id=SQL;
> password=xxxxxxxxxx;"
> Can someone help me get this working? I would like to make a simple
account
> for all of my apps to use, don't really care what its called for now.
> When I log in, I can only use the windows authencation method, so maybe my
> MSDE instance isn't set for SQL passwords? How can I check this?
> Thanks
> Brett
>
|||Ahh, that fixed it up. Thanks James
"James" <jamesATnorton-associates.co.ukREMOVE> wrote in message
news:e6GypgfLEHA.1644@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Whoops, I misread!
> It looks like you do want to use the first suggestion I made.
> By default, msde is only setup for Windows Authentication, rather than sql
> authentication.
> See this link for information on how to modify this:
> http://support.microsoft.com/default...en-us%3B319930
> http://support.microsoft.com/default...n-us%3BQ322336
>
> --
> Cheers,
> James Goodman
> "Brett Baisley" <baisley@.hotmail.com.REMOVETHIS> wrote in message
> news:e$TLLgdLEHA.3292@.TK2MSFTNGP11.phx.gbl...
small[vbcol=seagreen]
from[vbcol=seagreen]
it[vbcol=seagreen]
not[vbcol=seagreen]
> account
my
>

Arghhhh Alias (local)\FOOBAR -> TCP/IP,ditto

I've just spent days trying to get no-network protocol access to a local
(MSDE )database working. Everything I tried failed, all hints from the
documentation failed.
Eventually...I found cliconfg.exe and found out about Aliases and found the
stupid alias I referred to in the subject line, i.e.
(local)\FOOBAR -> DBMSSOCN,(local)\FOOBAR
No wonder things didn't work when I removed TCP/IP from the server's
protocol set!
So:
1. Why do none of the utilities report the existense of this Alias. Not
osql when I connect, no "using alias" line.
I would like it to say "Using Alias" if it was, e.g.
C:\>osql -S (local)\FOOBAR -U sa
Password:
Using Alias.
[TCP/IP Sockets]Specified SQL server not found.
[TCP/IP Sockets]ConnectionOpen (Connect()).
C:\>
Not from "osql -L", though perhaps the existence of multiple lines of output
was a hint.
Nor when using odbcad32. It does not show that Aliases exist at all; it
does not show the Alias panel. In its "Client Configuration" window, it
uses the term "Server alias", but that's not the same thing I think...it's
just a hold-over from that dialog's use in cliconfg.exe? It certainly does
not show cliconfg.exe's Aliases panel and no alias is created when I try
putting things in there now.
2. Why does none of the documentation mention anything about this?
There's very little mention of aliases at all.
In troubleshooting sections, there's no mention of the possibility of an
alias making the system lie to you.
There's little mention of the client network configuration utility. And
particularly no mention of where it is located and what it is called. I
don't know where I found out is was called cliconfg.exe and it was in
system32. I don't know where I found this, maybe I even in the end
did a search for "cli" on my hard-disk.
3. How did that alias get created?
Was it created by the people who provided the installer for the database'
If so, they better beware. Was it created by some automatic step in using
the database' I certainly didn't create it intentionally and no-one else
has access to my machine.
So just a long complaint really. But hopefully of use to someone. Maybe
even the docuemntation could be improved based on it... :-)
BTW. I'm never really sure of what Power Users can and cannot do, but...
The registry permissions allow a Power User to change aliases. Can power
users normally make such globally significant changes?
--
Alan J. McFarlane
http://homepage.ntlworld.com/alanjmcf/
Please follow-up in the newsgroup for the benefit of all.The client network utilities and other GUI utilities don't ship with MSDE.
Client aliases have been around since SQL 4.2.
SQLDiag.exe will report that aliases are configured on the server as well.
aliases are stored in the registry on the client machine.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer\Client\ConnectTo
Q. Why does none of the documentation mention anything about this?
Answer:
See: Books Online: Configuring Client Net-Libraries
There are lots of articles that discuss the use of aliases to connect.
328383 INF: SQL Server Clients May Change Protocols When They Try to Connect
http://support.microsoft.com/?id=328383
265808 INF: How to Connect to an SQL Server 2000 Named Instance with the
http://support.microsoft.com/?id=265808
Q. How did that alias get created?
Answer: SQL setup and MDAC setup don't create any aliases. They are
created by the user. Either using SQL Client network Utility, or creating
a ODBC DSN and using the Client Configuration Button.
With MSDE, you also have the option of having it only listen on Shared
Memory. This would only allow local connections to succeed.
This is documented in the sp3 readme as well as the following article.
814130 INF: How to Secure Network Connectivity for SQL Server 2000 Local
http://support.microsoft.com/?id=814130
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

are there any MSDE T-SQL code limitations?

I am writing a database app which will run under MSDE on the user's systems.

Other than limitations as to the number of concurrent users, are there any
issues that I need to be aware of when programming the database using SQL
Server 2000? i.e., are there T-SQL programming statements that will run
under SQL Server 2000 as part of my development enviornemnt that won't run
under MSDE on the end users machines, or will MSDE handle anything that SQL
Server can from the database engine standpoint?

Thanks!hi Mike,
"Mike N." <BadDog@.thepound.com> ha scritto nel messaggio
news:r3erb.5780$942.4765@.newssvr25.news.prodigy.co m...
> I am writing a database app which will run under MSDE on the user's
systems.
> Other than limitations as to the number of concurrent users, are there any
> issues that I need to be aware of when programming the database using SQL
> Server 2000? i.e., are there T-SQL programming statements that will run
> under SQL Server 2000 as part of my development enviornemnt that won't run
> under MSDE on the end users machines, or will MSDE handle anything that
SQL
> Server can from the database engine standpoint?

all T-SQL statements SQL Server 2000 supports are supported by MSDE...
you only (only...) have database limitation size, limited replication
support, no mail support...
for further info please visit
http://www.microsoft.com/sql/msde/p...fo/features.asp

hth
Andrea Montanari (Microsoft MVP - SQL Server)
andrea.sql@.virgilio.it
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.4.0 - DbaMgr ver 0.50.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--- remove DMO to reply

Are there any JDBC Drivers for MSDE

Are there any JDBC Drivers for MSDE ver of SQL Server 2000 Desktop Engine
Release A?
We prefer a MS version of the JDBC but I dont see it....
Thanks
-Tom
Download:
http://www.microsoft.com/downloads/d...displaylang=en
Service Packs:
http://support.microsoft.com/default...b;en-us;883370
How to use:
http://support.microsoft.com/default...b;en-us;313100
--
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/
"Tom Celica" <Tom@.DontReply.net> wrote in message
news:_bc1f.795$ht7.731@.newssvr21.news.prodigy.com. ..
> Are there any JDBC Drivers for MSDE ver of SQL Server 2000 Desktop Engine
> Release A?
> We prefer a MS version of the JDBC but I dont see it....
> Thanks
> -Tom
>
|||Mike, thanks for looking this up. But the versions of JDBC referenced below
don't work with MSDE version of SQL 2000.
-tom
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:etxB$VpyFHA.3408@.TK2MSFTNGP09.phx.gbl...
> Download:
> http://www.microsoft.com/downloads/d...displaylang=en
> Service Packs:
> http://support.microsoft.com/default...b;en-us;883370
> How to use:
> http://support.microsoft.com/default...b;en-us;313100
> --
> --
> 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/
> "Tom Celica" <Tom@.DontReply.net> wrote in message
> news:_bc1f.795$ht7.731@.newssvr21.news.prodigy.com. ..
>