Hi

I have a question

1. if i use Import and export data(64bits), it use sqlclient of 64 bits, it is correct?

2. When I use tcp, port 6000 why if I don't put the port, I connect to sqlserver, if sqlbrowser is disable and the client protocol have the port default: 1433

Hello,

The default port 1433 is used by default instances, usually the instance that has the same name as the computer. Named instances use a dynamic port and you may need the SQL Server Browser service to connect to them unless you specify the port they are using at the time.

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

1. if i use Import and export data(64bits), it use sqlclient of 64 bits, it is correct?

2. When I use tcp, port 6000 why if I don't put the port, I connect to sqlserver, if sqlbrowser is disable and the client protocol have the port default: 1433

Import and export wizard works in 32 bit mode although SQL Server is 64 bit.

I guess when you dont put port its taking default post and connecting.