CONNECTING.markdown

CONNECTING

Various notes (needs to be cleaned-up).

See:

• http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx
• http://blogs.msdn.com/b/bethmassi/archive/2008/09/17/enabling-remote-sql-express-2008-network-connections-on-vista.aspx

Example Setup

• In Visual Studio, click Server Explorer
• Right click Data Connections
• Create New SQL Server Database
• Server Name: YOURPCNAME\SQLEXPRESS
• Use Windows Authentication
• #Use SQL Server Authentication
• #User name: do_test
• #Password: do_test
• New database name: do_test

See: http://social.msdn.microsoft.com/Forums/en-US/Vsexpressinstall/thread/aaf2f68c-4a40-44c8-b7ee-b2f5d94e23c3

---

Tips

• Check the password is not required to be set on first connect.
• Test you can connect locally. Either through Visual Studio SQL Server tools, SQL Server Management Studio, or simply using telnet: telnet localhost 4322.
• Configure Firewall correctly: http://support.microsoft.com/kb/287932
• Specify an instance: in the DO URL append INSTANCE=SQLEXPRESS.
• You can not add the instance to the hostname, i.e. 192.168.2.110\SQLEXPRESS as the underlying jTDS driver needs a URL that looks like this: jdbc:jtds:sqlserver://192.168.2.110:1433/do_test;instance=SQLEXPRESS.