.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

Login SQL Server with Dynamic Code and block SSMS remote connection

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :
 

Dear all,

- Can we configure SQL Server login integrated using Dynamic Code (TOKEN) ?

As far i know , we can use Dynamic code / Token with Login Windows, but i dont know about Token/Dynamic Code with SQL Server login.

- and can we block SSMS Remote connection, so we cannot connect using SSMS /Query analyzer to the server. The only way is local connection.

thanks in advance

Our Environments :
-SQL Server 2K8EE integrated with LUna HSM & RSA

-Win Server 2k8EE

 


Regards, Mathias.Arya


View Complete Post


More Related Resource Links

Server failed with error code 0xc0000000 to spawn a thread to process a new login or connection

  
Hello All, Suddenly, the sql server is down, in the log file, C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG, I found the record as follows, 2007-03-05 15:40:31.59 Logon       Error: 17189, Severity: 16, State: 1.2007-03-05 15:40:31.59 Logon       SQL Server failed with error code 0xc0000000 to spawn a thread to process a new login or connection. Check the SQL Server error log and the Windows event logs for information about possible related problems. [CLIENT: 172.21.123.48] What else I can do to further investigate? Thanks Spencer

Remote Connection to SQL Server 2008

  
Hi everyone,    I'm allowing remote connections, have started the SQL Server Browser, and have the TCP/IP protocol enabled for my server instance, but I still can't connect to my SQL server remotely.   I have my router forwarding to the local IP for it when using port 1433 and it works when I put the router ip with 1433 locally, but it gives me an error when I try this remotely. It throws a timeout error, so it isn't even reaching it.   Any suggestions?

Linked Server Mapping Error "Access to the remote server is denied because no login-mapping exists"

  

SQL Server 2005 SP3 32bit server
Connecting to an Oracle 10g server
Loaded OracleClient 10g

I'm able to ping the Oracle Server, and ODBC connect and able to run an open query with a single remote user id.

Issue: When I use the security context "Be made using this security context" it connects.
When I choose the "Not Be Made" WITH THE SAME USER ID & PASSWORD, I get the mapping error.


what the configuartion to Enable Remote Connection on SQL Server 2008

  

I have  server and I install windows server2003 With sqlserver 2008

and I have Application with vb.net2008  and i want to make connection between the application and sql server 2008

wht Is steps to make them>>>>??


Remote Connection Of SQL Server 2000

  

Hi All,

Am creating a C# Windows Application. Am using SQL Server 2000 as my database. I have created a setup for my application. I have to install the application in some computers connected through WORKGROUP. Now am installing my application in a client machine which doesn't have any SQL Server or Visual Studio. After installing i need to configure the App.Config to set the ConnectionString. How can i do this? 

 

This is my connection string after installing. How can i modify this to access remote sql server?

 

<add key="ConnectionString" value="Password=sa;Persist Security Info=True;User ID=sa;Initial Catalog=Fahd;Data Source=(local)"/>


how to enable remote Connection sql server 2008

  

Hi

I've just installed sql server 2008 on a vista server, unfortunately I forgot to enable remote connection when I was installing it. As I need this feature really I tried to enable I but "Surface Area Configuration" of sql 2005 seems to be vanished in this new version. Despite  I searched like 2 hours, I couldn't find any useful solution,  interestingly all the results are either nonsense or related to 2005 version.

Please me what the hell should I do and I believe many people will use your answer!

Thank you in advance


The underlying connection was closed: Unable to connect to the remote server.

  

Hello,

 

I get this error message when i kick off my web service to run. It gathers survey feedback from a database via http soap. Recently i put in a proxy that is required for access to internet. The web service started to fail that day as well. Can anyone tell me how i could hard code the proxy that should be used by the web service? I found this link: http://support.microsoft.com/kb/307220

and tried editing the machine.config file but that didn't fix my issue. Any Ideas?

 

Error:

 

8/2/2007 1:02:25 PM
The underlying connection was closed: Unable to connect to the remote server.
   at System.Net.HttpWebRequest.CheckFinalStatus()
   at Syst

Sql Server 2008 logs Authentication mode incorrectly avoids remote login

  

Im trying to connect SQL server 2008 Express R2 installed on XP sp3 pc through ODBC SQL Server driver with a Windows 7 PC. I managed to define static IP ports and setup firewall. Now the ODBC connection successfully gets created by accepting uid : sa and my password given.

Now Im getting "login failed for user ". " msg from my application. When I run the same application with same ODBC connection created in the SQL server PC it works fine. The two pcs operate in a workgroup.

Following  is the error log. Im surprised to note that the server logs its in Mixed mode initially and later makes a cry that its in Windows Authentication mode. !!!!

010-07-25 15:19:53.76 Server      Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86)
    Apr  2 2010 15:53:02
    Copyright (c) Microsoft Corporation
    Express Edition with Advanced Services on Windows NT 5.1 <X86> (Build 2600: Service Pack 3, v.3311)

2010-07-25 15:19:53.76 Server      (c) Microsoft Corporation.
2010-07-25 15:19:53.76 Server      All rights reserved.
2010-07-25 15:19:53.76 Server      Server process ID is 3552.
2010-07-25 15:19:53.76 Server      Auth

How to wirte the connection code and cofigure SQL Server to use the programe in internet.

  

Hi

I am a bigner

i am using sqlserver 2008

in my computer, sql server name is "LOCALHOET-PC" AND SECOND ONE "LOCALHOST-PC\SQLEXPRESS"

I have write a code in my software like

 

SqlConnection conn;

conn = new SqlConnection("Data Source=LOCALHOST-PC;Initial Catalog=n4netsALT;Integrated Security=sspi");

conn.Open();

 

 

and it is working working smoothly in my computer

MY DOUBT IS

IS THIS CODE WILL WORK IN INETRNET?

OR I SHOULD CHANGE MY SERVER NAME TO SOMTHING OTHER?

PLEASE REPLY ME?

RUPESH B S


How to wirte the connection code and cofigure SQL Server to use the programe in internet.

  

Hi

I am a bigner

i am using sqlserver 2008

in my computer, sql server name is "LOCALHOET-PC" AND SECOND ONE "LOCALHOST-PC\SQLEXPRESS"

I have write a code in my software like

SqlConnection conn;

conn = <

Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

  

I have been using my workstation on a Windows 2000 SQL Server network for several weeks without any issues. I am using Activant Prophet 21 accounting software along with MS Office 2010 Professional on a Windows 7 Ultimate platform. I recently upgraded to the new Windows Live. While working with Access today, I suddenly lost connection to the server (also my internet server). I received the following message:

Unable to connect
SQLSTATE = 42000
Microsoft OLE DB Provider for SQL Server
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.


Potential Reasons:

1. Invalid User Name 

2. Invalid Password

3. Invalid Server Name

4. Invalid Database Name

 Any suggestions?

P.S. I am able to access the SQL Server using my user name from a different (Window XP) workstation (i.e. database functions and internet access)

 


Login failed for user ''. The user is not associated with a trusted SQL Server connection.

  
First at all, My name is Yuri.
I have a problem with SQL server 2005 when I want to select data from sql server database on another machine and then insert data to local sql server 2005 database. And I Have checked that authentication mode for both sql server database is mixed mode.
If anybody can give suggestion for my problem, many thanks before.

Best Regards,


Yuri  

Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

  

I am receiving the following message when connecting via query analzyer to SQL server using windows authentication.(error 18452). I have a login created with the sys admin server role on the server. When I connect using SQL authentication it works.

I added myself to the local admin group on the server, this allows it to work. The same situation is seen with another user.

I am using windows 2000 sp4 server and SQL 2000 SP3, connecting from NT4. I get the same issue if I use TCP or named pipes. We have been using SQL security but are moving to windows authentication - but this issue is stopping us.

I have checked and upgraded my version of MDAC to match the server version 2.7 (sp1)


Any help would be much appreciated.


Thanks

Ian


CommunicationException was unhandled by user code;The remote server returned an error: NotFound

  
Hi ,

Getting an err :CommunicationException was unhandled by user code;The remote server returned an error: NotFound.

scenario:

1. we are sending large amount of data from Silverlight client to wcf svc and storing in DB.
2. when the data size is less its working fine.
3. But when we send large data we get an err like

CommunicationException was unhandled by user code

The remote server returned an error: NotFound

4. we also increased the Buffer Sizes in the binding part in the config files.


most of the google results , forums are saying to increase the Buffer Sizes, but still we face the same proble.


Any clues on how to overcome this err will be a gr8 help!

Thanks
Senthil

http://dotnetcrunch.blogspot.com


how to enable remote Connection sql server 2008

  

Hi

I've just installed sql server 2008 on a vista server, unfortunately I forgot to enable remote connection when I was installing it. As I need this feature really I tried to enable I but "Surface Area Configuration" of sql 2005 seems to be vanished in this new version. Despite  I searched like 2 hours, I couldn't find any useful solution,  interestingly all the results are either nonsense or related to 2005 version.

Please me what the hell should I do and I believe many people will use your answer!

Thank you in advance


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

  

I have two SQL 2000 Server. Both server needs to communicate with each other. The setup was working for last 8 month. Last week, we disconnected the server 2 from the network and then we reconnected the server 2 again. Now when we tried to call StoredProcedure of Server 2 from Server 1 we get the following error:

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

This used to work.

However if we call storedprocedure of server 1 from server 2, it works just fine.

This is an old problem and this problem has been answered several times. The problem is none of them are working for me.

The main solution that has proposed is that I should set login option to Mixed Mode. My authentication mode has been set to mixed mode, I have also checked the registry and that's ok too. What I can't get what used to work and now it doesn't.

 

I am completely lost.



Login failed for user 'sa' .The user is not assosiated with a trusted SQL Server Connection.

  

Dear Friends,

                   I have downloaded a project from

http://www.c-sharpcorner.com/Tutorials/Building3TierAppPA.asp

 

 ,which is an example of 3 tier architecture.

To run this project the author has suggested to change the 'value' in <appsettings> of webconfig file.

previously it was

 <add key="SqlConnect" value="ABRAHAMOS;database=TimeManagement;uid=sa;pwd=moses;" />

I changed it to

 <add key="SqlConnect" value="server=ABC-314FF72122C\SQLEXPRESS;database=TimeManagement;uid=sa;pwd=moses" />

as 'ABC-314FF72122C\SQLEXPRESS'  is the server name of my sqlserver 2005.

when i run the project and try to enter something from a page then error occur as  'Login failed for user 'sa' .The user is not assosiated with a trusted SQL Server Connection.'

what could be the possible reason?????????

 

Till now I have tried following things:

1. I kept the pwd value blank and tried to run-------- then also the same problem

2.   I kept the pwd value .(dot) and tried to run-------- then also the same problem

3.   I tried to chan

Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend