473,558 Members | 3,023 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

SQL Server 2000 Trusted connection

I am trying to connect to a sql server database from enterprise
manager. I am using sql server authentication and have set the SQL
Server up to accept mixed mode authentication. I am still get the
message : Login failed for xxx. Reason not associated with a trusted
sql server connection.
Jul 20 '05 #1
1 5058
Hi, Vicky.

"Trusted" refers to your domain based login that this protocol
expects. You might temporarily delete your SQL-based login and re-add
your "trusted" ID or the group it is a member of in the domain to test
this functionality.

You can troubleshoot this by putting a trace (SQL Profiler) on to see
where the authentication fails and what exact message is responsible
for the failure.

Is it possible that you have different passwords between your SQL
account and your domain-based account? If not, try setting them to the
same code.

If you enable more TCP/IP and Named Pipes for both the client and
server and try again, it will probably allow you to pass the check by
authenticating somewhere. I only suggest this if you are stuck.

Hope this helps or gives you some options.

--Steve
st***@strategic-pc.com
Jul 20 '05 #2

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

Similar topics

4
1678
by: Frodo | last post by:
I have a problem establishing a link between Visual Studio.NET 2003 and SQL Server 2000. Both are installed on a Windows Server 2003, standard version. Visual Studio.NET Issues =================== From Visual Studio.NET 2003 I attempt to ‘Connect to a database’ The ‘Data Link Properties’ dialog box appears.
3
4318
by: vlad | last post by:
We are running SQL server 2000 on MS Windows Server 2000. We have web based database (ASP.net and SQL Server 2000). When I run this page with 'sa' account, It works but when I change it to Window autointoxication I am getting the following error massage. Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server...
7
2149
by: Ray Valenti | last post by:
I am able to preview this data in the development environment, but when I run the application the error below shows up. How do I set up a Trusted Connection? -Ray Server Error in '/WebApplication2' Application. ---------------------------------------------------------------------------- ----
4
1142
by: Robert | last post by:
What user/account do I need to setup on my SQL 2000 Server, that requires the use of a Trusted Connection (Integrated Security=SSPI), in order for my postings to be able to make a connection to the database. The SqlConnection would look something like this? Data Source=MYSQL01;Initial Catalog=WebDB;Integrated Security=SSPI;Persist...
12
1314
by: RKay | last post by:
I have a Win2k server running SQL Server 2000. On that box I built a working web service that pulls data from the database. One of the services available simply accepts an ado.net connection string to test if a connection can be made to the local server. I can call that web service from any box on my network, and with the correct connection...
1
2272
by: vighnesh | last post by:
Hi All I am dealing a project in ASP.NET in which I have to establish a connection to SQL Server 2000 database,where the database was located on a remote system. For this I have used SQLConnection object and specified the connetion string.But when it comes to establish a connection its giving me the Error that I. Connection string :...
17
9198
by: Danieltbt05 | last post by:
just installed SQL server 2000 and using my client , i can't locate the server. I used SQL query analyzer to search but no servers were found. Error message is as below Server : Msg17,level 16, state1 SQL server does not exist or denied access.
22
3397
by: Bob and Sharon Hiller | last post by:
I have an ASP page that was done in VBScript It is setup to read an Access database and I need to change it to read a Sql 2005 Database. The code that is used to open the Access Database: Set adoConnection = server.CreateObject("ADODB.Connection") Set adoRecordset = server.CreateObject("ADODB.Recordset") adoConnection.Provider =...
4
2301
by: =?Utf-8?B?ZGF2aWQ=?= | last post by:
When I start the Visual Studio .NET 2005 on client machine, I select Tools and database connection (Database: SQL Server, security: windows authentication. Server: Server Machine name (not in the same domain, but in the same local area network; even same subnet)). When test the connection, I get error message: not associated with a trusted SQL...
2
2278
by: gnewsgroup | last post by:
OK, I know this has been a popular question from newbies. But, please don't haste to reply yet. I've googled and tested for a few hours, and cannot have this problem resolved. I have followed articles on the web and enabled "SQL Server and Windows Authentication" for my SQL Server 2005. But, it does not solve my problem. (It is...
0
7629
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...
0
7550
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7836
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
7915
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...
0
6184
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...
0
3579
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2046
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
1
1165
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
872
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...

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.