January 23, 2011 at 11:56 pm
Hi all,
I am a newbie and I started facing this problem last night and ever since I was trying various methods described on web but no luck yet.
I was trying to import a 4GB csv file into SQL and it gave me this error:
===================================
===================================
Cannot generate SSPI context
SQL Server Network Interfaces: The Local Security Authority cannot be contacted (Microsoft SQL Server Native Client 10.0)
------------------------------
Program Location:
at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OleDb.OleDbConnection.Open()
at Microsoft.SqlServer.Dts.DtsWizard.DTSWizard.GetOpenedConnection(WizardInputs wizardInputs, String connEntryName)
at Microsoft.SqlServer.Dts.DtsWizard.Step2.OnLeavePage(LeavePageEventArgs e)
I have no clue what this error means. I have done re-install 10 times and spent the whole day trying to overcome this error. Tried to install flavors of SQL Express, SQL Developer, SQL Enterprise!
Also, I am not able to connect to my old dB's (.mdf and .ldf). I just need to import flat files and I can easily build my old dB's.
OS: XP SP3, SQL Server Express R2 (240 MB version). My Servername: <computer_name>\<sqlexpress0124>, TCP/IP enabled, Order 2 in Client protocols (tried at order 3 but no luck).
Any help in this regard is greatly appreciated.
Thanks a lot!!
January 24, 2011 at 12:02 am
Can u please let me know which method are u using to import the file into database.
Also what type of rights does the user have on the system as well as database level which is trying to connect to the database.
Satnam
January 24, 2011 at 6:09 am
I am using the GUI method: Right Click Databases - Attach etc.
While installing I added myself as admin .. is there a way to check out my user privileges?
Thanks!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply