I have a certificate file that was supplied to me by my FTP provider.
What are the steps I need to use the cetificate for authentication?
I would appreciate some sample in C#.
Thanks in advance.
View Complete Post
I'm running the above mentioned version of Sharpoint on Win2003 server. I had to change domain admin password and now my Sharpoint doesn't work. I have manually changed all the passwords for Sharpoint services using domain admin account and also
in IIS but with no success. In the event manager there is buch of error messages mostly refering to bad password or user name during logon. What am I missing?
SQL Server Express 2008, on a standalone XP Pro fully updated, with a named instance of COMPUTERNAME\SQLEXPRESS.
As installed, the 'log on as' was set to NT\NETWORK SERVICE. Basically things worked, though I had some issues, now irrelevant. Foolishly I went into SQL Server Configuration Manager, clicked on SQL Server Services, in the right pane right-clicked on Sql Server (SQLEXPRESS) - Properties, on the logon tab -ÃÂ Built-in account, which showed Network Service.
From the dropdown, I selected Local Service and probably Apply, then Start, though maybe vice versa.
This stopped pretty much everything working, e.g. no access via Managment Studio etc (cannot login). Now if I attempt to select Network Service from the dropdown to put it back to what it was:
- If I click Apply I get a message box : Cannot find object or property [0x80092004]
- If I click Start there is a long wait while the progress bar ticks over, then a message box with 'The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details'
In the logs folder the log starts with informational stuff that looks to me to be pretty
I get the below erro in the event logs from MSSQLSERVER.
Error: 60000 Severity: 16 State: 1 SQL Error Log:  Logon to server (local) failed (ConnUpdateStartExecutionDate)
No idea if it is related to high memory utilization of SQL Server.
How to get rid of it.
SQL Server 2008 Enterprise.
When I tried to logon this morning I couldn't logon. I had no problem until this morning. What do I do to fix this?
TITLE: Connect to Server
Cannot connect to ABCD123.
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider:
Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476
Thank you in advance.
In the event log of my SQL server I get this error every two minutes:
"Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: <local machine>] Error 18456, Severity: 14, State 16"
I have spent alot of time Googling and reading through this forum but to no avail. I ran a trace according to this site: http://www.eraofdata.com/blog/2009/01/, but I am not able to find anything that seems related to the problems I am experiencing. The
few events created by NT AUHTORITY\SYSTEM are of the class SQL:BatchStarting and SQL:BatchCompleted.
The first event says this:
and the second event this:
Should instancename be the name of the server? What is the next step to troubleshoot this problem?
I need to capture the logon event and set some options (SET DEFAULTS, SET ANSI_NULLS, etc) and those options should be set that way during all the user's session. I thought a server trigger for logon would do it, but I found out it runs
BEFORE the user's session begins, so it does not do the job. I need to set the options
only for certain users of an application I don't have the code for.
I also read it could be done using alerts and auditing, but I'm not sure how. I would appreciate any suggestion.
Hi, Kerberos seems to be malfunctioning with SQL2008R2.
I have a new dev SQL2008R2 server called BDSDEV2 and an upgraded(in-place) SQL2008R2 server BDSTEST2.
From BDSDEV2 , I can successfully issue a linked server query to BDSTEST2
select * from bdstest2.eis_prod.dbo.wcs_agent
But from my client in SSMS, connected to BDSDEV2 , the double hop is failing to BDSTEST2 for same query
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
I have another BDSDEV1 server, which is SQL2008 and there double hop IS WORKING
From my client in SSMS, connected to BDSDEV1 ,I can successfully issue the query to BDSTEST2 .
The service accounts for MSSQLSERVER are both local admins on their servers and sa's
I have confirmed SPN is OK
This is from BDSDEV2 - sql2008r2 server.
C:\Program Files (x86)\Resource Kit>setspn -L tsqlssvc
Registered ServicePrincipalNames for CN=TSQLSSVC,OU=SvcAcct,DC=corp,DC=saif,DC=c