ttreqop.blogg.se

How Should SQL Server verify authenticity?Ĭhoose how you want to connect to db Windows integrated or SQL server (if SQL Server then add user parameters eg user= sa pass=' *')Ĭhange default database to AdvetureWorks2008 -> Next 'dont touch anything here unless.-> and click Finish -> click on Test Data Source -> OK Server: "SQL Server Name" from drop down box example: (local) or SQL Server name initially specified during setup->

Start Button -> Setting -> Control Panel -> Admin Tools -> Data Sources (ODBC)Īfter opening the ODBC Data Source Administrator if not on then go to -User DSN- tabĬlick Add -> Choose SQL Server Native Client 10.0 -> I am not sure if ODBC driver is installed with SQL Server or native to Windows or you have to install it separately. If the value of Listen All is no, the TCP/IP port number for this instance of SQL Server 2005 is the value of the TCP Dynamic Ports item for a specific IP address. If the value of Listen All is yes, the TCP/IP port number for this instance of SQL Server 2005 is the value of the TCP Dynamic Ports item under IPAll. On the Protocol tab, notice the value of the Listen All item.Click Protocols for InstanceName, and then make sure TCP/IP is enabled in the right panel and double-click TCP/IP.Open SQL Server Configuration Manager, and then expand SQL Server 2005 Network Configuration.Make sure that 1433 port is set in SQL Server. JDBC URL: jdbc:sqlserver://testServer\SQLEXPRESS/Databases/testDB:1433 user=sa password=pass ĭriver Class: .SQLServerDriverĪlso I added sqljdbc4.jar in Prefrences.