[x]
Posted via EE Mobile

Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.
Question
[x]
Attachment Details

Confirming SQL Express 2008 installation

Asked by jxm2 in SQL Server 2008

Hi,

I'm trying to confirm the SQL 2008 Express is correctly installed on my 2003 DC (my application can't connect to it, so I need to know if it's sql or the app that's causing the problem)

I'm trying to test this using "osql /Uaccount /Sserver\instance" but I can't seem to login - it prompts me for a password then just says login failed when I type it in.

At first I was trying the sa account, but after googling around it seems that this is disabled by default because I'm using the default setting of "Windows authentication".

So I've also tried using the administrator account "login failed for user administrator", and also the sql account I set up during the sql installation process but that fails as well.

So which account am I supposed to use for this???  Just testing the stupid thing works seems like it should just be a simple thing to do...

Just a thought: as this is a DC I had to create a user account manually for SQL to use.  I assumed that when I provided this account during the setup that the SQL install would then assign that user account all of the permissions and group memberships required.  Would I be correct in think that?  I've changed the password on the account and tried the above again but I just can't see to get osql to connect no matter what account I try...
[+][-]11/07/09 05:42 AM, ID: 25766286Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/07/09 06:24 AM, ID: 25766415Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11/07/09 06:30 AM, ID: 25766430Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/07/09 06:32 AM, ID: 25766438Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/07/09 06:32 AM, ID: 25766439Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11/07/09 06:35 AM, ID: 25766448Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11/07/09 06:44 AM, ID: 25766482Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/07/09 07:58 AM, ID: 25766734Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11/07/09 10:26 PM, ID: 25769598Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20091111-EE-VQP-89 - Hierarchy / EE_QW_3_20080625