sql-serverimportexportwindows-authentication
SqlServer import export Wizard - Set destination to Windows Authentication
i couldn't fine the connection string to set to windows authentication to carry out my import operation.. help me to set connection string, i know how to set the connection for sql server ,but not using windows authentication
Solution
It sounds like your trying to use the .Net Framework Data Provider for ODBC as your data source.
Instead change the data source to SQL Server Native Client. Then you will have the option to use Windows Authentication rather than trying to create an exact connection string.
- How to use PERCENTILE_CONT without over clause? any alternative to it?
- SQL count occurrences based on values in other columns
- SSIS Error: External Column for Source out of sync with Data Source columns; How do I remove External Columns?
- Linq how to select only a small subset of a large result set?
- Finding RDBMS table relationships using SqlConnection schemas
- TSQL Calculate week number of the month
- "The certificate chain was issued by an authority that is not trusted" when connecting DB in VM Role from Azure website
- How to connect a microsoft SQL Server database to Open Data Discovery (odd-odd-platform)?
- SSIS tasks are getting fail with Communication link failure error
- Cause of SSIS Custom Dataflow Component Error - Cannot be upgraded
- SQL Server 2016 DB_CHAINING with Views
- Find values that are 6 characters long in a string, pipe delimited
- ThreadAbortException out of nowhere
- SQL Query to get latest price
- Order By In a SQL Table Valued Function
- How to work with SQL Server table dependency with ASP.NET Core
- SSIS Package Stuck in "Pending Execution" status
- Split a string with no delimiters into columns
- MSSQL 2008 R2 Selecting rows withing certain range - Paging - What is the best way
- No selection to install SSIS, SSRS and SSAS
- SQL Server INSERT into huge table is slow
- How to export SSRS report directly to csv without rendering
- SQLdevelopersfruit puzzle
- Bacpac vs dacpac for migrating database to Azure
- Return total records from SQL Server when using ROW_NUMBER
- Caching paged LINQ results without using Skip() or Take()
- Paging results from a complex SQL Server query
- does snapshot isolation level protects from Phantom read?
- Sql Server ldf files growing very fast
- T-SQL SELECT DISTINCT & ROW_NUMBER() OVER Ordering Problem