April 20, 2009 at 3:47 pm
I have stood up a LANDesk test server (offline) installed the management suite, took note of the SA logon and password, installed SQL 2005 as the DB but when I try to connect I get
"login failed for SA account invalid connection string attribute" Any Ideas...Anybody
April 20, 2009 at 3:59 pm
When you installed SQL Server, did you change from Windows Authentication only to both SQL and Windows authentication?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 20, 2009 at 4:07 pm
I can log on with either Windows Authentication or SQL Server Authentication. Did not see a setting for both. LANDesk must use a SQL account to access the database.
I have created double frustration, installing LANDesk and SQL.
April 20, 2009 at 5:11 pm
FlyFish-N-Lady (4/20/2009)
I can log on with either Windows Authentication or SQL Server Authentication. Did not see a setting for both. LANDesk must use a SQL account to access the database.I have created double frustration, installing LANDesk and SQL.
When you say you can connect using either Windows or SQL authentication - what does that mean? Are you able to connect to that instance of SQL Server using SSMS - and can connect using either Windows Authentication or SQL Authentication?
If so, then what is the username you are using to connect with?
You stated you couldn't connect using the SA account - which means either the password is incorrect (usually tells you invalid password), or the account is not enabled. The SA account is not enabled when you installed SQL Server by default. You have to select that option when you install SQL Server.
If you can connect to SQL Server using SSMS - right click on the server in Object Explorer, select properties and go to the Security page. The top of the page should show what server authentication is selected.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 20, 2009 at 5:19 pm
I was not clear.
I can log into SSMS and I do have SQL Server and Windows Authentication mode selected. So I am thinking this is a LANDesk issue. Thanks for your answers
April 21, 2009 at 1:12 pm
Is there any other sysadmin account using which you can login thru management studio?
MJ
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply