Not Associated with a Trusted SQL Server Connection

  • Thread starter Thread starter Don Peters
  • Start date Start date
D

Don Peters

I'm running Win XP Pro with Visual Studio 2002 and have copied a working
ASPX application to my PC in order to support it here. The application uses
SQL Server, i.e., MSDE 2000.

When I bring up Server Explorer in Visual Studio, I can browse all the
tables in the application's database, as expected.

When I right-click on the database and select "Modify Connection...", the
Connection tab of the Data Link Properties form indicates I'm using "Windows
NT Integrated security". When I click on button "Test Connection", the test
is successful. So far, so good.

However, this database actually uses SQL Server authentication. So when I
click on "Use a specific user name and password" instead of "Use Windows NT
Integrated security", and supply a User Name and Password, and then click
button "Test Connection", the test fails. The error given is that the "Login
failed", and the reason given is:

Not associated with a trusted SQL Server connection

I've searched the Internet for this problem, and found it reported numerous
times. But each time the solution seems to be to use Enterprise Manager's
security tab to set the login to use BOTH Windows NT and SQL Server
authentication.

Unfortunately XP Pro doesn't have Enterprise Manager, and this MSDE "Data
Link Properties" form doesn't allow setting both forms of authentication at
the same time.

I've just upgraded my MSDE from SP1 to SP3, but that didn't help.

Any ideas as to how I can fix this problem?

Don
 
When accessed from the IDE, you are on the local network so it knows who you
are. You can use Windows Authentication if you use the ASP.NET account and
make sure it has been granted the appropriate permissions. I read somewhere
that there is like a $50.00 version of SQL Server (I think it's developer)
that gives you client tools but I can't seem to find the link now. Once you
get a connection, you can just fire SQL Statements to grant access to users
and the like, if I remember correctly, MSDE makes you install it with the SA
account and the ASP.NET account wouldn't yet exist.

Let me see If I can find that link about Developer edition and the client
tools....
 
Hi Don,

Search for the LoginMode parameter in the registry editor under the SQL
Server service. Change it to 0 and restart the MSDE.

HTH,
 
Hello Don,

Don,

You can get Enterrprise Manager pretty easily even though its not
included with msde.

Obtain a copy of the SQL 2000 120 day evaluation version disk (I
bought a cheapish book with it attached within the back cover- Sams
Teach Yourself SQL Server . You can install Enterprise Manager from
the disk and it is not time limited.

There are plenty of other books which include the evaluation version
disk,

Best wishes, John Morgan
 
You can obtain it this way but doing so does not comply with the EULA.

HTH,
 
If you need it for longer than 120 days, is it OK to uninstall it, and then
reinstall it to get another 120 days?

Don
 
Thank you Greg - that fixed it!

But from everything I've now read on this issue, I understand that I've now
opened myself up to a potential security issue since someone can come over
the Internet and connect to my MSDE and easily access (and change) my
database since the default user account of "sa" with no password is the
default for every installation. Hence I should change them.

My wish: that the initial error message would clearly address this issue..

Thanks again,
Don
 
Hi Don,

Also ensure you have service pack 3a installed if you have a live system or
you'll have even bigger problems...:-)

HTH,
 
Hi Don,

The point is that the eval license is for evaluating the product, not for
ongoing work. The developer edition at (I gather) $49 USD sounds more
appropriate for ongoing development work.

HTH,
 
Regarding that "$50.00 version of SQL Server", do you mean MySQL? Or, are
you thinking of a replacement for Enterprise Manager, one of which is from
Teratrax,
and another from ASPEnterpriseManager.

Don
 
No, the Microsoft SQL Server Developer Edition is $49.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
MVP, hRD
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Back
Top