473,699 Members | 2,271 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

MSDE login problem

Hi all,

I have bought Visual C# .NET 2003 Standard and downloaded the MSDE to use
with it.

I did install it with it's default options and now i'd like to administer it
with Web Data Administrator but it keeps telling me that i should enable SQL
Server Authentication.

So i tried debugging the question creating an .udl file and trying to test
various authentication methods:
- Integrated Windows authentication works fine
- SQL Server authentication (when i try logging in using user 'sa' with the
password i've set keeps telling me that user 'sa' is not associated with a
trusted SQL Server connection.

How do i solve this puzzle? Tried googling (and reading some faqs) but
didn't come up with anything useful.

Unfortunately the Web Data Administrator doesn't allow using integrated NT
authentication. :-(

Thank You,
Lorenzo
Jul 20 '05 #1
2 3892
Check out MSKB 321698:

https://mvp.support.microsoft.com/de...b;en-us;321698

--
Hope this helps.

Dan Guzman
SQL Server MVP

-----------------------
SQL FAQ links (courtesy Neil Pike):

http://www.ntfaq.com/Articles/Index....partmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
-----------------------

"Lorenzo Bolognini" <lo*****@mysurn ame.net> wrote in message
news:jN******** *************@n ews2.tin.it...
Hi all,

I have bought Visual C# .NET 2003 Standard and downloaded the MSDE to use with it.

I did install it with it's default options and now i'd like to administer it with Web Data Administrator but it keeps telling me that i should enable SQL Server Authentication.

So i tried debugging the question creating an .udl file and trying to test various authentication methods:
- Integrated Windows authentication works fine
- SQL Server authentication (when i try logging in using user 'sa' with the password i've set keeps telling me that user 'sa' is not associated with a trusted SQL Server connection.

How do i solve this puzzle? Tried googling (and reading some faqs) but
didn't come up with anything useful.

Unfortunately the Web Data Administrator doesn't allow using integrated NT authentication. :-(

Thank You,
Lorenzo

Jul 20 '05 #2
"Dan Guzman" <da*******@nosp am-earthlink.net> ha scritto nel messaggio
news:p_******** ******@newsread 2.news.atl.eart hlink.net...
Check out MSKB 321698:


Thank you very much Dan.

Lorenzo
Jul 20 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
4857
by: David Lee | last post by:
Need some help bad here. Am using VB.Net Standard 2003 supplied for a class and I need to install Msde and the sample databases to work on homework. Following the documentation I can download sql2kdesksp3.exe and get the server running. I cannot then install the sample databases according to directions. Log file follows: 2:28:26 AM Wednesday, October 01, 2003: 12:28:26 AM Wednesday, October 01, 2003: Modified the sourceview node of...
6
5492
by: Nathan Sokalski | last post by:
I recently downloaded and installed (hopefully correctly) MSDE 2000 Release A. I previously, and still do, have the version of IIS that comes with XP Professional installed on my computer. I wanted MSDE 2000 Release A so that I could do database access using ASP from my websites, which are on my computer. When I went to my first test website, I recieved the following error: Error Type: Microsoft OLE DB Provider for ODBC Drivers...
2
2464
by: Marek Powichrowski | last post by:
Hi all, I have the the problem with logging to MSDE using SQL-DMO interface. On the W2K with LoginSecure=TRUE everything is OK (connect is made without any parameters) But when LoginSecure=FALSE (on Win 98) connect( 'instance_name', 'sa', 'sa_password' )
1
1402
by: Danny Liberty | last post by:
Hi, I am writing an application that uses MSDE to store data. Both application & MSDE run on the same computer. I want to regulate the operations done on the DB by the user. For example, I don't want to allow "standard" users to delete records, update certain fields, etc... I can regulate these rules within my program, but what if the user runs MSDE query for example on the DB and fetches the list of users & passwords from the DB ?
1
1491
by: farqua | last post by:
I've finally got MSDE 2000 sp3a to install on my PC by turning on the "Server" service. Duh! Unfortunately, I can't get it to connect to the server when I try to upsize a tables in an mdb database file. The SQL Server Manager icon is running and I am able to start the SQL server. I get a dialog box message about unknown procedure or something like that. I am running a stand alone PC with a DSL connection. I am trying to run the server...
5
1350
by: Hei | last post by:
Hi i'm try a asp.net web page that access msde, i think these problem is about premission. i have 1. added a login to msde named 'Database Users' and 2. grant windows user group 'Database Users' to that login, also 3. add 'ASPNET' to windows user group 'Database Users'.
1
1575
by: NWx | last post by:
Hi, I'm an old developer, but didn't used SQL Server or MSDE to much before. I have NetSDK instance of MSDE installed on my PC by Net Framework SDK. All quickstart samples access it using trusted connection. However, I want to access it using user / password, but I have no idea what is default username / password to use. Any help is appreciated.
2
1051
by: Paul C. | last post by:
Hi folks, I cannot seem to get my .NET app to successfully login to my Sql Server MSDE instance. It always tells me that the login for ASPNET failed. My biggest problem is that I cannot find any tools to let me administer the MSDE database. How do you guys all do it? Why didn't the MSDE installation take care of this? I should tell you that I am running my MSDE instance under the Local Account, which is Paul, a member of the...
16
2159
by: Nathan Sokalski | last post by:
I have Visual Studio .NET and SQL Server Desktop Engine on my computer. I have created an empty database using Visual Studio .NET's Server Explorer. However, I am having trouble connecting to the database using ASP.NET. I think the problem is somewhere in my connection string, but because I do not know much about connection strings, I am not sure what it should look like. Can someone please help me determine what my connection string should...
1
1143
by: rajeshwarrao.g | last post by:
Hi All, I am trying to access MSDE from ASP.NET application without giving administrative privileges to ASPNET user. It gives an error message saying "Cannot login to SQL server for ASPNET". Can't I access the MSDE in local machine or across network without giving administrative privileges to ASPNET? I tried accessing MSDE in another machine by giving <identity impersonate="true" userName="" password="" /it doesn't work. But i tried...
0
8706
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9055
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8945
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8902
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7787
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6550
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4392
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
3075
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2016
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.