Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pssheba
Yak Posting Veteran
95 Posts |
 Posted - 2010-02-06 : 14:41:47
|
| Hi everyone,In order to transfer data from an excel sheet to an OLE DB table i createda new project, dragged an excel source tool to the Data flow board, assigned an OLE DB Destination behind it and connected it with a green arrow.From right click menu on: "Data sources" i selected "New Data Source".At "Data Source" wizard i selected "New", "Server Name" i selected:"myServer" then i selected: "Use SQL Server Authentication", "sa","myPassword" and "Test Connection".The error message i get says:"An error has occured while establishing a connection a connection toSQL Server 2005, this failure may be caused by the fact that under thedefault settings SQL Server does not allow remote connections."Could anyone help me in creating connection in SSIS project ? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
pssheba
Yak Posting Veteran
95 Posts |
Posted - 2010-02-07 : 16:23:55
|
[quote]Originally posted by tkizer
To resolve that error, check this out: http://weblogs.sqlteam.com/tarad/archive/2008/05/23/60609.aspxHi Tara Kizer,I tried to do act according the instruction at your links and now a more terrible thing happened: I cannot log to SSMS. I open SQL Server SurfaceArea Configuration For Services and Connections to find that Database Engine service is stopped ! I click: "Start" and get an error message that says: "An error occured while performing this operation" .Can you helpe with this ?Thanks |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
pssheba
Yak Posting Veteran
95 Posts |
Posted - 2010-02-08 : 04:00:23
|
quote:
Originally posted by tkizer
Check the Application Log in Event Viewer for the reason why the service won't start.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong."
This is what i got in the "errorlog" file:Error: 17182, Severity: 16, State: 1.2010-02-08 08:53:35.89 Server TDSSNIClient initialization failed with error 0x7e, status code 0x60.2010-02-08 08:53:35.89 Server Error: 17182, Severity: 16, State: 1.2010-02-08 08:53:35.89 Server TDSSNIClient initialization failed with error 0x7e, status code 0x1.2010-02-08 08:53:35.89 Server Error: 17826, Severity: 18, State: 3.2010-02-08 08:53:35.89 Server Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.2010-02-08 08:53:35.89 Server Error: 17120, Severity: 16, State: 1.2010-02-08 08:53:35.89 Server SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.'l |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
pssheba
Yak Posting Veteran
95 Posts |
Posted - 2010-02-09 : 06:17:47
|
| Where can i get it ? |
|
|
|
|
|
|
|
|
Connection manager, test connection button creates