Using Trusted Connection From Unix
Nov 4, 2006Hi,
Is it possible to connect to SQL Server using trusted connection from
unix? If yes, I'd like to know how.
Regards,
Thyagu.
ADVERTISEMENT
ODBC Connection In UNIX
May 14, 2007Hi Folks,
I need to access the MSSQL data in Oracle.
For that i need to first create the data source (ODBC Connection) to the MSSQL server on UNIX. Can anybody help me in creating the ODBC connection.
Thanks,
Amit
Connection Strings, Trusted-connection VS Username-password, SQL Server 2005 Express
Mar 9, 2007All --
Please help.
I have some questions about connection strings.
BACKGROUND...
Note that I am using the "SQL Native Client OLE DB Provider", SQL Sever 2005 Express, ASP.NET, C#.NET, and VS.NET 2005.
Note that I do not want to use the "Attach a database file" type of connection string.
Note that I am using the site http://www.ConnectionStrings.com as a reference.
Note that this "Standard security" connection string...<add name="LocalSqlServer" connectionString="Server=MYTESTOFFICESERVERS;Database=MyDatabase;Uid=MyDatabaseUser;Pwd=MyDatabasePassword;" />...does not work and causes the following run-time error...A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
Note that this "Trusted connection" connection string...<add name="LocalSqlServer" connectionString="Server=MYTESTOFFICESERVERS;Database=MyDatabase;Trusted_Connection=yes;" />...works but is less-than ideal because it uses a Trusted Connection rather than a Username/Password combination.
QUESTIONS...
(A) What exactly does the error in Item 4 mean?
(B) Do 4 and 5 imply that one must use a Trusted_Connection for all SQL Server 2005 Express connection strings when the database does not reside in the web application's App_Data folder or use a "Attach a database file" type of connection string?
(C) Are there any alternatives?
(D) What do you suggest?
Please advise.
Thank you.
-- Mark Kamoski
SQL Connection In Vista With Trusted Connection Fails Under Local System Account Until Reboot
Mar 4, 2008Hi All,
We are using the Windows Task Scheduler as a substitute for the SQL Server Agent, which isn't available in the Express edition. The scheduled task just calls a batch file, which in turn, runs a stored procedure using osql with the -E option for a Trusted Connection.
SQL Server Express has been installed using the defaults, which means the service is running in the "NT AUTHORITYNETWORK SERVICE" account. The scheduled task we create is set to run using the "NT AUTHORITYSYSTEM" account.
Now we find that on Windows Vista (tested using Ultimate Edition) that the scheduled task fails to run the stored procedure until the machine is rebooted the first time after installing SQL Server Express. When I say "fail", I mean that the stored procedure isn't executed. The scheduled task however completes and reports no errors. On Windows XP, we do not run into this problem so I suspect it has something to do with the UAC in Vista?
We further found that after installing SQL Server Express and creating the scheduled task in the "NT AUTHORITYNETWORK SERVICE" account, the scheduled task (and stored procedure) runs fine WITHOUT requiring a reboot.
Can anyone explain why a reboot is needed to get SQL Server Express to run the scheduled task correctly under Windows Vista and the SYSTEM account?
Any help or thoughts greatly appreciated.
Jdbc Refuses Connection With 'user Not Associated With A Trusted SQL Server Connection' Message
Jul 10, 2007When using jdbc with IntegratedSecurity, I run into this problem when the machine is not part of a domain & gets its IP address via dhcp. Is this expected behavior or a bug in the jdbc driver.
The SQLServer and client application are installed on the same machine and a local admin is logged in, running the client app.
If I change one of the two parameters mentioned above, the connection can be established leading me to believe this may be intentional for security issues. Am I correct?
Unix, Windows For Unix, And Direct Read Of .mdf File This Is A True Story
Sep 13, 2007First, let me start by saying I know the answer to this, but due to politics any answer I give will be viewed with some disdain and disbelief.
A Unix/Network [rtdpmin one our sister agencies is trying to solve a problem that really does not need to be solved, but ....
The sister agency uses Information Builder's WebFocus on Unix. When they try to read my data warehouse in SQL Server 2000 it times out on them (on their end and they claim they cannot fix it) (This is using the supplied WebFocus ODBC/JDBC driver for SQL Server). This has lead to accusations of us not letting them read the data.
After much gnashing of teeth over "if you do data and data analysis for a living, why do I have to show you how to set-up an ODBC connection" we have shown them how to connect to the data, read it, and transfer it using MS-ACCESS, EXCEL, and more importantly SPSS. This is not good enough because they cannot figure out how to put it into WebFocus.
Their network person has come-up with the brilliant idea of reading the .mdf directly by installing Windows for Unix on the Unix side and then just pointing to the .mdf file and "reading it ".
Unless I have missed something somwhere (I will admit possible), I know you need a driver to read MS-SQL and that driver in every example I have seen could care less about the physical location of the .mdf file. It wants to know what database, what server (ip or name) and what security/login to use.
Could someone give me a more "technical answer" or even Microsoft's party line so I do not have this person mucking around with my production server trying to acomplish the impossible.
Connection Between SCO UNIX And Microsoft SQL Server 7.0 Using BCP(sisql)
Jun 8, 1999Hello,
I am trying to connect to a Microsoft SQL Server 7.0 from a SCO box (version 3.2v4.2)using sisql/bcp (sybase product). I can connect to a 6.5 database but when I try the same script to connect to 7.0 I get the following message: DB-LIBRARY error:
Unable to connect: SQL Server is unavailable or does not exist.
Is there anything I can do in order to fix this problem? Any ideas?
Thanks
How To Create UNIX Format Files Using Flat File Connection Manager?
Dec 17, 2007Hi All,
How to create a text file in UNIX format using Flat File connection manager. By default when we create a connection manager for flat files it is taking "CRLF" as the delimeter.
I beleive the format of the file will be decided based on the control line feed character at the end of each row. There are different control line feeds for different operating systems.
CR - Mac OS (Carraige return)
LF - UNIX (Line Feed)
CRLF - Windows. (Carriage return Line Feed)
Correct me if i am wrong.
Thanks in advance.
Not Associated With Trusted Sql Connection
Jul 4, 2007I have a Web application in asp.net 1.1Iam using windows authentication. The application is on IIS on MachineA. When i try to access this from MachineB as http://MachineA/test/test.aspx, it gives me the error "login failed for user 'null' : not associated with a trusted sql connection"Both MachineA and MachineB are on the same domain & iam not using any sql authentication. Could someone suggest me where i might have gone wrong. Web.config has authentication as 'windows', allow users = "*" and Identity impersonation = trueOn IIS, the vitual directory of 'test' application has Directory secuirty set to 'Integrated Security'Please let me know if someone had dealt with similar scenario. Thanks.
View 2 Replies View RelatedTrusted SQL Connection
Nov 1, 2004Hello,
I keep getting this error when I try to connect to my SQL Server:
"Login failed for user ''. Reason: Not associated with a trusted SQL Server connection."
I've tried to use both methods of logging into the DB (integrated security and using a SQL username and password).
Anyone have any idea on how to fix this?
Dale
Not Trusted Connection???
Mar 8, 2005i had try to use the following comand to login msde server
osql -U sa -P ****
and it reture the following:
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server
connection.
how can i fixed this problem,and i really want to use command line to maniuplate msde server
Trusted Sql Connection
Jul 3, 2001Hello,
I have just installed MSSQL 2000 on Windows 2000. what I am finding is that I cannot open an isql (or query analyzer) session using the sql login (i am successful when i use NT authentication). The error message I get is as follows
Msg 18452, Level 14, State 1:
Login failed for user 'xxx'. Reason: Not associated with a trusted SQL Server
connection.
DB-Library: Login incorrect.
MSDN talks about setting the registry entries differently, but that seems to be only for SQL 7.
anybody have any hints about this.
Trusted Connection
May 12, 2000Can anyone please tell me how to create a trusted connection?. I am from Unix world and NT is still kind of new to
me. Let say my SQL server is located in this machine residing in domain X and I want a NT user, ABC, who is in
domain Y to have acess to my server. What do I need to do?. Many thanks.
Trusted Connection
Dec 11, 2001Can anyone please advise me on how to set a sql7.0 and sql2000 server having trusted connection. Appreciate your help"""
View 1 Replies View RelatedNon-trusted Connection What Does It Mean?
May 5, 2004What does it mean when a users is connected but it is a "non-trusted connection". This is showing up in the log file after my users connect. How does this effect the system/user? We have been experiencing speed issues and I was wondering if this might be a possible source of the problem.
Thanks in advance.
Trusted Connection
Jul 20, 2005Hi-Is it possible to do a trusted connection for a web server not onthe same physical machine. By this I mean can I make a remoteconnection from a web server to a sql server using a trusted connection.If so, how?Thanks,Dave
View 2 Replies View RelatedHow Do I Specify A Trusted Connection?
May 18, 2006I'm trying to get a utility to run, and it's insisting on a user or trusted connection. I'm using SQL Server 2000 running locally. I've tried every login name, default, user I can think of but it rejects all of them.
What should I use for "trusted connection"?
Trusted Connection From VPN
Dec 15, 2007
Hello,
I have an application we use here at work that I wanted to bring home to work from my house. At work I can get the application to connect to the SQL Server without problems. At home I get:
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
I am connected to the office using a VPN connection. I have permissions to access the database (I am the server admin). It only happens when I connect thru VPN. I have tried it on 2 other systems here in the house to insure its not just my computer.
At the moment the application will only work with a trusted connection or Windows Authentication. It will not work with SQL authentication.
Any ideas?
Thanks!
Connecting Using A Trusted Connection
Jun 29, 2006Hello,
I appologize if this is in the wrong spot, but it seemed like the appropriate place.
We have IIS installed on one box and SQL on another. We use a trusted connection to connect.
When we try an connect to our DB, we don't get an error, the page just refreshes. From what i have gathered, it looks like we are not being authenticated. We have the ASPNET domain user on both boxes and its configured with the correct permissions, but we still can't connect.
Do i need to set up or give permissions to another account i dont know about, or is there some file that needs access?
Trusted SQL Server Connection
Jul 4, 2006Hi 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??
Not Associated With A Trusted SQL Server Connection (Please Help)
Apr 2, 2008Hello 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
Not Associated With Trusted SQL Server Connection
May 22, 2008Hi 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.
Trusted Connection Problems
May 30, 2004Hello everyone,
I am trying to use a trusted connect to connect to a DB. Currently I use this code:
WindowsPrincipal wp = (WindowsPrincipal)HttpContext.Current.User;
WindowsIdentity id = (WindowsIdentity)wp.Identity;
// impersonate user to connect to DB
WindowsImpersonationContext impersonatedUser = id.Impersonate();
try
{
connection = new SqlConnection("Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=DBname;Data Source=server;Packet Size=4096;");
dataAdapter = new SqlDataAdapter("select query");
data = new DataSet();
connection.Open();
dataAdapter.Fill(data);
connection.Close();
}
finally
{
// restore our old security context
impersonatedUser.Undo();
}
I am testing the app with my user which has full access to the server and database I am trying to connect to. But I always get this error:
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Now I'm new to this and not sure if I am going about it correctly, so any help would be appreciated. I just want it to use the ID of the person viewing the page to login to the server.
Thanks,
Luke
Not Associated With Trusted Sqlserver Connection
Aug 14, 2004i was got this error when i am trying to connecting to my local sql server
any one to help me how i can do to solve this problem
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~
Login failed for user 'ASPNET'. Reason: Not associated with a trusted SQL Server connection.
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~
Not Associated With A Trusted SQL Server Connection
Sep 10, 2005Hi,
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
Trusted SQL Server Connection
Nov 16, 2000Two 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.
Not Associated With A Trusted SQL Server Connection
Mar 12, 2001Hi
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
Obtain Trusted Connection ?
Feb 2, 2006Hi all!
I have a new computer, clean, I installed WinXP, and I want to connect a SQL Server (other computer in the same network)
For this I installed the client tools from SQL SERVER 2000 kit. Ok.
When I try to connect to the server, I can't connect through "trusted connection", only whit user name and password.
I mention that I set the sql server in mixed mode autentification.
When I try to connect from other computer (my laptop, or other computer from this network) I can connect both types of connection: trusted and with
sa (for example)
The question is:
How I can set up a "trusted connection" at SQL Server?
The computer is completely new, clean and has win xp with sp2.
Any opinion are considered.
Thanks in advance.
koci.
SQL Server And Trusted Connection
Feb 26, 2002I 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.
Obtain Trusted Connection ?
Feb 2, 2006Hi all!
I have a new computer, clean, I installed WinXP, and I want to connect a SQL Server (other computer in the same network)
For this I installed the client tools from SQL SERVER 2000 kit. Ok.
When I try to connect to the server, I can't connect through "trusted connection", only whit user name and password.
I mention that I set the sql server in mixed mode autentification.
When I try to connect from other computer (my laptop, or other computer from this network) I can connect both types of connection: trusted and with
sa (for example)
The question is:
How I can set up a "trusted connection" at SQL Server?
The computer is completely new, clean and has win xp with sp2.
Any opinion are considered.
Thanks in advance.
koci.
Not Associated With A Trusted SQL Server Connection
Feb 11, 2004I 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
Trusted SQL Server Connection
Mar 29, 2006Please suggest the error message: "Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection
regardz,
sAm
Problem With Trusted Connection (asp.net)
Nov 15, 2006I am getting the following error when trying to access a database witha trusted connection:"Login failed for user '(null)'. Reason: Not associated with a trustedSQL Server connection."My connection string is:"Server=MyServer; Database=MyCatalog; Trusted_Connection=True;"Note that Anonymous Access is off in IIS, and I am able to read myWindows login with:Textbox1.text =System.Web.HttpContext.Current.User.Identity.Name. Substring(System.Web.HttpContext.Current.User.Iden tity.Name.IndexOf("")+ 1).ToLower()Can anyone explain how to query the db using a trusted connection?PS Is there a way to dynamically retrieve a list of databases thecurrent user has SQL rights on, by specifying only the server, againusing trusted connection?Thanks...
View 3 Replies View Related