Login to MSDE on Win 98 - Microsoft SQL Server

Marek Powichrowski

Hi all,

I have the the problem with logging to MSDE using SQL-DMO interface. On the
W2K with LoginSecure=TRU E everything is OK (connect is made without any
parameters)

But when LoginSecure=FAL SE (on Win 98)

connect( 'instance_name' , 'sa', 'sa_password' )

then it returns error message :

Login failed for user 'sa'. Reason : Not associated with a trusted SQL

I install MSDE on Win 98 with parameters :

INSTANCENAME='i nstance_name'
SECURITYMODE=SQ L
SAPWD='sa_passw ord'

Server runs with given instance name.

Who knows why I can not login to MSDE ?

TIA,

Marek Powichrowski

Jul 20 '05 #1

Subscribe Reply

2467

Simon Hayes

"Marek Powichrowski" <ma****@telbank .pl> wrote in message
news:bv******** **@korweta.task .gda.pl...

Hi all,

I have the the problem with logging to MSDE using SQL-DMO interface. On the W2K with LoginSecure=TRU E everything is OK (connect is made without any
parameters)

But when LoginSecure=FAL SE (on Win 98)

connect( 'instance_name' , 'sa', 'sa_password' )

then it returns error message :

Login failed for user 'sa'. Reason : Not associated with a trusted SQL

I install MSDE on Win 98 with parameters :

INSTANCENAME='i nstance_name'
SECURITYMODE=SQ L
SAPWD='sa_passw ord'

Server runs with given instance name.

Who knows why I can not login to MSDE ?

TIA,

Marek Powichrowski

The error is slightly strange, since it suggests MSDE is running in Windows
authentication mode, however that isn't supported on Windows 98. Can you
connect to the MSDE instance locally using osql, for example?

osql -S instance_name -U sa -P sa_password

If you can connect like this, then the issue is probably somewhere in your
SQLDMO code, and perhaps you could post the part which makes the connection.
If this doesn't work, then could you post the error message? And did you
install the latest MSDE version, ie. SP3a?

Simon

Jul 20 '05 #2

Marek Powichrowski

The error is slightly strange, since it suggests MSDE is running in Windows authentication mode, however that isn't supported on Windows 98. Can you
connect to the MSDE instance locally using osql, for example?

osql -S instance_name -U sa -P sa_password

If you can connect like this, then the issue is probably somewhere in your
SQLDMO code, and perhaps you could post the part which makes the connection. If this doesn't work, then could you post the error message? And did you
install the latest MSDE version, ie. SP3a?

Cause of error was setting LoginSecure to TRUE for the connection made on
the Win 98. When I change LoginSecure to FALSE then connection ends
succesfully (for proper server name user name and password) . So I can
create database using script generated by Enterprise Manager from my
computer and can atatch existing database to MSDE without Enterprise Manager
in the easy way (few lines of code).

Thanks for your support.

Marek Powichrowski

Jul 20 '05 #3

Similar topics

3895

MSDE login problem

by: Lorenzo Bolognini | last post by:

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

Microsoft SQL Server

2611

Pls Help: can't connect to server - login fails

by: ConTactMe | last post by:

I get the following error when trying to create an Access Data Project: Login failed for user 'myname'. Reason: Not associated with a trusted SQL Server connection. I'm using a specific username and password. The sQL Server (actually, MSDE) is installed on \\server1, and I'm working on my laptop.I get the error when I try and click the dropdown for "Select the database on the server". Any hints on what I've donw wrong?

Microsoft SQL Server

3854

MSDE 2000 Release A won't talk

by: noname | last post by:

MSDE 2000 Release A installed under windows 2000 pro will not communicate with SQL Server Manager nor MS Access on peer computer. Can someone help? Have set DISABLENETWORKPROTOCOLS=0 at install time. Install log shows installation successful.. Control Panel> Admin Tools> Services section shows SQL server instance running.

Microsoft SQL Server

6121

Can't import Access DB into MSDE

by: *no spam* | last post by:

I want to move my Access 2K database into MSDE. The Access Upsizing Wizard crashes (a known bug wi A2K), so I'm using the following suggested method: Access --> New --> Project (Existing Database) This asks for the name of the .adp file to create and then launches into the Data Link Properties dialog box (so far so good) I select my MSDE server from the drop-down, enter the sa account & passwd, attach a database file and try to...

Microsoft SQL Server

12840

by: PA | last post by:

I am new to MSDE 2000. Installed this yesterday using windows installer, deafult settings(no change in authentication). a. I want to create database and tabels in MSDE. How do I do this? (I managed to do this through .net web application using server explorer but is there any other way to do this? Where can I get enterprise manager? Can I use it after 120 days evalutaion? b. Once that I have created database and a table with windoes...

ASP.NET

1370

by: shahzad | last post by:

im using MSDE , not SQL server i have already created a new accnt named "demoasp" and assoigned it to processmodel section of machine.config so as to correct other error which said "server application unavailable" when i run my asp app .it gives following error

ASP.NET

1985

Help Login

by: Nicola Marchiori | last post by:

Hi I need some help. I am developing a Web App in one PC running IIS. I am trying to connect to to MSDE on another PC, but it's not working. This is the message i got Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

ASP.NET

1829

database login failed

by: Chuck Bowling | last post by:

I'm having a problem that i really don't understand. I'm new to ASP.NET and to SQL Server (MSDE). I'm trying to get a VS walkthru in the C# to work. I think the problem is permissions but I'm not sure. I've tried adding the ZEUS\ASPNET user to the server using osql with the command "EXEC sp_grantlogin 'ZEUS\ASPNET'" but it had no apparent effect. Below is the error page that was generated when I tried to build and run the site: ...

ASP.NET

9654

by: musosdev | last post by:

Wonder if someone can help! We're getting the following error on our Intranet system as soon as we login.. ------------------ Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\LOCAL SERVICE'. Source Error:

ASP.NET

8999

What is ONU?

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...

General

8836

Changing the language in Windows 10

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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

9575

Problem With Comparison Operator <=> in G++

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. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

6803

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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...

Microsoft Access / VBA

6080

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4885

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3322

transfer the data from one system to another through ip address

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

C# / C Sharp

2798

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2223

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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...

General