topic Re: Struggling to connect to a SQL Server 2008 R2 Express named instance in Talend Studio

Struggling to connect to a SQL Server 2008 R2 Express named instance

Anonymous — Sat, 16 Nov 2024 12:37:50 GMT

Hi there,
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,
Carl

Re: Struggling to connect to a SQL Server 2008 R2 Express named instance

_AnonymousUser — Tue, 11 Oct 2011 08:08:31 GMT

You need to give scrreenshot of settings you enter via DB connection wizard.
To get port number of your sql server you can use sql server configuration manager -->protocols for sqlexpress->TCP/TP. This gives you ports and ip address. But you need to share what inputs you are giving to various fields in wizard to get a clear picture of what is going wrong

Re: Struggling to connect to a SQL Server 2008 R2 Express named instance

Anonymous — Tue, 11 Oct 2011 11:46:58 GMT

thnx... pix attached

Re: Struggling to connect to a SQL Server 2008 R2 Express named instance

Anonymous — Tue, 08 Nov 2011 11:06:39 GMT

Hi,
You can follow steps given below to resolve issue
a) Through SQL server configuration manager ?Enable? the SQL Server Network Configurations and SQL Native Client 10.0 Configuration. See to that all the protocols are enabled except VIA.
b) Open SQL Server Management studio and right click ? properties on Database Connection. This will open properties window. Enable mixed mode authentication mode as shown in the figure below.
c) Go to Security ? Logins ? sa user and change the password for user sa.
d) Restart SQL Server Service and verify for the access
e) Create a new database connection in Metadata and enter required details
f) If you want to use another database user, and then add a user in sql server, assign a new password.
Default port is 1433
Thanks
Vaibhav

Re: Struggling to connect to a SQL Server 2008 R2 Express named instance

_AnonymousUser — Tue, 06 Dec 2011 14:46:27 GMT

not working for me. tried both 32 and 64 bit (working on 64 bit machine).
accessing SQL server through management studio with the given user does work.
So must be a glitch in the connection....
tried the jdbc and odbc connection, still no luck.

Re: Struggling to connect to a SQL Server 2008 R2 Express named instance

Anonymous — Tue, 06 Dec 2011 15:17:04 GMT

You must specify the instance name of the Microsoft SQL Server in your database component.
in Additional Parameters put instance=SQLExpress

Re: Struggling to connect to a SQL Server 2008 R2 Express named instance

_AnonymousUser — Fri, 10 Apr 2015 04:47:59 GMT

I put:
Username: sa
password: ****
Server: Khyati
Port: 1433
DA: Talend
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'.

Re: Struggling to connect to a SQL Server 2008 R2 Express named instance

_AnonymousUser — Thu, 16 Apr 2015 16:17:51 GMT

Does anyone know the solution to the above query? I could successfully activate the SQL Server Browser and login on SQL Server database through SQLExpress. Please let me know what else do I need to change.
Thanks
Khyati

Re: Struggling to connect to a SQL Server 2008 R2 Express named instance

kusumy — Tue, 13 Oct 2015 09:46:53 GMT

I put:
Username: sa
password: ****
Server: Khyati
Port: 1433
DA: Talend
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'.

This solution works for me. Thank You.
@Khyati -> Maybe you should IP Address instead computer name

Re: Struggling to connect to a SQL Server 2008 R2 Express named instance

_AnonymousUser — Wed, 02 Nov 2016 12:23:44 GMT

Make sure to enable "TCP/IP" protocol under SQL Server Network Configuration.

Re: Struggling to connect to a SQL Server 2008 R2 Express named instance

Pooja_kataria — Thu, 15 Mar 2018 07:21:09 GMT

This helped me thanks !