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


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

Why does the following MakeCert produces CA and Server certs that are never trusted?!?!

Posted By:      Posted Date: October 26, 2010    Points: 0   Category :WCF
 

 

Other than the minor(!) fact that it doesn't work, the following is a neat little bat script I wrote last night that was  intended to make it easier to set up and test wcf connections over ssl...

But something is not right with the switches. IE can accept them, but SVC doesn't like them much-- nor does Chrome or Firefox.

 

Could someone spot the switch I've left off?

thanks ever so much.

echo off
echo.  
echo **********************************************************************
echo *** WARNING: This script is intended for devs with only ONE machine.
echo.
echo This script
echo - deletes local cert artifact files from the current dir
echo - removes old Certs from the localmachine store 
echo - makes a new CA cert
echo - intalls CA cert in ROOT store
echo - uses CA cert (+ local CA pvk) to make a new Server cert
echo - installs Server cert in MY
echo - uses CA cert (+ local CA pvk) to make anew Client cert
echo - installs Cleint cert in MY
echo - copies Client cert to TRUSTEDPEOPLE of 'server'
echo  so that server can recognize client certs sent for mutualSSL,etc. 
echo - See: http://bit.ly/abFEhh
echo **********************************************************************
echo.
SET /P NEWCA=Step 1.: Build new Root Certificate Authority (CA)?
if /i 


View Complete Post


More Related Resource Links

Moving SharePoint Database to non trusted domain SQL server

  

Hi,

We have SharePoint and SQL server in a extranet domain. We would like move the SQL server databases for SharePoint to our corporate SQL server (on the corporate domain). 

The Corporate domain does not trust the extranet domain, and thus the web farm account cannnot be specified on the corportare SQL instance. If it possible to migrate the databases to a non tusted domain?

I've seen the script to create a new Config database using SQL authentication

psconfig -cmd configdb -create -server <SQL server name> -database <database name> -dbuser <SQL account> -dbpassword <SQL password> -user <AD user account> -password <AD user password>

Can I edit the config of SharePoint to point to the new SQL server, or do I need to create the entire sharepoint enviromnent again and attach the content databases?

I also have a SSP database that's heavily customised for searcvhing and the BDC. Will this need recreating again or can I move the BDC database  to the new server and attach?


Thanks,


Error 18452 (not associated with a trusted sql server connection)

  

Using sql2005 on a Novell network...

When attempting to log into Mgt Studio using windows authentication I am getting the error: Error 18452 (not associated with a trusted sql server connection) .

I added my domain\userName in sql with no problems and added the account to the sysadmin server role.  However, I noticed my credentials on my pc are not listed as domain\userName but rather ComputerName\UserName.  I think this is what is causing the problem but I am not sure.  Can anyone lend a hand?

I'd appreciate any help,

Thanks.

Scott


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)

 


Difference in the trusted and non trusted connection in SQL server 2005

  
Dear All,

Was just looking at the SSMS log of production server, and found  there are so many records of “connection: non-trusted”, I don’t remember we had these before.

What is the difference between trusted and non-trusted connections.

Thanks,
Gangadhar

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  

Which Domain Controller is SQL Server using for trusted windows authentication?

  

We are migrating from Windows Server 2003 domain controllers to Server 2008 Domain controllers.  I want to be able to know which domain controller a SQL server is using for authentication, so I can verify that the 2008 Domain Controllers are working, before we take down the 2003 domain controllers permanently.

I also read something about possibly setting a preferred DC?

Please advise

 

 


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


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

call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side.

Making Ajax Callbacks to the Server Using jQuery with ASP.NET

  
In the first part of this article series I introduced jQuery's functionality and how it provides a rich client side programming model. This time around I'll expand on these concepts and show you how you can use jQuery in combination with ASP.NET using it as an AJAX backend to retrieve data. I'll also discuss how you can create ASP.NET controls and otherwise interact with jQuery content from ASP.NET pages in WebForms.


jQuery is just a JavaScript library so it will work seamlessly with ASP.NET both from page code as well as through backend driven code using the Page.ClientScript object or ScriptManager. You can use jQuery on its own as a client side and Ajax library that communicates with ASP.NET or you can use jQuery in combination with ASP.NET AJAX. The two actually complement each other quite well as jQuery provides functionality that the ASP.NET AJAX library does not and vice versa. For the most part the interaction between the two libraries is trouble free except for a few very rare edge cases.

MS SQL Server: Disconnect Users From Database - Kill User Session

  
If you ever wanted to restore your database from a SQL backup file (.bak), but there are still users connected to your database, the backup operation will fail causing the error: Exclusive access could not be obtained because the database is in use.

MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

  
If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.

call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side

Publishing SQL Server Database using Publishing Wizard : Tips & Tricks

  
We can use SQL Server Publishing Wizard to deploy our local Database to remote hosting server/production server.This feature is available in SQL Server 2008/VWD 2008.

Below is the complete step by step guide of this process.

CLR Integration With Microsoft SQL Server

  
Transact-SQL provides as much flexibility as possible but, because it is not a real programming language, it has some shortcomings about many issues (memory management, exception handling, debugging, file processing (or streaming), object-orientation (classes), or thread management). Transact-SQL also lacks features of normal libraries (arrays, collections, serialization, expressions, or string manipulations, etc).

IP Address Blocking or Restriction in SQL Server

  
"is it possible to block connections to SQL Server based on IP address". As far as now there is no official way in SQL Server to block the connections in SQL Server based on IP address. However this can be done from the OS end, we have the following three options available, refer HERE for more.


.Firewall
.IPSec
.RRAS IP Filter
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