I'm trying to create my first DB connection via the wizard, but I can't seem to connect.
SQL Server is running locally on my laptop; Open Profiler is also installed on my laptop.
My computer name is 'Carl-THINK'
The instance name is 'SQLExpress'
SQL Server is running in mixed authentication mode and the 'sa' account is enabled.
I'm not sure how to determine what port number the instance is running on?
I'm trying to connect to the 'AdventureWorks2008R2' database.
Please help... thanks,
Additional parameters: instance=SQLEXPRESS
I have created the db 'Talend' in SQL SERVER Management Studio. Port is enabled in TCP/IP and is 1433. What else do I need to do?
I am getting an error: Connection failure. You must change the database settings. Server 'Khyati' has no instance named 'SQLEXPRESS'.