Trouble logging in to SQL2008

views:

123

answers:

Trouble logging in to SQL2008

I recently installed SQL2008 and am having trouble logging in from another application. I have set the security to shared authentication and have specified a password for the SA login. I am able to log in using SA and password from the management studio and also from command prompt using the osql command, but when trying to log in from third party software (specifically, WhereNet VSS) I get the popup "The SQL Instance Name or login information is not correct. Please try again."

Any suggestions? Unfortunately I cannot install the software until I can successfully log in to the SQL server so it is critical that I get past this ASAP.

Thanks,

Joseph

Did you enable remote connections to your SQL Svr instance (see Server Properties, Connections)? Also, make sure the Windows (or proprietary) firewall isn't interfering w/ connectivity.

Garrett 2009-05-13 12:42:57

Yes, shared pipes and TCP/IP have been enabled. I also made sure that the IP addresses (In TCP/IP properties) were enabled and active.I have disabled all firewalls (and disconnected from internet) but still cannot connect from software. And let me clarify, the Software is installed on the Server Machine.

Joseph 2009-05-13 13:36:11

Any change if you use the IP addr instead of the host name?? (Grasping for straws...)

Garrett 2009-05-13 20:18:33

I tried that, but no such luck. Thanks for the suggestion.

Joseph 2009-05-14 14:26:40

+1 A:

Other than allowing remote connections from SQL Server Instance properties --> connections - did you configure remote connections from SQL Server Surface Area Configuration tool? If not you might wanna play with those options to enable remote connections over TCP/IP and/or named pipes.

Also - did you check from the Configuration Manager Tool if TCP/IP properties are properly configured (TCP port properly set, etc.)

Did you try to do the same stuff on another machine and see if with the same settings it works?

JohnIdol 2009-05-13 21:45:49

TCP\IP and Named pipes have been enabled through the SQL server configuration manager. (There is no SQL Server Surface Area Configuration in SQL 2008).

Joseph 2009-05-14 14:47:48

Also tried using SQL2005 but same problems. I did use Surface Area configuration and enabled all appropriate remote connections, but still nothing.

Joseph 2009-05-14 15:03:34

it is puzzling - did you try same setting on different machine? We also have a machine at work with the same problem that we cannot quite figure out - we kinda gave up!

JohnIdol 2009-05-15 20:39:55

ansaurus

tags:

views:

answers:

Trouble logging in to SQL2008

related questions