Sha256: e4d980b2469fde840585ce24a40a575c5e9f894a0700701c7ee65a95ccf0e63f
Contents?: true
Size: 1.26 KB
Versions: 19
Compression:
Stored size: 1.26 KB
Contents
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`.
Version data entries
19 entries across 19 versions & 2 rubygems