Hi,
I have created a login for sphang1-desk server. But when I use the following command in my visual studio, the error as subject appears. what should i do?
Dim connectionString As String = "server=SPHANG1-DESK;User id=GARsprakasa;password='';database=Northwind"
thank you
Hello All,
I know this issue has been dealt with every where in the universe. but none seem to solve my problem. I need help desperately
The set up is Classic ASP/Sql Server 2000 in an intranet:
Computer-A is the Sql server2000 running Windows XP Professional.
On it i created a login, AA, as a dbowner of a database called XXX. Inside XXX, AA is right there as a user.
i configured the SqlServer to accept mixed (Windows and Sql) logins. I restarted the computer and i logged into sqlserver successfully as AA. Everything is fine here.
Computer-B is the web server running IIS in Windows XP Professional.
I successfully created a system ODBC named EEEE to connect to XXX using the AA login. Everything is fine up to this point.
But, to my greatest surprise when i use - conn.Open("DSN=EEEE;UID=AA;PWD=AApassword;") in a classic ASP page, it returns this very famous error.
What did i do wrong? Please help
Hi. i have a problem.
I want to Update a Database like this GISETS.SDE.CADENA, but it sais that it wants update this GISETS.DBO.CADENA (Database that doesn´t exist).
I use a connection string .sde but it gets a conflict because the reference is for a database .dbo. how can I fix it???
thanks for advance. Sorry for my english.
Fernando.
Is there any chance that the deadlock will break the database connection.
And if yes how to protect the conncetion that should not affect by deadlock.
Regards
Anil
After installing MSSQL EXPRESS 2005 (on Server 2003 Std. OS) there was no problem when connecting to MS SQL server remotely via Visual Basic 2005 or MS Access.
But after updating SP2 I can't connect to it from another computer in no way any more.
I'm getting error message:
SQL server error: 10061
SQL server error: 17
May sameone has some ideas :o ???
Hi folks, when i try to connect to my sql express sever through Sql sever authentication I keep getting an error that says
"Login failed for user 'username'. The user is not associated with a trusted SQL Server connection. "
I know the password is right.. how do i overcome this??
Hello All,
I know this issue has been dealt with every where in the universe. but none seem to solve my problem. I need help desperatelyThe Web Application is a Classic ASP/Sql Server 2000 using two computers in the same physical network:Computer-A is the Sql Server2000 running Windows XP Professional.Inside Sql Server2000 i created a login, AA, as a dbowner of a database called XXX. Inside XXX, AA is right there as a user.
i configured the SqlServer to accept mixed (Windows and Sql) logins.I restarted the computer and i logged into sqlserver successfully as AA. Everything is fine here.
Computer-B is the Web Server running IIS in Windows XP Professional.Here, I successfully created a System ODBC i named EEEE to connect to XXX using the AA login. Everything is fine up to this point.But, to my greatest surprise when i use - conn.Open("DSN=EEEE;UID=AA;PWD=AApassword;") in a classic ASP page, it returns this very famous error.
What did i do wrong? Please help
Hi All,
My Webserver and SQL Server are of different machines.I have connected my website with sql server database. I published that website in IIS. I can able to browse that in local machine. But, if I try to browse from some other machine its giving me error saying "NOT ASSOCIATED WITH TRUSTED SQL SERVER CONNECTION".
MY Connection string is this:
connectionString="Data Source=BOOKSQL;Initial Catalog=CustomerDb;Trusted_Connection=True;"
I also tried with
connectionString="Data Source=BOOKSQL;Initial Catalog=HeCustomerDb;Integrated Security=SSPI;"
How can I overcome this problem. Please help me! I need ur immediate response.
Hi,
Iam getting the following error when trying to connect to a database on the remote server using asp.net web form
"Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection."
can anybody tell me what could be the exact reason for this.
Regards
Adonis
seems a lot of people are having this problem but none of the solutions i tried has worked so far. I want to develop asp.net applications at my home pc running Win Xp pro SP2. I use MSDE as the database server and manage it with sql server enterprise manager. I do all the programming in Delphi 2005 and I run IIS 5.1, all on the same PC.
Now...if I build a test windows application and try to connect to the database with a connection object or UDL file, winnt authentication works. If I then try to connect through an asp.net application, where I have the connection string coded in the .aspx file I either get a "login failed" or "not trusted sql server connection". I have tried to set up login accounts on Enterprise manager both as winnt authentication or sql server authentication but none has worked with asp.net (no problem with windows apps). Funnilly I don't have that problem at work, though the sql server at the office is on a separate pc. I know many people face this problem, can anyone help me out?
thanx in advance
Two days ago I had no problem creating or running DTS packages.
Now, when I try to design or run a DTS package that has a connection to SQL Server (using userid 'sa') I get the following error message:
Error Source: Microsoft OLDDB Provider for SQL Server
Error Description: Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.
I am running from an NT Client. The only thing that might have caused a problem is that we had a power hit yesterday.
Has anyone seen this problem, and does anyone know what need to be done to resolve the problem?
Thanks, in advance.
Hi
when i am registoring my remote database to my mechine i am getting This error " Not Associated with a trusted SQL Server Connection "
The remote server is working on Windows 2000/ SQL Server 7.0 Mine is Windows NT4.0 / SQL Server 7.0 why I am getting this error, I am using user is sa with pass word.
Help me regarding this
Thanks
I just upgraded my SQl tools from 7.0 to 2000. Now, when I want to access information from our sql server (v. 7.0) through ODBC, I get an error, the login box comes up with the trusted connection checked (this particular database doesn't use trusted connection). My PC runs Windows 2000 and has for over a year. Others in my company have developed this issue immediately after installing W2k on their computer or installing other software. Is there a way to have the login NOT have trusted connection checked?
Thank you.
I am trying to connect to a SQL Server database using windows athenication over Cisco VPN 4.0.3. I recieve the error "Login Failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection" using Enterprise Manager. I am able to connect sucessfully when connecting using a SQL Server logon. I able to connect to the domain and connect to remote drives. I am able to using Microsoft Outlook with no problems.
I am running Windows XP and connecting to SQL Server 2000 running on windows 2000. I have no problems connecting via Windows authenication at work. I only have the problem over VPN. I just recently rebuilt my hard drive due to hardware failure, and have not been able to connect using Windows authenication since I re-installed all of my software. Prior to that, it worked great. Does any body know what might be the problem and what the solution is?
I appreciate any help that I can get.
Glenn
Please suggest the error message: "Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection
regardz,
sAm
Hi, I've got SQL2000 Evaluation edition running on my ownWindows XP Pro computer. I've installed it fine, and createdsome sample databases. It works fine.I can connect using Windows authentication. But when I try toconnect with username & password I get the error message:"Login failed for user sa Reason: not associated with a trustedSQL Server connection.What's going wrong here? How do I set up a trusted connection?
View 2 Replies View RelatedHi All... I'm using asp.net 2.0 against a SQL Server 2005 database and am getting an error,
Login failed for user 'MyUser'. The user is not associated with a trusted SQL Server connection.
I've done searches for this error and most say to switch from windows-only authentication to mixed mode. That seems more like a workaround rather than a solution. I mean we should be able to use windows-only right? So how does one set up that user to be associated with a trusted connection?
The odd thing in my setup is that I'm using the exact same username and password as I'm using to connect to the database with Visual Studio 2005 and that works fine. But when I try the same acct/pwd from asp.net, I get that error.
FWIW, here's my connection string:
"Server=192.168.1.47; Database=MyDatabase; UID=MyUser; PWD=MyPassword"
What gives here? Any thoughts? Thanks!
I setup a DSN to a remote SQL 2000 Enterprise Server and was able to successfully complete the test connection. However, when I went to use the DSN to establish a connection in Integration Manager for GP 8.0 I got the following error:
"Integration Manager was unable to obtain column information.
You will not be able to map to fields in this query until the following problem is corrected:
Could not create connection to Data Source '_Web Customers':
Attempt to open connection Failed:
[Microsoft][ODBC SQL Server Driver][SQL Sevrer]Login Failed for user'(null)'. Reason:Not Associated with a trusted SQL Server connection."
I have tried everything I have been able to find on Trusted Connections but nothing seems to work.
Any ideas or pointers on where to look for help with this?
Thanks in advance for any help
Terry
Hello Everyone,
In a Windows domain
i have One PC for SQL Server 2000 Database
and other PC is my development .
So When I create C# Windows Application on my PC and try to get the data , It Works Perfectly fine
but
when I create C# ASP.NET Application on my PC and try to get data , It throws Error as
"Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection."
my connection string for Windows Authentication is as follows
SqlConnection miConnection= new SqlConnection("integrated security=SSPI;data source=SID_DB;persist security info=False;initial catalog=CC");
I tried using "sa" account , it gives me following error
"Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection"
my connection string is as follows
SqlConnection miConnection= new SqlConnection("user id=sa;password=sa000;data source=SID_DB;persist security info=False;initial catalog=CC");
I tried both the ways above stated , It is giving me the Error .
Configuration is as follows
IIS on My PC
VS 2003 on MY PC
MS SQL Server 2000 on "SID_DB" pc.
Thanks in Advance,
Sidheshwar
Hi,
My question is related to accessing the data of one SQL server 2000 from another SQL server 2000 thru query analyser which are in different domains.
When I run SELECT query from one Query analyser of SQL server 2000 which is in domain A to fetch the data from the other SQL server database which is in different domain. I am getting the error as "Login failed for the user <username>, Not associated with a trusted SQL server connection"
Both SQL servers are having mixed mode (SQL & windows authentication).
Your help is very much appreciated.
Thanks in advance.
Hanumant
Hello All,
I know this issue has been dealt with every where in the universe. but none seem to solve my problem. I need help desperately
The Web Application is a Classic ASP/Sql Server 2000 using two computers in the same physical network:
Computer-A is the Sql server2000 running Windows XP Professional.
On it i created a login, AA, as a dbowner of a database called XXX. Inside XXX, AA is right there as a user.
i configured the SqlServer to accept mixed (Windows and Sql) logins. I restarted the computer and i logged into sqlserver successfully as AA. Everything is fine here.
Computer-B is the web server running IIS in Windows XP Professional.
Here in Computer B, I successfully created a system ODBC named EEEE to connect to XXX using the AA login. Everything is fine up to this point.
But, to my greatest surprise when i use - conn.Open("DSN=EEEE;UID=AA;PWD=AApassword;") in a classic ASP page, it returns this very famous error.
What did i do wrong? Please help
I just started evaluation of the server and meet the fist problem. I searched the forum however most answers related to use SQL Server manager and security tab. Note I use the express edition which has no manager, but only configuration manager. There is no security tab. So can somebody help in setting up trusted accounts for SQL server express edition?
View 5 Replies View RelatedI have developed a web application which works with SQL server express with out any problem on my development pc. I used the copy project from VS2005 to copy the whole project to my test pc which has Win XP and SQL server express installed. SQL authentication on both PCs is set to mixed mode (windows and SQL). But when I run the application I get the following error:"The user is not associated with a trusted SQL Server connection" I checked user permissions and everything works ok. Application works well on the development pc. Please help. Any help is greatly appriciated.
View 1 Replies View RelatedHi Eeveryone!
I am using SQL server 2000 with Webmatrix to build a simple Asp.net app, but facing this problem:
Using Entrprise Manager, I have created a login name "ASPNET" and gave it access as db_owner to the default database "master" , but still could not open SQL connection from Webmatrix aspx file!
The error message I get is :
Login failed for user "ASPNET". Reason : Not associated with as trusterd SQL Server .
I truely apprciate your help!
Hello all. I'm still learning SQL Server so hopefully you'll be patient with me. I've been using mostly MS Access db files in all my web sites ...but SQL Server on a few of them.I've installed SQL Server 2000 Personal Edition for web development (testing). I installed it under my log in name to this particular machine and used the same password and installed using Windows Authentication. I opened Ent Mgr and created a first database. I imported my Access data and all is well so far.I "convert" a test page to connect to my local SQL Server using the uid and pwd and get the error in the subject. I double check and the uid & pwd is in fact correct in the Security >> Logins section and it matches my code. I switch my connection string to use "sa" with and without a password....same results. I add ASPNET as a user and give it access to the new db and same results again. I also tried to enclose my Accout/Machine ID in single quotes in my connection string and no luck. Any ideas as to what I might be missing? Again - I also tried "sa" - no luck.server=MyMachineName; uid=Shane Fowlkes; pwd=123456; database=NewDatabase
Login failed for user 'Shane Fowlkes'. Reason: Not associated with a trusted SQL Server connection.
Does anyone know of a component or other mini application that can be run on the IIS server and allow IIS to access SQL Server 7 databases using Trusted Security.
Our security unit has required us to run SQL Server with Trusted Security so changing to Mixed mode is not an option. We are also not allowed to use Basic Authentication for Active Server Pages with IIS. IIS and SQL server are also on different machines.
We are looking into the possibility of trying to create a component that would run on the IIS machine to allow us to use Trusted Security to the SQL Server (in effect try to make it work the same way that the Cold Fusion product does).
Any help would be really appreciated.
Thanks
Hello
I've spent close to 3 hours trying to figure this out.
I have SQL Server 2000 Developers Version + Service Pack 4 installed on Machine A which is running Windows XP Pro. I have Machine B running XP Pro and Apache 2.0 + PHP 4.40.
SQL Server is configured to SQL Authentication + Windows Authentication.
PHP is configured as follows:
; Use NT authentication when connecting to the server
mssql.secure_connection = Off
When trying to connect with either mssql_connect or odbc_connect I get the following error:
Quote: odbc_connect(): SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'user'. Reason: Not associated with a trusted SQL Server connection., SQL state 28000 in SQLConnect
I have tried adding a System DSN to MDAC and it can connect no problems to MS SQL. I don't know what to do, I've googled and tried every possible solution and it didn't help.
Is there a way to make SQL accept any connections? I don't care if its insecure I just need it for several days to develope a small application.
Here is the sample code I'm using to test the connection:
PHP Code:
$myServer = '192.168.0.106';
$myUser = "user";
$myPass = "pass";
$myDB = "Northwind";
$s = mssql_connect($myServer, $myUser, $myPass)
or die("Couldn't connect to SQL Server on $myServer");
$d = mssql_select_db($myDB, $s)
or die("Couldn't open database $myDB");
$query = "SELECT TitleOfCourtesy+' '+FirstName+' '+LastName AS Employee ";
$query .= "FROM Employees ";
$query .= "WHERE Country='USA' AND Left(HomePhone, 5) = '(206)'";
$result = mssql_query($query);
$numRows = mssql_num_rows($result);
echo "<h1>" . $numRows . " Row" . ($numRows == 1 ? "" : "s") . " Returned </h1>";
while($row = mssql_fetch_array($result))
{
echo "<li>" . $row["Employee"] . "</li>";
}
Thanks in advance!!
I am trying to connect to a sql server database from enterprisemanager. I am using sql server authentication and have set the SQLServer up to accept mixed mode authentication. I am still get themessage : Login failed for xxx. Reason not associated with a trustedsql server connection.
View 1 Replies View RelatedError setting-up updatable subscription
I get the following error when trying to set-up an updateable subscription.
Unable to set the Publisher login for the updatable subscription. You may have to set this up directly on the Subscriber machine using sp_link_publication. (New Subscription Wizard)
The user is not associated with a trusted SQL Server connection
Login failed for user ''. The user is not associated with a trusted SQL Server connection
The details are
Server Name: DEVELOPER_WS
Error Number: 18456
Severity: 14
State: 1
Line Number: 1
My servers are set up for mixed mode operation.Can anyone recommend a possible way of debugging the issue with this login?
Hi All,
I have a web serivce written in C++ and I'm trying to connect to a database. I'm using the same connection string that works from an aspx page written in C#. but when I copy it over to the C++ environment, I get:
System.Data.SqlClient.SqlException: Login failed for user ''. The user is not associated with a trusted SQL Server connection.
Note the username shows up as null in the error... My C++ looks like:
using namespace System:ata:qlClient;
String^ cs2 = "server=192.168.1.47;database=MyDB;integrated security=true;uid=myuser;pwd=mypassword";
SqlConnection^ myConnection = gcnew SqlConnection(cs2);
myConnection->Open();
Again, this works in C#. Interestingly, a sniffer shows a difference in an NT Authentication Packet as it's sent from my development machine to the database across the network. For the C# call, the NT Authentication packet has a username of "myuser" - from the connection string. It then gets acknowledged from the database. For the C++ call though, the username is sent as "ASPNET" - seemingly ignoring the username in the connection string. It's also rejected by the database in the next packet with the message above.
Any idea what's up with this? -- Curt
I set up SQL Express and Visual Studio Team System for the first time yesterday. I created a web service (on my localhost IIS) and added an MDF file to my App_Data folder. I added a table with five fields. I'm trying to connect to the database in my web service, but when my web service gets to the connection line it returns the error
System.Data.SqlClient.SqlException: Login failed for user ''. The user is not associated with a trusted SQL Server connection.
When I add in my domain name and password to the connection string I get the error
System.Data.SqlClient.SqlException: Login failed for user 'redmonddanmor'. The user is not associated with a trusted SQL Server connection.
I've queried these SQL forums, and the advice is usually "add the user to the trusted users" or "changed to mixed mode authentication", but none of the posts I found specified HOW exactly to do either. How? What application lets you change those things? I just want to use an MDF file in an ASP.NET web service.
My database is in Sql Express. The security mode is set to Mixed Mode ( at least it is shown in the tab ) . I am tryinig to connect in database by using domain user, which is admin in the pc and it belongs to admins in the domain. But the problem persists. Is there any idea how to overcome this. When I connect with sa of course it is ok
Thanks in advance
Greg
it is quite embarassing for me to post this thread. But, i need help big time! I have searched high and low for a solution, and this is my last hope.
Sql Server Express 2005 is the server: I created a login, say james, password: bond. Also, i assigned a dbcreator, serveradmin db_owner to this login(james).
Then, from Sql Server Management Studio Express, i tried to log in with the login details stated above. i get the nasty surprise: The user is not associated with a trusted sql server connection Microsoft SQL Server, Error: 18452
I have aged years on this problem. All solutions on google, msn were either inapropriate (apply to other editions of sql server) or simply did not work!
The most common solution profered is to set the properties of the sqlserver to accept both windows and sql authentication (mix mode), and then restart the server. This feature is available on sqlserver 2000 BUT NOT on Sql Server Express 2005. Am i right?
Please help!