Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Newbie Question
Message
General information
Forum:
Microsoft SQL Server
Category:
Installation
Title:
Miscellaneous
Thread ID:
00947367
Message ID:
00947798
Views:
24
Ok, I tried the Mixed Mode, adn it failed. The error is:
SQL_Latin1_General_CP1_CI_AS

-m -Q -T4022 -T3659

Connecting to Server ...

driver={sql server};server=MAROIS1;UID=sa;PWD=;database=master

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'.

driver={sql server};server=MAROIS1;UID=sa;PWD=;database=master

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'.

driver={sql server};server=MAROIS1;UID=sa;PWD=;database=master

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'.

SQL Server configuration failed.
I'v got no idea what's going on. Your help is greatly appreciated.
Kevin




>Kevin,
>
>See in-line
>
>>I'm on WinXp Home. Is there even an Administrator acount?. I set up
>>the users on this PC, with me as admin.
>
>I've no idea.
>
>>I used Windows authentication when I installed SQL Server. This should
>>allow SQL to login using the Windows logon info, correct?
>
>Yes it should.
>
>
>>In the SQL Server Service Manager, there are 2 servers; one named
>>after the PC name (MAROIS1) and another with the instance name I gave
>>it MAROIS\SQLSERVER1.
>>
>>MAROIS1 is running, but when I try to start the other, I get the mesage
>>'The service did not start due to a logon error'
>
>Did you install two instanes?
>
>>
>>Should I have used Sql Server authentication? If so, what do I need to
>>do set it that way?
>
>It's good idea to have dev. SQL Server set up for Mixed mode authentication so you can troubleshoot login problems.
>
>I would uninstall SQL Server and start over. This time install default instance only and apply SP3. After you get comfortable with SQL Server, you can play with instances.
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform