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 |
|
sunjain
Starting Member
1 Post |
 Posted - 2008-06-20 : 06:59:29
|
| Hi I am new to this forum . I am running through few problems for sqlserver account settings . I) My registery key entry for MSSQLserver just has a client folder . 2) My sql server configuration manager just has sqlserver 2005 services , native client configuration and 2005 network configuration. I can't see any server name or databases under it. 3)I normally work on EMS lite so I can see my ./SQLEXPRESS as server and databases under it and i can create logins etc ..I assigned db_owner role to one of my recent created database. but when I try to connect it says : The user is not associated with sqlserver connection.5) i have sqlserver express service running, vss and sql server browser running. I googled and searched for the solution and it says the authentication mode should be turned to mix mode form win authentication.But from where. Have i missed some installation .I am able to connect to my other database from EMS.Please help me out. Thanks in advance SJ |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-20 : 23:58:36
|
| 1. You don't have to do anything in registry.2. Did you see sql server service and other services in it? You have to manage db in ssms.3. Did you create standard or trusted sql login? Did you login sql with windows or sql authentication?5. Set authentication model in sql server management studio (ssms), you can down load ssmse for sqlexpress from Microsoft. |
 |
|
|
|
|
|
/SQLEXPRESS