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 |
|
noctufaber
Starting Member
2 Posts |
 Posted - 2010-02-09 : 17:31:39
|
| I'm having trouble getting my software connected to my customer's SQL server. I'm getting the following error message:"Login failed for ComputerName/Administrator". My connection string is:"Data Source=ComputerName; User ID=MyUser; Password=MyPassword; Initial Catalog=eViewWork; Trusted_Connection=no; integrated security=sspi;"I was able to get this string to work on my development server (Windows 2003 Server running SQL 2008), but I get the Login failed error at my customer's location. I googled this error message but I couldn't find anything with an error that had the local computer name in it. The other weird thing is my User ID is not the Administrator account on the local machine. Any help would be greatly appreciated. I'm new at this and I'm used not used to the level of complexity I'm finding in this area of connecting to SQL. |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-10 : 01:42:59
|
Trusted_Connection=noandintegrated security=sspi;are mutually exclusive, it looks like the connection is using Trusted / Integrated security, which you don't want if you are using a UserID + Password.I presume the SQL box is set up with Mixed Security to allow SQL LoginsTry"Data Source=ComputerName; User ID=MyUser; Password=MyPassword; Initial Catalog=eViewWork; Trusted_Connection=false; no; integrated security=sspi;"if that fails have a look atwww.connectionstrings.com |
 |
|
|
noctufaber
Starting Member
2 Posts |
Posted - 2010-02-10 : 12:10:13
|
| That was it. I'm now connected. Thanks for your help. |
|
|
|
|
|
|
Connection problem