I'm having a time with SQL Server 2008. If only they'd let me use MySQL
So, using the example right from Microsoft http://msdn.microsoft.com/en-us/library/aa342339.aspx
, I have tried to get a sample database "s" to connect.
I know that it works on my machine because I'm running SQL Server Management Studio and that's where I created the database "s".
When I log into SQL Server Management Studio, I do something like this:
Server name: SomeServerName
Authentication: Windows Authentication
User name: (not enabled) computerName\name
Password: (not enabled) nothing_just_whitespace
So, with that, I try to connect using JDBC by using the following connection string:
In which case, I get
- I've tried it without "Windows Authentication" but with a user and have also left both out. Neither case works.
Again, I appreciate your help.