Connecting To SQL Server 2005 Using Windows Auth/Cannot Generate SSPI Context Error

Jan 3, 2008

Hi-
I have a program that I am developing on a laptop, then deploying it on a server.
I have the prgram running passing a username and PW in the connection object, but like the idea of using windows authentication MUCH better.
I just joined the domain, so I am domain/me for example.
If I log into the server, and look at securities, logins and added domain/me to the logins.
I then try and set up a sql connection via both visual studio, and sql server magt studio, and get the dreaded "Cannot generate SSPI context" error.
 
Anyone else have this problem? SHOULD V.S. be using domain/me to connect?
 
TIA
 
dan 

View 6 Replies


ADVERTISEMENT

SSPI Error '-2147467259 (80004005) Cannot Generate SSPI Context

Sep 14, 2007

We are runnig Windows server 2003 R2 and SQL Server 2005 Standard on the same computer.

We have workstations that log into our domain with Windows Authentication. The software loads just fine and then later up pops the error noted above.

Any help you can give me is greatly appreciated.

Thanks
Paul

View 1 Replies View Related

Cannot Generate SSPI Context. (Microsoft SQL Server, Error: 0)

Apr 20, 2007

Hi,

I am working on sql server 2005 .

when I am trying to connect to server:



following error is occuring:



TITLE: Connect to Server
------------------------------

Cannot connect to servername

------------------------------
ADDITIONAL INFORMATION:

Cannot generate SSPI context. (Microsoft SQL Server, Error: 0)



Could any one help What might be the problem ? for this ?



Thanks,

Ramki

View 1 Replies View Related

Connection Error: Cannot Generate SSPI Context

Nov 11, 2007

hi,
While trying to connect to SQLSever 2000 or SQLSever 2005 from a vb.net application ,
a user is getting the error "Cannot generate SSPI context" while other users
can still connect to the server.
and moreover, this user were able to connect before.
and if he restarts his computer, then try to connect after a lap of time, it will connect.
but if he waits and opens other applications,and then tries to open the application,it will not work.

so how to resolve this problem?

Regards,

View 3 Replies View Related

Urgent Help Needed !!! Cannot Generate SSPI Context Error

Dec 12, 2006

Dear Sir,

I tried installing sql server using mixed mode authentication but i am constantly receiving a error as follows and its getting shutting down


A connection could not be established to AICRR

Reason :Cannot generate SSPI context

Please verify sql server is running and check your sql server registeration properties(by right clicking on the AICRR node) and try again.


Please give me the resolution as soon as possible.

Regards

Arif

View 1 Replies View Related

SQL 2012 :: Cannot Generate SSPI Context Error When Password Changes

May 22, 2013

I regularly (every month or so) get the error "The target principle name is incorrect. Cannot generate SSPI context" when trying to remotely connect to my SQL 2012 instance. The SQL service is running using a managed service account. I understand this error can occur when the service account cannot authenticate with AD properly. Looking at the properties of the managed service account, the password for the account was automatically changed this morning - just when the error started.

View 9 Replies View Related

Windows Authentication - Cannot Generate SSPI Context - Login Failed For User ''. The User Is Not Associated With A Trusted SQL

May 29, 2007


We are looking at developing an SQL Server 2005 Database and I would like to use Windows Authentication rather than SQL Server Authentication to connect our client app.

In our development environment, we have two Servers, one being used as a file server and the other as an SQL Server. We have now set up a domain using the file server as the domain controller. (We had previously been set up to use a workgroup).

I have set up an active directory group called SqlDevelopers and added an active directory user called Jonathan to it.

On the SQL Sever, in management studio, I have set up a new server login which uses windows authentication called DomainSqlDevelopers. I used the GUI to verify I could see the domain and the group.

The default database is set to a test database on the server. A user in the test database is mapped to the DomainSqlDevelopers and given the Roles dbo, db_datareader, db_datawriter.

To test the log in, on the server, I logged out as administrator and in as Jonathan. I could successfully access the server through management studio using windows authentication.

However, if I log in as Jonathan on my client PC and try to access the SQL Server using management studio and windows authentication, I have problems.

The first time I try I will get a timeout error. If I try again will get either:

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

Or

Cannot generate SSPI context

I can€™t determine any pattern to which of the above errors I get.

However, if I log in as administrator on my client PC, I can connect to the server using management studio and windows authentication.

Sounds like Active Directory/Domain or other Network issue (Not really my area). I would be grateful for any help.

Thanks,

Jon

View 9 Replies View Related

SQL Server 2008 :: Cannot Generate SSPI Context

Jan 27, 2015

Our end users is getting below error, when they try to connect to our database:

"Cannot generate SSPI Context."

That is Windows based application and we have done everything like restart our DB Server , reinstall exe in users system, but still issue is same.The issue has occured from when DB Server has restarted and at the same time few users are connected. before that it was working fine. we could not find what is issue.

View 1 Replies View Related

Please - OLE DB Provider For SQL Server (0x80004005) Cannot Generate SSPI Context

Dec 7, 2005

Please can anybody help me in fixing this error I am getting on ASP page while accessing ASP database page using an SQL server database.

View 4 Replies View Related

Cannot Connect To Server Through Ssms - Cannot Generate Sspi Context

Aug 1, 2007

Hi,

I have gone through so many kb articles to understanding the problem, but no luck as yet.

Here is the situation:

I have two dev servers : Server A and Server B. Both are set up in an identical fashion. Windows 2003 sp2, Sql Server 2005 sp1 Developer Edition, both are on the same domain, Both have all the three protocols enabled: Shared Memory, Tcpip, and Named Pipes in that order. I can ping both servers, and telnet using the default port. Both have only default instances. Both use the same domain user account for sql service. Both have the error in the log saying that spn could not be registered so authentication may fall back to NTLM.

Here is the issue: When I try to register Server A specifying tcp-ip connection, I am successful and I can see that the authentication is NTLM - is as expected. since the spn registration did not happen and since the sqlservice account is not a domain admin, the authentication used NTLM over tcp-ip. However, I try to register Server B specifying tcpip, I get a cannot generate sspi context error. Why did the authentication not fall back to NTLM as in Server A? From what I read in the KB articles, I asked our network admin to check up the spn, but he assures me that spn were never manually registered.

Can somebody throw more light on this issue?

Thanks
KRSE

View 1 Replies View Related

Cannot Generate SSPI Context

Sep 21, 2004

I was trying out the Building an End-to-End Application (VB.Net) exercises on Web Matrix Guided Tour and encountered the mentioned errors. Please help. Thanks.

The code is as follows :

<%@ Page Language="VB" Debug="true"%>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.SqlClient" %>
<script runat="server">

Sub Page_Load(Sender As Object, E As EventArgs)
Welcome.Text = "Hello, " + User.Identity.Name
If Not Page.IsPostBack Then

' Databind the master grid on the first request only
' (viewstate will restore these values on subsequent postbacks).

MasterGrid.SelectedIndex = 0
BindMasterGrid()
BindDetailGrid()

End If

End Sub

Sub MasterGrid_Select(Sender As Object, E As EventArgs)
BindDetailGrid()
End Sub

Sub MasterGrid_Page(Sender As Object, E As DataGridPageChangedEventArgs)

If MasterGrid.SelectedIndex <> -1 Then

' unset the selection, details view
MasterGrid.SelectedIndex = -1
BindDetailGrid()

End If

MasterGrid.CurrentPageIndex = e.NewPageIndex
BindMasterGrid()

End Sub

Sub BindMasterGrid()

' TODO: Update the ConnectionString and CommandText values for your application
Dim ConnectionString As String = "server='WRPBI'; user id='sa'; password='sa';database=MatrixOrders;Integrated Security=SSPI"

Dim CommandText As String = "select OrderID, OrderDate, CustomerName from Orders"

Dim myConnection As New SqlConnection(ConnectionString)
Dim myCommand As New SqlDataAdapter(CommandText, myConnection)

Dim ds As New DataSet()
myCommand.Fill(ds)

MasterGrid.DataSource = ds
MasterGrid.DataBind()

End Sub

Sub BindDetailGrid()

' get the filter value from the master Grid's DataKeys collection
If MasterGrid.SelectedIndex <> -1 Then

' TODO: update the ConnectionString value for your application
Dim ConnectionString As String = "server='WRPBI'; user id='sa'; password='sa';database=MatrixOrders;Integrated Security=SSPI"

' TODO: update the CommandText value for your application
Dim filterValue As String = CStr(MasterGrid.DataKeys(MasterGrid.SelectedIndex)).Replace("'", "''")
Dim CommandText As String = "select OrderDetailID, ProductName, Quantity, UnitPrice from OrderDetails where OrderID = '" & filterValue & "'"

Dim myConnection As New SqlConnection(ConnectionString)
Dim myCommand As New SqlCommand(CommandText, myConnection)

myConnection.Open()

DetailsGrid.DataSource = myCommand.ExecuteReader(CommandBehavior.CloseConnection)

End If

DetailsGrid.DataBind()

End Sub

</script>


And this is the compilation error :

Cannot generate SSPI context.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Cannot generate SSPI context.

Source Error:


Line 49:
Line 50: Dim ds As New DataSet()
Line 51: myCommand.Fill(ds)
Line 52:
Line 53: MasterGrid.DataSource = ds


Source File: C:WorksWebWISHDefault.aspx Line: 51

Stack Trace:


[SqlException: Cannot generate SSPI context.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +472
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +311
System.Data.SqlClient.SqlConnection.Open() +383
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38
ASP.Default_aspx.BindMasterGrid() in C:WorksWebWISHDefault.aspx:51
ASP.Default_aspx.Page_Load(Object Sender, EventArgs E) in C:WorksWebWISHDefault.aspx:14
System.Web.UI.Control.OnLoad(EventArgs e) +55
System.Web.UI.Control.LoadRecursive() +27
System.Web.UI.Page.ProcessRequestMain() +731

View 1 Replies View Related

Cannot Generate SSPI Context

Feb 5, 2007

All of a sudden I cannot connect to sql server from Visual Studio. Nor I can't conenct to Sql server through IIS and it gives me the same error saying "Login failed: Cannot Generate SSPI Context". Lots of my development projects got stuck because of the SSPI Issue. I know there was a network upgrade from Windows NT (users) to Active directory. I can only access the sql server from the host machine.if someone can guide or give me a quick run down on things to look for that would be wonderful.

View 2 Replies View Related

Cannot Generate SSPI Context

Jul 23, 2005

HiMy company uses a Windows 2000 server with MS SQL Server 2000.We have many clients with administrative software that use the MS SQLserver, the problem is that we experimented randomly the error"Cannot Generate SSPI Context" and the only way to work with DB is logout the client.I'm looking the MS Technical sheet but there's no resolving hints thatcan help.Anyone has a similar problem ?Thanks.

View 1 Replies View Related

Cannot Generate SSPI Context

Feb 6, 2007

Win Server 2003
SQL Server 2000 SP4
SharePoint Server

Win Server 2000 (Domain Controller / Active Drectory)

Clients: Win XP / Access XP

I have two clients that can access the SQL Server and one that can not. All clients can access SharePoint (SLQ Server Back end) and directories controlled by AD.

The one that cannot access the SQL Server errors: "Cannot Generate SSPI Context". I have verified:
1) date and time
2) occurances of Security.DLL (win/system32; program file/common files/AOL...; Service Pack Files/i386 (x2))
3) Not using cached credentials

we recently moved our network and did not change any settings on any of the computers. I read KB811889; those suggestions did not resolve the issue.

Please assist me in touble shooting this connection problem. Also, how does changing the SQL Server Port on the server affect SharePoints connection to its database?

View 1 Replies View Related

Cannot Generate SSPI Context

Jul 27, 2006

I have a SQL Server 2000 in a specific W2K server, that belongs to a domain that is administered by a W2003 server.

There is a client that has a new computer with WXP in the same domain. It used to have an old machine with W2K pro. and with the same user it worked OK.

When accesing SQL from the client with an Office2003 application via ODBC with windows authentication, after several minutes working OK, suddenly it gets this message:

Conection error. SQL state: S1000

Cannot generate SSPI context.

In the client I have executed cliconfg.exe and created a piped name protocol, but still it won't work.

View 6 Replies View Related

Cannot Generate Sspi Context

Jul 3, 2007

Howdy,

Firstly, I have read through so much information on this, that my eyes are starting to bleed and I am right at the end of my rope with it all..



This issue has only started showing since I re-installed my dev box, so my server has not changed at all..



Server is 2003 with SQL 2005.



Dev box is

Vista (Ultimate)

Visual Studio Pro 2005..



A quick but painful solution is for me to log out of my box and then back in, but this is unworkable at times... about the only difference I can think of this install from the last is that now I have also installed SQLExpress on the dev box. I have gone into services and made sure that the service does not start auto. I have connection to the server and am running as administrator on both until such time as I can sort this out, but the error still occurs.



Authentication for the dbase is both windows and credential.



Can someone please give me a stratight out solution for this.



Cheers



View 5 Replies View Related

Cannot Generate SSPI Context

Mar 12, 2008

I'm signing into a sqlexpress 2005 local server using windows integration and it fails with a "Cannot generate SSPI context". After 2 years of working with this, it just started to happen after I installed a new piece of software to test. My colleague thinks it hosed our domain names. I've read all the articles and most of them have to do with a non-local server. I also read that this is caused with TCP/IP so I disabled it for sqlexpress and tried again. Then I get "An error has occurred while establishing a connection to the server. When connecting to the sql server 2005, this failure may be caused by the fact that under the default settings sql server does not allow remote connections." I know I have remote enabled so that isn't true. If it uses VIA, "Login failed for user '(null)'. Not a trusted sql connection" or something like that. Anyway, I think something is hosed in my domain and my colleague fixed it by downloading some xp tool that he can't remember where it came from. Any chance anyone else knows about this tool?

View 2 Replies View Related

Database Won't Start In Cluster - Cannot Generate SSPI Context

Jun 2, 2006

Hi,
I have a MSSQL database running in a Microsoft cluster. I was working on troubleshooting for another SAP problem when they suggested I change the setting using hte SQL Server Client Network Utility to 'named pipes' from 'tcp/ip'. Every since, despite changing it back I'm unable to start the database in the cluster.

I'm kind of a newbie at this so I'd really appreciate any help in getting this database up and running.

Here is the error message from the event log:
sqsrvres] checkODBCConnectError: sqlstate = HY000; native error = 0; message = [Microsoft][ODBC SQL Server Driver]Cannot generate SSPI context

View 2 Replies View Related

Recovery :: Connection Failed Cannot Generate SSPI Context

Oct 26, 2015

I have 2 servers. On one server i install sql server 2014 and its working fine, i am able to get connected with sql with domain account.

From second machine i want to connect my sql server, for that i create udl file when i give sql server address and click refresh getting following error: Connection failed cannot generate SSPI context

Firewall is off, created fire rule too, i am able to get ping first machine by ip and servername but still getting issue.

View 3 Replies View Related

System.Data.SqlClient.SqlException: Cannot Generate SSPI Context.

May 24, 2007

Hi,



I am using .net 2 to connect to sql server 2005 - All works fine. When I move the sql server machine date forward (to test the application) the above message is returned.



Any ideas as to why this message is generated when I move the clock forward will be gratefully received.



Thanks



Pete Clements

View 1 Replies View Related

SQL Server 2005 And SSPI Context On XP

Jul 26, 2005

Hello,
I have an XP box with SQL 2k working without any problems.  I am trying to install SQL 2005 CTP April on the same machine. Installation goes fine, but when I try to connect, I am getting an error "Can not Create SSPI Context".   Why am getting this error ?  DOes the machine needs to be on a domain to get connected? If yes, is there a work around? Can I use mixed mode? WhereHow do I specify  password for sa?

View 4 Replies View Related

How To Change Windows Auth. To SQL Server Auth. In SSIS Packages

Apr 30, 2007

I had a few packages created with Windows Authentication which now needs to be migrated to run with SQL Server Authentication. I tried changing it in the connection managers but the packages failed to validate at the SCD transformations.For a few packages I had Configuration files for these packages where i tried to do it but it dint run giving the following Error Message:
[Connection manager "Target"] Error: An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E4D Description: "Login failed for user <<with my network id>>.".

[Execute SQL Task] Error: Failed to acquire connection "Target". Connection may not be configured correctly or you may not have the right permissions on this connection.

Target was the name of my connection.

View 1 Replies View Related

SSPI Context Error Message

Oct 3, 2007

Hai,
I'm having Windows XP SP2 version and I have installed SQL server 2005. Whenever I'm opening SQL server management studio in Windows Authentication Mode I get a pop message indicating that "SSPI context error message". What may be the problem and how to sort it out?

Narayanamoorthy

View 1 Replies View Related

SSPI Context Error Message

Oct 5, 2007

Hai,
I usually connect SQL Server 2005 using Windows authentication mode (trusted connection). I have one server to which four client machines are connected and all the clients are windows XP SP2. The SQL Server 2005 I have installed is Standard Edition. When I'm connecting I get a pop message indicating that "SSPI context error message". I have seen the Troubleshooting Article ID : 811889. I was'nt able to resolve it. What may be the problem and how to sort it out ?

Narayanamoorthy

View 3 Replies View Related

SSPI Context Error Message

Jul 25, 2007

Hai,

I usually connect SQL Server 2005 using Windows authentication mode (trusted connection). I have one server to which four client machines are connected and all the clients are windows XP SP2. The SQL Server 2005 I have installed is Standard Edition. When I'm connecting I get a pop message indicating that "SSPI context error message". I have seen the Troubleshooting Article ID : 811889. I was'nt able to resolve it. What may be the problem and how to sort it out ?

View 3 Replies View Related

SSPI Context / [DBNETLIB][ConnectionRead (recv()).] General Network Error

Dec 28, 2006

Hello together,


since over a week I've been looking to
find out the reason for two error messages I get from our users and
servers, unfortunately without success up to now.



I really hope you can help me.



We are using Win 2k servers with active directory and SQL Server 2000,
clients are all Win XP with SP2. Versions of access are 2002 &
2003. The errors are userspecific and occur in both versions. The
SQL-Servers are accessed with an adp-file in 2002-format.



We have one usergroup which is member of specially many groups. This
affects the size of their windows access token which becomes constantly
larger. In order to enable those users to still access their mailboxes
on our Exchange servers, the DWORD entry "MaxTokenSize" with the
decimal value "65535" was made to the newly created key "Parameters" of
their registry branch
"HKLMSYSTEMCurrentControlSetControlLsaKerberos ".



Since then those users can not access any of our SQL Servers using the
windows authentification. One of them gets the error
"[DBNETLIB][ConnectionRead(recv().] General network error. Check your
network documentation.", the others the error "Check connection:
Failed: Cannot generate SSPI context".



In case of resetting the registry entries (by deleting them), the one
user receives the same error message as the rest while it doesn't make
any difference to those (but at least they can't connect to their
mailboxes).



After having researched the web, I realised in one of the SQL-Servers
logfiles the entry "Invalid buffer received from client.." which lead
me to start to believe it could have to do something with the kerberos
encryption in the first place. Therefore I asked if changes to the
tokensize had been made. I applied the change with "EXEC sp_configure
'network packet size', 65535 RECONFIGURE" on our testsystem and "EXEC
sp_configure" confirms that the value is run.



Consequence: The entry in the SQL Server log doesn't appear any longer, but the users still receive their error messages.





Do you have any hints?



Your comments will be highly appreciated!



Regards,

caracol

View 10 Replies View Related

IP Works But Not Named Pipes, Connecting To SQL 2005 (SQL Auth)

Jul 29, 2007

I have SQL 2005 Std Edition, Mixed Security, and remotely connecting by TCP/IP works great.

Named Pipes (and the SQL Native Client) is the only issue.


The problem _appears_ to be that I'm not authenticated under the SQL Machine; however, I'm not attempting to use Windows Authentication, I'm strictly using SQL, so I do not understand why I'm having a problem.


My reasoning for the above conclusion, is that the command "net use \[server_name]ipc$" will allow me to connect to the server, and Named Pipes will begin working. Again, remember that I'm only trying to access named pipes using SQL Authentication.


I've read through everything on the forum and tried everything I could find. Below are the answers from the most common suggestions posted here:

------------------------------------------------------------------------
Version: SQL Server 2005 - 9.00.1399.06 (Intel X86)
This is the Default & Only Instance of SQL 2005, named: MSSQLSERVER
------------------------------------------------------------------------

1. The error message with the SQL Native driver (v 9.00.3042):
Error 1326, SQL State 08001
[Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [1326]


2. The error messgae with the ODBC SQL driver (v 03.85.1117):

Error 1326, SQL State 01000
[Microsoft][ODBC SQL Server Driver][Named Pipes]Connection Open (Connect())

Connection Failed: SQL Error 17, State 08001
[Microsoft][ODBC SQL Server Driver][Named Pipes]SQL Server does not exist or access denied.


3. Local Connection on Win2003 Server works fine for IP & Named Pipes


4. Remote Connection using SQL Authentication
WORKS for IP, does not work for Named Pipes


5. Absolutely *no firewalls* or blocked ports are being used on either machine


6. Configuration Manager & Surface Area Config -- both enabled TCP/IP & Named Pipes
Currently listening on ALL IP's. The LOG reports:

Server is listening on [ 'any' <ipv4> 1433].
Server named pipe provider is ready to accept connection on [ \.pipesqlquery ].
Server is listening on [ 127.0.0.1 <ipv4> 1434].
Dedicated admin connection support was established for listening locally on port 1434.


7. Can telnet to server on 1433


8. Status of NETSTAT on server:

C:...>netstat -ano|findstr 1433
TCP 0.0.0.0:1433 0.0.0.0:0 LISTENING 656
C:...>netstat -ano|findstr 1434
TCP 127.0.0.1:1434 0.0.0.0:0 LISTENING 656
UDP 0.0.0.0:1434 *:* 2544


9. Tried both named instance and unnamed instance (although I'm not sure
if I'm passing the 'named' instance properly):

Tested: \MYSERVERpipesqlquery
Tested: \MYSERVERpipeMSSQL$MSSQLSERVERsqlquery
(although the named instance doesn't work on the server either)


10.I've setup an alias for the named pipe connection. This was based on a suggestion
posted here, but didn't work.


11.I've removed the shared-memory protocol, on another suggestion here, but no luck.


12.If I execute "net use \[server_name]ipc$" it asks for credentials and if I
enter the server credentials I have no problem with executing that command.
In other words the logged-on user is not an authenticated member of the server;
however, I'm not attempting to use windows authentication, I'm using
SQL Authentication.

------------------------------------------------------------------------

Thank you in advance for any suggestions,
Rusten

View 5 Replies View Related

Using Windows Auth In SQL 2005 Mgmt Studio

Feb 22, 2006

Is there any way to provide 'Windows' credentials to connect the Management Studio to a remote SQL 2000 DB when I am not logged on as that user (on the dev machine where I am running Mgmt Studio)?

I do of course have local machine admin rights via an AD domain account added to the machine administrators on the remote SQL box itself.



View 1 Replies View Related

Clean Install Windows Auth Error

Feb 17, 2007

Hi,

I cannot log in to SQL Server 2005 Dev Edition in my local machine using Windows Authentication. The server returned "Login failed..." when connecting with SQL Server Management Studio.

I have not change anything since installation of this server.

This problem happens in RTM and SP1 versions, both running on Windows Vista RTM.

Anyone having this kind of problem too? Any solution? I'm guessing it's Vista-related.

View 1 Replies View Related

SQL Server 7 Switches To Windows Only Auth On Reboot

Jul 20, 2005

Hi All,I have a SQL Server 7 installation running on a windows 2000 server.SQL Server switches from mixed mode authentication to Windows Only onreboot. Has anyone else experienced this? Any help would be greatlyappreciated.Service Pack Reports:Microsoft SQL Server 7.00 - 7.00.1077 (Intel X86) Sep 6 200215:10:15 Copyright (c) 1988-2002 Microsoft Corporation StandardEdition on Windows NT 5.0 (Build 2195: Service Pack 3)I only see two strange entries in the log:2004-05-01 00:38:09.55 spid37 Using 'xpsqlbot.dll' version'1998.11.13' to execute extended stored procedure 'xp_qv'.2004-05-01 00:38:01.71 spid1 Failed to obtainTransactionDispenserInterface: Result Code = 0x8004d01bI don't believe that either of these are related to the configurationoption for Windows Only, though.

View 2 Replies View Related

SQL Server Windows Auth For ETL Called By CreateProcessAsUser

May 11, 2007

Hi,

We are having problems in our project. We have ETL packages we call from our web app that we want to run and the user is the logged in one in the web.

We use Windows Authentication in our web app and we used the CreateProcessAsUser to impersonate the user. <identity impersonate="true"/> is also in our web.config.

We were able to call the dtexec successfully (with the user for the process as the logged in the web -- thus impersonation was successful.)

But, a problem arises when we use Windows Authentication for the connection of the ETL to the db (SQL Server). When we run the ETL on our local machine using dtexec/dtexecui, it works fine.

But when we ran it in our server, it fails. According to the event logs, it can't connect to the db server even though impersonation is successful.

Btw, the client, web server, db server are three different machines.

Any help is appreciated. Thanks!

View 7 Replies View Related

Cannont Create SSPI Context (SQL Connection Problem After 30 Minutes)

Dec 3, 2005

It makes no difference if I'm working with Enterprise Manager, QueryAnalyzer, Access, self written app with OleDb or Visual studio 2003builtin DB manager.Everything is fine but aufter some time - about 30 minutes I getmessage "cannot create SSPI context"After rebooting my machine I can work for another few minutes.Configuration:NB01 is my notebook with Windows XP ProSQL01 is another Windows XP Pro machine with SQL Server 2000 desktopDC01 is the domain controllerall machins within the same domain DOMAIN01The user is a domain admin and has every rightI'v seen some postings for this problem but not one useful idea how toresolve.As it runs perfectly for some time I don't thint it is a DNS problem orsomething like this.As there is no useful error message it must be some kind of bug.Has anybody resolved such a problem?

View 3 Replies View Related

Windows Mobile 5 Connecting To SQL Server 2005

Jan 30, 2006

Can't get winmobile 5 to connect to my sql server 2005 (using vs2005). Here's the connect string:

"Data Source=tcp:XXXXXXdefault,1433;Database=YYYYYY;" _
& "Integrated Security=SSPI;"

This very same string, and variations of it, work in a vs2005 winforms app, but not a windows mobile 5. I'm (obviously) using system.data.sqlclient. MS documentation says it's supported on both platforms with no syntax changes. Any suggestions?

View 11 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved