Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gold1384
Starting Member
1 Post |
 Posted - 2009-05-13 : 10:03:33
|
| 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 |
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2009-05-22 : 17:54:05
|
| It sounds as if the server setting in your software is incorrect. Try specifiying your sql server by ip :port instead of name.Are these on the same system? |
 |
|
|
iesoccer
Starting Member
3 Posts |
Posted - 2009-05-29 : 15:07:29
|
| Setting security to shared is not enough. Make sure that the server security settings allow remote connections.Also, use the configuration tool and make sure that TCP/IP and/or named pipes is enabled. |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2009-05-29 : 15:33:34
|
| If you are installing the application on a Windows 2008 server, you may need to poke a hole in the local firewall, to connect to SQL Server. |
|
|
|
|
|
|
sa account trouble