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 |
|
Sun Foster
Aged Yak Warrior
515 Posts |
 Posted - 2010-03-09 : 14:22:00
|
| In SQL 2008 express, what account and password for SQL authentication?I used sa but no luck. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Sun Foster
Aged Yak Warrior
515 Posts |
Posted - 2010-03-10 : 11:26:58
|
| When it was installed, I used default account "NT AUTHORITY\SYSTEM" but did not prompt for password. |
 |
|
|
Sun Foster
Aged Yak Warrior
515 Posts |
Posted - 2010-03-10 : 11:36:34
|
| I used "Windows Authentication", there is an error but let me connect to:...sqlserver.management.dmf.policystore threw an exception...the system cannot find the file specified. (Microsoft.sqlserver.dmf)If I used sa, ther is an error but did not let me connect to |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2010-03-10 : 14:41:53
|
quote:
Originally posted by Sun Foster
When it was installed, I used default account "NT AUTHORITY\SYSTEM" but did not prompt for password.
You are referring to the service account screen in the installer. There is another screen where it asks you what authentication types to use. Windows only is the default selected. I always enable the option to also use SQL authentication. You can change this after the installer is done by connecting with your Windows admin account and changing the security options (right click on the server, properties, security).I am not familiar with the error you are getting with Windows auth.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
|
|
|
Sun Foster
Aged Yak Warrior
515 Posts |
Posted - 2010-03-10 : 16:34:26
|
| Here is error:TITLE: Microsoft SQL Server Management Studio------------------------------The type initializer for 'Microsoft.SqlServer.Management.Dmf.PolicyStore' threw an exception. (Microsoft.SqlServer.Dmf)------------------------------ADDITIONAL INFORMATION:Could not load file or assembly 'Microsoft.SqlServer.Diagnostics.STrace, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. (Microsoft.SqlServer.Dmf) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Sun Foster
Aged Yak Warrior
515 Posts |
Posted - 2010-03-11 : 15:48:11
|
| I uninstalled and reinstalled SQL 2008 express without any error but no luck once connect to. |
|
|
|
|
|
|
|
|
What account for SQL authentication mode?